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