CREDIT_LIMIT_CONTROLS
Credit Limit Controls
tableFINCREDIT
CREDIT_LIMIT_CONTROLS — Credit Limit Controls. FIN table in the standard Ross ERP 8.0 schema: 41 columns, used by 11 programs. Columns, data types, keys, foreign keys and relationships.
Open CREDIT_LIMIT_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 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | DIVISION | varchar(2) | PK | Division |
| 4 | CREDIT_LIMIT_CODE | varchar(6) | PK | Credit Limit Code |
| 5 | DESCRIPTION | varchar(30) | Description | |
| 6 | WARNING_LIMIT | numeric(20,2) | Credit Warning Limit | |
| 7 | ABORT_LIMIT | numeric(20,2) | Credit Abort Limit | |
| 8 | MANUAL_AUTO_HALT | varchar(1) | Manual/Auto Status | |
| 9 | CREDIT_STATUS_CODE | varchar(6) | FK→CREDIT_HOLD_STATUS_CODES | Credit Status Code |
| 10 | ORDER_ENTRY_WARNING | varchar(1) | ||
| 11 | ORDER_ENTRY_BALANCE | varchar(1) | ||
| 12 | ORDER_ENTRY_PICKING | varchar(1) | ||
| 13 | ORDER_ENTRY_DESPATCH | varchar(1) | ||
| 14 | ORDER_ENTRY_OS_ORDER | varchar(1) | ||
| 15 | PICKING_WARNING | varchar(1) | ||
| 16 | PICKING_BALANCE | varchar(1) | ||
| 17 | PICKING | varchar(1) | ||
| 18 | PICKING_DESPATCH | varchar(1) | ||
| 19 | PICKING_OS_ORDER | varchar(1) | ||
| 20 | DESPATCH_WARNING | varchar(1) | ||
| 21 | DESPATCH_BALANCE | varchar(1) | ||
| 22 | DESPATCH_PICKING | varchar(1) | ||
| 23 | DESPATCH | varchar(1) | ||
| 24 | DESPATCH_OS_ORDER | varchar(1) | ||
| 25 | INVOICE_WARNING | varchar(1) | ||
| 26 | INVOICE_BALANCE | varchar(1) | ||
| 27 | INVOICE_PICKING | varchar(1) | ||
| 28 | INVOICE_DESPATCH | varchar(1) | ||
| 29 | INVOICE_OS_ORDER | varchar(1) | ||
| 30 | DAYS_OVERDUE | smallint | Number of days overdue | |
| 31 | MIN_TRANS_VALUE | numeric(20,2) | Minimum Transaction Value | |
| 32 | HOLD_TRANSACTIONS | varchar(1) | Hold all Transactions Flag | |
| 33 | ORDER_ENTRY_ABORT | varchar(1) | ||
| 34 | PICKING_ABORT | varchar(1) | ||
| 35 | DESPATCH_ABORT | varchar(1) | ||
| 36 | INVOICE_ABORT | varchar(1) | ||
| 37 | ORDER_DEBITS | varchar(1) | ||
| 38 | PICKING_DEBITS | varchar(1) | ||
| 39 | DESPATCH_DEBITS | varchar(1) | ||
| 40 | INVOICE_DEBITS | varchar(1) | ||
| 41 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |