RF_EXPORTED_TEST_REQS
Quality Test Requirements ready for export
tableFINRF
RF_EXPORTED_TEST_REQS — Quality Test Requirements ready for export. FIN table in the standard Ross ERP 8.0 schema: 18 columns, used by 4 programs. Columns, data types, keys, foreign keys and relationships.
Open RF_EXPORTED_TEST_REQS 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) | Company Code | |
| 3 | TIME_STAMP_SECONDS | numeric(20,2) | Time Stamp in Hundreds of Seconds | |
| 4 | REF_DIV_FAC_WH | varchar(6) | ||
| 5 | QUALITY_TEST_TYPE | smallint | Quality Test Type | |
| 6 | ACTION_MODE | varchar(6) | Action Mode | |
| 7 | TEST_REQUIREMENT_NAME | varchar(30) | Quality Test Requirement Name | |
| 8 | QUALITY_WORK_AREA | varchar(20) | Quality Work Area | |
| 9 | ORIGINAL_DOCUMENT_NUMBER | varchar(13) | Original Document Number | |
| 10 | ORIGINAL_DOCUMENT_LINE | varchar(8) | Original Document Line | |
| 11 | ORIGINAL_DOCUMENT_SEQUENCE | smallint | Original Document Sequence | |
| 12 | SYS_EDI_PRODUCT_ID | varchar(40) | Industry Product ID | |
| 13 | WAREHOUSE | varchar(2) | Warehouse Code | |
| 14 | IC_LOT_NUMBER | varchar(20) | Lot Number | |
| 15 | MOVEMENT_QTY | numeric(20,6) | Stock Movement Quantity | |
| 16 | IC_PACK_OR_CAP_UNIT | varchar(4) | Packaged or capacity unit of measure | |
| 17 | REQUIRED_DATE | datetime | Required Date | |
| 18 | RF_TEST_REQ_EXPORTED | varchar(1) | Quality Test Requirement Exported |