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
Unused Key - Segment 1  D M  ACSEGVAL01, ACCTSEGVAL, ACCTID
Unused Key - Segment 2  D M  ACSEGVAL02, ACCTSEGVAL, ACCTID
Unused Key - Segment 3  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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.