BR_ReconciliationRegisterWrk BR Reconciliation Register Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/BR"+%C$+"/BR_ReconciliationRegisterWrk"+%S$+".M4T"
KPRIMARY: BankCode+DocumentType+CheckNo+TransactionDate+EntryNo
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SYY Bank Code . . . . . . . . . . .BANKCODE 2 BankDesc. . . . . . . . . . . 30 SNN Bank Code Description . . . . . 3 DocumentType. . . . . . . . . 1 SYN Document Type . . . . . . . . . 4 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . .CHECKNO 5 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 6 EntryNo . . . . . . . . . . . 6 SNN Entry Number. . . . . . . . . . 7 DocumentDate. . . . . . . . . 8 SNN Document Date . . . . . . . . .DATE 8 SourceModule. . . . . . . . . 2 SNN Source Module . . . . . . . . . 9 AdjustmentType. . . . . . . . 1 SYN Adjustment Type . . . . . . . . 10 CheckType . . . . . . . . . . 1 SYN Check Type. . . . . . . . . . . 11 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE 12 ClearedBank . . . . . . . . . 1 SYN Cleared Bank. . . . . . . . . .YESNO DfltVal:N Valid:Y,N 13 ReferenceNo . . . . . . . . . 10 SNN Reference Number. . . . . . . . 14 CheckPayeeName. . . . . . . . 30 SNN Check Payee Name. . . . . . . .NAME 15 DepositAdjustComment. . . . . 30 SNN Deposit Adjustment Comment. . . 16 Account . . . . . . . . . . . 41 SNN Cash Account Number . . . . . . 17 CheckAmt. . . . . . . . . . . 13.2 NNN Check Amount. . . . . . . . . .AMOUNT Mask:###,###,###.00 18 DocumentAmt . . . . . . . . . 13.2 NNN Document Amount . . . . . . . .AMOUNT Mask:###,###,###.00 19 StatementBalance. . . . . . . 16.2 NNN Statement Balance Amount. . . .BALANCEAMT Mask:#,###,###,###.00- 20 OutstandingCheckTotal . . . . 16.2 NNY Outstanding Check Total . . . .BALANCEAMT Mask:#,###,###,###.00- 21 NumberOutstandingChecks . . . 10.0 NNY Number of Outstanding Checks. . 22 OutstandingDepositTotal . . . 16.2 NNY Outstanding Deposit Total . . .BALANCEAMT Mask:#,###,###,###.00- 23 NoOutstandingDeposits . . . . 10.0 NNY Number of Outstanding Deposits. 24 OutstandingAdjustTotal. . . . 16.2 NNY Outstanding Adjustment Total. .BALANCEAMT Mask:#,###,###,###.00- 25 NumberOutstandingAdjust . . . 10.0 NNY Number of Outstanding Adjustmen 26 AdjustedBankBalance . . . . . 16.2 NNN Adjusted Bank Balance . . . . .BALANCEAMT Mask:#,###,###,###.00- 27 CurrentBankBalance. . . . . . 16.2 NNY Current Bank Balance. . . . . .BALANCEAMT Mask:#,###,###,###.00- 28 OutOfBalanceAmt . . . . . . . 16.2 NNN Out Of Balance Amount . . . . .BALANCEAMT Mask:#,###,###,###.00-