CST_INV_TXNS_INSERT_CT_GT
Cost transactions that need to be inserted into CST_TRANSACTIONS
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier which uniquely identifies a transaction in costing. | |
IGNORE_INTRA_VU_FLAG | VARCHAR2 | 1 | This flag indicates whether to ignore intra valuation unit transfers for costing. Possible values are 'Y','N' and NULL. | ||
UNREFERENCED_RMA_COST_CODE | VARCHAR2 | 30 | Cost option to value sales returns without any reference to the original sales order, which can be the existing item cost or the price on RMA order. | ||
CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Costing inventory transaction identifier | |
CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | Costing inventory transaction lot/serial detail identifier | ||
COST_ORG_ID | NUMBER | 18 | Yes | Identifies the cost organization to which the inventory organization is associated | |
COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book assigned to the cost organization. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Value that identifies the inventory item associated with the transaction. | |
INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates the inventory org to which the item belongs. | |
ITEM_COST_PROFILE_ID | NUMBER | 18 | Identifies item cost profile associated with the transaction. | ||
COST_PROFILE_ID | NUMBER | 18 | Identifies cost profile associated with the transaction. | ||
COST_METHOD_CODE | VARCHAR2 | 30 | The cost method code as specified on the cost profile | ||
NEGATIVE_QTY_CODE | VARCHAR2 | 30 | Code as specified on the cost profile | ||
ENFORCE_TXN_DATE_ORDER_FLAG | VARCHAR2 | 5 | Profile option to have cost dates in the same order as the transaction date. Possible values are (Y)es and (N)o. | ||
QUANTITY_FLOW_CODE | VARCHAR2 | 30 | Code as specified on the cost profile | ||
PROPAGATE_COST_ADJ_FLAG | VARCHAR2 | 1 | Code as specified on the cost profile | ||
RECEIPT_WITHOUT_COST_CODE | VARCHAR2 | 30 | Code as specified on the cost profile | ||
REFERENCED_RMA_COST_CODE | VARCHAR2 | 30 | Code as specified on the cost profile | ||
COST_BY_UOM_TYPE | VARCHAR2 | 30 | Defaulted from the cost profile and its value can either be PRIMARY or SECONDARY | ||
STATUS | VARCHAR2 | 30 | Indicates the status of the transaction. | ||
ERROR_CODE | VARCHAR2 | 30 | Error code associated with the transaction | ||
LOGICAL_FLAG | VARCHAR2 | 1 | Whether a transaction is logical (not physical) or not | ||
INTRANSIT_FLAG | VARCHAR2 | 1 | Whether a transaction affects in-transit or physical inventory | ||
PROVISIONAL_COMPLETION_TYPE | VARCHAR2 | 30 | Work order valuation option to for valuing work order partial completions into inventory. | ||
OPERATION_SCRAP_COST_TYPE | VARCHAR2 | 30 | Work order valuation option for including scrap costs as a part of inventory or expensing out. | ||
QUANTITY | NUMBER | Quantity in costing unit of measure | |||
UOM_CODE | VARCHAR2 | 3 | Costing unit of measure as specified on the item cost profile | ||
UOM_CONVERSION_FACTOR | NUMBER | UOM conversion factor between the Primary quantity specified in Primary uom of the item and the Costing quantity specified in the costing uom defined in the item cost profile. If the Cost by UOM type is Primary, then the conversion factor is "1" and if it is Secondary, then the conversion factor is secondary_qty/primary_qty. There are cases where the uom on the transaction would be different from the costing uom, in that case uom conversion api is used to get the conversion from primary uom to costing uom. | |||
TRANSACTION_QTY | NUMBER | Transaction quantity as specified in the transaction uom | |||
COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transaction type which is either RECEIPT or ISSUE. | ||
ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Specifies the transactions that are further classified with the cost transaction type. It can either be null or TRANSFER | ||
USE_ITEM_COST_FLAG | VARCHAR2 | 1 | Specifies whether to use the current item cost or the incoming cost | ||
VAL_STRUCTURE_ID | NUMBER | 18 | Identifies the valuation structure. | ||
STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Structure instance number for the valuation unit | ||
VAL_UNIT_ID | NUMBER | 18 | Indicates valuation unit identifier for transaction. | ||
VAL_UNIT_DETAIL_ID | NUMBER | 18 | Valuation unit detail identifier. | ||
VAL_UNIT_COMBINATION_ID | NUMBER | 18 | Valuation unit code combination identifier | ||
EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Whether a transaction is asset or expense | ||
TRANSFER_COST_ORG_ID | NUMBER | 18 | The transfer cost organization identifier. | ||
TRANSFER_BOOK_ID | NUMBER | 18 | Cost book to be used for processing transfer transaction. | ||
TRANSFER_CST_INV_TXN_DTL_ID | NUMBER | 18 | Links the transfer transactions back to the costing inventory transaction identifier | ||
CONSIGNED_ACCT_DIST_BASIS | VARCHAR2 | 30 | Indicates the Consigned Accounting Distribution basis for the cost profile. | ||
CREATE_ACCT_FOR_CONS_TXNS | VARCHAR2 | 1 | Creating accounting for consigned transactions Flag - Y or N | ||
POSTED_FLAG | VARCHAR2 | 1 | Pass this flag to CT as to ignore costing or N to process the transactions. | ||
WO_COST_ALLOCATION_BASIS | VARCHAR2 | 30 | The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. Valid values exist in lookup ORA_WIS_COST_ALLOC_BASIS. | ||
STD_OH_ABSORPTION_FLAG | VARCHAR2 | 1 | This column indicates the decision derived by Cost processor whether to absorb or not absorb the overhead for a costing transaction. This is applicable only for standard cost method. Valid values are Y/N. 'Y' or null means absorb overheads, 'N' means do not absorb overheads. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_INV_TXNS_INSERT_CT_GT_N1 | Non Unique | CST_INV_TRANSACTION_ID, COST_ORG_ID, COST_BOOK_ID, NVL("CST_INV_TRANSACTION_DTL_ID",0) |