Skip Headers

Oracle Payables Reference Guide
Release 12.1
Part Number E12796-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Payables Open Interface Tables

Payables Open Interface Tables

The Payables Open Interface tables store invoice and supplier information for import into Payables base tables.

The Invoice Open Interface Import program builds Payables invoices based on the invoice records in the Payables Open Interface tables. After the import program builds the invoices, they can be viewed, modified, and validated in the Invoice Workbench.

The invoice data includes EDI and XML invoices from your suppliers, invoice records that you entered in the Quick Invoices window, invoices that you loaded with Oracle SQL*Loader, lease invoices that were transferred from Property Manager, credit card transaction data, and invoices that your suppliers entered and submitted online via Oracle iSupplier Portal.

The Suppliers Open Interface Import, Supplier Sites Open Interface Import, and Supplier Sites Contacts Open Interface Import process supplier information and load them into the appropriate tables.

This discussion includes the following topics:

Related Topics

Payables Open Interface Import, Oracle Payables User Guide

Create Procurement Card Issuer Invoice, Oracle Payables User Guide

Understanding the Invoice Open Interface Tables

Use the Quick Invoices window, Oracle e-Commerce Gateway, the Credit Card Invoice Interface Summary, Property Manager, the Oracle Assets Export Lease Payments to Payables process, Oracle XML Gateway, or SQL*Loader to load invoice information into the interface tables: AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.

The Payables Open Interface program validates each record you select for import, and if the record contains valid data, then the program creates a Payables invoice with distributions and scheduled payments based on the invoice header and line information in the record.

Records in the AP_INVOICE_LINES_INTERFACE table create one or more invoice distributions. Note that one row may create more than one distribution. For example, if you enter a Tax line in this table and prorate it across three Item lines, during Open Interface Import the system will create three Tax invoice distributions based on the single Tax line in this table.

The interface tables include columns, which Payables uses to categorize and store specific invoice information. For example, invoice source information is stored in the column called SOURCE in AP_INVOICES_INTERFACE. Columns may have the following attributes:

NOT NULL Columns

You must enter values for all NOT NULL columns in the interface tables to successfully save your invoice data in the interface tables. If you do not enter a value in a NOT NULL column, then you cannot save the record in the interface table.

Required Columns

If you do not enter a valid value in a Required field, then the record will be rejected during import.

NULL Columns

Leave these columns null or the import process will fail. For example, during import Payables Open Interface Import updates the values of the STATUS and REQUEST_ID columns to create invoices. Payables does not support importing any data from these columns and you should leave these columns null for the records you load in the table.

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 conditionally required column is dependent.

Optional Columns

You can use some columns in the interface tables to import additional invoice information for the invoices created by Payables Open Interface Import. Payables Open Interface Import imports the data that you load into these optional columns, provided that the information passes the validation checks during Payables Open Interface Import.

Internal ID Columns

These columns contain values that Payables uses internally and the user never sees. You can obtain these values only by looking in Payables tables. These ID columns correspond to other columns in the interface table. You do not need to enter a value for any of these ID columns if you enter a value in the corresponding column. For example, if you enter the TERMS_NAME you do not need to enter the TERMS_ID.

If you enter values for both columns and the values do not match, the record will be rejected during import. For example, if you enter a TERMS_NAME and a TERMS_ID, and the TERMS_ID corresponds to a different TERMS_NAME, then the record will be rejected during import.

Note that when you enter invoice records in the Quick Invoices window that Payables populates the ID columns. This enables faster processing of your invoice records.

Tip: If you are manually entering records: the import process will work faster if you provide values for the internal ID columns instead of the corresponding columns.

Understanding the Suppliers Open Interface Tables

The Supplier Open Interface Import, Supplier Sites Open Interface Import and Supplier Site Contacts Open Interface Import process the information that the user loads into AP_SUPPLIERS_INT, AP_SUPPLIER_SITES_INT, and AP_SUP_SITE_CONTACT_INT tables respectively. When all validations are passed, records are inserted into PO_VENDORS, PO_VENDOR_SITES_ALL, PO_VENDOR_CONTACTS respectively.

AP_SUPPLIERS_INT holds Supplier information that is loaded by the user for import. The columns in the table map to the corresponding columns in the PO_VENDORS table. Payables uses this information to create a new Supplier record when the Supplier Open Interface Import program is submitted.

AP_SUPPLIER_SITES_INT holds Supplier Site information that is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDOR_SITES_ALL table. Payables uses this information to create a new Supplier Site record when the Supplier Sites Open Interface Import program is submitted.

AP_SUP_SITE_CONTACT_INT holds Supplier Site Contact data that is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDOR_CONTACTS table. Payables uses this information to create a new Supplier Site Contact record when the Supplier Site Contacts Open Interface Import program is submitted.

Each row in the table will be joined to the appropriate Supplier Site using the VENDOR_SITE_CODE and ORG_ID and/or the VENDOR_SITE_CODE_ID.

Columns may have the attributes listed in the Understanding the Invoice Open Interface Tables section.

Users may find it helpful to review the Entering Suppliers and Supplier Sites Window Reference sections.

When loading existing supplier data into the interface tables, the following checks are performed to ensure data is valid:

Changes to Supplier Sites Open Interface Import

When importing supplier sites using Supplier Sites Open Interface import, if data is NULL in any of the following columns of supplier site interface table (AP_SUPPLIER_SITES_INT), then the values for these columns are populated from the values defined in the Supplier Tab of Payables Options:

During import if no value is found both in AP_SUPPLIER_SITES_INT and Payables Options, then the import program must default as per the current logic.

Defaults

The intent of the Supplier Open Interface Import is to emulate the entry of Suppliers, Sites, and Contacts through the Supplier Entry form as closely as possible. As such, there are many values that will be automatically defaulted if not provided by the user.

These defaults for Suppliers can come from AP_SYSTEM_PARAMETERS_ALL, FINANCIALS_SYSTEM_PARAMS_ALL, PO_SYSTEM_PARAMETERS.ALL, RCV_PARAMETERS, or hard-coded values. As these source tables are organized by operating unit and the supplier data is not, the Suppliers Open Interface Import program assigns a default organization to each run based on the responsibility of the user initiating the concurrent request. This is necessary in order to determine which default values to assign to supplier records.

The defaults for Supplier Sites generally come from the Supplier record. However, in certain cases due to multiple organizations considerations, it is necessary to default values for Supplier Sites from AP_SYSTEM_PARAMETERS_ALL or FINANCIALS_SYSTEM_PARAMS_ALL.

Validations

As with defaults, the validations performed by the Suppliers Open Interface Import program are intended to emulate the processing done by the Supplier Entry form. In addition to checks done at the database level for correct data types, these validations include checks performed against existing lookup values or values derived from other tables. When these types of validations are done, a check is performed to make sure that the value supplied is that of an active record, a record that has not been end-dated or disabled. Details of the validations performed can be found in the descriptions for the AP_SUPPLIERS_INT, AP_SUPPLIER_SITES_INT, and AP_SUP_SITE_CONTACT_INT tables.

Rejections

If an invalid value is encountered when the concurrent process is evaluating each row, the 'REJECT_CODE' column is populated with the relevant rejection message and the 'STATUS' is updated to 'REJECTED'. Processing on that row then stops and the program moves on to the next row.

Payables Open Interface Table Descriptions

The Payables Open Interface table descriptions list the columns in the AP_INVOICES_INTERFACE table, the AP_INVOICE_LINES_ INTERFACE table, the AP_SUPPLIERS_INT table, the AP_SUPPLIER_SITES_INT table, and the AP_SUP_SITE_CONTACT_INT table. Although columns are validated against columns in other tables, the tables have no foreign key relationships.

AP_INVOICES_INTERFACE

The following table summarizes the AP_INVOICES_INTERFACE table.

Column Name Null Type Comments
INVOICE_ID NOT NULL NUMBER(15) Required, Primary key. This value is assigned in the Quick Invoices window by the AP_INVOICES_ INTERFACE_S sequence.
INVOICE_NUM   VARCHAR2(50) Required if there is more than one invoice for the supplier during import
INVOICE_TYPE_ LOOKUP_CODE   VARCHAR2(25) Optional
INVOICE_DATE   DATE Optional
PO_NUMBER   VARCHAR2(20) Validated against: PO_HEADERS.SEGMENT1
VENDOR_ID   NUMBER(15) Internal ID Validated against: PO_VENDORS.VENDOR_ID One of the following is required unless you match to a PO: VENDOR_ID, VENDOR_NUM, VENDOR_NAME
VENDOR_NUM   VARCHAR2(30) One of the following is required unless you match to a PO: VENDOR_ID, VENDOR_NUM, VENDOR_NAME
VENDOR_NAME   VARCHAR2(80) One of the following is required: VENDOR_ID, VENDOR_NUM, VENDOR_NAME
VENDOR_SITE_ID   NUMBER(15) Internal ID
Validated against:
PO_VENDOR_SITES.VENDOR_SITE_ID
VENDOR_SITE_CODE   VARCHAR2(15) N/A
INVOICE AMOUNT   NUMBER Required
INVOICE_CURRENCY_CODE   VARCHAR2(15) Optional
Validated against:
FND_CURRENCIES.CURRENCY_CODE
EXCHANGE_RATE   NUMBER Validated against: GL_DAILY_CONVERSION_TYPES. CONVERSION_TYPE
EXCHANGE_RATE_TYPE   VARCHAR2(30) Conditionally required
EXCHANGE_DATE   DATE Conditionally required
TERMS_ID   NUMBER(15) Internal ID TERMS_NAME or TERMS_ID required if no terms are available through matching or at the supplier site. Validated against: AP_TERMS.TERMS_ID
TERMS_NAME   VARCHAR2(50) TERMS_NAME or TERMS_ID required if no terms are available through matching or at the supplier site.
DESCRIPTION   VARCHAR2(240) Optional
AWT_GROUP_ID   NUMBER(15) Internal ID Validated against: AP_AWT_GROUPS. AWT_GROUP_ID
AWT_GROUP_NAME   VARCHAR2(25) Optional
LAST_UPDATE_DATE   DATE Optional
LAST_UPDATED_BY   NUMBER(15) Optional
LAST_UPDATE_LOGIN   NUMBER(15) Optional
CREATION_DATE   DATE Optional
CREATED_BY   NUMBER(15) Optional
ATTRIBUTE_CATEGORY   VARCHAR2(150) Optional
ATTRIBUTE [1-15]   VARCHAR2(150) Optional
GLOBAL_ ATTRIBUTE_CATEGORY   VARCHAR2(150) Optional
GLOBAL_ATTRIBUTE [1-20]   VARCHAR2(150) Optional
STATUS   VARCHAR2(25) N/A
SOURCE   VARCHAR2(80) Required
GROUP_ID   VARCHAR2(80) Optional
REQUEST_ID   NUMBER N/A
PAYMENT_CROSS_RATE_ TYPE   VARCHAR2(30) N/A
PAYMENT_CROSS_RATE_ DATE   DATE N/A
PAYMENT_CROSS_RATE   NUMBER N/A
PAYMENT_CURRENCY_CODE   VARCHAR2(15) N/A
WORKFLOW_FLAG   VARCHAR2(1) N/A
DOC_CATEGORY_CODE   VARCHAR2(30) Optional if Sequential Numbering Profile option is "Partial" or "Always"
VOUCHER_NUM   VARCHAR2(50) N/A
PAYMENT_METHOD_ LOOKUP_CODE   VARCHAR2(25) Validated against AP_LOOKUP_CODES
PAY_GROUP_LOOKUP_CODE   VARCHAR2(25) Validated against: PO_LOOKUP_CODES
GOODS_RECEIVED_DATE   DATE N/A
INVOICE_RECEIVED_DATE   DATE N/A
GL_DATE   DATE N/A
ACCTS_PAY_CODE_ COMBINATION_ID   NUMBER(15) N/A
USSGL_TRANSACTION_ CODE   VARCHAR2(30) N/A
EXCLUSIVE_PAYMENT_FLAG   VARCHAR2(1) N/A
ORG_ID   NUMBER(15) N/A
AMOUNT_APPLICABLE_ TO_DISCOUNT   NUMBER Optional
PREPAY_NUM   VARCHAR2(50) Validated against AP_INVOICES_ALL.INVOICE_NUM
PREPAY_DIST_NUM   NUMBER(15) N/A
PREPAY_APPLY_AMOUNT   NUMBER N/A
PREPAY_GL_DATE   DATE N/A
INVOICE_INCLUDES_PREPAY_FLAG   VARCHAR2(1) N/A
NO_XRATE_BASE_AMOUNT   NUMBER Used only if Payables option Calculate User Exchange Rate is enabled
VENDOR_EMAIL_ADDRESS   VARCHAR2(2000) Supplier e-mail address for XML invoice rejections
TERMS_DATE   DATE N/A
REQUESTER_ID   NUMBER(10) N/A

INVOICE_ID

Unique identifier for this invoice within this batch. You assign the same value to the invoice's lines in the AP_INVOICE_LINES_INTERFACE table to identify the data as belonging to the same invoice.

Variable Description
Validation: None
Destination: None

INVOICE_NUM

Enter the invoice number that you want to assign to the invoice created in Payables from this record. The number must be unique for the supplier. If you do not enter a value, then during import, Payables uses the system date at the time of import as a default. If you enter more than one invoice for a supplier, then be sure to enter unique invoice numbers rather than using the default, or the invoices will have duplicate invoice numbers and will be rejected during import.

Variable Description
Validation: Must be a unique number for the supplier. If you assign a duplicate number for the supplier, Payables Open Interface Import does not create an invoice from this record.
Destination: AP_INVOICES_ALL.INVOICE_NUM

INVOICE_TYPE_LOOKUP_CODE

Type of invoice: Credit or Standard. If you do not enter a value, the system assigns a value during Payables Open Interface Import based on the value of INVOICE_AMOUNT. If INVOICE_AMOUNT is less than zero, the invoice will be Credit. If INVOICE_AMOUNT is zero or greater, the invoice will be Standard. When using the Service Procurement, you can import prepayments using the Payables Open Interface Import program.

Variable Description
Validation: The value must be Credit or Standard. The invoice type must correspond to the invoice amount if it is Credit or Standard. For example, a Credit invoice must have an invoice amount that is less than zero.
Destination: AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_ CODE

INVOICE_DATE

Date of the invoice. If you do not enter a value, the system uses the date you submit Payables Open Interface Import as the invoice date.

Payables may use the Invoice Date as the Terms Date and the GL Date for an invoice, depending on your system setup. If your GL Date Basis is Invoice Date, then the Invoice Date must be in an open or future period.

Variable Description
Validation: The value must be in valid date format.
Destination: AP_INVOICES_ALL.INVOICE_DATE

PO_NUMBER

Number of the purchase order to which you are matching the invoice. If you match the invoice to a purchase order by entering a value here, during Payables Open Interface Import the system uses purchase order information to create distributions and populate various columns in the AP_INVOICE_DISTRIBUTIONS_ALL table. If you do not use Quick Invoices, and if you do not specify a supplier in the AP_INVOICES_INTERFACE table, then the PO_NUMBER value is used to derive AP_INVOICES_ALL.VENDOR_ID, and if you do not specify the supplier site, the PO_NUMBER value could be used to derive AP_INVOICES_ALL.VENDOR_SITE_ID.

To match an invoice to a purchase order, you do not need to enter a value here at the invoice header level if you enter a value at the line level, AP_INVOICE_LINES_INTERFACE.PO_NUMBER.

Variable Description
Validation: This value must match a valid, approved, open purchase order for the same supplier. The purchase order must not be final matched. You can obtain a list of valid values from PO_HEADERS.SEGMENT1. If the source is e-Commerce Gateway, Payables will import invoices only if they are within the quantity and price tolerance you have specified in the Invoice Tolerances window. For other invoice sources, tolerances are checked at Invoice Validation time.
Destination: None

VENDOR_ID

The internal supplier identifier for the supplier. You must identify the supplier by entering a value for one of the following columns in this table: VENDOR_ID, VENDOR_NUM, VENDOR_SITE_ID, or PO_NUMBER. If you have not yet entered the supplier in the Suppliers window, enter it before import.

Variable Description
Validation: The ID you enter must be for an existing, valid supplier. You can obtain a list of valid values from PO_VENDORS.VENDOR_ID.
Destination: AP_INVOICES_ALL.VENDOR_ID

VENDOR_NUM

Supplier number. You must identify the supplier by entering a value for one of the following columns in this table: VENDOR_ID, VENDOR_NUM, VENDOR_SITE_ID, VENDOR_SITE CODE, or PO_NUMBER. If you have not yet entered the supplier in the Suppliers window, then enter it before import.

Variable Description
Validation: The number must be for an existing, valid supplier. You can obtain a list of valid values from PO_VENDORS.SEGMENT1.
Destination: None. This value is used to enter AP_INVOICES_ALL.VENDOR_ID.

VENDOR_NAME

Name of the supplier. You must identify the supplier by entering a value for one of the following columns in this table: VENDOR_ID, VENDOR_NUM, VENDOR_SITE_ID, VENDOR_SITE CODE, or PO_NUMBER. If you have not yet entered the supplier in the Suppliers window, then enter it before import.

Variable Description
Validation: This must be an existing, valid, active supplier. You can obtain a list of valid values from PO_VENDORS.VENDOR_NAME.
Destination: None. This value is used to enter AP_INVOICES_ALL.VENDOR_ID.

VENDOR_SITE_ID

Internal supplier site identifier.

If you do not provide a valid value to identify the pay site in VENDOR_SITE_CODE or VENDOR_SITE_ID then import searches for a valid supplier pay site in the following order:

Import rejects the invoice if it cannot identify a valid supplier site.

Variable Description
Validation: The ID you enter must be for an existing, valid supplier site for the supplier you specify (VENDOR_NUM or VENDOR_ID). You can obtain a list of valid values from PO_VENDOR_SITES.VENDOR_SITE_ID. The site must also be a pay site.
Destination: AP_INVOICES_ALL.VENDOR_SITE_ID

VENDOR_SITE_CODE

Supplier site name.

If you do not provide a valid value to identify the pay site in VENDOR_SITE_CODE or VENDOR_SITE_ID then import searches for a valid supplier pay site in the following order:

Import rejects the invoice if it cannot identify a valid supplier site.

Variable Description
Validation: This must be a valid, active supplier site for the supplier you specify (VENDOR_NUM or VENDOR_ID). You can obtain a list of valid values from PO_VENDORS.VENDOR_SITE_CODE. The site must also be a pay site.
Destination: None. This value is used to enter AP_INVOICES_ALL.VENDOR_SITE_ID.

INVOICE_AMOUNT

Amount of the invoice. Do not exceed the precision of the currency of for the invoice. For example, if you are entering an amount in US dollars, then do not enter more than two numbers after the decimal point.

Variable Description
Validation: This value must equal the sum of the AMOUNT values in the AP_INVOICE_LINES_INTERFACE table for lines with the same INVOICE_ID. The amount must correspond to the invoice type. For example, Standard invoices must have an amount of zero or greater.
Destination: AP_INVOICES_ALL.INVOICE_AMOUNT

INVOICE_CURRENCY_CODE

Currency code for the invoice. If you do not enter a value, then the supplier site value defaults during import.

Note: When the invoice currency and payment currency are associated fixed-rate currencies the PAYMENT_CROSS_RATE_TYPE, PAYMENT_CROSS_RATE, and PAYMENT_CROSS_RATE_DATE are not imported to AP_INVOICES_ALL

Variable Description
Validation: If you enter a code in a foreign currency, you must enter a valid, active currency code from FND_CURRENCIES.CURRENCY_CODE.
Destination: AP_INVOICES_ALL.INVOICE_CURRENCY_ CODE

EXCHANGE_RATE

Invoice exchange rate for a foreign currency invoice.

If the Payables option Require Exchange Rate Entry is enabled, then you must provide either an exchange rate or sufficient information for Payables to derive the exchange rate during import. If EXCHANGE_RATE_TYPE is User, then you must provide a value for EXCHANGE_RATE (or, if the Payables option Calculate User Exchange Rate is enabled, then you can provide a value for NO_XRATE_BASE_AMOUNT instead).

If you did not enter the invoice record in the Quick Invoices window, and if you enter SPOT or CORPORATE as the EXCHANGE_RATE_TYPE, then the import program supplies the exchange rate value, and you should leave this column null.

If the invoice currency has a fixed rate to your functional currency, then during import Payables overwrites any value you enter with the fixed rate. You can see any occurrences of Payables overwriting the exchange rate by reviewing the log file for the import.

Variable Description
Validation: If you entered the invoice record in the Quick Invoices window, then do not overwrite the value that the Quick Invoices window provided or import will reject the invoice record.
Destination: AP_INVOICES_ALL.EXCHANGE_RATE

EXCHANGE_RATE_TYPE

Type of exchange rate used to calculate the exchange rate between the invoice currency and your functional currency. If the value in the INVOICE_CURRENCY_CODE column is a foreign currency code, then enter a value in this column to indicate which exchange rate type you are using. You can enter a predefined or user-defined exchange rate type. If the invoice record has a foreign currency and you do not enter a value for EXCHANGE_RATE_TYPE, then during import the system uses the Exchange Rate Type selected in the Payables Options window. If the invoice currency and your functional currency are associated fixed-rate currencies, such as euro and another EMU currency, then enter EMU Fixed.

Variable Description
Validation: Payables uses five types of exchange rates: User, Spot, Corporate, EMU Fixed, and user-defined. If you use Spot, Corporate, or any user-defined rate type, the value you enter here is validated against the GL Daily Rates table. If you use EMU Fixed, Payables provides the exchange rate during import. If you use User as the exchange rate type, you must either enter a value for EXCHANGE_RATE or, if the Payables Option Calculate User Exchange Rate is enabled, you can enter a value for NO_XRATE_BASE_AMOUNT instead.
Destination: AP_INVOICES_ALL.EXCHANGE_RATE_TYPE

EXCHANGE_DATE

Enter a value in this column if you enter a foreign currency code in the CURRENCY_CODE column. The date you enter determines the exchange rate for a foreign currency invoice with a Spot, Corporate, or user-defined rate type. If you leave this column null, Payables uses the the invoice GL Date.

Variable Description
Validation: Must be in valid date format.
Destination: AP_INVOICES_ALL.EXCHANGE_DATE

TERMS_ID

Internal identifier for the payment terms. You maintain payment terms in the Payment Terms window. If you want to specify payment terms you need to enter a value in only one of the following columns: TERMS_NAME or TERMS_ID.

The import process searches the following sources in the following order for payment terms and uses the first terms it finds:

  1. invoice record header (TERMS_ID or TERMS_NAME)

  2. purchase order terms for the purchase order in the invoice header (if the invoice record is purchase order matched at the header level)

  3. purchase order terms for the purchase orders to which one or more lines are matched directly, or indirectly through a receipt (if not more than one set of terms is represented)

  4. supplier site

If none of these sources has a value for payment terms, then the invoice record is rejected.

If you use calendar-based payment terms and no calendar period is defined for the terms date, then the system uses the terms date as the due date when it creates the scheduled payment.

Variable Description
Validation: Terms must be valid terms in the AP_TERMS table.
Destination: AP_INVOICES_ALL.TERMS_ID.

TERMS_NAME

Payment terms. You maintain payment terms in the Payment Terms window. If you want to specify payment terms you need to enter a value in only one of the following columns: TERMS_NAME or TERMS_ID.

The import process searches the following sources in the following order for payment terms and uses the first terms it finds:

  1. invoice record header (TERMS_ID or TERMS_NAME)

  2. purchase order terms for the purchase order in the invoice header (if the invoice record is purchase order matched at the header level)

  3. purchase order terms for the purchase orders to which one or more lines are matched directly, or indirectly through a receipt (if not more than one set of terms is represented)

  4. supplier site

If none of these sources has a value for payment terms, then the invoice record is rejected.

If you use calendar-based payment terms and no calendar period is defined for the terms date, then the system uses the terms date as the due date when it creates the scheduled payment.

Variable Description
Validation: Terms must be valid, active terms in the AP_TERMS table.
Destination: None. This value may be used to enter a value for AP_INVOICES_ALL.TERMS_ID.

DESCRIPTION

Enter the description that you want to assign to the invoice created from this record. If you are matching to a purchase order and you do not enter a value here, then during Payables Open Interface Import the system will assign to AP_INVOICES_ALL.DESCRIPTION the Item Description from the purchase order line.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.DESCRIPTION

AWT_GROUP_ID

Internal identifier for Automatic Withholding Tax Group. The withholding tax group you identify in this table (AWT_GROUP_ID or AWT_GROUP_NAME) is used to assign a withholding tax group to a line only if you do not identify one for the invoice in one of the following columns: AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID or AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME.

Variable Description
Validation: If this value is used during import, it must be a valid value in AP_AWT_GROUPS.
Destination: AP_INVOICES_ALL.AWT_GROUP_ID, only if you do not enter another value for AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID or AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME.

AWT_GROUP_NAME

Automatic Withholding Tax Group. If you identify a withholding tax group in this table (AWT_GROUP_ID or AWT_GROUP_NAME), it is used only if you do not identify a withholding tax group for the invoice lines in the AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID or AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME column. You maintain withholding tax groups in the Withholding Tax Groups window.

Variable Description
Validation: Value must be valid and active in AP_AWT_GROUPS
Destination: None

LAST_UPDATE_DATE

Enter the last update date for this record (usually the same date as CREATION_DATE). Payables uses this date for reference and audit purposes only.

Variable Description
Validation: Must be in valid date format.
Destination: AP_INVOICES_ALL.LAST_UPDATED_DATE, AP_PAYMENT_SCHEDULES.LAST_UPDATED_ DATE

LAST_UPDATED_BY

Enter the userid of the person who last updated this record (usually the same value as CREATED_BY). If you do not enter a value here, then during Payables Open Interface Import the system will use the userid of the person who submits Payables Open Interface Import.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.LAST_UPDATED_BY, AP_ PAYMENT_SCHEDULES.LAST_UPDATED_BY

LAST_UPDATE_LOGIN

The last date for this record. Usually the same date as the CREATION_DATE. If you enter a value in this column, the system uses it to populate AP_INVOICES_ALL.AP_LAST_UPDATE_LOGIN. If you do not enter a value, then during Payables Open Interface Import the system will use the system date.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.AP_LAST_UPDATE_LOGIN,AP_PAYMENT_SCHEDULES.AP_LAST_UPDATE_LOGIN

CREATION_DATE

Enter the date on which you load this record into the interface table. Payables uses this date for reference and audit purposes. When Payables Open Interface Import creates an invoice from this record, it does not use this date as the creation date for the invoice; it uses the system date at the time you submit Payables Open Interface Import.

Variable Description
Validation: Must be in valid date format.
Destination: AP_INVOICES_ALL.CREATION_DATE, AP_PAYMENT_SCHEDULES.CREATION_DATE

CREATED_BY

Enter the userid of the person that loads this record into the table. Payables Open Interface Import transfers this ID to the AP_INVOICES_ALL and AP_PAYMENT_SCHEDULES tables during import so that the creator of the record becomes the invoice and scheduled payment creator. If you do not enter a value, then during Payables Open Interface Import the system will use the userid of the person who submits Payables Open Interface Import.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.CREATED_BY, AP_PAYMENT_SCHEDULES.CREATED_BY

ATTRIBUTE_CATEGORY

Enter the descriptive flexfield category for the descriptive flexfield information you want to import.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.ATTRIBUTE_CATEGORY

ATTRIBUTE [1-15]

Enter descriptive flexfield information that you want to import for an invoice. The structure of the information you enter in these columns (datatypes, value sets) must match the structure of the descriptive flexfield segments you have defined for your invoices or you will experience validation problems when you try to access the information in the invoice windows.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.ATTRIBUTE[1-15]

GLOBAL_ATTRIBUTE_CATEGORY

Enter the descriptive flexfield category for the descriptive flexfield information you want to import.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.GLOBAL_ATTRIBUTE_ CATEGORY

GLOBAL_ATTRIBUTE [1-20]

Enter descriptive flexfield information that you want to import for an invoice. The structure of the information you enter in these columns (datatypes, value sets) must match the structure of the descriptive flexfield segments you have defined for your invoices or you will experience validation problems when you try to access the information in the invoice windows.

Variable Description
Validation: If you are using a localization, you must enter appropriate values in this flexfield or the invoice will be rejected during import. For more information, see you localization user's guide.
Destination: AP_INVOICES_ALL.GLOBAL_ATTRIBUTE[1-20]

STATUS

Do not enter a value in this field. It is for internal use only.

Variable Description
Validation: None
Destination: None

SOURCE

Source of the invoice data. Examples include Quick Invoices, EDI Gateway (e-Commerce Gateway), Credit Card, Oracle Assets, Oracle Property Manager, ERS (Evaluated Receipt Settlement), RTS (Return to Supplier), XML Gateway, and user-defined.

You define additional values for Source in the Oracle Payables Lookups window. If you have defined additional sources, you should use a source name for only one type of source. For example, do not use the same source name for invoices that you enter in Quick Invoices, and invoices you load with SQL*Loader.

The Source name also determines which records will be selected for import or purge. You specify a Source name when you submit Payables Open Interface Import or Purge Payables Open Interface.

Variable Description
Validation: If you do not use a predefined source you must enter the name exactly as you have defined the lookup value in the Oracle Payables Lookups window, or Payables Open Interface Import will not create an invoice from the record. The lookup value must have the Type SOURCE. See: Lookups, Oracle Payables Implementation Guide.
Destination: AP_INVOICES_ALL.SOURCE

GROUP_ID

Identifier for this batch. When you submit Payables Open Interface Import or Purge Payables Open Interface, you must specify a Source and you can optionally specify a Group. Processing records by Group allows you to concurrently import or purge subsets of records for the same Source. You may want to assign a Group ID if you are processing a large number of records, for example, importing legacy data. For invoice records entered in the Quick Invoices window, this value is the Quick Invoices Batch Name.

Variable Description
Validation: None
Destination: None

REQUEST_ID

The system populates this field with the concurrent request ID number for the Payables Open Interface Import process. Leave this column null.

Variable Description
Validation: None
Destination: None

PAYMENT_CROSS_RATE_TYPE

If the invoice currency and payment currency are associated fixed-rate currencies, enter EMU FIXED. Otherwise, leave this value null.

Variable Description
Validation: If the invoice currency and payment currencies are different fixed-rate currencies, then during import, Payables will overwrite whatever value you enter here with EMU FIXED. If the invoice and payment currencies are the same, this value must be null.
Destination: AP_INVOICES_ALL.PAYMENT_CROSS_RATE_ TYPE

PAYMENT_CROSS_RATE

If the invoice currency and payment currency are different currencies and are both associated fixed-rate currencies (for example, euro and another EMU currency), you can enter the fixed cross rate. If you leave this value null, Payables will provide the cross rate during import.

Variable Description
Validation: If this value is different from the cross rate in the GL_DAILY_RATES table, the fixed rate in the GL_DAILY_RATES table will be used, and the system will ignore the value you provided. If the invoice currency and payment currency are the same, you can enter 1 as the value.
Destination: AP_INVOICES_ALL.PAYMENT_CROSS_RATE

PAYMENT_CROSS_RATE_DATE

Date cross rate between invoice currency and payment currency is effective.

Variable Description
Validation: This value must be the exact cross rate in the GL_DAILY_RATES table. If the values for PAYMENT_CURRENCY_CODE and INVOICE_CURRENCY_CODE are different, you must enter a value for PAYMENT_CROSS_RATE_DATE, and the two currencies must have a fixed rate effective as of the cross rate date or the invoice will be rejected.
Destination: AP_INVOICES.PAYMENT_CROSS_RATE_DATE

PAYMENT_CURRENCY_CODE

Currency code for the payment. If you do not provide a value, then during import PAYMENT_CURRENCY_CODE will be set to the same value as the INVOICE_CURRENCY_CODE, the PAYMENT_CROSS_RATE will be set to 1, and the PAYMENT_CROSS_RATE_TYPE and the PAYMENT_CROSS_RATE_DATE will both be null.

Variable Description
Validation: If the invoice currency is not a fixed rate currency, this value must be the same as INVOICE_CURRENCY_CODE. If the invoice currency is a fixed-rate currency, such as Euro or an EMU national currency, you can enter an associated fixed-rate currency. This must be a valid, active currency code from FND_CURRENCIES.CURRENCY_CODE.
Destination: AP_INVOICES_ALL.PAYMENT_CURRENCY_ CODE

WORKFLOW_FLAG

Payables Open Interface Workflow status of the invoice record. You submit this workflow before import.

If you are using the Payables Open Interface Workflow and you want Workflow to process this record, enter Y. If you enter D, Workflow will not process this record. See: Payables Open Interface Import Workflow, Oracle Payables Implementation Guide.

DOC_CATEGORY_CODE

If you are using automatic sequential numbering, then Payables Open Interface Import uses this column to assign a document category to the invoice it creates.

If the Sequential Numbering profile value is "Always" and you do not enter a value in this column, then during import Payables will use STANDARD as the category if the invoice amount is zero or positive, and CREDIT if the invoice amount is negative. We assume that a valid automatic sequence exists for such categories.

If you enable the Allow Document Category Override Payables option, you can enter the document category you want Payables Open Interface Import to assign to the invoice created from this record, instead of the Standard or Credit document category.

Variable Description
Validation: The value is a valid value in AP_INVOICES_ALL.FND_DOC_SEQUENCE_ CATEGORIES. Do not enter a value in this column unless the Sequential Numbering profile option is set to Partial or Always, and the Allow Document Category Override Payables option is enabled. If you enter the value of Standard, then the invoice amount must be positive, and if you enter the value of Credit, then the invoice amount must be negative.
If you enter a document category, it must have an active, automatic sequence assigned to it.
Destination: AP_INVOICES_ALL.DOC_CATEGORY_CODE

VOUCHER_NUM

If you use manual sequential numbering, then enter a unique value for the voucher number you want to apply to the invoice created from this record. The number should not exceed nine digits or you will have problems processing the invoice in Payables.

Variable Description
Validation: If you use manual sequential numbering, the system validates the voucher number for uniqueness. If you use automatic sequential numbering, Payables ignores any value you load into this column and instead selects the next available number for the numbering sequence assigned to the document category for imported invoices.
Destination: AP_INVOICES_ALL.VOUCHER_NUM

PAYMENT_METHOD_LOOKUP_CODE

Method that will be used to pay the invoice.

Variable Description
Validation: The value must be a valid value for the PAYMENT_METHOD lookup code. Payment Methods are user defined in Oracle Payments

PAY_GROUP_LOOKUP_CODE

Pay Group to which the invoice will be assigned. If you do not enter a value, the value will default from the supplier site. If the supplier site does not have a value for Pay Group, then the value will default from the supplier. If neither the supplier nor the supplier site has a value, the system uses the default Pay Group Payables option.

Variable Description
Validation: The value must be a valid and active value in AP_LOOKUP_CODES.LOOKUP_CODE, with a LOOKUP_TYPE value of PAYGROUP.
Destination: AP_INVOICES_ALL.PAY_GROUP_ LOOKUP_CODE

GOODS_RECEIVED_DATE

If you do not provide a value for TERMS_DATE, and if your Terms Date Basis Payables option is set to Goods Received, then if you provide a value here, Payables will use this value as the terms date.

Variable Description
Validation: The value must have a valid date format.
Destination: AP_INVOICES_ALL.GOODS_RECEIVED_DATE

INVOICE_RECEIVED_DATE

If you do not provide a value for TERMS_DATE, and if your Terms Date Basis Payables option is set to Invoice Received, then if you provide a value here, Payables will use the value as the terms date.

Variable Description
Validation: The value must have a valid date format.
Destination: AP_INVOICES_ALL.INVOICE_RECEIVED_DATE

ORG_ID

Organization identifier.

Quick Invoices records are assigned the ORG_ID associated with the user's responsibility. . If this column has no value then the system uses the ORG_ID associated with the responsibility used to submit import.

Variable Description
Validation: Must be a valid organization. Purchase order matched invoices must use an organization consistent with the purchase order.
Destination: AP_INVOICES_ALL.ORG_ID

GL_DATE

The GL Date for the invoice distributions. The date must be in an open or future period.

During import, Payables looks for a GL Date value to assign to the invoice distribution. Payables assigns a value from the first source it finds, and it searches the following sources in the following order: invoice record line, invoice record header, GL Date parameter from import submission, GL Date Basis Payables option.

Note: The following occurs if the system searches at the GL Date Basis level: If the GL Date Basis option is set to Goods Received/Invoice Date, then Payables uses the Goods Received Date, if it is populated. If not, then Payables uses the Invoice Date. If the GL Date Basis option is set to Goods Received/System Date, then Payables uses the Goods Received Date, if it is populated. If it is not, then Payables uses the system date at time of import.

If the GL Date of an invoice is in a future period in Payables, you can account for the invoice but you cannot pay it.

Important: If you are using encumbrance accounting, you must enter a GL Date in a period that is within the latest open encumbrance year. (See also: Budgetary Control In Payables).

Variable Description
Validation: Must be in valid date format. The date must be in an open or future accounting period.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL. ACCOUNTING_DATE (if no value is provided at line level)

ACCTS_PAY_CODE_COMBINATION_ID

Liability account. Payables defaults this value to invoice distributions during import. Payables uses the liability account when you create accounting entries for your invoices if you use accrual basis accounting. Payables credits the liability account in an amount equal to the sum of your invoice distributions. If you do not provide a value, the system uses the account from the supplier site.

Variable Description
Validation: Must be a valid account in your chart of accounts.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.ACCTS_ PAY_CODE_COMBINATION_ID

USSGL_TRANSACTION_CODE

Enter the default transaction code you want to assign to an invoice.

Open Interface Import imports any USSGL information that you load into the interface tables and assigns the information to the invoices it creates.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.USSGL_TRANSACTION_ CODE

EXCLUSIVE_PAYMENT_FLAG

Pay Alone flag. A pay alone invoice is paid with its own payment document without including other invoices for the supplier.

Variable Description
Validation: None
Destination: AP_INVOICES_ALL.EXCLUSIVE_PAYMENT_ FLAG

ORG_ID

Organization identifier.

Quick Invoices invoice records are assigned the ORG_ID associated with the user's responsibility. If this column has no value then the system uses the ORG_ID associated with the responsibility used to submit import.

Variable Description
Validation: Must be a valid organization. Purchase order matched invoices must use an organization consistent with the purchase order.
This value must be consistent with the ORG_ID value at the invoice header.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.ORG_ID

AMOUNT_APPLICABLE_TO_DISCOUNT

Invoice amount applicable to discount.

Variable Description
Validation: None
Destination: AP_INVOICES_ALLAMOUNT_APPLICABLE_TO_DISCOUNT.

PREPAY_NUM

Invoice number of a specific prepayment that you want to apply. Leave this column null to apply all available prepayments in chronological order, starting with the oldest prepayment first, up to the prepayment amount.

If the PREPAY_APPLY_AMOUNT exceeds the amount available on the specified prepayment, then import applies the specified prepayment first, then applies remaining available prepayments (oldest first) up to the specified PREPAY_APPLY_AMOUNT.

For more information see: Applying Prepayments to Invoices in the Open Interface, Oracle Payables User Guide.

Variable Description
Validation: The prepayment has a settlement date on or before the system date, is fully paid, is type Temporary, has the same invoice and payment currency as the invoice, and has not been fully applied.
Destination: None. Import uses this information to populate AP_INVOICES_DISTRIBUTIONS_ALL. PREPAY_DISTRIBUTION_ID

PREPAY_DIST_NUMBER

Distribution number of a specific Item distribution on the specified prepayment that you want to apply. Leave this field blank to apply all available prepayment Item distributions, starting with the lowest distribution number first, up to the amount of the invoice.

Variable Description
Validation: Must be a valid distribution number on the prepayment, must be an Item distribution, and cannot be a reversal distribution.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL. PREPAY_DISTRIBUTION_ID

PREPAY_APPLY_AMOUNT

If you are applying prepayments, the maximum currency amount of the prepayments you want to apply to the invoice. Payables ensures that the prepayment amount does not exceed the invoice amount.

Variable Description
Validation: Must not exceed unpaid invoice amount or amount of available prepayments. Cannot be zero or a negative number.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL. PREPAY_APPLY_AMOUNT

PREPAY_GL_DATE

Accounting date for the application of the prepayment. This will be the GL date on the new Prepayment type distribution on the imported invoice. If you do not enter a value, then import will use the system date as the prepayment accounting date.

Variable Description
Validation: The date must be in an open or future period.
Destination: AP_INVOICES_DISTRIBUTIONS_ALL. ACCOUNTING_DATE

INVOICE_INCLUDES_PREPAY_FLAG

A value of Y indicates that the invoice amount has been reduced by a prepayment. When the invoice is imported the amount paid on the invoice will not be reduced by the prepayment applied to it. For more information see: Entering Invoices that Reference Prepayments, Oracle Payables User Guide.

Variable Description
Validation: None
Destination: AP_INVOICES_DISTRIBUTIONS_ALL. INVOICE_INCLUDES_PREPAY_FLAG

NO_XRATE_BASE_AMOUNT

Invoice functional currency amount. Used only if the Payables option Calculate User Exchange Rate is enabled and if the exchange rate type is User. Import uses this value and the INVOICE_AMOUNT to calculate and enter the invoice exchange rate.

Variable Description
Validation: If you provide a value for NO_XRATE_BASE_AMOUNT the Payables option Calculate User Exchange Rate must be enabled; and the exchange rate type must be User. If the Payables option Calculate User Exchange Rate is enabled, and if the exchange rate type is User, then you are required to enter a value for either NO_XRATE_BASE_AMOUNT or EXCHANGE_RATE. If you enter values for both NO_XRATE_BASE_AMOUNT and EXCHANGE_RATE, then you must provide the correct exchange rate or import will reject the invoice.
Destination: AP_INVOICES_ALL.BASE_AMOUNT

VENDOR_EMAIL_ADDRESS

Supplier e-mail address.

Oracle XML Gateway populates this column when it loads XML invoice records to Payables. Certain invoice import failures will cause a workflow notification of the problem to be sent to the supplier at this specified e-mail address. For a list of these import rejections, see: Processing Oracle XML Gateway Invoice Records, Oracle Payables Implementation Guide.

Variable Description
Validation: None
Destination: None

TERMS_DATE

Date that Payables uses as the payment terms start date. If you leave this value blank then the system derives the value based on the Terms Date Basis Payables option if you have provided a value for the corresponding column.

Variable Description
Validation: The value must be in a valid date format.
Destination: AP_INVOICES_ALL.TERMS_DATE

REQUESTER_ID

ID of person who requested the goods or services on the invoice. If you use Invoice Approval Workflow, then you can define rules that use this value to generate a hierarchical list of approvers for the invoice.

Variable Description
Validation: This ID must correspond to a valid, existing employee.
Destination: AP_INVOICES_ALL.REQUESTER_ID

EXTERNAL_DOC_REF

Identifier your supplier assigns to this invoice record. Payables uses this value only when it sends error notifications to the supplier for XML invoices.

Variable Description
Validation: None
Destination: None

AP_INVOICE_LINES_INTERFACE

