# Table: Rollup Posted Transactions

Table: GLRPOST
View: GL0066
Record length: 467
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Rollup Posted Transactions |  | ACCTID, FISCALYR, FISCALPERD, SRCECURN, SRCELEDGER, SRCETYPE, POSTINGSEQ, CNTDETAIL

## Fields: 41

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 |
FMTACCTD | String*45 | Formatted Account Number | Mask: %-45C
DACCTID | String*45 | Trans. Account Number | Mask: %-45C
DFMTACCTD | String*45 | Trans. Formatted Account Number | Mask: %-45C

This page was generated on 2009-Nov-19

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