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