1. Tables and Views for SCM
  2. CST_ACQ_ADJ_TXN_COSTS

CST_ACQ_ADJ_TXN_COSTS

Contains cost adjustments from AP (Accounts Payable) and are processed by the cost preprocessors into specific cost organization books. The cost adjustments are stored in the cost component and currency of the transaction and await further processing by the cost preprocessors for cost component to cost element mapping as well as currency conversion into the default currency of the ledger.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_ACQ_ADJ_TXN_COSTS_PK

COST_ORG_ID, COST_BOOK_ID, CST_INV_TRANSACTION_ID, TRANSACTION_ID, ADJUSTMENT_TRANSACTION_ID, COST_COMPONENT_ID

Columns

Name Datatype Length Precision Not-null Comments
COST_ORG_ID NUMBER 18 Yes Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Yes Single column FK: Identifies the Cost Book assigned to the Cost Organization.
CST_INV_TRANSACTION_ID NUMBER 18 Yes Single column FK: Identifies the Inventory transaction.
TRANSACTION_ID NUMBER 18 Yes Single column FK: Identifies the cost transaction.
ADJUSTMENT_TRANSACTION_ID NUMBER 18 Yes Single column FK: Identifies the cost adjustment.
COST_COMPONENT_CODE VARCHAR2 30 OBSOLETE: Identifies the cost component. Values are based on the seeded cost components in the lookup type CST_COMPONENT_CODES
COST_COMPONENT_ID NUMBER 18 Yes Cost component identifier for sources like Purchase Orders, Invoices.
NEW_COST NUMBER Yes Identifies the new cost for this cost adjustment.
NEW_ACQ_AMOUNT NUMBER New acquisition amount of the Adjustment
NEW_ENTERED_AMOUNT NUMBER Acquisition amount in purchase order entered currency.
PRIMARY_ADJ_QTY NUMBER Net quantity in item primary uom.
SECONDARY_ADJ_QTY NUMBER Net quantity in item secondary uom.
SOURCE_DOC_ADJ_QTY NUMBER Net quantity in Purchase Order uom.
PO_RCPT_QTY NUMBER Purchase Order net received quantity to calculate the landed cost charge amount.
PRIMARY_RCPT_QTY NUMBER Purchase Order net received quantity to calculate the landed cost charge amount in item primary unit of measure.
SECONDARY_RCPT_QTY NUMBER Purchase Order net received quantity to calculate the landed cost charge amount in item secondary unit of measure.
CURRENCY_CODE VARCHAR2 15 Yes Identifies the currency of the transaction / cost.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion type that should be used for currency conversion.
CURRENCY_CONVERSION_DATE TIMESTAMP The date to be used to determine the exchange rates for currency conversion
CURRENCY_CONVERSION_RATE NUMBER Optional user specified currency conversion rate.
UOM_CONVERSION_FACTOR NUMBER Identifies the UOM conversion factor between primary UOM and transaction UOM.
BASE_TXN_TYPE_ID NUMBER 18 Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.
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.
ITEM_COST_PROFILE_ID NUMBER 18 Single column FK: Identifies the Item Cost Profile.
COST_PROFILE_ID NUMBER 18 Single column FK: Identifies Cost Profile associated with the adjustment transaction.
EFF_DATE TIMESTAMP Yes This indicates the effective date of the acquisition cost.
EXPENSE_TRANSACTION_FLAG VARCHAR2 1 Identifies whether a transaction is an asset or expense transaction. Expense = Y, Asset = N.
PREPROCESSED_FLAG VARCHAR2 1 Indicates if the cost adjustment has been mapped to the target cost elements of the cost organization and converted to the default currency of the ledger. N - No, Y - Yes, X - Not required due to 0 qty case, I - Ignored due to zero delta cost. There is no LOOKUP_TYPE for these codes.
ADJUSTMENT_DATE TIMESTAMP Indicates the adjustment date derived in preprocessing to be used in cost processing acquisition cost adjustments.
SOURCE_DOC_CURR_CODE VARCHAR2 15 Indicates the transaction source document currency code.
SOURCE_DOC_CURR_CONV_TYPE VARCHAR2 30 Indicates the transaction source document currency conversion type.
SOURCE_DOC_CURR_CONV_DATE TIMESTAMP Indicates the transaction source document currency conversion date.
SOURCE_DOC_CURR_CONV_RATE NUMBER Indicates the transaction source document currency conversion rate.
OLD_COST NUMBER Indicates the value of the unit acquisition cost prior to computing the new acquisition cost populated in the NEW_COST column.
OLD_ACQ_AMOUNT NUMBER Prior acquisition amount computed.
OLD_ENTERED_AMOUNT NUMBER Old acquisition amount in purchase order currency.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
CST_ACQ_ADJ_TXN_COSTS cst_acq_cost_adjustments ADJUSTMENT_TRANSACTION_ID
CST_ACQ_ADJ_TXN_COSTS cst_inv_transactions CST_INV_TRANSACTION_ID
CST_ACQ_ADJ_TXN_COSTS cst_item_cost_profiles ITEM_COST_PROFILE_ID
CST_ACQ_ADJ_TXN_COSTS cst_cost_books_b COST_BOOK_ID

Indexes

Index Uniqueness Tablespace Columns
CST_ACQ_ADJ_TXN_COSTS_N1 Non Unique FUSION_TS_TX_DATA ADJUSTMENT_TRANSACTION_ID
CST_ACQ_ADJ_TXN_COSTS_N2 Non Unique FUSION_TS_TX_DATA PREPROCESSED_FLAG
CST_ACQ_ADJ_TXN_COSTS_U1 Unique FUSION_TS_TX_DATA COST_ORG_ID, COST_BOOK_ID, CST_INV_TRANSACTION_ID, TRANSACTION_ID, ADJUSTMENT_TRANSACTION_ID, COST_COMPONENT_ID