|
1.*
|
Transaction Number
|
PSPMTRNUM
|
Numeric
|
5
|
R:1-99999
|
|
2.
|
Customer Number
|
PSPMNUM
|
CharCaps
|
20
|
|
|
3.
|
Customer Name
|
PSPMNAME
|
Character
|
35
|
|
|
4.
|
Customer Address 1
|
PSPMADD1
|
Character
|
35
|
|
|
5.
|
Customer Address 2
|
PSPMADD2
|
Character
|
35
|
|
|
6.
|
Customer City
|
PSPMCITY
|
Character
|
20
|
|
|
7.
|
Customer State
|
PSPMSTATE
|
CharCaps
|
2
|
|
|
8.
|
Customer Zip
|
PSPMZIP
|
Character
|
30
|
|
|
9.
|
Invoice Number
|
PSPMINVNO
|
CharCaps
|
15
|
|
|
10.
|
Purchase Order Number
|
PSPMPONUM
|
CharCaps
|
20
|
|
|
11.
|
Miscellaneous 1
|
PSPMMISC1
|
Character
|
20
|
|
|
12.
|
Miscellaneous 2
|
PSPMMISC2
|
Character
|
20
|
|
|
13.~
|
Sales Category Code
|
PSPMCODE
|
CharCaps
|
2
|
|
|
14.~
|
Salesperson Code
|
PSPMSPC
|
CharCaps
|
3
|
|
|
15.~
|
Sales Tax Code
|
PSPMTXCD
|
CharCaps
|
6
|
|
|
16.~
|
Terms Code
|
PSPMTERM
|
CharCaps
|
2
|
|
|
17.
|
Discount Code
|
PSPMDSCD
|
CharCaps
|
2
|
|
|
18.~
|
Credit Card Code
|
PSPMCRCD
|
CharCaps
|
4
|
|
|
19.*~
|
Register Code
|
PSPMRGCD
|
CharCaps
|
3
|
|
|
20.
|
Check Number
|
PSPMCKNO
|
CharCaps
|
15
|
|
|
21.
|
License Number
|
PSPMLINO
|
CharCaps
|
15
|
|
|
22.
|
Check Authorization
|
PSPMCKAU
|
Character
|
20
|
|
|
23.
|
Check Account Number
|
PSPMCKAC
|
CharCaps
|
20
|
|
|
24.
|
Credit Card Number
|
PSPMCRNO
|
CharCaps
|
20
|
|
|
25.
|
Credit Card Authorization
|
PSPMCRAU
|
Character
|
15
|
|
|
26.
|
Expiration Date
|
PSPMCREX
|
CharCaps
|
5
|
|
|
27.
|
Default (Header) Tax Code
|
PSPMTXCDH
|
CharCaps
|
6
|
|
|
28.
|
Price Level Code
|
PSPMPRCD
|
CharCaps
|
4
|
|
|
29.*
|
Total # Details Lines
|
PSPMNODT
|
Numeric
|
3
|
R:0-999
|
|
30.
|
Posting Status Flag
|
PSPMSTATUS
|
Numeric
|
3
|
R:0-255
|
|
31.
|
On-Hold Flag
|
PSPMHOLD
|
Numeric
|
1
|
|
|
32.
|
Credit Card Authorization Flag
|
PSPMCRFL
|
Numeric
|
1
|
R:0-9
|
|
33.*
|
Tran Type 1=Normal, 2=Layaway, 3=Paid Out, VOID = add 10 to the tran type
|
PSPMTYPE
|
Numeric
|
2
|
R:1-19 as defined
|
|
34.
|
Layaway Flag 1
|
PSPMLYF1
|
Numeric
|
1
|
|
|
35.
|
Layaway Flag 2
|
PSPMLYF2
|
Numeric
|
1
|
|
|
36.
|
Layaway Flag 3
|
PSPMLYF3
|
Numeric
|
1
|
|
|
37.
|
Layaway Flag 4
|
PSPMLYF4
|
Numeric
|
1
|
|
|
38.*~
|
Transaction Date
|
PSPMDATE
|
Date
|
|
R:block->fiscal end
|
|
39.
|
Transaction Time
|
PSPMTIME
|
Character
|
11
|
R: (xx:xx:xx xM)
|
|
40.
|
Layaway Date
|
PSPMLYDT
|
Date
|
|
R:0 & any date
|
|
41.
|
Transaction Total
|
PSPMTOT
|
Numeric
|
15
|
(11.2) R:+/-
|
|
42.
|
Cash Amount
|
PSPMCAAM
|
Numeric
|
15
|
(11.2) R:+/-
|
|
43.
|
Check Amount
|
PSPMCKAM
|
Numeric
|
15
|
(11.2) R:+/-
|
|
44.
|
Credit Card Amount
|
PSPMCRAM
|
Numeric
|
15
|
(11.2) R:+/-
|
|
45.
|
Charge Amount
|
PSPMCHAM
|
Numeric
|
15
|
(11.2) R:+/-
|
|
46.
|
Payment on Account (- Paid Out)
|
PSPMPOA
|
Numeric
|
15
|
(11.2) R:+/-
|
|
47.
|
Unused
|
PSPMREF
|
CharCaps
|
10
|
|
|
48.
|
Taxable Amount Total
|
PSPMTXAM
|
Numeric
|
15
|
(11.2) R:+/-
|
|
49.
|
Total Tax
|
PSPMTAX
|
Numeric
|
15
|
(11.2) R:+/-
|
|
50.
|
Change
|
PSPMCHNG
|
Numeric
|
15
|
(11.2) R:+/-
|
|
51.
|
Total Payment
|
PSPMTOTPY
|
Numeric
|
15
|
(11.2) R:+/-
|
|
52.
|
Layaway Deposit
|
PSPMLYDP
|
Numeric
|
15
|
(11.2) R:+/-
|
|
53.
|
Credit Card Track 1
|
PSPMTRK1
|
Character
|
240
|
|
|
54.
|
Credit Card Track 2
|
PSPMTRK2
|
Character
|
240
|
|
|
55.
|
Alt. Tender Register Balance
|
PSPMALT1
|
Numeric
|
15
|
(11.2) R:+/-
|
|
56.
|
Alt. Tender Non-Register Balance
|
PSPMALT2
|
Numeric
|
15
|
(11.2) R:+/-
|
|
57.
|
Customer Type
|
PSPMCTYPE
|
CharCaps
|
2
|
|
|
58.
|
Sales Tax Code 0
|
PSPMTAXC0
|
CharCaps
|
6
|
|
|
59.
|
Sales Tax Code 1
|
PSPMTAXC1
|
CharCaps
|
6
|
|
|
60.
|
Sales Tax Code 2
|
PSPMTAXC2
|
CharCaps
|
6
|
|
|
61.
|
Sales Tax Code 3
|
PSPMTAXC3
|
CharCaps
|
6
|
|
|
62.
|
Sales Tax Code 4
|
PSPMTAXC4
|
CharCaps
|
6
|
|
|
63.
|
Taxable Amt for Code 0
|
PSPMTAXBL0
|
Numeric
|
15
|
(11.2) R:+/-
|
|
64.
|
Taxable Amt for Code 1
|
PSPMTAXBL1
|
Numeric
|
15
|
(11.2) R:+/-
|
|
65.
|
Taxable Amt for Code 2
|
PSPMTAXBL2
|
Numeric
|
15
|
(11.2) R:+/-
|
|
66.
|
Taxable Amt for Code 3
|
PSPMTAXBL3
|
Numeric
|
15
|
(11.2) R:+/-
|
|
67.
|
Taxable Amt for Code 4
|
PSPMTAXBL4
|
Numeric
|
15
|
(11.2) R:+/-
|
|
68.
|
Taxable Amt for 1st Code xx0
|
PSPMTAXV00
|
Numeric
|
12
|
(8.2) R:+/-
|
|
69.
|
Taxable Amt for 1st Code xx1
|
PSPMTAXV01
|
Numeric
|
12
|
(8.2) R:+/-
|
|
70.
|
Taxable Amt for 1st Code xx2
|
PSPMTAXV02
|
Numeric
|
12
|
(8.2) R:+/-
|
|
71.
|
Taxable Amt for 1st Code xx3
|
PSPMTAXV03
|
Numeric
|
12
|
(8.2) R:+/-
|
|
72.
|
Taxable Amt for 1st Code xx4
|
PSPMTAXV04
|
Numeric
|
12
|
(8.2) R:+/-
|
|
73.
|
Taxable Amt for 1st Code xx5
|
PSPMTAXV05
|
Numeric
|
12
|
(8.2) R:+/-
|
|
74.
|
Taxable Amt for 1st Code xx6
|
PSPMTAXV06
|
Numeric
|
12
|
(8.2) R:+/-
|
|
75.
|
Taxable Amt for 1st Code xx7
|
PSPMTAXV07
|
Numeric
|
12
|
(8.2) R:+/-
|
|
76.
|
Taxable Amt for 1st Code xx8
|
PSPMTAXV08
|
Numeric
|
12
|
(8.2) R:+/-
|
|
77.
|
Taxable Amt for 1st Code xx9
|
PSPMTAXV09
|
Numeric
|
12
|
(8.2) R:+/-
|
|
78.
|
Taxable Amt for 2nd Code xx0
|
PSPMTAXV10
|
Numeric
|
12
|
(8.2) R:+/-
|
|
79.
|
Taxable Amt for 2nd Code xx1
|
PSPMTAXV11
|
Numeric
|
12
|
(8.2) R:+/-
|
|
80.
|
Taxable Amt for 2nd Code xx2
|
PSPMTAXV12
|
Numeric
|
12
|
(8.2) R:+/-
|
|
81.
|
Taxable Amt for 2nd Code xx3
|
PSPMTAXV13
|
Numeric
|
12
|
(8.2) R:+/-
|
|
82.
|
Taxable Amt for 2nd Code xx4
|
PSPMTAXV14
|
Numeric
|
12
|
(8.2) R:+/-
|
|
83.
|
Taxable Amt for 2nd Code xx5
|
PSPMTAXV15
|
Numeric
|
12
|
(8.2) R:+/-
|
|
84.
|
Taxable Amt for 2nd Code xx6
|
PSPMTAXV16
|
Numeric
|
12
|
(8.2) R:+/-
|
|
85.
|
Taxable Amt for 2nd Code xx7
|
PSPMTAXV17
|
Numeric
|
12
|
(8.2) R:+/-
|
|
86.
|
Taxable Amt for 2nd Code xx8
|
PSPMTAXV18
|
Numeric
|
12
|
(8.2) R:+/-
|
|
87.
|
Taxable Amt for 2nd Code xx9
|
PSPMTAXV19
|
Numeric
|
12
|
(8.2) R:+/-
|
|
88.
|
Taxable Amt for 3rd Code xx0
|
PSPMTAXV20
|
Numeric
|
12
|
(8.2) R:+/-
|
|
89.
|
Taxable Amt for 3rd Code xx1
|
PSPMTAXV21
|
Numeric
|
12
|
(8.2) R:+/-
|
|
90.
|
Taxable Amt for 3rd Code xx2
|
PSPMTAXV22
|
Numeric
|
12
|
(8.2) R:+/-
|
|
91.
|
Taxable Amt for 3rd Code xx3
|
PSPMTAXV23
|
Numeric
|
12
|
(8.2) R:+/-
|
|
92.
|
Taxable Amt for 3rd Code xx4
|
PSPMTAXV24
|
Numeric
|
12
|
(8.2) R:+/-
|
|
93.
|
Taxable Amt for 3rd Code xx5
|
PSPMTAXV25
|
Numeric
|
12
|
(8.2) R:+/-
|
|
94.
|
Taxable Amt for 3rd Code xx6
|
PSPMTAXV26
|
Numeric
|
12
|
(8.2) R:+/-
|
|
95.
|
Taxable Amt for 3rd Code xx7
|
PSPMTAXV27
|
Numeric
|
12
|
(8.2) R:+/-
|
|
96.
|
Taxable Amt for 3rd Code xx8
|
PSPMTAXV28
|
Numeric
|
12
|
(8.2) R:+/-
|
|
97.
|
Taxable Amt for 3rd Code xx9
|
PSPMTAXV29
|
Numeric
|
12
|
(8.2) R:+/-
|
|
98.
|
Taxable Amt for 4th Code xx0
|
PSPMTAXV30
|
Numeric
|
12
|
(8.2) R:+/-
|
|
99.
|
Taxable Amt for 4th Code xx1
|
PSPMTAXV31
|
Numeric
|
12
|
(8.2) R:+/-
|
|
100.
|
Taxable Amt for 4th Code xx2
|
PSPMTAXV32
|
Numeric
|
12
|
(8.2) R:+/-
|
|
101.
|
Taxable Amt for 4th Code xx3
|
PSPMTAXV33
|
Numeric
|
12
|
(8.2) R:+/-
|
|
102.
|
Taxable Amt for 4th Code xx4
|
PSPMTAXV34
|
Numeric
|
12
|
(8.2) R:+/-
|
|
103.
|
Taxable Amt for 4th Code xx5
|
PSPMTAXV35
|
Numeric
|
12
|
(8.2) R:+/-
|
|
104.
|
Taxable Amt for 4th Code xx6
|
PSPMTAXV36
|
Numeric
|
12
|
(8.2) R:+/-
|
|
105.
|
Taxable Amt for 4th Code xx7
|
PSPMTAXV37
|
Numeric
|
12
|
(8.2) R:+/-
|
|
106.
|
Taxable Amt for 4th Code xx8
|
PSPMTAXV38
|
Numeric
|
12
|
(8.2) R:+/-
|
|
107.
|
Taxable Amt for 4th Code xx9
|
PSPMTAXV39
|
Numeric
|
12
|
(8.2) R:+/-
|
|
108.
|
Taxable Amt for 5th Code xx0
|
PSPMTAXV40
|
Numeric
|
12
|
(8.2) R:+/-
|
|
109.
|
Taxable Amt for 5th Code xx1
|
PSPMTAXV41
|
Numeric
|
12
|
(8.2) R:+/-
|
|
110.
|
Taxable Amt for 5th Code xx2
|
PSPMTAXV42
|
Numeric
|
12
|
(8.2) R:+/-
|
|
111.
|
Taxable Amt for 5th Code xx3
|
PSPMTAXV43
|
Numeric
|
12
|
(8.2) R:+/-
|
|
112.
|
Taxable Amt for 5th Code xx4
|
PSPMTAXV44
|
Numeric
|
12
|
(8.2) R:+/-
|
|
113.
|
Taxable Amt for 5th Code xx5
|
PSPMTAXV45
|
Numeric
|
12
|
(8.2) R:+/-
|
|
114.
|
Taxable Amt for 5th Code xx6
|
PSPMTAXV46
|
Numeric
|
12
|
(8.2) R:+/-
|
|
115.
|
Taxable Amt for 5th Code xx7
|
PSPMTAXV47
|
Numeric
|
12
|
(8.2) R:+/-
|
|
116.
|
Taxable Amt for 5th Code xx8
|
PSPMTAXV48
|
Numeric
|
12
|
(8.2) R:+/-
|
|
117.
|
Taxable Amt for 5th Code xx9
|
PSPMTAXV49
|
Numeric
|
12
|
(8.2) R:+/-
|
|
118.
|
Amount remaining to Process to AR
|
PSPMREMAIN
|
Numeric
|
15
|
(11.2) R:+/-
|
|
119.
|
Early Payment Discounts Applied
|
PSPMDISCAP
|
Numeric
|
15
|
(11.2) R:+/-
|
|
120.
|
Unique number used in PSHIS
|
PSPMUNIQUE
|
Numeric
|
10
|
R:0->+
|
|
121.
|
Credit Card Address
|
PSPMCRAD
|
Character
|
20
|
|
|
122.
|
Credit Card Zip Code
|
PSPMCRZP
|
Character
|
9
|
|
|
123.
|
Check Routing Number
|
PSPMCKRN
|
Character
|
9
|
|
|
124.
|
Customer Phone #
|
PSPMPHN
|
Character
|
12
|
|
|
125.
|
Customer Fax #
|
PSPMFAX
|
Character
|
12
|
|
|
126.
|
Terms Code Desc (Unused)
|
PSPMTRMDES
|
Character
|
30
|
|
|
127.
|
Date of Birth
|
PSPMDOB
|
Date
|
|
|
|
128.
|
UDF 1
|
PSPMUDF1
|
Character
|
30
|
|
|
129.
|
UDF 2
|
PSPMUDF2
|
Character
|
30
|
|
|
130.
|
UDF 3
|
PSPMUDF3
|
Numeric
|
15
|
(9.4) R:+/-
|
|
131.
|
UDF 4
|
PSPMUDF4
|
Numeric
|
15
|
(9.4) R:+/-
|
|
132.
|
UDF 5
|
PSPMUDF5
|
Date
|
|
|
|
133.
|
Credit Card PCCharge TransNum
|
PSPMCCPCTN
|
Character
|
10
|
|
|
134.
|
Is PCCharge Debit Card Authorization
|
PSPMDEBIT
|
Numeric
|
1
|
|
|
135.
|
Credit Card Number Storage
|
PSPMSTORG
|
Character
|
96
|
|
|
136.
|
Is a Scanned Electronic Check 0=not a scanned check, 1=scanned check not in a generated file, 2=scanned check already in a generated file
|
PSPMCKSCAN
|
Numeric
|
1
|
R:0-2
|
|
137.
|
Front Scan Check Image File Name
|
PSPMFRTIMG
|
Character
|
64
|
|
|
138.
|
Back Scan Check Image File Name
|
PSPMBCKIMG
|
Character
|
64
|
|
|
139.
|
Scan Check Raw MICR Line
|
PSPMMICRLN
|
Character
|
128
|
|
|
140.*
|
Application User ID
|
PSPMUSERID
|
CharCaps
|
3
|
|
|
141.*
|
Transaction Batch Description
|
PSPMBATNUM
|
CharCaps
|
15
|
|