Name |
Datatype |
Length |
Prcn |
CONTAINER_INSTANCE_ID |
NUMBER
|
|
|
LPN |
VARCHAR2
|
(50)
|
|
CONTAINER_ITEM_ID |
NUMBER
|
|
|
MASTER_SERIAL_NUMBER |
VARCHAR2
|
(30)
|
|
CONTAINER_SERIAL_NUMBER |
VARCHAR2
|
(30)
|
|
LOT_NUMBER |
VARCHAR2
|
(32)
|
|
PARENT_CONTAINER_INSTANCE_ID |
NUMBER
|
|
|
PARENT_LPN |
VARCHAR2
|
(50)
|
|
CONTAINER_TYPE |
VARCHAR2
|
(30)
|
|
CONTAINER_GROSS_WEIGHT |
NUMBER
|
|
|
CONTAINER_GROSS_WEIGHT_UOM |
VARCHAR2
|
(3)
|
|
CONTAINER_VOLUME |
NUMBER
|
|
|
CONTAINER_VOLUME_UOM |
VARCHAR2
|
(3)
|
|
CONTAINER_NET_WEIGHT |
NUMBER
|
|
|
CONTAINER_FILL_PERCENT |
NUMBER
|
|
|
CONTAINER_MAXIMUM_VOLUME |
NUMBER
|
|
|
CONTAINER_MAXIMUM_LOAD_WEIGHT |
NUMBER
|
|
|
CONTAINER_MINIMUM_FILL_PERCENT |
NUMBER
|
|
|
CONTAINER_TARE_WEIGHT |
NUMBER
|
|
|
CONTAINER_SEAL_CODE |
VARCHAR2
|
(30)
|
|
CONTAINER_TRACKING_NUMBER |
VARCHAR2
|
(30)
|
|
ITEM_DESCRIPTION |
VARCHAR2
|
(250)
|
|
DELIVERY_ID |
NUMBER
|
|
|
LPN_TYPE |
VARCHAR2
|
(100)
|
|
ORDER_BY_CUSTOMER_ID |
NUMBER
|
|
|
ORDER_BY_CONTACT_ID |
NUMBER
|
|
|
DESTINATION_CONT_ID |
NUMBER
|
|
|
INVOICE_TO_ORG_ID |
NUMBER
|
|
|
INVOICE_TO_CONTACT_ID |
NUMBER
|
|
|
CONTAINER_LEVEL |
VARCHAR2
|
(250)
|
|