GL Database

The following describes the fields in the GL (Journal Entries) database.

Field Contents Description

AC_NO

40 characters right aligned

Account number

ACCOUNTS

1 character

Account type (Financial, Cash Flow, Performance) (blank, S, or P)

ACT_TYPE

1 character

Tax entry or not (blank or T)

B_ACT

40 characters

Balancing account

B_DIV

6 characters

Not used

B_ENT

40 characters

Balancing entity

B_SUB

6 characters

Not used

BUCKET

1 character

Period Date Sequence for Adjusting entry

CREATEDON

14 characters

For internal purposes only. Marks date and time record was created.

CUR_MTH

19 digits and 2 decimal places

Balance for current month (amount before taxes)

CWDATE

14 characters

For internal purposes only. Marks date and time of database changes.

CWGUID

22 characters

For internal purposes only. Unique identifier, created when the record is appended.

DATE

8 characters

Date

DESC_NOTE

40 characters

Note for description

DIV

6 characters

Not used

DTYPE

1 character

Internal (always G)

ENTITY

40 characters left aligned

Entity designation

ERROR

2 character

Not used

EXINFO

10 characters

For internal purposes only. Memo used for reports

FROM_REF

12 characters

Reference

ITEMGUID

22

-

JE_DESC

35 characters

Journal entry description

JOURSOURSE

2 characters

Journal type (e.g. GJ, CD, CR)

KEY

10 characters

Internal (link to tax record)

LINK2GUID

22

-

LINKGUID

22

-

MEMO_NO

2 characters

Not used

NET

19 digits and 2 decimal places

Total amount (after taxes)

OPT

62 characters

Internal (optimization field)

OVERRIDE

1

-

PAY_TAX

22

-

PER

2 characters

Period (1-13)

REC

1 character

Recurring status

RECURKEY

10 characters

Internal (link to recurring entries)

RECURRING

1 character

Recurring or reversing (blank, R, or V)

REFNO

20 characters

Journal entry number

REV_CODE

2 characters

Not used

RF

3 characters

Not used

SPLIT

1

-

STATUS

1 character

Adjusting entry type (Normal, Reclass, etc.)

SUB

6 characters

Not used

TAX

19 digits and 2 decimal places

Tax amount

TAX_ID

4 characters

Tax code ID

USER

20 characters

ID of user who created the adjusting journal entry.