CST_MULTI_USR_ADJS_EFFDATE_GT

Global temporary table where we have all the user adjustments staged on a transaction and update the effective date of adjustments such that cost dates and effective dates are in order.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_ID	NUMBER		18	Yes	For item cost adjustments only, this column holds the reference to the logical transaction in CST_TRANSACTIONS; otherwise, the value is 0.
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.
COST_ELEMENT_ID	NUMBER		18	Yes	Cost element corresponding to the cost of the transaction.
EFF_DATE	TIMESTAMP			Yes	Indicates the user entered date of the cost adjustment.
USER_ADJUSTMENT_ID	NUMBER		18	Yes	Surrogate key that identifies a row in this table.
NEW_COST	NUMBER			Yes	Indicates the new cost specified by the user.
CURRENCY_CODE	VARCHAR2	15			Identifies the currency of the transaction / cost.
POSTED_FLAG	VARCHAR2	1		Yes	Indicates if the cost adjustment has been processed by the cost processor and posted to the CST_TRANSACTION_COSTS table. N - No, Y - Yes. There is no LOOKUP_TYPE for these codes.
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.
COST_DATE	TIMESTAMP				Date to be used for transaction sequencing. This field is populated by the cost processor during background processing.
EXPENSE_POOL_ID	NUMBER		18		Identifies the expense pool of the cost adjustment.
ADJUSTMENT_NUMBER	VARCHAR2	50			Document number for this adjustment.
STATUS_CODE	VARCHAR2	30			Indicates the status of the adjustment detail. P-pending, C-canceled, S-submitted.
ADJUSTMENT_DATE	TIMESTAMP				Time stamp that the adjustment is made.
ORIGINAL_EFF_DATE	TIMESTAMP				This column is used internally to keep track of original effective date while ordering the transactions.
PERIOD_NAME	VARCHAR2	15			Period for which cost processor is executed in a PAC cost book.