Table: Preview Accounts

Table: GLWAMF
View: GL0046
Record length: 449
Flags: A R 

Keys: 13


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

Fields: 41


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: 2 entries
0=Detail
1=Consolidated
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 currency
1=Specific currency
ACCTGRPID  Integer  Account Group  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  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   
ACCTGRPCPY  String*4  Account Group COPY   
POSTOSEGID  String*6  Post to Segment ID   
POSTOSGCPY  Integer  Post to Segment ID Copy  List: 2 entries
0=
34=
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

This page was generated on 2003-Sep-18

Copyright © 2003 ACCPAC International, Inc. All rights reserved.