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 |