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-