QUALITY_TEST_GROUPS
Quality Test Results Groups
tableFINQUALITY
QUALITY_TEST_GROUPS — Quality Test Results Groups. FIN table in the standard Ross ERP 8.0 schema: 44 columns, used by 59 programs. Columns, data types, keys, foreign keys and relationships.
Open QUALITY_TEST_GROUPS in the interactive Data Dictionary →Part of Other 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 | QC_EVENT_NUMBER | int | PK | Quality Test Event Number |
| 4 | SYS_TEST_GROUP | varchar(6) | PK | Quality Control Test Group Code |
| 5 | TRANSACTION_TYPE | varchar(2) | Transaction Type | |
| 6 | MOVEMENT_CODE | varchar(6) | Movement Code | |
| 7 | CREATION_DATE | datetime | Creation Date | |
| 8 | PART_CODE | varchar(15) | Product | |
| 9 | WAREHOUSE | varchar(2) | Warehouse Code | |
| 10 | IC_LOT_NUMBER | varchar(20) | Lot Number | |
| 11 | IC_STATUS_CODE_INITIAL | varchar(8) | ||
| 12 | IC_REF_DIV_WH_FAC | varchar(2) | ||
| 13 | IC_REF_DOCUMENT | varchar(13) | ||
| 14 | IC_REF_LINE_STAGE | varchar(8) | ||
| 15 | IC_REF_LINE_SEQ | smallint | ||
| 16 | SOURCE_MODULE | varchar(2) | Source Module Reference | |
| 17 | DESCRIPTION | varchar(30) | Description | |
| 18 | DETAIL_DESCRIPTION | text | Detailed Description | |
| 19 | SYS_QC_FINISHED | varchar(1) | Quality Controls Test Finished | |
| 20 | SYS_QC_OUT_OF_SPEC | varchar(1) | QC Results Out of Specification | |
| 21 | SYS_QC_ADDITIONAL_TEST | varchar(1) | QC Additional Test | |
| 22 | SYS_QC_RESULTS_REJECT_CODE | varchar(8) | Rejection Reason Code | |
| 23 | USERNAME | varchar(20) | Username | |
| 24 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 25 | RECIPE_LINE_TYPE | varchar(1) | Recipe Line Type Code | |
| 26 | DIVISION | varchar(2) | Division | |
| 27 | RESOURCES | varchar(15) | ||
| 28 | RESOURCE_DESC | varchar(60) | ||
| 29 | INHERIT_TEST_RESULTS | varchar(1) | Inheriting Test Results | |
| 30 | PARENT_QC_EVENT_NUMBER | int | ||
| 31 | PRODUCT_GROUP | varchar(6) | Product Group | |
| 32 | PRODUCT_GROUP_DESC | varchar(30) | ||
| 33 | PRODUCT_TYPE | varchar(6) | Product type | |
| 34 | PRODUCT_TYPE_DESC | varchar(30) | ||
| 35 | PRODUCT_CLASS | varchar(6) | Product Class | |
| 36 | PRODUCT_CLASS_DESC | varchar(30) | ||
| 37 | VENDOR_NUMBER | varchar(12) | Supplier Number (or ID) | |
| 38 | VENDOR_NAME | varchar(60) | Supplier Name | |
| 39 | MACHINE_CODE | varchar(8) | Machine Code | |
| 40 | MACHINE_DESC | varchar(30) | ||
| 41 | QUALITY_WORK_AREA | varchar(20) | Quality Work Area | |
| 42 | RF_TEST_REQ_EXPORTED | varchar(1) | Quality Test Requirement Exported | |
| 43 | PASS_FAIL_ONLY | varchar(1) | ||
| 44 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |