Table: Preview Accounts

Table: GLWAMF
View: GL0046
Record Length: 475

Flags: A R 

Keys: 14

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

Fields: 43

Field Type Title Presentation
ACCTID String*45 Unformatted Account Mask: %-45C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
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: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
ACCTOFSET String*45 Alloc Offset Account
ACCTSRTY String*2 Alloc Source Type
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
POSTOSGCPY Integer Post to Segment ID Copy
DEFCURNCOD String*3 Default Currency Code Mask: %-3N
PROCESSSW Integer Process Switch List:2 entries
0 = No
1 = Yes
CREATESW Integer Create Switch List:2 entries
0 = No
1 = Yes
OVALUES Long Optional Fields
TOVALUES Long Transaction Optional Fields

This page was generated on 2021-Nov-24

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