[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_INVOICES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_INVOICES_ALL
|
| Subobject Name: | |
| Status: | VALID |
This table holds invoices records entered manually, generated automatically or imported from the open interface tables. This table corresponds to the Invoices header block of Invoice workbench.
AP_INVOICES_ALL holds information of all AP invoices whether it is a manually entered, imported, created from other products like Oracle Loans, Oracle Projects, iSupplier Portal, Refunds from Oracle Receivables etc. This table holds all type of invoices, which includes Standard, Prepayments, Credit Memo, Debit Memo, Mixed invoice, Withholding invoice, Interest Invoice, Retainage invoices, Payment Requests etc., An invoice can also have one or more scheduled payments. There will be one row for each invoice you enter. An invoice can have one or more invoice lines and each line can have one or more invoice distributions.
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. Oracle Payables application links the interest invoice to the original invoice by inserting the INVOICE_ID in the AP_INVOICE_RELATIONSHIPS table.
The accounting code combinations stored in this table is meta data for creating accounting entries in Subledger Accounting. Payables provides the code combinations stored in this table to Subledger Accounting as a source for accounting attributes for deriving the accounting code combinations. Subledger Accounting generates the final accounting entries that are posted to General Ledger. The accounting code combination used in the final accounting entries can be same as that stored in AP_INVOICES_ALL table or can be different depending on the rules setup in Subledger Accounting. The XLA_AE_HEADERS and XLA_AE_LINES tables in Subledger Accounting stores the accounting entries posted to General Ledger.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_INVOICES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INVOICE_ID
|
| AP_INVOICES_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
DOC_SEQUENCE_ID
DOC_SEQUENCE_VALUE
|
| AP_INVOICES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_ID
|
| AP_INVOICES_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_HEADER_ID
|
| AP_INVOICES_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
|
| AP_INVOICES_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VOUCHER_NUM
|
| AP_INVOICES_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DOC_SEQUENCE_VALUE
|
| AP_INVOICES_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GLOBAL_ATTRIBUTE1
|
| AP_INVOICES_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAID_ON_BEHALF_EMPLOYEE_ID
|
| AP_INVOICES_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WFAPPROVAL_STATUS
|
| AP_INVOICES_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VALIDATION_REQUEST_ID
|
| AP_INVOICES_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ID
INVOICE_NUM
ORG_ID
|
| AP_INVOICES_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREDITED_INVOICE_ID
|
| AP_INVOICES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ID
INVOICE_TYPE_LOOKUP_CODE
|
| AP_INVOICES_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVOICE_NUM
PARTY_ID
PAYMENT_STATUS_FLAG
|
| AP_INVOICES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYMENT_STATUS_FLAG
VENDOR_ID
|
| AP_INVOICES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVOICE_DATE
ORG_ID
|
| AP_INVOICES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVOICE_NUM
|
| AP_INVOICES_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_SITE_ID
|
| AP_INVOICES_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_ID | NUMBER | (15) | Yes | Unique internal Identifier for this record. Generated using a database sequence. |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. |
| VENDOR_ID | NUMBER | (15) | The unique internal identifier of the supplier to which the invoice belongs. Foreign key to the AP_SUPPLIERS table. | |
| INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice number for an invoice. This number entered will be unique per supplier and operating unit. |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Ledger unique identifier |
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of the invoice. Foreign key to the FND_CURRENCIES table. |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of payment. If the Invoice Currency is not a fixed-rate currency, then the Payment Currency will be the same as the INVOICE_CURRENCY_CODE. For fixed-rate currency such as euro or another EMU currency it can be different to INVOICE_CURRENCY_CODE |
| PAYMENT_CROSS_RATE | NUMBER | Yes | Exchange rate between invoice and payment. The value is always 1 unless they are associated fixed-rate currencies such as euro or another EMU currency. | |
| INVOICE_AMOUNT | NUMBER | Total amount of the invoice. This amount can be negative for following types of invoices:� Credit Memo� Debit Memo� Mixed� Automatic Withholding� Expense Reports | ||
| VENDOR_SITE_ID | NUMBER | (15) | The unique internal identifier for the payment site of the supplier. Foreign key to the AP_SUPPLIER_SITES_ALL table. | |
| AMOUNT_PAID | NUMBER | Invoice amount paid | ||
| DISCOUNT_AMOUNT_TAKEN | NUMBER | This is the amount of discount taken for the invoice. This column gets updated during payment processing of this invoice and when discount is calculated. | ||
| INVOICE_DATE | DATE | Invoice date | ||
| SOURCE | VARCHAR2 | (25) | Defines the source of the invoice. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'SOURCE' | |
| INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Defines the source of the invoice. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'INVOICE TYPE' | |
| DESCRIPTION | VARCHAR2 | (240) | Description of the invoice. This column is a free form text field in Invoice workbench. | |
| BATCH_ID | NUMBER | (15) | Invoice Batch Identifier. This column will be populated if Invoices are entered in batches. Foreign key to the AP_BATCHES_ALL table. | |
| AMOUNT_APPLICABLE_TO_DISCOUNT | NUMBER | Amount of invoice applicable to a discount. This column gets calculated during scheduled payment creation based following :- Exclude Freight from discount option- Execlude Tax from the discount option- Prepayment applied with discount or without discount | ||
| TAX_AMOUNT | NUMBER | No Longer Used | ||
| TERMS_ID | NUMBER | (15) | Payment terms identifier, this column corresponds to the 'Terms' field in Invoice workbench. Foreign key to the TERMS_ID of the AP_TERMS_TL table. | |
| TERMS_DATE | DATE | Date used with payment terms to calculate scheduled payment of an invoice. This date will be defaulted from one of the following Payables System Setup option defined for Term Date Basis:� System Date� Goods Received Date� Invoice Date� Invoice Received Date | ||
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Name of the payment method used to pay the supplier site. Foreign key from the table IBY_PAYMENT_METHODS_B. This column is populated only for the invoices that are migrated from prior release. | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Name of the Paygroup defined to pay a category of suppliers or invoices in the same payment batch. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'PAY GROUP' | |
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for accounts payable liability account | |
| PAYMENT_STATUS_FLAG | VARCHAR2 | (1) | Flag that indicates if invoice has been paid or not. Possible Values:� 'N': Not paid� 'Y': Paid� 'P': Partially Paid | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. | |
| BASE_AMOUNT | NUMBER | Invoice amount in functional currency. This column gets populated for the invoice entered in non-functional currency and this column corresponds to the 'Functional Curr Amount' field in Invoice workbench. | ||
| VAT_CODE | VARCHAR2 | (15) | No Longer Used | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table. | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | This flag indicates to pay this invoice using separate payment document.This columns corresponds to 'Pay alone' checkbox of Invoice Workbench. | |
| PO_HEADER_ID | NUMBER | (15) | Purchase order identifier for invoices with QUICKMATCH and PO DEFAULT types, and prepayments associated with purchase order | |
| FREIGHT_AMOUNT | NUMBER | Freight amount used exclude when Payables calculates the default discountable amount for an invoice, if your Exclude Freight from Discount option is enabled for the supplier site. | ||
| GOODS_RECEIVED_DATE | DATE | Date invoice items received | ||
| INVOICE_RECEIVED_DATE | DATE | Date invoice received | ||
| VOUCHER_NUM | VARCHAR2 | (50) | Voucher number assigned to an invoice for internal tracking purposes. Payables assigns a unique number if Sequential numbering is enabled and will be free form text field if sequential number is not enabled. It will be a non-editable field if payables assigns the number. | |
| APPROVED_AMOUNT | NUMBER | Invoice amount approved through manual authorization for payment (used for reference purposes only). | ||
| RECURRING_PAYMENT_ID | NUMBER | (15) | Recurring invoice identifier. Foreign key to the RECURRING_PAYMENT_ID of the AP_RECURRING_PAYMENTS_ALL table. | |
| EXCHANGE_RATE | NUMBER | Exchange rate for foreign currency invoice. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for foreign currency invoice. Payables uses following five types of exchange rates;� User� Spot� Corporate� User-Defined� EMU Fixed | |
| EXCHANGE_DATE | DATE | Date exchange rate is effective, usually accounting date of a transaction | ||
| EARLIEST_SETTLEMENT_DATE | DATE | Date associated with a prepayment after which prepayment can be applied against invoices. Only used for temporary prepayments. Column is null for permanent prepayments and other invoice types. | ||
| ORIGINAL_PREPAYMENT_AMOUNT | NUMBER | No longer used | ||
| DOC_SEQUENCE_ID | NUMBER | Unique Sequence identifier assigned to an invoice, based on the document category of the invoice. Foreign key to the DOC_SEQUENCE_ID of the AP_DOC_SEQUENCE_AUDIT table. | ||
| DOC_SEQUENCE_VALUE | NUMBER | Sequence name assigned to an invoice, based on the document category of the invoice. Foreign key to the DOC_SEQUENCE_VALUE of the AP_DOC_SEQUENCE_AUDIT table. | ||
| DOC_CATEGORY_CODE | VARCHAR2 | (30) | Document category for an invoice. Payables predefines a document category for each invoice type. If Sequential Numbering profile option is enabled, this document category defaults to an invoice during entry. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| APPROVAL_STATUS | VARCHAR2 | (25) | No Longer used | |
| APPROVAL_DESCRIPTION | VARCHAR2 | (240) | Description of manual authorization invoice approval (used for reference purposes only). | |
| INVOICE_DISTRIBUTION_TOTAL | NUMBER | No longer used | ||
| POSTING_STATUS | VARCHAR2 | (15) | Status that indicates if invoice can be posted (either Available or N - column is populated, but not used) | |
| PREPAY_FLAG | VARCHAR2 | (1) | No longer used | |
| AUTHORIZED_BY | VARCHAR2 | (25) | No longer used. | |
| CANCELLED_DATE | DATE | Date invoice cancelled | ||
| CANCELLED_BY | NUMBER | (15) | Unique internal identifier of user who cancelled an invoice. Foreign key to the USER_ID column of the FND_USER table. | |
| CANCELLED_AMOUNT | NUMBER | Original amount of cancelled invoice | ||
| TEMP_CANCELLED_AMOUNT | NUMBER | Column for recording the original amount of an invoice until cancellation completes successfully | ||
| PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | No longer used | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Default transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables) | |
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | USSGL Transaction Code Descriptive Flexfield context column | |
| PROJECT_ID | NUMBER | (15) | Identifier for project used to build default Accounting Flexfield. Foreign key to the PROJECT_ID column of the PA_PROJECTS_ALL. | |
| TASK_ID | NUMBER | (15) | Identifier for project task used to build default Accounting Flexfield. Foreign key to the TASK_ID column of the TASK_ID. | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Project expenditure type used to build default Accounting Flexfield. Foreign key to the EXPENDITURE_TYPE column of the PA_EXPENDITURE_TYPES. | |
| EXPENDITURE_ITEM_DATE | DATE | Project expenditure item date used to build default Accounting Flexfield | ||
| PA_QUANTITY | NUMBER | (22) | Project item quantity used to build default Accounting Flexfield | |
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Identifier for project organization used to build default Accounting Flexfield. Foreign key to the EXPENDITURE_ORGANIZATION_ID of the PA_EXPENDITURE_TYPES. | |
| PA_DEFAULT_DIST_CCID | NUMBER | (15) | Identifier for project-related invoice default Accounting Flexfield (defaults to invoice distribution lines) | |
| VENDOR_PREPAY_AMOUNT | NUMBER | No longer used | ||
| PAYMENT_AMOUNT_TOTAL | NUMBER | Amount of invoice that has been paid | ||
| AWT_FLAG | VARCHAR2 | (1) | Flag to indicate if Automatic Withholding Tax has been calculated automatically (A), or manually (M) | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding Tax group identifier at Invoice Validation time. | |
| REFERENCE_1 | VARCHAR2 | (30) | Reference information from Oracle Projects expense reports | |
| REFERENCE_2 | VARCHAR2 | (30) | Reference information from Oracle Projects expense reports | |
| ORG_ID | NUMBER | (15) | Unique internal identifier of the Operating Unit to which the invoice belongs. | |
| PRE_WITHHOLDING_AMOUNT | NUMBER | Reserved for future use | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | No Longer Used | |
| PAYMENT_CROSS_RATE_TYPE | VARCHAR2 | (30) | Cross currency payment rate type (only valid value in this release is EMU Fixed) | |
| PAYMENT_CROSS_RATE_DATE | DATE | Cross currency payment rate date | ||
| PAY_CURR_INVOICE_AMOUNT | NUMBER | Invoice amount in the payment currency | ||
| MRC_BASE_AMOUNT | VARCHAR2 | (2000) | No Longer used | |
| MRC_EXCHANGE_RATE | VARCHAR2 | (2000) | No Longer used | |
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | (2000) | No Longer used | |
| MRC_EXCHANGE_DATE | VARCHAR2 | (2000) | No Longer used | |
| GL_DATE | DATE | Yes | Accounting date to default to invoice lines and distributions. | |
| AWARD_ID | NUMBER | (15) | If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information | |
| PAID_ON_BEHALF_EMPLOYEE_ID | NUMBER | (15) | 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. | |
| AMT_DUE_CCARD_COMPANY | NUMBER | Amount that is due to credit card company | ||
| AMT_DUE_EMPLOYEE | NUMBER | Amount that is due to employee | ||
| APPROVAL_READY_FLAG | VARCHAR2 | (1) | Yes | Indicates whether invoice is ready for the Invoice Approval Workflow process (Y or N) |
| APPROVAL_ITERATION | NUMBER | (9) | Count of times invoice has passed through the Invoice Approval Workflow process | |
| WFAPPROVAL_STATUS | VARCHAR2 | (50) | Yes | Status of invoice in the Invoice Approval Workflow process. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'AP_WFAPPROVAL_STATUS'. |
| REQUESTER_ID | NUMBER | (15) | Requester of invoice used by Invoice Workflow Approval process to generate list of approvers. Valid values from active HR employees. Validated against PER_ALL_PEOPLE_F.PERSON_ID. | |
| VALIDATION_REQUEST_ID | NUMBER | (15) | Identifier for the Invoice Validation concurrent request that is currently processing the invoice. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table. | |
| VALIDATED_TAX_AMOUNT | NUMBER | Total tax amount excluded from the discountable amount | ||
| QUICK_CREDIT | VARCHAR2 | (1) | Indicates whether a Credit or Debit Memo was created as a Quick Credit (Y or N). Allowed to update only for Invoices of Credit or Debit Memo. | |
| CREDITED_INVOICE_ID | NUMBER | (15) | Identifier for invoice to be fully reversed by a Credit or Debit Memo. This column corresponds to the 'Credited Invoice' field of Invoice workbench. This is a mandatory if QUICK_CREDIT flag is set to 'Y'. | |
| DISTRIBUTION_SET_ID | NUMBER | (15) | Distribution set identifier to be used to default on an invoice line and used in the generation of distributions for the line. Foreign key to the DISTRIBUTION_SET_ID of AP_DISTRIBUTION_SETS_ALL table. | |
| APPLICATION_ID | NUMBER | (15) | Unique internal application identifier. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table. | |
| PRODUCT_TABLE | VARCHAR2 | (30) | Product source table name | |
| REFERENCE_KEY1 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY2 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY3 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY4 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| REFERENCE_KEY5 | VARCHAR2 | (150) | Primary key information that will uniquely identify a record in other products view | |
| TOTAL_TAX_AMOUNT | NUMBER | The sum of the exclusive and inclusive tax amounts on an invoice. The amount will be refreshed every time a change in the tax amounts happens (for example after recalculation). | ||
| SELF_ASSESSED_TAX_AMOUNT | NUMBER | Total self-assessed tax amount on the invoice. | ||
| TAX_RELATED_INVOICE_ID | NUMBER | (15) | Invoice Id from AP_INVOICES_ALL, used to link two invoices that were split by the supplier such as for shipping reasons, but that should be treated as one for tax purposes. | |
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Transaction Business Category used to identify and classify your business transactions for tax calculation purpose. This column corresponds to 'Business Category' field of Invoice Workbench. | |
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classification used to to classify any tax requirement that you cannot define using the seeded fiscal classification types. This column corresponds to 'Fiscal Classification' of Invoice Workbench. | |
| TAXATION_COUNTRY | VARCHAR2 | (30) | The country in which the transaction is deemed to have taken place for taxation purposes. E-Business Tax will set the context of other tax drivers such as Product Fiscal Classification based on the value of this field. | |
| DOCUMENT_SUB_TYPE | VARCHAR2 | (150) | Document sub type is used for documentation classification within the application event class of the transaction. Used for certain countries, where tax or governmental authority defines and classifies document types for reporting purposes. This column replaces an existing GDFF. | |
| SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 | (150) | The invoice number of the tax invoice issued by supplier. This field is a reporting tax driver used to satisfy reporting requirements for certain tax authorities like Thailand. This column replaces an existing GDFF. | |
| SUPPLIER_TAX_INVOICE_DATE | DATE | The date on the tax invoice issued by supplier. This field is a reporting tax driver for certain countries. This column replaces an existing GDFF. | ||
| SUPPLIER_TAX_EXCHANGE_RATE | NUMBER | The external exchange rate used to calculate the amount of the supplier-issued tax invoice in foreign currency. This column replaces an existing GDFF. | ||
| TAX_INVOICE_RECORDING_DATE | DATE | The date the deploying company recorded the supplier-issued tax invoice in its internal records. This column is used to satisfy reporting requirements in certain countries. | ||
| TAX_INVOICE_INTERNAL_SEQ | VARCHAR2 | (150) | The internal sequential number that the deploying company uses to identify the supplier tax invoice when it receives it. The column replaces an existing GDFF. | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Legal Entity Id | |
| HISTORICAL_FLAG | VARCHAR2 | (1) | Flag to represent whether the document / invoice has been upgraded from a prior release or whether it has been newly created. | |
| FORCE_REVALIDATION_FLAG | VARCHAR2 | (1) | Force Revalidation Flag | |
| BANK_CHARGE_BEARER | VARCHAR2 | (30) | Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER | |
| REMITTANCE_MESSAGE1 | VARCHAR2 | (150) | Remittance message for use in payment processing | |
| REMITTANCE_MESSAGE2 | VARCHAR2 | (150) | Remittance message for use in payment processing | |
| REMITTANCE_MESSAGE3 | VARCHAR2 | (150) | Remittance message for use in payment processing | |
| UNIQUE_REMITTANCE_IDENTIFIER | VARCHAR2 | (30) | Unique remittance identifier provided by the payee | |
| URI_CHECK_DIGIT | VARCHAR2 | (2) | Unique remittance identifier check digit | |
| 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 | |
| PAYMENT_REASON_CODE | VARCHAR2 | (30) | Payment reason code | |
| PAYMENT_REASON_COMMENTS | VARCHAR2 | (240) | Free text field available for entering a reason for the payment | |
| PAYMENT_METHOD_CODE | VARCHAR2 | (30) | Name of the payment method used to pay the supplier site. Foreign key from the table IBY_PAYMENT_METHODS_B. | |
| DELIVERY_CHANNEL_CODE | VARCHAR2 | (30) | Delivery channel code | |
| QUICK_PO_HEADER_ID | NUMBER | (15) | PO Number ID is used for QuickMatch and to default values from the purchase order to the invoice header. | |
| NET_OF_RETAINAGE_FLAG | VARCHAR2 | (1) | Flag to indicate invoice amount is net of retainage | |
| RELEASE_AMOUNT_NET_OF_TAX | NUMBER | Invoice amount net of tax for retainage release invoices | ||
| CONTROL_AMOUNT | NUMBER | User-enterable value to ensure that the calculated tax will be the same as on the physical document. | ||
| PARTY_ID | NUMBER | (15) | Party identifier | |
| PARTY_SITE_ID | NUMBER | (15) | Party Site identifier | |
| PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 | (30) | Type of payment processing transaction or document. This derived from the PAYMENT_FUNCTION and passed to IBY to get IBY Defaults. | |
| PAYMENT_FUNCTION | VARCHAR2 | (30) | Function or purpose of the payment. Possible values are - PAYABLES_DISB, AR_CUSTOMER_REFUNDS, LOANS_PAYMENTS. Values are derived from FND_LOOKUP_VALUES for lookup_type IBY_PAYMENT_FUNCTIONS. | |
| CUST_REGISTRATION_CODE | VARCHAR2 | (50) | Customer legal registration code | |
| CUST_REGISTRATION_NUMBER | VARCHAR2 | (30) | Customer legal registration number. This column corresponds to 'Customer Taxpayer ID' of Invoice Workbench. | |
| PORT_OF_ENTRY_CODE | VARCHAR2 | (30) | Customs location code. | |
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | (15) | Unique internal identifier for the supplier bank account associated with Invoice. Foreign key to the IBY_EXT_BANK_ACCOUNTS table. | |
| VENDOR_CONTACT_ID | NUMBER | (15) | Foreign Key to PO_VENDOR_CONTACTS | |
| INTERNAL_CONTACT_EMAIL | VARCHAR2 | (2000) | Email address of possible internal contact | |
| 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) | |
| 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) | |
| PAY_AWT_GROUP_ID | NUMBER | (15) | Withholding Tax group identifier at Payment time. | |
| ORIGINAL_INVOICE_AMOUNT | NUMBER | Original Invoice Amount captured in case of a Dispute. | ||
| DISPUTE_REASON | VARCHAR2 | (100) | Dispute Reason | |
| REMIT_TO_SUPPLIER_NAME | VARCHAR2 | (240) | Name of the supplier to whom invoice amount can be remitted. | |
| REMIT_TO_SUPPLIER_ID | NUMBER | (15) | Unique supplier identifier to whom invoice amount can be remitted. | |
| REMIT_TO_SUPPLIER_SITE | VARCHAR2 | (240) | Name of the supplier site to whom invoice amount can be remitted. | |
| REMIT_TO_SUPPLIER_SITE_ID | NUMBER | (15) | Unique supplier site identifier to whom invoice amount can be remitted. | |
| RELATIONSHIP_ID | NUMBER | (15) | Unique identifier to third party relationships of a supplier with another supplier. This column will be populated if the payment is made to the third party. |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, VENDOR_ID
, INVOICE_NUM
, SET_OF_BOOKS_ID
, INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE
, PAYMENT_CROSS_RATE
, INVOICE_AMOUNT
, VENDOR_SITE_ID
, AMOUNT_PAID
, DISCOUNT_AMOUNT_TAKEN
, INVOICE_DATE
, SOURCE
, INVOICE_TYPE_LOOKUP_CODE
, DESCRIPTION
, BATCH_ID
, AMOUNT_APPLICABLE_TO_DISCOUNT
, TAX_AMOUNT
, TERMS_ID
, TERMS_DATE
, PAYMENT_METHOD_LOOKUP_CODE
, PAY_GROUP_LOOKUP_CODE
, ACCTS_PAY_CODE_COMBINATION_ID
, PAYMENT_STATUS_FLAG
, CREATION_DATE
, CREATED_BY
, BASE_AMOUNT
, VAT_CODE
, LAST_UPDATE_LOGIN
, EXCLUSIVE_PAYMENT_FLAG
, PO_HEADER_ID
, FREIGHT_AMOUNT
, GOODS_RECEIVED_DATE
, INVOICE_RECEIVED_DATE
, VOUCHER_NUM
, APPROVED_AMOUNT
, RECURRING_PAYMENT_ID
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, EARLIEST_SETTLEMENT_DATE
, ORIGINAL_PREPAYMENT_AMOUNT
, DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE
, DOC_CATEGORY_CODE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, APPROVAL_STATUS
, APPROVAL_DESCRIPTION
, INVOICE_DISTRIBUTION_TOTAL
, POSTING_STATUS
, PREPAY_FLAG
, AUTHORIZED_BY
, CANCELLED_DATE
, CANCELLED_BY
, CANCELLED_AMOUNT
, TEMP_CANCELLED_AMOUNT
, PROJECT_ACCOUNTING_CONTEXT
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, PA_QUANTITY
, EXPENDITURE_ORGANIZATION_ID
, PA_DEFAULT_DIST_CCID
, VENDOR_PREPAY_AMOUNT
, PAYMENT_AMOUNT_TOTAL
, AWT_FLAG
, AWT_GROUP_ID
, REFERENCE_1
, REFERENCE_2
, ORG_ID
, PRE_WITHHOLDING_AMOUNT
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, AUTO_TAX_CALC_FLAG
, PAYMENT_CROSS_RATE_TYPE
, PAYMENT_CROSS_RATE_DATE
, PAY_CURR_INVOICE_AMOUNT
, MRC_BASE_AMOUNT
, MRC_EXCHANGE_RATE
, MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_DATE
, GL_DATE
, AWARD_ID
, PAID_ON_BEHALF_EMPLOYEE_ID
, AMT_DUE_CCARD_COMPANY
, AMT_DUE_EMPLOYEE
, APPROVAL_READY_FLAG
, APPROVAL_ITERATION
, WFAPPROVAL_STATUS
, REQUESTER_ID
, VALIDATION_REQUEST_ID
, VALIDATED_TAX_AMOUNT
, QUICK_CREDIT
, CREDITED_INVOICE_ID
, DISTRIBUTION_SET_ID
, APPLICATION_ID
, PRODUCT_TABLE
, REFERENCE_KEY1
, REFERENCE_KEY2
, REFERENCE_KEY3
, REFERENCE_KEY4
, REFERENCE_KEY5
, TOTAL_TAX_AMOUNT
, SELF_ASSESSED_TAX_AMOUNT
, TAX_RELATED_INVOICE_ID
, TRX_BUSINESS_CATEGORY
, USER_DEFINED_FISC_CLASS
, TAXATION_COUNTRY
, DOCUMENT_SUB_TYPE
, SUPPLIER_TAX_INVOICE_NUMBER
, SUPPLIER_TAX_INVOICE_DATE
, SUPPLIER_TAX_EXCHANGE_RATE
, TAX_INVOICE_RECORDING_DATE
, TAX_INVOICE_INTERNAL_SEQ
, LEGAL_ENTITY_ID
, HISTORICAL_FLAG
, FORCE_REVALIDATION_FLAG
, BANK_CHARGE_BEARER
, REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3
, UNIQUE_REMITTANCE_IDENTIFIER
, URI_CHECK_DIGIT
, SETTLEMENT_PRIORITY
, PAYMENT_REASON_CODE
, PAYMENT_REASON_COMMENTS
, PAYMENT_METHOD_CODE
, DELIVERY_CHANNEL_CODE
, QUICK_PO_HEADER_ID
, NET_OF_RETAINAGE_FLAG
, RELEASE_AMOUNT_NET_OF_TAX
, CONTROL_AMOUNT
, PARTY_ID
, PARTY_SITE_ID
, PAY_PROC_TRXN_TYPE_CODE
, PAYMENT_FUNCTION
, CUST_REGISTRATION_CODE
, CUST_REGISTRATION_NUMBER
, PORT_OF_ENTRY_CODE
, EXTERNAL_BANK_ACCOUNT_ID
, VENDOR_CONTACT_ID
, INTERNAL_CONTACT_EMAIL
, DISC_IS_INV_LESS_TAX_FLAG
, EXCLUDE_FREIGHT_FROM_DISCOUNT
, PAY_AWT_GROUP_ID
, ORIGINAL_INVOICE_AMOUNT
, DISPUTE_REASON
, REMIT_TO_SUPPLIER_NAME
, REMIT_TO_SUPPLIER_ID
, REMIT_TO_SUPPLIER_SITE
, REMIT_TO_SUPPLIER_SITE_ID
, RELATIONSHIP_ID
FROM AP.AP_INVOICES_ALL;
AP.AP_INVOICES_ALL does not reference any database object
AP.AP_INVOICES_ALL is referenced by following:
APPS
AP_INVOICES
AP_INVOICES_ALL
IGI_CIS2007_IGIPMTHR_PKG
- show dependent code
IGI_CIS2007_IGIPMTHR_PKG
- show dependent code
IGI_SIA_AP_INVOICES_ALL_T1
ITG_IP_INVOICES_ALL_ARI
JAI_AP_IA_ARIUD_T1
JAI_AP_IA_BRIUD_T1
|
|
|
|