Table: Posting Journal ICT Generated Details

Table: GLPJID
View: GL0109
Record length: 303
Flags: A R 

Keys: 4

Title  Flags  Fields

Post Seq/Original Trans/Level/Co  POSTINGSEQ, OBATCHNBR, OENTRYNBR, OTRANSNBR, LEVEL, LEVCOMP, BATCHNBR, ENTRYNBR, TRANSNBR
Post Seq/Original Entry/Company/  D M  POSTINGSEQ, OBATCHNBR, OENTRYNBR, LEVCOMP, BATCHNBR, ENTRYNBR, TRANSNBR
Company/Transaction  D M  LEVCOMP, BATCHNBR, ENTRYNBR, TRANSNBR
Company/Account/Transaction  D M  LEVCOMP, ACCTID, BATCHNBR, ENTRYNBR, TRANSNBR

Fields: 31

Field  Type  Title  Presentation 

POSTINGSEQ  BCD*4.0  Posting Sequence Number   
OBATCHNBR  String*6  Original Batch Number   
OENTRYNBR  String*5  Original Entry Number   
OTRANSNBR  BCD*4.0  Original Transaction Number   
LEVEL  Integer  Route Level   
LEVCOMP  String*6  Company   
BATCHNBR  String*6  Batch Number   
ENTRYNBR  String*5  Entry Number   
TRANSNBR  BCD*4.0  Transaction Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRANSDATE  Date  Transaction Date   
TRANSREF  String*60  Reference   
TRANSDESC  String*60  Description   
ACCTID  String*45  Account Number   
SRCELDGR  String*2  Source Ledger   
SRCETYPE  String*2  Source Type   
SCURNCODE  String*3  Source Currency   
SCURNDEC  String*1  Source Currency Decimals   
RATEDATE  Date  Rate Date   
DATEMTCHCD  String*1  Rate Date Matching   
RATETYPE  String*2  Rate Type   
RATEOPER  String*1  Rate Operator   
CONVRATE  BCD*8.7  Rate   
RATESPREAD  BCD*8.7  Rate Spread   
TRANSQTY  BCD*10.3  Quantity   
SCURNAMT  BCD*10.3  Source Currency Amount   
TRANSAMT  BCD*10.3  Amount   
VALUES  Long  Optional Fields   

This page was generated on 2009-Nov-19

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