CST_ITEM_COST_ADJUSTMENTS

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
TRANSACTION_ID	NUMBER		18	Surrogate ID identifying the inventory transactions in CST_TRANSACTIONS.
COST_ORG_ID	NUMBER		18	Identifier for the cost organization.
COST_BOOK_ID	NUMBER		18	Identifier for the cost book associated with the cost organization.
INVENTORY_ITEM_ID	NUMBER		18	Identifier for the inventory item.
VAL_UNIT_ID	NUMBER		18	Identifier for the valuation unit.
EFF_DATE	TIMESTAMP			Effective date of the cost used to create this transaction.
SOURCE_TRANSACTION_ID	NUMBER		18	Identifies the source transaction.
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_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.
ADJUSTMENT_HEADER_ID	NUMBER		18	Unique identifier of the user cost adjustment header record.
ADJUSTMENT_NUMBER	VARCHAR2	50		The document number for user adjustment.
STATUS	VARCHAR2	1		Adjustment processing status indicator. Possible values are N/NULL - adjustment will be considered for processing, X - adjustment will be excluded from processing.
PERIOD_NAME	VARCHAR2	15		Identifier for the costing period.
ITEM_COST_PROFILE_ID	NUMBER		18	Identifies the item cost profile associated with the transaction.
COST_PROFILE_ID	NUMBER		18	Identifies the cost profile associated with the transaction.