GL_DailyTransactionRegisterWrk GL Daily Transaction Register WoRel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_DailyTransaction_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_DailyTransactionRegisterWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SYY Sort Field. . . . . . . . . . .
2 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE
Notes: YYYYMMDD
3 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
4 RegisterNo. . . . . . . . . . 6 SYY Register Number . . . . . . . .
Mask:000000 FmtType:ZEROFILL
5 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT
Notes: Validated against
GL_Account
6 SequenceNo. . . . . . . . . . 14 SYY Sequence Number . . . . . . . .
7 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number.
8 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . .
9 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT
10 BatchFlag . . . . . . . . . . 1 SYY Batch Flag. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
11 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
12 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-