Name |
Datatype |
Length |
Prcn |
IB_OWNER_CODE |
VARCHAR2
|
(30)
|
|
IB_CURRENT_LOCATION_CODE |
VARCHAR2
|
(30)
|
|
IB_INSTALLED_AT_LOCATION_CODE |
VARCHAR2
|
(30)
|
|
INVOICE_CUSTOMER_ID |
NUMBER
|
|
|
DELIVER_TO_CUSTOMER_ID |
NUMBER
|
|
|
ACCOUNTING_RULE_DURATION |
NUMBER
|
|
|
ATTRIBUTE16 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE17 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE18 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE19 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
ACKNOWLEDGMENT_TYPE |
VARCHAR2
|
(30)
|
|
BLANKET_NUMBER |
NUMBER
|
|
|
BOOKED_DATE |
DATE
|
|
|
FLOW_STATUS_CODE |
VARCHAR2
|
(30)
|
|
CREDIT_CARD_APPROVAL_DATE |
DATE
|
|
|
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)
|
|
CUSTOMER_PREFERENCE_SET_CODE |
VARCHAR2
|
(30)
|
|
SALES_CHANNEL_CODE |
VARCHAR2
|
(30)
|
|
SOLD_TO_PHONE_ID |
NUMBER
|
|
|
SHIP_TO_PROVINCE |
VARCHAR2
|
(240)
|
|
SHIP_TO_SITE_INT |
VARCHAR2
|
(30)
|
|
SHIP_TO_STATE |
VARCHAR2
|
(240)
|
|
SHIP_TOLERANCE_ABOVE |
NUMBER
|
|
|
SHIP_TOLERANCE_BELOW |
NUMBER
|
|
|
SHIPMENT_PRIORITY |
VARCHAR2
|
(80)
|
|
SHIPMENT_PRIORITY_CODE |
VARCHAR2
|
(30)
|
|
SHIPMENT_PRIORITY_CODE_INT |
VARCHAR2
|
(30)
|
|
SHIPPING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
SHIPPING_METHOD |
VARCHAR2
|
(80)
|
|
SHIPPING_METHOD_CODE |
VARCHAR2
|
(30)
|
|
SOLD_TO_CONTACT |
VARCHAR2
|
(330)
|
|
SOLD_TO_CONTACT_ID |
NUMBER
|
|
|
SOURCE_DOCUMENT_ID |
NUMBER
|
|
|
SOURCE_DOCUMENT_TYPE_ID |
NUMBER
|
|
|
SUBMISSION_DATETIME |
DATE
|
|
|
TAX_EXEMPT_FLAG |
VARCHAR2
|
(30)
|
|
TAX_EXEMPT_NUMBER |
VARCHAR2
|
(80)
|
|
TAX_EXEMPT_REASON |
VARCHAR2
|
(80)
|
|
TAX_EXEMPT_REASON_CODE |
VARCHAR2
|
(30)
|
|
TAX_POINT |
VARCHAR2
|
(80)
|
|
TAX_POINT_CODE |
VARCHAR2
|
(30)
|
|
TRANSACTIONAL_CURR |
VARCHAR2
|
(80)
|
|
TRANSACTIONAL_CURR_CODE |
VARCHAR2
|
(15)
|
|
VERSION_NUMBER |
NUMBER
|
|
|
CUSTOMER_PAYMENT_TERM_ID |
NUMBER
|
|
|
DROP_SHIP_FLAG |
VARCHAR2
|
(1)
|
|
ORDER_CATEGORY_CODE |
VARCHAR2
|
(30)
|
|
SOLD_TO_ADDRESS1 |
VARCHAR2
|
(240)
|
|
SOLD_TO_ADDRESS2 |
VARCHAR2
|
(240)
|
|
SOLD_TO_ADDRESS3 |
VARCHAR2
|
(240)
|
|
SOLD_TO_ADDRESS4 |
VARCHAR2
|
(240)
|
|
SOLD_TO_CITY |
VARCHAR2
|
(240)
|
|
SOLD_TO_POSTAL_CODE |
VARCHAR2
|
(240)
|
|
SOLD_TO_COUNTRY |
VARCHAR2
|
(240)
|
|
SOLD_TO_STATE |
VARCHAR2
|
(240)
|
|
SOLD_TO_COUNTY |
VARCHAR2
|
(240)
|
|
SOLD_TO_PROVINCE |
VARCHAR2
|
(240)
|
|
SOLD_TO_CONTACT_LAST_NAME |
VARCHAR2
|
(240)
|
|
SOLD_TO_CONTACT_FIRST_NAME |
VARCHAR2
|
(240)
|
|
SHIP_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
SOLD_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
BILL_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
CUSTOMER_PAYMENT_TERM |
VARCHAR2
|
(30)
|
|
SHIP_FROM_ADDRESS_1 |
VARCHAR2
|
(240)
|
|
SHIP_FROM_ADDRESS_2 |
VARCHAR2
|
(240)
|
|
SHIP_FROM_ADDRESS_3 |
VARCHAR2
|
(240)
|
|
SHIP_FROM_CITY |
VARCHAR2
|
(60)
|
|
SHIP_FROM_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
SHIP_FROM_COUNTRY |
VARCHAR2
|
(60)
|
|
SHIP_FROM_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
SHIP_FROM_REGION1 |
VARCHAR2
|
(240)
|
|
SHIP_FROM_REGION2 |
VARCHAR2
|
(240)
|
|
SHIP_FROM_REGION3 |
VARCHAR2
|
(240)
|
|
SHIP_FROM_ADDRESS_ID |
NUMBER
|
|
|
SOLD_TO_ADDRESS_ID |
NUMBER
|
|
|
SHIP_TO_ADDRESS_ID |
NUMBER
|
|
|
INVOICE_ADDRESS_ID |
NUMBER
|
|
|
SHIP_TO_ADDRESS_CODE |
VARCHAR2
|
(240)
|
|
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)
|
|
XML_MESSAGE_ID |
NUMBER
|
|
|
SHIP_TO_CUSTOMER_ID |
NUMBER
|
|
|
ORDER_FIRMED_DATE |
DATE
|
|
|
DELIVER_TO_ADDRESS1 |
VARCHAR2
|
(240)
|
|
DELIVER_TO_ADDRESS2 |
VARCHAR2
|
(240)
|
|
DELIVER_TO_ADDRESS3 |
VARCHAR2
|
(240)
|
|
DELIVER_TO_ADDRESS4 |
VARCHAR2
|
(240)
|
|
DELIVER_TO_CITY |
VARCHAR2
|
(60)
|
|
DELIVER_TO_COUNTRY |
VARCHAR2
|
(60)
|
|
DELIVER_TO_COUNTY |
VARCHAR2
|
(60)
|
|
DELIVER_TO_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
DELIVER_TO_PROVINCE |
VARCHAR2
|
(60)
|
|
TRANSACTION_PHASE_CODE |
VARCHAR2
|
(30)
|
|
SALES_DOCUMENT_NAME |
VARCHAR2
|
(240)
|
|
QUOTE_NUMBER |
NUMBER
|
|
|
QUOTE_DATE |
DATE
|
|
|
USER_STATUS_CODE |
VARCHAR2
|
(30)
|
|
SOLD_TO_SITE_USE_ID |
NUMBER
|
|
|
SUPPLIER_SIGNATURE |
VARCHAR2
|
(240)
|
|
SUPPLIER_SIGNATURE_DATE |
DATE
|
|
|
CUSTOMER_SIGNATURE |
VARCHAR2
|
(240)
|
|
CUSTOMER_SIGNATURE_DATE |
DATE
|
|
|
SOLD_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
SHIP_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
INVOICE_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
DELIVER_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
END_CUSTOMER_NUMBER |
VARCHAR2
|
(50)
|
|
END_CUSTOMER_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
END_CUSTOMER_ID |
NUMBER
|
|
|
END_CUSTOMER_CONTACT_ID |
NUMBER
|
|
|
END_CUSTOMER_SITE_USE_ID |
NUMBER
|
|
|
END_CUSTOMER_ADDRESS1 |
VARCHAR2
|
(240)
|
|
END_CUSTOMER_ADDRESS2 |
VARCHAR2
|
(240)
|
|
END_CUSTOMER_ADDRESS3 |
VARCHAR2
|
(240)
|
|
END_CUSTOMER_ADDRESS4 |
VARCHAR2
|
(240)
|
|
END_CUSTOMER_CITY |
VARCHAR2
|
(60)
|
|
END_CUSTOMER_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
END_CUSTOMER_COUNTRY |
VARCHAR2
|
(60)
|
|
END_CUSTOMER_STATE |
VARCHAR2
|
(60)
|
|
END_CUSTOMER_COUNTY |
VARCHAR2
|
(60)
|
|
END_CUSTOMER_PROVINCE |
VARCHAR2
|
(60)
|
|
END_CUSTOMER_CONTACT |
VARCHAR2
|
(360)
|
|
END_CUSTOMER_CONTACT_LAST_NAME |
VARCHAR2
|
(240)
|
|
END_CUSTOMER_CONTACT_FIRST_NAM |
VARCHAR2
|
(240)
|
|
END_CUSTOMER_NAME |
VARCHAR2
|
(360)
|
|
IB_OWNER |
VARCHAR2
|
(60)
|
|
IB_CURRENT_LOCATION |
VARCHAR2
|
(60)
|
|
IB_INSTALLED_AT_LOCATION |
VARCHAR2
|
(60)
|
|
SOLD_TO_LOCATION_ADDRESS1 |
VARCHAR2
|
(240)
|
|
SOLD_TO_LOCATION_ADDRESS2 |
VARCHAR2
|
(240)
|
|
SOLD_TO_LOCATION_ADDRESS3 |
VARCHAR2
|
(240)
|
|
SOLD_TO_LOCATION_ADDRESS4 |
VARCHAR2
|
(240)
|
|
SOLD_TO_LOCATION_CITY |
VARCHAR2
|
(60)
|
|
SOLD_TO_LOCATION_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
SOLD_TO_LOCATION_COUNTRY |
VARCHAR2
|
(60)
|
|
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_ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
HEADER_PO_CONTEXT |
VARCHAR2
|
(30)
|
|
INTERFACE_STATUS |
VARCHAR2
|
(1000)
|
|
INVOICE_ADDRESS_1 |
VARCHAR2
|
(240)
|
|
INVOICE_ADDRESS_2 |
VARCHAR2
|
(240)
|
|
INVOICE_ADDRESS_3 |
VARCHAR2
|
(240)
|
|
INVOICE_ADDRESS_4 |
VARCHAR2
|
(240)
|
|
INVOICE_CITY |
VARCHAR2
|
(240)
|
|
INVOICE_COUNTRY |
VARCHAR2
|
(240)
|
|
INVOICE_COUNTY |
VARCHAR2
|
(240)
|
|
INVOICE_CUSTOMER |
VARCHAR2
|
(360)
|
|
INVOICE_CUSTOMER_NUMBER |
VARCHAR2
|
(50)
|
|
INVOICE_POSTAL_CODE |
VARCHAR2
|
(240)
|
|
INVOICE_PROVINCE_INT |
VARCHAR2
|
(240)
|
|
INVOICE_SITE |
VARCHAR2
|
(30)
|
|
INVOICE_SITE_CODE |
VARCHAR2
|
(240)
|
|
INVOICE_STATE |
VARCHAR2
|
(240)
|
|
INVOICE_TO_CONTACT |
VARCHAR2
|
(330)
|
|
INVOICE_TO_CONTACT_FIRST_NAME |
VARCHAR2
|
(240)
|
|
INVOICE_TO_CONTACT_ID |
NUMBER
|
|
|
INVOICE_TO_CONTACT_LAST_NAME |
VARCHAR2
|
(240)
|
|
INVOICE_TO_ORG |
VARCHAR2
|
(240)
|
|
INVOICE_TO_ORG_ID |
NUMBER
|
|
|
INVOICE_TOLERANCE_ABOVE |
NUMBER
|
|
|
INVOICE_TOLERANCE_BELOW |
NUMBER
|
|
|
INVOICING_RULE |
VARCHAR2
|
(30)
|
|
INVOICING_RULE_ID |
NUMBER
|
|
|
OPEN_FLAG |
VARCHAR2
|
(1)
|
|
OPERATION_CODE |
VARCHAR2
|
(30)
|
|
ORDER_DATE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
ORDER_SOURCE |
VARCHAR2
|
(240)
|
|
ORDER_SOURCE_ID |
NUMBER
|
|
|
ORDER_TYPE |
VARCHAR2
|
(30)
|
|
ORDER_TYPE_ID |
NUMBER
|
|
|
ORDERED_BY_CONTACT_FIRST_NAME |
VARCHAR2
|
(150)
|
|
ORDERED_BY_CONTACT_LAST_NAME |
VARCHAR2
|
(150)
|
|
PACKING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
PARTIAL_SHIPMENTS_ALLOWED |
VARCHAR2
|
(1)
|
|
PAYMENT_TERM_ID |
NUMBER
|
|
|
PAYMENT_TERM |
VARCHAR2
|
(30)
|
|
PO_ATTRIBUTE_1 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_2 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_3 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_4 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_5 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_6 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_7 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_8 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_9 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_10 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_11 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_12 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_13 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_14 |
VARCHAR2
|
(240)
|
|
PO_ATTRIBUTE_15 |
VARCHAR2
|
(240)
|
|
PO_REVISION_DATE |
DATE
|
|
|
PROGRAM |
VARCHAR2
|
(30)
|
|
PROGRAM_APPLICATION |
VARCHAR2
|
(30)
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
RELATED_PO_NUMBER |
VARCHAR2
|
(50)
|
|
REMAINDER_ORDERS_ALLOWED |
VARCHAR2
|
(1)
|
|
REQUEST_DATE |
DATE
|
|
|
REQUEST_ID |
NUMBER
|
|
|
RETURN_REASON_CODE |
VARCHAR2
|
(30)
|
|
SALESREP_ID |
NUMBER
|
|
|
SALESREP |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS_1 |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS_2 |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS_3 |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS_4 |
VARCHAR2
|
(240)
|
|
SHIP_TO_CITY |
VARCHAR2
|
(240)
|
|
SHIP_TO_CONTACT |
VARCHAR2
|
(330)
|
|
SHIP_TO_CONTACT_FIRST_NAME |
VARCHAR2
|
(240)
|
|
SHIP_TO_CONTACT_ID |
NUMBER
|
|
|
SHIP_TO_CONTACT_LAST_NAME |
VARCHAR2
|
(240)
|
|
SHIP_TO_COUNTRY |
VARCHAR2
|
(240)
|
|
SHIP_TO_COUNTY |
VARCHAR2
|
(240)
|
|
SHIP_TO_CUSTOMER |
VARCHAR2
|
(360)
|
|
SHIP_TO_CUSTOMER_NUMBER |
VARCHAR2
|
(50)
|
|
SHIP_TO_POSTAL_CODE |
VARCHAR2
|
(240)
|
|
FIRST_ACK_CODE |
VARCHAR2
|
(30)
|
|
LAST_ACK_CODE |
VARCHAR2
|
(30)
|
|
FIRST_ACK_DATE |
DATE
|
|
|
LAST_ACK_DATE |
DATE
|
|
|
BUYER_SELLER_FLAG |
VARCHAR2
|
(1)
|
|
CREATED_BY |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
BOOKED_FLAG |
VARCHAR2
|
(1)
|
|
AGREEMENT_ID |
NUMBER
|
|
|
AGREEMENT |
VARCHAR2
|
(240)
|
|
AGREEMENT_NAME |
VARCHAR2
|
(30)
|
|
CONTEXT |
VARCHAR2
|
(30)
|
|
PRICE_LIST |
VARCHAR2
|
(240)
|
|
PRICE_LIST_ID |
NUMBER
|
|
|
PRICING_DATE |
DATE
|
|
|
SHIP_FROM_ORG_ID |
NUMBER
|
|
|
SHIP_FROM_ORG |
VARCHAR2
|
(240)
|
|
SHIP_TO_ORG_ID |
NUMBER
|
|
|
SHIP_TO_ORG |
VARCHAR2
|
(240)
|
|
SOLD_FROM_ORG |
VARCHAR2
|
(240)
|
|
SOLD_FROM_ORG_ID |
NUMBER
|
|
|
SOLD_TO_ORG |
VARCHAR2
|
(360)
|
|
SOLD_TO_ORG_ID |
NUMBER
|
|
|
ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
CANCELLED_FLAG |
VARCHAR2
|
(1)
|
|
CLOSED_FLAG |
VARCHAR2
|
(1)
|
|
CONVERSION_RATE |
NUMBER
|
|
|
CONVERSION_RATE_DATE |
DATE
|
|
|
CONVERSION_TYPE |
VARCHAR2
|
(30)
|
|
CONVERSION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
CUST_PO_NUMBER |
VARCHAR2
|
(50)
|
|
CUSTOMER_ID |
NUMBER
|
|
|
CUSTOMER_NAME |
VARCHAR2
|
(360)
|
|
CUSTOMER_NUMBER |
VARCHAR2
|
(30)
|
|
DELIVER_TO_CONTACT |
VARCHAR2
|
(330)
|
|
DELIVER_TO_CONTACT_ID |
NUMBER
|
|
|
DELIVER_TO_CUSTOMER |
VARCHAR2
|
(360)
|
|
DELIVER_TO_CUSTOMER_NUMBER |
VARCHAR2
|
(50)
|
|
DELIVER_TO_ORG |
VARCHAR2
|
(240)
|
|
DELIVER_TO_ORG_ID |
NUMBER
|
|
|
DEMAND_CLASS |
VARCHAR2
|
(80)
|
|
DEMAND_CLASS_CODE |
VARCHAR2
|
(30)
|
|
EARLIEST_SCHEDULE_LIMIT |
NUMBER
|
|
|
LATEST_SCHEDULE_LIMIT |
NUMBER
|
|
|
ERROR_FLAG |
VARCHAR2
|
(1)
|
|
EXPIRATION_DATE |
DATE
|
|
|
FOB_POINT |
VARCHAR2
|
(240)
|
|
FOB_POINT_CODE |
VARCHAR2
|
(30)
|
|
FREIGHT_CARRIER_CODE |
VARCHAR2
|
(30)
|
|
FREIGHT_TERMS |
VARCHAR2
|
(80)
|
|
FREIGHT_TERMS_CODE |
VARCHAR2
|
(30)
|
|
GLOBAL_ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
GLOBAL_ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE2 |
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_ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
GLOBAL_ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
DELIVER_TO_STATE |
VARCHAR2
|
(60)
|
|
SOLD_TO_LOCATION_STATE |
VARCHAR2
|
(60)
|
|
SOLD_TO_LOCATION_COUNTY |
VARCHAR2
|
(60)
|
|
SOLD_TO_LOCATION_PROVINCE |
VARCHAR2
|
(60)
|
|
HEADER_ID |
NUMBER
|
|
|
ORIG_SYS_DOCUMENT_REF |
VARCHAR2
|
(50)
|
|
ORDER_NUMBER |
NUMBER
|
|
|
ORDERED_DATE |
DATE
|
|
|
ORG_ID |
NUMBER
|
|
|
CHANGE_DATE |
DATE
|
|
|
CHANGE_SEQUENCE |
VARCHAR2
|
(50)
|
|
ACCOUNTING_RULE_ID |
NUMBER
|
|
|
ACCOUNTING_RULE |
VARCHAR2
|
(30)
|
|
ACKNOWLEDGMENT_FLAG |
VARCHAR2
|
(1)
|
|
FREIGHT_CHARGE |
NUMBER
|
|
|
TAX_VALUE |
NUMBER
|
|
|