View: GL Subledger Details

RotoID: GP0110
Table: GPGLBD
Protocol: Detail, Ordered revisions
DLL:GPGLBD

Compositions: 2

RotoID Tables Title DLL
GP0120 GPGLBH GL Subledger Entries GPGLBH
GP0130 GPGLBO GL Subledger Detail Opt. Fields GPGLBO

Keys: 1

Title Fields
Details BSEQUENCE, ESEQUENCE, DSEQUENCE

Fields: 19

Field Index Type Title Attributes Presentation
BSEQUENCE 1 BCD*10.0 Batch Sequence E A K R 
ESEQUENCE 2 BCD*10.0 Entry Sequence E A K R 
DSEQUENCE 3 BCD*10.0 Detail Sequence E A K R 
ACCOUNT 4 String*45 Account Code E A 
SRCECUR 5 String*3 Source Currency E A 
DESC 6 String*60 Description E A 
REFERENCE 7 String*60 Reference E A 
TRANSAMT 8 BCD*10.3 Functional Amount E A 
TRANSQTY 9 BCD*10.3 Quantity E A 
SRCEAMT 10 BCD*10.3 Source Amount E A 
SRCEDEC 11 Integer Source Currency Decimals E A 
RATETYPE 12 String*2 Rate Type E A 
RATEDATE 13 Date Rate Date E A 
CONVRATE 14 BCD*8.7 Rate E A 
RATESPREAD 15 BCD*8.7 Rate Spread E A 
RATEMTCHCD 16 Integer Rate Matching Code E A  List:3 entries
1 = Exact
2 = Later
3 = Earlier
RATEOPER 17 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
TRANSDATE 18 Date Transaction Date E A 
COMMENT 19 String*250 Comment E A 

This page was generated on 2023-Aug-31

© 2023 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).