1. Tables and Views for SCM
  2. CST_INV_TO_LINES_INT_I_GT

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