ACTNUMST

string

75

N

<blank>

Account string

ACTALIAS

string

21

N

<blank>

Account alias

ACCTTYPE

i4

2

N

1

Account type:

1=Posting;

2=Unit account;

3=Posting allocation;

4=Unit allocation

ACTDESCR

string

50

N

<blank>

Account description:

If a value is not supplied, the element value defaults from the segment setup.

PSTNGTYP

i4

2

N

0

Posting type:

0=Balance sheet;

1=Profit & loss account

CATEGORY

string

50

N

<blank>

Account category—required if a posting account

ACTIVE

i4

1

N

1

Active:

0=Inactive;

1=Active

TPCLBLNC

i4

2

N

0

Typical balance: 0=Debit; 1=Credit

DECPLACS

i4

2

N

0

Decimal Places—only used for unit accounts

FXDORVAR

i4

2

N

0

Fixed or variable allocation:

1=Fixed;

2=Variable

BALFRCLC

i4

2

N

0

Based on flag:

0=Year to date;

1=Transaction period

USERDEF1

string

20

N

<blank>

User defined 1

USERDEF2

string

20

N

<blank>

User defined 2

PostSlsIn

i4

2

N

1

Post sales in:

1=Detail;

2=Summary

PostIvIn

i4

2

N

1

Post inventory in:

1=Detail;

2=Summary

PostPurchIn

i4

2

N

1

Post purchasing in:

1=Detail;

2=Summary

PostPRIn

i4

2

N

1

Post payroll in:

1=Detail;

2=Summary

ACCTENTR

i4

1

N

1

Allow account entry:

0=False;

1=True

USRDEFS1

string

30

N

<blank>

User defined string 1

USRDEFS2

string

30

N

<blank>

User defined string 2

UpdateIfExists

i4

1

N

1

Flag to update account data if it exists:

0=No;

1=Yes

NOTETEXT

string

8000

N

<blank>

Notes field

DSPLKUPSSALES

i4

1

N

1

Include in Lookup for Sales:

0=False;

1=True

Valid for ACCTTYPE values of 1, 2, 3, and 4.

DSPLKUPSIV

i4

1

N

1

Include in Lookup for Inventory Control:

0=False;

1=True

Valid for ACCTTYPE values of 1, 3, and 4.

DSPLKUPSPURCH

i4

1

N

1

Include in Lookup for Purchasing:

0=False;

1=True

Valid for ACCTTYPE values of 1, 2, 3, and 4.

DSPLKUPSPR

i4

1

N

1

Include in Lookup for Payroll:

0=False;

1=True

Valid for ACCTTYPE values of 1, 3, and 4.

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates the requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only