Table: Posted Transactions

Table: GLPOST
View: GL0018
Record Length: 355

Flags: A R 

Keys: 5

Title Flags Fields
Posted Transactions ACCTID, FISCALYR, FISCALPERD, SRCECURN, SRCELEDGER, SRCETYPE, POSTINGSEQ, CNTDETAIL
Dated Posting Sequence D M  JRNLDATE, POSTINGSEQ, BATCHNBR, ENTRYNBR, TRANSNBR
Posting Sequence D M  POSTINGSEQ, BATCHNBR, ENTRYNBR, TRANSNBR
Account Posting Sequence D M  ACCTID, POSTINGSEQ, BATCHNBR, ENTRYNBR, TRANSNBR
Document Dated Posting Sequence D M  ACCTID, DOCDATE, POSTINGSEQ, CNTDETAIL, BATCHNBR, ENTRYNBR, TRANSNBR

Fields: 42

Field Type Title Presentation
ACCTID String*45 Account Number Mask: %-45C
FISCALYR String*4 Fiscal Year Mask: %04D
FISCALPERD String*2 Fiscal Period Mask: %02D
SRCECURN String*3 Source Currency Code Mask: %-3N
SRCELEDGER String*2 Source Ledger Code Mask: %-2A
SRCETYPE String*2 Source Type Code Mask: %-2N
POSTINGSEQ BCD*4.0 Posting Sequence Number
CNTDETAIL BCD*4.0 Detail Count
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
JRNLDATE Date Journal Date
BATCHNBR String*6 Batch Number Mask: %06D
ENTRYNBR String*5 Journal Entry Number Mask: %05D
TRANSNBR BCD*4.0 Journal Transaction Number
EDITALLOWD Integer Reserved
CONSOLIDAT Integer Consolidation Occurred on Post List:2 entries
0 = No
1 = Yes
COMPANYID String*8 Company ID
JNLDTLDESC String*60 Journal Detail Description
JNLDTLREF String*60 Journal Detail Reference
TRANSAMT BCD*10.3 Journal Transaction Amount
TRANSQTY BCD*10.3 Journal Transaction Quantity
SCURNDEC String*1 Nbr of Source Currency Decimals
SCURNAMT BCD*10.3 Source Currency Amount
HCURNCODE String*3 Home Currency Code Mask: %-3N
RATETYPE String*2 Currency Rate Table Type Mask: %-2N
SCURNCODE String*3 Source Currency Code Mask: %-3N
RATEDATE Date Date of Currency Rate Selected
CONVRATE BCD*8.7 Currency Rate for Conversion
RATESPREAD BCD*8.7 Currency Rate Spread Allowed
DATEMTCHCD String*1 Code for Rate Date Matching
RATEOPER String*1 Currency Rate Operator
DRILSRCTY Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
DRILAPP String*2 Drill Down Application Source Mask: %-2A
RPTAMT BCD*10.3 Report Currency Amount
VALUES Long Optional Fields
DOCDATE Date Document Date
TXRPTSTAT Long Tax Reporting Status - KB 103720
TAXAUTH String*12 Tax Authority
TXACCTTYPE Integer Tax Account Type List:5 entries
0 = None
1 = Liability
2 = Expense
3 = Recoverable
4 = Allocated

This page was generated on 2023-Aug-31

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