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