Table: Posting Journal Generated GL Details

Table: APPJGID
View: AP0519
Record Length: 283

Flags: A R 

Keys: 1

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

Fields: 25

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

This page was generated on 2021-Nov-24

© 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).