File Structure - A/R Journal
File Name:
JOURNAL
File
Contents: Contains the detail for all payments and charges
associated with each customer order in the system. This table is
used for accounting reporting functions and for interfacing to G/L
packages.
Table Legend
The column
headings in the table include the following.
-
Position - The ordinal
position of the field in the table.
-
Field Name - The column
name used in programming the information transferred. It serves to
classify data kept in this field.
-
Type - Can be one of 6
types:
Char - Text type data
Text- a field with a large character limit.
Numeric - numbers
Int- a whole number
Datetime - a date
Bit- a logical
field. 0=False, 1=True
-
Character Length- For
character fields only. The maximum number of character that the
field element can occupy.
-
Numeric Precision - For
numeric fields only. The maximum length for a numeric value before
the radix point.
-
Numeric Scale- For
numeric fields only. The maximum length for a decimal value after
the radix point.
-
Description of Field - A
definition of the field's contents. RESERVED signifies for M.O.M.
use only. FUTURE USE signifies that the field may be used in a
future release. UK Only signifies a field used for the UK edition
of M.O.M.
|
POSITION
|
FIELD NAME
|
TYPE
|
CHARACTER LENGTH
|
NUMERIC PRECISION
|
NUMERIC SCALE
|
DESCRIPTION
|
|
1
|
ORDERNO
|
Numeric
|
N/A
|
10
|
0
|
Order number to which this entry belongs.
|
|
2
|
INPART
|
Char
|
1
|
N/A
|
N/A
|
Invoice part code to which this entry
|
|
3
|
ACCT
|
Char
|
2
|
N/A
|
N/A
|
Two character ID establishing the G/L category
|
|
4
|
GL_DEPT
|
Char
|
2
|
N/A
|
N/A
|
Two character ID establishing the G/L sub-account.
|
|
5
|
PAYMETHOD
|
Char
|
2
|
N/A
|
N/A
|
Method of payment (when applicable).
|
|
6
|
CARDTYPE
|
Char
|
2
|
N/A
|
N/A
|
Card type (when applicable).
|
|
7
|
PAYMENT
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
8
|
CHARGE
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
9
|
ODR_DATE
|
Date
|
N/A
|
23
|
3
|
Date of transaction.
|
|
10
|
NOTATION
|
Char
|
25
|
N/A
|
N/A
|
Description of transaction.
|
|
11
|
AMOUNT
|
Numeric
|
N/A
|
10
|
2
|
Amount of transaction.
|
|
12
|
USERID
|
Char
|
3
|
N/A
|
N/A
|
Operator ID.
|
|
13
|
POSTED
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
14
|
REPORTED
|
Bit
|
N/A
|
1
|
0
|
RESERVED.
|
|
15
|
CHECKNUM
|
Char
|
20
|
N/A
|
N/A
|
Check number which.
|
|
16
|
TRANS_ID
|
Numeric
|
N/A
|
12
|
0
|
Transaction number.
|
|
17
|
POPENTRY
|
Bit
|
N/A
|
1
|
0
|
Indicates a POP order.
|
|
18
|
DISC_TAKEN
|
Numeric
|
N/A
|
10
|
2
|
Discount taken for transaction.
|
|
19
|
PAYSCHEDID
|
Numeric
|
N/A
|
10
|
0
|
RESERVED.
|
|
20
|
GL_ACCT
|
Char
|
2
|
N/A
|
N/A
|
Two character ID establishing the G/L account.
|
|
21
|
PARTPRINT
|
Char
|
1
|
N/A
|
N/A
|
Invoice part code this transaction was printed on.
|
|
22
|
POSTDATE
|
Datetime
|
N/A
|
23
|
3
|
Date and time that the entry was posted.
|
|
23
|
JOURNAL_ID
|
Numeric
|
N/A
|
12
|
0
|
RESERVED.
|
|
24
|
POPBATCHID
|
Numeric
|
N/A
|
12
|
0
|
RESERVED.
|
|
