MasterCard (procurement Card) Processing
Description:
From The Purchasing web site: The University Purchasing Card issued by, JP Morgan Chase, is a credit card which acts as a procurement tool offering an alternative to the existing University procurement processes. It provides an extremely efficient and effective method of purchasing and paying for goods and services with a value less than $4,999.00.
Processing:
A .cdf file is sent to UConn, daily, usually around 3PM, from MasterCard. The ProCard file name begins with GUC3571C (distribution id). The file is placed on the prod batch server PCdrop/inbound/prod. PRD-KFS-ProCard_data_xfer runs to transfer the file to the Kuali production batch server staging/fp/masterCardInput. The ProCard file contains cardholder data and transactional data.
LoadMasterCardFileJob runs at 7pm each evening (Sunday thru Friday) to process the file. Cardholder data is used to create or update information on the procurement cardholder table. Transactional data and data from the procurement cardholder table is used to create an .xml file. A MasterCard Summary report is sent to the Procurement Card Administrator(s), giving a detaill list of transactions on the ProCard file, sent from MasterCard.
ProcurementCardDocumentJob runs following loadMasterCardFileJob to create PCDO documents, using the .xml file as input. Each PCDO document has one accounting line with a department account and an object code of 7130 (procurement clearing). The documents are routed to the cardholder reconciler.
The cardholder reconciler must then reallocate the PCDO documents from object code 7130 to an object code that is valid for PCDO documents. The reconciler may change the account number as well as the object code or even split the charge between several accounts. In all cases the object code must be changed from 7130 to an object code that is valid for PCDO documents.
Once the PCDO document has been modified and approved by the reconciler, it will route to the Fiscal Officer(s) of the account for approval. The PCDO document will become final, after receiving approval from the Fiscal Officer(s).