[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ST_SALES_ORDERS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_ST_SALES_ORDERS
|
| Subobject Name: | |
| Status: | VALID |
The staging table used by the collection program to validate and process data for table MSC_SALES_ORDERS.
| Tablespace: |  |
|---|---|
| PCT Free: | |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| DEMAND_ID | NUMBER | Unique identifier of a demand row from source application instance | ||
| PRIMARY_UOM_QUANTITY | NUMBER | Primary UOM quantity | ||
| RESERVATION_TYPE | NUMBER | Code for type of reservation | ||
| RESERVATION_QUANTITY | NUMBER | otal quantity reserved expressed in primary unit of measure | ||
| DEMAND_SOURCE_TYPE | NUMBER | Demand source type | ||
| DEMAND_SOURCE_HEADER_ID | NUMBER | Header ID for the source of the demand | ||
| COMPLETED_QUANTITY | NUMBER | Completed quantity | ||
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory code | |
| DEMAND_CLASS | VARCHAR2 | (34) | Demand class code | |
| REQUIREMENT_DATE | DATE | Planned ship date for summary demand | ||
| DEMAND_SOURCE_LINE | VARCHAR2 | (40) | Line id of demand source | |
| DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | For Sales Order demand, Line id of Sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID) from source application instance | |
| DEMAND_SOURCE_NAME | VARCHAR2 | (30) | Identifier for user-defined Source Type | |
| PARENT_DEMAND_ID | NUMBER | Parent demand identifier | ||
| DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS will be deleted | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| REFRESH_ID | NUMBER | Refresh number populated by the collection program | ||
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
| SALES_ORDER_NUMBER | VARCHAR2 | (122) | Sales order number | |
| SALESREP_CONTACT | VARCHAR2 | (100) | Sales Representative Contact Info | |
| ORDERED_ITEM_ID | NUMBER | Ordered item identifier | ||
| AVAILABLE_TO_MRP | VARCHAR2 | (1) | Available to MRP flag | |
| CUSTOMER_ID | NUMBER | Customer identifier | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Ship to identifier of the sales order | ||
| BILL_TO_SITE_USE_ID | NUMBER | Bill to identifier of the sales order | ||
| LINE_NUM | NUMBER | Sales order line number | ||
| TERRITORY_ID | NUMBER | Territory identifier of the sales order | ||
| UPDATE_SEQ_NUM | NUMBER | Update sequence number | ||
| DEMAND_TYPE | NUMBER | Demand type | ||
| PROJECT_ID | NUMBER | Project identifier | ||
| TASK_ID | NUMBER | Task identifier | ||
| PLANNING_GROUP | VARCHAR2 | (30) | Planning group | |
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Unit number identifier | |
| DEMAND_PRIORITY | NUMBER | Demand priority | ||
| ATP_REFRESH_NUMBER | NUMBER | Number used to co-ordinate Collections with ATP | ||
| REQUEST_DATE | DATE | Request Date | ||
| SELLING_PRICE | NUMBER | Unique identifier of a demand row from source application instance | ||
| DEMAND_VISIBLE | VARCHAR2 | (1) | Demand Visibility Flag | |
| FORECAST_VISIBLE | VARCHAR2 | (1) | Forecast Visibility Flag | |
| CTO_FLAG | NUMBER | Unique identifier of a demand row from source application instance | ||
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original System Refrence | |
| ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | Original System Line Reference | |
| COMPANY_ID | NUMBER | Company identifier | ||
| COMPANY_NAME | VARCHAR2 | (255) | Company name | |
| ITEM_NAME | VARCHAR2 | (250) | Item name | |
| ORDERED_ITEM_NAME | VARCHAR2 | (250) | Ordered Item Name | |
| CUSTOMER_NAME | VARCHAR2 | (255) | Customer Name | |
| SHIP_TO_SITE_CODE | VARCHAR2 | (30) | Shipping site code | |
| BILL_TO_SITE_CODE | VARCHAR2 | (30) | Billing site code | |
| ORGANIZATION_CODE | VARCHAR2 | (7) | Organization code | |
| SR_INSTANCE_CODE | VARCHAR2 | (3) | Source instance Code | |
| PROJECT_NUMBER | VARCHAR2 | (25) | Project number | |
| TASK_NUMBER | VARCHAR2 | (25) | Task Number | |
| MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | ||
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | ||
| BATCH_ID | NUMBER | Batch identifier generated during pre-processing | ||
| DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source Type indicating the source of the records | |
| ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
| ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
| COMMENTS | VARCHAR2 | (1000) | Comments | |
| ORDER_RELEASE_NUMBER | VARCHAR2 | (20) | Order Release Number | |
| END_ORDER_NUMBER | VARCHAR2 | (240) | End Order Number | |
| END_ORDER_RELEASE_NUMBER | VARCHAR2 | (20) | End Order Release Number | |
| END_ORDER_LINE_NUMBER | VARCHAR2 | (20) | End Order Line Number | |
| END_ORDER_TYPE | VARCHAR2 | (240) | End Order Type | |
| NEW_ORDER_PLACEMENT_DATE | DATE | New Order Placement Date | ||
| ORIGINAL_ITEM_ID | NUMBER | Original Item Id in case of Product Substitution | ||
| PROMISE_DATE | DATE | Date promised to the customer | ||
| ORIGINAL_ITEM_NAME | VARCHAR2 | (250) | Original Item Name in case of substitution | |
| LINK_TO_LINE_ID | NUMBER | Parent Line Identifier | ||
| CUST_PO_NUMBER | VARCHAR2 | (50) | Customer Purchase Order Number | |
| CUSTOMER_LINE_NUMBER | VARCHAR2 | (50) | Refrence Information.Contains customer line number, if specified while importing an order. | |
| MFG_LEAD_TIME | NUMBER | |||
| ORDER_DATE_TYPE_CODE | NUMBER | |||
| LATEST_ACCEPTABLE_DATE | DATE | |||
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | ||
| SCHEDULE_ARRIVAL_DATE | DATE | |||
| ORG_FIRM_FLAG | NUMBER | |||
| SHIP_SET_ID | NUMBER | |||
| ARRIVAL_SET_ID | NUMBER | |||
| SOURCE_DEMAND_SOURCE_HEADER_ID | NUMBER | |||
| SOURCE_ORGANIZATION_ID | NUMBER | |||
| SOURCE_ORIGINAL_ITEM_ID | NUMBER | |||
| SOURCE_DEMAND_ID | NUMBER | |||
| SOURCE_INVENTORY_ITEM_ID | NUMBER | |||
| SOURCE_CUSTOMER_ID | NUMBER | |||
| SOURCE_BILL_TO_SITE_USE_ID | NUMBER | |||
| SOURCE_SHIP_TO_SITE_USE_ID | NUMBER | |||
| ATO_LINE_ID | NUMBER | |||
| SHIP_SET_NAME | VARCHAR2 | (30) | ||
| ARRIVAL_SET_NAME | VARCHAR2 | (30) | ||
| SALESREP_ID | NUMBER | |||
| INTRANSIT_LEAD_TIME | NUMBER | |||
| SOURCE_DEMAND_SOURCE_LINE | VARCHAR2 | (40) | ||
| ROW_TYPE | NUMBER | |||
| REVISED_DMD_DATE | DATE | Revised Demand Date | ||
| REVISED_DMD_PRIORITY | NUMBER | Revised Demand Priority | ||
| ITEM_TYPE_ID | NUMBER | |||
| ITEM_TYPE_VALUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DEMAND_ID
, PRIMARY_UOM_QUANTITY
, RESERVATION_TYPE
, RESERVATION_QUANTITY
, DEMAND_SOURCE_TYPE
, DEMAND_SOURCE_HEADER_ID
, COMPLETED_QUANTITY
, SUBINVENTORY
, DEMAND_CLASS
, REQUIREMENT_DATE
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, DEMAND_SOURCE_NAME
, PARENT_DEMAND_ID
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REFRESH_ID
, SR_INSTANCE_ID
, SALES_ORDER_NUMBER
, SALESREP_CONTACT
, ORDERED_ITEM_ID
, AVAILABLE_TO_MRP
, CUSTOMER_ID
, SHIP_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID
, LINE_NUM
, TERRITORY_ID
, UPDATE_SEQ_NUM
, DEMAND_TYPE
, PROJECT_ID
, TASK_ID
, PLANNING_GROUP
, END_ITEM_UNIT_NUMBER
, DEMAND_PRIORITY
, ATP_REFRESH_NUMBER
, REQUEST_DATE
, SELLING_PRICE
, DEMAND_VISIBLE
, FORECAST_VISIBLE
, CTO_FLAG
, ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE
, COMPANY_ID
, COMPANY_NAME
, ITEM_NAME
, ORDERED_ITEM_NAME
, CUSTOMER_NAME
, SHIP_TO_SITE_CODE
, BILL_TO_SITE_CODE
, ORGANIZATION_CODE
, SR_INSTANCE_CODE
, PROJECT_NUMBER
, TASK_NUMBER
, MESSAGE_ID
, PROCESS_FLAG
, BATCH_ID
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, ERROR_TEXT
, COMMENTS
, ORDER_RELEASE_NUMBER
, END_ORDER_NUMBER
, END_ORDER_RELEASE_NUMBER
, END_ORDER_LINE_NUMBER
, END_ORDER_TYPE
, NEW_ORDER_PLACEMENT_DATE
, ORIGINAL_ITEM_ID
, PROMISE_DATE
, ORIGINAL_ITEM_NAME
, LINK_TO_LINE_ID
, CUST_PO_NUMBER
, CUSTOMER_LINE_NUMBER
, MFG_LEAD_TIME
, ORDER_DATE_TYPE_CODE
, LATEST_ACCEPTABLE_DATE
, SHIPPING_METHOD_CODE
, SCHEDULE_ARRIVAL_DATE
, ORG_FIRM_FLAG
, SHIP_SET_ID
, ARRIVAL_SET_ID
, SOURCE_DEMAND_SOURCE_HEADER_ID
, SOURCE_ORGANIZATION_ID
, SOURCE_ORIGINAL_ITEM_ID
, SOURCE_DEMAND_ID
, SOURCE_INVENTORY_ITEM_ID
, SOURCE_CUSTOMER_ID
, SOURCE_BILL_TO_SITE_USE_ID
, SOURCE_SHIP_TO_SITE_USE_ID
, ATO_LINE_ID
, SHIP_SET_NAME
, ARRIVAL_SET_NAME
, SALESREP_ID
, INTRANSIT_LEAD_TIME
, SOURCE_DEMAND_SOURCE_LINE
, ROW_TYPE
, REVISED_DMD_DATE
, REVISED_DMD_PRIORITY
, ITEM_TYPE_ID
, ITEM_TYPE_VALUE
FROM MSC.MSC_ST_SALES_ORDERS;
MSC.MSC_ST_SALES_ORDERS does not reference any database object
MSC.MSC_ST_SALES_ORDERS is referenced by following:
MSC
MSC_ST_SALES_ORDERS#
|
|
|
|