Name |
Datatype |
Length |
Prcn |
DELIVERY_ID |
NUMBER
|
|
|
DELIVERY_NAME |
VARCHAR2
|
(30)
|
|
PLANNED_FLAG |
VARCHAR2
|
(1)
|
|
STATUS_CODE |
VARCHAR2
|
(2)
|
|
DELIVERY_TYPE |
VARCHAR2
|
(30)
|
|
LOADING_SEQUENCE |
NUMBER
|
|
|
LOADING_ORDER_FLAG |
VARCHAR2
|
(2)
|
|
INITIAL_PICKUP_DATE |
DATE
|
|
|
INITIAL_PICKUP_LOCATION_ID |
NUMBER
|
|
|
ORGANIZATION_ID |
NUMBER
|
|
|
ULTIMATE_DROPOFF_LOCATION_ID |
NUMBER
|
|
|
ULTIMATE_DROPOFF_DATE |
DATE
|
|
|
CUSTOMER_ID |
NUMBER
|
|
|
INTMED_SHIP_TO_LOCATION_ID |
NUMBER
|
|
|
POOLED_SHIP_TO_LOCATION_ID |
NUMBER
|
|
|
CARRIER_ID |
NUMBER
|
|
|
SHIP_METHOD_CODE |
VARCHAR2
|
(30)
|
|
FREIGHT_TERMS_CODE |
VARCHAR2
|
(30)
|
|
FOB_CODE |
VARCHAR2
|
(30)
|
|
FOB_LOCATION_ID |
NUMBER
|
|
|
WAYBILL |
VARCHAR2
|
(30)
|
|
DOCK_CODE |
VARCHAR2
|
(30)
|
|
ACCEPTANCE_FLAG |
VARCHAR2
|
(1)
|
|
ACCEPTED_BY |
VARCHAR2
|
(150)
|
|
ACCEPTED_DATE |
DATE
|
|
|
ACKNOWLEDGED_BY |
VARCHAR2
|
(150)
|
|
CONFIRMED_BY |
VARCHAR2
|
(150)
|
|
CONFIRM_DATE |
DATE
|
|
|
ASN_DATE_SENT |
DATE
|
|
|
ASN_STATUS_CODE |
VARCHAR2
|
(15)
|
|
ASN_SEQ_NUMBER |
NUMBER
|
|
|
GROSS_WEIGHT |
NUMBER
|
|
|
NET_WEIGHT |
NUMBER
|
|
|
WEIGHT_UOM_CODE |
VARCHAR2
|
(3)
|
|
VOLUME |
NUMBER
|
|
|
VOLUME_UOM_CODE |
VARCHAR2
|
(3)
|
|
ADDITIONAL_SHIPMENT_INFO |
VARCHAR2
|
(500)
|
|
CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
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)
|
|
TP_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
TP_ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
GLOBAL_ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE16 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE17 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE18 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE19 |
VARCHAR2
|
(150)
|
|
GLOBAL_ATTRIBUTE20 |
VARCHAR2
|
(150)
|
|
CREATION_DATE |
DATE
|
|
|
CREATED_BY |
NUMBER
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
REQUEST_ID |
NUMBER
|
|
|
BATCH_ID |
NUMBER
|
|
|
HASH_VALUE |
NUMBER
|
|
|
SOURCE_HEADER_ID |
NUMBER
|
|
|
NUMBER_OF_LPN |
NUMBER
|
|
|
COD_AMOUNT |
NUMBER
|
|
|
COD_CURRENCY_CODE |
VARCHAR2
|
(15)
|
|
COD_REMIT_TO |
VARCHAR2
|
(150)
|
|
COD_CHARGE_PAID_BY |
VARCHAR2
|
(150)
|
|
PROBLEM_CONTACT_REFERENCE |
VARCHAR2
|
(500)
|
|
PORT_OF_LOADING |
VARCHAR2
|
(150)
|
|
PORT_OF_DISCHARGE |
VARCHAR2
|
(150)
|
|
FTZ_NUMBER |
VARCHAR2
|
(35)
|
|
ROUTED_EXPORT_TXN |
VARCHAR2
|
(1)
|
|
ENTRY_NUMBER |
VARCHAR2
|
(35)
|
|
ROUTING_INSTRUCTIONS |
VARCHAR2
|
(120)
|
|
IN_BOND_CODE |
VARCHAR2
|
(35)
|
|
SHIPPING_MARKS |
VARCHAR2
|
(100)
|
|
SERVICE_LEVEL |
VARCHAR2
|
(30)
|
|
MODE_OF_TRANSPORT |
VARCHAR2
|
(30)
|
|
ASSIGNED_TO_FTE_TRIPS |
VARCHAR2
|
(1)
|
|
AUTO_SC_EXCLUDE_FLAG |
VARCHAR2
|
(1)
|
|
AUTO_AP_EXCLUDE_FLAG |
VARCHAR2
|
(1)
|
|
AP_BATCH_ID |
NUMBER
|
|
|
ROW_ID |
VARCHAR2
|
(4000)
|
|
LOADING_ORDER_DESC |
VARCHAR2
|
(80)
|
|
ORGANIZATION_CODE |
VARCHAR2
|
(3)
|
|
ULTIMATE_DROPOFF_LOCATION_CODE |
VARCHAR2
|
(500)
|
|
INITIAL_PICKUP_LOCATION_CODE |
VARCHAR2
|
(500)
|
|
CUSTOMER_NUMBER |
VARCHAR2
|
(30)
|
|
INTMED_SHIP_TO_LOCATION_CODE |
VARCHAR2
|
(500)
|
|
POOLED_SHIP_TO_LOCATION_CODE |
VARCHAR2
|
(500)
|
|
CARRIER_CODE |
VARCHAR2
|
(360)
|
|
SHIP_METHOD_NAME |
VARCHAR2
|
(240)
|
|
FREIGHT_TERMS_NAME |
VARCHAR2
|
(80)
|
|
FOB_NAME |
VARCHAR2
|
(80)
|
|
FOB_LOCATION_CODE |
VARCHAR2
|
(500)
|
|
WEIGHT_UOM_DESC |
VARCHAR2
|
(25)
|
|
VOLUME_UOM_DESC |
VARCHAR2
|
(25)
|
|
CURRENCY_NAME |
VARCHAR2
|
(80)
|
|
SHIPMENT_DIRECTION |
VARCHAR2
|
(30)
|
|
VENDOR_ID |
NUMBER
|
|
|
PARTY_ID |
NUMBER
|
|
|
ROUTING_RESPONSE_ID |
NUMBER
|
|
|
RCV_SHIPMENT_HEADER_ID |
NUMBER
|
|
|
ASN_SHIPMENT_HEADER_ID |
NUMBER
|
|
|
SHIPPING_CONTROL |
VARCHAR2
|
(30)
|
|
TP_DELIVERY_NUMBER |
NUMBER
|
|
|
EARLIEST_PICKUP_DATE |
DATE
|
|
|
LATEST_PICKUP_DATE |
DATE
|
|
|
EARLIEST_DROPOFF_DATE |
DATE
|
|
|
LATEST_DROPOFF_DATE |
DATE
|
|
|
IGNORE_FOR_PLANNING |
VARCHAR2
|
(1)
|
|
TP_PLAN_NAME |
VARCHAR2
|
(10)
|
|
PRORATE_WT_FLAG |
VARCHAR2
|
(1)
|
|