Name |
Datatype |
Length |
Prcn |
OTM_DOMAIN |
VARCHAR2
|
(50)
|
|
OTM_USER |
VARCHAR2
|
(50)
|
|
OTM_PASSWORD |
VARCHAR2
|
(50)
|
|
SERVER_TIMEZONE_CODE |
VARCHAR2
|
(50)
|
|
ACTION |
VARCHAR2
|
(50)
|
|
PO_HEADER_ID |
NUMBER
|
|
|
PO_RELEASE_ID |
NUMBER
|
|
|
PO_NUMBER |
VARCHAR2
|
(20)
|
|
RELEASE_NUMBER |
NUMBER
|
|
|
FREIGHT_TERMS_LOOKUP_CODE |
VARCHAR2
|
(25)
|
|
SHIPPING_CONTROL |
VARCHAR2
|
(30)
|
|
SUPPLIER_ID |
NUMBER
|
|
|
SUPPLIER_SITE_ID |
NUMBER
|
|
|
SUPPLIER_NAME |
VARCHAR2
|
(240)
|
|
SUPPLIER_ADDR_LINE_1 |
VARCHAR2
|
(240)
|
|
SUPPLIER_ADDR_LINE_2 |
VARCHAR2
|
(240)
|
|
SUPPLIER_ADDR_LINE_3 |
VARCHAR2
|
(240)
|
|
SUPPLIER_ADDR_CITY |
VARCHAR2
|
(25)
|
|
SUPPLIER_ADDR_COUNTRY |
VARCHAR2
|
(25)
|
|
SUPPLIER_SITE_CODE |
VARCHAR2
|
(15)
|
|
SUPPLIER_ADDR_ZIP |
VARCHAR2
|
(20)
|
|
SUPPLIER_ADDR_STATE_PROVINCE |
VARCHAR2
|
(150)
|
|
SUPPLIER_CONTACT_PREFIX |
VARCHAR2
|
(5)
|
|
SUPPLIER_CONTACT_FIRST_NAME |
VARCHAR2
|
(15)
|
|
SUPPLIER_CONTACT_MIDDLE_NAME |
VARCHAR2
|
(15)
|
|
SUPPLIER_CONTACT_LAST_NAME |
VARCHAR2
|
(20)
|
|
SUPPLIER_CONTACT_PHONE |
VARCHAR2
|
(15)
|
|
SUPPLIER_CONTACT_EMAIL |
VARCHAR2
|
(2000)
|
|
SUPPLIER_CONTACT_FAX |
VARCHAR2
|
(60)
|
|
ORG_ID |
NUMBER
|
|
|
ORG_NAME |
VARCHAR2
|
(240)
|
|
ORG_LOCATION_ID |
NUMBER
|
|
|
ORG_LOCATION_CODE |
VARCHAR2
|
(60)
|
|
ORG_LOC_ADDR_LINE_1 |
VARCHAR2
|
(240)
|
|
ORG_LOC_ADDR_LINE_2 |
VARCHAR2
|
(240)
|
|
ORG_LOC_ADDR_LINE_3 |
VARCHAR2
|
(240)
|
|
ORG_LOC_ADDR_CITY |
VARCHAR2
|
(30)
|
|
ORG_LOC_ADDR_COUNTRY |
VARCHAR2
|
(60)
|
|
ORG_LOC_ADDR_ZIP |
VARCHAR2
|
(30)
|
|
ORG_LOC_ADDR_STATE_PROVINCE |
VARCHAR2
|
(120)
|
|
BUYER_FIRST_NAME |
VARCHAR2
|
(150)
|
|
BUYER_LAST_NAME |
VARCHAR2
|
(150)
|
|
BUYER_PHONE |
VARCHAR2
|
(60)
|
|
BUYER_EMAIL |
VARCHAR2
|
(240)
|
|
BUYER_FAX |
VARCHAR2
|
(60)
|
|
BILL_TO_LOCATION_ID |
NUMBER
|
|
|
BILL_TO_LOCATION_CODE |
VARCHAR2
|
(60)
|
|
BILL_TO_ADDR_LINE_1 |
VARCHAR2
|
(240)
|
|
BILL_TO_ADDR_LINE_2 |
VARCHAR2
|
(240)
|
|
BILL_TO_ADDR_LINE_3 |
VARCHAR2
|
(240)
|
|
BILL_TO_ADDR_CITY |
VARCHAR2
|
(30)
|
|
BILL_TO_ADDR_COUNTRY |
VARCHAR2
|
(60)
|
|
BILL_TO_ADDR_ZIP |
VARCHAR2
|
(30)
|
|
BILL_TO_ADDR_STATE_PROVINCE |
VARCHAR2
|
(120)
|
|
TERMS |
VARCHAR2
|
(50)
|
|
SCHEDULE_LINES |
PO_OTM_SCHEDULE_LINE_TBL
|
|
|