Field
Name: |
Type: |
Length: |
Index: |
Description: |
JE_SEQ |
sequence |
|
x |
sequence # |
JE_DATE |
short date |
1980.2079 |
x |
entry date from invoice,
check, etc. |
JE_REF |
char |
15 |
x |
invoice, check, payment number |
JE_POSTED |
short date |
1980..2079 |
x |
date posted into G/L |
JE_DESC |
char |
2000 |
|
description |
JE_DEBIT |
number |
2dp |
|
debit amount |
JE_CREDIT |
number |
2dp |
|
credit amount |
JE_AC_NUM |
short num |
2dp |
x |
account number |
JE_PERIOD |
short num |
0dp |
x |
accounting period |
JE_JOB_NUM |
char |
10 |
x |
job number |
JE_CLIENT_NUM |
char |
10 |
x |
client number |
JE_RECONCILE |
short num |
2dp |
x |
key for bank reconciliation
(100000=not cleared) |
JE_SOURCE |
short int |
(0 to 255) |
x |
source (0=General/1=AP/2=AR/3=CK/4=PMT) |
JE_ADDED_BY |
char |
4 |
|
who added this? |
JE_ADDED_WHEN |
date & time |
(#FDT) |
|
when was this JE added? |
JE_VENDOR_NUM |
char |
10 |
x |
vendor number |
JE_AUTO_REV |
short int |
(0 to 255) |
|
auto-reverse? |
JE_AUTO_ACC |
short int |
(0 to
255) |
|
auto-accrural JE? |
JE_TEMP_REC |
short int |
(0 to 255) |
|
temporarily reconciled? |
JE_KIND |
short int |
(0 to 255) |
|
0=user/1=auto-rev/2=WIP/3=recurring
4=adjusting/5=clearing |
JE_PAY_BATCH |
char |
10 |
|
Batch ID for client payments |
JE_GL_REC |
short int |
(0 to
255) |
|
G/L reconciliation
- period |
JE_EXPORTED |
short date |
1980..2079 |
|
date exported (for SQL only) |