View: Posted Transactions

RotoID: GL0018
Table: GLPOST
Protocol: Flat
DLL:GLPOST

Keys: 5

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

Fields: 38

Field Index Type Title Attributes Presentation
ACCTID 1 String*45 Account Number E A K R  Mask: %-45C
FISCALYR 2 String*4 Fiscal Year E A K R  Mask: %04D
FISCALPERD 3 String*2 Fiscal Period E A K R  Mask: %02D
SRCECURN 4 String*3 Source Currency Code E A K R  Mask: %-3N
SRCELEDGER 5 String*2 Source Ledger Code E A K R  Mask: %-2A
SRCETYPE 6 String*2 Source Type Code E A K R  Mask: %-2N
POSTINGSEQ 7 BCD*4.0 Posting Sequence Number E A K R 
CNTDETAIL 8 BCD*4.0 Detail Count E A K R 
JRNLDATE 9 Date Journal Date E A 
BATCHNBR 10 String*6 Batch Number E A  Mask: %06D
ENTRYNBR 11 String*5 Journal Entry Number E A  Mask: %05D
TRANSNBR 12 BCD*4.0 Journal Transaction Number E A 
EDITALLOWD 13 Integer Reserved
CONSOLIDAT 14 Integer Consolidation Occurred on Post E A  List:2 entries
0 = No
1 = Yes
COMPANYID 15 String*8 Company ID E A 
JNLDTLDESC 16 String*60 Journal Detail Description E A 
JNLDTLREF 17 String*60 Journal Detail Reference E A 
TRANSAMT 18 BCD*10.3 Journal Transaction Amount E A T 
TRANSQTY 19 BCD*10.3 Journal Transaction Quantity E A T 
SCURNDEC 20 String*1 Nbr of Source Currency Decimals E A 
SCURNAMT 21 BCD*10.3 Source Currency Amount E A T 
HCURNCODE 22 String*3 Home Currency Code E A  Mask: %-3N
RATETYPE 23 String*2 Currency Rate Table Type E A  Mask: %-2N
SCURNCODE 24 String*3 Source Currency Code E A  Mask: %-3N
RATEDATE 25 Date Date of Currency Rate Selected E A 
CONVRATE 26 BCD*8.7 Currency Rate for Conversion E A 
RATESPREAD 27 BCD*8.7 Currency Rate Spread Allowed E A 
DATEMTCHCD 28 String*1 Code for Rate Date Matching E A 
RATEOPER 29 String*1 Currency Rate Operator E A 
DRILSRCTY 30 Integer Drill Down Type E A 
DRILLDWNLK 31 BCD*10.0 Drill Down Link Number E A 
DRILAPP 32 String*2 Drill Down Application Source E A  Mask: %-2A
RPTAMT 33 BCD*10.3 Report Currency Amount E A T 
VALUES 34 Long Optional Fields E A 
DOCDATE 35 Date Document Date E A 
TXRPTSTAT 36 Long Tax Reporting Status - KB 103720 E A 
TAXAUTH 37 String*12 Tax Authority E A C 
TXACCTTYPE 38 Integer Tax Account Type E A C  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).