Procurement Card Upload Format

 

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

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:

General Ledger