View: Accounts

RotoID: GL0001
Table: GLAMF
Protocol: Header
DLL:GLAMF

Compositions: 9

RotoID Tables Title DLL
GL0003 Fiscal Sets GLFISC
GL0004 GLAIS Account Allocation Instructions GLAIS
GL0012 GLAVC Account Valid Currencies GLAVC
GL0023 GLABRX Structure Codes GLABRX
GL0107 GLCAS Control Account Subledgers GLCAS
GL0400 GLAMFO Account Optional Fields GLAMFO
GL0401 GLAMFTO Account Trans. Optional Fields GLAMFTO
GL0057 GLACHD Rollup Groups GLACHD
GL0063 GLPACHD Rollup Member Preview GLPACHD

Keys: 14

Title Fields
Account ID ACCTID
Account Group Code ACCTGRPCOD, ACCTSEGVAL, ABRKID, ACCTID
Account ACSEGVAL01, ACCTSEGVAL, ABRKID, ACCTID
Division ACSEGVAL02, ACCTSEGVAL, ABRKID, ACCTID
Region ACSEGVAL03, ACCTSEGVAL, ABRKID, ACCTID
Unused Key - Segment 4 ACSEGVAL04, ACCTSEGVAL, ABRKID, ACCTID
Unused Key - Segment 5 ACSEGVAL05, ACCTSEGVAL, ABRKID, ACCTID
Unused Key - Segment 6 ACSEGVAL06, ACCTSEGVAL, ABRKID, ACCTID
Unused Key - Segment 7 ACSEGVAL07, ACCTSEGVAL, ABRKID, ACCTID
Unused Key - Segment 8 ACSEGVAL08, ACCTSEGVAL, ABRKID, ACCTID
Unused Key - Segment 9 ACSEGVAL09, ACCTSEGVAL, ABRKID, ACCTID
Unused Key - Segment 10 ACSEGVAL10, ACCTSEGVAL, ABRKID, ACCTID
Formatted Account ID ACCTFMTTD
Sort Order - Account Group ACCTGRPSCD, ACCTGRPCOD, ACCTSEGVAL, ABRKID, ACCTID

Fields: 82

