Previous | Next | Contents | Index | Navigation | Glossary | Library |
Column Name | Null | Type | Comments |
---|---|---|---|
INVOICE_ID | NOT NULL | NUMBER(15) | Required, Primary key |
INVOICE_NUM | NOT NULL | VARCHAR2(50) | Required |
INVOICE_TYPE_ LOOKUP_CODE | VARCHAR2(25) | Optional | |
INVOICE_DATE | DATE | Optional | |
PO_HEADER_ID | NUMBER(15) | Optional | |
PO_NUMBER_ID | VARCHAR2(20) | Foreign key: PO_HEADERS. SEGMENT1 | |
VENDOR_ID | NUMBER(15) | Internal ID Foreign key: PO_VENDORS. VENDOR_ID | |
VENDOR_NUM | VARCHAR2(30) | Optional | |
VENDOR_NAME | VARCHAR2(80) | Optional | |
VENDOR_SITE_ID | NUMBER(15) | Internal ID Foreign key: PO_ VENDOR_SITES. VENDOR_SITE_ID | |
VENDOR_SITE_CODE | VARCHAR2(15) | Optional | |
INVOICE_AMOUNT | NUMBER | Required | |
INVOICE_ CURRENCY_CODE | VARCHAR2(15) | Optional Foreign key: FND_CURRENCIES. CURRENCY_CODE | |
EXCHANGE RATE | NUMBER | Foreign key: GL_DAILY_ CONVERSION_TYPES. CONVERSION_TYPE | |
EXCHANGE RATE TYPE | VARCHAR2(30) | ||
EXCHANGE_DATE | DATE | ||
PAYMENT_ CURRENCY_CODE | VARCHAR2(15) | Optional Foreign key: FND_CURRENCIES. CURRENCY_CODE | |
PAYMENT_ CROSS_RATE_TYPE | VARCHAR2(30) | Optional | |
PAYMENT_ CROSS_RATE | NUMBER | Optional | |
PAYMENT_CROSS_ RATE_DATE | DATE | Optional | |
TERMS_ID | NUMBER(15) | Internal ID Foreign key: AP_TERMS.TERMS_ID | |
TERMS_NAME | VARCHAR2(50) | Optional | |
DESCRIPTION | VARCHAR2(240) | Optional | |
AWT_GROUP_ID | NUMBER(15) | Internal ID Foreign key: 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 | |
ATTRIBUTE1 | VARCHAR2(150) | Optional | |
ATTRIBUTE2 | VARCHAR2(150) | Optional | |
ATTRIBUTE3 | VARCHAR2(150) | Optional | |
ATTRIBUTE4 | VARCHAR2(150) | Optional | |
ATTRIBUTE5 | VARCHAR2(150) | Optional | |
ATTRIBUTE6 | VARCHAR2(150) | Optional | |
ATTRIBUTE7 | VARCHAR2(150) | Optional | |
ATTRIBUTE8 | VARCHAR2(150) | Optional | |
ATTRIBUTE9 | VARCHAR2(150) | Optional | |
ATTRIBUTE10 | VARCHAR2(150) | Optional | |
ATTRIBUTE11 | VARCHAR2(150) | Optional | |
ATTRIBUTE12 | VARCHAR2(150) | Optional | |
ATTRIBUTE13 | VARCHAR2(150) | Optional | |
ATTRIBUTE14 | VARCHAR2(150) | Optional | |
ATTRIBUTE15 | VARCHAR2(150) | Optional | |
GLOBAL_ ATTRIBUTE_CATEGORY | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE1 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE2 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE3 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE4 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE5 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE6 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE7 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE8 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE9 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE10 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE11 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE12 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE13 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE14 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE15 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE16 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE17 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE18 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE19 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE20 | VARCHAR2(150) | Optional | |
WORKFLOW_FLAG | VARCHAR2(1) | Optional | |
SOURCE | VARCHAR2(80) | Required | |
GROUP_ID | NUMBER | Optional | |
STATUS | NULL | VARCHAR2(25) | |
REQUEST_ID | NULL | NUMBER | |
Table 1 - 26. AP_INVOICES_INTERFACE (Page 4 of 4) |
Validation: | None |
Destination: | None |
Validation: | You must assign a unique number for the supplier to the invoice. If you assign a duplicate number for the supplier, Payables Open Interface Import does not create an invoice from this record and lists this record on the Payables Open Interface Rejections Report. |
Destination: | AP_INVOICES.INVOICE_NUM |
Validation: | The value must be Credit or Standard. The invoice type must correspond to the invoice amount. For example, Credit invoices must have invoice Amounts less than zero. |
Destination: | AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE |
Validation: | The value must be in date format. |
Destination: | AP_INVOICES.INVOICE_DATE |
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 |
This value is used as a default for AP_INVOICE_LINES_INTERFACE.PO_NUMBER. To match an invoice to a purchase order, you do not need to enter a value here at the invoice level if you enter a value at the line level, AP_INVOICE_LINES_INTERFACE.PO_NUMBER.
Validation: | This value must match a valid, active purchase order that has not been final matched. You can obtain a list of valid values from PO_HEADERS.SEGMENT1. |
Destination: | None |
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.VENDOR_ID |
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.VENDOR_ID. |
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.VENDOR_ID. |
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.VENDOR_SITE_ID |
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. |
Destination: | None. This value is used to enter AP_INVOICES.VENDOR_SITE_ID. |
Validation: | This value must equal the sum of the AMOUNT values in the AP_INVOICE_LINES_INTERFACE table for distributions 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.INVOICE_AMOUNT |
You must enter a value for EXCHANGE_RATE if you enter a foreign currency code, and you have enabled the Require Exchange Rate Entry option in the Financials Options window, and you use USER as the exchange type. You should also enter a value for EXCHANGE_DATE. However, if your invoice currency and your functional currency are associated fixed-rate currencies, Payables will provide the fixed-rate as the exchange rate during import.
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.INVOICE_CURRENCY_CODE |
If the invoice currency has a fixed rate to your functional currency, then during import Payables will overwrite the 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.
Validation: | You must enter a value in this column if you enter a foreign currency code for this record, and your Require Rate Entry system option is enabled, and you enter USER in the EXCHANGE_RATE_TYPE column. |
Destination: | AP_INVOICES.EXCHANGE_RATE |
Validation: | Payables users four types of exchange rates: User, Spot, Corporate, 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 User as the exchange rate type, you must enter a value for EXCHANGE_RATE or the record will be rejected during import. |
Destination: | AP_INVOICES.EXCHANGE_RATE_TYPE |
Validation: | Must be in valid date format. |
Destination: | AP_INVOICES.EXCHANGE_DATE |
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.PAYMENT_CURRENCY_CODE |
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 EMUFIXED. If the invoice and payment currencies are the same, this value must be null. |
Destination: | AP_INVOICES.CROSS_RATE_TYPE |
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. If the invoice currency and payment currency are the same, you can enter 1 as the value. |
Destination: | AP_INVOICES.CROSS_RATE |
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.CROSS_RATE_DATE |
Validation: | Terms must be valid terms in the AP_TERMS table. |
Destination: | If not purchase order matched, AP_INVOICES.TERMS_ID. |
If you match the invoice to a purchase order, the system always uses the payment terms specified on the purchase order and ignores TERMS_NAME or TERMS_ID in this table. If you do not specify payment terms in the open interface tables or match to a purchase order, the system uses the supplier site payment terms.
Validation: | Terms must be valid, active terms in the AP_TERMS table. If you are matching to a purchase order, and the Terms_ID does not match the purchase order payment terms, the system uses the purchase order terms for the invoice it creates from this record. |
Destination: | None. This value may be used to enter a value for AP_INVOICES.TERMS_ID. |
Validation: | None |
Destination: | AP_INVOICES.DESCRIPTION |
Validation: | If this value is used during import, it must be a valid value in AP_AWT_GROUPS. |
Destination: | AP_INVOICES.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. |
Validation: | Value must be valid and active in AP_AWT_GROUPS |
Destination: | None |
Validation: | Must be in valid date format. |
Destination: | AP_INVOICES.LAST_UPDATED_DATE, AP_ PAYMENT_SCHEDULES.LAST_UPDATED_DATE |
Validation: | None |
Destination: | AP_INVOICES.LAST_UPDATED_BY, AP_ PAYMENT_SCHEDULES.LAST_UPDATED_BY |
Validation: | None |
Destination: | AP_INVOICES.AP_LAST_UPDATE_LOGIN, AP_PAYMENT_SCHEDULES.AP_LAST_UPDATE_LOGIN |
Validation: | Must be in valid date format. |
Destination: | AP_INVOICES.CREATION_DATE, AP_PAYMENT_SCHEDULES.CREATION_DATE |
Validation: | None |
Destination: | AP_INVOICES.CREATED_BY, AP_PAYMENT_SCHEDULES.CREATED_BY |
Validation: | None |
Destination: | AP_INVOICES.ATTRIBUTE_CATEGORY |
Validation: | None |
Destination: | AP_INVOICES.ATTRIBUTE[1-15] |
Validation: | None |
Destination: | AP_INVOICES.GLOBAL_ATTRIBUTE_ CATEGORY |
Validation: | None |
Destination: | AP_INVOICES.GLOBAL_ATTRIBUTE[1-20] |
Validation: | None |
Destination: | None |
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.
Validation: | You must enter the name exactly as you have defined the QuickCode in the QuickCodes window or Payables Open Interface Import will not create an invoice from the record. The QuickCode must have the Type SOURCE. See: Quickcodes. |
Destination: | AP_INVOICES.SOURCE |
Validation: | None |
Destination: | None |
Validation: | None |
Destination: | None |
Column Name | Null | Type | Comments |
---|---|---|---|
INVOICE_ID | NOT NULL | NUMBER(15) | Required Foreign key: AP_INVOICES_ INTERFACE |
INVOICE_LINE_ID | NUMBER(15) | Internal ID Primary key. Must be either NULL or Unique for the INVOICE_ID. | |
LINE_NUMBER | NUMBER(15) | Optional | |
LINE_TYPE_LOOKUP _CODE | NOT NULL | VARCHAR2(25) | Required |
LINE_GROUP_NUMBER | NUMBER | Optional | |
AMOUNT | NOT NULL | NUMBER | Required |
ACCOUNTING_DATE | DATE | ||
DESCRIPTION | VARCHAR2(240) | Optional | |
TAX_CODE | VARCHAR2(15) | Foreign key: AP_TAX_CODES. NAME | |
AMOUNT_INCLUDES_ TAX_FLAG | VARCHAR2(1) | Optional | |
PRORATE_ACROSS_ FLAG | VARCHAR2(1) | Optional | |
PO_HEADER_ID | NUMBER | Internal ID Foreign key: PO_HEADERS. PO_HEADER_ID | |
PO_NUMBER | VARCHAR2(20) | Optional Foreign key: PO_HEADERS. SEGMENT1 | |
PO_LINE_ID | NUMBER | Internal ID Foreign key: PO_LINES. PO_LINE_ID | |
PO_LINE_NUMBER | NUMBER | Optional Foreign key: PO_LINES. PO_LINE_NUM | |
PO_LINE_LOCATION_ID | NUMBER | Internal ID Foreign key: PO_LINE_ LOCATIONS. LINE_LOCATION_ID | |
PO_SHIPMENT_NUM | NUMBER | Optional Foreign key: PO_LINE_ LOCATIONS. SHIPMENT_NUM | |
PO_DISTRIBUTION_ID | NUMBER | Internal ID Foreign key: PO_DISTRIBUTIONS. PO_DISTRIBUTION_ ID | |
PO_DISTRIBUTION_ NUM | NUMBER | Optional Foreign key: PO_DISTRIBUTIONS. PO_DISTRIBUTION_ NUM | |
PO_UNIT_OF_MEASURE | VARCHAR2(25) | Optional | |
PO_RELEASE_ID | NUMBER | Optional Foreign key: PO_RELEASES_ALL | |
RELEASE_NUM | NUMBER | Optional | |
INVENTORY_ITEM_ID | NUMBER | Optional Foreign key: MTL_SYSTEM_ITEMS. INVENTORY_ITEM_ ID | |
ITEM_DESCRIPTION | VARCHAR2(240) | Optional | |
SHIP_TO_ LOCATION_CODE | VARCHAR2(25) | ||
QUANTITY_INVOICED | NUMBER | Optional | |
UNIT_PRICE | NUMBER | Optional | |
FINAL_MATCH_FLAG | VARCHAR2(1) | Optional | |
DISTRIBUTION_SET_ID | NUMBER(15) | Internal ID Foreign key: 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 Foreign key: GL_CODE_ COMBINATIONS. CODE_ COMBINATION_ID | |
AWT_GROUP_ID | NUMBER(15) | Internal ID Foreign key: AP_AWT_GROUPS. AWT_GROUP_ID | |
BALANCING_SEGMENT | VARCHAR2(25) | Optional | |
COST_CENTER | VARCHAR2(25) | Optional | |
ACCOUNT | VARCHAR2(25) | Optional | |
PROJECT_ ACCOUNTING_CONTEXT | VARCHAR2(30) | Projects | |
PROJECT_ID | NUMBER(15) | Internal ID Foreign key: PA_PROJECTS | |
TASK_ID | NUMBER(15) | Internal ID Foreign key: PA_TASKS | |
EXPENDITURE_ ORGANIZATION_ID | NUMBER(15) | Internal ID Foreign key: PER_ORGANIZATION_UNITS | |
EXPENDITURE_TYPE | VARCHAR2(30) | Foreign key: PA_EXPENDITURE_TYPES | |
EXPENDITURE_ ITEM_DATE | DATE | Foreign key: PZ_EXPENDITURE_TYPES | |
PA_ADDITION_FLAG | VARCHAR2(1) | Projects | |
PA_QUANTITY | NUMBER | Projects | |
AWT_GROUP_NAME | VARCHAR2(25) | Optional | |
LAST_UPDATE_DATE | DATE | Optional | |
LAST_UPDATED_BY | NUMBER(15) | Optional | |
LAST_UPDATE_LOGIN | NUMBER(15) | Optional | |
CREATED_BY | NUMBER(15) | Optional | |
CREATION_DATE | DATE | Optional | |
ATTRIBUTE CATEGORY | VARCHAR2(150) | Optional | |
ATTRIBUTE1 | VARCHAR2(150) | Optional | |
ATTRIBUTE2 | VARCHAR2(150) | Optional | |
ATTRIBUTE3 | VARCHAR2(150) | Optional | |
ATTRIBUTE4 | VARCHAR2(150) | Optional | |
ATTRIBUTE5 | VARCHAR2(150) | Optional | |
ATTRIBUTE6 | VARCHAR2(150) | Optional | |
ATTRIBUTE7 | VARCHAR2(150) | Optional | |
ATTRIBUTE8 | VARCHAR2(150) | Optional | |
ATTRIBUTE9 | VARCHAR2(150) | Optional | |
ATTRIBUTE10 | VARCHAR2(150) | Optional | |
ATTRIBUTE11 | VARCHAR2(150) | Optional | |
ATTRIBUTE12 | VARCHAR2(150) | Optional | |
ATTRIBUTE13 | VARCHAR2(150) | Optional | |
ATTRIBUTE14 | VARCHAR2(150) | Optional | |
ATTRIBUTE15 | VARCHAR2(150) | Optional | |
GLOBAL_ ATTRIBUTE_CATEGORY | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE1 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE2 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE3 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE4 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE5 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE6 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE7 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE8 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE9 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE10 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE11 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE12 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE13 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE14 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE15 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE16 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE17 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE18 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE19 | VARCHAR2(150) | Optional | |
GLOBAL_ATTRIBUTE20 | VARCHAR2(150) | Optional | |
Table 1 - 27. AP_INVOICE_LINES_INTERFACE (Page 5 of 5) |
Validation: | AP_INVOICES_INTERFACE.INVOICE_ID |
Destination: | None |
Validation: | The value must be a number. |
Destination: | None |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER |
Validation: | The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. These lookup codes are stored in the AP_LOOKUP_CODES table. |
Destination: | AP_INVOICE_DISTRIBUTIONS.LINE_TYPE_ LOOKUP_CODE |
Validation: | This value must be a positive whole number. |
Destination: | AP_INVOICE_DISTRIBUTIONS.LINE_GROUP_ NUMBER |
Validation: | If the total amount of all the invoice distributions does not equal the amount of the invoice that has the same INVOICE_ID, then Payables Open Interface Import will reject the invoice. |
Destination: | AP_INVOICE_DISTRIBUTIONS.AMOUNT |
Attention: 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).
Validation: | The date must be in an open accounting period. |
Destination: | AP_INVOICE_DISTRIBUTIONS.ACCOUNTING_DATE |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.DESCRIPTION |
Validation: | The tax name you enter must be a valid, active tax name with a type of SALES or user-defined. If you enter an invalid tax name in this column, the import program identifies the record as a rejection and does not create an invoice distribution. If you have enabled the Enforce Tax From Account Payables option, and your expense or asset account for this distribution has a tax name associated with it, you must enter the correct tax name. See: Deriving Tax From a Natural Account. |
Destination: | AP_INVOICE_DISTRIBUTIONS.VAT_CODE |
Validation: | The Tax Name is not a Use type tax. |
Destination: | None |
Payables prorates tax for Tax type lines, freight for Freight type lines, and miscellaneous for Miscellaneous type lines. The system assigns the expense account of the Item line to the new invoice distribution.
Validation: | None |
Destination: | None |
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 |
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 table. If you do not specify a supplier in the AP_INVOICE_DISTRIBUTIONS_INTERFACE table, the PO_NUMBER value is used to derive AP_INVOICE_DISTRIBUTIONS.VENDOR_ID, and if you do not specify the supplier site, the PO_NUMBER value is used to derive AP_INVOICE_DISTRIBUTIONS.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.
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 PO number. |
Destination: | None. This value is used to enter AP_INVOICES.PO_HEADER_ID. |
Validation: | This must be a valid value for PO_LINES.PO_LINE_ID. |
Destination: | None |
Alternatively, you can identify a purchase order line number by entering only an ITEM_ID or an ITEM_DESCRIPTION if the value exactly matches the ITEM_ID or ITEM_DESCRIPTION of exactly one purchase order line for the PO_NUMBER. For example, you can match to a line number by entering the ITEM_DESCRIPTION "books" for an invoice that has exactly one line with an ITEM_DESCRIPTION of "books".
Validation: | This must be a valid value for PO_LINES.PO_LINE_NUM. |
Destination: | None |
Validation: | This must be a valid value in PO_LINE_LOCATIONS.LINE_LOCATION_ID for the purchase order. |
Destination: | None |
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 value "Taipei".
Validation: | This must be a valid value for PO_LINE_LOCATIONS.SHIPMENT_NUM |
Destination: | None |
Validation: | This must be a valid value in INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ ID |
Destination: | None |
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 |
Validation: | If you enter a value here and it does not match the purchase order information, Payables Open Interface Import will reject this invoice. You can find a list of valid values in the MTL_UNITS_OF_MEASURE table. |
Destination: | None |
Validation: | This value must match a valid value in PO_RELEASES.PO_RELEASE_ID. |
Destination: | None |
Validation: | This value must match a valid value in PO_RELEASES.RELEASE_NUM. |
Destination: | None |
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, if a supplier has one purchase order for PCs and one line is for monitors, but you don't know the purchase order number, you can enter the proper INVENTORY_ITEM_ID for the PCs, and the system will match to the correct purchase order line.
Validation: | This value must match the purchase order MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID for exactly one line. |
Destination: | None |
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 proper description for the books, and the system will match to the correct purchase order line.
Validation: | The description must match PO_LINES.ITEM_DESCRIPTION. |
Destination: | None |
Validation: | This value must be a positive number. |
Destination: | AP_INVOICE_DISTRIBUTIONS.QUANTITY_ INVOICED |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.UNIT_PRICE |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.FINAL_MATCH_FLAG |
Do not enter a value here if you are matching this line to a purchase order or if you enter an account.
Validation: | This must be an existing, active value for AP_DISTRIBUTION_SETS.DISTRIBUTION_SET_ ID |
Destination: | None |
Do not enter a value in this column if you are matching to a purchase order or if you provide an account.
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 |
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.
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: | AP_INVOICE_DISTRIBUTIONS.CODE_ COMBINATION_ID |
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.ACCTS_PAY_CODE_ COMBINATION_ID |
Validation: | The account code must be valid. |
Destination: | AP_INVOICE_DISTRIBUTIONS.CODE_ COMBINATION_ID |
Validation: | The account code must be valid. |
Destination: | AP_INVOICE_DISTRIBUTIONS.CODE_ COMBINATION_ID |
Validation: | The account code must be valid. |
Destination: | AP_INVOICE_DISTRIBUTIONS.CODE_ COMBINATION_ID |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.[Projects Columns] |
Validation: | This must be a valid, active value in AP_AWT_GROUPS.GROUP_ID |
Destination: | None. |
Validation: | This must be a valid, active value in AP_AWT_GROUPS.NAME |
Destination: | None |
Validation: | Must be in valid date format. |
Destination: | None |
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.
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.LAST_ UPDATED_BY |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.AP_LAST_ UPDATE_LOGIN |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.CREATED_BY |
Validation: | Must be in valid date format. |
Destination: | AP_INVOICE_DISTRIBUTIONS.CREATION_ DATE |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.ATTRIBUTE_ CATEGORY |
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 you have enabled the Transfer PO Descriptive Flexfield Information Payables option, then data you enter here will overwrite the descriptive flexfield on the purchase order.
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.ATTRIBUTE [1-15] |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.GLOBAL_ ATTRIBUTE_CATEGORY |
Validation: | None |
Destination: | AP_INVOICE_DISTRIBUTIONS.GLOBAL_ ATTRIBUTE[1-20] |
Previous | Next | Contents | Index | Navigation | Glossary | Library |