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 |
| |
| |||||
|
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) | |
Payment Spreadsheet
Upload