AP_INVOICES_ALL
AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice youenter. An invoice can have one or more invoice distribution lines. An invoice can also have one or more scheduled payments. An invoice of type EXPENSE REPORT must relate to a row in AP_EXPENSE_REPORT_HEADERS_ALL unless the record has been purged from AP_EXPENSE_REPORT_HEADERS_ALL. Your Oracle Payables application uses the INTEREST type invoice for interest that it calculates on invoices that are overdue. Your Oracle Payables application links the interest invoice to the original invoice by inserting the INVOICE_ID in the AP_INVOICE_RELATIONSHIPS table. This table corresponds to the Invoices window.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
AP_INVOICES_ALL_PK |
INVOICE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
---|---|---|---|---|---|---|---|
INVOICE_ID | NUMBER | 18 | Yes | Unique invoice identifier. | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
VENDOR_ID | NUMBER | 18 | Invoice supplier identifier. | Active | |||
INVOICE_NUM | VARCHAR2 | 50 | Yes | Unique number for supplier invoice. | Active | ||
SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Ledger identifier of the invoice. | Active | ||
INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code used on the invoice. | Active | ||
PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of payment (must be same as INVOICE_CURRENCY_CODE or have a fixed rate relationship) | Active | ||
PAYMENT_CROSS_RATE | NUMBER | Yes | Exchange rate between invoice and payment; in Release 11 the value is always 1 unless they are associated fixed-rate currencies | Active | |||
INVOICE_AMOUNT | NUMBER | Invoice amount in transaction currency. | Active | ||||
VENDOR_SITE_ID | NUMBER | 18 | Physical location of the supplier. | Active | |||
AMOUNT_PAID | NUMBER | Amount paid against an invoice. | Active | ||||
DISCOUNT_AMOUNT_TAKEN | NUMBER | Discount amount on an invoice. | Active | ||||
INVOICE_DATE | DATE | Date when an event will occur or occurred. | Active | ||||
SOURCE | VARCHAR2 | 25 | Feeder system from which an invoice is imported. | Active | |||
INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Invoice category, such as standard, credit memo, or prepayment. | Active | |||
DESCRIPTION | VARCHAR2 | 240 | Statement that describes the invoice. | Active | |||
BATCH_ID | NUMBER | 18 | Unique invoice group identifier. | Active | |||
AMOUNT_APPLICABLE_TO_DISCOUNT | NUMBER | Amount of invoice applicable to a discount | Active | ||||
TERMS_ID | NUMBER | 18 | Payment terms identifier used on the invoice. | Active | |||
TERMS_DATE | DATE | Date used with payment terms to calculate scheduled payment of an invoice | Active | ||||
PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | 25 | Indicates the payment method of the invoice. | Active | |||
PAY_GROUP_LOOKUP_CODE | VARCHAR2 | 25 | Groups a category of suppliers or invoices for single pay run. For example, employees, merchandise, nonmerchandise, government, domestic, and international. | Active | |||
ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for accounts payable liability account | Active | |||
PAYMENT_STATUS_FLAG | VARCHAR2 | 1 | Flag that indicates if invoice has been paid (Y, N, or P) | Active | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
BASE_AMOUNT | NUMBER | When the Calculate User Exchange Rate option is enabled and when the exchange rate type is User, the user can enter a value for BASE_AMOUNT so the system can calculate the exchange rate. | Active | ||||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Pay invoice on separate payment document flag | Active | |||
PO_HEADER_ID | NUMBER | 18 | the PO number the invoice is matched to. | Active | |||
FREIGHT_AMOUNT | NUMBER | Total freight amount for an invoice. | Active | ||||
GOODS_RECEIVED_DATE | DATE | Date when goods on the invoice were received. | Active | ||||
INVOICE_RECEIVED_DATE | DATE | Date when the invoice was received. This is used to calculate when the invoice is due. | Active | ||||
VOUCHER_NUM | VARCHAR2 | 50 | Voucher number; validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled) | Active | |||
APPROVED_AMOUNT | NUMBER | Invoice amount approved through manual authorization for payment (used for reference purposes only). | Active | ||||
RECURRING_PAYMENT_ID | NUMBER | 18 | Recurring invoice identifier. | Active | |||
EARLIEST_SETTLEMENT_DATE | DATE | Date associated with a prepayment after which you can apply the prepayment against invoices. Only used for temporary prepayments. Column is null for permanent prepayments and other invoice types | Active | ||||
DOC_SEQUENCE_ID | NUMBER | Sequential Numbering (voucher number) document sequence identifier | Active | ||||
DOC_SEQUENCE_VALUE | NUMBER | Voucher number (Sequential Numbering) for invoice | Active | ||||
DOC_CATEGORY_CODE | VARCHAR2 | 30 | Sequential Numbering (voucher number) document category | Active | |||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE15 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Invoices (AP_INVOICES) | Active | ||
APPROVAL_STATUS | VARCHAR2 | 25 | Status of manual authorization invoice approval (used for reference purposes only). | Active | |||
APPROVAL_DESCRIPTION | VARCHAR2 | 240 | Description of manual authorization invoice approval (used for reference purposes only). | Active | |||
POSTING_STATUS | VARCHAR2 | 15 | Status that indicates if invoice can be posted (either Available or N - column is populated, but not used) | Active | |||
CANCELLED_DATE | DATE | Date when the invoice was canceled. | Active | ||||
CANCELLED_BY | VARCHAR2 | 64 | User ID of person who canceled an invoice. | Active | |||
CANCELLED_AMOUNT | NUMBER | Original amount of canceled invoice. | Active | ||||
TEMP_CANCELLED_AMOUNT | NUMBER | Column for recording the original amount of an invoice until cancellation completes successfully | Active | ||||
USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Default transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables) | Active | |||
USSGL_TRX_CODE_CONTEXT | VARCHAR2 | 30 | USSGL Transaction Code Descriptive Flexfield context column | Active | |||
PROJECT_ID | NUMBER | 18 | Identifier for project used to build default Accounting Flexfield | Active | |||
TASK_ID | NUMBER | 18 | Identifier for project task used to build default Accounting Flexfield | Active | |||
EXPENDITURE_TYPE | VARCHAR2 | 30 | Project expenditure type used to build default Accounting Flexfield | Active | |||
EXPENDITURE_ITEM_DATE | DATE | Project expenditure item date used to build default Accounting Flexfield | Active | ||||
PA_QUANTITY | NUMBER | Project item quantity used to build default Accounting Flexfield | Active | ||||
EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Identifier for project organization used to build default Accounting Flexfield | Active | |||
PA_DEFAULT_DIST_CCID | NUMBER | 18 | Identifier for project-related invoice default Accounting Flexfield (defaults to invoice distribution lines) | Active | |||
PAYMENT_AMOUNT_TOTAL | NUMBER | Amount of invoice that has been paid | Active | ||||
AWT_FLAG | VARCHAR2 | 1 | Flag to indicate if Automatic Withholding Tax has been calculated automatically (A), or manually (M) | Active | |||
AWT_GROUP_ID | NUMBER | 18 | Withholding tax group identifier | Active | |||
REFERENCE_1 | VARCHAR2 | 30 | Reference information from Oracle Projects expense reports | Active | |||
REFERENCE_2 | VARCHAR2 | 30 | Reference information from Oracle Projects expense reports | Active | |||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | Active | ||
PRE_WITHHOLDING_AMOUNT | NUMBER | Reserved for future use | Active | ||||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | |||
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. | |||||
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. | |||||
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_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. | |||||
PAYMENT_CROSS_RATE_TYPE | VARCHAR2 | 30 | Cross currency payment rate type (only valid value in this release is EMU Fixed) | Active | |||
PAYMENT_CROSS_RATE_DATE | DATE | Cross currency payment rate date | Active | ||||
PAY_CURR_INVOICE_AMOUNT | NUMBER | Invoice amount in the payment currency | Active | ||||
MRC_BASE_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and invoice amount in the reporting currency pairs | Active | |||
MRC_EXCHANGE_RATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion rate pairs | Active | |||
MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion rate type pairs | Active | |||
MRC_EXCHANGE_DATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion date pairs | Active | |||
MRC_POSTING_STATUS | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID | Active | |||
GL_DATE | DATE | Yes | Accounting date to default to invoice distributions | Active | |||
AWARD_ID | NUMBER | 18 | If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information | Active | |||
PAID_ON_BEHALF_EMPLOYEE_ID | NUMBER | 18 | When an expense report gets split in Both Pay scenario, the new expense report's paid_on_behalf_employee_id gets populated with the original expense report's employee_id. | Active | |||
AMT_DUE_CCARD_COMPANY | NUMBER | Amount that is due to credit card company | Active | ||||
AMT_DUE_EMPLOYEE | NUMBER | Amount that is due to an employee. | Active | ||||
APPROVAL_READY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether invoice is ready for the Invoice Approval Workflow process (Y or N) | Active | ||
APPROVAL_ITERATION | NUMBER | 9 | Count of times invoice has passed through the Invoice Approval Workflow process | Active | |||
WFAPPROVAL_STATUS | VARCHAR2 | 50 | Yes | Status of invoice in the Invoice Approval Workflow process | Active | ||
REQUESTER_ID | NUMBER | 18 | Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers | Active | |||
VALIDATION_REQUEST_ID | NUMBER | 18 | Identifier for the invoice validation concurrent request that is currently processing the invoice. | Active | |||
VALIDATED_TAX_AMOUNT | NUMBER | Total tax amount excluded from the discountable amount | Active | ||||
QUICK_CREDIT | VARCHAR2 | 1 | Indicates whether a Credit or Debit Memo was created as a Quick Credit | Active | |||
CREDITED_INVOICE_ID | NUMBER | 18 | Identifier for invoice to be fully reversed by a Credit or Debit Memo | Active | |||
DISTRIBUTION_SET_ID | NUMBER | 18 | Distribution set identifier to be used in the generation of an invoice line and corresponding distributions for the line | Active | |||
APPLICATION_ID | NUMBER | 18 | Unique identifier that identifies the application from where the invoice originated. | Active | |||
PRODUCT_TABLE | VARCHAR2 | 30 | Name of the product source table used for generating an invoice. | Active | |||
REFERENCE_KEY1 | VARCHAR2 | 4000 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY2 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY3 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY4 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
REFERENCE_KEY5 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | |||
TOTAL_TAX_AMOUNT | NUMBER | Total tax charged on an invoice. | Active | ||||
SELF_ASSESSED_TAX_AMOUNT | NUMBER | Total self-assessed tax amount on the invoice. | Active | ||||
TAX_RELATED_INVOICE_ID | NUMBER | 18 | Tax related to an invoice. | Active | |||
TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Identifies the taxable nature of a transaction based on the business. | Active | |||
USER_DEFINED_FISC_CLASS | VARCHAR2 | 240 | User Defined Fiscal Classification | Active | |||
TAXATION_COUNTRY | VARCHAR2 | 30 | Country in which the transaction occurred. Oracle Fusion tax sets the context of other tax drivers, such as Product Fiscal Classification based on this value. | Active | |||
DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Classification to categorize a document associated with a transaction for tax. This affects the taxability of the transaction. | Active | |||
SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Invoice supplier tax invoice number. | Active | |||
SUPPLIER_TAX_INVOICE_DATE | DATE | Date when the supplier charged tax, as shown on the purchase order. | Active | ||||
SUPPLIER_TAX_EXCHANGE_RATE | NUMBER | Conversion rate for taxes on a supplier invoice. | Active | ||||
TAX_INVOICE_RECORDING_DATE | DATE | Date when the invoice was recorded. | Active | ||||
TAX_INVOICE_INTERNAL_SEQ | VARCHAR2 | 150 | Invoice internal sequence number. | Active | |||
LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier of the legal entity. | Active | |||
HISTORICAL_FLAG | VARCHAR2 | 1 | Flag that indicates whether a document or invoice is upgraded from a prior release or is newly created. | Active | |||
FORCE_REVALIDATION_FLAG | VARCHAR2 | 1 | Indicator to enable revalidation of the invoice. | Active | |||
BANK_CHARGE_BEARER | VARCHAR2 | 30 | Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER | Active | |||
REMITTANCE_MESSAGE1 | VARCHAR2 | 150 | Remittance message for use in payment processing | Active | |||
REMITTANCE_MESSAGE2 | VARCHAR2 | 150 | Remittance message for use in payment processing | Active | |||
REMITTANCE_MESSAGE3 | VARCHAR2 | 150 | Remittance message for use in payment processing | Active | |||
UNIQUE_REMITTANCE_IDENTIFIER | VARCHAR2 | 256 | Unique remittance identifier provided by the payee | Active | |||
URI_CHECK_DIGIT | VARCHAR2 | 2 | Unique remittance identifier check digit | Active | |||
SETTLEMENT_PRIORITY | VARCHAR2 | 30 | The priority with which the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY | Active | |||
PAYMENT_REASON_CODE | VARCHAR2 | 30 | Codes provided by the government or central bank of a country. These codes provide the payment system or bank with additional details about the reason for the payment and are used for regulatory reporting purposes. | Active | |||
PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Free text field available for entering a reason for the payment | Active | |||
PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Indicates the payment method, such as check, cash, or credit. | Active | |||
DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Text on electronic payment that instructs the bank about the execution of payment. For example, print a check and hold it for collection by the payee. | Active | |||
QUICK_PO_HEADER_ID | NUMBER | 18 | PO Number ID is used for QuickMatch and to default values from the purchase order to the invoice header. | Active | |||
NET_OF_RETAINAGE_FLAG | VARCHAR2 | 1 | Flag to indicate invoice amount is net of retainage | Active | |||
RELEASE_AMOUNT_NET_OF_TAX | NUMBER | Invoice amount net of tax for retainage release invoices | Active | ||||
CONTROL_AMOUNT | NUMBER | User-enterable value to ensure that the calculated tax will be the same as on the physical document. | Active | ||||
PARTY_ID | NUMBER | 18 | An entity that can enter into business relationships with other entities and that submits invoices or other requests for payment. In some cases, goods or services or both are provided in return for payment. | Active | |||
PARTY_SITE_ID | NUMBER | 18 | Unique identity of the party site. | Active | |||
PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 | 30 | Type of payment processing transaction or document | Active | |||
PAYMENT_FUNCTION | VARCHAR2 | 30 | The function or purpose of the payment | Active | |||
CUST_REGISTRATION_CODE | VARCHAR2 | 50 | Customer legal registration code | Active | |||
CUST_REGISTRATION_NUMBER | VARCHAR2 | 30 | Customer legal registration number | Active | |||
PORT_OF_ENTRY_CODE | VARCHAR2 | 30 | Code that identifies the location or port through which the invoiced goods entered the country. | Active | |||
EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | External bank account identifier | Active | |||
VENDOR_CONTACT_ID | NUMBER | 18 | Foreign Key to PO_VENDOR_CONTACTS | Active | |||
INTERNAL_CONTACT_EMAIL | VARCHAR2 | 2000 | Email address of possible internal contact | Active | |||
DISC_IS_INV_LESS_TAX_FLAG | VARCHAR2 | 1 | Flag that indicates if tax amount is excluded from the discountable amount when invoice amount applicable to discount is calculated (Y or N) | Active | |||
EXCLUDE_FREIGHT_FROM_DISCOUNT | VARCHAR2 | 1 | Flag that indicates whether the freight amount is excluded from the discountable amount when calculating the discount (Y or N) | Active | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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. | Active | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Source of currency conversion rate for an invoice. For example, user defined, spot, or corporate. | Active | |||
EXCHANGE_RATE | NUMBER | Ratio at which the principal unit of one currency is converted into another currency for an invoice. | Active | ||||
EXCHANGE_DATE | DATE | Date when a conversion rate is used to convert an amount into another currency for an invoice. | Active | ||||
EMPLOYEE_ADDRESS_CODE | VARCHAR2 | 15 | Address Code for the Employee. Can be either 'HOME' or 'OFFICE | Active | |||
INTERCOMPANY_FLAG | VARCHAR2 | 1 | Intercompany flag added to incorporate FUN team's intercompany feature. | Active | |||
IMPORT_DOCUMENT_NUMBER | VARCHAR2 | 50 | Import declaration number or import manifest number provided by Customs when goods are imported. In countries, such as Israel, the common business practice is to report the details of the import invoice when the payable tax is demanded for the tax paid on the invoice that was obtained from the Customs Agent. The VAT percentage that is included in the invoice from the Customs Agent varies and consequently cannot be calculated from the total amount on the invoice. The Bill of Lading and Import Manifest represent the Import Declaration document which will include the name and legal entity number of the importer and the supplier and an unequivocal description of the goods including their four digit classification code. This field is used for VAT Tax reporting. | ||||
IMPORT_DOCUMENT_DATE | DATE | Import declaration date associated with the import document number. | |||||
CORRECTION_YEAR | NUMBER | 4 | The tax declaration year of a purchase transaction that is being corrected. | ||||
CORRECTION_PERIOD | VARCHAR2 | 2 | The tax declaration period of a purchase transaction that is being corrected. | ||||
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. | ||||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||||
TRANSACTION_DEADLINE | NUMBER | Number of days to perform an intra-EU transaction. Used for Modelo reports for Spain. | |||||
MERGE_REQUEST_ID | NUMBER | Supplier or Party merge request identifier | |||||
BUDGET_DATE | DATE | Budgetary Calendar Period Date applicable for funds check | |||||
DATA_SET_ID | NUMBER | Transaction Identifier for XCC Engine | |||||
FUNDS_STATUS | VARCHAR2 | 30 | Indicator to check and reserve funds for the invoice. | ||||
FIRST_PARTY_REGISTRATION_ID | NUMBER | 18 | First party tax registration identifier. | ||||
THIRD_PARTY_REGISTRATION_ID | NUMBER | 18 | Third party tax registration identifier. | ||||
ROUTING_ATTRIBUTE1 | VARCHAR2 | 270 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
ROUTING_ATTRIBUTE2 | VARCHAR2 | 270 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
ROUTING_ATTRIBUTE3 | VARCHAR2 | 270 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
ROUTING_ATTRIBUTE4 | VARCHAR2 | 270 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
ROUTING_ATTRIBUTE5 | VARCHAR2 | 270 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
IMAGE_DOCUMENT_NUM | VARCHAR2 | 50 | 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 | ||||
PO_MATCHED_FLAG | VARCHAR2 | 1 | Temporary identifier to determine whether an invoice is purchase order matched in Payables Invoice Validation batch program. | ||||
VALIDATION_WORKER_ID | NUMBER | 18 | Temporary identifier to set the worker assignment numnber in Payables Invoice Validation batch program. | ||||
LOCKED_BY | VARCHAR2 | 64 | User who has locked the invoice for edit | ||||
LOCK_TIME | TIMESTAMP | Time when invoice is locked for edit | |||||
ROUTING_STATUS_LOOKUP_CODE | VARCHAR2 | 30 | This value indicates the routing status of the invoice. The invoice can be in the process of routing or complete. | ||||
ACC_REFERENCE_VALUE1 | VARCHAR2 | 4000 | This column is reserved for future internal use. | ||||
ADDITIONAL_NOTE | VARCHAR2 | 4000 | Captures additional information for the invoice. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
AP_INVOICES_ALL | ap_batches_all | BATCH_ID |
AP_INVOICES_ALL | po_headers_all | PO_HEADER_ID |
AP_INVOICES_ALL | gl_code_combinations | PA_DEFAULT_DIST_CCID |
AP_INVOICES_ALL | ap_doc_sequence_audit | DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE |
AP_INVOICES_ALL | ap_awt_groups | AWT_GROUP_ID |
AP_INVOICES_ALL | gl_ussgl_transaction_codes | SET_OF_BOOKS_ID, USSGL_TRANSACTION_CODE |
AP_INVOICES_ALL | poz_supplier_contacts | VENDOR_CONTACT_ID |
AP_INVOICES_ALL | poz_suppliers | VENDOR_ID |
AP_INVOICES_ALL | gl_daily_conversion_types | PAYMENT_CROSS_RATE_TYPE |
AP_INVOICES_ALL | gl_ledgers | SET_OF_BOOKS_ID |
AP_INVOICES_ALL | hz_parties | PARTY_ID |
AP_INVOICES_ALL | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
AP_INVOICES_ALL | ap_invoices_all | TAX_RELATED_INVOICE_ID |
AP_INVOICES_ALL | hz_party_sites | PARTY_SITE_ID |
AP_INVOICES_ALL | per_persons | REQUESTER_ID |
AP_INVOICES_ALL | xle_entity_profiles | LEGAL_ENTITY_ID |
AP_INVOICES_ALL | poz_suppliers | REMIT_TO_SUPPLIER_ID |
AP_INVOICES_ALL | hz_party_sites | REMIT_TO_ADDRESS_ID |
AP_INVOICES_ALL | poz_sup_thirdparty_payment_rel | RELATIONSHIP_ID |
AP_INVOICES_ALL | ap_terms_b | TERMS_ID |
AP_INVOICES_ALL | pjf_projects_all_b | PROJECT_ID |
AP_INVOICES_ALL | gl_code_combinations | ACCTS_PAY_CODE_COMBINATION_ID |
AP_INVOICES_ALL | fnd_currencies_b | INVOICE_CURRENCY_CODE, ORG_ID |
fa_adj_src_lines_t | ap_invoices_all | INVOICE_ID |
fa_asset_invoices | ap_invoices_all | INVOICE_ID |
ap_checks_all | ap_invoices_all | ESCHEATMENT_INVOICE_ID |
ap_invoice_payments_all | ap_invoices_all | INVOICE_ID |
fun_trx_headers | ap_invoices_all | AP_INVOICE_ID |
ap_prepay_history_all | ap_invoices_all | INVOICE_ID |
ap_interface_rejections | ap_invoices_all | INVOICE_ID |
ap_selected_invoices_all | ap_invoices_all | INVOICE_ID |
ap_selected_invoices_all | ap_invoices_all | ORIGINAL_INVOICE_ID |
ap_apinv_approvers | ap_invoices_all | INVOICE_ID |
ap_invoice_lines_all | ap_invoices_all | INVOICE_ID |
ap_invoice_lines_all | ap_invoices_all | CORRECTED_INV_ID |
ap_invoice_lines_all | ap_invoices_all | PA_CC_AR_INVOICE_ID |
ap_invoice_lines_all | ap_invoices_all | RETAINED_INVOICE_ID |
ap_invoice_lines_all | ap_invoices_all | PREPAY_INVOICE_ID |
ap_holds_all | ap_invoices_all | INVOICE_ID |
fa_mc_asset_invoices | ap_invoices_all | INVOICE_ID |
ap_inv_aprvl_hist_all | ap_invoices_all | INVOICE_ID |
ap_self_assessed_tax_dist_all | ap_invoices_all | INVOICE_ID |
ap_unselected_invoices_all | ap_invoices_all | INVOICE_ID |
ap_invoices_all | ap_invoices_all | TAX_RELATED_INVOICE_ID |
fa_mass_additions | ap_invoices_all | INVOICE_ID |
ap_payment_schedules_all | ap_invoices_all | INVOICE_ID |
ap_awt_tax_rates_all | ap_invoices_all | VENDOR_ID, INVOICE_NUM, ORG_ID |
ap_invoice_distributions_all | ap_invoices_all | INVOICE_ID |
ap_invoice_distributions_all | ap_invoices_all | PARENT_INVOICE_ID |
ap_invoice_distributions_all | ap_invoices_all | AWT_INVOICE_ID |
ap_invoice_distributions_all | ap_invoices_all | COMPANY_PREPAID_INVOICE_ID |
ap_invoice_relationships | ap_invoices_all | RELATED_INVOICE_ID |
ap_invoice_relationships | ap_invoices_all | ORIGINAL_INVOICE_ID |
ap_awt_temp_distributions_all | ap_invoices_all | INVOICE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
AP_INVOICES_ALL_U1 | Unique | Default | INVOICE_ID | |
AP_INVOICES_ALL_U2 | Unique | Default | DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE | |
AP_INVOICES_ALL_U3 | Unique | Default | VENDOR_ID, INVOICE_NUM, ORG_ID, PARTY_ID | |
AP_INVOICES_N1 | Non Unique | FUSION_TS_TX_IDX | BATCH_ID | |
AP_INVOICES_N10 | Non Unique | FUSION_TS_TX_IDX | PO_HEADER_ID | Active |
AP_INVOICES_N11 | Non Unique | FUSION_TS_TX_IDX | PROJECT_ID, TASK_ID | Active |
AP_INVOICES_N12 | Non Unique | FUSION_TS_TX_IDX | VOUCHER_NUM | Active |
AP_INVOICES_N13 | Non Unique | FUSION_TS_TX_IDX | DOC_SEQUENCE_VALUE | Obsolete |
AP_INVOICES_N14 | Non Unique | FUSION_TS_TX_IDX | GLOBAL_ATTRIBUTE1 | Obsolete |
AP_INVOICES_N15 | Non Unique | FUSION_TS_TX_IDX | PAID_ON_BEHALF_EMPLOYEE_ID | Obsolete |
AP_INVOICES_N16 | Non Unique | FUSION_TS_TX_IDX | WFAPPROVAL_STATUS, ORG_ID | Active |
AP_INVOICES_N17 | Non Unique | FUSION_TS_TX_IDX | VALIDATION_REQUEST_ID | Active |
AP_INVOICES_N19 | Non Unique | FUSION_TS_TX_IDX | CREDITED_INVOICE_ID | Obsolete |
AP_INVOICES_N2 | Non Unique | FUSION_TS_TX_IDX | VENDOR_ID, INVOICE_TYPE_LOOKUP_CODE | Active |
AP_INVOICES_N20 | Non Unique | FUSION_TS_TX_IDX | ORG_ID | Obsolete |
AP_INVOICES_N21 | Non Unique | Default | UPPER("INVOICE_NUM"), INVOICE_TYPE_LOOKUP_CODE | |
AP_INVOICES_N22 | Non Unique | Default | PARTY_ID | |
AP_INVOICES_N23 | Non Unique | Default | SOURCE, APPROVAL_STATUS, CREATION_DATE, ORG_ID, ROUTING_ATTRIBUTE5 | |
AP_INVOICES_N24 | Non Unique | Default | ORG_ID, APPROVAL_READY_FLAG, VALIDATION_REQUEST_ID, PAYMENT_STATUS_FLAG, HISTORICAL_FLAG | |
AP_INVOICES_N25 | Non Unique | Default | INVOICE_NUM, PARTY_ID, PAYMENT_STATUS_FLAG | |
AP_INVOICES_N26 | Non Unique | Default | PAYMENT_STATUS_FLAG | Obsolete |
AP_INVOICES_N27 | Non Unique | Default | DATA_SET_ID | |
AP_INVOICES_N28 | Non Unique | Default | LAST_UPDATE_DATE, ORG_ID | |
AP_INVOICES_N3 | Non Unique | FUSION_TS_TX_IDX | PAYMENT_STATUS_FLAG, PAY_GROUP_LOOKUP_CODE, ORG_ID | Active |
AP_INVOICES_N4 | Non Unique | FUSION_TS_TX_IDX | INVOICE_AMOUNT | Obsolete |
AP_INVOICES_N5 | Non Unique | FUSION_TS_TX_IDX | INVOICE_DATE, ORG_ID | Active |
AP_INVOICES_N6 | Non Unique | FUSION_TS_TX_IDX | INVOICE_NUM | Obsolete |
AP_INVOICES_N7 | Non Unique | FUSION_TS_TX_IDX | VENDOR_SITE_ID | Active |
AP_INVOICES_N8 | Non Unique | FUSION_TS_TX_IDX | CREATION_DATE | Active |
AP_INVOICES_N9 | Non Unique | FUSION_TS_TX_IDX | INVOICE_TYPE_LOOKUP_CODE | Obsolete |