Name |
Datatype |
Length |
Prcn |
TRANSACTION_DATE |
DATE
|
|
|
DOCUMENT_CODE |
VARCHAR2
|
(500)
|
|
ORGANIZATION_ID |
NUMBER
|
|
|
DELIVERY_ID |
NUMBER
|
|
|
DELIVERY_NAME |
VARCHAR2
|
(500)
|
|
ORGANIZATION_CODE |
VARCHAR2
|
(500)
|
|
WAREHOUSE_LOCATION_ID |
NUMBER
|
|
|
WAREHOUSE_CODE |
VARCHAR2
|
(500)
|
|
WAREHOUSE_NAME |
VARCHAR2
|
(500)
|
|
WAREHOUSE_ADDRESS1 |
VARCHAR2
|
(500)
|
|
WAREHOUSE_ADDRESS2 |
VARCHAR2
|
(500)
|
|
WAREHOUSE_ADDRESS3 |
VARCHAR2
|
(500)
|
|
WAREHOUSE_ADDRESS4 |
VARCHAR2
|
(500)
|
|
WAREHOUSE_CITY |
VARCHAR2
|
(500)
|
|
WAREHOUSE_POSTAL_CODE |
VARCHAR2
|
(500)
|
|
WAREHOUSE_COUNTRY |
VARCHAR2
|
(500)
|
|
WAREHOUSE_COUNTY |
VARCHAR2
|
(500)
|
|
WAREHOUSE_STATE |
VARCHAR2
|
(500)
|
|
WAREHOUSE_CONTACT_NAME |
VARCHAR2
|
(500)
|
|
WAREHOUSE_CONTACT_EMAILID |
VARCHAR2
|
(500)
|
|
WAREHOUSE_CONTACT_PHONENUMBER |
VARCHAR2
|
(500)
|
|
DESTINATION_CODE |
VARCHAR2
|
(500)
|
|
DESTINATION_NAME |
VARCHAR2
|
(500)
|
|
DESTINATION_ADDRESS1 |
VARCHAR2
|
(500)
|
|
DESTINATION_ADDRESS2 |
VARCHAR2
|
(500)
|
|
DESTINATION_ADDRESS3 |
VARCHAR2
|
(500)
|
|
DESTINATION_ADDRESS4 |
VARCHAR2
|
(500)
|
|
DESTINATION_CITY |
VARCHAR2
|
(500)
|
|
DESTINATION_POSTAL_CODE |
VARCHAR2
|
(500)
|
|
DESTINATION_COUNTRY |
VARCHAR2
|
(500)
|
|
DESTINATION_STATE |
VARCHAR2
|
(500)
|
|
DESTINATION_PROVINCE |
VARCHAR2
|
(500)
|
|
DESTINATION_COUNTY |
VARCHAR2
|
(500)
|
|
DESTINATION_CONT_ID |
NUMBER
|
|
|
DESTINATION_CONT_AREA_CODE |
VARCHAR2
|
(500)
|
|
DESTINATION_CONT_PHONE_NUMBER |
VARCHAR2
|
(500)
|
|
DESTINATION_CONT_NAME |
VARCHAR2
|
(500)
|
|
DESTINATION_CONT_EMAIL |
VARCHAR2
|
(500)
|
|
DESTINATION_CONT_COUNTRY_CODE |
VARCHAR2
|
(500)
|
|
DESTINATION_CONT_PHONE_EXTN |
VARCHAR2
|
(500)
|
|
BILL_OF_LADING |
VARCHAR2
|
(500)
|
|
FREIGHT_TERMS_CODE |
VARCHAR2
|
(500)
|
|
FOB_POINT_CODE |
VARCHAR2
|
(500)
|
|
INITIAL_PICKUP_DATE |
DATE
|
|
|
PORT_OF_LOADING |
VARCHAR2
|
(500)
|
|
CHANGE_OF_OWNERSHIP |
VARCHAR2
|
(500)
|
|
DOCK_CODE |
VARCHAR2
|
(500)
|
|
STATUS_CODE |
VARCHAR2
|
(500)
|
|
CREATED_BY |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
INVOICE_TO_ORG_ID |
NUMBER
|
|
|
INVOICE_TO_CONTACT_ID |
NUMBER
|
|
|
INVOICE_NAME |
VARCHAR2
|
(500)
|
|
INVOICE_ADDRESS1 |
VARCHAR2
|
(500)
|
|
INVOICE_ADDRESS2 |
VARCHAR2
|
(500)
|
|
INVOICE_ADDRESS3 |
VARCHAR2
|
(500)
|
|
INVOICE_ADDRESS4 |
VARCHAR2
|
(500)
|
|
INVOICE_CITY |
VARCHAR2
|
(500)
|
|
INVOICE_POSTAL_CODE |
VARCHAR2
|
(500)
|
|
INVOICE_COUNTRY_INT |
VARCHAR2
|
(500)
|
|
INVOICE_STATE_INT |
VARCHAR2
|
(500)
|
|
INVOICE_PROVINCE_INT |
VARCHAR2
|
(500)
|
|
INVOICE_COUNTY |
VARCHAR2
|
(500)
|
|
INVOICE_CONT_NAME |
VARCHAR2
|
(500)
|
|
INVOICE_CONT_JOB_TITLE |
VARCHAR2
|
(500)
|
|
INVOICE_CONT_EMAIL_ADDRESS |
VARCHAR2
|
(500)
|
|
INVOICE_CONT_COUNTRY_CODE |
VARCHAR2
|
(500)
|
|
INVOICE_CONT_AREA_CODE |
VARCHAR2
|
(500)
|
|
INVOICE_CONT_PHONE_NUMBER |
VARCHAR2
|
(500)
|
|
INVOICE_CONT_PHONE_EXTN |
VARCHAR2
|
(500)
|
|
SOLDTO_CUSTOMER_ID |
NUMBER
|
|
|
SOLDTO_CONTACT_ID |
NUMBER
|
|
|
SOLDTO_ADDRESS_ID |
NUMBER
|
|
|
SOLDTO_NAME |
VARCHAR2
|
(360)
|
|
SOLDTO_ADDRESS1 |
VARCHAR2
|
(240)
|
|
SOLDTO_ADDRESS2 |
VARCHAR2
|
(240)
|
|
SOLDTO_ADDRESS3 |
VARCHAR2
|
(240)
|
|
SOLDTO_ADDRESS4 |
VARCHAR2
|
(240)
|
|
SOLDTO_CITY |
VARCHAR2
|
(60)
|
|
SOLDTO_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
SOLDTO_COUNTRY |
VARCHAR2
|
(60)
|
|
SOLDTO_STATE |
VARCHAR2
|
(60)
|
|
SOLDTO_PROVINCE |
VARCHAR2
|
(60)
|
|
SOLDTO_COUNTY |
VARCHAR2
|
(60)
|
|
SOLDTO_CONT_NAME |
VARCHAR2
|
(240)
|
|
SOLDTO_CONT_JOB_TITLE |
VARCHAR2
|
(240)
|
|
SOLDTO_CONT_EMAIL |
VARCHAR2
|
(240)
|
|
SOLDTO_CONT_COUNTRY_CODE |
VARCHAR2
|
(240)
|
|
SOLDTO_CONT_AREA_CODE |
VARCHAR2
|
(240)
|
|
SOLDTO_CONT_PHONE_NUMBER |
VARCHAR2
|
(240)
|
|
SOLDTO_CONT_PHONE_EXTN |
VARCHAR2
|
(240)
|
|
SOLDBY_LOCATION_CODE |
VARCHAR2
|
(60)
|
|
SOLDBY_COUNTRY |
VARCHAR2
|
(60)
|
|
SOLDBY_ADDRESS_LINE_1 |
VARCHAR2
|
(240)
|
|
SOLDBY_ADDRESS_LINE_2 |
VARCHAR2
|
(240)
|
|
SOLDBY_ADDRESS_LINE_3 |
VARCHAR2
|
(240)
|
|
SOLDBY_ADDRESS_LINE_4 |
VARCHAR2
|
(240)
|
|
SOLDBY_COUNTY |
VARCHAR2
|
(120)
|
|
SOLDBY_STATE |
VARCHAR2
|
(120)
|
|
SOLDBY_POSTAL_CODE |
VARCHAR2
|
(30)
|
|
SOLDBY_CITY |
VARCHAR2
|
(30)
|
|
SOLDBY_ORGANIZATION_ID |
NUMBER
|
|
|
SOLDBY_NAME |
VARCHAR2
|
(240)
|
|
SOLDBY_CONTACT_NAME |
VARCHAR2
|
(240)
|
|
SOLDBY_CONTACT_EMAILID |
VARCHAR2
|
(240)
|
|
SOLDBY_CONTACT_PHONENUMBER |
VARCHAR2
|
(240)
|
|