Table: Posted Transactions

Table: GLPOST
View: GL0018
Record length: 332
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: 38

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*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   
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   
VALUES  Long  Optional Fields   

This page was generated on 2009-Nov-19

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