PDP Payment Upload File Format

 

The following rules apply to formatting the PDP payment upload file:

    The upload file must begin with the standard XML version line.

    The root (first) tag for PCDO files must be the pdp_file tag, and the file must contain only one pdp_file tag. This tag also contains attributes that identify the schema to which the document adheres.

      Following the header will be one or more groups of payments identified by the group tag. Each group references a single payee and must also contain a detail section identifying the accounting distribution for that payment in one or more accounting tags.

      After the final group the file must end with a trailer tag specifying the total detail count and amount in the file.

      When nra_ind = Y or the payee is an employee, the payment will be held.

 

PDP Payment Upload Format

Name

Type

Max Size

Required?

Notes

Header

Chart

Characters

2

Yes

 

Unit

Characters

4

Yes

 

sub_unit

Characters

4

Yes

 

Group

payee_name

Characters

40

Yes

 

payee_id_type

Characters

25

No

Payee ID type (a single character)must be included within this tag

payee_own_cd

Characters

2

Yes/No

Customer Profile determines if this field is required

customer_institution_identifier

Characters

30

No

 

address1

Characters

55

Yes

 

address2

Characters

55

No

 

address3

Characters

55

No

 

address4

Characters

55

No

 

City

Characters

45

No

 

State

Characters

30

No

 

Zip

Characters

20

No

 

Country

Characters

30

No

 

campus_address_indicator

Characters

1

No

Y or N

payment_date

Date

10

No

MM/DD/YYYYY format

attachment_ind

Characters

1

No

Y or N

special_handling_ind

Characters

1

No

Y or N

taxable_ind

Characters

1

Yes/No

Valid values are Y or N

Customer Profile determines if this field is required

nra_ind

Characters

1

Yes/No

Valid values are Y or N

Customer Profile determines if this field is required

If the value is Y, then the payment will be held.

combine_group_ind

Characters

1

No

Y or N

bank_code

Characters

4

No

 

Detail

source_doc_nbr

Characters

14

Yes

 

invoice_nbr

Characters

14

No

 

po_nbr

Characters

9

No

 

req_nbr

Characters

8

No

 

org_doc_nbr

Characters

10

No

 

invoice_date

Date

10

No

MM/DD/YYYY format

orig_invoice_amt

Decimal

 

No

Money format (2 decimal places)

net_payment_amt

Decimal

 

No

Money format (2 decimal places)

invoice_tot_discount_amt

Decimal

 

No

Money format (2 decimal places)

invoice_tot_ship_amt

Decimal

 

No

Money format (2 decimal places)

invoice_tot_other_debits

Decimal

 

No

Money format (2 decimal places)

invoice_tot_other_credits

Decimal

 

No

Money format (2 decimal places)

fs_origin_cd

Characters

2

No

 

fdco_typ_cd

Characters

4

No

 

payment_text

Characters

90

No

Can contain multiples

Accounting

 

 

 

 

coa_cd

Characters

2

Yes

 

account_nbr

Characters

7

Yes

 

sub_account_nbr

Characters

5

No

 

object_cd

Characters

4

Yes

 

sub_object_cd

Characters

3

No

 

org_ref_id

Characters

8

No

 

project_cd

Characters

10

No

 

Amount

Decimal

 

Yes

Money format (2 decimal places)

Trailer

 

 

 

 

detail_count

Integer

 

Yes

 

detail_tot_amt

Decimal

 

Yes

Money format (2 decimal places)

More:

Payment Spreadsheet Upload