t_distributionrundetail

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_distributionrun_id numeric 10 null
m_distributionrun.m_distributionrun_id mdistributionrun_tdrdetail C
m_distributionrunline_id numeric 10 null
m_distributionrunline.m_distributionrunline_id mdistributionrline_tdrdetail C
m_distributionlist_id numeric 10 null
m_distributionlist.m_distributionlist_id mdistributionlist_tdrdetail C
m_distributionlistline_id numeric 10 null
m_distributionlistline.m_distributionlistline_id mdistributionlline_tdrdetail C
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
ratio numeric 0 null
minqty numeric 0 0
qty numeric 0 0
m_product_id numeric 10 null
m_product.m_product_id mproduct_tdrdetail C
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_tdrdetail C
c_bpartner_location_id numeric 10 null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_tdrdetail C
t_distributionrundetail_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
t_distributionrundetail_pkey Primary key Asc/Asc/Asc/Asc m_distributionrun_id + m_distributionrunline_id + m_distributionlist_id + m_distributionlistline_id
t_distributionrundetail_uu_idx Must be unique Asc t_distributionrundetail_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation