Name |
Datatype |
Length |
Prcn |
ROW_ID |
VARCHAR2
|
(30)
|
|
INSTANCE_ID |
NUMBER
|
|
|
INVENTORY_ITEM_ID |
NUMBER
|
|
|
INVENTORY_ITEM_NAME |
VARCHAR2
|
(40)
|
|
SOURCE_ORGANIZATION_ID |
NUMBER
|
|
|
SOURCE_ORGANIZATION_CODE |
VARCHAR2
|
(7)
|
|
ORGANIZATION_ID |
NUMBER
|
|
|
IDENTIFIER |
NUMBER
|
|
|
DEMAND_SOURCE_HEADER_ID |
NUMBER
|
|
|
DEMAND_SOURCE_DELIVERY |
VARCHAR2
|
(30)
|
|
DEMAND_SOURCE_TYPE |
NUMBER
|
|
|
SCENARIO_ID |
NUMBER
|
|
|
CALLING_MODULE |
NUMBER
|
|
|
CUSTOMER_ID |
NUMBER
|
|
|
CUSTOMER_SITE_ID |
NUMBER
|
|
|
DESTINATION_TIME_ZONE |
VARCHAR2
|
(30)
|
|
QUANTITY_ORDERED |
NUMBER
|
|
|
QUANTITY_UOM |
VARCHAR2
|
(3)
|
|
REQUESTED_SHIP_DATE |
DATE
|
|
|
REQUESTED_ARRIVAL_DATE |
DATE
|
|
|
EARLIEST_ACCEPTABLE_DATE |
DATE
|
|
|
LATEST_ACCEPTABLE_DATE |
DATE
|
|
|
DELIVERY_LEAD_TIME |
NUMBER
|
|
|
FREIGHT_CARRIER |
VARCHAR2
|
(30)
|
|
SHIP_METHOD |
VARCHAR2
|
(30)
|
|
DEMAND_CLASS |
VARCHAR2
|
(30)
|
|
SHIP_SET_NAME |
VARCHAR2
|
(30)
|
|
ARRIVAL_SET_NAME |
VARCHAR2
|
(30)
|
|
OVERRIDE_FLAG |
VARCHAR2
|
(1)
|
|
ACTION |
NUMBER
|
|
|
SHIP_DATE |
DATE
|
|
|
ARRIVAL_DATE |
DATE
|
|
|
AVAILABLE_QUANTITY |
NUMBER
|
|
|
REQUESTED_DATE_QUANTITY |
NUMBER
|
|
|
GROUP_SHIP_DATE |
DATE
|
|
|
GROUP_ARRIVAL_DATE |
DATE
|
|
|
VENDOR_ID |
NUMBER
|
|
|
VENDOR_NAME |
VARCHAR2
|
(80)
|
|
VENDOR_SITE_ID |
NUMBER
|
|
|
VENDOR_SITE_NAME |
VARCHAR2
|
(80)
|
|
INSERT_FLAG |
NUMBER
|
|
|
OE_FLAG |
VARCHAR2
|
(1)
|
|
ATP_LEAD_TIME |
NUMBER
|
|
|
ERROR_CODE |
NUMBER
|
|
|
MESSAGE |
VARCHAR2
|
(2000)
|
|
END_PEGGING_ID |
NUMBER
|
|
|
ORDER_NUMBER |
NUMBER
|
|
|
OLD_SOURCE_ORGANIZATION_ID |
NUMBER
|
|
|
OLD_DEMAND_CLASS |
VARCHAR2
|
(30)
|
|
ATO_DELETE_FLAG |
VARCHAR2
|
(1)
|
|
ATTRIBUTE_01 |
NUMBER
|
|
|
ATTRIBUTE_02 |
NUMBER
|
|
|
ATTRIBUTE_03 |
NUMBER
|
|
|
ATTRIBUTE_04 |
NUMBER
|
|
|
ATTRIBUTE_05 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_06 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_07 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_08 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_09 |
DATE
|
|
|
ATTRIBUTE_10 |
DATE
|
|
|
CUSTOMER_NAME |
VARCHAR2
|
(255)
|
|
CUSTOMER_CLASS |
VARCHAR2
|
(30)
|
|
CUSTOMER_LOCATION |
VARCHAR2
|
(40)
|
|
CUSTOMER_COUNTRY |
VARCHAR2
|
(60)
|
|
CUSTOMER_STATE |
VARCHAR2
|
(60)
|
|
CUSTOMER_CITY |
VARCHAR2
|
(60)
|
|
CUSTOMER_POSTAL_CODE |
VARCHAR2
|
(60)
|
|
SUBSTITUTION_TYP_CODE |
NUMBER
|
|
|
REQ_ITEM_DETAIL_FLAG |
NUMBER
|
|
|
REQUEST_ITEM_ID |
NUMBER
|
|
|
REQ_ITEM_REQ_DATE_QTY |
NUMBER
|
|
|
REQ_ITEM_AVAILABLE_DATE |
DATE
|
|
|
REQ_ITEM_AVAILABLE_DATE_QTY |
NUMBER
|
|
|
REQUEST_ITEM_NAME |
VARCHAR2
|
(40)
|
|
OLD_INVENTORY_ITEM_ID |
NUMBER
|
|
|
SALES_REP |
VARCHAR2
|
(255)
|
|
CUSTOMER_CONTACT |
VARCHAR2
|
(255)
|
|
SUBST_FLAG |
NUMBER
|
|
|
TOP_MODEL_LINE_ID |
NUMBER
|
|
|
ATO_PARENT_MODEL_LINE_ID |
NUMBER
|
|
|
ATO_MODEL_LINE_ID |
NUMBER
|
|
|
PARENT_LINE_ID |
NUMBER
|
|
|
MATCH_ITEM_ID |
NUMBER
|
|
|
CONFIG_ITEM_LINE_ID |
NUMBER
|
|
|
VALIDATION_ORG |
NUMBER
|
|
|
COMPONENT_SEQUENCE_ID |
NUMBER
|
|
|
COMPONENT_CODE |
VARCHAR2
|
(255)
|
|
LINE_NUMBER |
VARCHAR2
|
(80)
|
|
INCLUDED_ITEM_FLAG |
NUMBER
|
|
|
ATP_FLAG |
VARCHAR2
|
(1)
|
|
ATP_COMPONENTS_FLAG |
VARCHAR2
|
(1)
|
|
WIP_SUPPLY_TYPE |
NUMBER
|
|
|
BOM_ITEM_TYPE |
NUMBER
|
|
|
MANDATORY_ITEM_FLAG |
NUMBER
|
|
|
PICK_COMPONENTS_FLAG |
VARCHAR2
|
(1)
|
|
BASE_MODEL_ID |
NUMBER
|
|
|
OSS_ERROR_CODE |
NUMBER
|
|
|
MATCHED_ITEM_NAME |
VARCHAR2
|
(255)
|
|
CASCADE_MODEL_INFO_TO_COMP |
NUMBER
|
|
|
SEQUENCE_NUMBER |
NUMBER
|
|
|
FIRM_FLAG |
NUMBER
|
|
|
ORDER_LINE_NUMBER |
NUMBER
|
|
|
OPTION_NUMBER |
NUMBER
|
|
|
SHIPMENT_NUMBER |
NUMBER
|
|
|
ITEM_DESC |
VARCHAR2
|
(255)
|
|
OLD_LINE_SCHEDULE_DATE |
DATE
|
|
|
OLD_SOURCE_ORGANIZATION_CODE |
VARCHAR2
|
(7)
|
|
FIRM_SOURCE_ORG_ID |
NUMBER
|
|
|
FIRM_SOURCE_ORG_CODE |
VARCHAR2
|
(7)
|
|
FIRM_SHIP_DATE |
DATE
|
|
|
FIRM_ARRIVAL_DATE |
DATE
|
|
|
SHIP_METHOD_TEXT |
VARCHAR2
|
(255)
|
|
SHIP_SET_ID |
NUMBER
|
|
|
ARRIVAL_SET_ID |
NUMBER
|
|
|
PROJECT_ID |
NUMBER
|
|
|
TASK_ID |
NUMBER
|
|
|
PROJECT_NUMBER |
VARCHAR2
|
(30)
|
|
TASK_NUMBER |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_11 |
NUMBER
|
|
|
ATTRIBUTE_12 |
NUMBER
|
|
|
ATTRIBUTE_13 |
NUMBER
|
|
|
ATTRIBUTE_14 |
NUMBER
|
|
|
ATTRIBUTE_15 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_16 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_17 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_18 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_19 |
DATE
|
|
|
ATTRIBUTE_20 |
DATE
|
|
|
ATTRIBUTE_21 |
NUMBER
|
|
|
ATTRIBUTE_22 |
NUMBER
|
|
|
ATTRIBUTE_23 |
NUMBER
|
|
|
ATTRIBUTE_24 |
NUMBER
|
|
|
ATTRIBUTE_25 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_26 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_27 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_28 |
VARCHAR2
|
(30)
|
|
ATTRIBUTE_29 |
DATE
|
|
|
ATTRIBUTE_30 |
DATE
|
|
|
ATF_DATE |
DATE
|
|
|
PLAN_ID |
NUMBER
|
|
|
ORIGINAL_REQUEST_DATE |
DATE
|
|
|
RECEIVING_CAL_CODE |
VARCHAR2
|
(14)
|
|
INTRANSIT_CAL_CODE |
VARCHAR2
|
(14)
|
|
SHIPPING_CAL_CODE |
VARCHAR2
|
(14)
|
|
MANUFACTURING_CAL_CODE |
VARCHAR2
|
(14)
|
|
INTERNAL_ORG_ID |
NUMBER
|
|
|
FIRST_VALID_SHIP_ARRIVAL_DATE |
DATE
|
|
|
PARTY_SITE_ID |
NUMBER
|
|
|