m_packagemps

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
c_uom_length_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuomlength_mpackagemps R
c_uom_weight_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuomweight_mpackagemps R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
createfrom bpchar 1 √ NULL::bpchar
description varchar 255 √ NULL::character varying
height numeric 0 √ null
isactive bpchar 1 'Y'::bpchar
length numeric 0 √ null
m_package_id numeric 10 null
m_package.m_package_id mpackage_mpackagemps R
m_packagemps_id numeric 10 null
m_packageline.m_packagemps_id mpackagemps_mpackageline R
m_shippingtransactionline.m_packagemps_id mpackagemps_mshippingtransacti R
x_packagelineweight.m_packagemps_id Implied Constraint R
m_packagemps_uu varchar 36 √ NULL::character varying
mastertrackingno varchar 255 √ NULL::character varying
price numeric 0 √ null
processed bpchar 1 'N'::bpchar
seqno numeric 10 √ NULL::numeric
trackingno varchar 255 √ NULL::character varying
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
weight numeric 0 √ null
width numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
m_packagemps_key Primary key Asc m_packagemps_id
m_packagemps_uu_idx Must be unique Asc m_packagemps_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation