r_requestaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
r_requestaction_id numeric 10 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
r_request_id numeric 10 null
r_request.r_request_id rrequest_rrequestaction R
r_group_id numeric 10 √ null
r_group.r_group_id rgroup_rrequestaction R
r_category_id numeric 10 √ null
r_category.r_category_id rcategory_rrequestaction R
r_status_id numeric 10 √ null
r_status.r_status_id rstatus_rrequestaction R
r_resolution_id numeric 10 √ null
r_resolution.r_resolution_id rresolution_rrequestaction R
salesrep_id numeric 10 √ null
ad_user.ad_user_id adusersr_rrequestaction R
ad_role_id numeric 10 √ null
ad_role.ad_role_id adrole_rrequestaction R
isescalated bpchar 1 √ null
isinvoiced bpchar 1 √ null
confidentialtype bpchar 1 √ null
isselfservice bpchar 1 √ null
priority bpchar 1 √ null
priorityuser bpchar 1 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_rrequestaction R
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_rrequestaction R
c_order_id numeric 10 √ null
c_order.c_order_id corder_rrequestaction R
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_rrequestaction R
c_payment_id numeric 10 √ null
c_payment.c_payment_id cpayment_rrequestaction R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_rrequestaction R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_rrequestaction R
summary varchar 2000 √ null
datenextaction timestamp 29,6 √ null
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_rrequestaction R
r_requesttype_id numeric 10 √ null
r_requesttype.r_requesttype_id rrequesttype_rrequestaction R
a_asset_id numeric 10 √ null
a_asset.a_asset_id aasset_rrequestaction R
m_inout_id numeric 10 √ null
m_inout.m_inout_id minout_mrequestaction R
m_rma_id numeric 10 √ null
m_rma.m_rma_id mrma_rrequestaction R
nullcolumns varchar 255 √ null
taskstatus bpchar 1 √ null
datecompleteplan timestamp 29,6 √ null
qtyplan numeric 0 √ null
qtyspent numeric 0 √ null
startdate timestamp 29,6 √ null
enddate timestamp 29,6 √ null
datestartplan timestamp 29,6 √ null
qtyinvoiced numeric 0 √ null
m_productspent_id numeric 10 √ null
m_product.m_product_id mproductspent_rrequestaction R
r_requestaction_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
r_requestaction_pkey Primary key Asc r_requestaction_id
r_requestaction_uu_idx Must be unique Asc r_requestaction_uu

Check Constraints

Constraint Name Constraint
r_requestaction_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation