AP_INVOICES_INTERFACE_
AP_INVOICES_INTERFACE contains header information about invoices that you create or load for import. AP_INVOICES_INTERFACE_ is the audit table for AP_INVOICES_INTERFACE.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
AP_INVOICES_INTERFACE_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_ID, LOAD_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 18 | Yes | Invoice identifier. Must be unique. | |
| INVOICE_NUM | VARCHAR2 | 50 | Supplier invoice number. Validation: must be unique for the supplier site. | ||
| INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Type of invoice. Use the Manage Payables Lookups task, lookup type INVOICE TYPE to identify valid values. | ||
| INVOICE_DATE | DATE | Invoice date used to calculate due date per payment terms. Date format: YYYY/MM/DD. | |||
| PO_NUMBER | VARCHAR2 | 30 | Document number used to request a seller supply a product or service for payment. Use the Manage Purchase Orders task to identify valid values. | ||
| VENDOR_ID | NUMBER | 18 | Supplier identifier. If the identifier is not available, use the VENDOR_NAME column. Validated against POZ_SUPPLIERS.VENDOR_ID. | ||
| VENDOR_NUM | VARCHAR2 | 30 | Unique number to identify a supplier. Use the Manage Suppliers task to identify valid values. | ||
| VENDOR_NAME | VARCHAR2 | 240 | Supplier name. Use the Manage Suppliers task to identify valid values. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Supplier site identifier. If the identifier is not available, use the VENDOR_SITE_CODE column. Validated against POZ_SUPPLIER_SITES_ALL.VENDOR_SITE_ID. | ||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Physical location of the supplier. Use the Manage Suppliers task to identify valid values. | ||
| INVOICE_AMOUNT | NUMBER | Invoice amount in transaction currency. Should be positive for standard and prepayment invoices. Should be negative for credit memos. | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency of invoice. Use the Manage Currencies task to identify valid values. Use the three character ISO currency code. Example: US Dollars is USD. | ||
| EXCHANGE_RATE | NUMBER | Exchange rate used for foreign currency invoices. User entered conversion rate. Not validated. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type for foreign currency invoices. Use the Manage Conversion Rate Types task to identify valid values. Validated against GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE. | ||
| EXCHANGE_DATE | DATE | Date exchange rate is effective. Usually the accounting date of the transaction. Date format: YYYY/MM/DD. | |||
| TERMS_ID | NUMBER | 18 | Payment terms identifier. If the identifier is not available, use the TERMS_NAME column. Validated against AP_TERMS_TL.TERM_ID. | ||
| TERMS_NAME | VARCHAR2 | 50 | Name of payment term for an invoice. Use the Manage Payment Terms task to identify valid values. | ||
| DESCRIPTION | VARCHAR2 | 240 | Invoice description. Free text field. Not validated. | ||
| AWT_GROUP_ID | NUMBER | 18 | Withholding tax group identifier. If the identifier is not available, use the AWT_GROUP_NAME column. Validated against AP_AWT_GROUPS.AWT_GROUP_ID. | ||
| AWT_GROUP_NAME | VARCHAR2 | 50 | Used to apply multiple withholding taxes to an invoice line. Use the Manage Withholding Groups task to identify valid values. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| STATUS | VARCHAR2 | 25 | Status of import data. Valid values: NEW, NULL. | ||
| SOURCE | VARCHAR2 | 80 | Feeder system from which invoice is imported. Use the Manage Payables Lookups task, lookup type SOURCE to identify valid values. | ||
| GROUP_ID | VARCHAR2 | 80 | Value used to select invoices for importing. Free text field. Not validated. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PAYMENT_CROSS_RATE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| PAYMENT_CROSS_RATE_DATE | DATE | Oracle internal use only. | |||
| PAYMENT_CROSS_RATE | NUMBER | Oracle internal use only. | |||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| WORKFLOW_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| DOC_CATEGORY_CODE | VARCHAR2 | 30 | Sequential numbering (voucher number) document category. Use the Manage Payables Document Sequences task to identify valid values. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE. | ||
| VOUCHER_NUM | VARCHAR2 | 50 | Unique internal identifier assigned to a document. Required if document category code has assignment type of manual. | ||
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | 25 | Name of payment method. Use the Manage Payables Lookups task, lookup type PAYMENT METHOD to identify valid values. | ||
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | 25 | Groups suppliers or invoices for a single pay run. Examples: employees, merchandise, nonmerchandise. Use the Manage Payables Lookups task, lookup type PAY GROUP to identify valid values. | ||
| GOODS_RECEIVED_DATE | DATE | Date when goods on the invoice were received. Date format: YYYY/MM/DD. Required if the terms date basis is Goods Received. | |||
| INVOICE_RECEIVED_DATE | DATE | Date when the invoice was received. Also known as terms date. Date format: YYYY/MM/DD. Required if the terms date basis is Invoice Received Date. | |||
| GL_DATE | DATE | Default accounting date for invoice distributions. Date format: YYYY/MM/DD. The date must be in an open or future open accounting period. | |||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for accounts payable liability account. If the identifier is not available, use the ACCTS_PAY_CODE_CONCATENATED column. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Indicates whether to pay invoice on a separate payment document. Valid values: Y,N, NULL. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| AMOUNT_APPLICABLE_TO_DISCOUNT | NUMBER | Amount of invoice applicable to a discount. Not validated. | |||
| PREPAY_NUM | VARCHAR2 | 50 | Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice. Validations: settlement date must be on or before the system date, if the type is Temporary, it must have the same invoice and payment currency as the invoice, the prepayment must not be fully applied. | ||
| PREPAY_APPLY_AMOUNT | NUMBER | Amount of prepayment to apply to the invoice. Must be positive. Cannot exceed the unpaid invoice amount or the amount of available prepayments. | |||
| PREPAY_GL_DATE | DATE | Accounting date for the prepayment application. If NULL, the value for the column GL_DATE is used. Date format: YYYY/MM/DD. | |||
| INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2 | 1 | Prepayment included in invoice amount. Valid values: Y,N, NULL. | ||
| NO_XRATE_BASE_AMOUNT | NUMBER | Invoice amount in the functional currency. Used to calculate exchange rate. Used only when Calculate User Exchange Rate option is enabled for foreign currency invoices with exchange rate type of User. | |||
| VENDOR_EMAIL_ADDRESS | VARCHAR2 | 2000 | Supplier e-mail address for XML invoice rejections. | ||
| TERMS_DATE | DATE | Used with payment terms to calculate scheduled payment of an invoice. Date format: YYYY/MM/DD. | |||
| REQUESTER_ID | NUMBER | 18 | Requester of invoice: used by the Invoice Approval workflow process to generate the list of approvers. If the identifier is not available, use the REQUESTOR_NAME column. | ||
| SHIP_TO_LOCATION | VARCHAR2 | 40 | Ship to location for purchase order matching. Used for XML invoices. Use the Manage Locations task to identify valid values. | ||
| EXTERNAL_DOC_REF | VARCHAR2 | 240 | Internal document reference number from Accounts Receivables system. Used for XML invoices. | ||
| PREPAY_LINE_NUM | NUMBER | The invoice line of an existing prepayment to be applied to the invoice. | |||
| REQUESTER_FIRST_NAME | VARCHAR2 | 150 | The first name of the employee who requested goods or services on the invoice line. Both REQUESTER_FIRST_NAME and REQUESTER_LAST_NAME must be populated to determine a valid employee identifier if REQUESTER_ID is not used. | ||
| REQUESTER_LAST_NAME | VARCHAR2 | 150 | The last name of the employee who requested goods or services on the invoice line. . Both REQUESTER_FIRST_NAME and REQUESTER_LAST_NAME must be populated to determine a valid employee identifier if REQUESTER_ID is not used. | ||
| APPLICATION_ID | NUMBER | 18 | Oracle internal use only. For Oracle Fusion applications interfacing to Oracle Fusion Payables. | ||
| PRODUCT_TABLE | VARCHAR2 | 30 | Name of the product source table used to generate an invoice. Free text field. Not validated. | ||
| REFERENCE_KEY1 | VARCHAR2 | 4000 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY2 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY3 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY4 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_KEY5 | VARCHAR2 | 150 | Captures invoice reference information from non-Oracle application. Free text field. Not validated. | ||
| APPLY_ADVANCES_FLAG | VARCHAR2 | 1 | Indicates applicable advances will be applied against expense reports and other invoices. Valid values: Y, N, NULL. | ||
| CALC_TAX_DURING_IMPORT_FLAG | VARCHAR2 | 1 | Indicates whether tax should be calculated for the invoice during import. Valid values: Y,N, NULL. | ||
| CONTROL_AMOUNT | NUMBER | Total tax amount. Cannot be more than the invoice amount. | |||
| ADD_TAX_TO_INV_AMT_FLAG | VARCHAR2 | 1 | Indicates whether the invoice amount should be grossed up by the calculated tax. Valid values: Y, N, NULL. | ||
| TAX_RELATED_INVOICE_ID | NUMBER | 18 | Oracle internal use only. | ||
| TAXATION_COUNTRY | VARCHAR2 | 30 | Sets the context for tax drivers such as Product Classification Code. If no value is entered, it will display the legal entity country by default. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | A document type required by a tax or governmental authority. | ||
| SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 | 150 | The invoice number used to report on a supplier issued tax invoice that is distinct from the regular invoice. Free text field. Not validated. | ||
| SUPPLIER_TAX_INVOICE_DATE | DATE | Tax invoice date on the supplier-issued tax invoice. Date format: YYYY/MM/DD. | |||
| SUPPLIER_TAX_EXCHANGE_RATE | NUMBER | Supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices. | |||
| TAX_INVOICE_RECORDING_DATE | DATE | If company-specific tax invoice date and number is captured, the date the company receives or records the supplier-issued tax invoice. Date format: YYYY/MM/DD. | |||
| TAX_INVOICE_INTERNAL_SEQ | VARCHAR2 | 150 | Company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. Free text field. Not validated. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier of the legal entity. If the identifier is not available, use the LEGAL_ENTITY_NAME column. | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Name of the legal entity on the invoice. Use the Manage Legal Entities task to identify valid values. | ||
| REFERENCE_1 | VARCHAR2 | 30 | Captures invoice reference information from a non-Oracle application. Free text field. Not validated. | ||
| REFERENCE_2 | VARCHAR2 | 30 | Captures invoice reference information from a non-Oracle application. Free text field. Not validated. | ||
| OPERATING_UNIT | VARCHAR2 | 240 | Business unit to which the invoice refers. | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Bearer of bank charge cost. Uses the Manage Payables Lookup task, lookup type BANK BEARER CHARGE to identify valid values. | ||
| REMITTANCE_MESSAGE1 | VARCHAR2 | 150 | Remittance message for use in payment processing. Free text field. Not validated. | ||
| REMITTANCE_MESSAGE2 | VARCHAR2 | 150 | Remittance message for use in payment processing. Free text field. Not validated. | ||
| REMITTANCE_MESSAGE3 | VARCHAR2 | 150 | Remittance message for use in payment processing. Free text field. Not validated. | ||
| UNIQUE_REMITTANCE_IDENTIFIER | VARCHAR2 | 256 | Unique remittance identifier provided by the payee. Not validated. | ||
| URI_CHECK_DIGIT | VARCHAR2 | 2 | Unique remittance identifier check digit. Free text field. Not validated. | ||
| SETTLEMENT_PRIORITY | VARCHAR2 | 30 | Priority to settle payment for the transaction. Use the Manage Payables Lookups task, lookup type IBY_SETTLEMENT_PRIORITY to identify valid values. | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | Code to provide the payment system or bank with additional details for the payment. Use the Manage Payment Codes task to identify valid values. The corresponding Payment Code Type must be Payment Reason. | ||
| PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Reason for the payment. Free text field. Not validated. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Payment method, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values. | ||
| DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Information displayed for an electronic payment that instruct the bank about carrying out the payment. Example: print a check and hold it for collection by the payee. Use the Manage Payment Codes task to identify valid values. The corresponding Payment Code Type must be Delivery Channel. | ||
| PAID_ON_BEHALF_EMPLOYEE_ID | NUMBER | 18 | Oracle internal use only. Original expense report's employee identifier when expense report is split using Both Pay Scenario. | ||
| NET_OF_RETAINAGE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| REQUESTER_EMPLOYEE_NUM | VARCHAR2 | 30 | Oracle internal use only. | ||
| CUST_REGISTRATION_CODE | VARCHAR2 | 30 | Customer legal registration code. Used to derive customer registration number for invoice. Use the Manage Suppliers task, Transaction Tax region to identify valid values. | ||
| CUST_REGISTRATION_NUMBER | VARCHAR2 | 30 | Customer legal registration number. Used to derive customer registration number for invoice header. Use the Manage Suppliers task, Transaction Tax region to identify valid values. | ||
| PARTY_ID | NUMBER | 18 | Oracle internal use only. Unique party identifier derived from supplier or populated by Oracle Fusion applications using Oracle Fusion Payables. | ||
| PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. Unique party site identifier derived from supplier site or populated by Oracle Fusion applications using Oracle Fusion Payables. | ||
| PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 | 30 | Oracle internal use only. Type of payment processing transaction or document. | ||
| PAYMENT_FUNCTION | VARCHAR2 | 30 | Oracle internal use only. The function or purpose of the payment. | ||
| PAYMENT_PRIORITY | NUMBER | 2 | The payment priority of a scheduled payment. Valid values: whole numbers from 1 to 99. | ||
| PORT_OF_ENTRY_CODE | VARCHAR2 | 30 | Identifies the location or port through which the invoiced goods entered the country. Free text field. Not validated. | ||
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | External bank account identifier. Defaulted from supplier setup. Do not populate during interface. | ||
| ACCTS_PAY_CODE_CONCATENATED | VARCHAR2 | 250 | Accounting flexfield value for the accounts payable liability account. Validated against the accounting key flexfield values. Use segment separators defined for the flexfield. Example: 01-2000-000 | ||
| IMPORT_DOCUMENT_NUMBER | VARCHAR2 | 50 | Customer assigned document number. Not validated. | ||
| IMPORT_DOCUMENT_DATE | DATE | Customer assigned date during import of invoice. Date format: YYYY/MM/DD. | |||
| CORRECTION_YEAR | NUMBER | Correction year for the invoice. Valid format: four numbers. Example: 2010. | |||
| CORRECTION_PERIOD | VARCHAR2 | 15 | Correction period for the invoice being corrected. Not validated. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| EMPLOYEE_ADDRESS_CODE | VARCHAR2 | 15 | Address code for employee. Valid values: HOME, OFFICE. | ||
| INTERCOMPANY_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| BUDGET_DATE | DATE | Budgetary Calendar Period Date applicable for funds check | |||
| FIRST_PARTY_REGISTRATION_ID | NUMBER | 18 | First party tax registration identifier. | ||
| THIRD_PARTY_REGISTRATION_ID | NUMBER | 18 | Third party tax registration identifier. | ||
| FIRST_PARTY_REGISTRATION_NUM | VARCHAR2 | 60 | First party tax registration number. | ||
| THIRD_PARTY_REGISTRATION_NUM | VARCHAR2 | 60 | Third party tax registration number. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Oracle Enterprise Scheduler: request identifier of the interface load job that created the row. | |
| CHECK_VAT_AMOUNT_PAID | VARCHAR2 | 1 | Indicator used to determine if a partially paid purchase transaction is reportable for tax. Used for tax reporting in eastern and central Europe. | ||
| TRANSACTION_DEADLINE | NUMBER | Number of days to perform an intra-EU transaction. Used for Modelo reports for Spain. | |||
| AUTOMATIC_MATCHING_FLAG | VARCHAR2 | 1 | Indicates if automatic matching is enabled for the invoice. | ||
| MATCHING_RULE_SET | VARCHAR2 | 50 | Matching rule set used to perform automatic matching for the invoice. | ||
| MATCHING_RULE_SET_ID | NUMBER | 18 | Matching rule set identifier used to perform automatic matching for the invoice. | ||
| ROUTING_ATTRIBUTE1 | VARCHAR2 | 270 | Captures additional attributes that can be used for routing payables invoice images. | ||
| ROUTING_ATTRIBUTE2 | VARCHAR2 | 270 | Captures additional attributes that can be used for routing payables invoice images. | ||
| ROUTING_ATTRIBUTE3 | VARCHAR2 | 270 | Captures additional attributes that can be used for routing payables invoice images. | ||
| ROUTING_ATTRIBUTE4 | VARCHAR2 | 270 | Captures additional attributes that can be used for routing payables invoice images. | ||
| ROUTING_ATTRIBUTE5 | VARCHAR2 | 270 | Captures additional attributes that can be used for routing payables invoice images. | ||
| IMAGE_DOCUMENT_NUM | VARCHAR2 | 50 | Oracle internal use only. | ||
| IMAGE_DOCUMENT_URI | VARCHAR2 | 4000 | Oracle internal use only. | ||
| FISCAL_DOC_ACCESS_KEY | VARCHAR2 | 50 | Fiscal document unique identifier, which is generated by concatenating multiple attributes of fiscal document. | ||
| REMIT_TO_SUPPLIER_NAME | VARCHAR2 | 240 | Third party supplier | ||
| REMIT_TO_SUPPLIER_ID | NUMBER | 18 | Third party supplier identifier | ||
| REMIT_TO_ADDRESS_NAME | VARCHAR2 | 240 | Remit-to address where the payment should be sent | ||
| REMIT_TO_ADDRESS_ID | NUMBER | 18 | Remit-to address identifier where the payment should be sent | ||
| RELATIONSHIP_ID | NUMBER | 18 | Third party relationship identifier | ||
| REMIT_TO_SUPPLIER_NUM | VARCHAR2 | 30 | Third party supplier number | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. | ||
| EXTERNAL_BANK_ACCOUNT_NUMBER | VARCHAR2 | 100 | Supplier preferred bank account to which the payments have to be made. | ||
| EXT_BANK_ACCOUNT_IBAN_NUMBER | VARCHAR2 | 50 | International Bank Account Number. | ||
| REQUESTER_EMAIL_ADDRESS | VARCHAR2 | 240 | The email address of the employee for the requested items. | ||
| ACC_REFERENCE_VALUE1 | VARCHAR2 | 4000 | This column is reserved for future internal use. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_INVOICES_INTERFACE_N1_ | Non Unique | Default | INVOICE_ID, LOAD_REQUEST_ID |
| AP_INVOICES_INTERFACE_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_ID, LOAD_REQUEST_ID |