Request (Window ID-201)

From iDempiere en

Table of 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.

File:Request - Request - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Fixed in Fixed in Change Notice R_Request.M_FixChangeNotice_ID
numeric(10)
Table
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. R_Request.AD_Client_ID
numeric(10)
Table Direct
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. R_Request.AD_Org_ID
numeric(10)
Table Direct
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).

R_Request.DocumentNo
character varying(30)
String
Due type Status of the next action for this Request The Due Type indicates if this request is Due, Overdue or Scheduled. R_Request.DueType
character(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_Request.R_RequestType_ID
numeric(10)
Table Direct
Group Request Group Group of requests (e.g. version numbers, responsibility, ...) R_Request.R_Group_ID
numeric(10)
Table Direct
Category Request Category Category or Topic of the Request R_Request.R_Category_ID
numeric(10)
Table Direct
Related Request Related Request (Master Issue, ..) Request related to this request R_Request.R_RequestRelated_ID
numeric(10)
Search
Status Request Status Status if the request (open, closed, investigating, ..) R_Request.R_Status_ID
numeric(10)
Table Direct
Resolution Request Resolution Resolution status (e.g. Fixed, Rejected, ..) R_Request.R_Resolution_ID
numeric(10)
Table Direct
Priority Indicates if this request is of a high, medium or low priority. The Priority indicates the importance of this request. R_Request.Priority
character(1)
List
User Importance Priority of the issue for the User R_Request.PriorityUser
character(1)
List
Summary Textual summary of this request The Summary allows free form text entry of a recap of this request. R_Request.Summary
character varying(2000)
Text
Confidentiality Type of Confidentiality R_Request.ConfidentialType
character(1)
List
Invoiced Is this invoiced? If selected, invoices are created R_Request.IsInvoiced
character(1)
Yes-No
Escalated This request has been escalated The Escalated checkbox indicates that this request has been escalated or raised in importance. R_Request.IsEscalated
character(1)
Yes-No
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. R_Request.IsSelfService
character(1)
Yes-No
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. R_Request.SalesRep_ID
numeric(10)
Table
Role Responsibility Role The Role determines security and access a user who has this Role will have in the System. R_Request.AD_Role_ID
numeric(10)
Table Direct
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. R_Request.DateNextAction
timestamp without time zone
Date+Time
Entry Confidentiality Confidentiality of the individual entry R_Request.ConfidentialTypeEntry
character(1)
List
Standard Response Request Standard Response Text blocks to be copied into request response text R_Request.R_StandardResponse_ID
numeric(10)
Table Direct
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_Request.R_MailText_ID
numeric(10)
Table Direct
Result Result of the action taken The Result indicates the result of any action taken on this request. R_Request.Result
character varying(2000)
Text
Product Used Product/Resource/Service used in Request Invoicing uses the Product used. R_Request.M_ProductSpent_ID
numeric(10)
Search
Quantity Used Quantity used for this event R_Request.QtySpent
numeric
Quantity
Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing R_Request.C_Activity_ID
numeric(10)
Table Direct
Quantity Invoiced Invoiced Quantity The Invoiced Quantity indicates the quantity of a product that have been invoiced. R_Request.QtyInvoiced
numeric
Quantity
Task Status Status of the Task Completion Rate and Status of the Task R_Request.TaskStatus
character(1)
List
Quantity Plan Planned Quantity Planned Quantity R_Request.QtyPlan
numeric
Quantity
Start Time Time started R_Request.StartTime
timestamp without time zone
Date+Time
End Time End of the time span R_Request.EndTime
timestamp without time zone
Date+Time
Start Date First effective day (inclusive) The Start Date indicates the first or starting date R_Request.StartDate
timestamp without time zone
Date+Time
Close Date Close Date The Start Date indicates the last or final date R_Request.CloseDate
timestamp without time zone
Date+Time
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson R_Request.C_BPartner_ID
numeric(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 R_Request.AD_User_ID
numeric(10)
Table Direct
Project Financial Project A Project allows you to track and control internal or external activities. R_Request.C_Project_ID
numeric(10)
Table Direct
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. R_Request.A_Asset_ID
numeric(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 close an order, unshipped (backordered) quantities are cancelled. R_Request.C_Order_ID
numeric(10)
Search
Invoice Invoice Identifier The Invoice Document. R_Request.C_Invoice_ID
numeric(10)
Search
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. R_Request.M_Product_ID
numeric(10)
Search
Payment Payment identifier The Payment is a unique identifier of this payment. R_Request.C_Payment_ID
numeric(10)
Search
Shipment/Receipt Material Shipment Document The Material Shipment / Receipt R_Request.M_InOut_ID
numeric(10)
Search
RMA Return Material Authorization A Return Material Authorization may be required to accept returns and to create Credit Memos R_Request.M_RMA_ID
numeric(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. R_Request.RequestAmt
numeric
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. R_Request.C_Campaign_ID
numeric(10)
Table Direct
Table Database Table information The Database Table provides the information of the table definition R_Request.AD_Table_ID
numeric(10)
Table Direct
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. R_Request.Record_ID
numeric(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. R_Request.DateLastAction
timestamp without time zone
Date+Time
Last Alert Date when last alert were sent The last alert date is updated when a reminder email is sent R_Request.DateLastAlert
timestamp without time zone
Date+Time
Last Result Result of last contact The Last Result identifies the result of the last contact made. R_Request.LastResult
character varying(2000)
String
Created Date this record was created The Created field indicates the date that this record was created. R_Request.Created
timestamp without time zone
Date+Time
Created By User who created this records The Created By field indicates the user who created this record. R_Request.CreatedBy
numeric(10)
Search
Updated Date this record was updated The Updated field indicates the date that this record was updated. R_Request.Updated
timestamp without time zone
Date+Time
Updated By User who updated this records The Updated By field indicates the user who updated this record. R_Request.UpdatedBy
numeric(10)
Search
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 refers to a Bill of Materials R_Request.M_ChangeRequest_ID
numeric(10)
Search
Request Invoice The generated invoice for this request The optionally generated invoice for the request R_Request.C_InvoiceRequest_ID
numeric(10)
Search
Processed The document has been processed The Processed checkbox indicates that a document has been processed. R_Request.Processed
character(1)
Yes-No

Tab: Updates

Description: Request Updates

Help: Updated of the Request

File:Request - Updates - Window (iDempiere 1.0.0).png

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. R_RequestUpdate.AD_Client_ID
numeric(10)
Table Direct
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. R_RequestUpdate.AD_Org_ID
numeric(10)
Table Direct
Request Request from a Business Partner or Prospect The Request identifies a unique request from a Business Partner or Prospect. R_RequestUpdate.R_Request_ID
numeric(10)
Search
Entry Confidentiality Confidentiality of the individual entry R_RequestUpdate.ConfidentialTypeEntry
character(1)
List
Created Date this record was created The Created field indicates the date that this record was created. R_RequestUpdate.Created
timestamp without time zone
Date+Time
Created By User who created this records The Created By field indicates the user who created this record. R_RequestUpdate.CreatedBy
numeric(10)
Search
Result Result of the action taken The Result indicates the result of any action taken on this request. R_RequestUpdate.Result
character varying(2000)
Memo
Quantity Used Quantity used for this event R_RequestUpdate.QtySpent
numeric
Quantity
Quantity Invoiced Invoiced Quantity The Invoiced Quantity indicates the quantity of a product that have been invoiced. R_RequestUpdate.QtyInvoiced
numeric
Quantity
Product Used Product/Resource/Service used in Request Invoicing uses the Product used. R_RequestUpdate.M_ProductSpent_ID
numeric(10)
Search

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.

File:Request - History - Window (iDempiere 1.0.0).png

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. R_RequestAction.AD_Client_ID
numeric(10)
Table Direct
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. R_RequestAction.AD_Org_ID
numeric(10)
Table Direct
Request Request from a Business Partner or Prospect The Request identifies a unique request from a Business Partner or Prospect. R_RequestAction.R_Request_ID
numeric(10)
Search
Created Date this record was created The Created field indicates the date that this record was created. R_RequestAction.Created
timestamp without time zone
Date+Time
Created By User who created this records The Created By field indicates the user who created this record. R_RequestAction.CreatedBy
numeric(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_RequestAction.R_RequestType_ID
numeric(10)
Table Direct
Group Request Group Group of requests (e.g. version numbers, responsibility, ...) R_RequestAction.R_Group_ID
numeric(10)
Table Direct
Category Request Category Category or Topic of the Request R_RequestAction.R_Category_ID
numeric(10)
Table Direct
Status Request Status Status if the request (open, closed, investigating, ..) R_RequestAction.R_Status_ID
numeric(10)
Table Direct
Resolution Request Resolution Resolution status (e.g. Fixed, Rejected, ..) R_RequestAction.R_Resolution_ID
numeric(10)
Table Direct
Priority Indicates if this request is of a high, medium or low priority. The Priority indicates the importance of this request. R_RequestAction.Priority
character(1)
List
User Importance Priority of the issue for the User R_RequestAction.PriorityUser
character(1)
List
Summary Textual summary of this request The Summary allows free form text entry of a recap of this request. R_RequestAction.Summary
character varying(2000)
Text
Confidentiality Type of Confidentiality R_RequestAction.ConfidentialType
character(1)
List
Invoiced Is this invoiced? If selected, invoices are created R_RequestAction.IsInvoiced
character(1)
Yes-No
Escalated This request has been escalated The Escalated checkbox indicates that this request has been escalated or raised in importance. R_RequestAction.IsEscalated
character(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. R_RequestAction.IsSelfService
character(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. R_RequestAction.SalesRep_ID
numeric(10)
Search
Role Responsibility Role The Role determines security and access a user who has this Role will have in the System. R_RequestAction.AD_Role_ID
numeric(10)
Table Direct
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. R_RequestAction.DateNextAction
timestamp without time zone
Date+Time
Product Used Product/Resource/Service used in Request Invoicing uses the Product used. R_RequestAction.M_ProductSpent_ID
numeric(10)
Search
Quantity Used Quantity used for this event R_RequestAction.QtySpent
numeric
Quantity
Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing R_RequestAction.C_Activity_ID
numeric(10)
Table Direct
Quantity Invoiced Invoiced Quantity The Invoiced Quantity indicates the quantity of a product that have been invoiced. R_RequestAction.QtyInvoiced
numeric
Quantity
Task Status Status of the Task Completion Rate and Status of the Task R_RequestAction.TaskStatus
character(1)
List
Quantity Plan Planned Quantity Planned Quantity R_RequestAction.QtyPlan
numeric
Quantity
Start Plan Planned Start Date Date when you plan to start R_RequestAction.DateStartPlan
timestamp without time zone
Date
Complete Plan Planned Completion Date Date when the task is planned to be complete R_RequestAction.DateCompletePlan
timestamp without time zone
Date
Start Date First effective day (inclusive) The Start Date indicates the first or starting date R_RequestAction.StartDate
timestamp without time zone
Date+Time
End Date Last effective date (inclusive) The End Date indicates the last date in this range. R_RequestAction.EndDate
timestamp without time zone
Date+Time
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson R_RequestAction.C_BPartner_ID
numeric(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 R_RequestAction.AD_User_ID
numeric(10)
Table Direct
Project Financial Project A Project allows you to track and control internal or external activities. R_RequestAction.C_Project_ID
numeric(10)
Table Direct
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. R_RequestAction.A_Asset_ID
numeric(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 close an order, unshipped (backordered) quantities are cancelled. R_RequestAction.C_Order_ID
numeric(10)
Search
Invoice Invoice Identifier The Invoice Document. R_RequestAction.C_Invoice_ID
numeric(10)
Search
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. R_RequestAction.M_Product_ID
numeric(10)
Search
Payment Payment identifier The Payment is a unique identifier of this payment. R_RequestAction.C_Payment_ID
numeric(10)
Search
Shipment/Receipt Material Shipment Document The Material Shipment / Receipt R_RequestAction.M_InOut_ID
numeric(10)
Search
RMA Return Material Authorization A Return Material Authorization may be required to accept returns and to create Credit Memos R_RequestAction.M_RMA_ID
numeric(10)
Search
Null Columns Columns with NULL value Null values are used for showing "no change" R_RequestAction.NullColumns
character varying(255)
String

Tab: Update Notification

Description: List Recipients for to receive Request Updates

Help:

File:Request - Update Notification - Window (iDempiere 1.0.0).png

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. R_RequestUpdates.AD_Client_ID
numeric(10)
Table Direct
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. R_RequestUpdates.AD_Org_ID
numeric(10)
Table Direct
Request Request from a Business Partner or Prospect The Request identifies a unique request from a Business Partner or Prospect. R_RequestUpdates.R_Request_ID
numeric(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 R_RequestUpdates.AD_User_ID
numeric(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.

R_RequestUpdates.IsActive
character(1)
Yes-No
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. R_RequestUpdates.IsSelfService
character(1)
Yes-No


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.