Column Name Null Type Comments
INVOICE_ID NOT NULL NUMBER(15) Required
Validated against: AP_INVOICES_INTERFACE
INVOICE_LINE_ID   NUMBER(15) Internal ID. Required. Value provided by the AP_INVOICE_LINES_INTERFACE_S sequence. Primary key. Must be unique for the INVOICE_ID.
LINE_NUMBER   NUMBER(15) Required
LINE_TYPE_LOOKUP_CODE   VARCHAR2(25) Required
LINE_GROUP_NUMBER   NUMBER Optional
AMOUNT   NUMBER Required
ACCOUNTING_DATE   DATE N/A
DESCRIPTION   VARCHAR2(240) Optional
PRORATE_ACROSS_FLAG   VARCHAR2(1) Optional
TAX_CODE   VARCHAR2(15) Validated against: AP_TAX_CODES.NAME
FINAL_MATCH_FLAG   VARCHAR2(1) N/A
PO_HEADER_ID   NUMBER Internal ID
Validated against:
PO_HEADERS.PO_HEADER_ID
PO_NUMBER   VARCHAR2(20) Optional
Validated against: PO_HEADERS.SEGMENT1
PO_LINE_ID   NUMBER Internal ID
Validated against: PO_LINES.PO_LINE_ID
PO_LINE_NUMBER   NUMBER Optional
Validated against: PO_LINES.PO_LINE_NUM
PO_LINE_LOCATION_ID   NUMBER Internal ID
Validated against:
PO_LINE_LOCATIONS.LINE_LOCATION_ID
PO_SHIPMENT_NUM   NUMBER Optional
Validated against:
PO_LINE_LOCATIONS.SHIPMENT_NUM
PO_DISTRIBUTION_ID   NUMBER Internal ID
Validated against:
PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID
PO_DISTRIBUTION_NUM   NUMBER Optional
Validated against:
PO_DISTRIBUTIONS.PO_DISTRIBUTION_NUM
INVENTORY_ITEM_ID   NUMBER Optional
Validated against:
MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
ITEM_DESCRIPTION   VARCHAR2(240) Optional
QUANTITY_INVOICED   NUMBER Optional
SHIP_TO_LOCATION_CODE   VARCHAR2(25) N/A
UNIT_PRICE   NUMBER Optional
DISTRIBUTION_SET_ID   NUMBER(15) Internal ID
Validated against: AP_DISTRIBUTION_SETS.
DISTRIBUTION_SET_ID
DISTRIBUTION_SET_NAME   VARCHAR2(50) Optional
DIST_CODE_CONCATENATED   VARCHAR2(250) Optional
DIST_CODE_COMBINATION_ID   NUMBER(15) Internal ID
Validated against: GL_CODE_COMBINATIONS.
CODE_COMBINATION_ID
AWT_GROUP_ID   NUMBER(15) Internal ID
Validated against:
AP_AWT_GROUPS.GROUP_ID
AWT_GROUP_NAME   VARCHAR2(25) Optional
LAST_UPDATED_BY   NUMBER(15) Optional
LAST_UPDATE_DATE   DATE Optional
LAST_UPDATE_LOGIN   NUMBER(15) Optional
CREATED_BY   NUMBER(15) Optional
CREATION_DATE   DATE Optional
ATTRIBUTE CATEGORY   VARCHAR2(150) Optional
ATTRIBUTE [1-15]   VARCHAR2(150) Optional
GLOBAL_ATTRIBUTE CATEGORY   VARCHAR2(150) Optional
GLOBAL_ATTRIBUTE [1-20]   VARCHAR2(150) Optional
PO_RELEASE_ID   NUMBER Optional
Validated against: PO_RELEASES_ALL
RELEASE_NUM   NUMBER Optional
ACCOUNT_SEGMENT   VARCHAR2(25) Optional
BALANCING_SEGMENT   VARCHAR2(25) Optional
COST_CENTER_SEGMENT   VARCHAR2(25) Optional
PROJECT_ID   NUMBER(15) Internal ID Validated against: PA_PROJECTS
TASK_ID   NUMBER(15) Internal ID Validated against: PA_TASKS
EXPENDITURE_TYPE   VARCHAR2(30) Validated against: PA_EXPENDITURE_TYPES
EXPENDITURE_ITEM_DATE   DATE Validated against: PA_EXPENDITURE_TYPES
EXPENDITURE_ ORGANIZATION_ID   NUMBER(15) Validated against
PER_ORGANIZATION_UNITS.
EXPENDITURE_ORGANIZATION_ID
PA_ADDITION_FLAG   VARCHAR2(1) Projects
PA_QUANTITY   NUMBER Projects
USSGL_TRANSACTION_CODE   VARCHAR2(30) General Ledger
STAT_AMOUNT   NUMBER N/A
TYPE_1099   VARCHAR2(10) N/A
INCOME_TAX_REGION   VARCHAR2(10) N/A
ASSETS_TRACKING_FLAG   VARCHAR2(1) N/A
TAX_CODE_ID   NUMBER(15) N/A
PRICE_CORRECTION_FLAG   VARCHAR2(1) N/A
ORG_ID   NUMBER(15) Organization identifier
RECEIPT_NUMBER   VARCHAR2(30) Validated against RCV_SHIPMENT_HEADERS.RECEIPT_NUM
RECEIPT_LINE_NUMBER   VARCHAR2(25) N/A
MATCH_OPTION   VARCHAR2(25) N/A
PACKING_SLIP   VARCHAR2(25) N/A
RCV_TRANSACTION_ID   NUMBER N/A
PA_CC_AR_INVOICE_ID   NUMBER(15) Identifier of the corresponding receivable intercompany invoice in Oracle Receivables
PA_CC_AR_INVOICE_LINE_NUMBER   NUMBER(15) Identifier of the corresponding receivable intercompany invoice in Oracle Receivables
REFERENCE_1   VARCHAR2(30) Projects
REFERENCE_2   VARCHAR2(30) Projects
PA_CC_PROCESSED_CODE   VARCHAR2(1) N/A
CREDIT_CARD_TRX_ID   NUMBER(15) Credit card transaction ID if the line is a credit card charge.
AWARD_ID   NUMBER(15) Grants requirement to store award.
VENDOR_ITEM_NUM   VARCHAR(25) Optional. Validated against PO_LINES_ ALL.VENDOR_PRODUCT_NUM
TAXABLE_FLAG   VARCHAR2(1) Value of Y indicates that the line is taxable.
PRICE_CORRECT_INV_NUM   VARCHAR2(50) N/A
EXTERNAL_DOC_LINE_REF   VARCHAR2(240) Internal document reference number from Accounts Receivables system. Used for XML Invoices.
SERIAL_NUMBER   VARCHAR2(35) Serial number for item.
MANUFACTURER   VARCHAR2(30) Name of the manufacturer.
MODEL_NUMBER   VARCHAR2(40) Model information.
WARRANTY_NUMBER   VARCHAR2(15) Warranty number.
DEFERRED_ACCTG_FLAG   VARCHAR2(1) Flag that indicates whether to generate deferred accounting for this line.
DEF_ACCTG_START_DATE   DATE The start date of the deferred expense period.
DEF_ACCTG_END_DATE   DATE The end date of the deferred expense period.
DEF_ACCTG_NUMBER_OF_PERIODS   NUMBER Number of periods to generate deferred expenses. Used in combination with PERIOD_TYPE. Alternative to END_DATE.
DEF_ACCTG_PERIOD_TYPE   VARCHAR2(15) Period type used in combination with NUMBER_OF_PERIODS to generate deferred expenses. Validated against XLA_LOOKUPS with lookup type XLA_DEFERRED_PERIOD_TYPE.
UNIT_OF_MEAS_LOOKUP_CODE   VARCHAR2(25) Unit of Measure for quantity invoiced. Validated against MTL_UNITS_OF_MEASURE.UNITS_OF_MEASURE
PRICE_CORRECT_INV_LINE_NUM   NUMBER Invoice line subject to the price correction.
ASSET_BOOK_TYPE_CODE   VARCHAR2(15) Asset Book Defaults to the distributions candidate for transfer to Oracle Assets.
ASSET_CATEGORY_ID   NUMBER(15) Asset Category Defaults to the distributions candidate for transfer to Oracle Assets.
REQUESTER_ID   VARCHAR2(15) Requester identifier. Valid values from active HR employees. Validated against PER_ALL_PEOPLE_F.PERSON_ID
REQUESTER_FIRST_NAME   VARCHAR2(150) The first name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use the Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line.
REQUESTER_LAST_NAME   VARCHAR2(150) The last name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use the Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line.
REQUESTER_EMPLOYEE_NUM   VARCHAR2(30) The employee number of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use the Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line.
APPLICATION_ID   NUMBER(15) Application identifier.
PRODUCT_TABLE   VARCHAR2(30) Product source table name.
REFERENCE_KEY1   VARCHAR2(150) Primary key information that will uniquely identify a record in other products view.
REFERENCE_KEY2   VARCHAR2(150) Primary key information that will uniquely identify a record in other products view.
REFERENCE_KEY3   VARCHAR2(150) Primary key information that will uniquely identify a record in other products view.
REFERENCE_KEY4   VARCHAR2(150) Primary key information that will uniquely identify a record in other products view.
REFERENCE_KEY5   VARCHAR2(150) Primary key information that will uniquely identify a record in other products view.
PURCHASING_CATEGORY   VARCHAR2(2000) Item category concatenated segments.
PURCHASING_CATEGORY_ID   NUMBER(15) Item category unique ID
COST_FACTOR_ID   NUMBER(15) Identifier of the cost component class. Used to identify the individual buckets or component costs that make up the total cost of an item for example, direct material costs, freight costs, labor costs, production or conversion costs and so on.
COST_FACTOR_NAME   VARCHAR2(80) Cost component class name. Used to identify the individual buckets or component costs that make up the total cost of an item for example, direct material costs, freight costs, labor costs, production or conversion costs and so on.
CONTROL_AMOUNT   NUMBER Optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document.
ASSESSABLE_VALUE   NUMBER User enterable amount to be used as taxable basis.
DEFAULT_DIST_CCID   NUMBER(15) Already addressed by lines project Tax Driver: Code combination identifier of the GL account associated with the transaction line. Note that this is necessary to support the Account Method VAT feature.
PRIMARY_INTENDED_USE   VARCHAR2(30) Tax Driver: The purpose for which the product may be used. The actual use will be stored at the distribution level.
SHIP_TO_LOCATION_ID   NUMBER(15) Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched.
PRODUCT_TYPE   VARCHAR2(240) Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user.
PRODUCT_CATEGORY   VARCHAR2(240) Tax Driver: Product category.
PRODUCT_FISC_CLASSIFICATION   VARCHAR2(240) Tax Driver: Product fiscal classification.
USER_DEFINED_FISC_CLASS   VARCHAR2(240) Tax Driver: Fiscal Classification.
TRX_BUSINESS_CATEGORY   VARCHAR2(240) Tax Driver: Transactoins category assigned by user.
TAX_REGIME_CODE   VARCHAR2(30) Tax Regime Code: The set of tax rules that determines the treatment of one or more taxes administered by a tax authority.
TAX   VARCHAR2(30) A classification of a charge imposed by a government through a fiscal or tax authority.
TAX_JURISDICTION_CODE   VARCHAR2(30) Internal ID of the Tax Jurisdiction.
TAX_STATUS_CODE   VARCHAR2(30) Tax status code.
TAX_RATE_ID   NUMBER(15)) Internal identifier for tax rate effective on the invoice date.
TAX_RATE_CODE   VARCHAR2(150) Tax rate name associated with tax rate identifier. TAX_RATE_ID is unique while the TAX_RATE_CODE may have different tax rates based on date ranges.
TAX_RATE   NUMBER The rate specified for a tax status in effect for a period of time.
INCL_IN_TAXABLE_LINE_FLAG   VARCHAR2(1) Flag to indicate if the amount in the tax line is included or not in the taxable line.
SOURCE_APPLICATION_ID   NUMBER Source document application identifier.
SOURCE_ENTITY_CODE   VARCHAR2(30) Source document entity code.
SOURCE_EVENT_CLASS_CODE   VARCHAR2(30) Source document event class code.
SOURCE_TRX_ID   NUMBER Source document transaction identifier.
SOURCE_LINE_ID   NUMBER Identifier of the lowest level for which tax is calculated.
SOURCE_TRX_LEVEL_TYPE   VARCHAR2(30) Source document transaction level type.
TAX_CLASSIFICATION_CODE   VARCHAR2(30) Tax classification code.

INVOICE_ID

Enter the INVOICE_ID of the corresponding invoice in the AP_INVOICES_INTERFACE table. This value is used only to assign lines in this table to invoices in the AP_INVOICES_INTERFACE table. If this value does not match a value in AP_INVOICES_INTERFACE.INVOICE_ID, this row (invoice line record) will not be imported and it will not appear on the Open Interface Rejections Report.

Variable Description
Validation: This must match a value in AP_INVOICES_INTERFACE.INVOICE_ID or the line will not be imported.
Destination: None

INVOICE_LINE_ID

This value is not required in this table. You can enter a unique number for each invoice line of an invoice. This column is populated by the AP_INVOICE_LINES_INTERFACE_S sequence.

Variable Description
Validation: The value must be a number.
Destination: None

LINE_NUMBER

You can enter a unique number to identify the line.

Variable Description
Validation: This value should be a number.
Destination: None. The import program automatically generates the values for AP_INVOICE_DISTRIBUTIONS_ALL. DISTRIBUTION_LINE_NUMBER

LINE_TYPE_LOOKUP_CODE

Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record.

Variable Description
Validation: The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. These lookup codes are stored in the AP_LOOKUP_CODES table. AWT is not an acceptable value here.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE

LINE_GROUP_NUMBER

If you want to prorate a charge to a group of lines, enter an identical line group number value for each Item line to which you want to prorate the charge. For example, if you want to prorate tax across two Item lines, enter the same line group number for the two Item lines and the Tax line.

Variable Description
Validation: This value must be a positive whole number.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.LINE_ GROUP_NUMBER

AMOUNT

The invoice distribution amount. If you are matching to a purchase order, the AMOUNT = QUANTITY_INVOICED x UNIT PRICE.

Variable Description
Validation: If the total amount of all the invoice lines does not equal the amount of the invoice header that has the same INVOICE_ID, then Payables Open Interface Import will reject the invoice.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT

ACCOUNTING_DATE

The GL Date for the invoice distributions. The date must be in an open or future period.

During import, Payables looks for a GL Date value to assign to the invoice distribution. Payables assigns a value from the first source it finds, and it searches the following sources in the following order: line of the invoice record, header of the invoice record, GL Date parameter from import submission, GL Date Basis Payables option.

Note: The following occurs if the system searches at the GL Date Basis level: If the GL Date Basis option is set to Goods Received/Invoice Date, then Payables uses the Goods Received Date, if it is populated. If not, then Payables uses the Invoice Date. If the GL Date Basis option is set to Goods Received/System Date, then Payables uses the Goods Received Date, if it is populated. If it is not, then Payables uses the system date at time of import.

If the GL Date of an invoice is in a future period in Payables, you can account for the invoice but you cannot pay it.

Note: Note the system searches at the GL Date Basis level and the GL Date Basis option is set to Invoice Received Date, then Payables uses the Invoice Date, and if the GL Date Basis option is set to Goods Received Date, then Payables uses the system date at time of import.

Important: If you are using encumbrance accounting, you must enter a GL Date in a period that is within the latest open encumbrance year. (See also: Budgetary Control In Payables).

Variable Description
Validation: Must be in valid date format. The date must be in an open accounting period.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL. ACCOUNTING_DATE

DESCRIPTION

Enter a description that you want to assign to the invoice distribution created from this record. If you do not enter a value, and you match to a purchase order, then during import the system uses the item description on the purchase order line to populate AP_INVOICE_DISTRIBUTIONS_ALL.DESCRIPTION.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL. DESCRIPTION

PRORATE_ACROSS_FLAG

If you set this column to Y and this is a non-Item type line (Tax, Miscellaneous, or Freight), then Payables will prorate the charge to all Item type lines with the same LINE_GROUP_NUMBER as this line. If no line group number is specified, Payables will prorate the charge to all Item lines. If this column is set to N, then Payables will not prorate the cost and will create only one distribution.

Payables prorates tax for Tax type lines, freight for Freight type lines, and miscellaneous for Miscellaneous type lines. Payables creates a distribution line for each line you prorate the charge to. The system assigns the expense account of the Item line to the new invoice distribution.

Variable Description
Validation: Line type is not Item.
Destination: None

FINAL_MATCH_FLAG

If you are certain that this is a final match against the purchase order, enter Y. Once you validate a final matched invoice distribution, you cannot update the Final Match check box in the Distributions window. Since you cannot final close purchase orders when you are matching to receipts, if the invoice is matched to a receipt then import ignores any value in this column.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.FINAL_ MATCH_FLAG

PO_HEADER_ID

If you enter the record in the Quick Invoices window, then you must provide a value for this column by entering a value in the PO Number field, and you must specify the supplier.

Internal identifier for the purchase order number. To match to a purchase order you can enter either the PO_HEADER_ID or the PO_NUMBER.

Variable Description
Validation: This must be a valid value in PO_HEADERS.PO_HEADER_ID. It must be for the same supplier and cannot be final matched.
Destination: None

PO_NUMBER

Enter a purchase order number if you are matching to a purchase order. If you are matching to a purchase order, you must enter the PO_NUMBER or the PO_HEADER_ID.

If you match the invoice to a purchase order by entering a value here, then during Payables Open Interface Import the system uses purchase order information to create distributions and populate various columns in the AP_INVOICE_DISTRIBUTIONS_ALL table. If you do not specify a supplier in the AP_INVOICE_LINES_INTERFACE table, the PO_NUMBER value is used to derive AP_INVOICE_DISTRIBUTIONS_ALL.VENDOR_ID, and if you do not specify the supplier site, the PO_NUMBER value can be used to derive AP_INVOICE_DISTRIBUTIONS_ALL.VENDOR_SITE_ID. If you enter supplier information in another column and enter a value for PO_NUMBER, then the system will use the supplier on the purchase order and ignore any other supplier information you have entered.

Variable Description
Validation: This must be a valid purchase order number for the same supplier, and the purchase order cannot be final matched or inactive. If you specified a purchase order in AP_INVOICES_INTERFACE, it must match this purchase order number. The match option for the purchase order shipment must be set to purchase order.
Destination: None. This value is used to enter AP_INVOICES_ALL.PO_HEADER_ID.

PO_LINE_ID

Internal identifier for the purchase order line number. If you are matching to a purchase order line you can enter either the PO_LINE_ID or the PO_LINE_NUMBER.

Variable Description
Validation: This must be a valid value for PO_LINES.PO_LINE_ID.
Destination: None

PO_LINE_NUMBER

If you want to match to a purchase order line, enter a value for PO_LINE_NUMBER or PO_LINE_ID.

Alternatively, you can identify a purchase order line number by entering only an ITEM_ID or an ITEM_DESCRIPTION. If you do this, the value you enter must exactly match the ITEM_ID or ITEM_DESCRIPTION of exactly one purchase order line for the PO_NUMBER. For example, you can match to a line by entering the ITEM_DESCRIPTION "books" for an invoice that has exactly one line with an ITEM_DESCRIPTION of "books".

Variable Description
Validation: This must be a valid value for PO_LINES.PO_LINE_NUM.
Destination: None

PO_LINE_LOCATION_ID

Internal identifier for purchase order shipment.

Variable Description
Validation: This must be a valid value in PO_LINE_LOCATIONS.LINE_LOCATION_ID for the purchase order. PO shipment cannot be finally closed.
Destination: None

PO_SHIPMENT_NUM

Number of the purchase order shipment. If you are matching to a purchase order shipment, enter a value for either PO_SHIPMENT_NUM or PO_LINE_LOCATION_ID.

Alternatively, you can enter a value for SHIP_TO_LOCATION_CODE if exactly one shipment on the purchase order has the SHIP_TO_LOCATION_CODE you specify. For example, you enter a SHIP_TO_LOCATION_CODE of "Taipei" for a purchase order with exactly one shipment with the location value of "Taipei".

Variable Description
Validation: This must be a valid value for PO_LINE_LOCATIONS.SHIPMENT_NUM. PO shipment cannot be finally closed.
Destination: None

PO_DISTRIBUTION_ID

Internal identifier for purchase order distribution number. If you are matching to a purchase order distribution you can enter a value for PO_DISTRIBUTION_ID or PO_DISTRIBUTION_NUM.

Variable Description
Validation: This must be a valid value in INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ ID
Destination: None

PO_DISTRIBUTION_NUM

Purchase order distribution number. If you are matching to a distribution, you must enter a value for PO_DISTRIBUTION_NUM or PO_DISTRIBUTION_ID.

Variable Description
Validation: Value must match a distribution number on the purchase order and must be a valid value for PO_DISTRIBUTIONS.PO_DISTRIBUTION_NUM.
Destination: None

INVENTORY_ITEM_ID

Inventory item identifier on the purchase order. Used during purchase order matching.

If you have limited purchase order information, you can enter an inventory item number, and the system will attempt to match the invoice to a purchase order line. For example, a supplier has one purchase order for PCs, that includes a single line for monitors. If you want to match to the line with monitors and you don't know the purchase order number, enter the proper INVENTORY_ITEM_ID for the monitors. The system will match to the correct purchase order line for the monitors during import.

Variable Description
Validation: This value must match the purchase order MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID for exactly one line.
Destination: None

ITEM_DESCRIPTION

Exact description of the item on the purchase order. Used during purchase order line matching.

If you have limited purchase order information, you can enter a description in the column, and the system will attempt to match the invoice to a purchase order line. For example, if a purchase order has one line for books and one line for software, but you don't know the line number, you can enter the exact description for the books, and the system will match to the correct purchase order line.

Variable Description
Validation: The description must match PO_LINES.ITEM_DESCRIPTION.
Destination: None

QUANTITY_INVOICED

Number of units invoiced. Used for purchase order matching. For example if there are 5 chairs on the invoice, enter 5. If you enter a value for UNIT_PRICE and do not enter a value for QUANTITY_INVOICED, the system will derive a value for QUANTITY_INVOICED during Payables Open Interface Import (QUANTITY_INVOICED = AMOUNT / UNIT PRICE).

If the Invoice Match option on the purchase order shipment is Receipt, Import reviews all receipts that have unbilled quantities for the purchase order shipment. Import then matches the billed quantity on the invoice to these receipts starting with the oldest receipt that has an unbilled quantity. Import then fills each unbilled receipt quantity up to the amount of the invoice billed quantity. If the invoice quantity exceeds all available unbilled receipt quantities for the purchase order shipment, import overbills the newest unbilled quantity by the remaining amount.

Variable Description
Validation: This value must be a positive number if AMOUNT for this line is positive, and a negative number if AMOUNT is negative.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.QUANTITY_INVOICED

SHIP_TO_LOCATION_CODE

If you want to match to a purchase order shipment and have not entered a value for either PO_SHIPMENT_NUM or PO_LINE_LOCATION_ID, you can enter a value for SHIP_TO_LOCATION_CODE if exactly one shipment on the purchase order has the SHIP_TO_LOCATION_CODE you specify. For example, you enter a SHIP_TO_LOCATION_CODE of "Taipei" for a purchase order with exactly one shipment with the value "Taipei".

Variable Description
Validation: This must be an existing, active value for PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID
Destination: None

UNIT_PRICE

Unit price of the distribution line item(s). Used for purchase order matching. If you enter a value for UNIT_PRICE and do not enter a value for QUANTITY_INVOICED, the system will derive a value for QUANTITY_INVOICED during Payables Open Interface Import (QUANTITY_INVOICED = AMOUNT / UNIT PRICE).

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.UNIT_ PRICE

DISTRIBUTION_SET_ID

Internal identifier for the Distribution Set. If you enter a value for DISTRIBUTION_SET_NAME or DISTRIBUTION_SET_ID, then during import Payables automatically creates distributions for you based on the Distribution Set.

Do not enter a value here if you are matching this line to a purchase order, if you are prorating, or if you enter an account.

Variable Description
Validation: This must be an existing, active value for AP_DISTRIBUTION_SETS.DISTRIBUTION_SET_ ID
Destination: None

DISTRIBUTION_SET_NAME

Name of the Distribution Set. You define Distribution Sets in the Distribution Sets window. If you enter a Distribution Set name, then during Payables Open Interface Import, Payables automatically creates distributions for you based on the Distribution Set. If you enter a value here, you do not need to enter the corresponding value for DISTRIBUTION_SET_ID.

Do not enter a value in this column if you are matching to a purchase order, if you are prorating, or if you provide an account.

Variable Description
Validation: This must be an existing, active value for AP_DISTRIBUTION_SETS.DISTRIBUTION SET_NAME. If you are matching to a purchase order and you enter a value in this column, Payables Open Interface Import will reject the invoice.
Destination: None

DIST_CODE_CONCATENATED

The GL account to which the distribution amount will be charged.

For information on how Payables Open Interface Import builds an account based on the value you enter here, see: Account Overlay in Payables Open Interface Import.

Variable Description
Validation: The account code combination must be valid and in the exact flexfield structure you have defined for your Set of Books, and must match a value for GL_CODE_COMBINATIONS.CODE_ COMBINATION_ID.
Destination: None. This value may be used to enter a value for AP_INVOICE_DISTRIBUTIONS_ALL.DIST_ CODE_COMBINATION_ID

DIST_CODE_COMBINATION_ID

Internal identifier for GL account to which the distribution amount will be charged.

If you enter Projects information in the Quick Invoices, the Quick Invoices window will automatically build the account for you. If you enter records in any way other than the Quick Invoices window, you must provide this value.

For information on how Payables Open Interface Import builds an account based on the value you enter here, see: Account Overlay in Payables Open Interface Import.

Variable Description
Validation: The account code combination must be valid and in the exact flexfield structure you have defined for your Set of Books.
Destination: AP_INVOICES_ALL.DIST_CODE_ COMBINATION_ID

AWT_GROUP_ID

Internal identifier associated with the automatic withholding tax group name. If you want to assign a withholding tax group to the line, you do not need to enter a value here if you enter a value for AWT_GROUP_NAME.

Variable Description
Validation: This must be a valid, active value in AP_AWT_GROUPS.GROUP_ID
Destination: None

AWT_GROUP_NAME

Automatic withholding tax group name. When you enter a withholding tax group for a line, then all the withholding taxes in the group are applied to the line. You define automatic withholding tax group names in the Withholding Tax Groups window. If you do not enter a value for this column, then during Payables Open Interface Import the system will use the value you entered for AP_INVOICES_INTERFACE.AWT_GROUP_NAME. If you did not enter a value, then the system uses the supplier site value if there is one.

Variable Description
Validation: This must be a valid, active value in AP_AWT_GROUPS.NAME
Destination: None

LAST_UPDATED_BY

Enter the ID of the person who last updated this record (usually the same value as CREATED_BY).

If you do not enter a value here, then during Payables Open Interface Import the system will use the userid of the person who submits Payables Open Interface Import.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.LAST_ UPDATED_BY

LAST_UPDATE_DATE

Enter the last update date for this record (usually the same date as CREATION_DATE). Payables uses this date for reference and audit purposes only. When the import program creates an invoice from a record in this table, it does not use this date as the last update date for the invoice; it uses the system date at the time you submit Payables Open Interface Import.

Variable Description
Validation: Must be in valid date format.
Destination: None

LAST_UPDATE_LOGIN

The last update date for this record. Usually the same date as the CREATION_DATE. If you enter a value in this column, the system uses it to populate AP_INVOICE_DISTRIBUTIONS_ALL.AP_LAST_ UPDATE_LOGIN. If you do not enter a value, then during Payables Open Interface Import, the system will use the system date.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.AP_LAST_UPDATE_LOGIN

CREATED_BY

Enter the userid of the person or organization who loads this record into the table. Payables Open Interface Import transfers this userid to the AP_INVOICE_DISTRIBUTIONS_ALL table during import so that the creator of the record becomes the invoice and scheduled payment creator. If you do not enter a value, then during import the system will use the userid of the person who submits Payables Open Interface Import.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.CREATED_BY

CREATION_DATE

Enter the date on which you load this record into the table. Payables uses this date for reference and audit purposes. When Payables Open Interface Import creates an invoice from this record, it does not use this date as the creation date for the invoice distributions; it uses the system date at the time you submit Payables Open Interface Import.

Variable Description
Validation: Must be in valid date format.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.CREATION_DATE

ATTRIBUTE_CATEGORY

Enter the Descriptive Flexfield category for the Descriptive Flexfield information you want to import for an invoice distribution.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.ATTRIBUTE_CATEGORY

ATTRIBUTE [1-15]

Enter Descriptive Flexfield information that you want to import for an invoice distribution. The structure of the information you enter in these columns (datatypes, value sets) must match the structure of the Descriptive Flexfield segments you have defined for your invoice distributions or you will experience validation problems when you try to access the information in the invoice windows.

If you are using a Distribution Set that has a descriptive flexfield, any data you enter here will overwrite the descriptive flexfield on the Distribution Set.

If a line is purchase order matched and the Transfer PO Descriptive Flexfield Information Payables option is enabled, then import uses the purchase order values for any corresponding open interface attribute columns that are null. However, if you enter data for any open interface attribute then that value will be used on the invoice instead of the purchase order value.

If the Transfer PO Descriptive Flexfield Information Payables option is disabled, then the purchase order flexfield values are ignored during import.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.ATTRIBUTE [1-15]

GLOBAL_ATTRIBUTE_CATEGORY

Enter the Descriptive Flexfield category for the descriptive flexfield information you want to import.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.GLOBAL_ ATTRIBUTE_CATEGORY

GLOBAL ATTRIBUTE [1-20]

Enter descriptive flexfield information that you want to import for an invoice. The structure of the information you enter in these columns (datatypes, value sets) must match the structure of the descriptive flexfield segments you have defined for your invoices or you will experience validation problems when you try to access the information in the invoice windows.

Variable Description
Validation: If you are using a localization, you must enter appropriate values in this flexfield or the invoice will be rejected by import. For more information, see your localization user's guide.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.GLOBAL_ ATTRIBUTE[1-20]

PO_RELEASE_ID

Internal identifier for a purchase order release number. If you want to match to a blanket purchase order you must supply either the RELEASE_NUM or the PO_RELEASE_ID, and provide a shipment number. You can also optionally provide a line number.

Variable Description
Validation: This value must match a valid value in PO_RELEASES.PO_RELEASE_ID.
Destination: None

RELEASE_NUM

Release number of a blanket purchase order. Used during purchase order matching. If you want to match to a blanket purchase order you must supply either the RELEASE_NUM or the PO_RELEASE_ID.

Variable Description
Validation: This value must match a valid value in PO_RELEASES.RELEASE_NUM.
Destination: None

ACCOUNT_SEGMENT

If you want to override the account segment in the account for this line, enter a value here. Payables will override the account segment with this value during import. See: Account Overlay in Payables Open Interface Import.

Variable Description
Validation: The new account code must be valid.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.CODE_ COMBINATION_ID

BALANCING_SEGMENT

If you want to override the balancing segment in the account, enter a value here. Payables will override the balancing segment with this value during import. See: Account Overlay in Payables Open Interface Import.

Variable Description
Validation: The account code must be valid.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.CODE_ COMBINATION_ID

COST_CENTER_SEGMENT

If you want to override the cost center in the account, enter a value here. Payables will override the cost center with this value during import. See: Account Overlay in Payables Open Interface Import.

Variable Description
Validation: The account code must be valid.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.CODE_ COMBINATION_ID

Projects Columns

Enter project information from Oracle Projects in the following columns if you want to associate the invoice distribution (created from this record) with a project in Oracle Projects. If Projects is installed and you provide information for the projects columns, then Projects will build the expense account based on this information.

If the invoice is matched to a purchase order and the purchase order has project related information, then during import Payables automatically populates the Projects related columns in AP_INVOICES and AP_INVOICE_DISTRIBUTIONS_ALL.

In addition, Oracle Projects uses the following columns to transfer invoice data:

USSGL_TRANSACTION_CODE

Enter the default transaction code you want to assign to an invoice.

Open Interface Import imports any USSGL information that you load into the interface tables and assigns the information to the invoices it creates.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.USSGL_ TRANSACTION_CODE

STAT_AMOUNT

Statistical quantity based on the unit of measure. For example, if your unit of measure is barrels, you can enter the number of barrels here. See also: Invoice Distribution Statistics in Oracle General Ledger.

Variable Description
Validation: You must also enter a valid value for PO_UNIT_OF_MEASURE.
Destination: AP_INVOICES_DISTRIBUTIONS_ALL.STAT_ AMOUNT

TYPE_1099

Income tax type, for a United States 1099 reportable supplier. You define a supplier as federally reportable by enabling the Federal option in the Suppliers window. Enter a 1099 Miscellaneous Tax Type.

See:Entering Invoices for Suppliers Subject to Income Tax Reporting Requirements, Oracle Payables User Guide

If you leave this value null and match to a purchase order, then this value always defaults from the purchase order (even if that value is null and the supplier now has a value).

For unmatched invoices, if you do not use a Distribution Set to create invoice distributions, Payables uses the supplier's income tax type as the default value. If you use a Distribution Set to create invoice distributions, Payables uses the default income tax type from the Distribution Set as the default value. You can enter this field regardless of whether the supplier is defined as a 1099 supplier. Payables uses this information when you submit the 1099 Payments Report and the 1099 Form Reports. See also: 1099 Reporting Overview, Oracle Payables User Guide.

You can update this field of the imported invoice in the Distributions window even after you have accounted for a distribution. You can use the Update Income Tax Details Utility to make adjustments to many distributions at once. See: Update Income Tax Details Utility and Report, Oracle Payables User Guide.

Variable Description
Validation: The value must be a valid and active value in the AP_INCOME_TAX_TYPES table (MISC types 1-14, except MISC9, MISC11 and MISC12), and the supplier for this record must be defined as federally reportable.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.TYPE_1099

INCOME_TAX_REGION

If the supplier is a 1099 supplier, enter the supplier's reporting region. If you do not enter a value, and you have enabled the Use Pay Site Tax Region Payables option, then during import the system uses the income tax region of the supplier site. If you do not enter a value and you have instead entered a value for the Income Tax Region Payables option, then during import the system will use that value as the default.

Variable Description
Validation: You must also enter a value for INCOME_TAX_TYPE.
Destination: AP_INVOICES_DISTRIBUTIONS.INCOME_TAX_REGION

ASSETS_TRACKING_FLAG

Enter Y if the invoice distribution should be imported into Oracle Assets using the Create Mass Additions for Assets program. If you do not enter a value, and the line has an Asset type account entered for it, then Payables will automatically set this value to Y during import.

Variable Description
Validation: The account must be set up as an existing asset category, and it must be either an asset clearing account or a construction-in-progress (CIP) clearing account.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.ASSETS_ TRACKING_FLAG

PRICE_CORRECTION_FLAG

Use a price correction when a supplier sends an invoice for a change in unit price for an invoice that you have matched to a purchase order. You record a price correction by entering a Standard or Credit invoice, setting this flag to Y, and entering the base-matched invoice in the PRICE_CORRECT_INV_NUM column.

Payables records and updates the invoiced unit price of previously matched purchase order shipment or distributions without adjusting the quantity billed so you can track price variances. Payables also updates the amount billed on the originally matched purchase order distributions.

See also: Price Corrections, Oracle Payables User Guide.

Variable Description
Validation: None
Destination: None

ORG_ID

Organization identifier.

Variable Description
Validation: None
Destination: None

RECEIPT_NUMBER

If you are matching to a purchase order receipt, then enter the receipt number.

Variable Description
Validation: A purchase order and receipt for the same supplier, supplier site, and currency as the invoice you are entering must be approved and open. Also, the Invoice Match option for the purchase order shipment you are matching to is set to Receipt.
Destination: This value is used to enter: AP_INVOICE_DISTRIBUTIONS_ALL. RCV_TRANSACTION_ID

RECEIPT_LINE_NUMBER

If you are matching to a purchase order receipt, then you can specify the receipt line you are matching to.

Variable Description
Validation: A purchase order and receipt for the same supplier, supplier site, and currency as the invoice you are entering must be approved and open. Also, the Invoice Match option for the purchase order shipment you are matching to is set to Receipt. This must be a valid line number for the receipt.
Destination: None

MATCH_OPTION

Indicates if a match is to a purchase order or receipt. When you match to a purchase order or receipt in the Quick Invoices window, then the system populates this field based on the value of the purchase order shipment.

Variable Description
Validation: The value must match the value specified in PO_SHIPMENTS.MATCH_OPTION.
Destination: None

PACKING_SLIP

This column is not currently used.

Variable Description
Validation: None
Destination: None

RCV_TRANSACTION_ID

This value specifies a receipt record for matching. This value is used to match Oracle e-Commerce Gateway invoices to receipts.

Variable Description
Validation: This value must be a valid, existing value for RCV_TRANSACTIONS. RCV_TRANSACTION_ID
Destination: AP_INVOICE_DISTRIBUTIONS_ALL. RCV_TRANSACTION_ID

PA_CC_AR_INVOICE_ID

Identifier of the corresponding receivable intercompany invoice in Oracle Receivables

Variable Description
Validation: None
Destination: None

PA_CC_AR_INVOICE_LINE_NUM

Line number of the corresponding receivable intercompany invoice in Oracle Receivables

Variable Description
Validation: None
Destination: None

REFERENCE_1 - 2

These columns references records in another application

Variable Description
Validation: None
Destination: None

PA_CC_PROCESSED_CODE

This column indicates the processing status of this invoice line by Oracle Projects in the Receiver Operating Unit.

Variable Description
Validation: None
Destination: None

TAX_CODE_ID

Internal identifier for the tax code. You can enter a value for either the TAX_CODE or TAX_CODE_ID.

Variable Description
Validation: This must be a valid value for AP_TAX_CODES_ALL.TAX_ID. Further validations are the same as those for TAX_CODE.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.TAX_CODE_ID

CREDIT_CARD_TRX_ID

This column is populated when credit card transactions for expense reports entered in Oracle Internet Expenses are imported to Payables.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.CREDIT_ CARD_TRX_ID

AWARD_ID

This value is used only if you use Oracle Grants Management.

Variable Description
Validation: None
Destination: AP_INVOICE_DISTRIBUTIONS_ALL. AWARD_SET_ID

VENDOR_ITEM_NUM

Supplier item number on the purchase order. Used during purchase order matching. If you have limited purchase order information, you can enter a supplier item number in the column and the system will attempt to match the invoice to a purchase order line.

Variable Description
Validation: This value must match a valid value in PO_LINES_ALL.VENDOR_PRODUCT_NUM for exactly one line.
Destination: None

TAXABLE_FLAG

Y indicates that the line is taxable. Import uses this value for invoices from XML Gateway

Variable Description
Validation: None
Destination: None

PRICE_CORRECT_INV_NUM

If you have set the PRICE_CORRECTION_FLAG to Y to indicate that this is a price correction, then you must enter the number of the base-matched invoice here. For more information, see: Price Corrections, Oracle Payables User Guide.

Variable Description
Validation: This value must be a valid purchase order matched invoice with a type of either Standard or Mixed. You must provide sufficient purchase order information for the system to identify the purchase order amount that you want to update.
Destination: We use this to derive AP_INVOICE_DISTRIBUTIONS.PRICE_CORRECT_INV_ID

EXTERNAL_DOC_LINE_REF

This column is an internal document reference number from Accounts Receivables system. Used for XML invoices.

Variable Description
Validation: None
Destination: None

SERIAL_NUMBER

This column is the serial number for an item.

Variable Description
Validation: None
Destination: None

MANUFACTURER

This column is the name of the manufacturer.

Variable Description
Validation: None
Destination: None

MODEL_NUMBER

This column is the model information.

Variable Description
Validation: None
Destination: None

WARRANTY_NUMBER

This column is a warranty number.

Variable Description
Validation: None
Destination: None

DEFERRED_ACCTG_FLAG

This column is a flag that indicates whether to generate deferred accounting for this line.

Variable Description
Validation: None
Destination: None

DEF_ACCTG_START_DATE

This column is the start date of the deferred expense period.

Variable Description
Validation: None
Destination: None

DEF_ACCTG_END_DATE

This column is the end date of the deferred expense period.

Variable Description
Validation: None
Destination: None

DEF_ACCTG_NUMBER_OF_PERIODS

This column is the number of periods to generate deferred expenses. Used in combination with PERIOD_TYPE. Alternative to END_DATE

Variable Description
Validation: None
Destination: None

DEF_ACCTG_PERIOD_TYPE

This column is the period type used in combination with NUMBER_OF_PERIODS to generate deferred expenses.

Variable Description
Validation: XLA_LOOKUPS with lookup type XLA_DEFERRED_PERIOD_TYPE
Destination: None

UNIT_OF_MEAS_LOOKUP_CODE

This column is the Unit of Measure for quantity invoiced.

Variable Description
Validation: MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE
Destination: None

PRICE_CORRECT_INV_LINE_NUM

This column is the invoice line subject to the price correction.

Variable Description
Validation: None
Destination: None

ASSET_BOOK_TYPE_CODE

This column is the Asset Book Defaults to the distributions candidate for transfer to Oracle Assets

Variable Description
Validation: None
Destination: None

ASSET_CATEGORY_ID

This column is the Asset Category Defaults to the distributions candidate for transfer to Oracle Assets

Variable Description
Validation: None
Destination: None

REQUESTER_ID

This column is the Requester identifier. Valid values from active HR employees.

Variable Description
Validation: PER_ALL_PEOPLE_F.PERSON_ID
Destination: None

REQUESTER_FIRST_NAME

This column is the first name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use therequester ID to generate a hierarchical list of approvers for the line

Variable Description
Validation: None
Destination: None

REQUESTER_LAST_NAME

This column is the last name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use therequester ID to generate a hierarchical list of approvers for the line

Variable Description
Validation: None
Destination: None

REQUESTER_EMPLOYEE_NUM

This column is the employee number of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use therequester ID to generate a hierarchical list of approvers for the line

Variable Description
Validation: None
Destination: None

APPLICATION_ID

This column is the Application Identifier

Variable Description
Validation: None
Destination: None

PRODUCT_TABLE

This column is the Product source table name,

Variable Description
Validation: None
Destination: None

REFERENCE_KEY1 - 5

These columns are primary keys that will uniquely identify a record in other products view

Variable Description
Validation: None
Destination: None

PURCHASING_CATEGORY

This column is the item category concatenated segments

Variable Description
Validation: None
Destination: None

PURCHASING_CATEGORY_ID

This column is the item category unique identifier

Variable Description
Validation: None
Destination: None

COST_FACTOR_ID

This column is the identifier of the cost component class. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on.

Variable Description
Validation: None
Destination: None

COST_FACTOR_NAME

This column is the cost component class name. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on.

Variable Description
Validation: None
Destination: None

CONTROL_AMOUNT

This column is an optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document.

Variable Description
Validation: None
Destination: None

ASSESSABLE_VALUE

This column is the user-enterable amount to be used as taxable basis

Variable Description
Validation: None
Destination: None

DEFAULT_DIST_CCID

This column is a Tax Driver. It is a code combination identifier of the GL account associated with the transaction line. Note that this is necessary to support the Account Method VAT feature.

Variable Description
Validation: None
Destination: None

PRIMARY_INTENDED_USE

This column is a Tax Driver. It is the purpose for which a product may be used. The actual use will be stored at the distribution level.

Variable Description
Validation: None
Destination: None

SHIP_TO_LOCATION_ID

This column is a Tax Driver. It is the ship to location ID. Value entered by user only if line is not PO matched.

Variable Description
Validation: None
Destination: None

PRODUCT_TYPE

This column is a Tax Driver. It is the type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user.

Variable Description
Validation: None
Destination: None

PRODUCT_CATEGORY

This column is a Tax Driver. It is a product category.

Variable Description
Validation: None
Destination: None

PRODUCT_FISC_CLASSIFICATION

This column is a Tax Driver. It is a Product Fiscal Classification.

Variable Description
Validation: None
Destination: None

USER_DEFINED_FISC_CLASS

This column is a Tax Driver. It is a Fiscal Classification.

Variable Description
Validation: None
Destination: None

TRX_BUSINESS_CATEGORY

This column is a Tax Driver. It is a transactions category assigned by user.

Variable Description
Validation: None
Destination: None

TAX_REGIME_CODE

This column is a Tax Regime Code. The set of tax rules that determines the treatment of one or more taxes administered by a tax authority. e.g., VAT Regime in Argentina.

Variable Description
Validation: None
Destination: None

TAX

This column is a classification of a charge imposed by a government through a fiscal or tax authority.

Variable Description
Validation: None
Destination: None

TAX_JURISDICTION_CODE

This column is the Internal ID of the Tax Jurisdiction

Variable Description
Validation: None
Destination: None

TAX_STATUS_CODE

This column is the Tax status code. e.g., taxable standard rate, zero rated, exempt, non-taxable.

Variable Description
Validation: None
Destination: None

TAX_RATE_ID

This column is the Internal identifier for tax rate effective on the invoice date

Variable Description
Validation: None
Destination: None

TAX_RATE_CODE

This column is the tax rate name associated with tax rate identifier. Tax_rate_id is unique while a tax_rate_code may have different tax rates based on date ranges.

Variable Description
Validation: None
Destination: None

TAX_RATE

This column is the rate specified for a tax status in effect for a period of time.

Variable Description
Validation: None
Destination: None

INCL_IN_TAXABLE_LINE_FLAG

This column is the flag to indicate if the amount in the tax line is included or not in the taxable line.

Variable Description
Validation: None
Destination: None

SOURCE_APPLICATION_ID

This column is the source document application identifier

Variable Description
Validation: None
Destination: None

SOURCE_ENTITY_CODE

This column is the source document entity code

Variable Description
Validation: None
Destination: None

SOURCE_EVENT_CLASS_CODE

This column is the source document event class code

Variable Description
Validation: None
Destination: None

SOURCE_TRX_ID

This column is the source document transaction identifier

Variable Description
Validation: None
Destination: None

SOURCE_LINE_ID

This column is the identifier of the lowest level for which Tax is calculated

Variable Description
Validation: None
Destination: None

SOURCE_TRX_LEVEL_TYPE

This column is the source document transaction level type

Variable Description
Validation: None
Destination: None

TAX_CLASSIFICATION_CODE

This column is the Tax Classification Code

Variable Description
Validation: None
Destination: None

AP_SUPPLIERS_INT

Column Name Null Type Comments
VENDOR_INTERFACE_ID NOT NULL NUMBER(15) Required
VENDOR_NAME   VARCHAR2(240) Required
VENDOR_NAME_ALT   VARCHAR2(320) N/A
SEGMENT1   VARCHAR2(30) Conditionally required
SUMMARY_FLAG   VARCHAR2(1) N/A
ENABLED_FLAG   VARCHAR(1) Column used by Oracle Purchasing
EMPLOYEE_ID   NUMBER N/A
VENDOR_TYPE_LOOKUP_CODE   VARCHAR2(30) N/A
CUSTOMER_NUM   VARCHAR2(25) N/A
ONE_TIME_FLAG   VARCHAR2(1) N/A
MIN_ORDER_AMOUNT   NUMBER N/A
SHIP_TO_LOCATION_ID   NUMBER N/A
SHIP_TO_LOCATION_CODE   VARCHAR2(60) N/A
BILL_TO_LOCATION_ID   NUMBER N/A
BILL_TO_LOCATION_CODE   VARCHAR2(60) N/A
SHIP_VIA_LOOKUP_CODE   VARCHAR2(25) N/A
FREIGHT_TERMS_LOOKUP_CODE   VARCHAR2(25) N/A
FOB_LOOKUP_CODE   VARCHAR2(25) N/A
TERMS_ID   NUMBER N/A
TERMS_NAME   VARCHAR2(50) N/A
SET_OF_BOOKS_ID   NUMBER N/A
ALWAYS_TAKE_DISC_FLAG   VARCHAR2(1) N/A
PAY_DATE_BASIS_LOOKUP_CODE   VARCHAR2(25) Required but will default
PAY_GROUP_LOOKUP_CODE   VARCHAR2(25) N/A
PAYMENT_PRIORITY   NUMBER Required but will default
INVOICE_CURRENCY_CODE   VARCHAR2(15) N/A
PAYMENT_CURRENCY_CODE   VARCHAR2(15) N/A
INVOICE _AMOUNT_LIMIT   NUMBER N/A
HOLD_ALL_PAYMENTS_FLAG   VARCHAR2(1) N/A
HOLD_FUTURE_PAYMENTS_FLAG   VARCHAR2(1) N/A
HOLD_REASON   VARCHAR2(240) N/A
DISTRIBUTION_SET_ID   NUMBER N/A
DISTRIBUTION_SET_NAME   VARCHAR2(50) N/A
ACCTS_PAY_CODE_COMBINATION_ID   NUMBER N/A
PREPAY_CODE_COMBINATION_ID   NUMBER N/A
NUM_1099   VARCHAR2(30) N/A
TYPE_1099   VARCHAR2(10) N/A
ORGANIZATION_TYPE_LOOKUP_CODE   VARCHAR2(25) N/A
VAT_CODE   VARCHAR2(15) N/A
START_DATE_ACTIVE   DATE N/A
END_DATE_ACTIVE   DATE N/A
MINORITY_GROUP_LOOKUP_CODE   VARCHAR2(25) N/A
PAYMENT_METHOD_LOOKUP_CODE   VARCHAR2(25) Required but will default
WOMEN_OWNED_FLAG   VARCHAR2(1) N/A
SMALL_BUSINESS_FLAG   VARCHAR2(1) N/A
STANDARD_INDUSTRY_CLASS   VARCHAR2(25) N/A
HOLD_FLAG   VARCHAR2(1) N/A
PURCHASING_HOLD_REASON   VARCHAR2(240) N/A
HOLD_BY   NUMBER(9) N/A
HOLD_DATE   DATE N/A
TERMS_DATE_BASIS   VARCHAR2(25) Required but will default
INSPECTION_REQUIRED_FLAG/RECEIPT_REQUIRED_FLAG   VARCHAR2(1) N/A
QTY_RCV_TOLERANCE   NUMBER(25) Column used by Oracle Purchasing
QTY_RCV_EXCEPTION_CODE   VARCHAR2(25) Column used by Oracle Purchasing
ENFORCE_SHIP_TO_LOCATION_CODE   VARCHAR2(25) Column used by Oracle Purchasing
DAYS_EARLY_RECEIPT_ALLOWED   NUMBER Column used by Oracle Purchasing
DAYS_LATE_RECEIPT_ALLOWED   NUMBER Column used by Oracle Purchasing
RECEIPT_DAYS_EXCEPTION_CODE   VARCHAR2 Column used by Oracle Purchasing
RECEIVING_ROUTING_ID   NUMBER Column used by Oracle Purchasing
ALLOW_SUBSTITUTE_RECEIPTS_FLAG   VARCHAR2(1) Column used by Oracle Purchasing
ALLOW_UNORDERED_RECEIPTS_FLAG   VARCHAR2(1) Column used by Oracle Purchasing
HOLD_UNMATCHED_INVOICES_FLAG   VARCHAR2(1) N/A
EXCLUSIVE_PAYMENT_FLAG   VARCHAR2(1) N/A
AP_TAX_ROUNDING_RULE   VARCHAR2(1) N/A
AUTO_TAX_CALC_FLAG   VARCHAR2(1) N/A
AUTO_TAX_CALC_OVERRIDE   VARCHAR2(1) N/A
AMOUNT_INCLUDES_TAX_FLAG   VARCHAR2(1) N/A
TAX_VERIFICATION_DATE   DATE N/A
NAME_CONTROL   VARCHAR2(4) N/A
STATE_REPORTABLE_FLAG   VARCHAR2(1) N/A
FEDERAL_REPORTABLE_FLAG   VARCHAR2(1) N/A
ATTRIBUTE_CATEGORY   VARCHAR2(30) N/A
ATTRIBUTES (1-15)   VARCHAR2(150) N/A
VAT_REGISTRATION_NUM   VARCHAR2(20) N/A
AUTO_CALCULATE_INTEREST_FLAG   VARCHAR2(1) N/A
EXCLUDE_FREIGHT_FROM_DISCOUNT   VARCHAR2(1) N/A
TAX_REPORTING_NAME   VARCHAR2(80) N/A
ALLOW_AWT_FLAG   VARCHAR2(1) N/A
AWT_GROUP_ID   NUMBER(15) N/A
AWT_GROUP_NAME   VARCHAR2(25) N/A
GLOBAL_ATTRIBUTES (1-20)   VARCHAR2(150) N/A
GLOBAL_ATTRIBUTE_CATEGORY   VARCHAR2(30) N/A
EDI_TRANSACTION_HANDLING   VARCHAR2(25) N/A
EDI_PAYMENT_METHOD   VARCHAR2(25) N/A
EDI_PAYMENT_FORMAT   VARCHAR2(25) N/A
EDI_REMITTANCE_METHOD   VARCHAR2(25) N/A
EDI_REMITTANCE_INSTRUCTION   VARCHAR(256) N/A
BANK_CHARGE_BEARER   VARCHAR2(1) Conditionally required
MATCH_OPTION   VARCHAR2(1) Required but will default
FUTURE_DATED_PAYMENT_CCID   NUMBER(15) N/A
CREATE_DEBIT_MEMO_FLAG   VARCHAR2(25) N/A
OFFSET_TAX_FLAG   VARCHAR2(1) N/A
STATUS   VARCHAR2(30) N/A
REJECT_CODE   VARCHAR2(2000) N/A
ECE_TO_LOCATION_CODE   VARCHAR2(60) Trading partner location code for e-Commerce Gateway
IBY_BANK_CHARGE_BEARER   VARCHAR2(30) Bearer of bank charge cost.
BANK_INSTRUCTION1_CODE   VARCHAR2(30) Code of first bank instruction
BANK_INSTRUCTION2_CODE   VARCHAR2(30) Code of second bank instruction
BANK_INSTRUCTION_DETAILS   VARCHAR2(255) Additional bank instruction details
PAYMENT_REASON_CODE   VARCHAR2(30) Payment reason code.
PAYMENT_REASON_COMMENTS   VARCHAR2(240) Fee text field available for entering a reason.
PAYMENT_TEXT_MESSAGE1   VARCHAR2(150) Text message for use in payment processing.
PAYMENT_TEXT_MESSAGE2   VARCHAR2(150) Text message for use in payment processing.
PAYMENT_TEXT_MESSAGE3   VARCHAR2(150) Text message for use in payment processing.
DELIVERY_CHANNEL_CODE   VARCHAR2(30) Default delivery channel code.
PAYMENT_FORMAT_CODE   VARCHAR2(150) Default delivery channel code.
SETTLEMENT_PRIORITY   VARCHAR2(30) Priority for payments.
PAYMENT_METHOD_CODE   VARCHAR2(30) Settlement payment method identifier.

VENDOR_INTERFACE_ID

This is the unique identifier for records in this table. A value is required in this column and should be derived from AP_SUPPLIERS_INT_S.

Variable Description
Validation: N/A
Destination: None

VENDOR_NAME

This is the unique name used to identify the supplier. You must provide a value for this column.

Variable Description
Validation: Check perfomed for duplicates against PO_VENDORS.VENDOR_NAME.
Destination: PO_VENDORS.VENDORS_NAME

VENDOR_NAME_ALT

This is the alternate name by which the supplier is identified. This column was designed for use in Japan for the entry of both Kanji and Kana values for the supplier name.

Variable Description
Validation: None
Destination: PO_VENDORS.VENDOR_NAME_ALT

SEGMENT1

This is the Supplier Number. If the Supplier Number entry option in the Financials Options window is set to 'Automatic', the Suppliers Open Interface Import Program assigns the number. Please note that if a value is provided in the interface table, this value will be ignored and the next automatic number will be assigned to the supplier.

Variable Description
Validation: If 'Manual' option is used, check is performed for duplicate against PO_VENDOR.SEGMENT1.
Destination: PO_VENDORS.SEGMENT1

SUMMARY_FLAG

This column is used internally and defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.SUMMARY_FLAG

ENABLED_FLAG

This column is used by some Oracle Purchasing routines to determine if a supplier is enabled and defaults to 'Y'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.ENABLED_FLAG

EMPLOYEE_ID

This is the internal identifier for the employee that corresponds to an 'EMPLOYEE' type supplier. A value for this field is valid if VENDOR_TYPE_LOOKUP_CODE = 'EMPLOYEE'

Variable Description
Validation: HR_EMPLOYEES_CURRENT_V.PERSON_ID
Destination: PO_VENDORS.EMPLOYEE_ID

VENDOR_TYPE_LOOKUP_CODE

This is the type of supplier.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'VENDOR TYPE'
Destination: PO_VENDORS.VENDOR_TYPE_LOOKUP_CODE

CUSTOMER_NUM

This is the number by which the supplier identifies the user's enterprise.

Variable Description
Validation: None
Destination: PO_VENDORS.CUSTOMER_NUM

ONE_TIME_FLAG

This flag is enabled if repeat business is not anticipated with the supplier. Defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.ONE_TIME_FLAG

MIN_ORDER_AMOUNT

This is the minimum purchase order amount for the supplier.

Variable Description
Validation: None
Destination: PO_VENDORS.MIN_ORDER_AMOUNT

SHIP_TO_LOCATION_ID

This is the unique identifier for the location where the supplier sends shipments for goods and services. This corresponds to SHIP_TO_LOCATION_CODE. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-CODE' combination. This identifier defaults from FINANCIALS_SYSTEM_PARAMS_ALL.SHIP_TO_LOCATION_ID.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_ID. The HR_LOCATIONS_ALL.SHIP_TO_SITE_FLAG must be Y.
Destination: PO_VENDORS.SHIP_TO_LOCATION_ID

SHIP_TO_LOCATION_CODE

This is the location where the supplier sends shipments for goods and services. This corresponds to SHIP_TO_LOCATION_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-CODE' combination.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_CODE. HR_LOCATIONS_ALL. SHIP_TO_SITE_FLAG must be 'Y'.
Destination: None. The value of PO_VENDORS.SHIP_TO_LOCATION_ID may be derived from this column.

BILL_TO_LOCATION_ID

This is the unique identifier for the location where the supplier sends invoices for goods and services. This corresponds to BILL_TO_LOCATION_CODE. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-CODE' combination. This identifier defaults from FINANCIALS_SYSTEM_PARAMS_ALL.BILL_TO_LOCATION_ID.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_ID. The HR_LOCATIONS_ALL.BILL_TO_SITE_FLAG must be 'Y'.
Destination: PO_VENDORS.BILL_TO_LOCATION_ID

BILL_TO_LOCATION_CODE

This is the location where the supplier sends invoices for goods and services. This corresponds to BILL_TO_LOCATION_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid ID-CODE combination.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_CODE. The HR_LOCATIONS_ALL.BILL_TO_SITE_FLAG must be 'Y'.
Destination: None. The value of PO_VENDORS.BILL_TO_LOCATION_ID may be derived from this column.

SHIP_VIA_LOOKUP_CODE

This is the default freight carrier that is used with the supplier. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.SHIP_VIA_LOOKUP_CODE.

Variable Description
Validation: ORG_FREIGHT.FREIGHT_CODE where ORGANIZATION_ID = (SELECT INVENTORY_ORGANIZATION_ID FROM FINANCIALS_SYSTEM_PARAMS_ALL WHERE ORG_ID = &DEFAULT_ORGID)
Destination: PO_VENDORS.SHIP_VIA_LOOKUP_CODE

FREIGHT_TERMS_LOOKUP_CODE

This is the default freight terms that have been negotiated with the supplier. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.FREIGHT_TERMS_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FREIGHT TERMS'
Destination: PO_VENDORS.FREIGHT_TERMS_LOOKUP_CODE

FOB_LOOKUP_CODE

This is the Free on Board (FOB) code for the supplier. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.FOB_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FOB'
Destination: PO_VENDORS.FOB_LOOKUP_CODE

TERMS_ID

This is the unique identifier for the terms on invoices from the supplier. This corresponds to TERMS_NAME. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid ID-NAME combination. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.TERMS_ID.

Variable Description
Validation: AP_TERMS_TL.TERMS.ID
Destination: PO_VENDORS.TERMS_ID

TERMS_NAME

This is the name for the default terms used on invoices from the supplier. This corresponds to TERMS_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid ID-NAME combination.

Variable Description
Validation: AP_TERMS_TL_TERMS_NAME
Destination: None. The value of PO_VENDORS.TERMS_ID may be derived from this column.

SET_OF_BOOKS_ID

This value defaults from the set of books associated with the user submitting the concurrent request. This is derived from the System Profile Options: GL Set of Books ID.

Variable Description
Validation: GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID
Destination: PO_VENDORS.SET_OF_BOOKS_ID

ALWAYS_TAKE_DISC_FLAG

Enable this option if all payments for the supplier will be paid less the discount. This values defaults from FINANCIALS_SYSTEM_PARAMS_ALL.ALWAYS_TAKE_DISC_FLAG

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.ALWAYS_TAKE_DISC_FLAG

PAY_DATE_BASIS_LOOKUP_CODE

The Pay Date Basis determines the pay date for the supplier's invoice: Discount or Due. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.PAY_DATE_BASIS_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'PAY DATE BASIS'. Valid values are: 'DISCOUNT' or 'DUE'
Destination: PO_VENDORS.PAY_DATE_BASIS_LOOKUP_CODE

PAY_GROUP_LOOKUP_CODE

This is the Pay Group for the supplier. This can be used in payment batch processing for grouping categories of suppliers. This value is defaulted from AP_SYSTEM_PARAMETERS_ALL.PAY_GROUP_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'PAY GROUP'
Destination: PO_VENDORS.PAY_GROUP_LOOKUP_CODE

PAYMENT_PRIORITY

A number between 1 and 99 which represents the payment priority for the supplier. This value defaults to 99.

Variable Description
Validation: Must be a number from 1 to 99.
Destination: PO_VENDORS.PAYMENT_PRIORITY

INVOICE_CURRENCY_CODE

This is the default currency for Purchasing documents and Payables transactions from the supplier. This value is defaulted from AP_SYSTEM_PARAMETERS_ALL.INVOICE_CURRENCY_CODE.

Variable Description
Validation: FND.CURRENCIES.CURRENCY_CODE. This value must match AP_SUPPLIERS_INT.PAYMENT_CURRENCY_CODE unless currency is EMU derived.
Destination: PO_VENDORS.INVOICE_CURRENCY_CODE

PAYMENT_CURRENCY_CODE

This is the default currency for Payments to this supplier. This value is derived from AP_SYSTEM_PARAMETERS_ALL.INVOICE_CURRENCY_CODE.

Variable Description
Validation: FND.CURRENCIES.CURRENCY_CODE. This value must match AP_SUPPLIERS_INT.INVOICE_CURRENCY_CODE unless currency is EMU derived.
Destination: PO_VENDORS.PAYMENT_CURRENCY_CODE

INVOICE_AMOUNT_LIMIT

Variable Description
Validation: Must be a number.
Destination: PO_VENDORS.INVOICE_AMOUNT_LIMIT

HOLD_ALL_PAYMENTS_FLAG

Enable if payments for the supplier are to be held. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.HOLD_ALL_PAYMENTS_FLAG

HOLD_FUTURE_PAYMENTS_FLAG

Enable if unvalidated invoices for the supplier should be held. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.HOLD_FUTURE_PAYMENTS_FLAG

HOLD_REASON

The reason invoices from the supplier are being held.

Variable Description
Validation: None
Destination: PO_VENDORS.HOLD_REASON

DISTRIBUTION_SET_ID

This column is valid at the supplier level only in a Non Multi-Org environment. This column is the unique identifier for the distribution set that will be applied to invoices from the supplier. This corresponds to DISTRIBUTION_SET_NAME. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values represent a valid ID-NAME combination.

Variable Description
Validation: AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID
Destination: PO_VENDORS.DISTRIBUTION_SET_ID

DISTRIBUTION_SET_NAME

This column is valid at the supplier level only in a Non Multi-Org environment. This is the name for the distribution set that will be applied to invoices from this supplier. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values represent a valid ID-NAME combination.

Variable Description
Validation: AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_NAME
Destination: None. The value for PO_VENDORS.DISTRIBUTION_SET_ID may be derived from this column.

ACCTS_PAY_CODE_COMBINATION_ID

This column is valid at the supplier level only in a Non Multi-Org environment. This will be the default liability account for supplier sites from the supplier. If a value for this column is entered into the interface table in a multi-org environment, that value will be ignored and not brought into the PO_VENDORS table.

Variable Description
Validation: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID where ACCOUNT_TYPE = 'L' and CHART_OF_ACCOUNTS_ID = (SELECT CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = &DEFAULT_SET_OF_BOOKS_ID)
Destination: PO_VENDORS.ACCTS_PAY_CODE_COMBINATION_ID

PREPAY_CODE_COMBINATION_ID

This column is valid at the supplier level only in a Non Multi-Org environment. This is the account that will be used for Prepayment Item distributions entered on invoices for the supplier. If a value for this column is entered into the interface table in a mulit-org environment, that value will be ignored and not brought into the PO_VENDORS table.

Variable Description
Validation: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID where CHART_OF_ACCOUNTS_ID = (SELECT CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = &DEFAULT_SET_OF_BOOKS_ID)
Destination: PO_VENDORS.PREPAY_CODE_COMBINATION_ID

NUM_1099

Supplier Tax Identification Number (TIN).

Variable Description
Validation: None
Destination: PO_VENDORS.NUM_1099

TYPE_1099

This is the income tax type for a United States 1099 reportable supplier.

Variable Description
Validation: AP_INCOME_TAX_TYPES.INCOME_TAX_TYPE. Value in this field is only valid if AP_SUPPLIERS_INT.FEDERAL_REPORTABLE_FLAG = 'Y'.
Destination: PO_VENDORS.TYPE_1099

ORGANIZATION_TYPE_LOOKUP_GUIDE

This is the type of enterprise for the supplier.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'ORGANIZATION TYPE'. Valid values are: 'CORPORATION', 'FOREIGN CORPORATION', 'FOREIGN GOVERNMENT AGENCY', 'FOREIGN INDIVIDUAL', 'FOREIGN PARTNERSHIP', 'GOVERNMENT AGENCY', 'INDIVIDUAL', 'PARTNERSHIP'
Destination: PO_VENDORS.ORGANIZATION_TYPE_LOOKUP_CODE

VAT_CODE

This column is valid at the supplier level only in a Non Multi-Org environment. This will be the default tax code for invoices entered for the supplier. In Non Multi-Org enviroments, this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.VAT_CODE.

Variable Description
Validation: AP_TAX_CODES_ALL.NAME and AP_TAX_CODES_ALL.TAX_TYPE cannot be 'OFFSET'.
Destination: PO_VENDORS.VAT_CODE

START_DATE_ACTIVE

This is the date on which the supplier will appear on supplier lists of values.

Variable Description
Validation: Must be in valid format.
Destination: PO_VENDORS.START_DATE_ACTIVE

END_DATE_ACTIVE

This is the date on which the supplier will no longer appear on any supplier list of values.

Variable Description
Validation: Must be in valid format.
Destination: PO_VENDORS.END_DATE_ACTIVE

MINORITY_GROUP_LOOKUP_CODE

If the supplier is a minority-owned business, enter the minority group in this column.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'MINORITY GROUP'
Destination: PO_VENDORS.MINORITY_GROUP_LOOKUP_CODE

PAYMENT_METHOD_LOOKUP_CODE

This is the default payment method for the supplier.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'PAYMENT METHOD'. Payment methods are user defined in Oracle Payments

WOMEN_OWNED_FLAG

Indicates if the supplier is a woman-owned business. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.WOMEN_OWNED_FLAG

SMALL_BUSINESS_FLAG

Indicates if the supplier is a small business. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.SMALL_BUSINESS_FLAG

STANDARD_INDUSTRY_CLASS

Standard Industry Code (SIC).

Variable Description
Validation: None
Destination: PO_VENDORS.STANDARD_INDUSTRY_CLAS

HOLD_FLAG

Indicates whether the supplier is on purchasing hold. Purchase orders can be entered for the supplier but not approved. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.HOLD_FLAG

PURCHASING_HOLD_REASON

The reason purchase orders for this supplier cannot be approved.

Variable Description
Validation: None
Destination: PO_VENDORS.PURCHASING_HOLD_REASONS_FLAG

HOLD_BY

This is the unique identifier of the employee who placed the supplier on purchasing hold.

Variable Description
Validation: PER_ALL_PEOPLE_F.PERSON_ID
Destination: PO_VENDORS.HOLD_BY

HOLD_DATE

The date the supplier was placed on purchasing hold.

Variable Description
Validation: Must be in valid date format.
Destination: PO_VENDORS.HOLD_DATE

TERMS_DATE_BASIS

The date from which Payables calculates a scheduled payment. This value defaults to AP_SYSTEM_PARAMETERS_ALL.TERMS.DATE_BASIS.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'TERMS DATE BASIS'. Valid values are: 'CURRENT', 'GOODS RECEIVED', 'INVOICE', 'INVOICE RECEIVED'.
Destination: PO_VENDORS.TERMS.DATE_BASIS

INSPECTION_REQUIRED_FLAG/ RECEIPT_REQUIRED_FLAG

These columns, taken together, determine the level of match level approval that is required for invoices matched to purchase orders: 4-way, 3-way, or 2-way. These values default from PO_SYSTEM_PARAMETERS_ALL.INSPECTION_REQUIRED_FLAG and PO_SYSTEM_PARAMETERS_ALL.RECEIVING FLAG.

Variable Description
Validation: These columns are evaluated together. Valid combinations of values are: INSPECTION_REQUIRED_FLAG = 'Y, RECEIPT_REQUIRED_FLAG = 'Y'; INSPECTION_REQUIRED_FLAG = 'N', RECEIPT_REQUIRED_FLAG = 'Y'; and INSPECTION_REQUIRED_FLAG = 'N', RECEIPT_REQUIRED_FLAG = 'N'
Destination: PO_VENDORS.INSPECTION_REQUIRED_FLAG, PO_VENDORS.RECEIPT_REQUIRED_FLAG

QTY_RCV_TOLERANCE

Oracle Purchasing uses this column during the receiving process. It identifies the maximum acceptable quantity received in excess of the quantity ordered on a purchase order for the supplier. This value defaults from RCV_PARAMETERS.QTY_RCV_TOLERANCE.

Variable Description
Validation: Must be a number.
Destination: PO_VENDORS.QTY_RCV_TOLERANCE

QTY_RCV_EXCEPTION_CODE

Oracle Purchasing uses this column to determine the action to be taken when the quantity-received tolerance is violated during the receiving process. This value defaults from RCV_PARAMETERS.QTY_RCV_EXCEPTION_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV OPTION'. Valid values are: 'NONE', 'REJECT', or 'WARNING'.
Destination: PO_VENDORS.QTY_RCV_EXCEPTION_CODE

ENFORCE_SHIP_TO_LOCATION_CODE

Oracle Purchasing uses this column to determine the action to be taken when receiving location varies from the ship-to location. This value defaults from RCV_PARAMETERS.ENFORCE_SHIP_TO_LOCATION.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV OPTION'. Valid values are 'NONE', 'REJECT', or 'WARNING'.
Destination: PO_VENDORS.ENFORCE_SHIP_TO_LOCATION_CODE

DAYS_EARLY_RECEIPT_ALLOWED

Oracle Purchasing uses this column to determine the maximum number of days items can be received early. This defaults from RCV_PARAMETERS.DAYs_EARLY_RECEIPT_ALLOWED.

Variable Description
Validation: Must be a number.
Destination: PO_VENDORS.DAYS_EARLY_RECEIPT_ALLOWED

DAYS_LATE_RECEIPT_ALLOWED

Oracle Purchasing uses this column to determine the maximum number of days items can be received late. RCV_PARAMETERS.DAYS_LATE_RECEIPT_ALLOWED.

Variable Description
Validation: Must be a number.
Destination: PO_VENDORS.DAYS_LATE_RECEIPT_ALLOWED

RECEIPT_DAYS_EXCEPTION_CODE

Oracle Purchasing uses this column to determine the action to be taken when items are received earlier or later than the allowed number of days specified. This value defaults from RCV_PARAMETERS.RECEIPT_DAYS_EXCEPTION_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV OPTION'. Valid values are: 'NONE', 'REJECT', or 'WARNING'.
Destination: PO_VENDORS.RECEIPT_DAYS_EXCEPTION_CODE

