     BR_Transaction                          BR Transaction                Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: BR_Transaction_bus,BR_ReconciliationRegister_upd,AR_CashReceiptsJournal_upd,GL_TransactionJour
     SQL Def: Y  SysDB: N                                        "MAS_"+%C$+"/BR"+%C$+"/BR_Transaction.M4T"

     KPRIMARY: BankCode+DocumentType+CheckNo+TransactionDate+EntryNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  BankCode. . . . . . . . . . .     1 SYY  Bank Code . . . . . . . . . . .BANKCODE
                                                    Notes: {BR1$(1,1)}
       2  DocumentType. . . . . . . . .     1 SYN  Document Type . . . . . . . . .
                                                    Valid:A,C Notes: A=Adjustment
                                                    /deposit, C=Checks {BR1$(2,
                                                    1)}
       3  CheckNo . . . . . . . . . . .    10 SYN  Check Number. . . . . . . . . .CHECKNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED Notes: {BR1$(3,6)}
       4  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
                                                    DepVal:REQUIRED Notes:
                                                    {BR1$(3,6)}
       5  EntryNo . . . . . . . . . . .     6 SNN  Entry Number. . . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    DepVal:REQUIRED Notes:
                                                    {BR1$(9,3)}
       6  SourceModule. . . . . . . . .     2 SNN  Source Module . . . . . . . . .
                                                    Notes: {BR1$(12,2)}
       7  AdjustmentType. . . . . . . .     1 SYN  Adjustment Type . . . . . . . .
                                                    Valid:A,B,D,I,N,W ValGroup:Ad
                                                    justOnly Notes: A=Adjustment,
                                                     B=Bank charge, D=Deposit,
                                                    I=Interest, N=Nsf, W=Withdraw
                                                    al {BR1$(14,1)}
       8  DocumentDate. . . . . . . . .     8 SNN  Document Date . . . . . . . . .DATE
                                                    ValGroup:AdjustOnly Notes:
                                                    {BR1$(15,6)}
       9  CheckType . . . . . . . . . .     1 SYN  Check Type. . . . . . . . . . .
                                                    Valid:A,M,R,V,X ValGroup:Chec
                                                    kOnly Notes: A=Auto,
                                                    M=Manual, R=Reverse, V=Void,
                                                    X=void range {BR1$(14,1)}
      10  CheckDate . . . . . . . . . .     8 SNN  Check Date. . . . . . . . . . .DATE
                                                    ValGroup:CheckOnly Notes:
                                                    {BR1$(15,6)}
      11  ClearedBank . . . . . . . . .     1 SYN  Cleared Bank. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {BR1$(21,1)}
      12  ReferenceNo . . . . . . . . .    10 SNN  Reference Number. . . . . . . .
                                                    Notes: Last Check Number, if
                                                    Xrange {BR1$(22,10)}
      13  CheckPayeeName. . . . . . . .    30 SNN  Check Payee Name. . . . . . . .NAME
                                                    ValGroup:CheckOnly Notes:
                                                    {BR1$(32,30)}
      14  DepositAdjustComment. . . . .    30 SNN  Deposit Adjustment Comment. . .
                                                    ValGroup:AdjustOnly Notes:
                                                    {BR1$(32,23)}
      15  CheckAmt. . . . . . . . . . . 13.2  NNN  Check Amount. . . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00-
                                                    ValGroup:CheckOnly Notes:
                                                    {BR1[0]}
      16  DocumentAmt . . . . . . . . . 13.2  NNN  Document Amount . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00-
                                                    ValGroup:AdjustOnly Notes:
                                                    {BR1[0]}
      17  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      18  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      19  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL