Name |
Datatype |
Length |
Prcn |
ACCOUNTING_RULE_ID |
NUMBER
|
|
|
ACTUAL_ARRIVAL_DATE |
DATE
|
|
|
ACTUAL_SHIPMENT_DATE |
DATE
|
|
|
AGREEMENT_ID |
NUMBER
|
|
|
ARRIVAL_SET_ID |
NUMBER
|
|
|
ATO_LINE_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)
|
|
AUTHORIZED_TO_SHIP_FLAG |
VARCHAR2
|
(1)
|
|
AUTO_SELECTED_QUANTITY |
NUMBER
|
|
|
BOOKED_FLAG |
VARCHAR2
|
(1)
|
|
CANCELLED_FLAG |
VARCHAR2
|
(1)
|
|
CANCELLED_QUANTITY |
NUMBER
|
|
|
CANCELLED_QUANTITY2 |
NUMBER
|
|
|
COMMITMENT_ID |
NUMBER
|
|
|
COMPONENT_CODE |
VARCHAR2
|
(1000)
|
|
COMPONENT_NUMBER |
NUMBER
|
|
|
COMPONENT_SEQUENCE_ID |
NUMBER
|
|
|
CONFIG_HEADER_ID |
NUMBER
|
|
|
CONFIG_REV_NBR |
NUMBER
|
|
|
CONFIG_DISPLAY_SEQUENCE |
NUMBER
|
|
|
CONFIGURATION_ID |
NUMBER
|
|
|
CONTEXT |
VARCHAR2
|
(30)
|
|
CREATED_BY |
NUMBER
|
|
|
CREATION_DATE |
DATE
|
|
|
CREDIT_INVOICE_LINE_ID |
NUMBER
|
|
|
CUSTOMER_DOCK_CODE |
VARCHAR2
|
(50)
|
|
CUSTOMER_JOB |
VARCHAR2
|
(50)
|
|
CUSTOMER_PRODUCTION_LINE |
VARCHAR2
|
(50)
|
|
CUSTOMER_TRX_LINE_ID |
NUMBER
|
|
|
CUST_MODEL_SERIAL_NUMBER |
VARCHAR2
|
(50)
|
|
CUST_PO_NUMBER |
VARCHAR2
|
(50)
|
|
CUST_PRODUCTION_SEQ_NUM |
VARCHAR2
|
(50)
|
|
DELIVERY_LEAD_TIME |
NUMBER
|
|
|
DELIVER_TO_CONTACT_ID |
NUMBER
|
|
|
DELIVER_TO_ORG_ID |
NUMBER
|
|
|
DEMAND_BUCKET_TYPE_CODE |
VARCHAR2
|
(30)
|
|
DEMAND_CLASS_CODE |
VARCHAR2
|
(30)
|
|
DEP_PLAN_REQUIRED_FLAG |
VARCHAR2
|
(1)
|
|
EARLIEST_ACCEPTABLE_DATE |
DATE
|
|
|
END_ITEM_UNIT_NUMBER |
VARCHAR2
|
(30)
|
|
EXPLOSION_DATE |
DATE
|
|
|
FOB_POINT_CODE |
VARCHAR2
|
(30)
|
|
FREIGHT_CARRIER_CODE |
VARCHAR2
|
(30)
|
|
FREIGHT_TERMS_CODE |
VARCHAR2
|
(30)
|
|
FULFILLED_QUANTITY |
NUMBER
|
|
|
FULFILLED_QUANTITY2 |
NUMBER
|
|
|
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)
|
|
HEADER_ID |
NUMBER
|
|
|
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_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_ATTRIBUTE30 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
INDUSTRY_ATTRIBUTE3 |
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)
|
|
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)
|
|
INTERMED_SHIP_TO_ORG_ID |
NUMBER
|
|
|
INTERMED_SHIP_TO_CONTACT_ID |
NUMBER
|
|
|
INVENTORY_ITEM_ID |
NUMBER
|
|
|
INVOICE_INTERFACE_STATUS_CODE |
VARCHAR2
|
(30)
|
|
INVOICE_TO_CONTACT_ID |
NUMBER
|
|
|
INVOICE_TO_ORG_ID |
NUMBER
|
|
|
INVOICING_RULE_ID |
NUMBER
|
|
|
ORDERED_ITEM |
VARCHAR2
|
(2000)
|
|
ITEM_REVISION |
VARCHAR2
|
(3)
|
|
ITEM_TYPE_CODE |
VARCHAR2
|
(30)
|
|
LAST_UPDATED_BY |
NUMBER
|
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
|
LATEST_ACCEPTABLE_DATE |
DATE
|
|
|
LINE_CATEGORY_CODE |
VARCHAR2
|
(30)
|
|
LINE_ID |
NUMBER
|
|
|
LINE_NUMBER |
NUMBER
|
|
|
LINE_TYPE_ID |
NUMBER
|
|
|
LINK_TO_LINE_REF |
VARCHAR2
|
(50)
|
|
LINK_TO_LINE_ID |
NUMBER
|
|
|
LINK_TO_LINE_INDEX |
NUMBER
|
|
|
MODEL_GROUP_NUMBER |
NUMBER
|
|
|
MFG_COMPONENT_SEQUENCE_ID |
NUMBER
|
|
|
MFG_LEAD_TIME |
NUMBER
|
|
|
OPEN_FLAG |
VARCHAR2
|
(1)
|
|
OPTION_FLAG |
VARCHAR2
|
(1)
|
|
OPTION_NUMBER |
NUMBER
|
|
|
ORDERED_QUANTITY |
NUMBER
|
|
|
ORDERED_QUANTITY2 |
NUMBER
|
|
|
ORDER_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
ORDERED_QUANTITY_UOM2 |
VARCHAR2
|
(3)
|
|
ORG_ID |
NUMBER
|
|
|
ORIG_SYS_DOCUMENT_REF |
VARCHAR2
|
(50)
|
|
ORIG_SYS_LINE_REF |
VARCHAR2
|
(50)
|
|
OVER_SHIP_REASON_CODE |
VARCHAR2
|
(30)
|
|
OVER_SHIP_RESOLVED_FLAG |
VARCHAR2
|
(1)
|
|
PAYMENT_TERM_ID |
NUMBER
|
|
|
PLANNING_PRIORITY |
NUMBER
|
|
|
PREFERRED_GRADE |
VARCHAR2
|
(4)
|
|
PRICE_LIST_ID |
NUMBER
|
|
|
PRICE_REQUEST_CODE |
VARCHAR2
|
(240)
|
|
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
|
(240)
|
|
PRICING_DATE |
DATE
|
|
|
PRICING_QUANTITY |
NUMBER
|
|
|
PRICING_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
PROGRAM_APPLICATION_ID |
NUMBER
|
|
|
PROGRAM_ID |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE |
DATE
|
|
|
PROJECT_ID |
NUMBER
|
|
|
PROMISE_DATE |
DATE
|
|
|
RE_SOURCE_FLAG |
VARCHAR2
|
(1)
|
|
REFERENCE_CUSTOMER_TRX_LINE_ID |
NUMBER
|
|
|
REFERENCE_HEADER_ID |
NUMBER
|
|
|
REFERENCE_LINE_ID |
NUMBER
|
|
|
REFERENCE_TYPE |
VARCHAR2
|
(30)
|
|
REQUEST_DATE |
DATE
|
|
|
REQUEST_ID |
NUMBER
|
|
|
RESERVED_QUANTITY |
NUMBER
|
|
|
RETURN_ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
RETURN_ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
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
|
|
|
SCHEDULE_ARRIVAL_DATE |
DATE
|
|
|
SCHEDULE_SHIP_DATE |
DATE
|
|
|
SCHEDULE_ACTION_CODE |
VARCHAR2
|
(30)
|
|
SCHEDULE_STATUS_CODE |
VARCHAR2
|
(30)
|
|
SHIPMENT_NUMBER |
NUMBER
|
|
|
SHIPMENT_PRIORITY_CODE |
VARCHAR2
|
(30)
|
|
SHIPPED_QUANTITY |
NUMBER
|
|
|
SHIPPED_QUANTITY2 |
NUMBER
|
|
|
SHIPPING_INTERFACED_FLAG |
VARCHAR2
|
(1)
|
|
SHIPPING_METHOD_CODE |
VARCHAR2
|
(30)
|
|
SHIPPING_QUANTITY |
NUMBER
|
|
|
SHIPPING_QUANTITY2 |
NUMBER
|
|
|
SHIPPING_QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
SHIPPING_QUANTITY_UOM2 |
VARCHAR2
|
(3)
|
|
SHIP_FROM_ORG_ID |
NUMBER
|
|
|
SHIP_MODEL_COMPLETE_FLAG |
VARCHAR2
|
(30)
|
|
SHIP_SET_ID |
NUMBER
|
|
|
FULFILLMENT_SET_ID |
NUMBER
|
|
|
SHIP_TOLERANCE_ABOVE |
NUMBER
|
|
|
SHIP_TOLERANCE_BELOW |
NUMBER
|
|
|
SHIP_TO_CONTACT_ID |
NUMBER
|
|
|
SHIP_TO_ORG_ID |
NUMBER
|
|
|
SOLD_TO_ORG_ID |
NUMBER
|
|
|
SOLD_FROM_ORG_ID |
NUMBER
|
|
|
SORT_ORDER |
VARCHAR2
|
(2000)
|
|
SOURCE_DOCUMENT_ID |
NUMBER
|
|
|
SOURCE_DOCUMENT_LINE_ID |
NUMBER
|
|
|
SOURCE_DOCUMENT_TYPE_ID |
NUMBER
|
|
|
SOURCE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
SPLIT_FROM_LINE_ID |
NUMBER
|
|
|
TASK_ID |
NUMBER
|
|
|
TAX_CODE |
VARCHAR2
|
(50)
|
|
TAX_DATE |
DATE
|
|
|
TAX_EXEMPT_FLAG |
VARCHAR2
|
(30)
|
|
TAX_EXEMPT_NUMBER |
VARCHAR2
|
(80)
|
|
TAX_EXEMPT_REASON_CODE |
VARCHAR2
|
(30)
|
|
TAX_POINT_CODE |
VARCHAR2
|
(30)
|
|
TAX_RATE |
NUMBER
|
|
|
TAX_VALUE |
NUMBER
|
|
|
TOP_MODEL_LINE_REF |
VARCHAR2
|
(50)
|
|
TOP_MODEL_LINE_ID |
NUMBER
|
|
|
TOP_MODEL_LINE_INDEX |
NUMBER
|
|
|
UNIT_LIST_PRICE |
NUMBER
|
|
|
UNIT_LIST_PRICE_PER_PQTY |
NUMBER
|
|
|
UNIT_SELLING_PRICE |
NUMBER
|
|
|
UNIT_SELLING_PRICE_PER_PQTY |
NUMBER
|
|
|
VEH_CUS_ITEM_CUM_KEY_ID |
NUMBER
|
|
|
VISIBLE_DEMAND_FLAG |
VARCHAR2
|
(1)
|
|
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)
|
|
ARRIVAL_SET |
VARCHAR2
|
(30)
|
|
SHIP_SET |
VARCHAR2
|
(30)
|
|
FULFILLMENT_SET |
VARCHAR2
|
(30)
|
|
ORDER_SOURCE_ID |
NUMBER
|
|
|
ORIG_SYS_SHIPMENT_REF |
VARCHAR2
|
(50)
|
|
CHANGE_SEQUENCE |
VARCHAR2
|
(50)
|
|
CHANGE_REQUEST_CODE |
VARCHAR2
|
(30)
|
|
STATUS_FLAG |
VARCHAR2
|
(1)
|
|
DROP_SHIP_FLAG |
VARCHAR2
|
(1)
|
|
CUSTOMER_LINE_NUMBER |
VARCHAR2
|
(50)
|
|
CUSTOMER_SHIPMENT_NUMBER |
VARCHAR2
|
(50)
|
|
CUSTOMER_ITEM_NET_PRICE |
NUMBER
|
|
|
CUSTOMER_PAYMENT_TERM_ID |
NUMBER
|
|
|
ORDERED_ITEM_ID |
NUMBER
|
|
|
ITEM_IDENTIFIER_TYPE |
VARCHAR2
|
(25)
|
|
SHIPPING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
PACKING_INSTRUCTIONS |
VARCHAR2
|
(2000)
|
|
CALCULATE_PRICE_FLAG |
VARCHAR2
|
(1)
|
|
INVOICED_QUANTITY |
NUMBER
|
|
|
SERVICE_TXN_REASON_CODE |
VARCHAR2
|
(30)
|
|
SERVICE_TXN_COMMENTS |
VARCHAR2
|
(2000)
|
|
SERVICE_DURATION |
NUMBER
|
|
|
SERVICE_PERIOD |
VARCHAR2
|
(3)
|
|
SERVICE_START_DATE |
DATE
|
|
|
SERVICE_END_DATE |
DATE
|
|
|
SERVICE_COTERMINATE_FLAG |
VARCHAR2
|
(1)
|
|
UNIT_LIST_PERCENT |
NUMBER
|
|
|
UNIT_SELLING_PERCENT |
NUMBER
|
|
|
UNIT_PERCENT_BASE_PRICE |
NUMBER
|
|
|
SERVICE_NUMBER |
NUMBER
|
|
|
SERVICE_REFERENCE_TYPE_CODE |
VARCHAR2
|
(30)
|
|
SERVICE_REFERENCE_LINE_ID |
NUMBER
|
|
|
SERVICE_REFERENCE_SYSTEM_ID |
NUMBER
|
|
|
SERVICE_REF_ORDER_NUMBER |
NUMBER
|
|
|
SERVICE_REF_LINE_NUMBER |
NUMBER
|
|
|
SERVICE_REFERENCE_ORDER |
VARCHAR2
|
(50)
|
|
SERVICE_REFERENCE_LINE |
VARCHAR2
|
(50)
|
|
SERVICE_REFERENCE_SYSTEM |
VARCHAR2
|
(50)
|
|
SERVICE_REF_SHIPMENT_NUMBER |
NUMBER
|
|
|
SERVICE_REF_OPTION_NUMBER |
NUMBER
|
|
|
SERVICE_LINE_INDEX |
NUMBER
|
|
|
LINE_SET_ID |
NUMBER
|
|
|
SPLIT_BY |
VARCHAR2
|
(240)
|
|
SPLIT_ACTION_CODE |
VARCHAR2
|
(30)
|
|
SHIPPABLE_FLAG |
VARCHAR2
|
(1)
|
|
MODEL_REMNANT_FLAG |
VARCHAR2
|
(1)
|
|
FLOW_STATUS_CODE |
VARCHAR2
|
(30)
|
|
FULFILLED_FLAG |
VARCHAR2
|
(1)
|
|
FULFILLMENT_METHOD_CODE |
VARCHAR2
|
(30)
|
|
REVENUE_AMOUNT |
NUMBER
|
|
|
MARKETING_SOURCE_CODE_ID |
NUMBER
|
|
|
FULFILLMENT_DATE |
DATE
|
|
|
SEMI_PROCESSED_FLAG |
INTEGER
|
|
|
UPGRADED_FLAG |
VARCHAR2
|
(1)
|
|
LOCK_CONTROL |
NUMBER
|
|
|
SUBINVENTORY |
VARCHAR2
|
(10)
|
|
SPLIT_FROM_LINE_REF |
VARCHAR2
|
(50)
|
|
SPLIT_FROM_SHIPMENT_REF |
VARCHAR2
|
(50)
|
|
SHIP_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)
|
|
ORIGINAL_INVENTORY_ITEM_ID |
NUMBER
|
|
|
ORIGINAL_ITEM_IDENTIFIER_TYPE |
VARCHAR2
|
(30)
|
|
ORIGINAL_ORDERED_ITEM_ID |
NUMBER
|
|
|
ORIGINAL_ORDERED_ITEM |
VARCHAR2
|
(2000)
|
|
ITEM_SUBSTITUTION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
LATE_DEMAND_PENALTY_FACTOR |
NUMBER
|
|
|
OVERRIDE_ATP_DATE_CODE |
VARCHAR2
|
(30)
|
|
SHIP_TO_CUSTOMER_ID |
NUMBER
|
|
|
INVOICE_TO_CUSTOMER_ID |
NUMBER
|
|
|
DELIVER_TO_CUSTOMER_ID |
NUMBER
|
|
|
ACCOUNTING_RULE_DURATION |
NUMBER
|
|
|
UNIT_COST |
NUMBER
|
|
|
USER_ITEM_DESCRIPTION |
VARCHAR2
|
(1000)
|
|
XML_TRANSACTION_TYPE_CODE |
VARCHAR2
|
(30)
|
|
ITEM_RELATIONSHIP_TYPE |
NUMBER
|
|
|
BLANKET_NUMBER |
NUMBER
|
|
|
BLANKET_LINE_NUMBER |
NUMBER
|
|
|
BLANKET_VERSION_NUMBER |
NUMBER
|
|
|
CSO_RESPONSE_FLAG |
VARCHAR2
|
(1)
|
|
FIRM_DEMAND_FLAG |
VARCHAR2
|
(1)
|
|
EARLIEST_SHIP_DATE |
DATE
|
|
|
TRANSACTION_PHASE_CODE |
VARCHAR2
|
(30)
|
|
SOURCE_DOCUMENT_VERSION_NUMBER |
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
|
|
|
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
|
|
|
RETROBILL_REQUEST_ID |
NUMBER
|
|
|
ORIGINAL_LIST_PRICE |
NUMBER
|
|
|
COMMITMENT_APPLIED_AMOUNT |
NUMBER
|
|
|
SHIP_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
INVOICE_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
DELIVER_TO_PARTY_NUMBER |
VARCHAR2
|
(30)
|
|
ORDER_FIRMED_DATE |
DATE
|
|
|
ACTUAL_FULFILLMENT_DATE |
DATE
|
|
|
CHANGED_LINES_POCAO |
VARCHAR2
|
(1)
|
|
CHARGE_PERIODICITY_CODE |
VARCHAR2
|
(3)
|
|
FREIGHT_CHARGE |
NUMBER
|
|
|