Name |
Datatype |
Length |
Prcn |
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)
|
|
ORDER_FIRMED_DATE |
DATE
|
|
|
ACTUAL_FULFILLMENT_DATE |
DATE
|
|
|
COMMITMENT |
VARCHAR2
|
(240)
|
|
CUSTOMER_PAYMENT_TERM |
VARCHAR2
|
(30)
|
|
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)
|
|
DELIVER_TO_STATE |
VARCHAR2
|
(60)
|
|
INVOICE_ADDRESS_1 |
VARCHAR2
|
(240)
|
|
INVOICE_ADDRESS_2 |
VARCHAR2
|
(240)
|
|
INVOICE_ADDRESS_3 |
VARCHAR2
|
(240)
|
|
INVOICE_ADDRESS_4 |
VARCHAR2
|
(240)
|
|
INVOICE_COUNTRY |
VARCHAR2
|
(60)
|
|
INVOICE_COUNTY |
VARCHAR2
|
(60)
|
|
INVOICE_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
INVOICE_STATE |
VARCHAR2
|
(60)
|
|
IB_OWNER_CODE |
VARCHAR2
|
(30)
|
|
IB_CURRENT_LOCATION_CODE |
VARCHAR2
|
(30)
|
|
IB_INSTALLED_AT_LOCATION_CODE |
VARCHAR2
|
(30)
|
|
CONFIG_REV_NBR |
NUMBER
|
|
22 |
CONFIG_HEADER_ID |
NUMBER
|
|
22 |
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
|
|
22 |
SHIP_TO_ADDRESS_CODE |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS_NAME |
VARCHAR2
|
(360)
|
|
SHIP_TO_ADDRESS_ID |
NUMBER
|
|
22 |
INVOICE_ADDRESS_CODE |
VARCHAR2
|
(40)
|
|
INVOICE_ADDRESS_NAME |
VARCHAR2
|
(360)
|
|
DELIVER_TO_CUSTOMER |
VARCHAR2
|
(360)
|
|
SERVICED_LINE_ID |
NUMBER
|
|
22 |
SERVICE_REFERENCE_ORDER |
VARCHAR2
|
(50)
|
|
SERVICE_REFERENCE_LINE |
VARCHAR2
|
(50)
|
|
SERVICE_REFERENCE_SYSTEM |
VARCHAR2
|
(50)
|
|
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)
|
|
SPLIT_FROM_SHIPMENT_REF |
VARCHAR2
|
(50)
|
|
SHIP_TO_CUSTOMER_ID |
NUMBER
|
|
22 |
INVOICE_TO_CUSTOMER_ID |
NUMBER
|
|
22 |
UNIT_SELLING_PRICE_PER_PQTY |
NUMBER
|
|
22 |
DELIVER_TO_CUSTOMER_ID |
NUMBER
|
|
22 |
SHIP_TO_CUSTOMER_NAME |
VARCHAR2
|
(360)
|
|
SHIP_TO_CUSTOMER_NUMBER |
VARCHAR2
|
(30)
|
|
INVOICE_TO_CUSTOMER_NAME |
VARCHAR2
|
(360)
|
|
INVOICE_TO_CUSTOMER_NUMBER |
VARCHAR2
|
(30)
|
|
DELIVER_TO_CUSTOMER_NAME |
VARCHAR2
|
(360)
|
|
DELIVER_TO_CUSTOMER_NUMBER |
VARCHAR2
|
(30)
|
|
ACCOUNTING_RULE_DURATION |
NUMBER
|
|
22 |
ATTRIBUTE16 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE17 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE18 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE19 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
ACKNOWLEDGMENT_TYPE |
VARCHAR2
|
(30)
|
|
USER_ITEM_DESCRIPTION |
VARCHAR2
|
(1000)
|
|
BLANKET_NUMBER |
NUMBER
|
|
22 |
BLANKET_LINE_NUMBER |
NUMBER
|
|
22 |
ORIGINAL_INVENTORY_ITEM_ID |
NUMBER
|
|
22 |
ORIGINAL_ORDERED_ITEM_ID |
NUMBER
|
|
22 |
ORIGINAL_ORDERED_ITEM |
VARCHAR2
|
(2000)
|
|
ORDERED_ITEM |
VARCHAR2
|
(2000)
|
|
INVOICE_INTERFACE_STATUS_CODE |
VARCHAR2
|
(30)
|
|
PREFERRED_GRADE |
VARCHAR2
|
(4)
|
|
ORDERED_QUANTITY2 |
NUMBER
|
|
22 |
ORDERED_QUANTITY_UOM2 |
VARCHAR2
|
(3)
|
|
SHIPPING_QUANTITY2 |
NUMBER
|
|
22 |
CANCELLED_QUANTITY2 |
NUMBER
|
|
22 |
SHIPPED_QUANTITY2 |
NUMBER
|
|
22 |
SHIPPING_QUANTITY_UOM2 |
VARCHAR2
|
(3)
|
|
FULFILLED_QUANTITY2 |
NUMBER
|
|
22 |
REVENUE_AMOUNT |
NUMBER
|
|
22 |
FULFILLMENT_DATE |
DATE
|
|
|
ORIGINAL_ITEM_IDENTIFIER_TYPE |
VARCHAR2
|
(30)
|
|
ITEM_SUBSTITUTION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
AUTO_SELECTED_QUANTITY |
NUMBER
|
|
22 |
ORDERED_ITEM_ID |
NUMBER
|
|
22 |
ITEM_IDENTIFIER_TYPE |
VARCHAR2
|
(30)
|
|
END_ITEM_UNIT_NUMBER |
VARCHAR2
|
(30)
|
|
RETURN_ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
RETURN_CONTEXT |
VARCHAR2
|
(30)
|
|
RETURN_REASON_CODE |
VARCHAR2
|
(30)
|
|
RLA_SCHEDULE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
SALESREP_ID |
NUMBER
|
|
22 |
SALESREP |
VARCHAR2
|
(240)
|
|
SCHEDULE_ARRIVAL_DATE |
DATE
|
|
|
SCHEDULE_SHIP_DATE |
DATE
|
|
|
SCHEDULE_ITEM_DETAIL |
VARCHAR2
|
(30)
|
|
SCHEDULE_STATUS_CODE |
VARCHAR2
|
(30)
|
|
SHIP_MODEL_COMPLETE_FLAG |
VARCHAR2
|
(1)
|
|
SHIP_SET_ID |
NUMBER
|
|
22 |
SHIP_SET_NAME |
VARCHAR2
|
(30)
|
|
SHIP_TO_ADDRESS1 |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS2 |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS3 |
VARCHAR2
|
(240)
|
|
SHIP_TO_ADDRESS4 |
VARCHAR2
|
(240)
|
|
SHIP_TO_CITY |
VARCHAR2
|
(60)
|
|
SHIP_TO_CONTACT |
VARCHAR2
|
(330)
|
|
SHIP_TO_CONTACT_AREA_CODE1 |
VARCHAR2
|
(10)
|
|
SHIP_TO_CONTACT_AREA_CODE2 |
VARCHAR2
|
(10)
|
|
SHIP_TO_CONTACT_AREA_CODE3 |
VARCHAR2
|
(40)
|
|
SHIP_TO_CONTACT_FIRST_NAME |
VARCHAR2
|
(150)
|
|
SHIP_TO_CONTACT_ID |
NUMBER
|
|
22 |
SHIP_TO_CONTACT_JOB_TITLE |
VARCHAR2
|
(100)
|
|
SHIP_TO_CONTACT_LAST_NAME |
VARCHAR2
|
(150)
|
|
SHIP_TO_COUNTRY |
VARCHAR2
|
(60)
|
|
SHIP_TO_COUNTY |
VARCHAR2
|
(60)
|
|
SHIP_TO_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
SHIP_TO_STATE |
VARCHAR2
|
(60)
|
|
SHIP_TOLERANCE_ABOVE |
NUMBER
|
|
22 |
SHIP_TOLERANCE_BELOW |
NUMBER
|
|
22 |
SHIPMENT_NUMBER |
NUMBER
|
|
22 |
SHIPMENT_PRIORITY |
VARCHAR2
|
(80)
|
|
SHIPMENT_PRIORITY_CODE |
VARCHAR2
|
(30)
|
|
SHIPPED_QUANTITY |
NUMBER
|
|
22 |
SHIPPING_METHOD |
VARCHAR2
|
(80)
|
|
SHIPPING_METHOD_CODE |
VARCHAR2
|
(30)
|
|
SHIPPING_QUANTITY |
NUMBER
|
|
22 |
SHIPPING_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
SORT_ORDER |
VARCHAR2
|
(2000)
|
|
SOURCE_DOCUMENT_ID |
NUMBER
|
|
22 |
SOURCE_DOCUMENT_LINE_ID |
NUMBER
|
|
22 |
SOURCE_DOCUMENT_TYPE_ID |
NUMBER
|
|
22 |
SOURCE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
SPLIT_FROM_LINE_ID |
NUMBER
|
|
22 |
SUBINVENTORY |
VARCHAR2
|
(30)
|
|
SUBMISSION_DATETIME |
DATE
|
|
|
TASK |
VARCHAR2
|
(30)
|
|
TASK_ID |
NUMBER
|
|
22 |
TAX |
VARCHAR2
|
(50)
|
|
TAX_CODE |
VARCHAR2
|
(50)
|
|
TAX_DATE |
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)
|
|
TAX_RATE |
NUMBER
|
|
22 |
TAX_VALUE |
NUMBER
|
|
22 |
UNIT_LIST_PRICE |
NUMBER
|
|
22 |
UNIT_SELLING_PRICE |
NUMBER
|
|
22 |
VEH_CUS_ITEM_CUM_KEY_ID |
NUMBER
|
|
22 |
VISIBLE_DEMAND_FLAG |
VARCHAR2
|
(1)
|
|
CUSTOMER_LINE_NUMBER |
VARCHAR2
|
(50)
|
|
CUSTOMER_SHIPMENT_NUMBER |
VARCHAR2
|
(50)
|
|
CUSTOMER_ITEM_NET_PRICE |
NUMBER
|
|
22 |
CUSTOMER_PAYMENT_TERM_ID |
NUMBER
|
|
22 |
DROP_SHIP_FLAG |
VARCHAR2
|
(1)
|
|
SPLIT_FROM_LINE_REF |
VARCHAR2
|
(50)
|
|
SHIP_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
SERVICE_TXN_REASON_CODE |
VARCHAR2
|
(30)
|
|
SERVICE_TXN_COMMENTS |
VARCHAR2
|
(2000)
|
|
SERVICE_DURATION |
NUMBER
|
|
22 |
SERVICE_START_DATE |
DATE
|
|
|
SERVICE_END_DATE |
DATE
|
|
|
SERVICE_COTERMINATE_FLAG |
VARCHAR2
|
(1)
|
|
SERVICE_NUMBER |
NUMBER
|
|
22 |
SERVICE_PERIOD |
VARCHAR2
|
(3)
|
|
SERVICE_REFERENCE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
SERVICE_REFERENCE_LINE_ID |
NUMBER
|
|
22 |
SERVICE_REFERENCE_SYSTEM_ID |
NUMBER
|
|
22 |
CREDIT_INVOICE_LINE_ID |
NUMBER
|
|
22 |
SHIP_TO_PROVINCE |
VARCHAR2
|
(60)
|
|
INVOICE_PROVINCE |
VARCHAR2
|
(60)
|
|
BILL_TO_EDI_LOCATION_CODE |
VARCHAR2
|
(40)
|
|
INVOICE_CITY |
VARCHAR2
|
(60)
|
|
INVENTORY_ITEM_SEGMENT_17 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_18 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_19 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_2 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_20 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_3 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_4 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_5 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_6 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_7 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_8 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_9 |
VARCHAR2
|
(240)
|
|
INVOICE_COMPLETE_FLAG |
VARCHAR2
|
(1)
|
|
INVOICE_SET_ID |
NUMBER
|
|
22 |
INVOICE_SET_NAME |
VARCHAR2
|
(30)
|
|
INVOICE_NUMBER |
VARCHAR2
|
(20)
|
|
INVOICE_TO_CONTACT |
VARCHAR2
|
(330)
|
|
INVOICE_TO_CONTACT_ID |
NUMBER
|
|
22 |
INVOICE_TO_ORG |
VARCHAR2
|
(240)
|
|
INVOICE_TO_ORG_ID |
NUMBER
|
|
22 |
INVOICE_TOLERANCE_ABOVE |
NUMBER
|
|
22 |
INVOICE_TOLERANCE_BELOW |
NUMBER
|
|
22 |
INVOICING_RULE |
VARCHAR2
|
(30)
|
|
INVOICING_RULE_ID |
NUMBER
|
|
22 |
ITEM_INPUT |
VARCHAR2
|
(240)
|
|
ITEM_REVISION |
VARCHAR2
|
(3)
|
|
ITEM_TYPE_CODE |
VARCHAR2
|
(30)
|
|
LATEST_ACCEPTABLE_DATE |
DATE
|
|
|
LINE_CATEGORY_CODE |
VARCHAR2
|
(30)
|
|
LINE_ID |
NUMBER
|
|
22 |
LINE_NUMBER |
NUMBER
|
|
22 |
LINE_PO_CONTEXT |
VARCHAR2
|
(30)
|
|
LINE_TYPE |
VARCHAR2
|
(30)
|
|
LINE_TYPE_ID |
NUMBER
|
|
22 |
LINK_TO_LINE_ID |
NUMBER
|
|
22 |
LINK_TO_LINE_REF |
VARCHAR2
|
(50)
|
|
LOAD_SEQ_NUMBER |
NUMBER
|
|
22 |
LOT |
VARCHAR2
|
(30)
|
|
MATERIAL_COST |
NUMBER
|
|
22 |
MATERIAL_OVERHEAD_COST |
NUMBER
|
|
22 |
MODEL_GROUP_NUMBER |
NUMBER
|
|
22 |
OPEN_FLAG |
VARCHAR2
|
(1)
|
|
OPERATION_CODE |
VARCHAR2
|
(30)
|
|
OPTION_FLAG |
VARCHAR2
|
(1)
|
|
OPTION_NUMBER |
NUMBER
|
|
22 |
ORDER_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
ORDER_SOURCE |
VARCHAR2
|
(30)
|
|
ORDER_SOURCE_ID |
NUMBER
|
|
22 |
ORDERED_QUANTITY |
NUMBER
|
|
22 |
ORG_ID |
NUMBER
|
|
22 |
OUTSIDE_PROCESSING_COST |
NUMBER
|
|
22 |
ORIG_SYS_SHIPMENT_REF |
VARCHAR2
|
(50)
|
|
OVER_SHIP_REASON_CODE |
VARCHAR2
|
(30)
|
|
OVER_SHIP_RESOLVED_FLAG |
VARCHAR2
|
(1)
|
|
OVERHEAD_COST |
NUMBER
|
|
22 |
PAYMENT_TERM |
VARCHAR2
|
(30)
|
|
PAYMENT_TERM_ID |
NUMBER
|
|
22 |
PAYMENT_TRX |
VARCHAR2
|
(30)
|
|
PAYMENT_TRX_ID |
NUMBER
|
|
22 |
PLANNING_PROD_SEQ_NUM |
NUMBER
|
|
22 |
PRICING_ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
PRICING_ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
PRICING_CONTEXT |
VARCHAR2
|
(150)
|
|
PRICING_DATE |
DATE
|
|
|
PRICING_QUANTITY |
NUMBER
|
|
22 |
PRICING_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
PROGRAM |
VARCHAR2
|
(30)
|
|
PROGRAM_APPLICATION |
VARCHAR2
|
(30)
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
22 |
PROGRAM_ID |
NUMBER
|
|
22 |
PROGRAM_UPDATE_DATE |
DATE
|
|
|
PROJECT |
VARCHAR2
|
(30)
|
|
PROJECT_ID |
NUMBER
|
|
22 |
PROMISE_DATE |
DATE
|
|
|
REFERENCE_HEADER |
VARCHAR2
|
(30)
|
|
REFERENCE_HEADER_ID |
NUMBER
|
|
22 |
REFERENCE_LINE |
VARCHAR2
|
(30)
|
|
REFERENCE_LINE_ID |
NUMBER
|
|
22 |
REFERENCE_TYPE |
VARCHAR2
|
(30)
|
|
RELATED_PO_NUMBER |
VARCHAR2
|
(50)
|
|
REQUEST_DATE |
DATE
|
|
|
REQUEST_ID |
NUMBER
|
|
22 |
RESERVED_QUANTITY |
NUMBER
|
|
22 |
RESOURCE_COST |
NUMBER
|
|
22 |
RETURN_ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
DELIVER_TO_CONTACT_ID |
NUMBER
|
|
22 |
DELIVER_TO_ORG |
VARCHAR2
|
(240)
|
|
DELIVER_TO_ORG_ID |
NUMBER
|
|
22 |
DELIVERY_LEAD_TIME |
NUMBER
|
|
22 |
DEMAND_BUCKET_TYPE |
VARCHAR2
|
(80)
|
|
DEMAND_BUCKET_TYPE_CODE |
VARCHAR2
|
(30)
|
|
DEMAND_CLASS |
VARCHAR2
|
(80)
|
|
DEMAND_CLASS_CODE |
VARCHAR2
|
(30)
|
|
DEMAND_STREAM |
VARCHAR2
|
(30)
|
|
DEP_PLAN_REQUIRED_FLAG |
VARCHAR2
|
(1)
|
|
DPW_ASSIGNED_FLAG |
VARCHAR2
|
(1)
|
|
EARLIEST_ACCEPTABLE_DATE |
DATE
|
|
|
ERROR_FLAG |
VARCHAR2
|
(1)
|
|
EXPLOSION_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)
|
|
FULFILLED_QUANTITY |
NUMBER
|
|
22 |
FULFILLMENT_SET_ID |
NUMBER
|
|
22 |
FULFILLMENT_SET_NAME |
VARCHAR2
|
(30)
|
|
GLOBAL_ATTRIBUTE_CATEGORY |
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)
|
|
INDUSTRY_ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE16 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE17 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE18 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE19 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE21 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE22 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE23 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE24 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE25 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE26 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE27 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE28 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE29 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE30 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
INDUSTRY_CONTEXT |
VARCHAR2
|
(30)
|
|
INTMED_SHIP_TO_CONTACT_ID |
NUMBER
|
|
22 |
INTMED_SHIP_TO_ORG_ID |
NUMBER
|
|
22 |
INTERFACE_STATUS |
VARCHAR2
|
(1000)
|
|
INVENTORY_ITEM |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_ID |
NUMBER
|
|
22 |
INVENTORY_ITEM_SEGMENT_1 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_10 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_11 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_12 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_13 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_14 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_15 |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_SEGMENT_16 |
VARCHAR2
|
(240)
|
|
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
|
|
22 |
END_CUSTOMER_CONTACT_ID |
NUMBER
|
|
22 |
END_CUSTOMER_SITE_USE_ID |
NUMBER
|
|
22 |
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)
|
|
SHIPPING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
PACKING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
INVOICED_QUANTITY |
NUMBER
|
|
22 |
REFERENCE_CUSTOMER_TRX_LINE_ID |
NUMBER
|
|
22 |
SPLIT_BY |
VARCHAR2
|
(30)
|
|
LINE_SET_ID |
NUMBER
|
|
22 |
UNIT_LIST_PERCENT |
NUMBER
|
|
22 |
UNIT_SELLING_PERCENT |
NUMBER
|
|
22 |
UNIT_PERCENT_BASE_PRICE |
NUMBER
|
|
22 |
RE_SOURCE_FLAG |
VARCHAR2
|
(1)
|
|
FLOW_STATUS_CODE |
VARCHAR2
|
(30)
|
|
UNIT_LIST_PRICE_PER_PQTY |
NUMBER
|
|
22 |
UNIT_SELLING_PRICE_PQTY |
NUMBER
|
|
22 |
ITEM_RELATIONSHIP_TYPE |
NUMBER
|
|
22 |
HEADER_ID |
NUMBER
|
|
22 |
ORIG_SYS_DOCUMENT_REF |
VARCHAR2
|
(50)
|
|
ORIG_SYS_LINE_REF |
VARCHAR2
|
(50)
|
|
CHANGE_DATE |
DATE
|
|
|
CHANGE_SEQUENCE |
VARCHAR2
|
(50)
|
|
ACCOUNTING_RULE |
VARCHAR2
|
(30)
|
|
ORDER_NUMBER |
NUMBER
|
|
22 |
ACCOUNTING_RULE_ID |
NUMBER
|
|
22 |
ACKNOWLEDGMENT_FLAG |
VARCHAR2
|
(1)
|
|
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
|
|
22 |
CREATION_DATE |
DATE
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
22 |
LAST_UPDATED_BY |
NUMBER
|
|
22 |
ACTUAL_ARRIVAL_DATE |
DATE
|
|
|
ACTUAL_SHIPMENT_DATE |
DATE
|
|
|
AGREEMENT |
VARCHAR2
|
(240)
|
|
AGREEMENT_ID |
NUMBER
|
|
22 |
ARRIVAL_SET_ID |
NUMBER
|
|
22 |
ARRIVAL_SET_NAME |
VARCHAR2
|
(30)
|
|
PRICE_LIST |
VARCHAR2
|
(240)
|
|
PRICE_LIST_ID |
NUMBER
|
|
22 |
SHIP_FROM_ORG |
VARCHAR2
|
(240)
|
|
SHIP_FROM_ORG_ID |
NUMBER
|
|
22 |
SHIP_TO_ORG |
VARCHAR2
|
(240)
|
|
SHIP_TO_ORG_ID |
NUMBER
|
|
22 |
SOLD_FROM_ORG |
VARCHAR2
|
(240)
|
|
SOLD_FROM_ORG_ID |
NUMBER
|
|
22 |
SOLD_TO_ORG |
VARCHAR2
|
(360)
|
|
SOLD_TO_ORG_ID |
NUMBER
|
|
22 |
ATO_LINE_ID |
NUMBER
|
|
22 |
ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE15 |
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)
|
|
AUTHORIZED_TO_SHIP_FLAG |
VARCHAR2
|
(1)
|
|
BOOKED_FLAG |
VARCHAR2
|
(1)
|
|
CALCULATE_PRICE_FLAG |
VARCHAR2
|
(1)
|
|
CANCELLED_FLAG |
VARCHAR2
|
(1)
|
|
CANCELLED_QUANTITY |
NUMBER
|
|
22 |
CLOSED_FLAG |
VARCHAR2
|
(1)
|
|
COMMITMENT_ID |
NUMBER
|
|
22 |
COMPONENT_CODE |
VARCHAR2
|
(1000)
|
|
COMPONENT_NUMBER |
NUMBER
|
|
22 |
COMPONENT_SEQUENCE_ID |
NUMBER
|
|
22 |
CONFIG_DISPLAY_SEQUENCE |
NUMBER
|
|
22 |
CONFIGURATION_ID |
NUMBER
|
|
22 |
CONFIG_LINE_REF |
VARCHAR2
|
(50)
|
|
TOP_MODEL_LINE_ID |
NUMBER
|
|
22 |
CONTEXT |
VARCHAR2
|
(30)
|
|
CONTRACT_PO_NUMBER |
VARCHAR2
|
(150)
|
|
COST_TYPE |
VARCHAR2
|
(30)
|
|
COST_TYPE_ID |
NUMBER
|
|
22 |
COSTING_DATE |
DATE
|
|
|
CUST_MODEL_SERIAL_NUMBER |
VARCHAR2
|
(50)
|
|
CUST_PO_NUMBER |
VARCHAR2
|
(50)
|
|
CUST_PRODUCTION_SEQ_NUM |
VARCHAR2
|
(50)
|
|
CUSTOMER_DOCK |
VARCHAR2
|
(50)
|
|
CUSTOMER_DOCK_CODE |
VARCHAR2
|
(50)
|
|
CUSTOMER_ITEM |
VARCHAR2
|
(2000)
|
|
CUSTOMER_ITEM_ID |
NUMBER
|
|
22 |
CUSTOMER_ITEM_REVISION |
VARCHAR2
|
(50)
|
|
CUSTOMER_JOB |
VARCHAR2
|
(50)
|
|
CUSTOMER_PRODUCTION_LINE |
VARCHAR2
|
(50)
|
|
CUSTOMER_TRX_LINE_ID |
NUMBER
|
|
22 |
DELIVERY_ID |
NUMBER
|
|
22 |
DELIVER_TO_CONTACT |
VARCHAR2
|
(330)
|
|