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 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).