CST_RESOURCE_TXNS_TO_PROC

Details

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

Columns

Name	Datatype	Length	Precision	Comments
CST_WO_RESOURCE_TXN_ID	NUMBER		18	Surrogate ID identifying the resource transaction interfaced to costing from manufacturing.
COST_ORG_ID	NUMBER		18	Surrogate ID identifying the cost organization which is associated to the plant/inventory organization of the resource transaction.
COST_BOOK_ID	NUMBER		18	Surrogate ID identifying the cost book to which this transaction belongs.
MASTER_ORGANIZATION_ID	NUMBER		18	Surrogate ID identifying the master inventory organization associated to the cost organization. This value is derived from CST_COST_ORG_PARAMETERS.
INVENTORY_ITEM_ID	NUMBER		18	Reference to the unique identifier for the inventory item
COST_PROFILE_TYPE_FLAG	VARCHAR2	1		The type of cost profile needed. The possible values are (A)sset, (E)xpense and (C)onsigned.
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.
INVENTORY_ORGANIZATION_ID	NUMBER		18	Surrogate ID identifying the plant where the resource was consumed. This attribute will be derived from the work order and de-normalized to improve performance.
RESOURCE_ID	NUMBER		18	Surrogate ID identifying the resource. This is a foreign key reference to the resource master at the plant level.
CST_WORK_ORDER_ID	NUMBER		18	Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID	NUMBER		18	Surrogate ID identifying the operation in the work order tied to this resource.
WORK_CENTER_ID	NUMBER		18	The work center where the resource is charged.
WO_OPERATION_RESOURCE_ID	NUMBER		18	The operation-resource reference from the work order.
RESOURCE_ACTIVITY_CODE	VARCHAR2	30		Activity in the first release of fusion will be used to define any intra operation steps + any other custom run steps that the customer would like to track at the resource level.
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30		Surrogate ID identifying the resource transaction in the source system.
BASE_TXN_TYPE_ID	NUMBER		18	Resource transaction type identifier. For resource transactions it would be a costing internal transaction type defined in CST_INTERNAL_TXN_TYPES_VL.
TRANSACTION_DATE	TIMESTAMP			Date and time when the resource transaction is performed.
TRANSACTION_QUANTITY	NUMBER			Quantity of resource to be charged.
TRANSACTION_UOM_CODE	VARCHAR2	3		The unit of measure for the transacted units.
PRIMARY_QUANTITY	NUMBER			Transaction quantity converted using the primary UOM of the primary product.
PRIMARY_UOM_CODE	VARCHAR2	3		Primary unit of measure for the primary product in the work order.
WORK_ORDER_NUMBER	VARCHAR2	120		Work Order Number in manufacturing. The uniqueness of which will be controlled by user at the work method level or at the plant level.