Table: Accounts

Table: GLAMF
View: GL0001
Record Length: 476

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: 42

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 Post to Account List:3 entries
0 = Detail
1 = Consolidated
2 = Prohibited
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
ROLLUPSW Integer Rollup Switch List:2 entries
0 = No
1 = Yes

This page was generated on 2022-Aug-18

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