BANK_CODES
Bank Account Codes
tableFINBANK
BANK_CODES — Bank Account Codes. FIN table in the standard Ross ERP 8.0 schema: 73 columns, used by 77 programs. Columns, data types, keys, foreign keys and relationships.
Open BANK_CODES 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 | BANK_CODE | varchar(6) | PK | Bank Code |
| 5 | BANK_ACCOUNT_NAME | varchar(30) | Bank Account Name | |
| 6 | BANK_ACCOUNT | varchar(30) | Bank Account Number | |
| 7 | BANK_SORT_CODE | varchar(6) | Bank Sort Code | |
| 8 | BANK_NAME | varchar(30) | Bank Name | |
| 9 | BANK_CONTACT | varchar(20) | Contact Name | |
| 10 | PHONE | varchar(21) | Phone Number | |
| 11 | FAX_NUMBER | varchar(21) | Fax Number | |
| 12 | GL_BANK_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Bank Short Code |
| 13 | BANK_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Cash Postings |
| 14 | SORT_ELEMENT_1 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 15 | SORT_ELEMENT_2 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 16 | SORT_ELEMENT_3 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 17 | SORT_ELEMENT_4 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 18 | SORT_ELEMENT_5 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 19 | SORT_ELEMENT_6 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 20 | SORT_ELEMENT_7 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 21 | SORT_ELEMENT_8 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 22 | BACS_NUMBER | varchar(6) | BACS Number | |
| 23 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 24 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 25 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 26 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 27 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 28 | SYS_CITY | varchar(25) | City | |
| 29 | SYS_COUNTY | varchar(25) | County | |
| 30 | SYS_STATE | varchar(6) | State Code | |
| 31 | SYS_PROVINCE | varchar(6) | Province Code | |
| 32 | SYS_COUNTRY | varchar(6) | Country Code | |
| 33 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 34 | PAYMENT_TYPE_EFT | varchar(6) | ||
| 35 | SORT_ELEMENT_9 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | Sort element |
| 36 | SORT_ELEMENT_10 | varchar(4) | FK→BANK_RECONCILIATION_SORT_CODES | |
| 37 | SYS_LANGUAGE_CODE | varchar(8) | Language Code | |
| 38 | SYS_CHECK_DATE_ROW | smallint | Check Date Row Number | |
| 39 | SYS_CHECK_DATE_COL | smallint | Check Date Column Number | |
| 40 | SYS_CHECK_WRITTEN_ROW | smallint | ||
| 41 | SYS_CHECK_WRITTEN_COL | smallint | ||
| 42 | SYS_CHECK_TOTAL_ROW | smallint | ||
| 43 | SYS_CHECK_TOTAL_COL | smallint | ||
| 44 | SYS_CHECK_NAME_ROW | smallint | ||
| 45 | SYS_CHECK_NAME_COL | smallint | ||
| 46 | SYS_EFT_NUMBER | varchar(20) | EFT Number | |
| 47 | SYS_CHECK_PRINT_FLAG | varchar(1) | Check Print Flag | |
| 48 | AP_BANK_DRAFT_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for AP Drafts |
| 49 | AP_BANK_DRAFT_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for AP Drafts |
| 50 | AR_BANK_DRAFT_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for AR Drafts |
| 51 | AR_BANK_DRAFT_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for AR Drafts |
| 52 | LOCKBOX_NUMBER | varchar(10) | Lockbox Number | |
| 53 | LB_FILE_FORMAT | numeric(3,0) | Flag specifying a lockbox file format | |
| 54 | AP_AUTO_CHECK_NUMBER_IN_USE | varchar(1) | Yes-No field for using Auto Check Numbering | |
| 55 | AP_CURRENT_CHECK_NUMBER | varchar(8) | Current Check Number in Check Number Range | |
| 56 | AP_STARTING_CHECK_NUMBER | varchar(8) | First Check Number in Check Number Range | |
| 57 | AP_ENDING_CHECK_NUMBER | varchar(8) | Last Check Number in Check Number Range | |
| 58 | SYS_CHECK_NUMBER_ROW | smallint | ||
| 59 | SYS_CHECK_NUMBER_COL | smallint | ||
| 60 | BS_FILE_FORMAT | varchar(2) | Bank Statement Import File Format | |
| 61 | BS_FILE_DELIMITER | varchar(1) | ||
| 62 | BS_JOURNAL_CODE | varchar(8) | ||
| 63 | GL_MISC_CHARGE_FULL_ACCOUNT | varchar(50) | ||
| 64 | GL_MISC_CHARGE_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | |
| 65 | GL_MISC_INCOME_FULL_ACCOUNT | varchar(50) | ||
| 66 | GL_MISC_INCOME_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | |
| 67 | OPENING_BALANCE | numeric(20,2) | ||
| 68 | AUTO_CREATE_MC | varchar(1) | Auto create miscellaneous charges flag | |
| 69 | AUTO_CREATE_MI | varchar(1) | Auto create miscellaneous income flag | |
| 70 | POS_PAY_FILE_FORMAT | varchar(2) | Positive Pay File Format | |
| 71 | IBAN_CODE | varchar(34) | International Bank Account Number | |
| 72 | BIC_CODE | varchar(11) | Bank Identification Code | |
| 73 | CREDITOR_SCHEME_ID | varchar(35) | Creditor Scheme ID |