Skip to main content

Window: Request (all)

[Created: 08/12/2001 - Updated: 09/02/2005 ]
Description: View and work on all requests
Help: This Request window is used to view all available requests

Tab: Request

[Created: 08/12/2001 - Updated: 27/04/2005 ]
Description: Define Request
Help: The Request Tab defines any Request submitted by a Business Partner or internally.
Tab Level: 0

Table 10: Request - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.r_request.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.r_request.AD_Org_ID numeric(10)
Table Direct
Document NoDocument sequence number of the documentThe 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_", where TableName is the actual name of the table (e.g. C_Order).r_request.DocumentNo character varying(30)
String
Due typeStatus of the next action for this RequestThe Due Type indicates if this request is Due, Overdue or Scheduled.r_request.DueType character(1)
List
Request TypeType 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
GroupRequest GroupGroup of requests (e.g. version numbers, responsibility, ...)r_request.R_Group_ID numeric(10)
Table Direct
CategoryRequest CategoryCategory or Topic of the Requestr_request.R_Category_ID numeric(10)
Table Direct
Related RequestRelated Request (Master Issue, ..)Request related to this requestr_request.R_RequestRelated_ID numeric(10)
Search
StatusRequest StatusStatus if the request (open, closed, investigating, ..)r_request.R_Status_ID numeric(10)
Table Direct
ResolutionRequest ResolutionResolution status (e.g. Fixed, Rejected, ..)r_request.R_Resolution_ID numeric(10)
Table Direct
PriorityIndicates 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 ImportancePriority of the issue for the Userr_request.PriorityUser character(1)
List
SummaryTextual summary of this requestThe Summary allows free form text entry of a recap of this request.r_request.Summary character varying(2000)
Text
ConfidentialityType of Confidentialityr_request.ConfidentialType character(1)
List
InvoicedIs this invoiced?If selected, invoices are createdr_request.IsInvoiced character(1)
Yes-No
EscalatedThis request has been escalatedThe Escalated checkbox indicates that this request has been escalated or raised in importance.r_request.IsEscalated character(1)
Yes-No
Self-ServiceThis is a Self-Service entry or this entry can be changed via Self-ServiceSelf-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 RepresentativeSales Representative or Company AgentThe 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
RoleResponsibility RoleThe 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 ActionDate that this request should be acted onThe 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 ConfidentialityConfidentiality of the individual entryr_request.ConfidentialTypeEntry character(1)
List
Standard ResponseRequest Standard ResponseText blocks to be copied into request response textr_request.R_StandardResponse_ID numeric(10)
Table Direct
Mail TemplateText templates for mailingsThe 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
ResultResult of the action takenThe Result indicates the result of any action taken on this request.r_request.Result character varying(2000)
Text
Product UsedProduct/Resource/Service used in RequestInvoicing uses the Product used.r_request.M_ProductSpent_ID numeric(10)
Search
Quantity UsedQuantity used for this eventr_request.QtySpent numeric
Quantity
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingr_request.C_Activity_ID numeric(10)
Table Direct
Task StatusStatus of the TaskCompletion Rate and Status of the Taskr_request.TaskStatus character(1)
List
Quantity InvoicedInvoiced QuantityThe Invoiced Quantity indicates the quantity of a product that have been invoiced.r_request.QtyInvoiced numeric
Quantity
Start TimeTime startedr_request.StartTime timestamp without time zone
Date+Time
End TimeEnd of the time spanr_request.EndTime timestamp without time zone
Date+Time
Start DateFirst effective day (inclusive)The Start Date indicates the first or starting dater_request.StartDate timestamp without time zone
Date+Time
Close DateClose DateThe Start Date indicates the last or final dater_request.CloseDate timestamp without time zone
Date+Time
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonr_request.C_BPartner_ID numeric(10)
Search
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactr_request.AD_User_ID numeric(10)
Table Direct
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.r_request.C_Project_ID numeric(10)
Table Direct
AssetAsset used internally or by customersAn 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
OrderOrderThe 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
InvoiceInvoice IdentifierThe Invoice Document.r_request.C_Invoice_ID numeric(10)
Search
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.r_request.M_Product_ID numeric(10)
Search
PaymentPayment identifierThe Payment is a unique identifier of this payment.r_request.C_Payment_ID numeric(10)
Search
Shipment/ReceiptMaterial Shipment DocumentThe Material Shipment / Receiptr_request.M_InOut_ID numeric(10)
Search
RMAReturn Material AuthorizationA Return Material Authorization may be required to accept returns and to create Credit Memosr_request.M_RMA_ID numeric(10)
Search
Request AmountAmount associated with this requestThe Request Amount indicates any amount that is associated with this request. For example, a warranty amount or refund amount.r_request.RequestAmt numeric
Amount
CampaignMarketing CampaignThe 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
TableDatabase Table informationThe Database Table provides the information of the table definitionr_request.AD_Table_ID numeric(10)
Table Direct
Record UUIDr_request.Record_UU character varying(36)
Record UUID
Record IDDirect internal record IDThe 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)
Record ID
Date Last ActionDate this request was last acted onThe Date Last Action indicates that last time that the request was acted on.r_request.DateLastAction timestamp without time zone
Date+Time
Last AlertDate when last alert were sentThe last alert date is updated when a reminder email is sentr_request.DateLastAlert timestamp without time zone
Date+Time
Last ResultResult of last contactThe Last Result identifies the result of the last contact made.r_request.LastResult character varying(2000)
String
CreatedDate this record was createdThe Created field indicates the date that this record was created.r_request.Created timestamp without time zone
Date+Time
Created ByUser who created this recordsThe Created By field indicates the user who created this record.r_request.CreatedBy numeric(10)
Search
UpdatedDate this record was updatedThe Updated field indicates the date that this record was updated.r_request.Updated timestamp without time zone
Date+Time
Updated ByUser who updated this recordsThe Updated By field indicates the user who updated this record.r_request.UpdatedBy numeric(10)
Search
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.r_request.Processed character(1)
Yes-No
Request InvoiceThe generated invoice for this requestThe optionally generated invoice for the requestr_request.C_InvoiceRequest_ID numeric(10)
Search

