AR_CUSTOMER_BANKS
AR Customer Bank Account Details
tableFINAR
AR_CUSTOMER_BANKS — AR Customer Bank Account Details. FIN table in the standard Ross ERP 8.0 schema: 28 columns, used by 22 programs. Columns, data types, keys, foreign keys and relationships.
Open AR_CUSTOMER_BANKS in the interactive Data Dictionary →Part of AR 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 | DIVISION | varchar(2) | Division | |
| 4 | CUSTOMER_NUMBER | varchar(8) | Customer Number | |
| 5 | BANK_NAME | varchar(30) | Bank Name | |
| 6 | BANK_SORT_CODE | varchar(6) | Bank Sort Code | |
| 7 | BANK_ACCOUNT | varchar(30) | Bank Account Number | |
| 8 | BANK_ACCOUNT_NAME | varchar(30) | Bank Account Name | |
| 9 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 10 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 11 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 12 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 13 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 14 | SYS_CITY | varchar(25) | City | |
| 15 | SYS_COUNTY | varchar(25) | County | |
| 16 | SYS_STATE | varchar(6) | State Code | |
| 17 | SYS_PROVINCE | varchar(6) | Province Code | |
| 18 | SYS_COUNTRY | varchar(6) | Country Code | |
| 19 | SYS_LANGUAGE_CODE | varchar(8) | Language Code | |
| 20 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 21 | AR_CUSTOMER_BANK | varchar(6) | Customer's Bank Account Code | |
| 22 | TRANSIT_ROUTING_NUMBER | varchar(9) | Bank Transit/Routing Number | |
| 23 | DDA_ACCOUNT_NUMBER | varchar(10) | DDA Account Number | |
| 24 | IBAN_CODE | varchar(34) | International Bank Account Number | |
| 25 | BIC_CODE | varchar(11) | Bank Identification Code | |
| 26 | MANDATE_REFERENCE | varchar(35) | Mandate Reference | |
| 27 | MANDATE_DATE | datetime | Mandate Date | |
| 28 | ULTIMATE_DEBTOR | varchar(140) | Ultimate Debtor |