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 2009-Nov-19

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