GL_DetailPosting GL Detail Posting Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_GeneralJournal_upd,GL_RecurringJournal_upd,GL_AllocationJournal_upd,GL_TransactionJournal_u
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_DetailPosting.M4T"
KPRIMARY: AccountKey+PostingDate+SourceJournal+JournalRegisterNo+SequenceNo
KSOURCEJOURNAL: SourceJournal+JournalRegisterNo+PostingDate+SequenceNo
KSEQNO: SequenceNo(u)
KPOSTINGDATE: PostingDate(d)+AccountKey+SourceJournal+JournalRegisterNo+SequenceNo
KSOURCEMODULE: SourceModule+AccountKey+PostingDate+SourceJournal+JournalRegisterNo(**)+SequenceNo **=C
ase Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 AccountKey. . . . . . . . . . 9 SNY Account Number. . . . . . . . .ACCOUNT
Notes: Validated against
GL_Account
2 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE
Notes: YYYYMMDD
3 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL
Notes: Validated against
GL_SourceJournal
4 JournalRegisterNo . . . . . . 6 SNY Journal/Register Number . . . .
Mask:000000 FmtType:ZEROFILL
Notes: This can also be a
Journal Number from GL Data
Entry tables.
5 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . .
Mask:00000000000000
FmtType:ZEROFILL
6 SourceModule. . . . . . . . . 2 SYY Source Module . . . . . . . . .
Notes: GL, AP, AR...
7 DocumentType. . . . . . . . . 1 SNY Document Type . . . . . . . . .
Valid:I,C,R,S Notes:
I=Invoice, C=Check,
R=Receipt, S=Summary
8 DocumentNo. . . . . . . . . . 15 SNY Document Number . . . . . . . .
9 DocSequenceNo . . . . . . . . 14 SNY Document Sequence Number. . . .
Mask:00000000000000
FmtType:ZEROFILL
10 ReceiptNo . . . . . . . . . . 7 SNY Receipt Number. . . . . . . . .
11 BatchType . . . . . . . . . . 2 SYY Batch Type. . . . . . . . . . .
12 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM
13 PostingComment. . . . . . . . 2048 SNY Posting Detail Comment. . . . .COMMENT
14 HeaderRec . . . . . . . . . . 1 SYN Header Record . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
15 LineBankCode. . . . . . . . . 1 SNN Line Bank Code. . . . . . . . .BANKCODE
16 LineDocRefer. . . . . . . . . 10 SNN Line Document Reference . . . .
17 LineDate. . . . . . . . . . . 8 SNN Line Date . . . . . . . . . . .DATE
18 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
19 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
20 UserCreatedKey. . . . . . . . 10 SNY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
21 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
22 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-