View: Posting Journal Generated GL Details

RotoID: AP0519
Table: APPJGID
Protocol: Flat
DLL:APPJGID

Keys: 1

Title Fields
Posted Detail/Generated GL Detai TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM, CNTSEQENCE, GENTYPE, BATCHNBR, JOURNALID, TRANSNBR

Fields: 21

Field Index Type Title Attributes Presentation
TYPEBTCH 1 String*2 Batch Type E A K R  Mask: %-2N
POSTSEQNCE 2 BCD*5.0 Posting Sequence No. E A K R 
CNTBTCH 3 BCD*5.0 Batch No. E A K R 
CNTITEM 4 BCD*4.0 Entry No. E A K R 
CNTSEQENCE 5 Long Sequence No. E A K R 
GENTYPE 6 Integer Generation Type E A K R  List:6 entries
1 = AI to GI
4 = Recoverable Tax
3 = Expensed Separately Tax
2 = Allocated Tax
5 = Balance
6 = Exch. Rounding
BATCHNBR 7 String*6 Generated Batch No. E A K R  Mask: %06D
JOURNALID 8 String*5 Generated Entry No. E A K R  Mask: %05D
TRANSNBR 9 String*10 Generated Line No. E A K R  Mask: %C%09D
TRANSDATE 10 Date Transaction Date E A 
TRANSREF 11 String*60 Reference E A 
TRANSDESC 12 String*60 Description E A 
DESCOMP 13 String*6 Destination E A  Mask: %-6N
ROUTE 14 Integer Route No. E A 
ACCTID 15 String*45 G/L Account E A  Mask: %-45C
SRCELDGR 16 String*2 Source Ledger E A  Mask: %-2A
SRCETYPE 17 String*2 Source Type E A  Mask: %-2N
SCURNAMT 18 BCD*10.3 Source Amount E A 
TRANSAMT 19 BCD*10.3 Functional Amount E A 
TRANSQTY 20 BCD*10.3 Quantity E A 
VALUES 21 Long Optional Fields E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).