CST_PERPAVG_COST2_GT

Current Perpavg Cost and Transaction Cost

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

Columns

Name

TRANSACTION_IDNUMBER18YesSingle column FK: Identifies the costing transaction.Active

REC_TRXN_IDNUMBER18YesReceipt Transaction IdentifyerActive

DEP_TRXN_IDNUMBER18YesDeplete Transaction IdentifyerActive

COST_ELEMENT_IDNUMBER18YesCost element corresponding to the cost of the transaction.Active

EXPENSE_POOL_IDNUMBER18YesExpense Pool IdentifierActive

EFF_DATETIMESTAMPYesCost in Effect DateActive

COST_DATETIMESTAMPYesTransaciton Cost DateActive

COST_ORG_IDNUMBER18YesSingle column FK: Identifies the Cost Organization associated with the inventory organization.Active

COST_BOOK_IDNUMBER18YesSingle column FK: Identifies the Cost Book assigned to the Cost Organization.Active

INVENTORY_ITEM_IDNUMBER18YesInventory Item IdentifierActive

VAL_UNIT_IDNUMBER18YesValuation unit identifierActive

UNIT_COST_ONHANDNUMBERCurrent Perpavg CostActive

UNIT_COST_NEWNUMBERCurrent Transaction CostActive

UNIT_COST_ADJUSTNUMBERAdjustment CostActive

CURRENCY_CODEVARCHAR230Identifies the currency of the transaction / cost.Active