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

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