# Table: Prov. Posting Journal Details

Table: GLPPD
View: GL0014
Record length: 318
Flags: A R

## Keys: 3

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

## Fields: 35

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 | Entry Date |
RPTAMT | BCD*10.3 | Report currency amount |
VALUES | Long | Optional Fields |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.