ManPageW Request(all)

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Request (all)

Description : View and work on all requests

Help : This Request window is used to view all available requests



Tab: Request

Description : Define Request

Help : The Request Tab defines any Request submitted by a Business Partner or internally.

Table Name  : R_Request

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Document No Document sequence number of the document The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

DocumentNo

NVARCHAR2(30)

String

Due type Status of the next action for this Request The Due Type indicates if this request is Due, Overdue or Scheduled. DueType

CHAR(1)

List

Request Type Type of request (e.g. Inquiry, Complaint, ..) Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc. R_RequestType_ID

NUMBER(10)

TableDir

Group Request Group Group of requests (e.g. version numbers, responsibility, ...) R_Group_ID

NUMBER(10)

TableDir

Category Request Category Category or Topic of the Request R_Category_ID

NUMBER(10)

TableDir

Related Request Related Request (Master Issue, ..) Request related to this request R_RequestRelated_ID

NUMBER(10)

Search

Status Request Status Status if the request (open, closed, investigating, ..) R_Status_ID

NUMBER(10)

TableDir

Resolution Request Resolution Resolution status (e.g. Fixed, Rejected, ..) R_Resolution_ID

NUMBER(10)

TableDir

Priority Indicates if this request is of a high, medium or low priority. The Priority indicates the importance of this request. Priority

CHAR(1)

List

User Importance Priority of the issue for the User PriorityUser

CHAR(1)

List

Summary Textual summary of this request The Summary allows free form text entry of a recap of this request. Summary

NVARCHAR2(2000)

Text

Confidentiality Type of Confidentiality ConfidentialType

CHAR(1)

List

Invoiced Is this invoiced? If selected, invoices are created IsInvoiced

CHAR(1)

YesNo

Escalated This request has been escalated The Escalated checkbox indicates that this request has been escalated or raised in importance. IsEscalated

CHAR(1)

YesNo

Self-Service This is a Self-Service entry or this entry can be changed via Self-Service Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. IsSelfService

CHAR(1)

YesNo

Sales Representative Sales Representative or Company Agent The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. SalesRep_ID

NUMBER(10)

Table

Role Responsibility Role The Role determines security and access a user who has this Role will have in the System. AD_Role_ID

NUMBER(10)

TableDir

Date next action Date that this request should be acted on The Date Next Action indicates the next scheduled date for an action to occur for this request. DateNextAction

DATE

DateTime

Entry Confidentiality Confidentiality of the individual entry ConfidentialTypeEntry

CHAR(1)

List

Standard Response Request Standard Response Text blocks to be copied into request response text R_StandardResponse_ID

NUMBER(10)

TableDir

Mail Template Text templates for mailings The Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).

So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.
For Multi-Lingual systems, the template is translated based on the Business Partner's language selection.

R_MailText_ID

NUMBER(10)

TableDir

Result Result of the action taken The Result indicates the result of any action taken on this request. Result

NVARCHAR2(2000)

Text

Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID

NUMBER(10)

TableDir

Quantity Used Quantity used for this event QtySpent

NUMBER

Quantity

Product Used Product/Resource/Service used in Request Invoicing uses the Product used. M_ProductSpent_ID

NUMBER(10)

Search

Quantity Invoiced Invoiced Quantity The Invoiced Quantity indicates the quantity of a product that have been invoiced. QtyInvoiced

NUMBER

Quantity

Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID

NUMBER(10)

Search

User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID

NUMBER(10)

TableDir

Project Financial Project A Project allows you to track and control internal or external activities. C_Project_ID

NUMBER(10)

TableDir

Asset Asset used internally or by customers An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. A_Asset_ID

NUMBER(10)

Search

Order Order The Order is a control document. The Order is complete when the quantity ordered is the same as the quantity shipped and invoiced. When you cloase an order, unshipped (backordered) quantities are cancelled. C_Order_ID

NUMBER(10)

Search

Invoice Invoice Identifier The Invoice Document. C_Invoice_ID

NUMBER(10)

Search

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Payment Payment identifier The Payment is a unique identifier of this payment. C_Payment_ID