RECEIVING_ROUTING_ID

This is the receipt routing unique identifier used by Oracle Purchasing. RCV_PARAMETERS.RECEIVING_ROUTING_ID.

Variable Description
Validation: RCV_ROUTING_HEADERS.ROUTING_HEADER_ID
Destination: PO_VENDORS.RECEIVING_ROUTING_ID

ALLOW_SUBSTITUTE_RECEIPTS_FLAG

Oracle Purchasing uses this column to determine if substitute items can be received in place of the ordered items. This value defaults from RCV_PARAMETERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG

ALLOW_UNORDERED_RECEIPTS_FLAG

Oracle Purchasing uses this column to determine if unordered receipts are allowed. This value defaults from RCV_PARAMETERS.ALLOW_UNORDERED_RECEIPTS_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.ALLOW_UNORDERED_RECEIPTS_FLAG

HOLD_UNMATCHED_INVOICES_FLAG

This column indicates if unmatched invoices should be put on hold. If AP_SUPPLIERS_INT.VENDOR_TYPE_LOOKUP_CODE = 'EMPLOYEE', then this value defaults from AP_SYSTEM_PARAMETERS_ALL.HOLD_UNMATCHED_INVOICES_FLAG. If not, then this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.HOLD_UNMATCHED_INVOICES_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.HOLD_UNMATCHED_INVOICES_FLAG

EXCLUSIVE_PAYMENT_FLAG

This column indicates whether or not separate payments should be created for each invoice for the supplier. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.EXCLUSIVE_PAYMENT_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.EXCLUSIVE_PAYMENT_FLAG

AP_TAX_ROUNDING_RULE

This column determines the rounding rule for tax values. This value defaults from FINANCIALS_SYSTEM_PARAMETERS_ALL.TAX_ROUNDING_RULE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'AP_TAX_ROUNDING_RULE'. Valid values are: 'D', 'N', 'U'.
Destination: PO_VENDORS.AP_TAX_ROUNDING_RULE

AUTO_TAX_CALC_FLAG

This column indicates the level for automatic tax calculation for supplier. This value defaults from AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_FLAG and cannot be changed in a Multi-Org environment.

Variable Description
Validation: If AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_OVERRIDE = 'N', this value must match the value of AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_FLAG. Valid values, which are found in FND_LOOKUP_VALUES.LOOKUP_TYPE = 'AP_TAX_CALCULATION_METHOD', are: 'L', 'N', 'T', 'Y'.
Destination: PO_VENDORS.AUTO_TAX_CALC_FLAG

AUTO_TAX_CALC_OVERRIDE

This indicates if override of tax calculation is allowed at supplier site level. This value defaults from AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_OVERRIDE and cannot be changed in a Multi-Org environment.

Variable Description
Validation: If AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_OVERRIDE = 'N', this value must also be 'N'.
Destination: PO_VENDORS.AUTO_TAX_CALC_OVERRIDE

AMOUNT_INCLUDES_TAX_FLAG

This column indicates if amounts on invoices from the supplier include tax. This value defaults from AP_SYSTEM_PARAMETERS_ALL.AMOUNT_INCLUDES_TAX_FLAG and cannot be changed in a Multi-Org environment.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.AMOUNT_INCLUDES_TAX_FLAG

TAX_VERIFICATION_DATE

The date tax verification for 1099 reporting purposes was received from the supplier.

Variable Description
Validation: Must be in the valid date format.
Destination: PO_VENDORS.TAX_VERIFICATION_DATE

NAME_CONTROL

This column is the first four characters of the last name of a 1099 reportable supplier.

Variable Description
Validation: Must be upper case letter, number between 0-9, and/or '&'.
Destination: PO_VENDORS.NAME_CONTROL

STATE_REPORTABLE_FLAG

This column indicates participation in the United States Internal Revenue Service Combined Filing Program and that the supplier is reportable to a state taxing authority. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.STATE_REPORTABLE_FLAG

FEDERAL_REPORTABLE_FLAG

This column indicates that the supplier is reportable to the United States Internal Revenue Service for 1099 purposes. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.FEDERAL_REPORTABLE_FLAG

ATTRIBUTE_CATEGORY

This is the descriptive flexfield category for the descriptive flexfield information for the supplier.

Variable Description
Validation: None
Destination: PO_VENDORS.ATTRIBUTE_CATEGORY

ATTRIBUTES (1-15)

This is the descriptive flexfield information for the supplier. The import process will not validate the information entered in these columns. However, the structure of the information entered (data types, value sets) must match the structure of the descriptive flexfield segments defined for suppliers or users will experience validation problems when trying to access the information through the application.

Variable Description
Validation: None
Destination: PO_VENDORS.ATTRIBUTE [1-15]

VAT_REGISTRATION_NUM

Tax registration number.

Variable Description
Validation: None
Destination: PO_VENDORS.VAT_REGISTRATION_NUM

AUTO_CALCULATE_INTEREST_FLAG

This column indicates if interest is to be automatically calculated on past due invoices for the supplier. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.AUTO_CALCULATE_INTEREST_FLAG

EXCLUDE_FREIGHT_FROM_DISCOUNT

This column indicates if the freight amount is to be excluded from the discount on invoices from the supplier. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.EXCLUDE_FREIGHT_FROM_DISCOUNT

TAX_REPORTING_NAME

This is the tax-reporting name for a supplier subject to United States Internal Revenue Service income tax reporting. This is only necessary if the supplier name is different from the tax-reporting name.

Variable Description
Validation: None
Destination: PO_VENDORS.TAX_REPORTING_NAME

ALLOW_AWT_FLAG

This column indicates whether or not automatic withholding is allowed for the supplier. This value defaults to 'N'.

Variable Description
Validation: If AP_SYSTEM_PARAMETERS_ALL.ALLOW_AWT_FLAG = 'N', then this option is not available for suppliers.
Destination: PO_VENDORS.ALLOW_AWT_FLAG

AWT_GROUP_ID

The 'ID' is the unique identifier for the Withholding Tax Group that will default to the supplier sites. This corresponds to AWT_GROUP_NAME. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valide 'ID-NAME' combination.

Variable Description
Validation: AP_AWT_GROUPS.GROUP_ID. Values are only valid if ALLOW_AWT_FLAG = 'Y'
Destination: PO_VENDORS.AWT_GROUP_ID

AWT_GROUP_NAME

This is the Withholding Tax Group that will default to the supplier sites. This corresponds to AWT_GROUP_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination.

Variable Description
Validation: AP_AWT_GROUP.NAME. Values are only valid if ALLOW_AWT_FLAG = 'Y'.
Destination: None. Value for PO_VENDORS.AWT_GROUP_ID may be derived from this column.

GLOBAL_ATTRIBUTES (1-20)

This is global descriptive flexfield information for the supplier. The structure of the information entered in these columns (data types, value sets) must match the structure of the descriptive flexfield segments defined for suppliers or users will experience validation problems when trying to access the information through the application.

Variable Description
Validation: None
Destination: PO_VENDORS.GLOBAL_ATTRIBUTES [1-20]

GLOBAL_ATTRIBUTE_CATEGORY

This is the descriptive flexfield category for the descriptive flexfield infomation for import.

Variable Description
Validation: None
Destination: PO_VENDORS.GLOBAL_ATTRIBUTE_CATEGORY

EDI_TRANSACTION_HANDLING

This is the standard EDI transaction code designating action to be taken by all parties.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI TRANSACTION HANDLING'
Destination: PO_VENDORS.EDI_TRANSACTION_HANDLING

EDI_PAYMENT_METHOD

This indicates how EDI payments will be made.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI PAYMENT METHOD'
Destination: PO_VENDORS.EDI_PAYMENT_METHOD

EDI_PAYMENT_FORMAT

This column indicates the type of information being transmitted when EDI Payment Method is 'ACH'.

Variable Description
Validation: Valid only if EDI_PAYMENT_METHOD = 'ACH'. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI PAYMENT FORMAT'.
Destination: PO_VENDORS.EDI_PAYMENT_FORMAT

EDI_REMITTANCE_METHOD

This column indicates the party responsible for sending remittance advice to the payee.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI REMITTANCE METHOD'
Destination: PO_VENDORS.EDI_REMITTANCE_METHOD

EDI_REMITTANCE_INSTRUCTION

This is the text of electronic payment instructions for a financial institution.

Variable Description
Validation: None
Destination: PO_VENDORS.EDI_REMITTANCE_INSTRUCTION

BANK_CHARGE_BEARER

This column indicates who will pay bank charges assessed on payments to this supplier. If AP_SYSTEM_PARAMETERS_ALL.USE_BANK_CHARGE_FLAG = 'Y', then this field defaults from AP_SYSTEM_PARAMETERS_ALL.BANK_CHARGE_BEARER.

Variable Description
Validation: If AP_SYSTEM_PARAMETERS_ALL.USE_BANK_CHARGE_FLAG = 'N', then this option is not available for suppliers, if AP_SYSTEM_PARAMETERS_ALL.USE_BANK_CHARGES_FLAG = 'Y', validated against FND_LOOKUP_VALUES where LOOKUP_TYPE = 'BANK CHARGE BEARER'. Valid values are: 'I', 'N', 'S'.
Destination: PO_VENDORS.BANK_CHARGE_BEARER

MATCH_OPTION

This column indicates whether invoices are matched to a purchase order to a receipt. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.MATCH_OPTION.

Variable Description
Validation: Valid values are: 'P' (meaning: Purchase Order) and 'R' (meaning: Receipt).
Destination: PO_VENDORS.MATCH_OPTION

FUTURE_DATED_PAYMENT_CCID

Default future dated payments account for sites for this supplier. This column is only valid at the supplier level in Non Multi-Org environments. If a value for this column is entered into the interface table in a multi-org environment, that value will be ignored and not brought into the PO_VENDORS table. If Non Multi-Org, this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.FUTURE_DATED_PAYMENT_CCID. If Multi-Org, the default is NULL.

Variable Description
Validation: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID where CHART_OF_ACCOUNTS_ID = (SELECT CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = &DEFAULT_SET_OF_BOOKS_ID)
Destination: PO_VENDORS.FUTURE_DATED_PAYMENT_CCID

CREATE_DEBIT_MEMO_FLAG

This column indicates if a debit memo should be automatically created when goods are returned to the supplier.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS.CREATE_DEBIT_MEMO_FLAG

OFFSET_TAX_FLAG

This column indicates whether or not the supplier uses offset taxes. This is only valid at the supplier level in Non Multi-Org environments. This value defaults to 'N'.

Variable Description
Validation: Non Multi-Org only: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'. Also, if AP_SUPPLIER_INT.VENDOR_TYPE_LOOKUP_CODE = 'EMPLOYEE', value cannot be 'Y'.
Destination: PO_VENDORS.OFFSET_TAX_FLAG

STATUS

This column indicates the status of the record in the interface table. The user should enter 'NEW' as the initial value for this column. After the Suppliers Open Interface Import Program is run, successfully imported records will be marked as 'PROCESSED' and records that are not imported will be marked 'REJECTED'.

REJECT_CODE

This column indicates the reason the record has been rejected by the Supplier Open Interface Import Program. This column is populated by the Supplier Open Interface Import Program and should not be entered by the user.

Variable Description
Validation: N/A
Destination: None

ECE_TP_LOCATION_CODE

Trading partner location code for e-Commerce Gateway.

Variable Description
Validation: None
Destination: PO_VENDORS_SITES_ALL.ECE_TP_LOCATION_CODE

IBY_BANK_CHARGE_BEARER

This column indicates who will pay bank charges assessed on payments to the supplier. This value defaults from PO_VENDORS.BANK_CHARGE_BEARER.

Variable Description
Validation: If AP_SYSTEM_PARAMETERS_ALL.USE_BANK_CHARGE_FLAG = 'N', then this option is not available for supplier sites. If AP_SYSTEM_PARAMETERS_ALL.USE_BANK_CHARGES_FLAG= 'Y', validated against FND_LOOKUP_VALUES where LOOKUP_TYPE = 'BANK CHARGE BEARER'. Valid values are: 'I', 'N', 'S'.
Destination: PO_VENDOR_SITES_ALL.BANK_CHARGE_BEARER

BANK_INSTRUCTION(1-2)_CODE

These columns indicate the code of first and second bank instructions.

Variable Description
Validation: N/A
Destination: None

BANK_INSTRUCTION_DETAILS

This column are the additional bank instruction details.

Variable Description
Validation: N/A
Destination: None

PAYMENT_REASON_CODE

This column indicates the payment reason code.

Variable Description
Validation: N/A
Destination: None

PAYMENT_REASON_COMMENTS

This column is a free text field available for entering a reason.

Variable Description
Validation: N/A
Destination: None

PAYMENT_TEXT_MESSAGE(1-3)

These columns indicate are text messages for use in payment processing.

Variable Description
Validation: N/A
Destination: None

DELIVERY CHANNEL_CODE

This column is the default delivery channel code.

Variable Description
Validation: N/A
Destination: None

PAYMENT_FORMAT_CODE

This column is the default payment format code.

Variable Description
Validation: N/A
Destination: None

SETTLEMENT_PRIORITY

This column is the priority for payments settlement.

Variable Description
Validation: N/A
Destination: None

PAYMENT_METHOD_CODE

This column is the payment method identifier.

Variable Description
Validation: N/A
Destination: None

AP_SUPPLIER_SITES_INT

Column Name Null Type Comments
VENDOR_INTERFACE_ID   NUMBER(15) Required if value is not provided for VENDOR_ID
VENDOR_ID   NUMBER Required if value is not provided for VENDOR_INTERFACE_ID
VENDOR_SITE_CODE   VARCHAR2(15) Required
VENDOR_SITE_CODE_ALT   VARCHAR(320) N/A
PURCHASING_SITE_FLAG   VARCHAR2(1) N/A
RFQ_ONLY_SITE_FLAG   VARCHAR2(1) N/A
PAY_SITE_FLAG   VARCHAR2(1) N/A
ATTENTION_AR_FLAG   VARCHAR2(1) N/A
ADDRESS_LINE1   VARCHAR2(240) N/A
ADDRESS_LINE_ALT   VARCHAR2(560) N/A
ADDRESS_LINE2   VARCHAR2(240) N/A
ADDRESS_LINE3   VARCHAR2(240) N/A
CITY   VARCHAR2(25) N/A
STATE   VARCHAR2(150) Conditionally required
ZIP   VARCHAR2(20) N/A
PROVINCE   VARCHAR2(150) N/A
COUNTRY   VARCHAR2(25) N/A
AREA_CODE   VARCHAR2(10) N/A
PHONE   VARCHAR(15) N/A
CUSTOMER_NUM   VARCHAR(25) N/A
SHIP_TO_LOCATION_ID   NUMBER N/A
SHIP_TO_LOCATION_CODE   VARCHAR2(60) N/A
BILL_TO_LOCATION_ID   NUMBER N/A
BILL_TO_LOCATION_CODE   VARCHAR2(60) N/A
SHIP_VIA_LOOKUP_CODE   VARCHAR2(25) N/A
FREIGHT_TERMS_LOOKUP_CODE   VARCHAR2(25) N/A
FOB_LOOKUP_CODE   VARCHAR2(25) N/A
SHIPPING_CONTROL   VARCHAR2(30) N/A
INACTIVE_DATE   DATE N/A
FAX   VARCHAR2(15) N/A
FAX_AREA_CODE   VARCHAR2(10) N/A
TELEX   VARCHAR2(15) N/A
PAYMENT_METHOD_LOOKUP_CODE   VARCHAR2(25) Required but will default
TERMS_DATE_BASIS   VARCHAR2(25) Required but will default
VAT_CODE   VARCHAR2(20) N/A
DISTRIBUTION_SET_ID   NUMBER N/A
DISTRIBUTION_SET_NAME   VARCHAR2(50) N/A
ACCTS_PAY_CODE_COMBINATION_ID   NUMBER N/A
PREPAY_CODE_COMBINATION_ID   NUMBER N/A
PAY_GROUP_LOOKUP_CODE   VARCHAR2(25) N/A
PAYMENT_PRIORITY   NUMBER Required but will default
TERMS_ID   NUMBER N/A
TERMS_NAME   VARCHAR2(50) N/A
INVOICE_AMOUNT_LIMIT   NUMBER N/A
PAY_DATE_BASIS_LOOKUP_CODE   VARCHAR2(25) Required but will default
ALWAYS_TAKE_DISC_FLAG   VARCHAR2(1) N/A
INVOICE_CURRENCY_CODE   VARCHAR2(15) N/A
PAYMENT_CURRENCY_CODE   VARCHAR2(15) N/A
HOLD_ALL_PAYMENTS_FLAG   VARCHAR2(1) N/A
HOLD_FUTURE_PAYMENTS_FLAG   VARCHAR2(1) N/A
HOLD_REASON   VARCHAR2(240) N/A
HOLD_UNMATCHED_INVOICES_FLAG   VARCHAR2(1) N/A
AP_TAX_ROUNDING_RULE   VARCHAR2(1) N/A
AUTO_TAX_CALC_FLAG   VARCHAR2(1) N/A
AUTO_TAX_CALC_OVERRIDE   VARCHAR2(1) N/A
AMOUNT_INCLUDES_TAX_FLAG   VARCHAR2(1) N/A
EXCLUSIVE_PAYMENT_FLAG   VARCHAR2(1) N/A
TAX_REPORTING_SITE_FLAG   VARCHAR2(1) Only one site required if Federal Reportable = 'Y'
ATTRIBUTE_CATEGORY   VARCHAR2(30) N/A
ATTRIBUTES(1-15)   VARCHAR2(150) N/A
EXCLUDE_FREIGHT_FROM_DISCOUNT   VARCHAR2(1) N/A
VAT_REGISTRATION_NUM   VARCHAR2(20) N/A
ORG_ID   NUMBER(15) Required if value is not provided for OPERATING_UNIT_NAME
OPERATING_UNIT_NAME   VARCHAR2(240) Required if value is not provided for ORG_ID
ADDRESS_LINE4   VARCHAR2(240) N/A
COUNTY   VARCHAR2(150) N/A
ADDRESS_STYLE   VARCHAR2(30) N/A
LANGUAGE   VARCHAR2(30) N/A
ALLOW_AWT_FLAG   VARCHAR2(1) N/A
AWT_GROUP_ID   NUMBER(1) N/A
AWT_GROUP_NAME   VARCHAR2(25) N/A
GLOBAL_ATTRIBUTES(1-20)   VARCHAR2(150) N/A
GLOBAL_ATTRIBUTE_CATEGORY   VARCHAR2(30) N/A
EDI_TRANSACTION_HANDLING   VARCHAR2(25) N/A
EDI_ID_NUMBER   VARCHAR2(30) N/A
EDI_PAYMENT_METHOD   VARCHAR2(30) N/A
EDI_PAYMENT_FORMAT   VARCHAR2(25) N/A
EDI_REMITTANCE_METHOD   VARCHAR2(25) N/A
BANK_CHARGE_BEARER   VARCHAR2(1) N/A
EDI_REMITTANCE_INSTRUCTION   VARCHAR2(256) N/A
PAY_ON_CODE   VARCHAR2(25) N/A
DEFAULT_PAY_SITE_ID   NUMBER(15) Conditionally required
PAY_ON_RECEIPT_SUMMARY_CODE   VARCHAR2(25) N/A
TP_HEADER_ID   NUMBER N/A
ECE_TP_LOCATION_CODE   VARCHAR2(60) N/A
PCARD_SITE_FLAG   VARCHAR2(1) N/A
MATCH_OPTION   VARCHAR2(25) Required but will default
COUNTRY_OF_ORIGIN_CODE   VARCHAR2(25) N/A
FUTURE_DATED_PAYMENT_CCID   NUMBER(15) N/A
CREATE_DEBIT_MEMO_FLAG   VARCHAR2(1) N/A
OFFSET_TAX_FLAG   VARCHAR2(1) N/A
SUPPLIER_NOTIF_METHOD   VARCHAR2(25) N/A
EMAIL_ADDRESS   VARCHAR2(2000) N/A
REMITTANCE_EMAIL   VARCHAR2(2000) N/A
PRIMARY_PAY_SITE_FLAG   VARCHAR2(1) N/A
STATUS   VARCHAR2(30) N/A
REJECT_CODE   VARCHAR2(2000) N/A
SHIPPING_CONTROL   VARCHAR2(30) Indicates the party responsible for arranging transportation: Supplier or Buyer.
DUNS_NUMBER   VARCHAR2(30) A unique 9-digit identification number assigned to all business entities in Dun & Bradstreet's database. Used only for Federal Financial installations.
TOLERANCE_ID   NUMBER (15) Tolerance Template identifier
TOLERANCE_NAME   VARCHAR2(255) Tolerance Template Name
IBY_BANK_CHARGE_BEARER   VARCHAR2(30) Bearer of bank charge cost.
BANK_INSTRUCTION1_CODE   VARCHAR2(30) Code of first bank instruction.
BANK_INSTRUCTION2_CODE   VARCHAR2(30) Code of second bank instruction.
BANK_INSTRUCTION_DETAILS   VARCHAR2(255) Additional bank instruction details.
PAYMENT_REASON_CODE   VARCHAR2(30) Payment reason code
PAYMENT_REASON_COMMENTS   VARCHAR(240) Free text field available for entering a reason.
DELIVERY_CHANNEL_CODE   VARCHAR2(30) Default delivery channel code.
PAYMENT_FORMAT_CODE   VARCHAR2(150) Default payment format code.
SETTLEMENT_PRIORITY   VARCHAR2(30) Priority for payments settlement
PAYMENT_TEXT_MESSAGE1   VARCHAR2(150) Text message for use in payment processing
PAYMENT_TEXT_MESSAGE2   VARCHAR2(150) Text message for use in payment processing
PAYMENT_TEXT_MESSAGE3   VARCHAR2(150) Text message for use in payment processing
VENDOR_SITE_INTERFACE_ID   NUMBER(15) Vendor site interface identifier.
PAYMENT_METHOD_CODE   VARCHAR2(30) Payment method identifier.
RETAINAGE_RATE   Number Maximum percentage that can be withheld from an invoice as Retainage.
GAPLESS_INV_NUM_FLAG   VARCHAR2(1) Gapless Invoice Numbering Flag
SELLING_COMPANY_IDENTIFIER   VARCHAR2(10) Unique selling company identifier for supplier.

VENDOR_INTERFACE_ID

This is the unique identifier for AP_SUPPLIERS_INT that joins the supplier to the site in the interface. The user can determine the value for this column from the AP_SUPPLIERS_INT.VENDOR_INTERFACE_ID that corresponds to the Supplier Site record. A user-supplied value is required for either this column or AP_SUPPLIER_SITES_INT.VENDOR_ID.

Variable Description
Validation: None
Destination: None

VENDOR_ID

This is the unique identifier for the supplier used to join the site to the corresponding supplier. A user-supplied value is required for either this field or AP_SUPPLIER_SITES_INT.VENDOR_INTERFACE_ID. If the VENDOR_INTERFACE_ID is provided and the Supplier Open Interface Import program is run first, the VENDOR_ID is derived and recorded by the Supplier Open Interface Import.

The Supplier Sites Open Interface Import program displays an exception in the output report when the VENDOR_ID is missing.

Variable Description
Validation: PO_VENDORS.VENDOR_ID
Destination: PO_VENDOR_SITES_ALL.VENDOR_ID

VENDOR_SITE_CODE

This is the unique name assigned by the user to the supplier site. The user must supply this value.

Variable Description
Validation: Checks for duplicates against: PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE and ORG_ID.
Destination: PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE

VENDOR_SITE_CODE_ALT

This column is the alternate supplier site code used primarily for Kana values.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE_ALT

PURCHASING_SITE_FLAG

This column indicates whether or not purchasing is allowed from the site. This value defaults to 'Y'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDOR_SITES_ALL.PURCHASING_SITE_FLAG

RFQ_ONLY_SITE_FLAG

This column indicates whether or not the site only accepts RFQs. This value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.RFQ_ONLY_SITE_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS_SITES_ALL.RFQ_ONLY_SITE_FLAG

PAY_SITE_FLAG

This column indicates whether or not payments are allowed to the site. This value defaults to 'Y'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS_SITES_ALL.PAY_SITE_FLAG

ATTENTION_AR_FLAG

This column indicates if payments are to be sent to the Accounts Receivable department of the supplier site. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDOR_SITES_ALL.ATTENTION_AR_FLAG

ADDRESS_LINE(1 - 3)

This is the first line of supplier site address.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.ADDRESS_LINE1

ADDRESS_LINES_ALT

This is the alternate address line for Kana Value of the supplier site address.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.ADDRESS_LINES_ALT

CITY

City name.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.CITY

STATE

State name or abbreviation.

Variable Description
Validation: If PO.VENDORS.FEDERAL_REPORTABLE_FLAG = 'Y', and PO_VENDORS.ORGANIZATION_TYPE_LOOKUP_CODE not like 'FOREIGN%', then validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'STATE', else no validation.
Destination: PO_VENDOR_SITES_ALL.STATE

ZIP

Postal code.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.ZIP

PROVINCE

Province.

Variable Description
Validation: None
Destination: PO_VENDORS_SITES_ALL.PROVINCE

COUNTRY

Country name. This value defaults from the System Profile Option: Default Country.

Variable Description
Validation: FND_TERRITORIES.TERRITORY_CODE
Destination: PO_VENDORS_SITES_ALL.COUNTRY

AREA_CODE

Telephone area code.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.AREA_CODE

PHONE

Telephone number.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.PHONE

CUSTOMER_NUM

Customer number with the supplier site. This value defaults from PO_VENDORS.CUSTOMER_NUM.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.CUSTOMER_NUM

SHIP_TO_LOCATION_ID

The 'ID' is the unique identifier for the location where the supplier site sends shipments for goods/services. This corresponds to SHIP_TO_LOCATION_CODE. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-CODE' combination. This value defaults from PO_VENDORS.SHIP_TO_LOCATION_ID.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_CODE. HR_LOCATIONS_ALL.SHIP_TO_SITE_FLAG must be 'Y'.
Destination: PO_VENDOR_SITES_ALL.SHIP_TO_LOCATION_ID

SHIP_TO_LOCATION_CODE

This is the location where the supplier site sends shipments for goods/services. This corresponds to SHIP_TO_LOCATION_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-CODE' combination.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_CODE. HR_LOCATIONS_ALL.SHIP_TO_SITE_FLAG must be 'Y'.
Destination: None. The value of PO_VENDOR_SITES_ALL.SHIP_TO_LOCATION_ID may be derived from this column.

BILL_TO_LOCATION_ID

The 'ID' is the unique identifier for the location where the supplier site sends invoices for goods/services. This corresponds to BILL_TO_LOCATION_CODE. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-CODE' combination. This value defaults from PO_VENDORS.BILL_TO_LOCATION_ID.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_ID. The HR_LOCATIONS_ALL.BILL_TO_SITE_FLAG must be 'Y'.
Destination: PO_VENDOR_SITES_ALL.BILL_TO_LOCATION_ID

BILL_TO_LOCATION_CODE

This is the location where the supplier sends invoices from goods/services. This corresponds to BILL_TO_LOCATION_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-CODE' combination.

Variable Description
Validation: HR_LOCATIONS_ALL.LOCATION_CODE. The HR_LOCATIONS_ALL.BILL_TO_SITE_FLAG must be 'Y'.
Destination: None The value of PO_VENDOR_SITES_ALL.BILL_TO_LOCATION_ID may be derived from this column.

SHIP_VIA_LOOKUP_CODE

This is the freight carrier that is used with the supplier site. This value defaults from PO_VENDORS.SHIP_VIA_LOOKUP_CODE if value is in ORG_FREIGHT.FREIGHT_CODE where ORGANIZATION_ID = (SELECT INVENTORY_ORGANIZATION_ID FROM FINANCIALS_SYSTEM_PARAMS_ALL WHERE ORG_ID = &SITE_ORG_ID), else NULL.

Variable Description
Validation: ORG_FREIGHT.FREIGHT_CODE where ORGANIZATION_ID = (SELECT INVENTORY_ORGANIZATION_ID FROM FINANCIALS_SYSTEM_PARAM_ALL WHERE ORG_ID = &SITE_ORG_ID).
Destination: PO_VENDOR_SITES_ALL.SHIP_VIA_CODE

FREIGHT_TERMS_LOOKUP_CODE

This column indicates the freight terms that have been negotiated with the supplier site. This value defaults from PO_VENDORS.FREIGHT_TERMS_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FREIGHT TERMS'
Destination: PO_VENDORS_SITES_ALL.FREIGHT_TERMS_LOOKUP_CODE

FOB_LOOKUP_CODE

This is the Free on Board (FOB) code for the supplier site. This value defaults from PO_VENDORS.FOB_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'FOB'
Destination: PO_VENDOR_SITES_ALL.FOB_LOOKUP_CODE

SHIPPING_CONTROL

Indicates the party responsible for arranging transportation: supplier or buyer.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'SHIPPING CONTROL'. Valid values are 'SUPPLIER' or 'BUYER'.
Destination: PO_VENDOR_SITES_ALL.SHIPPING_CONTROL

INACTIVE_DATE

This is the date on which the supplier site will no longer appear on any supplier site list of values.

Variable Description
Validation: Must be in valid date format.
Destination: PO_VENDOR_SITES_ALL.INACTIVE_DATE

FAX

Supplier site facsimile number.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.FAX

FAX_AREA_CODE

Supplier site area code for facsimile number.

Variable Description
Validation: None
Destination: PO_VENDORS_SITES_ALL.FAX_AREA_CODE

TELEX

Supplier site telex number.

Variable Description
Validation: None
Destination: PO_VENDORS_SITES_ALL.TELEX

PAYMENT_METHOD_LOOKUP_CODE

This column indicates the default method of payment for the supplier site.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'PAYMENT METHOD'. Payment methods are user defined in Oracle Payments

TERMS_DATE_BASIS

This is the date from which Payables calculates a scheduled payment for the supplier site. This value defaults from PO_VENDORS.TERMS_DATE_BASIS.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'TERMS DATE BASIS'. Valid values are: 'Current', 'Goods Received', 'Invoice', 'Invoice Received'.
Destination: PO_VENDOR_SITES_ALL.TERMS.DATE_BASIS

VAT_CODE

This will be the default tax code for invoices entered for the supplier site. If in a Multi-Org environment, this value defaults from PO_VENDORS.VAT_CODE. If in a Non Multi-Org environment, this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.VAT_CODE.

Variable Description
Validation: AP_TAX_CODES_ALL.NAME and AP_TAX_CODES_ALL.TAX_TYPE cannot be 'OFFSET'.
Destination: PO_VENDOR_SITES_ALL.VAT_CODE

DISTRIBUTION_SET_ID

The 'ID' is the unique identifier for the distribution set that will be applied to invoices from the supplier site. This corresponds to DISTRIBUTION_SET_NAME. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values represent a valid 'ID-NAME' combination. In a Non Multi-Org environment, this value defaults from PO_VENDORS.DISTRIBUTION_SET_ID. In a Multi-Org environment, there is no default.

Variable Description
Validation: AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID
Destination: PO_VENDOR_SITES_ALL.DISTRIBUTION_SET_ID

DISTRIBUTION_SET_NAME

This is the name for the distribution set that will be applied to invoices from the supplier site. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values represent a valid 'ID-NAME' combination.

Variable Description
Validation: AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_NAME
Destination: None. The value for PO_VENDOR_SITES_ALL.DISTRIBUTION_SET_ID may be derived from this column.

ACCTS_PAY_CODE_COMBINATION_ID

This will be the default liability account for invoices from the supplier site. In a Non Multi-Org environment, this value defaults from PO_VENDORS.ACCTS_PAY_CODE_COMBINATION_ID. In a Multi-Org environment, this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.ACCTS_PAY_CODE_COMBINATION_ID.

Variable Description
Validation: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID where ACCOUNT_TYPE = 'L' and CHART_OF_ACCOUNTS_ID = (SELECT CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF BOOKS where SET_OF_BOOKS_ID = &SITE_ORG_SET_OF_BOOKS_ID).
Destination: PO_VENDOR_SITES_ALL.ACCTS_PAY_CODE_COMBINATION_ID

PREPAY_CODE_COMBINATION_ID

This is the account that will be used for Prepayment Item distributions entered on invoices for the supplier site. In a Non Multi-Org environment, this value defaults from PO_VENDORS.PREPAY_CODE_COMBINATION_ID. In a Multi-Org environment, this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.PREPAY_CODE_COMBINATION_ID.

Variable Description
Validation: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID where CHART_OF_ACCOUNTS_ID = (SELECT CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = &SITE_ORG_SET_OF_BOOKS_ID).
Destination: PO_VENDOR_SITES_ALL.PREPAY_CODE_COMBINATION_ID

PAY_GROUP_LOOKUP_CODE

This is the Pay Group for the supplier site. This can be used in payment batch processing for grouping categories of suppliers. This value defaults from PO_VENDORS.PAY_GROUP_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'PAY GROUP'
Destination: PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE

PAYMENT_PRIORITY

A number between 1 and 99 that represents the payment priority for the supplier site. This value defaults from PO_VENDORS.PAYMENT_PRIORITY.

Variable Description
Validation: Must be a number from 1 to 99.
Destination: PO_VENDOR_SITES_ALL.PAYMENT_PRIORITY

TERMS_ID

The 'ID' is the unique identifier for the terms on invoices from the supplier site. This corresponds to TERMS_NAME. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination. This value defaults from PO_VENDORS.TERMS_ID.

Variable Description
Validation: AP_TERMS_TL.TERMS_ID
Destination: PO_VENDORS_SITES_ALL.TERMS_ID

TERMS_NAME

This column is the name of the terms that will default on invoices from the supplier site. This corresponds to TERMS_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination.

Variable Description
Validation: AP_TERMS_TL.TERMS_NAME
Destination: None. The value of PO_VENDOR_SITES_ALL.TERMS_ID may be derived from this column.

INVOICE_AMOUNT_LIMIT

This is the maximum amount allowed on invoices from the supplier site.

Variable Description
Validation: Must be a number.
Destination: PO_VENDOR_SITES_ALL.INVOICE_AMOUNT_LIMIT

PAY_DATE_BASIS_LOOKUP_CODE

The Pay Date Basis determines the pay date for the supplier site invoices: Discount or Due. This value defaults from PO_VENDORS.PAY_DATE_BASIS_LOOKUP_CODE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'PAY DATE BASIS'. Valid values are 'DISCOUNT' or 'DUE'.
Destination: PO_VENDOR_SITES_ALL.PAY_DATE_BASIS_LOOKUP_CODE

ALWAYS_TAKE_DISC_FLAG

Enable this option if all payments for the supplier site will be paid less the discount. This value defaults from PO_VENDORS.ALWAYS_TAKE_DISC_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDOR_SITES_ALL.ALWAYS_TAKE_DISC_FLAG

INVOICE_CURRENCY_CODE

This is the default currency for Purchasing documents and Payables transactions from the supplier site. This value defaults from PO_VENDORS.INVOICE_CURRENCY_CODE.

Variable Description
Validation: FND.CURRENCIES.CURRENCY_CODE. This value must match AP_SUPPLIER_SITES_INT.PAYMENT_CURRENCY_CODE unless currency is EMU derived.
Destination: PO_VENDORS_SITES_ALL.INVOICE_CURRENCY_CODE

PAYMENT_CURRENCY_CODE

This is the default currency for Payments to the supplier site. This value defaults from PO_VENDORS.PAYMENT_CURRENCY_CODE.

Variable Description
Validation: FND.CURRENCIES.CURRENCY_CODE. This value must match AP_SUPPLIER_SITES_INT.INVOICE_CURRENCY_CODE unless currency is EMU derived.
Destination: PO_VENDORS_SITES_ALL.PAYMENT_CURRENCY_CODE

HOLD_ALL_PAYMENTS_FLAG

Enable if payments for the supplier site are to be held. This value defaults from PO_VENDORS.HOLD_ALL_PAYMENTS_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDOR_SITES_ALL.HOLD_ALL_PAYMENTS_FLAG

HOLD_FUTURE_PAYMENTS_FLAG

Enable if unvalidated invoices for the supplier site should be held. This value defaults from PO_VENDORS.HOLD_FUTURE_PAYMENTS_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDOR_SITES_ALL.HOLD_FUTURE_PAYMENTS_FLAG

HOLD_REASON

The reason invoices are being held for the supplier site. This value defaults from PO_VENDORS.HOLD_REASON.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.HOLD_REASON

HOLD_UNMATCHED_INVOICES_FLAG

Indicates if unmatched invoices should be put on hold for the supplier site. This value defaults from PO_VENDORS.HOLD_UNMATCHED_INVOICES_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDOR_SITES_ALL.HOLD_UNMATCHED_INVOICES_FLAG

AP_TAX_ROUNDING_RULE

This column determines the rounding rule for tax values on invoices from the supplier site. If Non Multi-Org, this value defaults from PO_VENDORS.TAX_ROUNDING_RULE. If Mulit-Org, then this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.TAX_ROUNDING_RULE.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'AP_TAX_ROUNDING_RULE'. Valid values are: 'D', 'N', 'U'.
Destination: PO_VENDOR_SITES_ALL.AP_TAX_ROUNDING_RULE

AUTO_TAX_CALC_FLAG

This column indicates the level for automatic tax calculation for the supplier site. If Non Multi-Org, this value defaults from PO_VENDORS.AUTO_TAX_CALC_FLAG. If Multi-Org, this value defaults from AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_FLAG.

Variable Description
Validation: Non Multi-Org environment: If PO_VENDORS.AUTO_TAX_CALC_OVERRIDE = 'N', this value must match the value of PO_VENDORS.AUTO_TAX_CALC_FLAG. Multi-Org enviroment: If AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_OVERRIDE = 'N', this value must match the value of AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_FLAG. Valid values found in FND_LOOKUP_VALUES.LOOKUP_TYPE = 'AP_TAX_CALCULATION_METHOD'
Destination: PO_VENDOR_SITES_ALL.AUTO_TAX_CALC_FLAG

AUTO_TAX_CALC_OVERRIDE

Allows override of tax calculation for invoice entered for the supplier site. If Non Multi-Org, then this value defaults from PO_VENDORS.AUTO_TAX_CALC_OVERRIDE. If Multi-Org, then this value defaults from AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_OVERRIDE.

Variable Description
Validation: Non Multi-Org environment: If PO_VENDORS.AUTO_TAX_CALC_OVERRIDE = 'N', this value must also be 'N'. Mult-Org environment: If AP_SYSTEM_PARAMETERS_ALL.AUTO_TAX_CALC_OVERRIDE = 'N', this value must also be 'N'.
Destination: PO_VENDOR_SITES_ALL.AUTO_TAX_CALC_OVERRIDE

AMOUNT_INCLUDES_TAX_FLAG

This column indicates if amounts on invoices from the supplier include tax. If Non Multi-Org, then this value defaults from PO_VENDORS.AMOUNT_INCLUDES_TAX_FLAG. If Multi-Org, then this value defaults from AP_SYSTEM_PARAMETERS_ALL.AMOUNT_INCLUDES_TAX_FLAG.

Variable Description
Validation: Non Multi-Org environment: If PO_VENDORS.AUTO_TAX_CALC_FLAG = 'Y', this value cannot be 'Y'. Multi-Org environment: If AP_SYSTEM_PARAMETERS_ALL AUTO_TAX_CALC_FLAG = 'Y', this value cannot be 'Y'. Also, if: AP_SYSTEM_PARAMETERS_ALL.AMOUNT_INCLUDES_TAX_OVERRIDE = 'N', this value must match AP_SYSTEM_PARAMETERS_ALL.AMOUNT_INCLUDES_TAX_FLAG FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS_SITES_ALL.AMOUNT_INCLUDES_TAX_FLAG

EXCLUSIVE_PAYMENT_FLAG

Indicates whether or not separate payments should be created for each invoice issued by the supplier site. This value defaults from PO_VENDORS.EXCLUSIVE_PAYMENT_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS_SITES_ALL.EXCLUSIVE_PAYMENT_FLAG

TAX_REPORTING_SITE_FLAG

Indicates whether or not the site is the 1099-reporting site for the supplier. All 1099 reportable suppliers must have one and only one site designated as the tax-reporting site. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO' and no other site for the supplier is designated as a tax reporting site.
Destination: PO_VENDOR_SITES_ALL.TAX_REPORTING_SITE_FLAG

ATTRIBUTE_CATEGORY

This is the descriptive flexfield category for the descriptive flexfield information for the supplier site.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.ATTRIBUTE_CATEGORY

ATTRIBUTES (1-15)

These columns are descriptive flexfield information for the supplier site. The import process will not validate the information entered in these columns. However, the structure of the information entered (data types, value sets) must match the structure of the descriptive flexfield segments defined for supplier sites, or users will experience validation problems when trying to access the information through the application.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.ATTRIBUTE[1-15]

Validation number.

EXCLUDE_FREIGHT_FROM_DISCOUNT

Indicates if the freight amount is to be excluded from the discount on invoices issued by the supplier site. This value defaults from PO_VENDORS.EXCLUDE_FREIGHT_FROM_DISCOUNT.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS_SITES_ALL.EXCLUDE_FREIGHT_FROM_DISCOUNT

VAT_REGISTRATION_NUM

This is the tax registration number for the supplier site. This value defaults from PO_VENDORS.VAT_REGISTRATION_NUM.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.VAT_REGISTRATION_NUM

ORG_ID

This is the unique identifier for the operating unit. This corresponds to the OPERATING_UNIT_NAME. A value must be provided for at least one of these columns. If both are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination.

Variable Description
Validation: HR_OPERATING_UNITS.ORGANIZATION_ID
Destination: PO_VENDOR_SITES_ALL.ORG_ID

OPERATING_UNIT_NAME

This is the name for the operating unit. This corresponds to the ORG_ID. A value must be provided for at least one of these columns. If both are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination.

Variable Description
Validation: HR_OPERATING_UNITS.NAME
Destination: None. The value of PO_VENDOR_SITES_ALL.ORG_ID may be derived from this column.

ADDRESS_LINE4

This is the fourth line of the supplier site address.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.ADDRESS_LINE4

COUNTY

Supplier site county.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.COUNTY

ADDRESS_STYLE

This is the address style for the supplier site.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'ADDRESS_STYLE'
Destination: PO_VENDORS_SITES_ALL.ADDRESS_STYLE

LANGUAGE

This is the language for the supplier site.

Variable Description
Validation: FND_LANGUAGE.NLS_LANGUAGE
Destination: PO_VENDORS_SITES_ALL.LANGUAGE

ALLOW_AWT_FLAG

This flag indicates whether automatic withholding is allowed for the supplier site. This value defaults from PO_VENDORS.ALLOW_AWT_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'. If PO_VENDORS.ALLOW_AWT_FLAG is 'N', this option is not available for Supplier Sites.
Destination: PO_VENDOR_SITES_ALL.ALLOW_AWT_FLAG

AWT_GROUP_ID

This is the unique identifier for the automatic withholding tax group that will default for supplier site invoices. This corresponds to the AWT_GROUP_NAME. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination. This value defaults from PO_VENDORS.AWT_GROUP_ID.

Variable Description
Validation: Only allowed if PO_VENDORS_SITES_ALL.ALLOW_AWT_FLAG = 'Y'. Validated against: AP_AWT_GROUPS.GROUP_ID
Destination: PO_VENDOR_SITES_ALL.AWT_GROUP_ID

AWT_GROUP_NAME

This is the name for the automatic withholding tax group that will default for supplier site invoices. This corresponds to the AWT_GROUP_ID. A value can be provided for either or both columns. If both are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination.

Variable Description
Validation: Only allowed if PO_VENDORS_SITES_ALL.ALLOW_AWT_FLAG = 'Y'. Validated against: AP_AWT_GROUPS.GROUP_NAME.
Destination: None. The value for PO_VENDOR_SITES_ALL.AWT_GROUP_ID may be derived from this column.

GLOBAL_ATTRIBUTES (1-20)

This is the descriptive flexfield information for the supplier site. The structure of the information entered in these columns (data types, value sets) must match the structure of the descriptive flexfield segments defined for supplier site, or users will experience validation problems when trying to access the information through the application.

Variable Description
Validation: None
Destination: PO_VENDORS_SITES_ALL.GLOBAL_ATTRIBUTES [1-20]

GLOBAL_ATTRIBUTE_CATEGORY

This is the descriptive flexfield category for the descriptive flexfield information for import.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE_CATEGORY

EDI_TRANSACTION_HANDLING

This is the standard EDI transaction code designating action to be taken by all parties. This value defaults from PO_VENDORS.EDI_TRANSACTION_HANDLING.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI TRANSACTION HANDLING'
Destination: PO_VENDOR_SITES_ALL.EDI_TRANSACTION_HANDLING

EDI_ID_NUMBER

This is the EDI trading partner number for the supplier site.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.EDI_ID_NUMBER

EDI_PAYMENT_METHOD

This column indicates how EDI payments will be made. This value defaults from PO_VENDORS.EDI_PAYMENT_METHOD.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI PAYMENT METHOD'
Destination: PO_VENDOR_SITES_ALL.EDI_PAYMENT_METHOD

EDI_PAYMENT_FORMAT

This column indicates the type of information being transmitted when EDI Payment Method is 'ACH'. This value defaults from PO_VENDORS.EDI_PAYMENT_FORMAT.

Variable Description
Validation: Valid only if EDI_PAYMENT_METHOD = 'ACH'. Validated against FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI PAYMENT FORMAT'
Destination: PO_VENDORS_SITES_ALL.EDI_PAYMENT_FORMAT

EDI_REMITTANCE_METHOD

This column indicates the party responsible for sending remittance advice to the payee. This value defaults from PO_VENDORS.EDI_REMITTANCE_METHOD.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'EDI REMITTANCE METHOD'
Destination: PO_VENDOR_SITES_ALL.EDI_REMITTANCE_METHOD

BANK_CHARGE_BEARER

This column indicates who will pay bank charges assessed on payments to the supplier site. This value defaults from PO_VENDORS.BANK_CHARGE_BEARER.

Variable Description
Validation: If AP_SYSTEM_PARAMETERS_ALL.USE_BANK_CHARGE_FLAG = 'N', then this option is not available for supplier sites. If AP_SYSTEM_PARAMETERS_ALL.USE_BANK_CHARGES_FLAG= 'Y', validated against FND_LOOKUP_VALUES where LOOKUP_TYPE = 'BANK CHARGE BEARER'. Valid values are: 'I', 'N', 'S'.
Destination: PO_VENDOR_SITES_ALL.BANK_CHARGE_BEARER

EDI_REMITTANCE_INSTRUCTION

This is the text of electronic payment instructions for a financial institution. This value defaults from PO_VENDORS.EDI_REMITTANCE_INSTRUCTION.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.EDI_REMITTANCE_INSTRUCTION

PAY_ON_CODE

If the Oracle Purchasing 'Self Billing' feature is used, this column indicates when the invoice is to be created.

Variable Description
Validation: Value for this column is only valid if AP_SUPPLIER_SITES_INT.PURCHASING_SITE_FLAG = 'Y'. Valid values are 'RECEIPT', 'USE', or 'RECEIPT_AND_USE'.
Destination: PO_VENDOR_SITES_ALL.PAY_ON_CODE

DEFAULT_PAY_SITE_ID

This is the supplier site from which payments will be made for invoices created by the 'Payment on Receipt' process.

Variable Description
Validation: If the current site is not a pay site (PAY_SITE_FLAG = 'N'), then a valid pay site for the current org must be entered in this column. Validation is then done against: AP_SUPPLIER_SITES_ALL.VENDOR_SITE_ID where VENDOR_ID = &THIS_SUPPLIER, ORG_ID, and PAY_SITE_FLAG = 'Y'
Destination: PO_VENDOR_SITES_ALL.DEFAULT_PAY_SITE_ID

PAY_ON_RECEIPT_SUMMARY_CODE

This column indicates the level at which invoices will be consolidated for the supplier site by the 'Payment on Receipt' process. The default value is PAY_SITE.

Variable Description
Validation: Values for this column are allowed only if a valid value is provided for AP_SUPPLIER_SITES_INT.PAY_ON_CODE. When AP_SUPPLIER_SITES_INT.PAY_ON_CODE = 'RECEIPT' valid values are: 'PACKING_SLIP', 'PAY_SITE', or 'RECEIPT'. When AP_SUPPLIER_SITES_INT.PAY_ON_CODE = USE, valid values are: 'CONSUMPTION_ADVICE' or 'PAY_SITE' When AP_SUPPLIER_SITES_INT.PAY_ON_CODE = RECEIPT_AND_USE, only valid value is: 'PAY_SITE'.
Destination: PO_VENDOR_SITES_ALL.PAY_ON_RECEIPT_SUMMARY_CODE

TP_HEADER_ID

EDI transaction header unique identifier.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.TP_HEADER_ID

ECE_TP_LOCATION_CODE

Trading partner location code for e-Commerce Gateway.

Variable Description
Validation: None
Destination: PO_VENDORS_SITES_ALL.ECE_TP_LOCATION_CODE

PCARD_SITE_FLAG

This column indicates whether this supplier site uses the credit card brand used in the procurement card program of the enterprise or company. This value defaults to 'N'.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDOR_SITES_ALL.PCARD_SITE_FLAG

MATCH_OPTION

This column indicates if invoices are matched to a purchase order or to a receipt. This value defaults from PO_VENDORS.MATCH_OPTION.

Variable Description
Validation: Valid values are: 'P' (meaning: Purchase Order) and 'R' (meaning: Receipt).
Destination: PO_VENDOR_SITES_ALL.MATCH_OPTION

COUNTRY_OF_ORIGIN_CODE

This column indicates the country in which goods are manufactured.

Variable Description
Validation: FND_TERRITORIES_TL.TERRITORIES_CODE
Destination: PO_VENDOR_SITES_ALL.COUNTRY_OF_ORIGIN_CODE

FUTURE_DATED_PAYMENT_CCID

If future dated payments are used, the value entered here will be the account used for the supplier site. If Non Multi-Org, this value defaults from PO_VENDORS.FUTURE_DATED_PAYMENT_CCID. If Multi-Org, this value defaults from FINANCIALS_SYSTEM_PARAMS_ALL.FUTURE_DATED_PAYMENT_CCID.

Variable Description
Validation: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID where CHART_OF_ACCOUNTS_ID = (SELECT CHART_OF_ACCOUNTS_ID FROM GL_SET_OF_BOOKS where SET_OF_BOOKS_ID = &SITE_ORG_SET_OF_BOOKS_ID)
Destination: PO_VENDOR_SITES_ALL.FUTURE_DATED_PAYMENT_CCID

CREATE_DEBIT_MEMO_FLAG

This column indicates whether debit memos are to be created automatically when a Return to Supplier transaction is entered in Oracle Purchasing.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'
Destination: PO_VENDORS_SITES_ALL.CREATE_DEBIT_MEMO_FLAG

OFFSET_TAX_FLAG

This column indicates whether offset taxes are allowed on invoices from the supplier site. This value defaults from PO_VENDORS.OFFSET_TAX_FLAG.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO'. Also, if PO_VENDORS.VENDOR_TYPE_LOOKUP_CODE = 'EMPLOYEE', value cannot be 'Y'.
Destination: PO_VENDOR_SITES_ALL.OFFSET_TAX_FLAG

SUPPLIER_NOTIF_METHOD

This column indicates the primary method for sending purchase orders to the supplier site. This value defaults to 'EMAIL'.

Variable Description
Validation: The following hard-coded values: 'EMAIL', 'PRINT', 'FAX'
Destination: PO_VENDOR_SITES_ALL.SUPPLIER_NOTIF_METHOD

EMAIL_ADDRESS

This is the email address of the supplier site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.EMAIL_ADDRESS

REMITTANCE_EMAIL

This is the email address where remittance advice will be sent. Populating this column activates the E-mail Remittance advice feature in Payables.

Variable Description
Validation: None
Destination: PO_VENDOR_SITES_ALL.REMITTANCE_EMAIL

PRIMARY_PAY_SITE_FLAG

This column indicates the default pay site for the supplier site.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'YES/NO' and only one site per operating unit can have value = 'Y'.
Destination: PO_VENDORS_SITES_ALL.PRIMARY_PAY_SITE_FLAG

STATUS

This column indicates the current status of the record in the interface table. The user should enter 'NEW' as the initial value for this column. After the Supplier Sites Open Interface Import program is run, successfully imported records will be marked as 'PROCESSED' and records that are not imported will be marked 'REJECTED'.

Variable Description
Validation: N/A
Destination: None

REJECT_CODE

This column indicates the reason the record has been rejected by the Supplier Sites Open Interface Import Program. This column is populated by the Supplier Sites Open Interface Import Program and should not be entered by the user.

Variable Description
Validation: N/A
Destination: None

SHIPPING_CONTROL

Indicates the party responsible for arranging transportation: supplier or buyer.

Variable Description
Validation: FND_LOOKUP_VALUES.LOOKUP_TYPE = 'SHIPPING CONTROL'. Valid values are 'SUPPLIER' or 'BUYER'.
Destination: PO_VENDOR_SITES_ALL.SHIPPING_CONTROL

DUNS_NUMBER

This column is A unique 9-digit identification number assigned to all business entities in Dun & Bradstreet's database. Used only for Federal Financial installations.

Variable Description
Validation: N/A
Destination: None

TOLERANCE_ID

This column is the Tolerance Template Identifier

Variable Description
Validation: N/A
Destination: None

TOLERANCE_NAME

This column is the Tolerance Template Name

Variable Description
Validation: N/A
Destination: None

IBY_BANK_CHARGE_BEARER

This column is the bearer of bank charge cost

Variable Description
Validation: N/A
Destination: None

BANK_INSTRUCTION(1-2)_CODE

These columns are the bank instruction codes.

Variable Description
Validation: N/A
Destination: None

BANK_INSTRUCTION_DETAILS

This column is the additional bank instruction details

Variable Description
Validation: N/A
Destination: None

PAYMENT_REASON_CODE

This column is the payment reason code

Variable Description
Validation: N/A
Destination: None

PAYMENT_REASON_COMMENTS

This column is a free text field available for entering a reason

Variable Description
Validation: N/A
Destination: None

DELIVERY_CHANNEL_CODE

This column is the default delivery channel code

Variable Description
Validation: N/A
Destination: None

PAYMENT_FORMAT_CODE

This column is the default payment format code

Variable Description
Validation: N/A
Destination: None

SETTLEMENT_PRIORITY

This column is the priority for payments settlement

Variable Description
Validation: N/A
Destination: None

PAYMENT_TEXT_MESSAGE(1-3)

These columns are text messages for use in payment processing

Variable Description
Validation: N/A
Destination: None

VENDOR_SITE_INTERFACE_ID

This column is the vendor site interface identifier

Variable Description
Validation: N/A
Destination: None

PAYMENT_METHOD_CODE

This column is the payment method identifier

Variable Description
Validation: N/A
Destination: None

RETAINAGE_RATE

This column is the maximum percentage that can be withheld from an invoice as Retainage

Variable Description
Validation: N/A
Destination: None

GAPLESS_INV_NUM_FLAG

This column is the Gapless Invoice Numbering Flag

Variable Description
Validation: N/A
Destination: None

SELLING_COMPANY_IDENTIFIER

This column is the Unique Selling Company Identifier for Supplier

Variable Description
Validation: N/A
Destination: None

AP_SUP_SITE_CONTACT_INT

Column Name Null Type Comments
VENDOR_SITE_ID   NUMBER Required if value is not provided for VENDOR_SITE_CODE and ORG_ID and/or OPERATING_UNIT_NAME
VENDOR_SITE_CODE   VARCHAR2(15) Required if value is not provided for VENDOR_SITE_ID
ORG_ID   NUMBER(1) A value is required for this column or OPERATING_UNIT_NAME.
OPERATING_UNIT_NAME   NUMBER(1) A value is required for this column or ORG_ID.
INACTIVE_DATE   DATE N/A
FIRST_NAME   VARCHAR2(15) N/A
MIDDLE_NAME   VARCHAR2(15) N/A
LAST_NAME   VARCHAR2(20) Required
PREFIX   VARCHAR2(5) N/A
TITLE   VARCHAR2(30) N/A
MAIL_STOP   VARCHAR2(35) N/A
AREA_CODE   VARCHAR2(10) N/A
PHONE   VARCHAR2(15) N/A
CONTACT_NAME_ALT   VARCHAR2(320) N/A
FIRST_NAME_ALT   VARCHAR2(230) N/A
LAST_NAME_ALT   VARCHAR2(230) N/A
DEPARTMENT   VARCHAR2(230) N/A
EMAIL_ADDRESS   VARCHAR2(200) N/A
URL   VARCHAR2(2000) N/A
ALT_AREA_CODE   VARCHAR2(10) N/A
ALT_PHONE   VARCHAR2(15) N/A
FAX_AREA_CODE   VARCHAR2(10) N/A
FAX   VARCHAR2(15) N/A
STATUS   VARCHAR2(30) N/A
REJECT_CODE   VARCHAR2(2000) N/A

VENDOR_SITE_ID

This is the unique identifier for the supplier site. This column is used to join the contact to the appropriate supplier site. A value must be provided for this column or for the VENDOR_SITE_CODE and either ORG_ID or OPERATING_UNIT_NAME.

Variable Description
Validation: PO_VENDOR_SITES_ALL.VENDOR_SITE_ID
Destination: PO_VENDOR_CONTACTS.VENDOR_SITE_ID

VENDOR_SITE_CODE

This is the name for a supplier site. This column is used to join the contact to the appropriate supplier site. A value must be provided for this column along with either ORG_ID or OPERATING_UNIT_NAME if no value is present for VENDOR_SITE_ID.

Note: The VENDOR_SITE_CODE is not a unique value. More than one vendor can have a site with the same name. If the VENDOR_SITE_CODE is shared by more than one VENDOR in the organization, then you must enter the VENDOR_SITE_ID.

Variable Description
Validation: AP_SUPPLIER_SITES_INT.VENDOR_SITE_CODE
Destination: None

ORG_ID

This is the unique identifier for the operating unit. This corresponds to the OPERATING_UNIT_NAME. A value must be provided for the ORG_ID or the OPERATING_UNIT_NAME column, along with the VENDOR_SITE_ID or the VENDOR_SITE_CODE column. These values are used during the import process to join the contact with the proper supplier site. If both 'ID' and 'NAME' are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination. Additionally, a check will be done to confirm that the VENDOR_SITE_CODE/ORG_ID combination is also valid.

Variable Description
Validation: HR_OPERATING_UNITS.ORGANIZATION_ID, as well as PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE and PO_VENDOR_SITES_ALL.ORG_ID
Destination: None

OPERATING_UNIT_NAME

This is the name for the operating unit. This corresponds to the ORG_ID. A value must be provided for the OPERATING_UNIT_NAME or the ORG_ID column, along with the VENDOR_SITE_ID or the VENDOR_SITE_CODE column. These values are used during the import process to join the contact with the proper supplier site. If both 'ID' and 'NAME' are provided, the system will check to ensure that the values match a valid 'ID-NAME' combination. Additionally, a check will be done to confirm that the VENDOR_SITE_CODE/ORG_ID combination is also valid.

Variable Description
Validation: HR_OPERATING_UNITS.NAME, as well as PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE and PO_VENDOR_SITES_ALL.ORG_ID
Destination: None

INACTIVE_DATE

The date on which the contact is no longer valid.

Variable Description
Validation: Must be in valid date format.
Destination: PO_VENDOR_CONTACTS.INACTIVE_DATE

FIRST_NAME

This is the first name of the supplier contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.FIRST_NAME

MIDDLE_NAME

This is the middle name of the supplier contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.MIDDLE_NAME

LAST_NAME

This is the last name of the supplier contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.LAST_NAME

PREFIX

This indicates the prefix for the supplier contact (Mr., Mrs., etc.)

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.PREFIX

TITLE

This indicates the title for the supplier contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.TITLE

MAIL_STOP

This indicates the mail stop for the supplier contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.MAIL_STOP

AREA_CODE

This indicates the area code for the phone number of the supplier contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.AREA_CODE

PHONE

This indicates the phone number of the supplier contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.PHONE

CONTACT_NAME_ALT

This is an alternate name for the contact for the supplier site. This column is designed for entering both Kanji and Kana values.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.CONTACT_NAME_ALT

FIRST_NAME_ALT

This is an alternate first name for the contact for the supplier site. This column is designed for entering both Kanji and Kana values.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.FIRST_NAME_ALT

LAST_NAME_ALT

This is an alternate last name for the contact for the supplier site. This column is designed for entering both Kanji and Kana values.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.LAST_NAME_ALT

DEPARTMENT

This is the department for the supplier site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.DEPARTMENT

EMAIL_ADDRESS

Email address for the Supplier Site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.EMAIL_ADDRESS

URL

URL for the Supplier Site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.URL

ALT_AREA_CODE

Area code for the alternate telephone number for the Supplier Site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.ALT_AREA_CODE

ALT_PHONE

Alternate telephone number for the Supplier Site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.ALT_PHONE

FAX_AREA_CODE

Area code of the facsimile number for the Supplier Site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.FAX_AREA_CODE

FAX

Facsimile number for the Supplier Site contact.

Variable Description
Validation: None
Destination: PO_VENDOR_CONTACTS.FAX

STATUS

Indicates the status of the record in the interface table. The user should enter 'NEW' as the initial value for this column. After the Supplier Site Contacts Open Interface Import program is run, successfully imported records will be marked as 'PROCESSED' and records that are not imported will be marked 'REJECTED'.

Variable Description
Validation: N/A
Destination: None

REJECT_CODE

Indicates the reason the record has been rejected by the Supplier Site Contacts Open Interface Import Program. This column is populated by the Supplier Sites Open Interface Import Program and should not be entered by the user.

Variable Description
Validation: N/A
Destination: None

Sequential Numbering During Import

There are two methods you can use for sequential numbering when you use the Payables Open Interface:

If you enter a value for DOC_CATEGORY_CODE, then Payables will ignore any value you enter for VOUCHER_NUM, so automatic voucher numbering will always supersede manual entry.

Account Overlay in Payables Open Interface Import

You can use the Account Overlay feature to overwrite one or more account segments of a line expense or asset account. For example, if you are matching to a purchase order and you know that the cost center on the purchase order is incorrect, then the Account Overlay feature can correct this for you automatically during import if you enter a value for COST_CENTER_SEGMENT.

Note: If a record is matching to a particular shipment and accrued on receipt and an overlay account exists in any of the overlay segments, then the invoice will be rejected.

Variable Description
Rejection Text: Line is matched to a shipment, which uses accrual on receipt, and overlay segment is specified.
Rejection Reason: Accrual on Receipt
Line is matched to a shipment and uses accrual on receipt.

There are five ways that an invoice distribution can get accounting information when it is imported from the Payables Open Interface tables:

During Payables Open Interface import, the system uses values in the following AP_INVOICE_LINES_INTERFACE table columns to overlay the account:

BALANCING_SEGMENT, COST_CENTER_SEGMENT, and ACCOUNT_SEGMENT will overlay any values in DIST_CODE_CONCATENATED.

In summary, the hierarchy for overlay is as follows. Import builds the account by overlaying the account with any values at each successive level:

For example, if you have the following values for a line, then during import, Payables will create the Invoice Account below for the line:

This table shows how the Account Overlay feature creates an Invoice Account during the Payables Open Interface Import process. In this example, an invoice has values for an account, overlay GL account, account segment, cost center segment, and balancing segment. The resulting invoice account is based on the consecutive overlaying of these values for the different account segments.

Account 00. 000. 000. 2210. 000. 0000
Overlay GL Account 01. . . . 110. 8000
Account Segment       7710    
Cost Center Segment     120      
Balancing Segment 02          
             
Invoice Account 02. 000. 120. 7710. 110. 8000

The final account for the invoice must be a valid account in your chart of accounts or the invoice will be rejected during import.

How the Quick Invoices Window Populates the Payables Open Interface Tables

If you use the Quick Invoices window to enter invoice records, you may find the following tables helpful in understanding the Rejections Report. The following tables shows the column that is populated by each Quick Invoices field. Note that internal ID columns are populated, when available, to enhance performance.

The following table lists fields in the Quick Invoices header and the corresponding column in the AP_INVOICES_ INTERFACE table.

Quick Invoices Header Field Corresponding Column in AP_INVOICES_INTERFACE
Withholding Tax Group AWT_GROUP_ID
Description DESCRIPTION
Discountable Amount AMOUNT_APPLICABLE_TO_DISCOUNT
Document Category DOC_CATEGORY_CODE
Exchange Date EXCHANGE_DATE
Exchange Rate EXCHANGE_RATE
Exchange Rate Type EXCHANGE_RATE_TYPE
GL Date GL_DATE
Goods Received Date GOODS_RECEIVED_DATE
Invoice Amount INVOICE_AMOUNT
Invoice_Curr INVOICE_CURRENCY_CODE
Invoice_Date INVOICE_DATE
Invoice Num INVOICE_NUM
Invoice Received Date INVOICE_RECEIVED_DATE
Invoice Type INVOICE_TYPE_LOOKUP_CODE
Liability Account ACCTS_PAY_CODE_COMBINATION_ID
Pay Alone EXCLUSIVE_PAYMENT_FLAG
Payment Curr PAYMENT_CURRENCY_CODE
Pay Group PAY_GROUP_LOOKUP_CODE
Payment Method PAYMENT_METHOD_LOOKUP_CODE
Payment Rate PAYMENT_CROSS_RATE
Payment Rate Date PAYMENT_CROSS_RATE_DATE
Payment Rate Type PAYMENT_CROSS_RATE_TYPE
PO Number PO_NUMBER
Prepay Apply Amount PREPAY_APPLY_AMOUNT
Prepayment Distribution PREPAY_DIST_NUM
Prepayment GL Date PREPAY_GL_DATE
Prepayment Number PREPAY_NUM
Site VENDOR_SITE_ID
Supplier VENDOR_ID
Supplier Num VENDOR_ID
Terms TERMS_ID
Transaction Code USSGL_TRANSACTION_CODE
Voucher Num VOUCHER_NUM
Withholding Tax Group AWT_GROUP_ID
(Descriptive Flexfield) ATTRIBUTE [1-15]
(Localization Descriptive Flexfield) GLOBAL_ATTRIBUTE [1-20]

The following table lists display-only fields in the Quick Invoices header and the corresponding column in the AP_INVOICES_ INTERFACE table.

Quick Invoices Display-Only Header Fields Corresponding Column in AP_INVOICES_INTERFACE
Invoice Total INVOICE_AMOUNT
Source SOURCE
Gateway Batch GROUP_ID
Request ID REQUEST_ID
Status STATUS

The following table lists fields in the Quick Invoices lines region and the corresponding column in the AP_INVOICE_ LINES_INTERFACE table.

Quick Invoices Field Lines Region Corresponding Column in AP_INVOICE_LINES_INTERFACE
1099 Type TYPE_1099
Account DIST_CODE_COMBINATION_ID
Account Segment ACCOUNT_SEGMENT
Amount AMOUNT
Balancing Segment BALANCING_SEGMENT
Cost Center Segment COST_CENTER_SEGMENT
Description DESCRIPTION
Distribution Set DISTRIBUTION_SET_ID
Expenditure Item Date EXPENDITURE_ITEM_DATE
Expenditure Organization EXPENDITURE_ORGANIZATION_ID
Expenditure Type EXPENDITURE_TYPE
Final Match FINAL_MATCH_ID
GL Date ACCOUNTING_DATE
Includes Tax AMOUNT_INCLUDES_TAX_FLAG
Income Tax Region INCOME_TAX_REGION
Line Number INVOICE_LINE_ID
Match Option MATCH_OPTION
Oracle Projects Project PROJECT_ACCOUNTING_CONTEXT
Overlay GL Account DIST_CODE_CONCATENATED
PO Distribution Number PO_DISTRIBUTION_ID
PO Item Description DESCRIPTION
PO Line Number PO_LINE_ID
PO Number PO_HEADER_ID
PO Shipment Number PO_LINE_LOCATION_ID
PO Unit of Measure PO_UNIT_OF_MEASURE
PO Unit Price UNIT_PRICE
Price Correction PRICE_CORRECTION_FLAG
Project PROJECT_ID
Project Quantity PA_QUANTITY
Prorate Across PRORATE_ACROSS_FLAG
Prorate Group LINE_GROUP_NUMBER
Quantity Invoiced QUANTITY_INVOICED
Receipt Number RECEIPT_NUMBER
Recoverable TAX_RECOVERABLE_FLAG
Release Num PO_RELEASE_ID
Ship-To Location PO_LINE_LOCATION_ID
Statistical Quantity TASK_ID
Task TASK_ID
Track as Asset ASSETS_TRACKING_FLAG
Transaction Code USSGL_TRANSACTION_CODE
Type LINE_TYPE_LOOKUP_CODE
Withholding Tax Group AWT_GROUP_ID
(Descriptive Flexfield) ATTRIBUTE [1-15]
(Localization Descriptive Flexfield) GLOBAL_ATTRIBUTE [1-20]