Table: Posted Transactions

Table: GLPOST
View: GL0018
Record length: 260
Flags: A R 

Keys: 4


Title  Flags  Fields

Posted Transactions   ACCTID, FISCALYR, FISCALPERD, SRCECURN, SRCELEDGER, SRCETYPE, POSTINGSEQ, CNTDETAIL
Dated Posting Sequence   D M  JRNLDATE, POSTINGSEQ, BATCHNBR, ENTRYNBR, TRANSNBR
Posting Sequence   D M  POSTINGSEQ, BATCHNBR, ENTRYNBR, TRANSNBR
Account Posting Sequence   D M  ACCTID, POSTINGSEQ, BATCHNBR, ENTRYNBR, TRANSNBR

Fields: 37


Field  Type  Title  Presentation 

ACCTID  String*45  Account Number  Mask: %-45C
FISCALYR  String*4  Fiscal year  Mask: %04D
FISCALPERD  String*2  Fiscal period  Mask: %02D
SRCECURN  String*3  Source currency code  Mask: %-3N
SRCELEDGER  String*2  Source Ledger Code  Mask: %-2A
SRCETYPE  String*2  Source Type Code  Mask: %-2N
POSTINGSEQ  BCD*4.0  Posting sequence number   
CNTDETAIL  BCD*4.0  Detail count   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
JRNLDATE  Date  Journal date   
BATCHNBR  String*6  Batch Number  Mask: %06D
ENTRYNBR  String*5  Journal entry number  Mask: %05D
TRANSNBR  BCD*4.0  Journal transaction number   
EDITALLOWD  Integer  Reserved   
CONSOLIDAT  Integer  Consolidation occurred on post  List: 2 entries
0=No
1=Yes
COMPANYID  String*8  Company ID   
JNLDTLDESC  String*30  Journal detail description   
JNLDTLREF  String*22  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   
DRILSRCTY  Integer  Drill Down Type   
DRILLDWNLK  BCD*10.0  Drill Down Link Number   
DRILAPP  String*2  Drill Down Application Source  Mask: %-2A
RPTAMT  BCD*10.3  Report currency amount   

This page was generated on 2003-Apr-12

Copyright © 2002 ACCPAC International, Inc. All rights reserved.