Table idempiere9.adempiere.r_requestaction
Request History

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_requestaction_id numeric 10 Request has been changed
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
r_request_id numeric 10
r_request.r_request_id rrequest_rrequestaction R
Request from a Business Partner or Prospect
r_group_id numeric 10  √  null
r_group.r_group_id rgroup_rrequestaction R
Request Group
r_category_id numeric 10  √  null
r_category.r_category_id rcategory_rrequestaction R
Request Category
r_status_id numeric 10  √  null
r_status.r_status_id rstatus_rrequestaction R
Request Status
r_resolution_id numeric 10  √  null
r_resolution.r_resolution_id rresolution_rrequestaction R
Request Resolution
salesrep_id numeric 10  √  null
ad_user.ad_user_id adusersr_rrequestaction R
Sales Representative or Company Agent
ad_role_id numeric 10  √  null
ad_role.ad_role_id adrole_rrequestaction R
Responsibility Role
isescalated bpchar 1  √  null This request has been escalated
isinvoiced bpchar 1  √  null Is this invoiced?
confidentialtype bpchar 1  √  null Type of Confidentiality
isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
priority bpchar 1  √  null Indicates if this request is of a high, medium or low priority.
priorityuser bpchar 1  √  null Priority of the issue for the User
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_rrequestaction R
Identifies a Business Partner
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_rrequestaction R
User within the system - Internal or Business Partner Contact
c_order_id numeric 10  √  null
c_order.c_order_id corder_rrequestaction R
Order
c_invoice_id numeric 10  √  null
c_invoice.c_invoice_id cinvoice_rrequestaction R
Invoice Identifier
c_payment_id numeric 10  √  null
c_payment.c_payment_id cpayment_rrequestaction R
Payment identifier
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_rrequestaction R
Product, Service, Item
c_project_id numeric 10  √  null
c_project.c_project_id cproject_rrequestaction R
Financial Project
summary varchar 2000  √  null Textual summary of this request
datenextaction timestamp 29,6  √  null Date that this request should be acted on
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_rrequestaction R
Business Activity
r_requesttype_id numeric 10  √  null
r_requesttype.r_requesttype_id rrequesttype_rrequestaction R
Type of request (e.g. Inquiry, Complaint, ..)
a_asset_id numeric 10  √  null
a_asset.a_asset_id aasset_rrequestaction R
Asset used internally or by customers
m_inout_id numeric 10  √  null
m_inout.m_inout_id minout_mrequestaction R
Material Shipment Document
m_rma_id numeric 10  √  null
m_rma.m_rma_id mrma_rrequestaction R
Return Material Authorization
nullcolumns varchar 255  √  null Columns with NULL value
taskstatus bpchar 1  √  null Status of the Task
datecompleteplan timestamp 29,6  √  null Planned Completion Date
qtyplan numeric 0  √  null Planned Quantity
qtyspent numeric 0  √  null Quantity used for this event
startdate timestamp 29,6  √  null First effective day (inclusive)
enddate timestamp 29,6  √  null Last effective date (inclusive)
datestartplan timestamp 29,6  √  null Planned Start Date
qtyinvoiced numeric 0  √  null Invoiced Quantity
m_productspent_id numeric 10  √  null
m_product.m_product_id mproductspent_rrequestaction R
Product/Resource/Service used in Request
r_requestaction_uu varchar 36  √  NULL::character varying R_RequestAction_UU

Table contained 2 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
r_requestaction_id Primary key Asc r_requestaction_pkey
r_requestaction_uu Must be unique Asc r_requestaction_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.