DOS_SUPPLY_LINES
Supply lines stores information on the individual supply requests
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOS_SUPPLY_LINES_PK |
LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LINE_ID | NUMBER | 18 | Yes | Supply Line Identifier is system generated | |
| PTO_KIT_ITEM_FLAG | VARCHAR2 | 1 | Flag to indicate that the item is a PTO Kit Item. | ||
| PARENT_ITEM_ID | NUMBER | 18 | Parent Item ID for Source System Item ID | ||
| SUPPLY_ORDER_SOURCE | VARCHAR2 | 30 | The source of this supply Request | ||
| CUSTOMER_ORDER_SOURCE_SYSTEM | VARCHAR2 | 30 | Reference to the order capture system that the source order came from | ||
| ITEM_TYPE | VARCHAR2 | 30 | This is a flag to indicate whether it is an outsourced item, standard item, ATO or PTO or back to back. (can have multiple values) | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| HEADER_ID | NUMBER | 18 | Yes | Supply Order Header Identifier foreign key to DOS_SUPPLY_HEADERS | |
| PARENT_LINE_ID | NUMBER | 18 | Parent Line Identifier links to this line's parent line | ||
| LINE_NUMBER | NUMBER | 18 | Yes | Supply Line Number. Unique number for a particular Supply Order. | |
| SUPPLY_OPERATION | VARCHAR2 | 30 | Yes | Operation to be performed for the supply creation | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Status code of the Supply Line derived from lookups | |
| SUPPLY_TYPE | VARCHAR2 | 30 | Yes | Type of supply being created like MAKE, BUY | |
| SUPPLY_SOURCE_SYSTEM | VARCHAR2 | 120 | Source system code where the supply request is getting executed. | ||
| SOURCE_SYSTEM_ID | VARCHAR2 | 120 | Value will be from DOO and will be a valid value in HZ_ORIG_SYSTEMS_VL.ORIG_SYSTEM_ID | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | The system identifier for the Inventory Item being requested | |
| EXEC_SYSTEM_ITEM_NUMBER | VARCHAR2 | 300 | This field identifies the item number in the execution system. This value will be used by task layer while communicating with the non fusion systems. | ||
| ITEM_REVISION | VARCHAR2 | 72 | The revision of the item being requested | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of Measure for the Quantity being requested | |
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Description of the item in the item master | ||
| SUPPLY_ORDER_REF_LINE_NUMBER | VARCHAR2 | 20 | Identifier of the source system that generated the interface record. Document Line reference number from the requesting system | ||
| QUANTITY | NUMBER | Yes | Supply Quantity being requested for this order | ||
| SUPPLY_ORDER_REFERENCE_LINE_ID | NUMBER | 18 | Identifier of the source system that generated the interface record. | ||
| SECONDARY_QUANTITY | NUMBER | Secondary Quantity requested for this order | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary Quantity Unit of Measure | ||
| NEED_BY_DATE | TIMESTAMP | Yes | Date when the supply needs to be available | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Destination organization ID (for purchase request and internal req request) | ||
| DESTINATION_ORGANIZATION_CODE | VARCHAR2 | 18 | Destination Organization Code (for internal req) | ||
| DESTINATION_BU_ID | NUMBER | 18 | Operating unit in the source system for the destination organization | ||
| CHANGE_PENDING_FLAG | VARCHAR2 | 1 | Yes | Change Pending Identifier (Must be Y/N) This flag will be set to Y if any child tracking line is in change pending. If all the tracking lines' change pending flag set to N, this flag will be also set to N. If this flag sets to Y due to line-level change, all the child tracking lines' change panding flag will be also set to Y. | |
| BACK_TO_BACK_FLAG | VARCHAR2 | 1 | Yes | Back To Back Indicator Flag indicating this is a Back To Back request | |
| CONTRACT_MANUFACTURING_FLAG | VARCHAR2 | 1 | Yes | Contract Manufacturing Item, Indicator Flag | |
| CONFIG_ITEM_FLAG | VARCHAR2 | 1 | Yes | Flag to Indicate that the item is a configured Item. | |
| CUSTOMER_ORDER_NUMBER | VARCHAR2 | 50 | Customer Order ID for the DOO fline | ||
| CUSTOMER_ORDER_LINE_NUMBER | VARCHAR2 | 50 | Customer order line Id for the DOO fline | ||
| CUSTOMER_ORDER_SCHEDULE_NUMBER | VARCHAR2 | 50 | Customer order schedule ID for the DOO fline | ||
| CUSTOMER_ID | NUMBER | 18 | Customer Id for the DOO fulfillment line | ||
| CUSTOMER_SHIP_TO_ID | NUMBER | 18 | Customer Ship To ID for the DOO fline | ||
| CUSTOMER_CONTACT_ID | NUMBER | 18 | Customer Contact ID for the DOO fline | ||
| SPLIT_LINE_REFERENCE_ID | VARCHAR2 | 300 | GOP_REFERENCE_ID used for splits of DOO fline | ||
| PREPARER_ID | NUMBER | 18 | Preparer of this supply request must be a valid user | ||
| OUTSIDE_PROCESSING_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether this order is for Outside Processing supply | |
| MOVEMENT_REQUEST_FLAG | VARCHAR2 | 1 | Flag to indicate if this is for a movement request | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOS_SUPPLY_LINES_FK1 | Non Unique | FUSION_TS_TX_IDX | HEADER_ID |
| DOS_SUPPLY_LINES_N1 | Non Unique | FUSION_TS_TX_IDX | SUPPLY_ORDER_REFERENCE_LINE_ID |
| DOS_SUPPLY_LINES_U1 | Unique | FUSION_TS_TX_IDX | LINE_ID |