Invoice Open Interface Table AP_INVOICES_INTERFACE
This table stores invoice header information for import into Oracle Fusion Payables base tables.
The Import Payables Invoices process builds Payables invoices based on the invoice records in the Payables open interface tables. After the import process builds the invoices, the invoices can be viewed, modified, and validated on the Manage Invoices page. The invoice data includes Oracle B2B XML invoices from your suppliers and invoice records that you entered on the invoice spreadsheet.
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.
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
For the accounting date basis search:
-
If the basis is Goods received or invoice date, the goods received date is used unless it doesn't exist. In that case, the invoice date is used as the accounting date.
-
If the basis is Goods received or system date, the goods received date is used unless it doesn't exist. In that case, the system date at import time is used as the accounting date.
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.