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 PDP 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.
- An empty .done file of the same name must also be created when the file will be loaded into the staging/pdp/paymentImport directory via S3 buckets.
PDP Payment Upload Format - sample file below
Name |
Type |
Max Size |
Required? |
Notes |
|
Header |
|||||
Campus |
Characters |
2 |
Yes |
|
|
Unit |
Characters |
4 |
Yes |
|
|
sub_unit |
Characters |
4 |
Yes |
|
|
|
|||||
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 |
|
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 |
|
immediate_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 |
|
nonresident_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 |
|
|
fdoc_typ_cd |
Characters |
4 |
No |
|
|
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) |
|
payment_text |
Characters |
90 |
No |
Can be multiple and must follow the Accounting tag |
|
Trailer |
|
|
|
|
|
detail_count |
Integer |
|
Yes |
|
|
detail_tot_amt |
Decimal |
|
Yes |
Money format (2 decimal places) |
Sample File .xml
<?xml version="1.0" encoding="UTF-8"?>
<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">
<header>
<campus>BL</campus>
<unit>LIBM</unit>
<sub_unit>RAFT</sub_unit>
<creation_date>12/13/2019 12:11 PM</creation_date>
</header>
<group>
<payee_name>Accounting Consultants</payee_name>
<payee_id id_type="V">2005-0</payee_id>
<payee_own_cd>CF</payee_own_cd>
<address1>U.S. GOVERNMENT PRINTING OFFICE</address1>
<address2>APARTMENT 1413</address2>
<city>OMAHA</city>
<state>NE</state>
<zip>681030546</zip>
<country>US</country>
<campus_address_ind>N</campus_address_ind>
<payment_date>05/03/07</payment_date>
<attachment_ind>N</attachment_ind>
<immediate_ind>N</immediate_ind>
<special_handling_ind>N</special_handling_ind>
<taxable_ind>N</taxable_ind>
<nonresident_ind>N</nonresident_ind>
<bank_code>TEST</bank_code>
<detail>
<source_doc_nbr>B123456</source_doc_nbr>
<invoice_nbr>234</invoice_nbr>
<po_nbr></po_nbr>
<req_nbr></req_nbr>
<org_doc_nbr></org_doc_nbr>
<net_payment_amt>126.00</net_payment_amt>
<fs_origin_cd>01</fs_origin_cd>
<fdoc_typ_cd>DV</fdoc_typ_cd>
<accounting>
<coa_cd>BL</coa_cd>
<account_nbr>1031400</account_nbr>
<sub_account_nbr></sub_account_nbr>
<object_cd>5000</object_cd>
<sub_object_cd></sub_object_cd>
<org_ref_id></org_ref_id>
<project_cd></project_cd>
<amount> 126.00</amount>
</accounting>
<payment_text>Note Text</payment_text>
</detail>
</group>
<trailer>
<detail_count>1</detail_count>
<detail_tot_amt>126.00</detail_tot_amt>
</trailer>
</pdp_file>
Comments
0 comments
Please sign in to leave a comment.