Table idempiere9.adempiere.m_shippingtransaction
Shipping Transaction

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
action varchar 2 Indicates the Action to be performed
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
boxcount numeric 10  √  1 Box Count
c_bp_shippingacct_id numeric 10  √  NULL::numeric
c_bp_shippingacct.c_bp_shippingacct_id cbpshippingacct_mshippingtrans R
Business Partner Shipping Account
c_bpartner_location_id numeric 10  √  NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_mshippingtra R
Identifies the (ship to) address for this Business Partner
c_currency_id numeric 10  √  NULL::numeric
c_currency.c_currency_id ccurrency_mshippingtransaction R
The Currency for this record
c_order_id numeric 10  √  NULL::numeric
c_order.c_order_id corder_mshippingtransaction R
Order
c_uom_length_id numeric 10  √  NULL::numeric
c_uom.c_uom_id cuomlength_mshippingtransactio R
Standard Unit of Measure for Length
c_uom_weight_id numeric 10  √  NULL::numeric
c_uom.c_uom_id cuomweight_mshippingtransactio R
Standard Unit of Measure for Weight
cashondelivery bpchar 1 'N'::bpchar COD
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
datereceived timestamp 29,6  √  null Date a product was received
deliveryconfirmation bpchar 1 'N'::bpchar EMail Delivery confirmation
deliveryconfirmationtype varchar 30  √  NULL::character varying Delivery Confirmation Type
description varchar 255  √  NULL::character varying Optional short description of the record
dothazardclassordivision varchar 30  √  NULL::character varying Dot Hazard Class or Division
dryiceweight numeric 0  √  null Dry Ice Weight
dutiesshipperaccount varchar 40  √  NULL::character varying Duties Shipper Account
fob varchar 10  √  NULL::character varying Freight Terms
freightcharges varchar 10  √  NULL::character varying Freight Charges
handlingcharge numeric 0  √  null Handling Charge
height numeric 0  √  null Height
homedeliverypremiumdate timestamp 29,6  √  null Date
homedeliverypremiumphone varchar 30  √  NULL::character varying Phone Number
homedeliverypremiumtype varchar 30  √  NULL::character varying Home Delivery Premium Type
insurance bpchar 1  √  NULL::bpchar Insurance
insuredamount numeric 0  √  null Insured Amount
isaccessible bpchar 1 'N'::bpchar Accessible
isactive bpchar 1 'Y'::bpchar The record is active in the system
isaddedhandling bpchar 1 'N'::bpchar Added Handling
iscargoaircraftonly bpchar 1 'N'::bpchar Cargo Aircraft Only
isdryice bpchar 1 'N'::bpchar Dry Ice
isdutiable bpchar 1 'N'::bpchar Dutiable
isfuturedayshipment bpchar 1 'N'::bpchar Future Day Shipment
ishazmat bpchar 1 'N'::bpchar Hazardous Materials
isholdatlocation bpchar 1 'N'::bpchar Hold At Location
isignorezipnotfound bpchar 1 'N'::bpchar Ignore Zip Not Found
isignorezipstatenotmatch bpchar 1 'N'::bpchar Ignore Zip State Not Match
isresidential bpchar 1 'Y'::bpchar Residential
issaturdaydelivery bpchar 1 'N'::bpchar Saturday Delivery
issaturdaypickup bpchar 1 'N'::bpchar Saturday Pickup
isverbalconfirmation bpchar 1 'N'::bpchar Verbal Confirmation
latestpickuptime timestamp 29,6  √  null Latest Pickup Time
length numeric 0  √  null Length
m_inout_id numeric 10  √  NULL::numeric
m_inout.m_inout_id minout_mshippingtransaction R
Material Shipment Document
m_package_id numeric 10  √  NULL::numeric
m_package.m_package_id mpackage_mshippingtransaction R
Shipment Package
m_shipper_id numeric 10
m_shipper.m_shipper_id mshipper_mshippingtransaction R
Method or manner of product delivery
m_shipperlabels_id numeric 10  √  NULL::numeric
m_shipperlabels.m_shipperlabels_id mshipperlabels_mshippingtransa R
Shipper Labels
m_shipperpackaging_id numeric 10  √  NULL::numeric
m_shipperpackaging.m_shipperpackaging_id mshipperpackaging_mshippingtra R
Shipper Packaging
m_shipperpickuptypes_id numeric 10  √  NULL::numeric
m_shipperpickuptypes.m_shipperpickuptypes_id mshipperpickuptypes_mshippingt R
Shipper Pickup Types
m_shippingprocessor_id numeric 10  √  NULL::numeric
m_shippingprocessor.m_shippingprocessor_id mshippingprocessor_mshippingtr R
Shipping Processor
m_shippingtransaction_id numeric 10
m_shippingtransactionline.m_shippingtransaction_id mshippingtransaction_mshipping R
Shipping Transaction
m_shippingtransaction_uu varchar 36  √  NULL::character varying M_ShippingTransaction_UU
notificationmessage varchar 255  √  NULL::character varying Notification Message
notificationtype varchar 2  √  NULL::character varying Type of Notifications
paymentrule bpchar 1  √  NULL::bpchar How you pay the invoice
price numeric 0  √  null Price
priceactual numeric 0  √  null Actual Price
processed bpchar 1 'N'::bpchar The document has been processed
rateinquirymessage varchar 2000  √  NULL::character varying
receivedinfo varchar 255  √  NULL::character varying Information of the receipt of the package (acknowledgement)
shipdate timestamp 29,6  √  null Shipment Date/Time
shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
shippingrespmessage varchar 2000  √  NULL::character varying Response Message
surcharges numeric 0  √  null Surcharges
trackinginfo varchar 255  √  NULL::character varying Tracking Info
trackingno varchar 255  √  NULL::character varying Number to track the shipment
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
weight numeric 0  √  null Weight of a product
width numeric 0  √  null Width
isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
returnbpartner_id numeric 10  √  NULL::numeric
c_bpartner.c_bpartner_id returnbpartner_mshippingtransa R
Return Partner
returnlocation_id numeric 10  √  NULL::numeric
c_bpartner_location.c_bpartner_location_id returnlocation_mshippingtransa R
Return Location
returnuser_id numeric 10  √  NULL::numeric
ad_user.ad_user_id returnuser_mshippingtransactio R
Return User/Contact
codamount numeric 0  √  null COD Amount
customsvalue numeric 0  √  null Customs Value
freightamt numeric 0  √  null Freight Amount
salesrep_id numeric 10  √  NULL::numeric
ad_user.ad_user_id salesrep_mshippingtransaction R
Sales Representative or Company Agent
m_warehouse_id numeric 10  √  NULL::numeric
m_warehouse.m_warehouse_id mwarehouse_mshippingtransactio R
Storage Warehouse and Service Point
c_bpartner_id numeric 10  √  NULL::numeric
c_bpartner.c_bpartner_id cbpartner_mshippingtransaction R
Identifies a Business Partner
ad_user_id numeric 10  √  NULL::numeric
ad_user.ad_user_id aduser_mshippingtransaction R
User within the system - Internal or Business Partner Contact
poreference varchar 30  √  NULL::character varying Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice_id numeric 10  √  NULL::numeric
c_invoice.c_invoice_id cinvoice_mshippingtransaction R
Invoice Identifier
bill_location_id numeric 10  √  NULL::numeric
c_bpartner_location.c_bpartner_location_id billlocation_mshippingtransact R
Business Partner Location for invoicing
ispriviledgedrate bpchar 1 'N'::bpchar Priviledged Rate
holdaddress_id numeric 10  √  NULL::numeric
c_bpartner_location.c_bpartner_location_id holdaddress_mshippingtransacti R
Hold Address

Table contained 0 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.