View: Prov. Posting Journal Details

RotoID: GL0014
Table: GLPPD
Protocol: Flat
DLL:GLPPD

Keys: 3

Title Fields
Prov. Posting Journal Detail POSTINGSEQ, BATCHNBR, ENTRYNBR, TRANSNBR
Unformatted account ACCTID
Posting Journal Dtl-Entry Perd POSTINGSEQ, BATCHNBR, ENTRYNBR, FISCALYR, FISCALPERD, TRANSNBR

Fields: 34

Field Index Type Title Attributes Presentation
POSTINGSEQ 1 BCD*4.0 Prov. Posting sequence number E A K R 
BATCHNBR 2 String*6 Batch Number E A K R  Mask: %06D
ENTRYNBR 3 String*5 Journal entry number E A K R  Mask: %05D
TRANSNBR 4 BCD*4.0 Journal transaction number E A K R 
JRNLDATE 5 Date Journal date E A 
FISCALYR 6 String*4 Fiscal year E A  Mask: %04D
FISCALPERD 7 String*2 Fiscal period E A  Mask: %02D
SRCELEDGER 8 String*2 Source Ledger Code E A  Mask: %-2A
SRCETYPE 9 String*2 Source Type Code E A  Mask: %-2N
EDITALLOWD 10 Integer Reserved A 
CONSOLIDAT 11 Integer Consolidation occurred on post E A  List:2 entries
0 = No
1 = Yes
ACCTID 12 String*45 Account Number E A  Mask: %-45C
COMPANYID 13 String*8 Company ID E A 
JNLDTLDESC 14 String*60 Journal detail description E A 
JNLDTLREF 15 String*60 Journal detail reference E A 
TRANSAMT 16 BCD*10.3 Journal transaction amount E A T P R 
TRANSQTY 17 BCD*10.3 Journal transaction quantity E A T P 
SCURNDEC 18 String*1 Nbr of source currency decimals E A 
SCURNAMT 19 BCD*10.3 Source currency amount E A T P R 
HCURNCODE 20 String*3 Home currency code E A  Mask: %-3N
RATETYPE 21 String*2 Currency rate table type E A  Mask: %-2N
SCURNCODE 22 String*3 Source currency code E A  Mask: %-3N
RATEDATE 23 Date Date of currency rate selected E A 
CONVRATE 24 BCD*8.7 Currency rate for conversion E A 
RATESPREAD 25 BCD*8.7 Currency rate spread allowed E A 
DATEMTCHCD 26 String*1 Code for rate date matching E A 
RATEOPER 27 String*1 Currency rate operator E A 
CODESTATUS 28 Integer Printed status code E A  List:2 entries
0 = Not Printed
1 = Printed
DATEENTRY 29 Date Posting Date E A 
RPTAMT 30 BCD*10.3 Report currency amount E A T P R 
VALUES 31 Long Optional Fields E A C 
DOCDATE 32 Date Document Date E A 
TAXAUTH 33 String*12 Tax Authority E A C 
TXACCTTYPE 34 Integer Tax Account Type E A C 

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