Field Index Type Title Attributes Presentation
ACCTID 1 String*45 Unformatted Account E A K R  Mask: %-45C
CREATEDATE 2 Date Date Created E A 
ACCTDESC 3 String*60 Description E A 
ACCTTYPE 4 String*1 Type E A  List:3 entries
I = Income Statement
B = Balance Sheet
R = Retained Earnings
ACCTBAL 5 String*1 Normal Balance DR/CR E A  List:2 entries
1 = Debit
2 = Credit
ACTIVESW 6 Integer Status E A  List:2 entries
0 = Inactive
1 = Active
CONSLDSW 7 Integer Post to Account E A  List:3 entries
0 = Detail
1 = Consolidated
2 = Prohibited
QTYSW 8 Integer Quantities Allowed E A  List:2 entries
0 = No
1 = Yes
UOM 9 String*6 Unit of Measure E A 
ALLOCSW 10 Integer Allocations Allowed E A  List:3 entries
0 = No Allocation
1 = Allocated by Account Balance
2 = Allocated by Account Quantity
ACCTOFSET 11 String*45 Alloc Offset Account E A  Mask: %-45C
ACCTSRTY 12 String*2 Alloc Source Type E A  Mask: %-2N
MCSW 13 Integer Multicurrency E A  List:2 entries
0 = No
1 = Yes
SPECSW 14 Integer Specific Currency E A  List:2 entries
0 = All Currencies
1 = Specific Currencies
ACCTGRPID 15 Integer Reserved E 
CTRLACCTSW 16 Integer Control Account E A  List:2 entries
0 = No
1 = Yes
SRCELDGID 17 String*2 Reserved E A  Mask: %-2A
ALLOCTOT 18 BCD*8.7 Allocation Percent Total E A C 
ABRKID 19 String*6 Structure Code E A  Mask: %-6N
YRACCTCLOS 20 BCD*4.0 Year Last Closed E A 
ACCTFMTTD 21 String*45 Account Number E A 
ACSEGVAL01 22 String*15 Account Segment Code 1 E A 
ACSEGVAL02 23 String*15 Account Segment Code 2 E A 
ACSEGVAL03 24 String*15 Account Segment Code 3 E A 
ACSEGVAL04 25 String*15 Account Segment Code 4 E A 
ACSEGVAL05 26 String*15 Account Segment Code 5 E A 
ACSEGVAL06 27 String*15 Account Segment Code 6 E A 
ACSEGVAL07 28 String*15 Account Segment Code 7 E A 
ACSEGVAL08 29 String*15 Account Segment Code 8 E A 
ACSEGVAL09 30 String*15 Account Segment Code 9 E A 
ACSEGVAL10 31 String*15 Account Segment Code 10 E A 
ACCTSEGVAL 32 String*15 Segment Code E A 
ACCTGRPCPY 33 String*4 Reserved E 
POSTOSEGID 34 String*6 Post to Segment ID E A 
DEFCURNCOD 35 String*3 Default Currency Code E A  Mask: %-3N
CUOM 36 String*6 Reserved E A C 
SAMEUOMSW 37 Integer Reserved E A C 
GSSTATUS 38 Integer Reserved E A C 
OVALUES 39 Long Optional Fields E A C 
TOVALUES 40 Long Transaction Optional Fields E A C 
PROCESSCMD 41 Integer Process Switch E A C  List:8 entries
0 = Update Unit of Measurement
1 = Insert Optional Fields
2 = Replace Optional Fields
3 = Check valid account under GS
4 = Create Preview Accts
5 = Copy Accts from Preview
6 = Unlock Account Selector Preview
7 = Check Overlapped Rollup Relationship
ACCTGRPCOD 42 String*12 Account Group Code E A  Mask: %-12N
ACCTGRPSCD 43 String*12 Account Group Sort Code E A  Mask: %-12N
ROLLUPSW 44 Integer Rollup Switch E A  List:2 entries
0 = No
1 = Yes
TOPPARSW 45 Integer Rollup/Member/Non-Rollup E A C  List:3 entries
0 = Account Not in Rollup Group
1 = Member Account in Rollup Group
2 = Rollup Account in Rollup Group
RFRACCT 46 String*45 Acct Selector - From Account E A C  Mask: %-45C
RTOACCT 47 String*45 Acct Selector - To Account E A C  Mask: %-45C
RFRSEG1 48 String*15 Acct Selector - From Seg1 Val E A C 
RTOSEG1 49 String*15 Acct Selector - To Seg1 Val E A C 
RFRSEG2 50 String*15 Acct Selector - From Seg2 Val E A C 
RTOSEG2 51 String*15 Acct Selector - To Seg2 Val E A C 
RFRSEG3 52 String*15 Acct Selector - From Seg3 Val E A C 
RTOSEG3 53 String*15 Acct Selector - To Seg3 Val E A C 
RFRSEG4 54 String*15 Acct Selector - From Seg4 Val E A C 
RTOSEG4 55 String*15 Acct Selector - To Seg4 Val E A C 
RFRSEG5 56 String*15 Acct Selector - From Seg5 Val E A C 
RTOSEG5 57 String*15 Acct Selector - To Seg5 Val E A C 
RFRSEG6 58 String*15 Acct Selector - From Seg6 Val E A C 
RTOSEG6 59 String*15 Acct Selector - To Seg6 Val E A C 
RFRSEG7 60 String*15 Acct Selector - From Seg7 Val E A C 
RTOSEG7 61 String*15 Acct Selector - To Seg7 Val E A C 
RFRSEG8 62 String*15 Acct Selector - From Seg8 Val E A C 
RTOSEG8 63 String*15 Acct Selector - To Seg8 Val E A C 
RFRSEG9 64 String*15 Acct Selector - From Seg9 Val E A C 
RTOSEG9 65 String*15 Acct Selector - To Seg9 Val E A C 
RFRSEG10 66 String*15 Acct Selector - From Seg10 Val E A C 
RTOSEG10 67 String*15 Acct Selector - To Seg10 Val E A C 
ROPTFLD1 68 String*12 Acct Selector - Opt. Field 1 E A C 
ROPTFLD2 69 String*12 Acct Selector - Opt. Field 2 E A C 
ROPTFLD3 70 String*12 Acct Selector - Opt. Field 3 E A C 
ROPTFRVAL1 71 String*60 Acct Selector - From Opt1 Val E A C 
ROPTTOVAL1 72 String*60 Acct Selector - To Opt1 Val E A C 
ROPTFRVAL2 73 String*60 Acct Selector - From Opt2 Val E A C 
ROPTTOVAL2 74 String*60 Acct Selector - To Opt2 Val E A C 
ROPTFRVAL3 75 String*60 Acct Selector - From Opt3 Val E A C 
ROPTTOVAL3 76 String*60 Acct Selector - To Opt3 Val E A C 
RACCTTYPE 77 Integer Acct Selector - Acct Type E A C 
RFRGRPID 78 String*12 Acct Selector - From Acct Group E A C  Mask: %-12N
RTOGRPID 79 String*12 Acct Selector - To Acct Group E A C  Mask: %-12N
RQTYSW 80 Integer Acct Selector - Quant. Allowed E A C 
RCNT 81 Long No. of created preview accounts E A C 
ROVERLAP 82 Integer Rollup Members in Other Accounts E A C 

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