CST_COST_ADJ

Details

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

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TRANSACTION_ID	NUMBER		18	Yes	Single column FK: Identifies the costing transaction.	Active
COST_ELEMENT_ID	NUMBER		18	Yes	Cost element corresponding to the cost of the transaction.	Active
EFF_DATE	TIMESTAMP			Yes	Cost in Effect Date	Active
COST_DATE	TIMESTAMP			Yes	Transaciton Cost Date	Active
TRANSACTION_COST_ID	NUMBER		18	Yes	Single column FK: Identifies the transaction cost.	Active
COST_ORG_ID	NUMBER		18	Yes	Single column FK: Identifies the Cost Organization associated with the inventory organization.	Active
COST_BOOK_ID	NUMBER		18	Yes	Single column FK: Identifies the Cost Book assigned to the Cost Organization.	Active
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory Item Identifier	Active
VAL_UNIT_ID	NUMBER		18	Yes	Valuation unit identifier	Active
BASE_TXN_TYPE_ID	NUMBER		18		Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.
COST_TRANSACTION_TYPE	VARCHAR2	10			Cost Transaction Type is used by the costing engine to categorize group processing. Set to 'ADJUST' for adjustments, null otherwise.
ADDITIONAL_PROCESSING_CODE	VARCHAR2	240			Additional Processing Code is an optional further definition of the Cost Transaction Type. It is used on adjustment transactions (Cost Transaction Type is set to 'ADJUST') and is set to 'USER' when the adjustment was done by the user; otherwise, it is set to null.
QUANTITY_ONHAND	NUMBER				Current Quantity Onhand	Active
QUANTITY_ADJUST	NUMBER				Adjustment Quantity	Active
UNIT_COST_ADJUST	NUMBER				Adjustment Cost	Active
UOM_CODE	VARCHAR2	30		Yes	Transaction Unit of Measure	Active
CURRENCY_CODE	VARCHAR2	30		Yes	Identifies the currency of the transaction / cost.	Active
PROCESS_FLAG	VARCHAR2	1			Process Row Flag: R=RECEIPT, U=USER, I=ITEM, X=DO NOT PROCESS	Active