PRODUCT_WAREHOUSE_CHG_AUDIT
Audit table for product warehouse update
tableFINPRODUCT
PRODUCT_WAREHOUSE_CHG_AUDIT — Audit table for product warehouse update. FIN table in the standard Ross ERP 8.0 schema: 35 columns, used by 3 programs. Columns, data types, keys, foreign keys and relationships.
Open PRODUCT_WAREHOUSE_CHG_AUDIT in the interactive Data Dictionary →Part of PRODUCT 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) | Company Code | |
| 3 | CONVERSION_DATE | datetime | ||
| 4 | USERNAME | varchar(20) | Username | |
| 5 | PART_CODES | text | ||
| 6 | WAREHOUSES | text | ||
| 7 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 8 | POP_UNIT_PRICE | varchar(4) | Unit of Measure (Purchase Price) | |
| 9 | POP_NORMAL_RECEIPT_STATUS | varchar(8) | Normal Inventory Status for Received stock | |
| 10 | SOP_NORMAL_CREDIT_STATUS | varchar(8) | Inventory status for Sales Credit stock | |
| 11 | PM_NORMAL_OUTPUT_STATUS | varchar(8) | Inventory status for Job Outputs | |
| 12 | PM_NORMAL_RETURN_STATUS | varchar(8) | Inventory status for Job Returned stock | |
| 13 | GL_COUNT_ADJUSTMENT_CODE | varchar(6) | GL Short Code for Inventory Counting adjustments | |
| 14 | GL_COUNT_ADJUSTMENT_ACCOUNT | varchar(50) | GL Account for Inventory Counting adjustments | |
| 15 | GL_USER_DEFINED_CODE | varchar(6) | GL Short Code for a User-Defined status | |
| 16 | GL_USER_DEFINED_ACCOUNT | varchar(50) | GL Account for a User-Defined status | |
| 17 | GL_LINE_DISCOUNT_SHORT_CODE | varchar(6) | The short code for the line discount account | |
| 18 | GL_LINE_DISCOUNT_ACCT | varchar(50) | The line specific discount account | |
| 19 | GL_LOT_ADJUSTMENT_CODE | varchar(6) | GL Short Code for Lot Adjustment | |
| 20 | GL_LOT_ADJUSTMENT_ACCOUNT | varchar(50) | GL Account for Lot Adjustment | |
| 21 | GL_RECONCILIATION_CODE | varchar(6) | GL Short Code for inventory quantity reconciliation | |
| 22 | GL_RECONCILIATION_ACCOUNT | varchar(50) | GL Account for inventory quantity reconciliation | |
| 23 | GL_VAR_IN_INV_SHORT_CODE | varchar(6) | The short code for the variation in inventory account | |
| 24 | GL_VAR_IN_INV_ACCT | varchar(50) | The account used to post a variation in inventory | |
| 25 | GL_INV_EXPENSE_SHORT_CODE | varchar(6) | The short code for the inventory expense account | |
| 26 | GL_INV_EXPENSE_ACCT | varchar(50) | The Expense Account used in place of the Inventory Asset A/c | |
| 27 | ATP_IN_USE | varchar(1) | Available To Promise In Use | |
| 28 | ATP_WINDOW_LIMIT | varchar(1) | Available To Promise Window Limit | |
| 29 | ATP_WINDOW_DAYS | smallint | Available To Promise Window Days | |
| 30 | IC_ATP_FROM_EXISTING | varchar(1) | Promise from Existing Inventory | |
| 31 | IC_ATP_SOURCE_PURCHASE | varchar(1) | Promise made against Purchase Orders | |
| 32 | IC_ATP_SOURCE_FORECAST | varchar(1) | Promise made against production forecast | |
| 33 | IC_ATP_SOURCE_PLAN_JOBS | varchar(1) | Promise made against planned jobs | |
| 34 | IC_ATP_SOURCE_LIVE_JOBS | varchar(1) | Promise made against live jobs | |
| 35 | IC_ATP_AUTO_HORIZON | smallint | Time in which it is permissible to automatically promise inv |