View: Posting Journal Details

RotoID: GL0016
Table: GLPJD
Protocol: Flat
DLL:GLPJD

Keys: 3

Title Fields

Posting Journal Detail POSTINGSEQBATCHNBRENTRYNBRTRANSNBR
Unformatted account ACCTID
Posting Journal Dtl-Entry Perd POSTINGSEQBATCHNBRENTRYNBRFISCALYRFISCALPERDTRANSNBR

Fields: 38

Field Index Type Title Attributes Presentation

POSTINGSEQ 1 BCD*4.0 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 
ORIGCOMP 32 String*6 Originator E A  Mask: %-6N
SWREVERSE 33 Integer Auto Reversal E A  List:3 entries
0 = Auto Reversal Off
1 = Next Period
2 = Specific Period
DESCOMP 34 String*6 Destination E A  Mask: %-6N
ROUTE 35 Integer Route No. E A 
DOCDATE 36 Date Document Date 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