[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 |
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.
| 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
EARLIEST_SETTLEMENT_DATE
INVOICE_DATE
|
| 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
PAYMENT_STATUS_FLAG
|
| AP_INVOICES_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVOICE_NUM
PARTY_ID
PAYMENT_STATUS_FLAG
|
| AP_INVOICES_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORG_ID
APPROVAL_READY_FLAG
VALIDATION_REQUEST_ID
PAYMENT_STATUS_FLAG
HISTORICAL_FLAG
|
| AP_INVOICES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYMENT_STATUS_FLAG
PAY_GROUP_LOOKUP_CODE
ORG_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 | Invoice identifier |
| 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 - user who last updated this row (foreign key to FND_USER.USER_ID). |
| VENDOR_ID | NUMBER | (15) | Supplier identifier | |
| INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice number |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identifier |
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of invoice |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of payment (must be same as INVOICE_CURRENCY_CODE or have a fixed rate relationship) |
| 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 | |
| INVOICE_AMOUNT | NUMBER | Invoice amount | ||
| VENDOR_SITE_ID | NUMBER | (15) | Supplier site identifier | |
| AMOUNT_PAID | NUMBER | Amount paid | ||
| DISCOUNT_AMOUNT_TAKEN | NUMBER | Amount of discount taken | ||
| INVOICE_DATE | DATE | Invoice date | ||
| SOURCE | VARCHAR2 | (25) | Source of invoice | |
| INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Type of invoice | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| BATCH_ID | NUMBER | (15) | Invoice batch identifier | |
| AMOUNT_APPLICABLE_TO_DISCOUNT | NUMBER | Amount of invoice applicable to a discount | ||
| TAX_AMOUNT | NUMBER | No Longer Used | ||
| TERMS_ID | NUMBER | (15) | Payment terms identifier | |
| TERMS_DATE | DATE | Date used with payment terms to calculate scheduled payment of an invoice | ||
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Name of payment method | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Name of 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 (Y, N, or P) | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| 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. | ||
| 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 FND_LOGINS.LOGIN_ID). | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | Pay invoice on separate payment document flag | |
| 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 to calculate invoice amount available for discount and provide defaults for automatic proration | ||
| GOODS_RECEIVED_DATE | DATE | Date invoice items received | ||
| INVOICE_RECEIVED_DATE | DATE | Date invoice received | ||
| VOUCHER_NUM | VARCHAR2 | (50) | Voucher number; validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled) | |
| APPROVED_AMOUNT | NUMBER | Invoice amount approved through manual authorization for payment (used for reference purposes only). | ||
| RECURRING_PAYMENT_ID | NUMBER | (15) | Recurring invoice identifier | |
| EXCHANGE_RATE | NUMBER | Exchange rate for foreign currency invoice | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for foreign currency invoice | |
| 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 you can apply the prepayment 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 | Sequential Numbering (voucher number) document sequence identifier | ||
| DOC_SEQUENCE_VALUE | NUMBER | Voucher number (Sequential Numbering) for invoice | ||
| DOC_CATEGORY_CODE | VARCHAR2 | (30) | Sequential Numbering (voucher number) document category | |
| 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) | Status of manual authorization invoice approval (used for reference purposes only). | |
| 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) | User ID of person who cancelled an invoice | |
| 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 | |
| TASK_ID | NUMBER | (15) | Identifier for project task used to build default Accounting Flexfield | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Project expenditure type used to build default Accounting Flexfield | |
| 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 | |
| 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 | |
| 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) | Organization identifier | |
| 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) | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and invoice amount in the reporting currency pairs | |
| MRC_EXCHANGE_RATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion rate pairs | |
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion rate type pairs | |
| MRC_EXCHANGE_DATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion date pairs | |
| GL_DATE | DATE | Yes | Accounting date to default to invoice 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 |
| REQUESTER_ID | NUMBER | (15) | Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers | |
| VALIDATION_REQUEST_ID | NUMBER | (15) | Identifier for the Invoce Validation concurrent request that is currently processing the invoice. | |
| 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 | |
| CREDITED_INVOICE_ID | NUMBER | (15) | Identifier for invoice to be fully reversed by a Credit or Debit Memo | |
| DISTRIBUTION_SET_ID | NUMBER | (15) | Distribution set identifier to be used in the generation of an invoice line and corresponding distributions for the line | |
| APPLICATION_ID | NUMBER | (15) | Application Identifier | |
| 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 | Total Tax Amount | ||
| SELF_ASSESSED_TAX_AMOUNT | NUMBER | Self Assessed Tax Amount | ||
| TAX_RELATED_INVOICE_ID | NUMBER | (15) | Tax Related Invoice Id | |
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Trx Business Category | |
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (240) | User Defined Fiscal Classification | |
| TAXATION_COUNTRY | VARCHAR2 | (30) | Taxation Country | |
| DOCUMENT_SUB_TYPE | VARCHAR2 | (150) | Document Sub Type | |
| SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 | (150) | Supplier Tax Invoice Number | |
| SUPPLIER_TAX_INVOICE_DATE | DATE | Supplier Tax Invoice Date | ||
| SUPPLIER_TAX_EXCHANGE_RATE | NUMBER | Supplier Tax Exchange Rate | ||
| TAX_INVOICE_RECORDING_DATE | DATE | Tax Invoice Recording Date | ||
| TAX_INVOICE_INTERNAL_SEQ | VARCHAR2 | (150) | Tax Invoice Internal Seq | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Legal Entity Id | |
| HISTORICAL_FLAG | VARCHAR2 | (1) | Historical Flag | |
| 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) | Payment method identifier | |
| 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 | |
| PAYMENT_FUNCTION | VARCHAR2 | (30) | The function or purpose of the payment | |
| CUST_REGISTRATION_CODE | VARCHAR2 | (50) | Customer legal registration code | |
| CUST_REGISTRATION_NUMBER | VARCHAR2 | (30) | Customer legal registration number | |
| PORT_OF_ENTRY_CODE | VARCHAR2 | (30) | Customs location code. | |
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | (15) | External bank account identifier | |
| VENDOR_CONTACT_ID | NUMBER | (15) | Foreign Key to PO_VENDOR_CONACTS | |
| 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 | OTM module uses this field. This contains invoice amount which is originally calculated. Actual invoice amount can be different. This happens due to price differences, short deliveries of the goodsand so. | ||
| DISPUTE_REASON | VARCHAR2 | (100) | OTM module uses this field. This contains the reason for dispute. Dispute can arises due to price differences, short deliveries and so. | |
| REMIT_TO_SUPPLIER_NAME | VARCHAR2 | (240) | Name of the third party payee | |
| REMIT_TO_SUPPLIER_ID | NUMBER | (15) | ID of the third party payee | |
| REMIT_TO_SUPPLIER_SITE | VARCHAR2 | (240) | Site code of the third party payee | |
| REMIT_TO_SUPPLIER_SITE_ID | NUMBER | (15) | Site id of the third party payee | |
| RELATIONSHIP_ID | NUMBER | (15) | Relationship ID |
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:
AP
AP_INVOICES_ALL#
|
|
|
|