PAYABLES OPEN INTERFACE TABLE DESCRIPTIONS
The following table lists the columns in the Payables Open Interface tables and indicates which columns require values for importing invoices into Payables. See also: Table Definitions
(Payables Applications Technical Reference Manual).
|
| 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 | |
INVOICE_ID
Unique identifier for the invoice in this batch. You assign the same value to the invoice's distributions in the AP_INVOICE_LINES_INTERFACE table to identify the data as belonging to the same invoice.
| Validation: | None |
| Destination: | None |
INVOICE_NUM
Enter the invoice number that you want to assign to the invoice created in Payables from this record.
| 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 |
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 type. If INVOICE_AMOUNT is zero or greater, the invoice will be Standard type.
| 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 |
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.
| Validation: | The value must be in date format. |
| Destination: | AP_INVOICES.INVOICE_DATE |
PO_HEADER_ID
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.
| 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
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 table. If you do not specify a supplier in the AP_INVOICES_INTERFACE table, the PO_NUMBER value is used to derive AP_INVOICES.VENDOR_ID, and if you do not specify the supplier site, the PO_NUMBER value is used to derive AP_INVOICES.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. 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 |
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.
| 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 |
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 enter it before import.
| 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. |
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, enter it before import.
| 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. |
VENDOR_SITE_ID
Internal supplier site identifier. You must identify the supplier site by entering a value for one of the following columns in this table: VENDOR_SITE_CODE, VENDOR_SITE_ID or PO_NUMBER. If you have not yet entered the supplier site in the Supplier Sites window, enter it before import.
| 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 |
VENDOR_SITE_CODE
Supplier site name. You must identify the supplier site by entering a value for one of the following columns in this table: VENDOR_SITE_CODE, VENDOR_SITE_ID, or PO_NUMBER. If you have not yet entered the supplier site in the Supplier Sites window, enter it before import.
| 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. |
INVOICE_AMOUNT
Amount of the invoice.
| 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 |
INVOICE_CURRENCY_CODE
Currency code for the invoice. If you want to create foreign currency invoices, enter a currency code that is different from your functional currency. 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 |
EXCHANGE_RATE
This column is required if you enter a foreign currency code in the INVOICE_CURRENCY_CODE column and you enter User as the EXCHANGE_RATE_TYPE. If you enter SPOT or CORPORATE as the EXCHANGE_RATE_TYPE, the system will supply the exchange rate value during Payables Open Interface Import, and you should leave this column null. 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 |
EXCHANGE_RATE_TYPE
If you enter a foreign currency code in the INVOICE_CURRENCY_CODE column, enter a value in this column to indicate which exchange rate type you use. You can enter a predefined or user-defined exchange rate type. If the 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 you entered in the Payables Options window.
| 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 |
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, Other, or user-defined rate type. If you leave this column Null, Payables uses the system date.
| Validation: | Must be in valid date format. |
| Destination: | AP_INVOICES.EXCHANGE_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, the PAYMENT_CROSS_RATE_TYPE and the PAYMENT_CROSS_RATE_DATE will both be null.
| 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 |
PAYMENT_CROSS_RATE_TYPE
If the invoice currency and payment currency are different currencies and are both associated fixed-rate currencies, enter EMU_FIXED. Otherwise, leave this value null.
| 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 |
PAYMENT_CROSS_RATE
If the invoice currency and payment currency are different currencies and are both associated fixed-rate currencies, you can enter the fixed cross rate. If you leave this value null, Payables will provide the cross rate during import.
| 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 |
PAYMENT_CROSS_RATE_DATE
Date cross rate between invoice currency and payment currency is effective.
| 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 |
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 only need to enter a value in one of the following columns: TERMS_NAME or 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.
| Validation: | Terms must be valid terms in the AP_TERMS table. |
| Destination: | If not purchase order matched, AP_INVOICES.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. 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. |
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.DESCRIPTION the Item Description from the PO line.
| Validation: | None |
| Destination: | AP_INVOICES.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 distribution only if you do not identify a withholding tax group for the invoice in the AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID or AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME.
| 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. |
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 distributions 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.
| 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.
| Validation: | Must be in valid date format. |
| Destination: | AP_INVOICES.LAST_UPDATED_DATE, AP_ PAYMENT_SCHEDULES.LAST_UPDATED_DATE |
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.
| Validation: | None |
| Destination: | AP_INVOICES.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.AP_LAST_UPDATE_LOGIN. If you do not enter a value, then during Payables Open Interface Import the system will use the system date.
| Validation: | None |
| Destination: | AP_INVOICES.AP_LAST_UPDATE_LOGIN, AP_PAYMENT_SCHEDULES.AP_LAST_UPDATE_LOGIN |
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; it uses the system date at the time you submit Payables Open Interface Import.
| Validation: | Must be in valid date format. |
| Destination: | AP_INVOICES.CREATION_DATE, AP_PAYMENT_SCHEDULES.CREATION_DATE |
CREATED_BY
Enter the ID of the person or organization that loads this record into the table. Payables Open Interface Import transfers this ID to the AP_INVOICES 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, during Payables Open Interface Import the system will use the userid of the person who submits Payables Open Interface Import.
| Validation: | None |
| Destination: | AP_INVOICES.CREATED_BY, AP_PAYMENT_SCHEDULES.CREATED_BY |
ATTRIBUTE_CATEGORY
Enter the Descriptive Flexfield category for the Descriptive Flexfield information you want to import.
| Validation: | None |
| Destination: | AP_INVOICES.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.
| Validation: | None |
| Destination: | AP_INVOICES.ATTRIBUTE[1-15] |
GLOBAL_ATTRIBUTE_CATEGORY
Enter the Descriptive Flexfield category for the Descriptive Flexfield information you want to import.
| Validation: | None |
| Destination: | AP_INVOICES.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.
| Validation: | None |
| Destination: | AP_INVOICES.GLOBAL_ATTRIBUTE[1-20] |
WORKFLOW_FLAG
If you are using the AP Open Interface Workflow and you want Workflow to process this record, enter Y. If you enter N or leave this column null, Workfow will not process this record. See:
AP Open Interface Import Workflow.
| Validation: | None |
| Destination: | None |
SOURCE
Source of the invoice data. If you import EDI invoices from the Oracle EDI Gateway, the source is EDI Gateway. For invoices you import using SQL*Loader, use a QuickCode with the type Source that you have defined in the QuickCodes window in Payables. 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 |
GROUP_ID
Identifier for this batch. When you submit Payables Open Interface Import or Purge Payables Open Interface, you must supply a Source and you can optionally enter 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.
STATUS
Do not enter a value in this field. It is for internal use only.
| Validation: | None |
| Destination: | None |
REQUEST_ID
The system populates this field with the concurrent request ID number for the Payables Open Interface Import process.
| Validation: | None |
| Destination: | None |
AP_INVOICE_LINES_INTERFACE
|
| 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 |
INVOICE_ID
Enter the INVOICE_ID of the corresponding invoice in the AP_INVOICES_INTERFACE table. This value is used only to assign distribution 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 will not be imported and it will not appear on the Open Interface Rejections Report.
| Validation: | AP_INVOICES_INTERFACE.INVOICE_ID |
| Destination: | None |
INVOICE_LINE_ID
This value is not required. You can enter a unique number for each invoice line of an invoice.
| Validation: | The value must be a number. |
| Destination: | None |
LINE_NUMBER
This value is optional. You can enter a unique number to identify the line.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.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.
| 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 |
LINE_GROUP_NUMBER
If you want to prorate to a group of lines, enter a value to identify each line to which you want to prorate. For example, if you want to prorate tax to two Item lines, enter the same line group number for the two Item lines and the Tax line.
| Validation: | This value must be a positive whole number. |
| Destination: | AP_INVOICE_DISTRIBUTIONS.LINE_GROUP_ NUMBER |
AMOUNT
The invoice distribution amount. If you are matching to a purchase order, the AMOUNT = QUANTITY_INVOICED x UNIT PRICE.
| 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 |
ACCOUNTING_DATE
The GL Date for the invoice distributions. If you do not enter a value here or enter a value for GL Date when you submit Payables Open Interface Import, Payables will assign a GL Date based on the GL Date Basis defined in the Invoice Region of the Payables Options window.
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 |
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, during import the system uses the item description on the purchase order line to enter AP_INVOICE_DISTRIBUTIONS.DESCRIPTION.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.DESCRIPTION |
TAX_CODE
Enter the tax name you want to assign to the invoice distribution created from this record. If you do not enter a value for this column, then during import Payables will enter a Tax Name based on the Tax Name Defaults hierarchy you defined in the Payables Options window. See:
Defaulting Tax in Payables.
| 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 |
AMOUNT_INCLUDES_TAX_FLAG
A Y value indicates if the amount includes a non-Use Type tax (Sales, User, etc.). When the distribution is imported, Payables will calculate the tax amount based on the Tax Name and will create an additional tax distribution in that amount. Payables will also reduce the amount of this distribution by the tax amount.
| Validation: | The Tax Name is not a Use type tax. |
| Destination: | None |
PRORATE_ACROSS_FLAG
If you set this column to Y and this is a non-Item Type distribution (Tax, Miscellaneous, or Freight), Payables will prorate against all Item type distributions with the same LINE_GROUP_NUMBER as this line. If no line group number is specified, Payables will prorate across all lines. If this column is set to N, then Payables will create only one line. 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 |
PO_HEADER_ID
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.
| 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, 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. |
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.
| 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 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 |
PO_LINE_LOCATION_ID
Internal identifier for purchase order shipment.
| Validation: | This must be a valid value in PO_LINE_LOCATIONS.LINE_LOCATION_ID for the purchase order. |
| 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 value "Taipei".
| Validation: | This must be a valid value for PO_LINE_LOCATIONS.SHIPMENT_NUM |
| 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.
| 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.
| 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 |
PO_UNIT_OF_MEASURE
Unit of measure for the purchase order item, for example, each, square feet, months. This value is not required but may be helpful in successfully matching the invoice to a purchase order line.
| 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 |
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.
| 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.
| Validation: | This value must match a valid value in PO_RELEASES.RELEASE_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, 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 |
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 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 |
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".
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).
| Validation: | This value must be a positive number. |
| Destination: | AP_INVOICE_DISTRIBUTIONS.QUANTITY_ INVOICED |
UNIT_PRICE
Unit price of the distribution line item(s). Used for purchase order matching.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.UNIT_PRICE |
FINAL_MATCH_FLAG
If you are certain that this is a final match against the purchase order and you want Approval to close the purchase order permanently, enter Y. Once you approve a final matched invoice distribution, you cannot update the status of the permanently closed purchase order, or update the Final Match check box in the Distributions window.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.FINAL_MATCH_FLAG |
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 or if you enter an account.
| 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, 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 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 |
DIST_CODE_CONCATENATED
The GL account to which the distribution amount will be charged. If you enter a value here, you do not need to enter a value for DIST_CODE_COMBINATION_ID. 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 |
DIST_CODE_COMBINATION_ID
Internal identifier for GL account to which the distribution amount will be charged. If you enter a value here, you do not need to enter a value for DIST_CODE_CONCATENATED.
| 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 |
BALANCING_SEGMENT
If you want to override the balancing segment in the account, enter the value. Payables will override the balancing segment with this value during import. See:
Account Overlay in Payables Open Interface Import.
| Validation: | The account code must be valid. |
| Destination: | AP_INVOICE_DISTRIBUTIONS.CODE_ COMBINATION_ID |
COST_CENTER
If you want to override the cost center in the account, enter the value. Payables will override the cost center with this value during import. See:
Account Overlay in Payables Open Interface Import.
| Validation: | The account code must be valid. |
| Destination: | AP_INVOICE_DISTRIBUTIONS.CODE_ COMBINATION_ID |
ACCOUNT
If you want to override the account segment in the accounting flexfield, enter the value. Payables will override the account segment with this value during import. See:
Account Overlay in Payables Open Interface Import.
| Validation: | The account code must be valid. |
| Destination: | AP_INVOICE_DISTRIBUTIONS.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.
- EXPENDITURE_ORGANIZATION_ID
- PROJECT_ACCOUNTING_CONTEXT
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.[Projects Columns] |
AWT_GROUP_ID
Internal identifier associated with the automatic withholding tax group name. If you want to assign a withholding tax group to the distribution, you do not need to enter a value here if you enter a value for AWT_GROUP_NAME.
| Validation: | This must be a valid, active value in AP_AWT_GROUPS.GROUP_ID |
| Destination: | None. |
AWT_GROUP_NAME
Automatic withholding tax group name. Enter a value if you want to apply multiple withholding taxes to this distribution. You define automatic withholding tax group names in the Withholding Tax Groups window. If you do not enter a value for this column, 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 value if there is one.
| Validation: | This must be a valid, active value in AP_AWT_GROUPS.NAME |
| 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. 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.
| Validation: | Must be in valid date format. |
| 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.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.LAST_ UPDATED_BY |
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.AP_LAST_ UPDATE_LOGIN. If you do not enter a value, during Payables Open Interface Import, the system will use the system date.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.AP_LAST_ UPDATE_LOGIN |
CREATED_BY
Enter the ID of the person or organization who loads this record into the table. Payables Open Interface Import transfers this ID to the AP_INVOICE_DISTRIBUTIONS table during import so that the creator of the record becomes the invoice and scheduled payment creator. If you do not enter a value, during import the system will use the userid of the person who submits Payables Open Interface Import.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.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.
| Validation: | Must be in valid date format. |
| Destination: | AP_INVOICE_DISTRIBUTIONS.CREATION_ DATE |
ATTRIBUTE_CATEGORY
Enter the Descriptive Flexfield category for the Descriptive Flexfield information you want to import for an invoice distribution.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.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 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] |
GLOBAL_ATTRIBUTE_CATEGORY
Enter the Descriptive Flexfield category for the Descriptive Flexfield information you want to import.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.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.
| Validation: | None |
| Destination: | AP_INVOICE_DISTRIBUTIONS.GLOBAL_ ATTRIBUTE[1-20] |
No comments:
Post a Comment