| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| SERIES | Series 1 = All |
Integer | 2 | View | |
| CustomerVendor_ID | Customer/Vendor ID |
String | 16 | View | |
| ADRSCODE | Address Code |
String | 16 | View | |
| VENDORID | Vendor ID |
String | 16 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| EFTUseMasterID | EFT Use Master ID |
Integer | 2 | View | |
| EFTBankType | EFT Bank Type |
Integer | 2 | View | |
| FRGNBANK | Foreign Bank |
Boolean | 2 | View | |
| INACTIVE | Inactive |
Boolean | 2 | View | |
| BANKNAME | Bank Name |
String | 32 | View | |
| EFTBankAcct | EFT Bank Account |
String | 36 | View | |
| EFTBankBranch | EFT Bank Branch |
String | 16 | View | |
| GIROPostType | GIRO Post Type |
Integer | 2 | View | |
| EFTBankCode | EFT Bank Code |
String | 16 | View | |
| EFTBankBranchCode | EFT Bank Branch Code |
String | 6 | View | |
| EFTBankCheckDigit | EFT Bank Check Digit |
String | 4 | View | |
| BSROLLNO | Building Society Roll No |
String | 32 | View | |
| IntlBankAcctNum | International Bank Account Number |
String | 36 | View | |
| SWIFTADDR | Swift Address |
String | 12 | View | |
| CustVendCountryCode | Customer/Vendor Country Code |
String | 4 | View | |
| DeliveryCountryCode | Delivery Country Code |
String | 4 | View | |
| BNKCTRCD | Bank Country Code |
String | 4 | View | |
| CBANKCD | Central Bank Code |
String | 10 | View | |
| ADDRESS1 | Address 1 |
String | 62 | View | |
| ADDRESS2 | Address 2 |
String | 62 | View | |
| ADDRESS3 | Address 3 |
String | 62 | View | |
| ADDRESS4 | Address 4 |
String | 62 | View | |
| RegCode1 | Regulatory Code 1 |
String | 32 | View | |
| RegCode2 | Regulatory Code 2 |
String | 32 | View | |
| BankInfo7 | Bank Info 7 |
Integer | 2 | View | |
| EFTTransitRoutingNo | EFT Transit Routing Number |
String | 12 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| EFTTransferMethod | EFT Transfer Method |
Integer | 2 | View | |
| EFTAccountType | EFT Account Type |
Integer | 2 | View | |
| EFTPrenoteDate | EFT Prenote Date |
Date | 4 | View | |
| EFTTerminationDate | EFT Termination Date |
Date | 4 | View |