# View: Rollup Posted Transactions

RotoID: GL0066
Table: GLRPOST
Protocol: Flat, Ordered revisions
DLL: GLRPOST

## Compositions: 0

## Keys: 1

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

## Fields: 37

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
ACCTID | 1 | String*45 | Account Number | E A K R | Mask: %-45C
FISCALYR | 2 | String*4 | Fiscal Year | E A K R | Mask: %04D
FISCALPERD | 3 | String*2 | Fiscal Period | E A K R | Mask: %02D
SRCECURN | 4 | String*3 | Source Currency Code | E A K R | Mask: %-3N
SRCELEDGER | 5 | String*2 | Source Ledger Code | E A K R | Mask: %-2A
SRCETYPE | 6 | String*2 | Source Type Code | E A K R | Mask: %-2N
POSTINGSEQ | 7 | BCD*4.0 | Posting Sequence Number | E A K R |
CNTDETAIL | 8 | BCD*4.0 | Detail Count | E A K R |
JRNLDATE | 9 | Date | Journal Date | E A |
BATCHNBR | 10 | String*6 | Batch Number | E A | Mask: %06D
ENTRYNBR | 11 | String*5 | Journal Entry Number | E A | Mask: %05D
TRANSNBR | 12 | BCD*4.0 | Journal Transaction Number | E A |
EDITALLOWD | 13 | Integer | Reserved |  |
CONSOLIDAT | 14 | Integer | Consolidation Occurred on Post | E A | List: 2 entries
0 | = | No
1 | = | Yes
COMPANYID | 15 | String*8 | Company ID | E A |
JNLDTLDESC | 16 | String*60 | Journal Detail Description | E A |
JNLDTLREF | 17 | String*60 | Journal Detail Reference | E A |
TRANSAMT | 18 | BCD*10.3 | Journal Transaction Amount | E A T |
TRANSQTY | 19 | BCD*10.3 | Journal Transaction Quantity | E A T |
SCURNDEC | 20 | String*1 | Nbr of Source Currency Decimals | E A |
SCURNAMT | 21 | BCD*10.3 | Source Currency Amount | E A T |
HCURNCODE | 22 | String*3 | Home Currency Code | E A | Mask: %-3N
RATETYPE | 23 | String*2 | Currency Rate Table Type | E A | Mask: %-2N
SCURNCODE | 24 | String*3 | Source Currency Code | E A | Mask: %-3N
RATEDATE | 25 | Date | Date of Currency Rate Selected | E A |
CONVRATE | 26 | BCD*8.7 | Currency Rate for Conversion | E A |
RATESPREAD | 27 | BCD*8.7 | Currency Rate Spread Allowed | E A |
DATEMTCHCD | 28 | String*1 | Code for Rate Date Matching | E A |
RATEOPER | 29 | String*1 | Currency Rate Operator | E A |
DRILSRCTY | 30 | Integer | Drill Down Type | E A |
DRILLDWNLK | 31 | BCD*10.0 | Drill Down Link Number | E A |
DRILAPP | 32 | String*2 | Drill Down Application Source | E A | Mask: %-2A
RPTAMT | 33 | BCD*10.3 | Report Currency Amount | E A T |
VALUES | 34 | Long | Optional Fields | E A |
FMTACCTD | 35 | String*45 | Formatted Account Number | E A | Mask: %-45C
DACCTID | 36 | String*45 | Trans. Account Number | E A | Mask: %-45C
DFMTACCTD | 37 | String*45 | Trans. Formatted Account Number | E A | Mask: %-45C

This page was generated on 2008-May-01

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