PDP Spreadsheet Upload File Format

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:

Payment Spreadsheet Sample File Layout