Tab: Updates

[Created: 17/05/2005 - Updated: 17/05/2005 ]
Description: Request Updates
Help: Updates of the Request
Tab Level: 1

Table 20: Updates - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.r_requestupdate.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.r_requestupdate.AD_Org_ID numeric(10)
Table Direct
RequestRequest from a Business Partner or ProspectThe Request identifies a unique request from a Business Partner or Prospect.r_requestupdate.R_Request_ID numeric(10)
Search
Entry ConfidentialityConfidentiality of the individual entryr_requestupdate.ConfidentialTypeEntry character(1)
List
CreatedDate this record was createdThe Created field indicates the date that this record was created.r_requestupdate.Created timestamp without time zone
Date+Time
Created ByUser who created this recordsThe Created By field indicates the user who created this record.r_requestupdate.CreatedBy numeric(10)
Search
ResultResult of the action takenThe Result indicates the result of any action taken on this request.r_requestupdate.Result character varying(2000)
Memo
Quantity UsedQuantity used for this eventr_requestupdate.QtySpent numeric
Quantity
Quantity InvoicedInvoiced QuantityThe Invoiced Quantity indicates the quantity of a product that have been invoiced.r_requestupdate.QtyInvoiced numeric
Quantity
Product UsedProduct/Resource/Service used in RequestInvoicing uses the Product used.r_requestupdate.M_ProductSpent_ID numeric(10)
Search

Tab: History

[Created: 08/12/2001 - Updated: 17/05/2005 ]
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.
Tab Level: 1

Table 30: History - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.r_requestaction.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.r_requestaction.AD_Org_ID numeric(10)
Table Direct
RequestRequest from a Business Partner or ProspectThe Request identifies a unique request from a Business Partner or Prospect.r_requestaction.R_Request_ID numeric(10)
Search
CreatedDate this record was createdThe Created field indicates the date that this record was created.r_requestaction.Created timestamp without time zone
Date+Time
Created ByUser who created this recordsThe Created By field indicates the user who created this record.r_requestaction.CreatedBy numeric(10)
Search
Request TypeType 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
GroupRequest GroupGroup of requests (e.g. version numbers, responsibility, ...)r_requestaction.R_Group_ID numeric(10)
Table Direct
CategoryRequest CategoryCategory or Topic of the Requestr_requestaction.R_Category_ID numeric(10)
Table Direct
StatusRequest StatusStatus if the request (open, closed, investigating, ..)r_requestaction.R_Status_ID numeric(10)
Table Direct
ResolutionRequest ResolutionResolution status (e.g. Fixed, Rejected, ..)r_requestaction.R_Resolution_ID numeric(10)
Table Direct
PriorityIndicates 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 ImportancePriority of the issue for the Userr_requestaction.PriorityUser character(1)
List
SummaryTextual summary of this requestThe Summary allows free form text entry of a recap of this request.r_requestaction.Summary character varying(2000)
Text
ConfidentialityType of Confidentialityr_requestaction.ConfidentialType character(1)
List
InvoicedIs this invoiced?If selected, invoices are createdr_requestaction.IsInvoiced character(1)
Yes-No
EscalatedThis request has been escalatedThe Escalated checkbox indicates that this request has been escalated or raised in importance.r_requestaction.IsEscalated character(1)
List
Self-ServiceThis is a Self-Service entry or this entry can be changed via Self-ServiceSelf-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 RepresentativeSales Representative or Company AgentThe 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
RoleResponsibility RoleThe 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 ActionDate that this request should be acted onThe 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
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingr_requestaction.C_Activity_ID numeric(10)
Table Direct
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonr_requestaction.C_BPartner_ID numeric(10)
Search
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactr_requestaction.AD_User_ID numeric(10)
Table Direct
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.r_requestaction.C_Project_ID numeric(10)
Table Direct
AssetAsset used internally or by customersAn 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
OrderOrderThe 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
InvoiceInvoice IdentifierThe Invoice Document.r_requestaction.C_Invoice_ID numeric(10)
Search
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.r_requestaction.M_Product_ID numeric(10)
Search
PaymentPayment identifierThe Payment is a unique identifier of this payment.r_requestaction.C_Payment_ID numeric(10)
Search
Shipment/ReceiptMaterial Shipment DocumentThe Material Shipment / Receiptr_requestaction.M_InOut_ID numeric(10)
Search
RMAReturn Material AuthorizationA Return Material Authorization may be required to accept returns and to create Credit Memosr_requestaction.M_RMA_ID numeric(10)
Search
Null ColumnsColumns with NULL valueNull values are used for showing "no change"r_requestaction.NullColumns character varying(255)
String

Tab: Update Notification

[Created: 13/05/2005 - Updated: 17/05/2005 ]
Description: List Recipients for to receive Request Updates
Help:
Tab Level: 1

Table 40: Update Notification - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.r_requestupdates.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.r_requestupdates.AD_Org_ID numeric(10)
Table Direct
RequestRequest from a Business Partner or ProspectThe Request identifies a unique request from a Business Partner or Prospect.r_requestupdates.R_Request_ID numeric(10)
Search
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactr_requestupdates.AD_User_ID numeric(10)
Search
ActiveThe record is active in the systemThere 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-ServiceThis is a Self-Service entry or this entry can be changed via Self-ServiceSelf-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

Tab: Update Recipients

[Created: 13/05/2005 - Updated: 17/05/2005 ]
Description: Display Recipients of Request Updates
Help: List of Recipients of Request Updates (with reason).Direct: Sales Rep, User and direct subscribersIndirect: Users with Role, Subscribers of updates for Request Category, Type, Group)
Tab Level: 1

Table 50: Update Recipients - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.rv_requestupdates.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.rv_requestupdates.AD_Org_ID numeric(10)
Table Direct
RequestRequest from a Business Partner or ProspectThe Request identifies a unique request from a Business Partner or Prospect.rv_requestupdates.R_Request_ID numeric(10)
Search
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactrv_requestupdates.AD_User_ID numeric(10)
Search
Request TypeType of request (e.g. Inquiry, Complaint, ..)Request Types are used for processing and categorizing requests. Options are Account Inquiry, Warranty Issue, etc.rv_requestupdates.R_RequestType_ID numeric
Table Direct
CategoryRequest CategoryCategory or Topic of the Requestrv_requestupdates.R_Category_ID numeric
Table Direct
GroupRequest GroupGroup of requests (e.g. version numbers, responsibility, ...)rv_requestupdates.R_Group_ID numeric
Table Direct
Self-ServiceThis is a Self-Service entry or this entry can be changed via Self-ServiceSelf-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.rv_requestupdates.IsSelfService
Yes-No