The default system provides a template - PDP_PaymentSpreadsheetUpload.csv
Following is the format and a sample file is shown below.
Required |
Data Element |
Sample Value |
|
|
|
|
|
Data Type |
Length min/max |
Yes |
Chart |
BL |
String |
2/2 |
Yes |
Unit |
KUAL |
String |
1/4 |
Yes |
Sub Unit |
DV |
String |
1/4 |
Yes |
Date |
7/21/2010 10:30 |
date and time |
(must be unique for each file or file with be viewed as a duplicate) |
Yes |
COA |
BL |
String |
1/2 |
Yes |
Account Number |
1024700 |
String |
8/8 |
No |
Sub Account |
|
String |
1/5 |
Yes |
Object Code |
5000 |
String |
4/4 |
No |
Sub Object Code |
|
String |
1/6 |
Yes |
Payee Name |
Black Tree Service |
String |
1/40 |
Yes |
Employee Or Vendor |
V |
String |
1/1 |
Yes |
Address line 1 |
102 Nest Lane |
String |
1/55 |
No |
Address line 2 |
|
String |
0/55 |
No |
Address Line 3 |
|
String |
0/55 |
Yes |
City |
East Lansing |
String |
1/45 |
No |
State |
MI |
String |
0/30 |
No |
Zip |
48823 |
String |
0/20 |
Yes |
Payment Date |
5/2/2013 |
Date |
MM/dd/yyyy |
Yes |
Source Doc |
777777 |
String |
1/14 |
No |
Check Stub Notes |
Payment or Service |
String |
0/90 |
Yes |
Amount |
10.25 |
Decimal |
|
Yes |
Payee Name |
Snicker, Sue |
String |
1/40 |
Yes |
Employee Or Vendor |
V |
String |
1/1 |
Yes |
Address line 1 |
101 Hill Street |
String |
1/55 |
No |
Address line 2 |
|
String |
0/55 |
No |
Address Line 3 |
|
String |
0/55 |
Yes |
City |
East Lansing |
String |
1/45 |
No |
State |
MI |
String |
0/30 |
No |
Zip |
48823 |
String |
0/20 |
Yes |
Payment Date |
05/02/2013 |
Date |
MM/dd/yyyy |
More: