BACS_CONTROL
BACS Control Record
tableFINBACS
BACS_CONTROL — BACS Control Record. FIN table in the standard Ross ERP 8.0 schema: 11 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.
Open BACS_CONTROL in the interactive Data Dictionary →Part of BACS 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 | LAST_TAPE_NUMBER | varchar(6) | Last Tape Number | |
| 3 | SELECTION_IN_PROGRESS | varchar(1) | Selection In Progress | |
| 4 | BACS_PROCESS | varchar(1) | Tape Or Deletion | |
| 5 | BLOCKSIZE | varchar(5) | Blocksize | |
| 6 | LABEL | varchar(3) | Label Record Size | |
| 7 | DATA_RECORD_SIZE | varchar(3) | Data Record Size | |
| 8 | BUREAU_AVAILABLE | varchar(1) | Bureau Processing Available | |
| 9 | DEFAULT_USER | varchar(6) | Default User Number | |
| 10 | USERNAME | varchar(20) | Username | |
| 11 | SYSTEM_DATE | datetime | System Date Transaction Made |