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