Table idempiere9.adempiere.r_request
Request from a Business Partner or Prospect

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
r_request_id numeric 10
ad_issue.r_request_id rrequest_adissue N
r_issueknown.r_request_id rrequest_rissueknown R
r_request.r_requestrelated_id rrequest_related R
Request from a Business Partner or Prospect
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
documentno varchar 30 Document sequence number of the document
r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_group_id numeric 10  √  null Request Group
r_category_id numeric 10  √  null Request Category
r_status_id numeric 10  √  null Request Status
r_resolution_id numeric 10  √  null Request Resolution
r_requestrelated_id numeric 10  √  null
r_request.r_request_id rrequest_related R
Related Request (Master Issue, ..)
priority bpchar 1 Indicates if this request is of a high, medium or low priority.
priorityuser bpchar 1  √  null Priority of the issue for the User
duetype bpchar 1 Status of the next action for this Request
summary varchar 2000 Textual summary of this request
confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
isescalated bpchar 1 'N'::bpchar This request has been escalated
isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
salesrep_id numeric 10
ad_user.ad_user_id adusersr_rrequest R
Sales Representative or Company Agent
ad_role_id numeric 10  √  null Responsibility Role
datelastaction timestamp 29,6  √  null Date this request was last acted on
datelastalert timestamp 29,6  √  null Date when last alert were sent
lastresult varchar 2000  √  null Result of last contact
processed bpchar 1 'N'::bpchar The document has been processed
isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_rrequest R
User within the system - Internal or Business Partner Contact
c_campaign_id numeric 10  √  null Marketing Campaign
c_order_id numeric 10  √  null Order
c_invoice_id numeric 10  √  null Invoice Identifier
c_payment_id numeric 10  √  null Payment identifier
m_product_id numeric 10  √  null Product, Service, Item
c_project_id numeric 10  √  null
c_project.c_project_id cproject_rrequest R
Financial Project
a_asset_id numeric 10  √  null
a_asset.a_asset_id aasset_rrequest R
Asset used internally or by customers
m_inout_id numeric 10  √  null Material Shipment Document
m_rma_id numeric 10  √  null Return Material Authorization
ad_table_id numeric 10  √  null Database Table information
record_id numeric 10  √  null Direct internal record ID
requestamt numeric 0 0 Amount associated with this request
r_mailtext_id numeric 10  √  null Text templates for mailings
result varchar 2000  √  null Result of the action taken
confidentialtypeentry bpchar 1 Confidentiality of the individual entry
r_standardresponse_id numeric 10  √  null Request Standard Response
nextaction bpchar 1  √  null Next Action to be taken
datenextaction timestamp 29,6  √  null Date that this request should be acted on
starttime timestamp 29,6  √  null Time started
endtime timestamp 29,6  √  null End of the time span
qtyspent numeric 0  √  0 Quantity used for this event
qtyinvoiced numeric 0  √  0 Invoiced Quantity
m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
c_activity_id numeric 10  √  null Business Activity
startdate timestamp 29,6  √  null First effective day (inclusive)
closedate timestamp 29,6  √  null Close Date
c_invoicerequest_id numeric 10  √  null The generated invoice for this request
m_changerequest_id numeric 10  √  null BOM (Engineering) Change Request
taskstatus bpchar 1  √  null Status of the Task
qtyplan numeric 0  √  null Planned Quantity
datecompleteplan timestamp 29,6  √  null Planned Completion Date
datestartplan timestamp 29,6  √  null Planned Start Date
m_fixchangenotice_id numeric 10  √  null Fixed in Change Notice
r_request_uu varchar 36  √  NULL::character varying R_Request_UU

Table contained 1 rows at 2021-12-25 14:48 +0100

Indexes:
Column(s) Type Sort Constraint Name
r_request_id Primary key Asc r_request_pkey
c_bpartner_id Performance Asc r_request_bpartner
ad_user_id Performance Asc r_request_user
r_request_uu Must be unique Asc r_request_uu_idx

Close relationships  within of separation: