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. |
