CST_INV_TO_LINES_INT_I_GT
This table is used to temporarily store a subset of data from cst_transfer_order_lines table to support internal processing within the Cost Processor
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
CST_INV_TO_LINES_INT_I_GT_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 30 | Yes | Identifies the external (to costing) system that creates data in the interface. It is assumed that the inventory transactions will originate from the same system. | |
EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Identifier of the unique record in the external system. For Fusion TO, this is the transfer order line identifier. | |
ORIGIN_SOURCE | VARCHAR2 | 30 | Yes | Min-Max, Requisitions, Planning, Back to Back, Return, SSP. | |
TRANSFER_ORDER_NUMBER | VARCHAR2 | 50 | Yes | Indicates Transfer order number for Inv lines | |
LINE_NUMBER | NUMBER | 9 | Yes | Transfer order line number. | |
REQUISITIONING_BU_ID | NUMBER | 18 | Requisitioning BU of the transfer order. | ||
REQUISITION_LINE_ID | NUMBER | 18 | Reference to unique identifier of the requisition line number from which this Transfer order line was created | ||
ORDERED_DATE | DATE | Yes | Transfer Order creation date. | ||
DESCRIPTION | VARCHAR2 | 240 | Description for transfer order. | ||
FULFILL_ORCHESTRATION_REQUIRED | VARCHAR2 | 1 | Yes | Indicates if TO needs to be interfaced to DOO. It will be Y or N. | |
SOURCE_ORG_ID | NUMBER | 18 | Yes | The source organization as entered on the transfer order but this could be changed in DOO and could be split across multiple source organizations. | |
DESTINATION_ORG_ID | NUMBER | 18 | Yes | The destination organization as on the transfer order. | |
DESTINATION_TYPE_CODE | VARCHAR2 | 30 | Yes | Inventory or Expense. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item identifier for Transfer Order Lines | |
REQUESTED_QUANTITY | NUMBER | Yes | Requested quantity for the distribution. | ||
UOM | VARCHAR2 | 3 | Yes | Unit of Measure of the requested quantity. | |
SECONDARY_REQUESTED_QTY | NUMBER | The requested quantity in the secondary unit of measure. | |||
SECONDARY_QTY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure for Transfer Order Lines | ||
UNIT_PRICE | NUMBER | The unit transfer price, indicative. | |||
INCL_NONRECOVERABLE_TAX | NUMBER | Included Unit Non-Recoverable Tax. | |||
INCL_RECOVERABLE_TAX | NUMBER | Included Unit Recoverable Tax. | |||
NONINCL_NONRECOVERABLE_TAX | NUMBER | Non-included Unit Non-Recoverable Tax. | |||
NONINCL_RECOVERABLE_TAX | NUMBER | Non-included Unit Recoverable Tax. | |||
CURRENCY_CODE | VARCHAR2 | 15 | The functional currency of the destination organization. | ||
TRADE_AGREEMENT_PTR_ID | NUMBER | 18 | The price_agreement_id on the transfer order is going to be modified to carry the SFO PTR ID. | ||
ORIGINAL_HEADER_ID | NUMBER | 18 | Reference to unique identifier for the original Transfer Order Number in case this Transfer Order is of type 'Return'. | ||
ORIGINAL_LINE_ID | NUMBER | 18 | Reference to unique identifier for the original Transfer Order Line in case this Transfer Order is of type 'Return'. | ||
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. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_INV_TO_LINES_INT_I_GT_U1 | Unique | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |