IC_COUNT_SUMMARY
Inventory Count Summary
tableFINIC
IC_COUNT_SUMMARY — Inventory Count Summary. FIN table in the standard Ross ERP 8.0 schema: 22 columns, used by 19 programs. Columns, data types, keys, foreign keys and relationships.
Open IC_COUNT_SUMMARY 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 | WAREHOUSE | varchar(2) | PK | Warehouse Code |
| 4 | PHYS_COUNT_NUMBER | int | PK | Count Number |
| 5 | IC_COUNT_TYPE | varchar(1) | The type of inventory count | |
| 6 | SELECTION_DATE | datetime | ||
| 7 | SELECTION_USER | varchar(20) | ||
| 8 | REFERENCE_DATE | datetime | ||
| 9 | ACTIVATION_DATE | datetime | ||
| 10 | ACTIVATION_USER | varchar(20) | ||
| 11 | CLOSE_DATE | datetime | ||
| 12 | CLOSE_USER | varchar(20) | ||
| 13 | DIFFERENCE_DATE | datetime | ||
| 14 | DIFFERENCE_USER | varchar(20) | ||
| 15 | APPROVAL_DATE | datetime | Date the Requisition was approved by this Authorizer | |
| 16 | APPROVAL_USER | varchar(20) | ||
| 17 | UPDATE_DATE | datetime | ||
| 18 | UPDATE_USER | varchar(20) | ||
| 19 | STATUS_FLAG | varchar(1) | Status Flag | |
| 20 | IC_NET_VALUE_IMPACT | numeric(20,4) | Net monetary impact of an inventory count | |
| 21 | IC_COUNT_REASON_CODE | varchar(8) | Reason Code | |
| 22 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status |