GL_Bank GL Bank Code Master Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_Bank_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_Bank.M4T"
KPRIMARY: BankCode
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SNY Bank Code . . . . . . . . . . .BANKCODE
2 BankDesc. . . . . . . . . . . 30 SNN Bank Code Description . . . . .
3 CashAccountKey. . . . . . . . 9 SNN Cash Account Number . . . . . .ACCOUNT
Notes: Validated against
GL_Account
4 BankAccountNo . . . . . . . . 17 SNN Bank Account Number . . . . . .
5 NextCheckNo . . . . . . . . . 6 SNN Next Check Number For This Bank
FmtType:ZEROFILL
6 CheckPrintingStatus . . . . . 1 SNN Check Printing Status . . . . .
Notes: P=Payroll Check,
A=A/P Check, M=A/P Manual
Check
7 CurrentBankBalance. . . . . . 16.2 NNY Current Bank Balance. . . . . .BALANCEAMT
Mask:#,###,###,###.00-
8 OutstandingCheckTotal . . . . 16.2 NNY Outstanding Check Total . . . .BALANCEAMT
Mask:#,###,###,###.00-
9 NumberOutstandingChecks . . . 10.0 NNY Number of Outstanding Checks. .
Mask:#,###,###,##0
10 OutstandingDepositTotal . . . 16.2 NNY Outstanding Deposit Total . . .BALANCEAMT
Mask:#,###,###,###.00-
11 NoOutstandingDeposits . . . . 10.0 NNY Number of Outstanding Deposits.
Mask:#,###,###,##0
12 OutstandingAdjustTotal. . . . 16.2 NNY Outstanding Adjustment Total. .BALANCEAMT
Mask:#,###,###,###.00-
13 NumberOutstandingAdjust . . . 10.0 NNY Number of Outstanding Adjustmen
Mask:#,###,###,##0
14 StatementBalance. . . . . . . 16.2 NNY Statement Balance . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-