m_shippingtransaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
action varchar 2 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
boxcount numeric 10 √ 1
c_bp_shippingacct_id numeric 10 √ NULL::numeric
c_bp_shippingacct.c_bp_shippingacct_id cbpshippingacct_mshippingtrans R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_mshippingtra R
c_currency_id numeric 10 √ NULL::numeric
c_currency.c_currency_id ccurrency_mshippingtransaction R
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_mshippingtransaction R
c_uom_length_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuomlength_mshippingtransactio R
c_uom_weight_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuomweight_mshippingtransactio R
cashondelivery bpchar 1 'N'::bpchar
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
datereceived timestamp 29,6 √ null
deliveryconfirmation bpchar 1 'N'::bpchar
deliveryconfirmationtype varchar 30 √ NULL::character varying
description varchar 255 √ NULL::character varying
dothazardclassordivision varchar 30 √ NULL::character varying
dryiceweight numeric 0 √ null
dutiesshipperaccount varchar 40 √ NULL::character varying
fob varchar 10 √ NULL::character varying
freightcharges varchar 10 √ NULL::character varying
handlingcharge numeric 0 √ null
height numeric 0 √ null
homedeliverypremiumdate timestamp 29,6 √ null
homedeliverypremiumphone varchar 30 √ NULL::character varying
homedeliverypremiumtype varchar 30 √ NULL::character varying
insurance bpchar 1 √ NULL::bpchar
insuredamount numeric 0 √ null
isaccessible bpchar 1 'N'::bpchar
isactive bpchar 1 'Y'::bpchar
isaddedhandling 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
issaturdaydelivery bpchar 1 'N'::bpchar
issaturdaypickup bpchar 1 'N'::bpchar
isverbalconfirmation bpchar 1 'N'::bpchar
latestpickuptime timestamp 29,6 √ null
length numeric 0 √ null
m_inout_id numeric 10 √ NULL::numeric
m_inout.m_inout_id minout_mshippingtransaction R
m_package_id numeric 10 √ NULL::numeric
m_package.m_package_id mpackage_mshippingtransaction R
m_shipper_id numeric 10 null
m_shipper.m_shipper_id mshipper_mshippingtransaction R
m_shipperlabels_id numeric 10 √ NULL::numeric
m_shipperlabels.m_shipperlabels_id mshipperlabels_mshippingtransa R
m_shipperpackaging_id numeric 10 √ NULL::numeric
m_shipperpackaging.m_shipperpackaging_id mshipperpackaging_mshippingtra R
m_shipperpickuptypes_id numeric 10 √ NULL::numeric
m_shipperpickuptypes.m_shipperpickuptypes_id mshipperpickuptypes_mshippingt R
m_shippingprocessor_id numeric 10 √ NULL::numeric
m_shippingprocessor.m_shippingprocessor_id mshippingprocessor_mshippingtr R
m_shippingtransaction_id numeric 10 null
m_shippingtransactionline.m_shippingtransaction_id mshippingtransaction_mshipping R
m_shippingtransaction_uu varchar 36 √ NULL::character varying
notificationmessage varchar 255 √ NULL::character varying
notificationtype varchar 2 √ NULL::character varying
paymentrule bpchar 1 √ NULL::bpchar
price numeric 0 √ null
priceactual numeric 0 √ null
processed bpchar 1 'N'::bpchar
rateinquirymessage varchar 2000 √ NULL::character varying
receivedinfo varchar 255 √ NULL::character varying
shipdate timestamp 29,6 √ null
shipperaccount varchar 40 √ NULL::character varying
shippingrespmessage varchar 2000 √ NULL::character varying
surcharges numeric 0 √ null
trackinginfo varchar 255 √ NULL::character varying
trackingno varchar 255 √ NULL::character varying
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
weight numeric 0 √ null
width numeric 0 √ null
isalternatereturnaddress bpchar 1 'N'::bpchar
returnbpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id returnbpartner_mshippingtransa R
returnlocation_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id returnlocation_mshippingtransa R
returnuser_id numeric 10 √ NULL::numeric
ad_user.ad_user_id returnuser_mshippingtransactio R
codamount numeric 0 √ null
customsvalue numeric 0 √ null
freightamt numeric 0 √ null
salesrep_id numeric 10 √ NULL::numeric
ad_user.ad_user_id salesrep_mshippingtransaction R
m_warehouse_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id mwarehouse_mshippingtransactio R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_mshippingtransaction R
ad_user_id numeric 10 √ NULL::numeric
ad_user.ad_user_id aduser_mshippingtransaction R
poreference varchar 30 √ NULL::character varying
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id cinvoice_mshippingtransaction R
bill_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id billlocation_mshippingtransact R
ispriviledgedrate bpchar 1 'N'::bpchar
holdaddress_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id holdaddress_mshippingtransacti R

Indexes

Constraint Name Type Sort Column(s)
m_shippingtransaction_key Primary key Asc m_shippingtransaction_id
m_shippingtransaction_uu_idx Must be unique Asc m_shippingtransaction_uu

Check Constraints

Constraint Name Constraint
m_shippingtransaction_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isfuturedayshipment_check ((isfuturedayshipment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_issaturdaydelivery_check ((issaturdaydelivery = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isdutiable_check ((isdutiable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isholdatlocation_check ((isholdatlocation = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isalternatereturnaddress_check ((isalternatereturnaddress = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_ishazmat_check ((ishazmat = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_issaturdaypickup_check ((issaturdaypickup = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isdryice_check ((isdryice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isaccessible_check ((isaccessible = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_iscargoaircraftonly_check ((iscargoaircraftonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isignorezipstatenotmatch_check ((isignorezipstatenotmatch = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isverbalconfirmation_check ((isverbalconfirmation = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_deliveryconfirmation_check ((deliveryconfirmation = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isaddedhandling_check ((isaddedhandling = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isresidential_check ((isresidential = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_cashondelivery_check ((cashondelivery = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_ispriviledgedrate_check ((ispriviledgedrate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_shippingtransaction_isignorezipnotfound_check ((isignorezipnotfound = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation