Name |
Datatype |
Length |
Prcn |
ACCOUNTING_RULE_ID |
NUMBER
|
|
|
AGREEMENT_ID |
NUMBER
|
|
|
ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE16 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE17 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE18 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE19 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
BOOKED_FLAG |
VARCHAR2
|
(1)
|
|
CANCELLED_FLAG |
VARCHAR2
|
(1)
|
|
CONTEXT |
VARCHAR2
|
(30)
|
|
CONVERSION_RATE |
NUMBER
|
|
|
CONVERSION_RATE_DATE |
DATE
|
|
|
CONVERSION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
CUSTOMER_PREFERENCE_SET_CODE |
VARCHAR2
|
(30)
|
|
CREATED_BY |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
CUST_PO_NUMBER |
VARCHAR2
|
(50)
|
|
DELIVER_TO_CONTACT_ID |
NUMBER
|
|
|
DELIVER_TO_ORG_ID |
NUMBER
|
|
|
DEMAND_CLASS_CODE |
VARCHAR2
|
(30)
|
|
EARLIEST_SCHEDULE_LIMIT |
NUMBER
|
|
|
EXPIRATION_DATE |
DATE
|
|
|
FOB_POINT_CODE |
VARCHAR2
|
(30)
|
|
FREIGHT_CARRIER_CODE |
VARCHAR2
|
(30)
|
|
FREIGHT_TERMS_CODE |
VARCHAR2
|
(30)
|
|
GLOBAL_ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE16 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE17 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE18 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE19 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
TP_CONTEXT |
VARCHAR2
|
(30)
|
|
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)
|
|
HEADER_ID |
NUMBER
|
|
|
INVOICE_TO_CONTACT_ID |
NUMBER
|
|
|
INVOICE_TO_ORG_ID |
NUMBER
|
|
|
INVOICING_RULE_ID |
NUMBER
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
LATEST_SCHEDULE_LIMIT |
NUMBER
|
|
|
OPEN_FLAG |
VARCHAR2
|
(1)
|
|
ORDER_CATEGORY_CODE |
VARCHAR2
|
(30)
|
|
ORDERED_DATE |
DATE
|
|
|
ORDER_DATE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
ORDER_NUMBER |
NUMBER
|
|
|
ORDER_SOURCE_ID |
NUMBER
|
|
|
ORDER_TYPE_ID |
NUMBER
|
|
|
ORG_ID |
NUMBER
|
|
|
ORIG_SYS_DOCUMENT_REF |
VARCHAR2
|
(50)
|
|
PARTIAL_SHIPMENTS_ALLOWED |
VARCHAR2
|
(1)
|
|
PAYMENT_TERM_ID |
NUMBER
|
|
|
PRICE_LIST_ID |
NUMBER
|
|
|
PRICE_REQUEST_CODE |
VARCHAR2
|
(240)
|
|
PRICING_DATE |
DATE
|
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
REQUEST_DATE |
DATE
|
|
|
REQUEST_ID |
NUMBER
|
|
|
RETURN_REASON_CODE |
VARCHAR2
|
(30)
|
|
SALESREP_ID |
NUMBER
|
|
|
SALES_CHANNEL_CODE |
VARCHAR2
|
(30)
|
|
SHIPMENT_PRIORITY_CODE |
VARCHAR2
|
(30)
|
|
SHIPPING_METHOD_CODE |
VARCHAR2
|
(30)
|
|
SHIP_FROM_ORG_ID |
NUMBER
|
|
|
SHIP_TOLERANCE_ABOVE |
NUMBER
|
|
|
SHIP_TOLERANCE_BELOW |
NUMBER
|
|
|
SHIP_TO_CONTACT_ID |
NUMBER
|
|
|
SHIP_TO_ORG_ID |
NUMBER
|
|
|
SOLD_FROM_ORG_ID |
NUMBER
|
|
|
SOLD_TO_CONTACT_ID |
NUMBER
|
|
|
SOLD_TO_ORG_ID |
NUMBER
|
|
|
SOLD_TO_PHONE_ID |
NUMBER
|
|
|
SOURCE_DOCUMENT_ID |
NUMBER
|
|
|
SOURCE_DOCUMENT_TYPE_ID |
NUMBER
|
|
|
TAX_EXEMPT_FLAG |
VARCHAR2
|
(30)
|
|
TAX_EXEMPT_NUMBER |
VARCHAR2
|
(80)
|
|
TAX_EXEMPT_REASON_CODE |
VARCHAR2
|
(30)
|
|
TAX_POINT_CODE |
VARCHAR2
|
(30)
|
|
TRANSACTIONAL_CURR_CODE |
VARCHAR2
|
(15)
|
|
VERSION_NUMBER |
NUMBER
|
|
|
RETURN_STATUS |
VARCHAR2
|
(1)
|
|
DB_FLAG |
VARCHAR2
|
(1)
|
|
OPERATION |
VARCHAR2
|
(30)
|
|
FIRST_ACK_CODE |
VARCHAR2
|
(30)
|
|
FIRST_ACK_DATE |
DATE
|
|
|
LAST_ACK_CODE |
VARCHAR2
|
(30)
|
|
LAST_ACK_DATE |
DATE
|
|
|
CHANGE_REASON |
VARCHAR2
|
(30)
|
|
CHANGE_COMMENTS |
VARCHAR2
|
(2000)
|
|
CHANGE_SEQUENCE |
VARCHAR2
|
(50)
|
|
CHANGE_REQUEST_CODE |
VARCHAR2
|
(30)
|
|
READY_FLAG |
VARCHAR2
|
(1)
|
|
STATUS_FLAG |
VARCHAR2
|
(1)
|
|
FORCE_APPLY_FLAG |
VARCHAR2
|
(1)
|
|
DROP_SHIP_FLAG |
VARCHAR2
|
(1)
|
|
CUSTOMER_PAYMENT_TERM_ID |
NUMBER
|
|
|
PAYMENT_TYPE_CODE |
VARCHAR2
|
(30)
|
|
PAYMENT_AMOUNT |
NUMBER
|
|
|
CHECK_NUMBER |
VARCHAR2
|
(50)
|
|
CREDIT_CARD_CODE |
VARCHAR2
|
(80)
|
|
CREDIT_CARD_HOLDER_NAME |
VARCHAR2
|
(80)
|
|
CREDIT_CARD_NUMBER |
VARCHAR2
|
(80)
|
|
CREDIT_CARD_EXPIRATION_DATE |
DATE
|
|
|
CREDIT_CARD_APPROVAL_CODE |
VARCHAR2
|
(80)
|
|
CREDIT_CARD_APPROVAL_DATE |
DATE
|
|
|
SHIPPING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
PACKING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
FLOW_STATUS_CODE |
VARCHAR2
|
(30)
|
|
BOOKED_DATE |
DATE
|
|
|
MARKETING_SOURCE_CODE_ID |
NUMBER
|
|
|
UPGRADED_FLAG |
VARCHAR2
|
(1)
|
|
LOCK_CONTROL |
NUMBER
|
|
|
SHIP_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
SOLD_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
BILL_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
SHIP_FROM_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
SHIP_FROM_ADDRESS_ID |
NUMBER
|
|
|
SOLD_TO_ADDRESS_ID |
NUMBER
|
|
|
SHIP_TO_ADDRESS_ID |
NUMBER
|
|
|
INVOICE_ADDRESS_ID |
NUMBER
|
|
|
SHIP_TO_ADDRESS_CODE |
VARCHAR2
|
(40)
|
|
XML_MESSAGE_ID |
NUMBER
|
|
|
SHIP_TO_CUSTOMER_ID |
NUMBER
|
|
|
INVOICE_TO_CUSTOMER_ID |
NUMBER
|
|
|
DELIVER_TO_CUSTOMER_ID |
NUMBER
|
|
|
ACCOUNTING_RULE_DURATION |
NUMBER
|
|
|
XML_TRANSACTION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
BLANKET_NUMBER |
NUMBER
|
|
|
LINE_SET_NAME |
VARCHAR2
|
(30)
|
|
FULFILLMENT_SET_NAME |
VARCHAR2
|
(30)
|
|
DEFAULT_FULFILLMENT_SET |
VARCHAR2
|
(1)
|
|
QUOTE_DATE |
DATE
|
|
|
QUOTE_NUMBER |
NUMBER
|
|
|
SALES_DOCUMENT_NAME |
VARCHAR2
|
(240)
|
|
TRANSACTION_PHASE_CODE |
VARCHAR2
|
(30)
|
|
USER_STATUS_CODE |
VARCHAR2
|
(30)
|
|
DRAFT_SUBMITTED_FLAG |
VARCHAR2
|
(1)
|
|
SOURCE_DOCUMENT_VERSION_NUMBER |
NUMBER
|
|
|
SOLD_TO_SITE_USE_ID |
NUMBER
|
|
|
MINISITE_ID |
NUMBER
|
|
|
IB_OWNER |
VARCHAR2
|
(60)
|
|
IB_INSTALLED_AT_LOCATION |
VARCHAR2
|
(60)
|
|
IB_CURRENT_LOCATION |
VARCHAR2
|
(60)
|
|
END_CUSTOMER_ID |
NUMBER
|
|
|
END_CUSTOMER_CONTACT_ID |
NUMBER
|
|
|
END_CUSTOMER_SITE_USE_ID |
NUMBER
|
|
|
SUPPLIER_SIGNATURE |
VARCHAR2
|
(240)
|
|
SUPPLIER_SIGNATURE_DATE |
DATE
|
|
|
CUSTOMER_SIGNATURE |
VARCHAR2
|
(240)
|
|
CUSTOMER_SIGNATURE_DATE |
DATE
|
|
|
SOLD_TO_PARTY_ID |
NUMBER
|
|
|
SOLD_TO_ORG_CONTACT_ID |
NUMBER
|
|
|
SHIP_TO_PARTY_ID |
NUMBER
|
|
|
SHIP_TO_PARTY_SITE_ID |
NUMBER
|
|
|
SHIP_TO_PARTY_SITE_USE_ID |
NUMBER
|
|
|
DELIVER_TO_PARTY_ID |
NUMBER
|
|
|
DELIVER_TO_PARTY_SITE_ID |
NUMBER
|
|
|
DELIVER_TO_PARTY_SITE_USE_ID |
NUMBER
|
|
|
INVOICE_TO_PARTY_ID |
NUMBER
|
|
|
INVOICE_TO_PARTY_SITE_ID |
NUMBER
|
|
|
INVOICE_TO_PARTY_SITE_USE_ID |
NUMBER
|
|
|
END_CUSTOMER_PARTY_ID |
NUMBER
|
|
|
END_CUSTOMER_PARTY_SITE_ID |
NUMBER
|
|
|
END_CUSTOMER_PARTY_SITE_USE_ID |
NUMBER
|
|
|
END_CUSTOMER_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
END_CUSTOMER_ORG_CONTACT_ID |
NUMBER
|
|
|
SHIP_TO_CUSTOMER_PARTY_ID |
NUMBER
|
|
|
DELIVER_TO_CUSTOMER_PARTY_ID |
NUMBER
|
|
|
INVOICE_TO_CUSTOMER_PARTY_ID |
NUMBER
|
|
|
SHIP_TO_ORG_CONTACT_ID |
NUMBER
|
|
|
DELIVER_TO_ORG_CONTACT_ID |
NUMBER
|
|
|
INVOICE_TO_ORG_CONTACT_ID |
NUMBER
|
|
|
CONTRACT_TEMPLATE_ID |
NUMBER
|
|
|
CONTRACT_SOURCE_DOC_TYPE_CODE |
VARCHAR2
|
(30)
|
|
CONTRACT_SOURCE_DOCUMENT_ID |
NUMBER
|
|
|
SOLD_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
SHIP_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
INVOICE_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
DELIVER_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
ORDER_FIRMED_DATE |
DATE
|
|
|