Table: Posting Journal Details

Table: GLPJD
View: GL0016
Record length: 334
Flags: A R 

Keys: 3

Title  Flags  Fields

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: 39

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

This page was generated on 2008-May-01

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