Table idempiere9.adempiere.m_package
Shipment Package

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
m_package_id numeric 10
m_packageline.m_package_id mpackage_mpackageline R
m_packagemps.m_package_id mpackage_mpackagemps R
m_shippingtransaction.m_package_id mpackage_mshippingtransaction R
Shipment Package
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
documentno varchar 30 Document sequence number of the document
m_inout_id numeric 10
m_inout.m_inout_id minout_mpackage R
Material Shipment Document
description varchar 255  √  null Optional short description of the record
m_shipper_id numeric 10
m_shipper.m_shipper_id mshipper_mpackage R
Method or manner of product delivery
trackinginfo varchar 255  √  null Tracking Info
datereceived timestamp 29,6  √  null Date a product was received
receivedinfo varchar 255  √  null Information of the receipt of the package (acknowledgement)
shipdate timestamp 29,6  √  null Shipment Date/Time
m_package_uu varchar 36  √  NULL::character varying M_Package_UU
boxcount numeric 10  √  (1)::numeric Box Count
cashondelivery bpchar 1 'N'::bpchar COD
c_bpartner_location_id numeric 10  √  NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_mpackage R
Identifies the (ship to) address for this Business Partner
c_currency_id numeric 10  √  NULL::numeric
c_currency.c_currency_id ccurrency_mpackage R
The Currency for this record
c_uom_length_id numeric 10  √  NULL::numeric
c_uom.c_uom_id cuomlength_mpackage R
Standard Unit of Measure for Length
c_uom_weight_id numeric 10  √  NULL::numeric
c_uom.c_uom_id cuomweight_mpackage R
Standard Unit of Measure for Weight
deliveryconfirmation bpchar 1 'N'::bpchar EMail Delivery confirmation
dothazardclassordivision varchar 30  √  NULL::character varying Dot Hazard Class or Division
handlingcharge numeric 0  √  null Handling Charge
height numeric 0  √  null Height
homedeliverypremiumdate timestamp 29,6  √  null Date
homedeliverypremiumtype varchar 30  √  NULL::character varying Home Delivery Premium Type
insuredamount numeric 0  √  null Insured Amount
isaccessible bpchar 1 'N'::bpchar Accessible
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
labelprint bpchar 1  √  NULL::bpchar Label Print
latestpickuptime timestamp 29,6  √  null Latest Pickup Time
length numeric 0  √  null Length
notificationtype varchar 2  √  NULL::character varying Type of Notifications
oprocessing bpchar 1  √  NULL::bpchar This payment can be processed online
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 Rate Inquiry Message
issaturdaydelivery bpchar 1 'N'::bpchar Saturday Delivery
issaturdaypickup bpchar 1 'N'::bpchar Saturday Pickup
shippingrateinquiry bpchar 1  √  NULL::bpchar Rate Inquiry
shippingrespmessage varchar 2000  √  NULL::character varying Response Message
surcharges numeric 0  √  null Surcharges
trackingno varchar 255  √  NULL::character varying Number to track the shipment
voidit bpchar 1  √  NULL::bpchar Void It
weight numeric 0  √  null Weight of a product
width numeric 0  √  null Width
c_bp_shippingacct_id numeric 10  √  NULL::numeric
c_bp_shippingacct.c_bp_shippingacct_id cbpshippingacct_mpackage R
Business Partner Shipping Account
dutiesshipperaccount varchar 40  √  NULL::character varying Duties Shipper Account
m_shipperlabels_id numeric 10  √  NULL::numeric
m_shipperlabels.m_shipperlabels_id mshipperlabels_mpackage R
Shipper Labels
m_shipperpackaging_id numeric 10  √  NULL::numeric
m_shipperpackaging.m_shipperpackaging_id mshipperpackaging_mpackage R
Shipper Packaging
m_shipperpickuptypes_id numeric 10  √  NULL::numeric
m_shipperpickuptypes.m_shipperpickuptypes_id mshipperpickuptypes_mpackage R
Shipper Pickup Types
shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
homedeliverypremiumphone varchar 30  √  NULL::character varying Phone Number
dryiceweight numeric 0  √  null Dry Ice Weight
notificationmessage varchar 255  √  NULL::character varying Notification Message
isverbalconfirmation bpchar 1 'N'::bpchar Verbal Confirmation
isaddedhandling bpchar 1 'N'::bpchar Added Handling
paymentrule bpchar 1  √  NULL::bpchar How you pay the invoice
deliveryconfirmationtype varchar 30  √  NULL::character varying Delivery Confirmation Type
holdaddress_id numeric 10  √  NULL::numeric
c_bpartner_location.c_bpartner_location_id holdaddress_mpackage R
Hold Address

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

Indexes:
Column(s) Type Sort Constraint Name
m_package_id Primary key Asc m_package_pkey
m_package_uu Must be unique Asc m_package_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.