Table idempiere11.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
r_requestaction.r_request_id rrequest_rrequestaction R
r_requestupdate.r_request_id rrequest_rrequestupdate R
r_requestupdates.r_request_id rrequest_rrupdates R
Request from a Business Partner or Prospect
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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
r_requesttype.r_requesttype_id rrequesttype_rrequest R
Type of request (e.g. Inquiry, Complaint, ..)
r_group_id numeric 10  √  null
r_group.r_group_id rgroup_rrequest R
Request Group
r_category_id numeric 10  √  null
r_category.r_category_id rcategory_rrequest R
Request Category
r_status_id numeric 10  √  null
r_status.r_status_id rstatus_rrequest R
Request Status
r_resolution_id numeric 10  √  null
r_resolution.r_resolution_id rresolution_rrequest R
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
ad_role.ad_role_id adrole_rrequest R
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
c_bpartner.c_bpartner_id c_bpartner_rrequest R
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
c_campaign.c_campaign_id ccampaign_rrequest R
Marketing Campaign
c_order_id numeric 10  √  null
c_order.c_order_id corder_rrequest R
Order
c_invoice_id numeric 10  √  null
c_invoice.c_invoice_id rinvoice_rrequest R
Invoice Identifier
c_payment_id numeric 10  √  null
c_payment.c_payment_id cpayment_rrequest R
Payment identifier
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_rrequest R
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
m_inout.m_inout_id minout_rrequest R
Material Shipment Document
m_rma_id numeric 10  √  null
m_rma.m_rma_id mrma_rrequest R
Return Material Authorization
ad_table_id numeric 10  √  null
ad_table.ad_table_id adtable_rrequest R
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
r_mailtext.r_mailtext_id rmailtext_rrequest R
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
r_standardresponse.r_standardresponse_id rstandardresponse_rrequest R
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
m_product.m_product_id mproductspent_rrequest R
Product/Resource/Service used in Request
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_rrequest R
Business Activity
startdate timestamp 29,6  √  null First effective day (inclusive)
closedate timestamp 29,6  √  null Close Date
c_invoicerequest_id numeric 10  √  null
c_invoice.c_invoice_id cinvoicerequest_rrequest R
The generated invoice for this request
m_changerequest_id numeric 10  √  null
m_changerequest.m_changerequest_id mchangerequest_rrequest R
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
m_changenotice.m_changenotice_id mfixchangenotice_rrequest R
Fixed in Change Notice
r_request_uu varchar 36  √  NULL::character varying R_Request_UU
record_uu varchar 36  √  NULL::character varying Record UUID

Table contained 1 rows at 2024-01-03 13:44 +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_table_id + record_uu Performance Asc/Asc r_request_table_recorduu_idx
ad_user_id Performance Asc r_request_user
r_request_uu Must be unique Asc r_request_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.