Patent ID: 7676407

Claim:
A computer-accessible medium having executable instructions to communicate data from an online procurement system to an account payable system, the executable instructions directing a processor to perform: extracting procurement data from a first database, the first database having a file format from an online procurement system; splitting the extracted procurement data to a specified format in accordance with rules that define a plurality of procurement data fields in the specified format and a plurality of relationships between fields of an account payable data format wherein the splitting further comprises splitting the procurement data into four purchase order tables comprising a purchase order header table, purchase order line item table, a purchase order shipment table, and a purchase order distribution table; changing a record number of each of the four purchase order tables to an organization code; loading the four purchase order tables into an intermediate database using four control files, the four control files containing information to operate a second database; filling a new table in a format of the second database from the values from the four purchase order tables; mapping terms that do not exist in the first database to a genesis value; creating a purchase order file by writing records that match the organization code and a particular charge account; creating procurement data in an account payable format from the second database in the specified format; and communicating the created procurement data in the account payable format to an account payable system.