Table: Posting Journal Details

Table: GLPJD
View: GL0016
Record Length: 353

Flags: A R 

Keys: 3

Title Flags Fields

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

Fields: 42

Field Type Title Presentation

POSTINGSEQ BCD*4.0 Posting sequence number
BATCHNBR String*6 Batch Number Mask: %06D
ENTRYNBR String*5 Journal entry number Mask: %05D
TRANSNBR BCD*4.0 Journal transaction number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
JRNLDATE Date Journal date
FISCALYR String*4 Fiscal year Mask: %04D
FISCALPERD String*2 Fiscal period Mask: %02D
SRCELEDGER String*2 Source Ledger Code Mask: %-2A
SRCETYPE String*2 Source Type Code Mask: %-2N
EDITALLOWD Integer Reserved
CONSOLIDAT Integer Consolidation occurred on post List:2 entries
0 = No
1 = Yes
ACCTID String*45 Account Number Mask: %-45C
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
CODESTATUS Integer Printed status code List:2 entries
0 = Not Printed
1 = Printed
DATEENTRY Date Posting Date
RPTAMT BCD*10.3 Report currency amount
VALUES Long Optional Fields
ORIGCOMP String*6 Originator Mask: %-6N
SWREVERSE Integer Auto Reversal List:3 entries
0 = Auto Reversal Off
1 = Next Period
2 = Specific Period
DESCOMP String*6 Destination Mask: %-6N
ROUTE Integer Route No.
DOCDATE Date Document Date
TAXAUTH String*12 Tax Authority
TXACCTTYPE Integer Tax Account Type List:5 entries
0 = None
1 = Liability
2 = Expense
3 = Recoverable
4 = Allocated