| 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
|
|
|