Invoice Open Interface Table AP_INVOICES

INVOICE_ID

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

Validation: None.
Destination: None.

INVOICE_NUM

Enter the invoice number. If you don't enter a value, the system date at the time of import is used as the default invoice number. If you enter more than one invoice for a supplier, enter unique invoice numbers instead of accepting the default value. The import process rejects invoices with duplicate invoice numbers.

Validation: Must be a unique number for the supplier. If you assign a duplicate invoice number for the supplier, the import process doesn't create an invoice from this record.
Destination: AP_INVOICES_ALL.INVOICE_NUM

INVOICE_TYPE_LOOKUP_CODE

Type of invoice: CREDIT or STANDARD. If you don't enter a value, the import process assigns a value based on the value in the INVOICE_AMOUNT column. If the INVOICE_AMOUNT value is less than zero, the invoice type is Credit. If the INVOICE_AMOUNT value is zero or greater, the invoice type is Standard.

Validation: The value must be CREDIT or STANDARD and the invoice type must correspond with the invoice amount.
Destination: AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE

INVOICE_DATE

Date of the invoice. If you don't enter a value, the date that you submit the import process is used as the invoice date. Also if the Enable Legal Entity Time Zone profile is enabled, the invoice date is the date of the legal entity time zone.

The import process might use the invoice date as the terms date and the accounting date, depending on the invoice options setup. If the Accounting Date Basis option is set to Invoice, the invoice date must be in an open or future period.

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

PO_NUMBER

Number of the purchase order to which you're matching the invoice. If you enter a value, the import process uses the purchase order information to create distributions and populate various columns in the AP_INVOICE_DISTRIBUTIONS_ALL table. If you don't create invoices from a spreadsheet, the import process uses the PO_NUMBER value to derive the AP_INVOICES_ALL.VENDOR_ID table column. The import process uses the PO_NUMBER to derive the AP_INVOICES_ALL.VENDOR_ID table column if you don't specify a supplier. Also, if you don't specify the supplier site, the PO_NUMBER could be used to derive the AP_INVOICES_ALL.VENDOR_SITE_ID table column.

Note: To match to a purchase order, you don't have to enter a value here if you enter a value in the AP_INVOICE_LINES_INTERFACE.PO_NUMBER table column.

Validation: The value must match a valid, approved, open purchase order for the supplier. The purchase order must not have a status of finally matched. You can obtain a list of valid values from the PO_HEADERS.SEGMENT1 table column.
Destination: None.

VENDOR_ID

Internal 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.

Validation: The ID you enter must be for an existing, valid supplier. You can obtain a list of valid values from the POZ_SUPPLIERS.VENDOR_ID table column.
Destination: AP_INVOICES_ALL.VENDOR_ID

VENDOR_NUM

Number 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.

Validation: The number you enter must be for an existing, valid supplier. You can obtain a list of valid values from POZ_SUPPLIERS.VENDOR_ID.
Destination: None. The import process uses this value to derive the AP_INVOICES_ALL.VENDOR_ID table column.

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.

Validation: The name you enter must be an existing, valid, active supplier. You can obtain a list of valid values from the POZ_SUPPLIERS_V.VENDOR_NAME table column.
Destination: None. The import process uses this value to populate the AP_INVOICES_ALL.VENDOR_ID table column.

VENDOR_SITE_ID

Internal identifier for the supplier site. If you don't provide a valid value in the VENDOR_SITE_CODE or VENDOR_SITE_ID columns, the import process searches for the site in the following order:

Primary pay site for supplier if the supplier has site assignments for the invoice ORG_ID column
Single existing pay site for supplier if the supplier has site assignments for the invoice ORG_ID column
Purchase order number matched at the header level

The import process rejects the invoice if it can't identify a valid supplier site.

Validation: The ID that you enter must be for a valid supplier pay site for the supplier that you specify in the VENDOR_NUM or VENDOR_ID columns. You can obtain a list of valid values from POZ_SUPPLIER_SITES_V.VENDOR_SITE_CODE table columns.
Destination: AP_INVOICES_ALL.VENDOR_SITE_ID

VENDOR_SITE_CODE

Name of the supplier site. If you don't provide a valid value in the VENDOR_SITE_CODE or VENDOR_SITE_ID columns, the import process searches for the site in the following order:

Primary pay site for the supplier if the supplier has site assignments for the invoice ORG_ID column
Single existing pay site for the supplier if the supplier has site assignments for the invoice ORG_ID column
Purchase order number matched at the header level

The import process rejects the invoice if it can't identify a valid supplier site.

Validation: This must be a valid, active supplier pay site for the supplier that you specify in the VENDOR_NUM or VENDOR_ID columns. You can obtain a list of valid values from POZ_SUPPLIER_SITES_V.VENDOR_SITE_CODE table columns.
Destination: None. The import process uses this value to derive the AP_INVOICES_ALL.VENDOR_SITE_ID table column.

INVOICE_AMOUNT

Amount of the invoice. Don't exceed the precision of the currency for the invoice. For example, if you're entering an amount in US dollars, don't enter more than two numbers after the decimal point.

Validation: Must correspond to the invoice type. For example, STANDARD invoices must have an amount of zero or greater.
Destination: AP_INVOICES_ALL.INVOICE_AMOUNT

INVOICE_CURRENCY_CODE

Currency for the invoice. If you don't enter a value, the supplier site provides the default currency during import.

Validation: If you enter a code, you must enter a valid, active currency from the FND_CURRENCIES.CURRENCY_CODE table column.
Destination: AP_INVOICES_ALL.INVOICE_CURRENCY_CODE

EXCHANGE_RATE

Invoice conversion rate for a foreign currency invoice. If the Require conversion rate entry option is enabled, you must provide either a conversion rate, or sufficient information to derive the conversion rate. If the EXCHANGE_RATE_TYPE column is User, you must provide a value for the EXCHANGE_RATE column.

If you didn't enter the invoice in a spreadsheet and the EXCHANGE_RATE_TYPE is Spot or Corporate, the import process supplies the conversion rate value. If the entered currency has a fixed rate to your ledger currency, the import process overwrites any value you enter with the fixed rate. You can review the import process log file for conversion rate overwrites.

Validation: If you entered the invoice in the invoice spreadsheet, don't overwrite the value that the spreadsheet provides. Otherwise, the import process rejects the invoice.
Destination: AP_INVOICES_ALL.EXCHANGE_RATE

EXCHANGE_RATE_TYPE

Type of rate for converting the entered currency to the ledger currency. If the value in the INVOICE_CURRENCY_CODE column is a foreign currency, enter a conversion rate type. You can enter a predefined or user-defined conversion rate type.

If the invoice has a foreign currency and you don't enter a value, the import process uses the rate type from the common options page. If the entered currency and the ledger currency are associated fixed-rate currencies, such as EUR and another EMU currency, enter EMU Fixed.

Validation: If you use a Spot, Corporate, or any user-defined rate type, the import process validates the value against the GL_DAILY_RATES table. If you use EMU Fixed, the import process provides the conversion rate. If you provide User as the conversion rate type, you must enter a value for the EXCHANGE_RATE column.
Destination: AP_INVOICES_ALL.EXCHANGE_RATE_TYPE

EXCHANGE_DATE

Enter a value if you enter a foreign currency in the CURRENCY_CODE column. The date that you enter determines the conversion rate for a foreign currency invoice with a Spot, Corporate, or user-defined rate type. If you leave this column null, the import process uses the invoice accounting date.

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

TERMS_ID

Internal identifier for the payment terms. To specify payment terms, you must enter a value in only one of the following columns: TERMS_NAME or TERMS_ID.

The import process searches for payment terms in the following order:

Invoice header record TERMS_ID or TERMS_NAME
Terms for the purchase order number in the invoice header
Terms for the purchase orders that one or more lines are matched directly or indirectly through a receipt. This applies only when one set of terms is represented.
Supplier site
Payment terms that are specified on Manage Invoice Options page

If sources have of these a value for payment terms, the import process rejects the invoice. For calendar-based payment terms, if a period isn't defined for the terms date, the import process uses the terms date as the installment due date.

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

TERMS_NAME

Payment terms used to create invoice installments. To specify payment terms, you must enter a value in only one of the following columns: TERMS_NAME or TERMS_ID.

The import process searches for payment terms in the following order:

Invoice header record TERMS_ID or TERMS_NAME
Terms for the purchase order number in the invoice header
Terms for the purchase orders that one or more lines are matched directly or indirectly through a receipt. This applies only when one set of terms is represented.
Supplier site
Payment terms that are specified on the Manage Invoice Options page

If sources have of the a value for payment terms, the import process rejects the invoice. For calendar-based payment terms, if a period isn't defined for the terms date, the import process uses the terms date as the installment due date.

Validation: Terms must be valid, active terms in the AP_TERMS table.
Destination: None. The import process might use this value to derive a value for AP_INVOICES_ALL.TERMS_ID.

DESCRIPTION

Enter the description for the invoice. If you're matching to a purchase order and don't enter a value, the import process uses the item description from the purchase order line.

Validation: None.
Destination: AP_INVOICES_ALL.DESCRIPTION

AWT_GROUP_ID

Internal identifier for the withholding tax group. The import process assigns the tax group to the invoice line unless you specified a withholding tax group in any of the following table columns: AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID, AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME.

If you don't provide a value and withholding tax is enabled, the import process searches for the withholding tax group in the following order:

Supplier site default value
Tax reporting and withholding tax options

Validation: The value must be valid and active in AP_AWT_GROUPS.
Destination: AP_INVOICES_ALL.AWT_GROUP_ID, only if you don't enter another value for AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID, or AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME.

AWT_GROUP_NAME

Name of the withholding tax group. The import process assigns the tax group to the invoice line unless you specified a withholding tax group in any of the following table columns: AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID, AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME.

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

LAST_UPDATE_DATE

Who column that indicates the date and time of the last update of the row.

Validation: Must be in the valid date format.
Destination: AP_INVOICES_ALL.LAST_UPDATED_DATE, AP_PAYMENT_SCHEDULES.LAST_UPDATED_DATE

LAST_UPDATED_BY

Who column that indicates the user who last updated the row.

Validation: None.
Destination: AP_INVOICES_ALL.LAST_UPDATED_BY, AP_PAYMENT_SCHEDULES.LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Who column indicating the user who last updated the row.

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

CREATION_DATE

Who column that indicates the date and time of the creation of the row.

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

CREATED_BY

Who column that indicates the user who created the row.

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

ATTRIBUTE_CATEGORY

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

Validation: None.
Destination: AP_INVOICES_ALL.ATTRIBUTE_CATEGORY

ATTRIBUTE1-15

Enter descriptive flexfield information. The structure of the information, such as data types and value sets, must match the structure of the global descriptive flexfield segments that you defined. If the structure doesn't match, you might face validation problems on invoice pages.

Validation: None.
Destination: AP_INVOICES_ALL.ATTRIBUTE1-15

GLOBAL_ATTRIBUTE_CATEGORY

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

Validation: None.
Destination: AP_INVOICES_ALL.GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1-20

Enter descriptive flexfield information. The structure of the information, such as data types and value sets, must match the structure of the global descriptive flexfield segments that you defined. If the structure doesn't match, you might face validation problems on invoice pages.

Validation: While using a localization that uses the global descriptive flexfield, you must enter the appropriate attribute values. Otherwise, the import process rejects the invoice.
Destination: AP_INVOICES_ALL.GLOBAL_ATTRIBUTE1-20

STATUS

Status of the data in or after the import process. Don't enter a value in this column. This column is for internal use only.

Validation: None.
Destination: None.

SOURCE

Source of the invoice data. You can define additional sources on the Manage Payables Lookups page. If you defined additional sources, use a unique source name for each type of source. The source name also determines which records the import process selects. You specify a source name when you submit the import process.

Validation: If you don't use a predefined source, you must enter the name exactly as you defined it for the lookup value. The lookup value must have the type SOURCE.
Destination: AP_INVOICES_ALL.SOURCE

GROUP_ID

Identifier for this batch. When you submit the import process, you must specify a source, and you can optionally specify a group. Processing records by group enables you to concurrently import or purge records for the same source. You might want to assign a group ID if you're processing a large number of records.

Validation: None.
Destination: None.

REQUEST_ID

The application populates this field with the request ID number for the import process. Leave this column null.

Validation: None.
Destination: None.

PAYMENT_CURRENCY_CODE

Currency for the payment.

Validation: This must be a valid, active currency from the FND_CURRENCIES.CURRENCY_CODE table column.
Destination: AP_INVOICES_ALL.PAYMENT_CURRENCY_CODE

DOC_CATEGORY_CODE

If you're using automatic sequential numbering, the import process uses this column to assign a document category to the invoice. If you enable the Allow Document Category Override option, you can enter a document category other than STANDARD or CREDIT. If you don't enter a value, the import process uses STANDARD if the invoice is zero or positive, and CREDIT if the invoice is negative.

Validation: The value is a valid value in the AP_INVOICES_ALL.FND_DOC_SEQUENCE_ CATEGORIES table column. The document category must have an active, automatic sequence assigned to it. If you enter STANDARD, the invoice amount must be positive, and if you enter CREDIT, the invoice amount must be negative.
Destination: AP_INVOICES_ALL.DOC_CATEGORY_CODE

VOUCHER_NUM

If you use manual sequential numbering, enter a unique value for the voucher number you want to assign to the invoice. The number should not exceed nine digits or processing problems could occur.

Validation: If you provide a voucher number and the Enforce Document Sequencing for Payables ledger option is set to Yes, the import process rejects the invoice. If you require manual voucher numbering during import, you must set the Sequencing By ledger option to No sequencing.
Destination: AP_INVOICES_ALL.VOUCHER_NUM

PAY_GROUP_LOOKUP_CODE

Pay group that the invoice is assigned to. Used to group a category of suppliers or invoices into a single pay run. If you don't enter a value, the supplier site provides the default value. If the supplier site doesn't have a pay group, the supplier provides the default value. If neither the supplier nor supplier site has a value, the import process uses the default pay group from the Manage Invoice Options page.

Validation: The value must be a valid and active value in the AP_LOOKUP_CODES.LOOKUP_CODE table column, where the LOOKUP_TYPE PAY GROUP.
Destination: AP_INVOICES_ALL.PAY_GROUP_LOOKUP_CODE

GOODS_RECEIVED_DATE

This value is used as the terms date if the TERMS_DATE column is blank and the Terms Date Basis invoice option is Goods received date.

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

INVOICE_RECEIVED_DATE

Date when you received the invoice. This value is used as the terms date if the TERMS_DATE column is blank and the Terms Date Basis invoice option is Invoice received date.

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

ORG_ID

Identifier of the business unit associated with the invoice. Spreadsheet invoices are assigned the ID that's associated with the user's job role. If the column has no value, the import process uses the business unit that's associated with the job role that submitted the import.

Validation: Must be a valid business unit. Invoices matched to a purchase order must use a business unit consistent with the purchase order.
Destination: AP_INVOICES_ALL.ORG_ID

GL_DATE

The accounting date for the invoice. If the invoice is matched to a purchase order, invoice distributions are created immediately. The import process searches the following sources in the order listed, for an accounting date to assign to the invoice distributions:

Invoice line record
Invoice header record
Accounting date parameter from the import submission
Accounting date basis invoice option

Note: For the accounting date basis search:

If the invoice accounting date is in a future Payables period, you can account for the invoice, but you can't pay it.

Validation: Must be in valid date format. The date must be in an open or future accounting period.
Destination: The AP_INVOICES_ALL.ACCOUNTING_DATE table column if no value is provided at the line level.

ACCTS_PAY_CODE_COMBINATION_ID

Value for the accounts payable liability account. If you don't provide a value, the import process uses the account from the supplier site.

Validation: Must be a valid account for the chart of accounts.
Destination: AP_INVOICES_ALL.ACCTS_PAY_CODE_COMBINATION_ID

EXCLUSIVE_PAYMENT_FLAG

Indicates whether to pay an invoice with its own payment document, without including other invoices for the supplier.

Validation: None.
Destination: AP_INVOICES_ALL.EXCLUSIVE_PAYMENT_FLAG

OPERATING_UNIT

Name of the business unit that processes invoices for purchase orders raised by one or more requisitioning business units.

Validation: If you populate both the AP_INVOICES_INTERFACE.ORG_ID and AP_INVOICES_INTERFACE.OPERATING_UNIT columns and they don't match or are inconsistent, the import process rejects the invoice.
Destination: AP_INVOICES_ALL.ORG_ID

SETTLEMENT_PRIORITY

Instruction to a bank that indicates the priority for completing a payment.

Validation
Destination

BANK_CHARGE_BEARER

The bearer of the bank charge cost.

Validation
Destination

PAYMENT_REASON_CODE

Code that provides the payment system or bank with additional details about the reason for the payment.

Validation
Destination

PAYMENT_REASON_COMMENTS

Reason for the payment.

Validation
Destination

LEGAL_ENTITY_ID

The internal unique identifier for a legal entity. Enter a value in either this column or the LEGAL_ENTITY_NAME column.

Validation: Provide a value when matching to a purchase order. The import process uses the legal entity ID to identify the correct purchase order.
Destination: AP_INVOICES_ALL.LEGAL_ENTITY_ID

LEGAL_ENTITY_NAME

The legal entity that owns the invoice. Enter a value in either this column or the LEGAL_ENTITY_ID column. If you enter a legal entity name, the import process derives the legal entity identifier.

Validation: Provide a value when matching to a PO. The import process uses the legal entity name to identify the correct purchase order.
Destination: AP_INVOICES_ALL.LEGAL_ENTITY_ID

AMOUNT_APPLICABLE_TO_DISCOUNT

Invoice amount applicable to discount.

Validation: None.
Destination: AP_INVOICES_ALL.AMOUNT_APPLICABLE_TO_DISCOUNT

PREPAY_NUM

Invoice number of an existing, fully paid prepayment with the same supplier site as the invoice the prepayment is being applied to. Leave blank to apply all available prepayments in chronological order, starting with the oldest prepayment, up to the prepayment amount.

If the PREPAY_APPLY_AMOUNT column value exceeds the amount available on the specified prepayment, the import process applies the specified prepayment first. The process then applies the remaining available prepayments starting with the oldest, up to the specified PREPAY_APPLY_AMOUNT column value.

Validation: The prepayment must have a settlement date on or before the system date, must be fully paid, and can't be fully applied. In addition, the prepayment must have a type of Temporary, and have the same invoice and payment currency as the invoice. Also, the business unit of the prepayment invoice and the Standard invoice must be the same.
Destination: None. The import process uses this information to populate the AP_INVOICE_LINES_ALL.PREPAY_DISTRIBUTION_ID table column.

PREPAY_APPLY_AMOUNT

Amount of prepayment to apply to the invoice.

Validation: Must not exceed the amount of the unpaid invoice or available prepayments. Can't be zero or a negative number.
Destination: AP_INVOICE_LINES_ALL.PREPAY_APPLY_AMOUNT

PREPAY_GL_DATE

Accounting date for the application of the prepayment. The import process uses this date as the accounting date on the prepayment type distribution of the imported invoice. If you don't enter a value, the import process uses the system date as the prepayment accounting date.

Validation: The date must be in an open or future period.
Destination: AP_INVOICE_LINES_ALL.ACCOUNTING_DATE

INVOICE_INCLUDES_PREPAY_FLAG

A value of Y indicates that the invoice amount was reduced by a prepayment. The import process doesn't reduce the paid amount by the prepayment that's applied to it.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.INVOICE_INCLUDES_PREPAY_FLAG

VENDOR_EMAIL_ADDRESS

Supplier email for B2B XML invoice rejections. Oracle B2B populates this column when loading XML invoice records to Payables.

Validation: None.
Destination: None.

TERMS_DATE

The payment terms start date. If null, the import process derives the value based on the Terms Date Basis invoice option if you provided a value for the column.

Validation: The value must have a valid date format.
Destination: AP_INVOICES_ALL.TERMS_DATE

REQUESTER_ID

Identifier of the person who requested the goods or services on the invoice. If you use the invoice approval workflow, you can define rules that use this value to generate a hierarchical list of approvers for the invoice.

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

EXTERNAL_DOC_REF

Identifier that your supplier assigns to the invoice record.

Validation: None.
Destination: None.

REMIT_TO_SUPPLIER_NAME

Supplier that receives payment on behalf of the supplier on the invoice.

Validation: The name that you enter must be an existing, valid, active supplier. The POZ_SUPPLIERS_V.VENDOR_NAME table column has a valid list of values. The POZ_SUPPLIERS_V.PARTY_ID table column for the supplier name must have a valid value in the POZ_SUP_THIRDPARTY_PAYMENT_REL.REMIT_TO_SUPPLIER_ID table column.
Destination: AP_PAYMENT_SCHEDULES_ALL.REMIT_TO_SUPPLIER_NAME

REMIT_TO_SUPPLIER_ID

Identifier for the supplier that receives payment on behalf of the supplier on the invoice.

Validation: The ID that you enter must be for an existing, valid supplier. The POZ_SUPPLIERS.VENDOR_ID table column has a valid list of values. The POZ_SUPPLIERS_V.PARTY_ID table column for the supplier must have a valid value in the POZ_SUP_THIRDPARTY_PAYMENT_REL.REMIT_TO_SUPPLIER_ID table column.
Destination: AP_PAYMENT_SCHEDULES_ALL.REMIT_TO_SUPPLIER_ID

REMIT_TO_ADDRESS_NAME

Address belonging to the supplier or party that receives payment.

Validation: The name that you enter must be an existing, valid, active address for the supplier you specify in the POZ_SUP_THIRDPARTY_PAYMENT_REL.REMIT_TO_SUPPLIER_ID table column. The HZ_PARTY_SITES.PARTY_SITE_NAME table column has a list of valid values. The HZ_PARTY_SITES.PARTY_SITE_NAME table column for the address must have a valid value in the POZ_SUP_THIRDPARTY_PAYMENT_REL.REMIT_TO_ADDRESS_ID table column.
Destination: None. The import process uses this value to derive the value for the AP_PAYMENT_SCHEDULES_ALL.REMIT_TO_ADDRESS_ID table column.

REMIT_TO_ADDRESS_ID

Identifier for the address belonging to the supplier or party that receives payment.

Validation: The ID that you enter must be an existing, valid, active address for the supplier you specify in the POZ_SUP_THIRDPARTY_PAYMENT_REL.REMIT_TO_SUPPLIER_ID table column. The HZ_PARTY_SITES.PARTY_SITE_ID table column has a valid list of values. The HZ_PARTY_SITES.PARTY_SITE_ID table column for the address must have a valid value in the POZ_SUP_THIRDPARTY_PAYMENT_REL.REMIT_TO_ADDRESS_ID table column.
Destination: AP_PAYMENT_SCHEDULES_ALL.REMIT_TO_ADDRESS_ID

RELATIONSHIP_ID

Identifier for a third-party payment relationship.

Validation: The ID that you enter must be an existing, valid, active third-party relationship. The POZ_SUP_THIRDPARTY_PAYMENT_REL.RELATIONSHIP_ID table column has a valid list of values.
Destination: AP_PAYMENT_SCHEDULES_ALL.RELATIONSHIP_ID

REMIT_TO_SUPPLIER_NUM

Unique number to identify a supplier.

Validation: The number that you enter must be an existing, valid supplier. The POZ_SUPPLIERS_V.SEGMENT1 table column has a valid list of values.
Destination: None. The import process uses this value to derive the values of the AP_PAYMENT_SCHEDULES_ALL.REMIT_TO_SUPPLIER_NAME or REMIT_TO_SUPPLIER_ID table columns.

BUDGET_DATE

Budget date for invoices that require budgetary control. If populated, the BUDGET_DATE column in the AP_INVOICE_LINES_INTERFACE table takes precedence over this column. If neither table has a budget date, the import process uses the Budget Date Basis invoice option to determine the budget date for the invoice.

Validation
Destination: AP_INVOICES_ALL.BUDGET_DATE

FIRST_PARTY_REGISTRATION_ID

The first-party registration unique identifier.

Validation: None.
Destination: AP_INVOICES_ALL.FIRST_PARTY_REGISTRATION_ID

THIRD_PARTY_REGISTRATION_ID

The third-party registration unique identifier.

Validation: None.
Destination: AP_INVOICES_ALL. THIRD_PARTY_REGISTRATION_ID

FIRST_PARTY_REGISTRATION_NUM

The tax registration number of the first party.

Validation: None.
Destination: None. The import process might use this value to derive a value for the AP_INVOICES_ALL.FIRST_PARTY_REGISTRATION_ID table column.

THIRD_PARTY_REGISTRATION_NUM

The tax registration number of the supplier.

Validation: None.
Destination: None. The import process might use this value to derive a value for the AP_INVOICES_ALL.THIRD_PARTY_REGISTRATION_ID table column.