# Table: Accounts

Table: GLAMF
View: GL0001
Record length: 474
Flags: A R

## Keys: 14

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

## Fields: 41

Field | Type | Title | Presentation
--- | --- | --- | ---
ACCTID | String*45 | Unformatted Account | Mask: %-45C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CREATEDATE | Date | Date Created |
ACCTDESC | String*60 | Description |
ACCTTYPE | String*1 | Type | List: 3 entries
I | = | Income Statement
B | = | Balance Sheet
R | = | Retained Earnings
ACCTBAL | String*1 | Normal Balance DR/CR | List: 2 entries
1 | = | Debit
2 | = | Credit
ACTIVESW | Integer | Status | List: 2 entries
0 | = | Inactive
1 | = | Active
CONSLDSW | Integer | Consolidate Journals | List: 2 entries
0 | = | Do not consolidate journals
1 | = | Consolidate journals
QTYSW | Integer | Quantities Allowed | List: 2 entries
0 | = | No
1 | = | Yes
UOM | String*6 | Unit of Measure |
ALLOCSW | Integer | Allocations Allowed | List: 3 entries
0 | = | No Allocation
1 | = | Allocated by Account Balance
2 | = | Allocated by Account Quantity
ACCTOFSET | String*45 | Alloc Offset Account | Mask: %-45C
ACCTSRTY | String*2 | Alloc Source Type | Mask: %-2N
MCSW | Integer | Multicurrency | List: 2 entries
0 | = | No
1 | = | Yes
SPECSW | Integer | Specific Currency | List: 2 entries
0 | = | All Currencies
1 | = | Specific Currencies
ACCTGRPCOD | String*12 | Account Group Code | Mask: %-12N
CTRLACCTSW | Integer | Control Account | List: 2 entries
0 | = | No
1 | = | Yes
SRCELDGID | String*2 | Reserved | Mask: %-2A
ALLOCTOT | BCD*8.7 | Allocation Percent Total |
ABRKID | String*6 | Structure Code | Mask: %-6N
YRACCTCLOS | BCD*4.0 | Year Last Closed |
ACCTFMTTD | String*45 | Account Number |
ACSEGVAL01 | String*15 | Account Segment Code 1 |
ACSEGVAL02 | String*15 | Account Segment Code 2 |
ACSEGVAL03 | String*15 | Account Segment Code 3 |
ACSEGVAL04 | String*15 | Account Segment Code 4 |
ACSEGVAL05 | String*15 | Account Segment Code 5 |
ACSEGVAL06 | String*15 | Account Segment Code 6 |
ACSEGVAL07 | String*15 | Account Segment Code 7 |
ACSEGVAL08 | String*15 | Account Segment Code 8 |
ACSEGVAL09 | String*15 | Account Segment Code 9 |
ACSEGVAL10 | String*15 | Account Segment Code 10 |
ACCTSEGVAL | String*15 | Segment Code |
ACCTGRPSCD | String*12 | Account Group Sort Code | Mask: %-12N
POSTOSEGID | String*6 | Post to Segment ID |
DEFCURNCOD | String*3 | Default Currency Code | Mask: %-3N
OVALUES | Long | Optional Fields |
TOVALUES | Long | Transaction Optional Fields |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.