Understanding the Payables Credit Card Transaction Interface Table
Use SQL*Loader to load credit card transaction information into the AP_EXPENSE_FEED_LINES interface table. When you initiate the Credit Card Transaction Validation and Exception Report, 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 credit card transaction data.
Attention: If you are running Payables in a multi-org environment, you may want to populate ORG_ID when you load the Payables Credit Card Transaction Interface table.