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.