Procurement Card Upload Format

Note: For information on procedures and formatting rules that apply to all KFS batch uploads on the administration menu, 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 <transactions> tag, and the file must contain only one <transactions ></ transactions > tag. This tag also contains attributes that identify the schema the document adheres to, such as:

<transactions xmlns="http://www.kuali.org/kfs/fp/procurementCard"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

Following the transactions tag must be the <transaction> tag. This tag contains other identifier tags that describe a procurement card transaction.

The sequence of <transaction></transaction> can repeat one or more times.

Procurement card formats:

Name

Type

Max Size

Required?

Special Formatting

Transaction

<transactionCreditCardNumber>

Characters

16

Yes

<financialDocumentTotalAmount>

Decimal

Yes

Money format (2 decimal places)

< transactionDebitCreditCode>

Characters

1

Yes

Must have value D or C

< chartOfAccountsCode>

Characters

2

Yes

< accountNumber>

Characters

7

Yes

<financialObjectCode>

Characters

4

Yes

<financialSubObjectCode>

Characters

3

No

<projectCode>

Characters

10

No

<transactionCycleStartDate>

Date

No

YYYY-MM-DD format

< transactionCycleEndDate>

Date

No

YYYY-MM-DD format

< cardHolderName>

Characters

35

No

< transactionDate>

Date

Yes

YYYY-MM-DD format

< transactionReferenceNumber>

Characters

21

No

< transactionMerchantCategoryCode>

Characters

4

No

< transactionPostingDate>

Date

No

YYYY-MM-DD format

< transactionOriginalCurrencyCode>

Characters

3

No

< transactionBillingCurrencyCode>

Characters

3

No

< transactionOriginalCurrencyAmount>

Decimal

No

Money Format (2 decimal places)

< transactionCurrencyExchangeRate>

Decimal

No

Money Format (2 decimal places)

< transactionSettlementAmount>

Decimal

No

Money Format (2 decimal places)

< transactionSalesTaxAmount>

Decimal

No

Money Format (2 decimal places)

< transactionTaxExemptIndicator>

Characters

1

No

Must have value Y or N

< transactionPurchaseIdentifierIndicator>

Characters

1

No

Must have value Y or N

< transactionPurchaseIdentifierDescription>

Characters

25

No

< transactionUnitContactName>

Characters

35

No

< transactionTravelAuthorizationCode>

Characters

50

No

< transactionPointOfSaleCode>

Characters

25

No

< vendorName>

Characters

45

No

< vendorLine1Address>

Characters

45

No

< vendorLine2Address>

Characters

45

No

< vendorCityName>

Characters

45

No

< vendorStateCode>

Characters

2

No

Must be 2 characters

< vendorZipCode>

Characters

20

No

< vendorOrderNumber>

Characters

12

No

< visaVendorIdentifier>

Characters

16

No

< cardHolderAlternateName>

Characters

45

No

< cardHolderLine1Address>

Characters

45

No

< cardHolderLine2Address>

Characters

45

No

< cardHolderCityName>

Characters

45

No

< cardHolderStateCode>

Characters

2

No

Must be 2 characters

< cardHolderZipCode>

Characters

20

No

< cardHolderWorkPhoneNumber>

Characters

10

No

< cardLimit>

Decimal

No

Money format (2 decimal places)

< cardCycleAmountLimit>

Decimal

Money format (2 decimal places)

< cardCycleVolumeLimit>

Decimal

Money format (2 decimal places)

< cardStatusCode>

Characters

2

No

< cardNoteText>

Characters

50

No

More:

Endowment