NUMBER(10)

Search

Shipment/Receipt Material Shipment Document The Material Shipment / Receipt M_InOut_ID

NUMBER(10)

Search

RMA Return Material Authorization A Return Material Authorization may be required to accept returns and to create Credit Memos M_RMA_ID

NUMBER(10)

Search

Request Amount Amount associated with this request The Request Amount indicates any amount that is associated with this request. For example, a warranty amount or refund amount. RequestAmt

NUMBER

Amount

Campaign Marketing Campaign The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. C_Campaign_ID

NUMBER(10)

TableDir

Table Database Table information The Database Table provides the information of the table definition AD_Table_ID

NUMBER(10)

TableDir

Record ID Direct internal record ID The Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known. Record_ID

NUMBER(10)

Button

Date last action Date this request was last acted on The Date Last Action indicates that last time that the request was acted on. DateLastAction

DATE

DateTime

Last Alert Date when last alert were sent The last alert date is updated when a reminder email is sent DateLastAlert

DATE

DateTime

Last Result Result of last contact The Last Result identifies the result of the last contact made. LastResult

NVARCHAR2(2000)

String

Created Date this record was created The Created field indicates the date that this record was created. Created

DATE

DateTime

Created By User who created this records The Created By field indicates the user who created this record. CreatedBy

NUMBER(10)

Search

Updated Date this record was updated The Updated field indicates the date that this record was updated. Updated

DATE

DateTime

Updated By User who updated this records The Updated By field indicates the user who updated this record. UpdatedBy

NUMBER(10)

Table

Start Date First effective day (inclusive) The Start Date indicates the first or starting date StartDate

DATE

DateTime

Request Invoice The generated invoice for this request The optionally generated invoice for the request C_InvoiceRequest_ID

NUMBER(10)

Search

Close Date Close Date The Start Date indicates the last or final date CloseDate

DATE

DateTime

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo


Tab: Updates

Description : Request Updates

Help : Updates of the Request

Table Name  : R_RequestUpdate

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Request Request from a Business Partner or Prospect The Request identifies a unique request from a Business Partner or Prospect. R_Request_ID

NUMBER(10)

TableDir

Entry Confidentiality Confidentiality of the individual entry ConfidentialTypeEntry

CHAR(1)

List

Created Date this record was created The Created field indicates the date that this record was created. Created

DATE

DateTime

Created By User who created this records The Created By field indicates the user who created this record. CreatedBy

NUMBER(10)

Table

Result Result of the action taken The Result indicates the result of any action taken on this request. Result

NVARCHAR2(2000)

Memo

Quantity Used Quantity used for this event QtySpent

NUMBER

Quantity

Quantity Invoiced Invoiced Quantity The Invoiced Quantity indicates the quantity of a product that have been invoiced. QtyInvoiced

NUMBER

Quantity

Product Used Product/Resource/Service used in Request Invoicing uses the Product used. M_ProductSpent_ID

NUMBER(10)

Table


Tab: History

Description : Request History (Old Values)

Help : The History Tab displays changes of a Request. The data displayed are the OLD (changed from) values. The new data is in the request.

Table Name  : R_RequestAction

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Request Request from a Business Partner or Prospect The Request identifies a unique request from a Business Partner or Prospect. R_Request_ID

NUMBER(10)

TableDir

Created Date this record was created The Created field indicates the date that this record was created. Created

DATE

DateTime

Created By User who created this records The Created By field indicates the user who created this record. CreatedBy

NUMBER(10)

Table

Request Type Type of request (e.g. Inquiry, Complaint, ..) Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc. R_RequestType_ID

NUMBER(10)

TableDir

Group Request Group Group of requests (e.g. version numbers, responsibility, ...) R_Group_ID

NUMBER(10)

TableDir

Category Request Category Category or Topic of the Request R_Category_ID

NUMBER(10)

TableDir

Status Request Status Status if the request (open, closed, investigating, ..) R_Status_ID

NUMBER(10)

TableDir

Resolution Request Resolution Resolution status (e.g. Fixed, Rejected, ..) R_Resolution_ID

