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.
The column
headings in the table include the following.
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
ORDERNO
|
Numeric
|
8
|
0
|
Order number to which this entry belongs.
|
|
2
|
INPART
|
Character
|
1
|
N/A
|
Invoice part code to which this entry
|
|
3
|
ACCT
|
Character
|
2
|
N/A
|
Two character ID establishing the G/L category
|
|
4
|
GL_DEPT
|
Character
|
2
|
N/A
|
Two character ID establishing the G/L sub-account.
|
|
5
|
PAYMETHOD
|
Character
|
2
|
N/A
|
Method of payment (when applicable).
|
|
6
|
CARDTYPE
|
Character
|
2
|
N/A
|
Card type (when applicable).
|
|
7
|
PAYMENT
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
8
|
CHARGE
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
9
|
ODR_DATE
|
Datetime
|
8
|
N/A
|
Date of transaction.
|
|
10
|
NOTATION
|
Character
|
25
|
N/A
|
Description of transaction.
|
|
11
|
AMOUNT
|
Numeric
|
10
|
2
|
Amount of transaction.
|
|
12
|
USERID
|
Character
|
3
|
N/A
|
Operator ID.
|
|
13
|
POSTED
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
14
|
REPORTED
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
15
|
CHECKNUM
|
Character
|
20
|
N/A
|
Check number which.
|
|
16
|
TRANS_ID
|
Numeric
|
10
|
0
|
Transaction number.
|
|
17
|
POPENTRY
|
Logical
|
1
|
N/A
|
Indicates a POP order.
|
|
18
|
DISC_TAKEN
|
Numeric
|
10
|
2
|
Discount taken for transaction.
|
|
19
|
PAYSCHEDID
|
Numeric
|
10
|
0
|
RESERVED.
|
|
20
|
GL_ACCT
|
Character
|
2
|
N/A
|
Two character ID establishing the G/L account.
|
|
21
|
PARTPRINT
|
Character
|
1
|
N/A
|
Invoice part code this transaction was printed on.
|
|
22
|
POSTDATE
|
Datetime
|
8
|
N/A
|
Date and time that the entry was posted.
|
|
23
|
JOURNAL_ID
|
Integer
(Auto Increment)
|
4
|
N/A
|
RESERVED.
|
|
24
|
POPBATCHID
|
Numeric
|
12
|
0
|
RESERVED.
|
