Table: GL Subledger Details

Table: GPGLBD
View: GP0110
Record length: 536
Flags: A R 

Keys: 1

Title  Flags  Fields

Details  BSEQUENCE, ESEQUENCE, DSEQUENCE

Fields: 23

Field  Type  Title  Presentation 

BSEQUENCE  BCD*10.0  Batch Sequence   
ESEQUENCE  BCD*10.0  Entry Sequence   
DSEQUENCE  BCD*10.0  Detail Sequence   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
ACCOUNT  String*45  Account Code   
SRCECUR  String*3  Source Currency   
DESC  String*60  Description   
REFERENCE  String*60  Reference   
TRANSAMT  BCD*10.3  Functional Amount   
TRANSQTY  BCD*10.3  Quantity   
SRCEAMT  BCD*10.3  Source Amount   
SRCEDEC  Integer  Source Currency Decimals   
RATETYPE  String*2  Rate Type   
RATEDATE  Date  Rate Date   
CONVRATE  BCD*8.7  Rate   
RATESPREAD  BCD*8.7  Rate Spread   
RATEMTCHCD  Integer  Rate Matching Code  List: 3 entries
1=Exact
2=Later
3=Earlier
RATEOPER  Integer  Rate Operation  List: 2 entries
1=Multiply
2=Divide
TRANSDATE  Date  Transaction Date   
COMMENT  String*250  Comment   

This page was generated on 2009-Nov-19

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