# View: Accounts

RotoID: GL0100
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 2008-May-01

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