Table: Recurring Entry Details

Table: GLRED
View: GL0042
Record Length: 550

Flags: A R 

Keys: 1

Title Flags Fields

Reccuring Code / Sequence RECIDTRANSNBR

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