1. Tables and Views for SCM
  2. CST_TXN_ADJUST_COSTS_INT

CST_TXN_ADJUST_COSTS_INT

This interface table is used to store the adjustment cost records picked up from cst_transaction_costs for periodic average cost method. This table is cleared after the calculation is done.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CST_TXN_ADJUST_COSTS_INT_PK

TRANSACTION_ID, EFF_DATE, COST_ELEMENT_ID, EXPENSE_POOL_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSACTION_ID NUMBER 18 Yes Single column FK: Identifies the cost transaction.
EFF_DATE TIMESTAMP Yes The effective date of the cost record. It is the date when the cost became in effect for the transaction. For new costs, the effective date is the date stamped on the transaction. For user adjustments, the effective date is the user entry date. For acquisition cost adjustments, the effective date is the system date at time of cost processing.
COST_ELEMENT_ID NUMBER 18 Yes Cost element corresponding to the cost of the transaction.
EXPENSE_POOL_ID NUMBER 18 Yes Identifies the expense pool for which this cost is created. Indicates the following when negative value: -1: Freight Cost -2: Gain/loss on transfer price -3: Transfer Price -4: Expensed LCM cost element (capitalization flag deselected on mapping setup) -22: Used by internal logic to ignore cost for this node but transfer it to the next node for costing as gain/loss -5: Additional taxes for Brazil. Come on tops of TP.
ABSORPTION_TYPE VARCHAR2 30 Identifies the absorption type for which this cost is created.
UNIT_COST NUMBER Yes Indicates the unit cost of the cost element.
CURRENCY_CODE VARCHAR2 15 Yes Identifies the currency of the transaction cost.
COST_DATE TIMESTAMP Cost date for the adjustment costs.
PERIOD_NAME VARCHAR2 15 Yes Period in which the adjustment is processed.
COST_ORG_ID NUMBER 18 Surrogate ID identifying the cost organization to which the transaction belongs.
COST_BOOK_ID NUMBER 18 Surrogate ID identifying the cost book associated with the cost organization.
INVENTORY_ITEM_ID NUMBER 18 Surrogate ID identifying the item on the costing transaction.
VAL_UNIT_ID NUMBER 18 Valuation unit identifier associated with cost.
UOM_CODE VARCHAR2 3 Unit of measure for the transaction quantity.
TXN_PERIOD_NAME VARCHAR2 15 Period in which the transaction associated with this adjustment cost is processed
QUANTITY NUMBER Quantity of the costing transaction.
CT_BASE_TXN_TYPE_ID NUMBER 18 Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.
CT_BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, but a custom source type is treated as INVENTORY (value>100 is brought in as 13), and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES.
CT_BASE_TXN_ACTION_ID NUMBER 18 Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS.
CT_COST_TRANSACTION_TYPE VARCHAR2 30 This column stores the type of transaction e.g. RECEIPT or ISSUE.
CT_ADDITIONAL_PROCESSING_CODE VARCHAR2 30 Code specifying what kind of processing needs to be done. The value is defined in CST_INTERNAL_TXN_TYPE for the transaction type and is used by Cost Processors for additional processing.
TRANSACTION_COST_ID NUMBER 18 Surrogate ID identifying a transaction cost record.
CST_INV_TRANSACTION_ID NUMBER 18 Surrogate ID identifying the transaction row in CST_INV_TRANSACTIONS.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, and for CST it comes from lookup_type CST_BASE_TXN_SOURCE_TYPES.
BASE_TXN_ACTION_ID NUMBER 18 Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS.
BASE_TXN_TYPE_ID NUMBER 18 Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.
ADJUSTMENT_DATE TIMESTAMP Stores the adjustment date if specified by the user in the manual adjustments.
COST_SOURCE VARCHAR2 30 Identifies the source of the cost, such as Purchase Order (PO) or Accounts Payable (AP). The LOOKUP_TYPE for these values is CST_COST_SOURCES.
COST_REFERENCE VARCHAR2 100 Identifies a specific business object or value that further refines the cost source information, such as the source cost organization identifier or an effective date.
MIN_EFF_DATE TIMESTAMP This columns stores the effective date of the first adjustment in the processing period. For delta cost rows, this stores the effective date to be used to propagate any missing element to transaction costs table.
COMPUTE_PAC_FLAG VARCHAR2 1 Flag indicating if a cost is to be used for PAC calculation. Null indicates to include the cost, any other value excludes the cost.
MISSING_ELEMENT_FLAG VARCHAR2 1 Flag indicating if the cost element was present in the old cost but missing on the adjustment cost record. This element is layer recreated in cost transaction table for the adjustment records.
POSTED_FLAG VARCHAR2 5 Indicates if the adjustment is processed in cst_transaction_costs table.
PAC_TXN_GROUP_ID NUMBER 18 Surrogate ID used to group transaction into chunks for processing.
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 Tablespace Columns
CST_TXN_ADJUST_COSTS_INT_U1 Unique DEFAULT TRANSACTION_ID, EFF_DATE, COST_ELEMENT_ID, EXPENSE_POOL_ID