PRODUCT_MASTER_CHG_AUDIT
Audit table for parts update
tableFINPRODUCT
PRODUCT_MASTER_CHG_AUDIT — Audit table for parts update. FIN table in the standard Ross ERP 8.0 schema: 42 columns, used by 3 programs. Columns, data types, keys, foreign keys and relationships.
Open PRODUCT_MASTER_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 | PRODUCT_CLASSES | text | ||
| 7 | PRODUCT_GROUPS | text | ||
| 8 | PRODUCT_TYPES | text | ||
| 9 | WAREHOUSED_FLAG | varchar(1) | Warehoused Product Y/N | |
| 10 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 11 | IC_PACKAGED_PRODUCT | varchar(1) | Packaged product flag. | |
| 12 | IC_PRODUCT_UOM_CONTROL | varchar(1) | The type of product | |
| 13 | IC_WEIGHT_FROM_CONTROL | varchar(1) | ||
| 14 | IC_VOLUME_FROM_CONTROL | varchar(1) | ||
| 15 | POP_UNIT_PRICE | varchar(4) | Unit of Measure (Purchase Price) | |
| 16 | POP_NORMAL_RECEIPT_STATUS | varchar(8) | Normal Inventory Status for Received stock | |
| 17 | SOP_NORMAL_CREDIT_STATUS | varchar(8) | Inventory status for Sales Credit stock | |
| 18 | PM_NORMAL_OUTPUT_STATUS | varchar(8) | Inventory status for Job Outputs | |
| 19 | PM_NORMAL_RETURN_STATUS | varchar(8) | Inventory status for Job Returned stock | |
| 20 | GL_COUNT_ADJUSTMENT_CODE | varchar(6) | GL Short Code for Inventory Counting adjustments | |
| 21 | GL_COUNT_ADJUSTMENT_ACCOUNT | varchar(50) | GL Account for Inventory Counting adjustments | |
| 22 | GL_USER_DEFINED_CODE | varchar(6) | GL Short Code for a User-Defined status | |
| 23 | GL_USER_DEFINED_ACCOUNT | varchar(50) | GL Account for a User-Defined status | |
| 24 | GL_LINE_DISCOUNT_SHORT_CODE | varchar(6) | The short code for the line discount account | |
| 25 | GL_LINE_DISCOUNT_ACCT | varchar(50) | The line specific discount account | |
| 26 | GL_LOT_ADJUSTMENT_CODE | varchar(6) | GL Short Code for Lot Adjustment | |
| 27 | GL_LOT_ADJUSTMENT_ACCOUNT | varchar(50) | GL Account for Lot Adjustment | |
| 28 | GL_RECONCILIATION_CODE | varchar(6) | GL Short Code for inventory quantity reconciliation | |
| 29 | GL_RECONCILIATION_ACCOUNT | varchar(50) | GL Account for inventory quantity reconciliation | |
| 30 | GL_VAR_IN_INV_SHORT_CODE | varchar(6) | The short code for the variation in inventory account | |
| 31 | GL_VAR_IN_INV_ACCT | varchar(50) | The account used to post a variation in inventory | |
| 32 | GL_INV_EXPENSE_SHORT_CODE | varchar(6) | The short code for the inventory expense account | |
| 33 | GL_INV_EXPENSE_ACCT | varchar(50) | The Expense Account used in place of the Inventory Asset A/c | |
| 34 | HAZARDOUS_INGREDIENT | varchar(1) | ||
| 35 | ATP_IN_USE | varchar(1) | Available To Promise In Use | |
| 36 | IC_ATP_FROM_EXISTING | varchar(1) | Promise from Existing Inventory | |
| 37 | IC_ATP_SOURCE_PURCHASE | varchar(1) | Promise made against Purchase Orders | |
| 38 | IC_ATP_SOURCE_FORECAST | varchar(1) | Promise made against production forecast | |
| 39 | IC_ATP_SOURCE_PLAN_JOBS | varchar(1) | Promise made against planned jobs | |
| 40 | IC_ATP_SOURCE_LIVE_JOBS | varchar(1) | Promise made against live jobs | |
| 41 | ATP_WINDOW_LIMIT | varchar(1) | Available To Promise Window Limit | |
| 42 | ATP_WINDOW_DAYS | smallint | Available To Promise Window Days |