Credit Card Data Upload Format
In addition to the standard formatting rules that apply to all batch upload file formats, keep the following points in mind about the XML format:
• The file must begin with the standard XML version line such as:
<?xml version="1.0" encoding="UTF-8"?>
• The root (first) tag for collector files must be the <creditCardData> tag, and the file must contain only one <creditCardData></ creditCardData > tag. This tag also contains attributes that identify the schema the document adheres to, such as:
<creditCardData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.kuali.org/kfs/tem/CreditCardData"
xsi:noNamespaceSchemaLocation="../build/project/xsd/tem/CreditCardData.xsd">
• Following the batch tag must be the <importBy> tag. This section indicates how the imported transactions will be handled. By TRV prepares the record for manual reconciliation to a TEM document and By TRP prepares the record for automatic reconciliation. Like the creditCardData tag, the file must contain only one <importBy></importBy> tag.
• Next comes a <record> tag. This tag contains other tags that represent the fields of the credit card transaction. There can be many <record></record> tags back to back.
Agency Data Upload Format
|
Name |
Type |
Max Size |
Required? |
Special Formatting |
|
Air Number |
Character |
3 |
|
|
|
Billing Cycle Date |
Date |
10 |
|
YYYY-MM-DD |
|
Credit Card or Agency Code |
Char |
4 |
Y |
Must match value in Credit Card or Agency table. |
|
Creation Date |
Date |
10 |
|
YYYY-MM-DD |
|
Creation Timestamp |
Timestamp |
8 |
|
YYYY-MM-DD T HH:MM:SS (no spaces before and after the T) |
|
Credit Card Number |
Character |
16 |
Y |
|
|
Departure Date |
Date |
10 |
|
YYYY-MM-DD |
|
Identifier |
Char |
1 |
|
|
|
Reconciliation Date |
Date |
10 |
|
YYYY-MM-DD |
|
Reference Number (Transaction ID) |
Character |
23 |
|
Must be unique |
|
Sequence Number |
Character |
3 |
|
|
|
Ticket Number |
Character |
16 |
|
|
|
Transaction Amount |
Number |
15,4 |
|
Money format (four decimal places) |
|
Transaction Code |
Character |
1 |
|
|
|
Transaction Date |
Date |
10 |
|
YYYY-MM-DD |
|
Traveler Name |
Character |
40 |
|
|
|
Type Code |
Character |
1 |
|
|
|
Expense Type Code |
Character |
2 |
|
|
|
Merchant Name |
Character |
40 |
|
|
|
Bank Post Date |
Date |
10 |
|
YYYY-MM-DD |
|
Service Fee Number |
Character |
20 |
|
|
|
Itinerary Number |
Character |
20 |
|
|
|
Location |
Character |
20 |
|
|
Per Diem XML Batch
Upload