CI_BankCodeListingWrk CI Bank Code Listing Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: CI_BankCodeListing_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/CI"+%C$+"/CI_BankCodeListingWrk"+%S$+".M4T"
KPRIMARY: BankCode
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SNN Bank Code . . . . . . . . . . .
2 BankDesc. . . . . . . . . . . 30 SNN Bank Code Description . . . . .
3 CashAccountKey. . . . . . . . 9 SNN A/P Cash Account Key. . . . . .
4 CashAccount . . . . . . . . . 41 SNN A/P Cash Account Number . . . .
5 BankAccountNo . . . . . . . . 17 SNN Bank Account Number . . . . . .
6 NextCheckNo . . . . . . . . . 6 SNN Next check number for this bank
7 CurrentBankBalance. . . . . . 16.2 NNN Current Bank Balance. . . . . .
8 CheckPrefix . . . . . . . . . 1 SNN Check Prefix. . . . . . . . . .
9 CheckSuffix . . . . . . . . . 1 SNN Check Suffix. . . . . . . . . .
10 RoutingNo . . . . . . . . . . 11 SNN Routing Number. . . . . . . . .
11 MICRBankAccountNo . . . . . . 17 SNN Bank Account Number of MICR . .
12 MICRPrintingEnabled . . . . . 1 SNN MICR Printing Enabled . . . . .
13 Address1. . . . . . . . . . . 30 SNN Address Line 1. . . . . . . . .
14 Address2. . . . . . . . . . . 30 SNN Address Line 2. . . . . . . . .
15 Address3. . . . . . . . . . . 30 SNN Address Line 3. . . . . . . . .
16 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .
17 State . . . . . . . . . . . . 2 SNN State Code. . . . . . . . . . .
18 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . .
19 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . .
20 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . .
21 ContactCode . . . . . . . . . 30 SNN Contact Code. . . . . . . . . .
22 Telephone . . . . . . . . . . 17 SNN Telephone No. . . . . . . . . .
23 Extension . . . . . . . . . . 5 SNN Telephone Ext . . . . . . . . .
24 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .
25 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .
26 UrlAddress. . . . . . . . . . 50 SNN URL Address . . . . . . . . . .
27 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
28 APDefaultFormCode . . . . . . 20 SNN A/P Default Form Code . . . . .
29 APDefaultFormDesc . . . . . . 30 SNN A/P Default Form Description. .DESCRIPTION
30 BankName. . . . . . . . . . . 30 SNN BankName. . . . . . . . . . . .DESCRIPTION
31 DirectDepositBankAccountNo. . 17 SNN Direct Deposit Bank Account Num
32 RoutingTransitNo. . . . . . . 9 SNN Routing Transit Number. . . . .
33 BankAccountType . . . . . . . 9 SNN Bank Account Type . . . . . . .
34 PreNoteApproved . . . . . . . 1 SNN Pre Note Approved . . . . . . .YESNO
DfltVal:N