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 such as:

<?xml version="1.0" encoding="UTF-8"?>

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

<pdp_file xmlns=http://www.kuali.org/kfs/pdp/payment

xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance

xsi:schemaLocation=http://www.kuali.org/kfs/pdp/payment http://localhost:8080/kuali-dev/static/xsd/pdp/payment.xsd

version="1.0">

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> specifying the total detail count and amount in the file.

PDP Payment Upload Formats:

Name

Type

Max Size

Required?

Special Formatting

Header

<chart>

Characters

2

Yes

<unit>

Characters

4

Yes

<sub_unit>

Characters

4

Yes

Group

<payee_name>

Characters

40

Yes

<payee_id id_type= X>

Characters

25

No

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

<payee_own_cd>

Characters

2

No

<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

No

Y or N

<nra_ind>

Characters

1

No

Y or N

<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

Trailer

<detail_count>

Integer

Yes

<detail_tot_amt>

Decimal

Yes

Money format (2 decimal places)

More:

Format Summary