CST_TRANSFERS

Details

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

Primary Key

Name	Columns
CST_TRANSFERS_PK	TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TRANSACTION_ID	NUMBER		18	Yes	Single column FK: Identifies the costing transaction.	Active
REC_TRXN_ID	NUMBER		18	Yes	Identifies the receipt transaction for this transfer transaction.	Active
DEP_TRXN_ID	NUMBER		18	Yes	Identifies the deplete transaction for this transfer transaction.	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
VAL_UNIT_ID	NUMBER		18		Single column FK: Identifies the Valuation unit for the transfer transaction.	Active
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory Item identifier for the transfer transaction.	Active
COST_TRANSACTION_TYPE	VARCHAR2	10			Costing transaction types. Possible values are ISSUE or RECEIPT.	Active
COST_DATE	TIMESTAMP				Transfer transaction cost date, this will be used for transaction sequencing.	Active
PERIOD_NAME	VARCHAR2	15			Period in which the transaction is processed. This value is populated for the transactions of periodic average cost method.
TRANSFER_COST_ORG_ID	NUMBER		18		Cost Organization identifier associated with Inventory organization of the other leg of transfer transaction.
FOB_POINT	NUMBER		1		Indicates the freight on board point and determines the point of transfer of liability/ownership. Its value is 1 for SHIPMENT and 2 for RECEIPT.
QUANTITY	NUMBER				Transfer transaction quantity converted to costing unit of measure.	Active
UOM_CODE	VARCHAR2	30			Costing Unit of Measure for the transfer transaction quantity	Active
POSTED_FLAG	VARCHAR2	5			Flag to track if the transfer transaction quantity layer is posted or not.	Active
VAL_ONHAND_FLAG	VARCHAR2	1			Indicates if the on-hand calculations have been done for the layer. Values: N = Not processed, NULL = Processed for on-hand calculations
STAGED_FOR_CONV_FLAG	VARCHAR2	1			Identifies if this row has been staged in cst_transfer_txn_costs for pre-processor cost conversion and cost element remapping.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.	Active
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
CST_TRANSFERS	cst_transactions	TRANSACTION_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CST_TRANSFERS_N1	Non Unique	Default	TRANSACTION_ID	Obsolete
CST_TRANSFERS_N2	Non Unique	Default	POSTED_FLAG
CST_TRANSFERS_N3	Non Unique	Default	STAGED_FOR_CONV_FLAG
CST_TRANSFERS_N4	Non Unique	Default	VAL_ONHAND_FLAG, COST_ORG_ID, COST_BOOK_ID, TRUNC("COST_DATE")
CST_TRANSFERS_U1	Unique	Default	TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID