Use the Procurement Card Transactions Interface Table to load transaction data from your procurement card issuers into your Payables system. When you submit the Procurement Card Transactions Validation program for records where the CREATE_DISTRIBUTION_FLAG is Y, Payables uses the data in the AP_EXPENSE_FEED_LINES_ALL table to create distributions with proper accounts in the AP_EXPENSE_FEED_DISTS table. Payables uses data in this table to confirm transactions with your employees and managers. After employees and managers have verified and approved the transactions, you submit the Create Procurement Card Issuer Invoice program to import the data into the Payables Open Interface tables and optionally summarize the data by GL Account (CCID). You can then submit the Payables Open Interface Import Program to create invoices from the data.

If your procurement card supplier provides multiple records for a single transaction (detailed item level information), then load all records associated with a single procurement card transaction as one record in the AP_EXPENSE_FEED_LINES_ALL table. This table provides many columns for detailed item-level information as well as 30 descriptive flexfield attribute columns. Do this to avoid generating an exception (DUPLICATE REFERENCE) when running Procurement Card Transactions Validation.

Understanding the Payables Procurement Card Transactions Interface Table

Use SQL*Loader to load procurement card transaction information into the AP_EXPENSE_FEED_LINES interface table. When you initiate the Procurement Card Transactions Validation program, the import program validates all required transaction data in these tables.

The interface table is organized by columns that Payables uses to categorize and store specific transaction information.

NOT NULL Columns

You must enter values for all NOT NULL columns in the interface table to successfully save your credit card transaction data in the interface table.

NULL Columns

Such columns in the interface table need not have a value.

Required Columns

In addition to the NOT NULL columns, there are columns in the interface table that require a value for import. If you do not enter a valid value in a Required field, the record will be rejected during validation.

Conditionally Required Columns

Payables requires you to enter values in a conditionally required column only if you have entered a value in another column on which the column is dependent.

Optional Columns

You can use some columns in the interface table to import additional procurement card transaction data.