View: Accounts

RotoID: GL0001
Table: GLAMF
DLL: GLAMF

Compositions: 7

RotoID	Table	Title	DLL

GL0003	GLAFS	Fiscal Sets	GLFISC
GL0004	GLAIS	Account Allocation Instructions	GLAIS
GL0012	GLAVC	Account Valid Currencies	GLAVC
GL0023	GLABRX	Structure Codes	GLABRX
GL0107	GLCAS	Control Account Subledgers	GLCAS
GL0400	GLAMFO	Account Optional Fields	GLAMFO
GL0401	GLAMFTO	Account Trans. Optional Fields	GLAMFTO

Keys: 14

Title	Fields

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

Fields: 43

Field

Index

Type

Title

Attributes

Presentation

1

String*45

Unformatted Account

E A K R

Mask: %-45C

2

Date

Date Created

E A

3

String*60

Description

E A

4

String*1

Type

E A

List: 3 entries

I	=	Income Statement
B	=	Balance Sheet
R	=	Retained Earnings

5

String*1

Normal Balance DR/CR

E A

List: 2 entries

1	=	Debit
2	=	Credit

6

Integer

Status

E A

List: 2 entries

0	=	Inactive
1	=	Active

7

Integer

Consolidate Journals

E A

List: 2 entries

0	=	Do not consolidate journals
1	=	Consolidate journals

8

Integer

Quantities Allowed

E A

List: 2 entries

0	=	No
1	=	Yes

9

String*6

Unit of Measure

E A

10

Integer

Allocations Allowed

E A

List: 3 entries

0	=	No Allocation
1	=	Allocated by Account Balance
2	=	Allocated by Account Quantity

11

String*45

Alloc Offset Account

E A

Mask: %-45C

12

String*2

Alloc Source Type

E A

Mask: %-2N

13

Integer

Multicurrency

E A

List: 2 entries

0	=	No
1	=	Yes

14

Integer

Specific Currency

E A

List: 2 entries

0	=	All Currencies
1	=	Specific Currencies

15

Integer

Reserved

E

16

Integer

Control Account

E A

List: 2 entries

0	=	No
1	=	Yes

17

String*2

Reserved

E A

Mask: %-2A

18

BCD*8.7

Allocation Percent Total

E A C

19

String*6

Structure Code

E A

Mask: %-6N

20

BCD*4.0

Year Last Closed

E A

21

String*45

Account Number

E A

22

String*15

Account Segment Code 1

E A

23

String*15

Account Segment Code 2

E A

24

String*15

Account Segment Code 3

E A

25

String*15

Account Segment Code 4

E A

26

String*15

Account Segment Code 5

E A

27

String*15

Account Segment Code 6

E A

28

String*15

Account Segment Code 7

E A

29

String*15

Account Segment Code 8

E A

30

String*15

Account Segment Code 9

E A

31

String*15

Account Segment Code 10

E A

32

String*15

Segment Code

E A

33

String*4

Reserved

E

34

String*6

Post to Segment ID

E A

35

String*3

Default Currency Code

E A

Mask: %-3N

36

String*6

Reserved

E A C

37

Integer

Reserved

E A C

38

Integer

Reserved

E A C

39

Long

Optional Fields

E A C

40

Long

Transaction Optional Fields

E A C

41

Integer

Process Switch

E A C

List: 3 entries

0	=	Update Unit of Measurement
1	=	Insert Optional Fields
2	=	Replace Optional Fields

42

String*12

Account Group Code

E A

Mask: %-12N

43

String*12

Account Group Sort Code

E A

Mask: %-12N

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.