# Table: Posting Journal ICT Generated De

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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.