ManPageW Request
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: Request
Description : Work on your requests
Help : The Request Window is used to define and track any request assigned to you.
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. |
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 |
| Product Used | Product/Resource/Service used in Request | Invoicing uses the Product used. | M_ProductSpent_ID
NUMBER(10) Search |
| Quantity Used | Quantity used for this event | QtySpent
NUMBER Quantity | |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID
NUMBER(10) TableDir |
| Quantity Invoiced | Invoiced Quantity | The Invoiced Quantity indicates the quantity of a product that have been invoiced. | QtyInvoiced
NUMBER Quantity |
| Task Status | Status of the Task | Completion Rate and Status of the Task | TaskStatus
CHAR(1) List |
| Quantity Plan | Planned Quantity | Planned Quantity | QtyPlan
NUMBER Quantity |
| Start Plan | Planned Start Date | Date when you plan to start | DateStartPlan
DATE Date |
| Complete Plan | Planned Completion Date | Date when the task is planned to be complete | DateCompletePlan
DATE Date |
| Start Date | First effective day (inclusive) | The Start Date indicates the first or starting date | StartDate
DATE DateTime |
| Close Date | Close Date | The Start Date indicates the last or final date | CloseDate
DATE DateTime |
| 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 |
| Change Request | BOM (Engineering) Change Request | Change requests for a Bill of Materials. They can be automatically created from Requests, if enabled in the Request Type and the Request Group referres to a Bill of Materials | M_ChangeRequest_ID
NUMBER(10) Search |
| Request Invoice | The generated invoice for this request | The optionally generated invoice for the request | C_InvoiceRequest_ID
NUMBER(10) Search |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed
CHAR(1) YesNo |
| Fixed in | Fixed in Change Notice | M_FixChangeNotice_ID
NUMBER(10) Table |
Tab: Updates
Description : Request Updates
Help : Updated 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 |
| Product Used | Product/Resource/Service used in Request | Invoicing uses the Product used. | M_ProductSpent_ID
NUMBER(10) Table |
| Quantity Used | Quantity used for this event | QtySpent
NUMBER Quantity | |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID
NUMBER(10) TableDir |
| Quantity Invoiced | Invoiced Quantity | The Invoiced Quantity indicates the quantity of a product that have been invoiced. | QtyInvoiced
NUMBER Quantity |
| Task Status | Status of the Task | Completion Rate and Status of the Task | TaskStatus
CHAR(1) List |
| Quantity Plan | Planned Quantity | Planned Quantity | QtyPlan
NUMBER Quantity |
| Start Plan | Planned Start Date | Date when you plan to start | DateStartPlan
DATE Date |
| Complete Plan | Planned Completion Date | Date when the task is planned to be complete | DateCompletePlan
DATE Date |
| Start Date | First effective day (inclusive) | The Start Date indicates the first or starting date | StartDate
DATE DateTime |
| End Date | Last effective date (inclusive) | The End Date indicates the last date in this range. | EndDate
DATE DateTime |
| 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 |
