# View: Posting Journal Details

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

## Compositions: 0

## Keys: 3

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

## Fields: 35

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 | Entry 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 |

This page was generated on 2009-Nov-19

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