Name |
Datatype |
Length |
Prcn |
DELIVERY_DETAIL_ID |
NUMBER
|
|
|
SOURCE_CODE |
VARCHAR2
|
(30)
|
|
SOURCE_HEADER_ID |
NUMBER
|
|
|
SOURCE_LINE_ID |
NUMBER
|
|
|
CUSTOMER_ID |
NUMBER
|
|
|
SOLD_TO_CONTACT_ID |
NUMBER
|
|
|
INVENTORY_ITEM_ID |
NUMBER
|
|
|
ITEM_DESCRIPTION |
VARCHAR2
|
(250)
|
|
HAZARD_CLASS_ID |
NUMBER
|
|
|
COUNTRY_OF_ORIGIN |
VARCHAR2
|
(50)
|
|
CLASSIFICATION |
VARCHAR2
|
(30)
|
|
SHIP_FROM_LOCATION_ID |
NUMBER
|
|
|
SHIP_TO_LOCATION_ID |
NUMBER
|
|
|
SHIP_TO_CONTACT_ID |
NUMBER
|
|
|
SHIP_TO_SITE_USE_ID |
NUMBER
|
|
|
DELIVER_TO_LOCATION_ID |
NUMBER
|
|
|
DELIVER_TO_CONTACT_ID |
NUMBER
|
|
|
DELIVER_TO_SITE_USE_ID |
NUMBER
|
|
|
INTMED_SHIP_TO_LOCATION_ID |
NUMBER
|
|
|
INTMED_SHIP_TO_CONTACT_ID |
NUMBER
|
|
|
HOLD_CODE |
VARCHAR2
|
(1)
|
|
SHIP_TOLERANCE_ABOVE |
NUMBER
|
|
|
SHIP_TOLERANCE_BELOW |
NUMBER
|
|
|
REQUESTED_QUANTITY |
NUMBER
|
|
|
SHIPPED_QUANTITY |
NUMBER
|
|
|
DELIVERED_QUANTITY |
NUMBER
|
|
|
REQUESTED_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
SUBINVENTORY |
VARCHAR2
|
(10)
|
|
REVISION |
VARCHAR2
|
(3)
|
|
LOT_NUMBER |
VARCHAR2
|
(32)
|
|
CUSTOMER_REQUESTED_LOT_FLAG |
VARCHAR2
|
(1)
|
|
SERIAL_NUMBER |
VARCHAR2
|
(30)
|
|
LOCATOR_ID |
NUMBER
|
|
|
DATE_REQUESTED |
DATE
|
|
|
DATE_SCHEDULED |
DATE
|
|
|
MASTER_CONTAINER_ITEM_ID |
NUMBER
|
|
|
DETAIL_CONTAINER_ITEM_ID |
NUMBER
|
|
|
LOAD_SEQ_NUMBER |
NUMBER
|
|
|
SHIP_METHOD_CODE |
VARCHAR2
|
(30)
|
|
CARRIER_ID |
NUMBER
|
|
|
FREIGHT_TERMS_CODE |
VARCHAR2
|
(30)
|
|
SHIPMENT_PRIORITY_CODE |
VARCHAR2
|
(30)
|
|
FOB_CODE |
VARCHAR2
|
(30)
|
|
CUSTOMER_ITEM_ID |
NUMBER
|
|
|
DEP_PLAN_REQUIRED_FLAG |
VARCHAR2
|
(1)
|
|
CUSTOMER_PROD_SEQ |
VARCHAR2
|
(50)
|
|
CUSTOMER_DOCK_CODE |
VARCHAR2
|
(50)
|
|
CUST_MODEL_SERIAL_NUMBER |
VARCHAR2
|
(50)
|
|
CUSTOMER_JOB |
VARCHAR2
|
(50)
|
|
CUSTOMER_PRODUCTION_LINE |
VARCHAR2
|
(50)
|
|
NET_WEIGHT |
NUMBER
|
|
|
WEIGHT_UOM_CODE |
VARCHAR2
|
(3)
|
|
VOLUME |
NUMBER
|
|
|
VOLUME_UOM_CODE |
VARCHAR2
|
(3)
|
|
TP_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
TP_ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE_CATEGORY |
VARCHAR2
|
(150)
|
|
ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
CREATED_BY |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
REQUEST_ID |
NUMBER
|
|
|
MVT_STAT_STATUS |
VARCHAR2
|
(30)
|
|
RELEASED_FLAG |
VARCHAR2
|
(1)
|
|
ORGANIZATION_ID |
NUMBER
|
|
|
TRANSACTION_TEMP_ID |
NUMBER
|
|
|
SHIP_SET_ID |
NUMBER
|
|
|
ARRIVAL_SET_ID |
NUMBER
|
|
|
SHIP_MODEL_COMPLETE_FLAG |
VARCHAR2
|
(1)
|
|
TOP_MODEL_LINE_ID |
NUMBER
|
|
|
SOURCE_HEADER_NUMBER |
VARCHAR2
|
(150)
|
|
SOURCE_HEADER_TYPE_ID |
NUMBER
|
|
|
SOURCE_HEADER_TYPE_NAME |
VARCHAR2
|
(240)
|
|
CUST_PO_NUMBER |
VARCHAR2
|
(50)
|
|
ATO_LINE_ID |
NUMBER
|
|
|
SRC_REQUESTED_QUANTITY |
NUMBER
|
|
|
SRC_REQUESTED_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
MOVE_ORDER_LINE_ID |
NUMBER
|
|
|
CANCELLED_QUANTITY |
NUMBER
|
|
|
QUALITY_CONTROL_QUANTITY |
NUMBER
|
|
|
CYCLE_COUNT_QUANTITY |
NUMBER
|
|
|
TRACKING_NUMBER |
VARCHAR2
|
(30)
|
|
MOVEMENT_ID |
NUMBER
|
|
|
SHIPPING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
PACKING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
PROJECT_ID |
NUMBER
|
|
|
TASK_ID |
NUMBER
|
|
|
ORG_ID |
NUMBER
|
|
|
OE_INTERFACED_FLAG |
VARCHAR2
|
(1)
|
|
SPLIT_FROM_DETAIL_ID |
NUMBER
|
|
|
INV_INTERFACED_FLAG |
VARCHAR2
|
(1)
|
|
SOURCE_LINE_NUMBER |
VARCHAR2
|
(150)
|
|
INSPECTION_FLAG |
VARCHAR2
|
(1)
|
|
RELEASED_STATUS |
VARCHAR2
|
(1)
|
|
CONTAINER_FLAG |
VARCHAR2
|
(1)
|
|
CONTAINER_TYPE_CODE |
VARCHAR2
|
(30)
|
|
CONTAINER_NAME |
VARCHAR2
|
(30)
|
|
FILL_PERCENT |
NUMBER
|
|
|
GROSS_WEIGHT |
NUMBER
|
|
|
MASTER_SERIAL_NUMBER |
VARCHAR2
|
(30)
|
|
MAXIMUM_LOAD_WEIGHT |
NUMBER
|
|
|
MAXIMUM_VOLUME |
NUMBER
|
|
|
MINIMUM_FILL_PERCENT |
NUMBER
|
|
|
SEAL_CODE |
VARCHAR2
|
(30)
|
|
UNIT_NUMBER |
VARCHAR2
|
(30)
|
|
UNIT_PRICE |
NUMBER
|
|
|
CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
FREIGHT_CLASS_CAT_ID |
NUMBER
|
|
|
COMMODITY_CODE_CAT_ID |
NUMBER
|
|
|
PREFERRED_GRADE |
VARCHAR2
|
(4)
|
|
SRC_REQUESTED_QUANTITY2 |
NUMBER
|
|
|
SRC_REQUESTED_QUANTITY_UOM2 |
VARCHAR2
|
(3)
|
|
REQUESTED_QUANTITY2 |
NUMBER
|
|
|
SHIPPED_QUANTITY2 |
NUMBER
|
|
|
DELIVERED_QUANTITY2 |
NUMBER
|
|
|
CANCELLED_QUANTITY2 |
NUMBER
|
|
|
QUALITY_CONTROL_QUANTITY2 |
NUMBER
|
|
|
CYCLE_COUNT_QUANTITY2 |
NUMBER
|
|
|
REQUESTED_QUANTITY_UOM2 |
VARCHAR2
|
(3)
|
|
SUBLOT_NUMBER |
VARCHAR2
|
(32)
|
|
LPN_ID |
NUMBER
|
|
|
PICKABLE_FLAG |
VARCHAR2
|
(1)
|
|
ORIGINAL_SUBINVENTORY |
VARCHAR2
|
(10)
|
|
TO_SERIAL_NUMBER |
VARCHAR2
|
(30)
|
|
PICKED_QUANTITY |
NUMBER
|
|
|
PICKED_QUANTITY2 |
NUMBER
|
|
|
RECEIVED_QUANTITY |
NUMBER
|
|
|
RECEIVED_QUANTITY2 |
NUMBER
|
|
|
SOURCE_LINE_SET_ID |
NUMBER
|
|
|
BATCH_ID |
NUMBER
|
|
|
ROW_ID |
VARCHAR2
|
(4000)
|
|
TRANSACTION_ID |
NUMBER
|
|
|
VENDOR_ID |
NUMBER
|
|
|
SHIP_FROM_SITE_ID |
NUMBER
|
|
|
LINE_DIRECTION |
VARCHAR2
|
(30)
|
|
PARTY_ID |
NUMBER
|
|
|
ROUTING_REQ_ID |
NUMBER
|
|
|
SHIPPING_CONTROL |
VARCHAR2
|
(30)
|
|
SOURCE_BLANKET_REFERENCE_ID |
NUMBER
|
|
|
SOURCE_BLANKET_REFERENCE_NUM |
NUMBER
|
|
|
PO_SHIPMENT_LINE_ID |
NUMBER
|
|
|
PO_SHIPMENT_LINE_NUMBER |
NUMBER
|
|
|
RETURNED_QUANTITY |
NUMBER
|
|
|
RETURNED_QUANTITY2 |
NUMBER
|
|
|
RCV_SHIPMENT_LINE_ID |
NUMBER
|
|
|
SOURCE_LINE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
SUPPLIER_ITEM_NUMBER |
VARCHAR2
|
(50)
|
|
IGNORE_FOR_PLANNING |
VARCHAR2
|
(1)
|
|
EARLIEST_PICKUP_DATE |
DATE
|
|
|
LATEST_PICKUP_DATE |
DATE
|
|
|
EARLIEST_DROPOFF_DATE |
DATE
|
|
|
LATEST_DROPOFF_DATE |
DATE
|
|
|
REQUEST_DATE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
TP_DELIVERY_DETAIL_ID |
NUMBER
|
|
|
SOURCE_DOCUMENT_TYPE_ID |
NUMBER
|
|
|