IC_PERIOD_INVENTORY
Period Inventory
tableFINIC
IC_PERIOD_INVENTORY — Period Inventory. FIN table in the standard Ross ERP 8.0 schema: 45 columns, used by 22 programs. Columns, data types, keys, foreign keys and relationships.
Open IC_PERIOD_INVENTORY in the interactive Data Dictionary →Part of IC tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | DIVISION | varchar(2) | PK | Division |
| 4 | YEAR | smallint | PK | Year Number |
| 5 | PERIOD | smallint | PK | Period Number |
| 6 | PART_CODE | varchar(15) | PK | Product |
| 7 | COSTING_TYPE | varchar(8) | Inventory Costing Type | |
| 8 | OPEN_INV_QTY | numeric(20,6) | Period Opening Quantity | |
| 9 | OPEN_INV_COST | numeric(20,12) | Period Opening Cost | |
| 10 | OPEN_INV_VALUE | numeric(20,2) | Period Opening Value | |
| 11 | CLOSE_INV_QTY | numeric(20,6) | Closing Inventory Quantity | |
| 12 | CLOSE_INV_COST | numeric(20,12) | Closing Inventory Cost | |
| 13 | CLOSE_INV_VALUE | numeric(20,2) | Closing Inventory Value | |
| 14 | PERIOD_IN_QTY | numeric(20,6) | Period In Quantity | |
| 15 | PERIOD_IN_VALUE | numeric(20,2) | Period In Value | |
| 16 | PERIOD_MISC_COST | numeric(20,2) | Period Additional Cost | |
| 17 | PERIOD_DISCOUNT | numeric(20,2) | Period Discount | |
| 18 | PERIOD_OUT_QTY | numeric(20,6) | Period Out Quantity | |
| 19 | PERIOD_OUT_VALUE | numeric(20,2) | Period Out Value | |
| 20 | PERIOD_ACT_VALUE | numeric(20,2) | Period Actual Value | |
| 21 | PERIOD_ACT_COST | numeric(20,12) | Period Actual Cost | |
| 22 | MARKET_PRICE | numeric(20,4) | Market Price | |
| 23 | WRITE_OFF_AMOUNT | numeric(20,2) | Value Written Off | |
| 24 | UPDATED_MFG_UNIT_COST | numeric(20,4) | Updated Manufacturing Unit Cost | |
| 25 | UPDATED_MFG_COST_VARIANCE | numeric(20,2) | Manufacturing Cost Variance | |
| 26 | UPDATED_MFG_TOTAL_COST | numeric(20,2) | Updated Manufacturing cost | |
| 27 | STANDARD_COST | numeric(20,6) | Standard Cost | |
| 28 | COST_VARIANCE | numeric(20,2) | Standard Cost Variance | |
| 29 | PERIOD_SALES_RTN_QTY | numeric(20,6) | Period Return Quantity | |
| 30 | PERIOD_SALES_RTN_AMT | numeric(20,2) | Period Return Value | |
| 31 | CONFIRM_PERIOD | varchar(1) | Period Confirm Flag | |
| 32 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 33 | USERNAME | varchar(20) | Username | |
| 34 | PERIOD_COUNT_ADJ_QTY | numeric(20,6) | Period Count Adjust Quantity | |
| 35 | PERIOD_COUNT_ADJ_AMT | numeric(20,2) | Period Count Adjust Value | |
| 36 | PERIOD_BATCH_EXP_QTY | numeric(20,6) | Period Batch Expired Quantity | |
| 37 | PERIOD_BATCH_EXP_AMT | numeric(20,2) | Period Batch Expired Amount | |
| 38 | YTD_IN_QTY | numeric(20,6) | YTD In Quantity | |
| 39 | YTD_IN_AMT | numeric(20,2) | YTD in Amount | |
| 40 | YTD_OUT_QTY | numeric(20,6) | YTD Out Quantity | |
| 41 | YTD_OUT_AMT | numeric(20,2) | YTD Out Amount | |
| 42 | PRODUCT_GROUP | varchar(6) | Product Group | |
| 43 | LAST_PURCH_COST | numeric(20,4) | Last Purchase Cost | |
| 44 | LAST_PURCH_DATE | datetime | Last Purchase Date | |
| 45 | WAREHOUSE | varchar(2) | PK | Warehouse Code |