Procurement Card Upload Format

 

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></ procurementCardTransactions> tag. This tag also contains attributes that identify the schema the document adheres to, such as:

<transactionsxmlns="http://www.kuali.org/kfs/fp/procurementCard" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

• 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></transaction> can repeat one or more times.
• Access a sample file here. 

Procurement card format

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
<subAccountNumber>	Characters	5	No
<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