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 Format
|
Name |
Type |
Max Size |
Required? |
Special Formatting | ||
|
Header | ||||||
|
<chart> |
Characters |
2 |
Yes |
| ||
|
<unit> |
Characters |
4 |
Yes |
| ||
|
<sub_unit> |
Characters |
4 |
Yes |
| ||
| ||||||
|
<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) | |
Format Summary