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) |
More: