# Table: Recurring Entry Details

Table: GLRED
View: GL0042
Record length: 550
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Reccuring Code / Sequence |  | RECID, TRANSNBR

## Fields: 28

Field | Type | Title | Presentation
--- | --- | --- | ---
RECID | String*16 | Recurring Entry Code | Mask: %-16C
TRANSNBR | String*10 | Sequence Number | Mask: %C%09D
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
ACCTID | String*45 | Account Number | Mask: %-45C
COMPANYID | String*8 | Company ID |
TRANSAMT | BCD*10.3 | Amount |
TRANSQTY | BCD*10.3 | Quantity |
SCURNDEC | String*1 | Source Currency Decimals |
SCURNAMT | BCD*10.3 | Source Currency Amount |
HCURNCODE | String*3 | Home Currency | Mask: %-3N
RATETYPE | String*2 | Currency Rate Table | Mask: %-2N
SCURNCODE | String*3 | Source Currency | Mask: %-3N
RATEDATE | Date | Currency Rate Date |
CONVRATE | BCD*8.7 | Currency Rate |
RATESPREAD | BCD*8.7 | Currency Rate Spread |
DATEMTCHCD | String*1 | Currency Rate Date Matching |
RATEOPER | String*1 | Currency Rate Operator |
TRANSDESC | String*60 | Description |
TRANSREF | String*60 | Reference |
TRANSDATE | Date | Recurring Entry Date |
SRCELDGR | String*2 | Source Ledger | Mask: %-2A
SRCETYPE | String*2 | Source Type | Mask: %-2N
COMMENT | String*250 | Comment |
ZEROSRCFG | Boolean | Zero Source Amount Flag |
VALUES | Long | Optional Fields |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.