SUPPLIER_PERFORMANCE_CONTROLS
Supplier Performance Control Flags
tableFINSUPPLIER
SUPPLIER_PERFORMANCE_CONTROLS — Supplier Performance Control Flags. FIN table in the standard Ross ERP 8.0 schema: 20 columns, used by 4 programs. Columns, data types, keys, foreign keys and relationships.
Open SUPPLIER_PERFORMANCE_CONTROLS 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 | COLLECT_ORDER_DETAIL | varchar(1) | Collect Order Details for Supplier Performance | |
| 3 | COLLECT_GRN_DETAIL | varchar(1) | Collect GRN detail for Supplier Performance | |
| 4 | COLLECT_INVOICE_DETAIL | varchar(1) | Collect Invoice Details | |
| 5 | COLLECT_SUM_ORD_QTY | varchar(1) | Collect Summary Order Quantities | |
| 6 | COLLECT_SUM_ORD_VALUE | varchar(1) | Collect Summary Order Values | |
| 7 | COLLECT_SUM_ORD_PRICE | varchar(1) | Collect Summary Order Prices | |
| 8 | COLLECT_SUM_GRN_QTY | varchar(1) | Collect Summary GRN Quantities | |
| 9 | COLLECT_SUM_GRN_VALUE | varchar(1) | Collect Summarised GRN Values | |
| 10 | COLLECT_SUM_INV_QTY | varchar(1) | Collect Summarised Invoice Quantities | |
| 11 | COLLECT_SUM_INV_VALUE | varchar(1) | Collect Summarised Invoice Values | |
| 12 | COLLECT_SUM_INV_PRICE | varchar(1) | Collect Summarised Invoice Prices | |
| 13 | COLLECT_LEAD_TIME | varchar(1) | Collect Lead Time Performance Details | |
| 14 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 15 | DIVISION | varchar(2) | PK | Division |
| 16 | TOTAL_NUMBER_PERIODS | smallint | Number of Periods in Year | |
| 17 | CURRENT_YEAR | smallint | Current Year | |
| 18 | CURRENT_PERIOD | smallint | Current Period | |
| 19 | YEARS_TO_KEEP | smallint | Number Of Years to Keep | |
| 20 | SEQ_TO_KEEP | smallint | Number Of Sequences to Keep |