View: Preview Accounts

RotoID: GL0046
Table: GLWAMF
Protocol: Header
DLL:GLWAMF

Compositions: 4

RotoID	Tables	Title	DLL

GL0047	GLWAVC	Preview A/C Valid Currencies	GLWAVC
GL0048	GLWCAS	Preview Control A/C Subledgers	GLWCAS
GL0407	GLWAMFO	Account Optional Fields	GLWAMFO
GL0408	GLWAMTO	Account Trans. Optional Fields	GLWAMTO

Keys: 14

Title	Fields

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

Fields: 39

Field

Index

Type

Title

Attributes

Presentation

ACCTID

String*45

Unformatted Account

E A K R

Mask: %-45C

ACCTDESC

String*60

Description

E A

ACCTTYPE

String*1

Type

E A

List:3 entries

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

ACCTBAL

String*1

Normal Balance DR/CR

E A

List:2 entries

1	=	Debit
2	=	Credit

ACTIVESW

Integer

Status

E A

List:2 entries

0	=	Inactive
1	=	Active

CONSLDSW

Integer

Consolidate Journals

E A

List:3 entries

0	=	Detail
1	=	Consolidated
2	=	Prohibited

QTYSW

Integer

Quantities Allowed

E A

List:2 entries

0	=	No
1	=	Yes

UOM

String*6

Unit of Measure

E A

ALLOCSW

Integer

Allocations Allowed

E A

ACCTOFSET

String*45

Alloc Offset Account

E A

ACCTSRTY

String*2

Alloc Source Type

E A

MCSW

Integer

Multicurrency

E A

List:2 entries

0	=	No
1	=	Yes

SPECSW

Integer

Specific Currency

E A

List:2 entries

0	=	All Currencies
1	=	Specific Currencies

ACCTGRPCOD

String*12

Account Group Code

E A

Mask: %-12N

CTRLACCTSW

Integer

Control Account

E A

List:2 entries

0	=	No
1	=	Yes

SRCELDGID

String*2

Reserved

E A

Mask: %-2A

ALLOCTOT

BCD*8.7

Allocation Percent Total

E A C

ABRKID

String*6

Structure Code

E A

Mask: %-6N

YRACCTCLOS

BCD*4.0

Year Last Closed

E A

ACCTFMTTD

String*45

Account Number

E A

ACSEGVAL01

String*15

Account Segment Code 1

E A

ACSEGVAL02

String*15

Account Segment Code 2

E A

ACSEGVAL03

String*15

Account Segment Code 3

E A

ACSEGVAL04

String*15

Account Segment Code 4

E A

ACSEGVAL05

String*15

Account Segment Code 5

E A

ACSEGVAL06

String*15

Account Segment Code 6

E A

ACSEGVAL07

String*15

Account Segment Code 7

E A

ACSEGVAL08

String*15

Account Segment Code 8

E A

ACSEGVAL09

String*15

Account Segment Code 9

E A

ACSEGVAL10

String*15

Account Segment Code 10

E A

ACCTSEGVAL

String*15

Segment Code

E A

ACCTGRPSCD

String*12

Account Group Sort Code

E A

Mask: %-12N

POSTOSEGID

String*6

Post to Segment ID

E A

POSTOSGCPY

Integer

Post to Segment ID Copy

E A P

DEFCURNCOD

String*3

Default Currency Code

E A

Mask: %-3N

PROCESSSW

Integer

Process Switch

E A

List:2 entries

0	=	No
1	=	Yes

CREATESW

Integer

Create Switch

E A

List:2 entries

0	=	No
1	=	Yes

OVALUES

Long

Optional Fields

E A C

TOVALUES

Long

Transaction Optional Fields

E A C

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).