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