m_package

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_package_id numeric 10 null
m_packageline.m_package_id mpackage_mpackageline R
m_packagemps.m_package_id mpackage_mpackagemps R
m_shippingtransaction.m_package_id mpackage_mshippingtransaction R
x_packagelineweight.m_package_id Implied Constraint R
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
documentno varchar 30 null
m_inout_id numeric 10 null
m_inout.m_inout_id minout_mpackage R
description varchar 255 √ null
m_shipper_id numeric 10 null
m_shipper.m_shipper_id mshipper_mpackage R
trackinginfo varchar 255 √ null
datereceived timestamp 29,6 √ null
receivedinfo varchar 255 √ null
shipdate timestamp 29,6 √ null
m_package_uu varchar 36 √ NULL::character varying
boxcount numeric 10 √ (1)::numeric
cashondelivery bpchar 1 'N'::bpchar
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_mpackage R
c_currency_id numeric 10 √ NULL::numeric
c_currency.c_currency_id ccurrency_mpackage R
c_uom_length_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuomlength_mpackage R
c_uom_weight_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuomweight_mpackage R
deliveryconfirmation bpchar 1 'N'::bpchar
dothazardclassordivision varchar 30 √ NULL::character varying
handlingcharge numeric 0 √ null
height numeric 0 √ null
homedeliverypremiumdate timestamp 29,6 √ null
homedeliverypremiumtype varchar 30 √ NULL::character varying
insuredamount numeric 0 √ null
isaccessible bpchar 1 'N'::bpchar
iscargoaircraftonly bpchar 1 'N'::bpchar
isdryice bpchar 1 'N'::bpchar
isdutiable bpchar 1 'N'::bpchar
isfuturedayshipment bpchar 1 'N'::bpchar
ishazmat bpchar 1 'N'::bpchar
isholdatlocation bpchar 1 'N'::bpchar
isignorezipnotfound bpchar 1 'N'::bpchar
isignorezipstatenotmatch bpchar 1 'N'::bpchar
isresidential bpchar 1 'Y'::bpchar
labelprint bpchar 1 √ NULL::bpchar
latestpickuptime timestamp 29,6 √ null
length numeric 0 √ null
notificationtype varchar 2 √ NULL::character varying
oprocessing bpchar 1 √ NULL::bpchar
price numeric 0 √ null
priceactual numeric 0 √ null
processed bpchar 1 'N'::bpchar
rateinquirymessage varchar 2000 √ NULL::character varying
issaturdaydelivery bpchar 1 'N'::bpchar
issaturdaypickup bpchar 1 'N'::bpchar
shippingrateinquiry bpchar 1 √ NULL::bpchar
shippingrespmessage varchar 2000 √ NULL::character varying
surcharges numeric 0 √ null
trackingno varchar 255 √ NULL::character varying
voidit bpchar 1 √ NULL::bpchar
weight numeric 0 √ null
width numeric 0 √ null
c_bp_shippingacct_id numeric 10 √ NULL::numeric
c_bp_shippingacct.c_bp_shippingacct_id cbpshippingacct_mpackage R
dutiesshipperaccount varchar 40 √ NULL::character varying
m_shipperlabels_id numeric 10 √ NULL::numeric
m_shipperlabels.m_shipperlabels_id mshipperlabels_mpackage R
m_shipperpackaging_id numeric 10 √ NULL::numeric
m_shipperpackaging.m_shipperpackaging_id mshipperpackaging_mpackage R
m_shipperpickuptypes_id numeric 10 √ NULL::numeric
m_shipperpickuptypes.m_shipperpickuptypes_id mshipperpickuptypes_mpackage R
shipperaccount varchar 40 √ NULL::character varying
homedeliverypremiumphone varchar 30 √ NULL::character varying
dryiceweight numeric 0 √ null
notificationmessage varchar 255 √ NULL::character varying
isverbalconfirmation bpchar 1 'N'::bpchar
isaddedhandling bpchar 1 'N'::bpchar
paymentrule bpchar 1 √ NULL::bpchar
deliveryconfirmationtype varchar 30 √ NULL::character varying
holdaddress_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id holdaddress_mpackage R

Indexes

Constraint Name Type Sort Column(s)
m_package_pkey Primary key Asc m_package_id
m_package_uu_idx Must be unique Asc m_package_uu

Check Constraints

Constraint Name Constraint
m_package_isholdatlocation_check ((isholdatlocation = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_issaturdaydelivery_check ((issaturdaydelivery = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isaccessible_check ((isaccessible = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isdutiable_check ((isdutiable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_deliveryconfirmation_check ((deliveryconfirmation = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_ishazmat_check ((ishazmat = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isdryice_check ((isdryice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isignorezipstatenotmatch_check ((isignorezipstatenotmatch = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isfuturedayshipment_check ((isfuturedayshipment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_issaturdaypickup_check ((issaturdaypickup = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isaddedhandling_check ((isaddedhandling = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isignorezipnotfound_check ((isignorezipnotfound = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_iscargoaircraftonly_check ((iscargoaircraftonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isverbalconfirmation_check ((isverbalconfirmation = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_cashondelivery_check ((cashondelivery = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_package_isresidential_check ((isresidential = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation