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