|
OE Deposit Journal File: xxxOEDEP.DBF
|
Tag
|
Index
|
|
OEDPNUM
|
UPPER(OEDPNUM) + UPPER(OEDPINVNO) + STR(OEDPUNIQ)
|
|
OEDPINVNO
|
UPPER(OEDPINVNO) + UPPER(OEDPNUM) + STR(OEDPUNIQ)
|
|
OEDPDATE
|
UPPER(OEDPNUM) + UPPER(OEDPINVNO) + DTOS(OEDPDATE) + STR(OEDPUNIQ)
|
|
OEDPTYPE
|
STR(OEDPTYPE) + UPPER(OEDPNUM) + UPPER(OEDPINVNO) + STR(OEDPUNIQ)
|
|
OEDPNUM2
|
UPPER(OEDPNUM) + UPPER(OEDPINVNO) + STR(OEDPUNIQ)
|
|
OEDPSTATUS
|
STR(OEDPSTATUS,1,0)
|
|
##
|
Desc
|
Name
|
Type
|
Size
|
Condition
|
|
1.*
|
Customer Number
|
OEDPNUM
|
CharCaps
|
20
|
|
|
2.*
|
Work Order or Invoice#
|
OEDPINVNO
|
Character
|
15
|
|
|
3.
|
Date of Original Work Order
|
OEDPDATE
|
Date
|
|
R:block->fiscal end
|
|
4.
|
Status of Deposit
0=Deposit received not posted, 1=Deposit received posted, 2=Deposit completed, 3=Deposit refunded not posted, 4=Deposit refunded posted, 5=Deposit refunded completed
|
OEDPSTATUS
|
Numeric
|
1
|
R:0-5
|
|
5.
|
Amount
If OEDPSTATUS = 0, 1, or 2 then this is the amount of the deposit that can be refunded. Otherwise it's the total amount of the refund/deposit
|
OEDPAMOUNT
|
Numeric
|
15
|
(12.2) R:0->
|
|
6.
|
Tender
0=Cash, 1=Check, 2=Credit Card
|
OEDPPAY
|
Numeric
|
1
|
R:0-2
|
|
7.
|
Check Number
|
OEDPCKNO
|
CharCaps
|
15
|
|
|
8.
|
Check Account Number
|
OEDPCKAC
|
CharCaps
|
20
|
|
|
9.
|
Check Drivers License #
|
OEDPLINO
|
CharCaps
|
15
|
|
|
10.
|
Check Authorization
|
OEDPCKAU
|
Character
|
20
|
|
|
11.
|
Credit Card Code
|
OEDPCRCD
|
CharCaps
|
4
|
|
|
12.
|
Credit Card Number
|
OEDPCRNO
|
CharCaps
|
20
|
|
|
13.
|
Credit Card Expiration
|
OEDPCREX
|
CharCaps
|
5
|
|
|
14.
|
Credit Card Authorization
|
OEDPCRAU
|
Character
|
15
|
|
|
15.
|
Check/Credit Card Processed?
|
OEDPCPROC
|
Numeric
|
1
|
|
|
16.
|
Credit Card Track 1
|
OEDPTRK1
|
Character
|
240
|
|
|
17.
|
Credit Card Track 2
|
OEDPTRK2
|
Character
|
240
|
|
|
18.
|
Credit Card Address
|
OEDPCRADDR
|
Character
|
20
|
|
|
19.
|
Credit Card Zip
|
OEDPCRZIP
|
Character
|
9
|
Length of 0, 5, or 9
|
|
20.
|
Check Routing Number
|
OEDPCKRN
|
Character
|
9
|
|
|
21.
|
Unique Identifier
|
OEDPUNIQ
|
Numeric
|
3
|
|
|
22.
|
Verification code
|
OEDPCCVC
|
Character
|
4
|
|
|
23.
|
Type of Action
1 - Deposit, 2 - Refund
|
OEDPTYPE
|
Numeric
|
1
|
|
|
24.
|
Original Deposit Amount
|
OEDPDEPAMT
|
Numeric
|
15
|
|
|
25.
|
Credit Card PCCharge TransNum
|
OEDPCCPCTN
|
Character
|
10
|
|
|
26.
|
Credit Card Number Storage
|
OEDPSTORG
|
Character
|
96
|
|
| |
|
.jpg)
