invantive documentation
Invantive Support ForumsLog In / Sign Up

CRS_AKP: AccountView Inventory revaluation

read only per partition

  • Catalog: AccountView
  • Label: Inventory revaluation

Can only retrieve data.

Table Columns

The columns of the table CRS_AKP are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
DFF_PNC_PC int64 Difference new price - current price
DFF_PNC_PP int64 Difference new price - purchase price
DFF_PNC_PS int64 Difference selling price - new price
DFP_PNC_PC decimal Difference % new price / current price
DFP_PNC_PP decimal Difference % new price / purchase price
DFP_PNC_PS decimal Difference % selling price / new price
DIFF_PC_PP int64 Difference current price - purchase price
DIFF_PC_PS int64 Difference selling price - current price
DIFP_PC_PP decimal Difference % current price / purchase price
DIFP_PC_PS decimal Difference % selling price / current price
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PX_CALC int64 Current valuation price
PX_N_CALC int64 New valuation price
PX_PCHSX int64 Purchase price (functional currency)
PX_SELLX int64 Selling price (functional currency)
VAL_CALC int64 Current inventory value
VAL_N_CALC int64 New inventory value