NUMBER(10)

TableDir

Priority Indicates if this request is of a high, medium or low priority. The Priority indicates the importance of this request. Priority

CHAR(1)

List

User Importance Priority of the issue for the User PriorityUser

CHAR(1)

List

Summary Textual summary of this request The Summary allows free form text entry of a recap of this request. Summary

NVARCHAR2(2000)

Text

Confidentiality Type of Confidentiality ConfidentialType

CHAR(1)

List

Invoiced Is this invoiced? If selected, invoices are created IsInvoiced

CHAR(1)

List

Escalated This request has been escalated The Escalated checkbox indicates that this request has been escalated or raised in importance. IsEscalated

CHAR(1)

List

Self-Service This is a Self-Service entry or this entry can be changed via Self-Service Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. IsSelfService

CHAR(1)

List

Sales Representative Sales Representative or Company Agent The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. SalesRep_ID

NUMBER(10)

Search

Role Responsibility Role The Role determines security and access a user who has this Role will have in the System. AD_Role_ID

NUMBER(10)

TableDir

Date next action Date that this request should be acted on The Date Next Action indicates the next scheduled date for an action to occur for this request. DateNextAction

DATE

DateTime

Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID

NUMBER(10)

TableDir

Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID

NUMBER(10)

Search

User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID

NUMBER(10)

TableDir

Project Financial Project A Project allows you to track and control internal or external activities. C_Project_ID

NUMBER(10)

TableDir

Asset Asset used internally or by customers An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. A_Asset_ID

NUMBER(10)

Search

Order Order The Order is a control document. The Order is complete when the quantity ordered is the same as the quantity shipped and invoiced. When you cloase an order, unshipped (backordered) quantities are cancelled. C_Order_ID

NUMBER(10)

Search

Invoice Invoice Identifier The Invoice Document. C_Invoice_ID

NUMBER(10)

Search

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Payment Payment identifier The Payment is a unique identifier of this payment. C_Payment_ID

NUMBER(10)

Search

Shipment/Receipt Material Shipment Document The Material Shipment / Receipt M_InOut_ID

NUMBER(10)

Search

RMA Return Material Authorization A Return Material Authorization may be required to accept returns and to create Credit Memos M_RMA_ID

NUMBER(10)

TableDir

Null Columns Columns with NULL value Null values are used for showing "no change" NullColumns

NVARCHAR2(255)

String


Tab: Update Notification

Description : List Recipients for to receive Request Updates

Help :

Table Name  : R_RequestUpdates

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Request Request from a Business Partner or Prospect The Request identifies a unique request from a Business Partner or Prospect. R_Request_ID

NUMBER(10)

TableDir

User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID

NUMBER(10)

Search

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Self-Service This is a Self-Service entry or this entry can be changed via Self-Service Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. IsSelfService

CHAR(1)

YesNo


Tab: Update Recipients

Description : Display Recipients of Request Updates

Help : List of Recipients of Request Updates (with reason).
Direct: Sales Rep, User and direct subscribers Indirect: Users with Role, Subscribers of updates for Request Category, Type, Group)

Table Name  : RV_RequestUpdates

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Request Request from a Business Partner or Prospect The Request identifies a unique request from a Business Partner or Prospect. R_Request_ID

NUMBER(10)

Search

User/Contact User within the system - Internal or Business Partner Contact The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID

NUMBER(10)

Search

Request Type Type of request (e.g. Inquiry, Complaint, ..) Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc. R_RequestType_ID

NUMBER

TableDir

Category Request Category Category or Topic of the Request R_Category_ID

NUMBER

TableDir

Group Request Group Group of requests (e.g. version numbers, responsibility, ...) R_Group_ID

NUMBER

TableDir

Self-Service This is a Self-Service entry or this entry can be changed via Self-Service Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. IsSelfService

CHAR(1)

YesNo

Contributions

WARNING

Field "Result" on first tab (R_Request) must NOT BE updated to mandatory in dictionary. This field is intended to keep null after every change.

Personal tools