# View: Accounts

RotoID: GL0100
Table: GLAMF
DLL: GLAMF

## Compositions: 7

RotoID | Table | Title | DLL
--- | --- | --- | ---
GL0003 | GLAFS | 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

## Keys: 13

Title | Fields
--- | ---
Account ID | ACCTID
Account Group | ACCTGRPCPY, 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

## Fields: 41

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 | Consolidate Journals | E A | List: 2 entries
0 | = | Do not consolidate journals
1 | = | Consolidate journals
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 | Account Group | E A | List: 16 entries
1 | = | Current assets
2 | = | Fixed assets
3 | = | Other assets
4 | = | Accumulated depreciation
5 | = | Current liabilities
6 | = | Long term liabilities
7 | = | Shareholders' equity
8 | = | Revenue
9 | = | Cost of sales
10 | = | Opening inventory
11 | = | Purchases
12 | = | Closing inventory
13 | = | Cost and expenses
14 | = | Other income and expenses
15 | = | Provision for income taxes
16 | = | Other
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 | Account Group COPY | E A |
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: 3 entries
0 | = | Update Unit of Measurement
1 | = | Insert Optional Fields
2 | = | Replace Optional Fields

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.