For information on procedures and formatting rules that apply to all Kuali Financials batch uploads, see Batch Upload Basics.
Keep the following points in mind:
• The procurement card file must begin with the standard XML version line.
• The root (first) tag for PCDO files must be the procurementCardTransactions tag, and the file must contain only one procurementCardTransactions tag. This tag also contains attributes that identify the schema to which the document adheres.
• Following the procurementCardTransactions tag must be the transaction tag. This tag contains other identifier tags that describe a procurement card transaction.
• The sequence of transaction tags can repeat one or more times.
Procurement card format
Name |
Type |
Max Size |
Required? |
Special Formatting | |
Transaction | |||||
transactionCreditCardNumber |
Characters |
16 |
Yes |
| |
financialDocumentTotalAmount |
Decimal |
|
Yes |
Money format (2 decimal places) | |
|
Characters |
1 |
Yes |
Must have value D or C | |
|
Characters |
2 |
Yes |
| |
|
Characters |
7 |
Yes |
| |
|
Characters |
4 |
Yes |
| |
|
Characters |
3 |
No |
| |
|
Characters |
10 |
No |
| |
|
Date |
|
No |
YYYY-MM-DD format | |
|
Date |
|
No |
YYYY-MM-DD format | |
|
Characters |
35 |
No |
| |
|
Date |
|
Yes |
YYYY-MM-DD format | |
|
Characters |
21 |
No |
| |
|
Characters |
4 |
No |
| |
|
Date |
|
No |
YYYY-MM-DD format | |
|
Characters |
3 |
No |
| |
|
Characters |
3 |
No |
| |
|
Decimal |
|
No |
Money Format (2 decimal places) | |
|
Decimal |
|
No |
Money Format (2 decimal places) | |
|
Decimal |
|
No |
Money Format (2 decimal places) | |
|
Decimal |
|
No |
Money Format (2 decimal places) | |
|
Characters |
1 |
No |
Must have value Y or N | |
|
Characters |
1 |
No |
Must have value Y or N | |
|
Characters |
25 |
No |
| |
|
Characters |
35 |
No |
| |
|
Characters |
50 |
No |
| |
|
Characters |
25 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
2 |
No |
Must be 2 characters | |
|
Characters |
20 |
No |
| |
|
Characters |
12 |
No |
| |
|
Characters |
16 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
45 |
No |
| |
|
Characters |
2 |
No |
Must be 2 characters | |
|
Characters |
20 |
No |
| |
|
Characters |
10 |
No |
| |
|
Decimal |
|
No |
Money format (2 decimal places) | |
|
Decimal |
|
|
Money format (2 decimal places) | |
|
Decimal |
|
|
Money format (2 decimal places) | |
|
Characters |
2 |
No |
| |
|
Characters |
50 |
No |
|
More: