Procurement Card Upload Format

go-arrow-red   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 <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:

<transactions xmlns="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.

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

 

 

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

Labor Distribution