c_bp_shippingacct

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_bp_shippingacct_id numeric 10 null
m_package.c_bp_shippingacct_id cbpshippingacct_mpackage R
m_shippingtransaction.c_bp_shippingacct_id cbpshippingacct_mshippingtrans R
c_bp_shippingacct_uu varchar 36 √ NULL::character varying
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_cbpshippingacct R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cbpshippinga R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
dutiesshipperaccount varchar 40 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
m_shippingprocessor_id numeric 10 √ NULL::numeric
m_shippingprocessor.m_shippingprocessor_id mshippingprocessor_cbpshipping R
shipperaccount varchar 40 √ NULL::character varying
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
shippermeter varchar 255 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_bp_shippingacct_key Primary key Asc c_bp_shippingacct_id
c_bp_shippingacct_uu_idx Must be unique Asc c_bp_shippingacct_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation