IC_COSTING_TYPES

Costing types

tableFINIC

IC_COSTING_TYPES — Costing types. FIN table in the standard Ross ERP 8.0 schema: 10 columns, used by 22 programs. Columns, data types, keys, foreign keys and relationships.

Open IC_COSTING_TYPES in the interactive Data Dictionary →

Part of IC tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2COMPANY_CODEvarchar(10)PKCompany Code
3COSTING_TYPEvarchar(8)PKInventory Costing Type
4COSTING_TYPE_DESCvarchar(30)Inventory Costing Type
5INV_VALUATION_METHODvarchar(4)Inventory Valuation Method
6IC_COSTING_CYCLEvarchar(1)Inventory Costing Term
7CUR_VAL_FLAGvarchar(1)Using Market Price Flag
8CUR_VAL_AK_FLAGvarchar(1)written off/reserve Flag
9COSTING_METHODvarchar(3)Standard/Actual Cost
10LAST_COST_FLAGvarchar(3)Last Cost Selection