Table: Prov. Posting Journal Details

Table: GLPPD
View: GL0014
Record Length: 323

Flags: A R 

Keys: 3

Title Flags Fields

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

Fields: 36

Field Type Title Presentation

POSTINGSEQ BCD*4.0 Prov. 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
DOCDATE Date Document Date