[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_INVOICES_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_INVOICES_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
This is the open interface table for importing AP Invoices from external sources and stores header information about invoices. Invoice data comes from sources including: EDI invoices from suppliers that are loaded through Oracle e-Commerce Gateway, supplier invoices that are transferred through the Oracle XML Gateway, invoices that are loaded using Oracle SQL*Loader, lease invoices from Oracle Property Manager, Disbursements from Oracle loans, lease payments from Oracle Assets, credit card transaction data that are loaded using the Credit Card Invoice Interface Summary, Expense Report invoices from Oracle Internet Expenses, Payment Requests from Receivables, and invoices that are entered through the Invoice Gateway. There is one row for each invoice you import. Oracle Payables application uses this information to create invoice header information when Payables Open Interface program is submitted.
Data in the AP_INVOICES_INTERFACE table used in conjunction with AP_INVOICE_LINES_INTERFACE table to create Payables Invoice, Invoice lines, Distributions and Schedule payments.
Data in this table can be viewed and edited using �Open Interface Invoices� window.
The Payables Open Interface program validates each record in this interface table selected for import, and if the record contains valid data then the program creates a Payables Invoice.
Please refer to the Oracle Payables Reference Guide for more detailed information on Open Interface table columns, including import validation and destination columns.
Description
Scope: public
Lifecycle: active
Display Name: AP Invoices Interface
Product: AP
Category: BUSINESS_ENTITY AP_INVOICE
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_INVOICES_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INVOICE_ID
|
| AP_INVOICES_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
STATUS
|
| AP_INVOICES_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SOURCE
GROUP_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_ID | NUMBER | (15) | Yes | Unique identifier for this invoice within this batch. Same value should be populated in invoice's lines in the AP_INVOICE_LINES_INTERFACE table to identify the data as belonging to the same invoice. |
| INVOICE_NUM | VARCHAR2 | (50) | Enter the invoice number that needs to be assigned to the invoice created in Payables from this record. The number must be unique for the supplier. If no value is populated in this column, then during import, Payables uses the system date at the time of import as a default. | |
| INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Type of Invoice (can be STANDARD, CREDIT or PREPAYMENT) | |
| INVOICE_DATE | DATE | Date of the invoice. If no value is populated, the system uses the sysytem date at the time of import as the invoice date. | ||
| PO_NUMBER | VARCHAR2 | (20) | Purchase order number from PO_HEADERS.SEGMENT1. This column needs to be populated if invoice to be matched with an purchase order. | |
| VENDOR_ID | NUMBER | (15) | Unique identifier for a supplier. Validated against (PO_VENDORS.VENDOR_ID). Supplier of the invoice to be derived by value in one of the following columns in this table: VENDOR_ID, VENDOR_NUM, VENDOR_NAME, VENDOR_SITE_ID or PO_NUMBER. | |
| VENDOR_NUM | VARCHAR2 | (30) | Supplier number. Validated against PO_VENDORS_SEGMENT1. | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name. Validated against PO_VENDORS.VENDOR_NAME. | |
| VENDOR_SITE_ID | NUMBER | (15) | Supplier pay site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID | |
| VENDOR_SITE_CODE | VARCHAR2 | (15) | Supplier pay site code. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE | |
| INVOICE_AMOUNT | NUMBER | Invoice amount. This amount should be negative for invoice type 'CREDIT'. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Currency of invoice. Validated against FND_CURRENCIES.CURRENCY_CODE | |
| EXCHANGE_RATE | NUMBER | Exchange rate of foreign currency invoices. If the Payables option Require Exchange Rate Entry is enabled, then this column is a mandatory for Payables to derive the exchange rate during import. If EXCHANGE_RATE_TYPE is User, then value must be populated in this column(or, if the Payables option Calculate User Exchange Rate is enabled, then value must be populated in NO_XRATE_BASE_AMOUNT instead). | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for foreign currency invoices. Validated against GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE | |
| EXCHANGE_DATE | DATE | Date exchange rate is effective, usually accounting date of a transaction | ||
| TERMS_ID | NUMBER | (15) | Payment terms identifier. Validated against AP_TERMS_TL.TERM_ID | |
| TERMS_NAME | VARCHAR2 | (50) | Payment terms identifier, this column corresponds to the Validated against AP_TERMS_TL.NAME | |
| DESCRIPTION | VARCHAR2 | (240) | Invoice description | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding tax group identifier at Invoice Validation time. Validated against AP_AWT_GROUPS.AWT_GROUP_ID. | |
| AWT_GROUP_NAME | VARCHAR2 | (25) | Withholding tax group name at Invoice Validation time. Validated against AP_AWT_GROUPS.NAME. | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. | |
| 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. | |
| 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. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| 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 | |
| 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 | |
| STATUS | VARCHAR2 | (25) | Status of the data in or after the Payables Open Interface Import. This column is for internal use only. If Payables Open Interface program successfully imports Invoice it will set the value of the column to 'PROCESSED', if it rejects the invoice the value will be 'REJECTED'. | |
| SOURCE | VARCHAR2 | (80) | Source of the invoices. Validated against AP_LOOKUP_CODES.LOOKUP_CODE for LOOKUP_TYPE = 'SOURCE' | |
| GROUP_ID | VARCHAR2 | (80) | Unique Group Identifier for the batch.This column will be populated to group for processing large number of records in a batch. | |
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| 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 | ||
| PAYMENT_CROSS_RATE | NUMBER | Exchange rate between invoice and payment. The value is always 1 unless they are associated fixed-rate currencies such as euro ro another EMU currency | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Cross currency payment currency. Validated against FND_CURRENCIES.CURRENCY_CODE | |
| WORKFLOW_FLAG | VARCHAR2 | (1) | Flag that indicates if the Payables Open Interface Workflow should process the record (Y or N) | |
| DOC_CATEGORY_CODE | VARCHAR2 | (30) | Sequential numbering (voucher number) document category. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE | |
| VOUCHER_NUM | VARCHAR2 | (50) | Voucher number; validated (Sequential Numbering enabled), or non-validated (Sequential Numbering not enabled) | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Name of the payment method used to pay the supplier site. Validated against IBY_PAYMENT_METHODS_B. | |
| 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' | |
| GOODS_RECEIVED_DATE | DATE | If value for TERMS_DATE is not populated, and if Terms Date Basis Payables option is set to Goods Received, then value should be populated in this column. Payables will use this value as the terms date. | ||
| INVOICE_RECEIVED_DATE | DATE | If value for TERMS_DATE is not populated, and if your Terms Date Basis Payables option is set to Invoice Received, then value should be populated in this column. Payables will use this value as the terms date. | ||
| GL_DATE | DATE | Accounting date to default to invoice distributions | ||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for accounts payable liability account. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Default transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables). Validated against GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | (1) | Flag that indicates whether to pay invoice on a separate payment document | |
| ORG_ID | NUMBER | (15) | Unique internal identifier of the Operating Unit to which the invoice to be imported. Validated against HR_OPERATING_UNITS.ORGANIZATION_ID. Must be a valid organization. Purchase order matched invoices must use an organization consistent with the purchase order | |
| AMOUNT_APPLICABLE_TO_DISCOUNT | NUMBER | Amount of invoice applicable to a discount | ||
| PREPAY_NUM | VARCHAR2 | (50) | The invoice number of an existing, fully paid prepayment to be applied to the imported invoice | |
| PREPAY_DIST_NUM | NUMBER | (15) | No longer used | |
| PREPAY_APPLY_AMOUNT | NUMBER | The amount of prepayment that the user wants to apply to the invoice. This amount has to be positive. | ||
| PREPAY_GL_DATE | DATE | The accounting date to be used for the prepayment application. If left null, the invoices GL_DATE is used | ||
| INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2 | (1) | Prepayment included in invoice amount | |
| NO_XRATE_BASE_AMOUNT | NUMBER | Invoice amount in the functional currency. Used only when the Calculate User Exchange Rate option is enabled, and used only for foreign currency invoices when the exchange rate type is User. The system uses this value and the invoice amount to calculate the exchange rate. | ||
| VENDOR_EMAIL_ADDRESS | VARCHAR2 | (2000) | Supplier e-mail address for XML invoice rejections | |
| TERMS_DATE | DATE | Date used with payment terms to calculate scheduled payment of an invoice | ||
| REQUESTER_ID | NUMBER | (10) | Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers | |
| SHIP_TO_LOCATION | VARCHAR2 | (40) | Ship to location for purchase order matching.Used for XML invoices | |
| EXTERNAL_DOC_REF | VARCHAR2 | (240) | Internal document reference number from Accounts Receivables system. Used for XML invoices | |
| PREPAY_LINE_NUM | NUMBER | The invoice line of an existing Prepayment to be applied to the imported invoice | ||
| REQUESTER_FIRST_NAME | VARCHAR2 | (150) | The first name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If Invoice Approval Workflow is used, then rules can be defined to use requester ID to generate a hierarchical list of approvers for the line. | |
| REQUESTER_LAST_NAME | VARCHAR2 | (150) | The last name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If Invoice Approval Workflow is used, then rules can be defined to use requester ID to generate a hierarchical list of approvers for the line. | |
| APPLICATION_ID | NUMBER | (15) | Unique internal application identifier. Validated against 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 | |
| APPLY_ADVANCES_FLAG | VARCHAR2 | (1) | A value of Y indicates that applicable advances will be applied against expense reports and other invoices | |
| CALC_TAX_DURING_IMPORT_FLAG | VARCHAR2 | (1) | Indicates whether tax should be calculated or not for the imported invoice. | |
| CONTROL_AMOUNT | NUMBER | Allows user to enter total tax amount to be prorated by E-Business Tax. | ||
| ADD_TAX_TO_INV_AMT_FLAG | VARCHAR2 | (1) | Indicates whether the invoice amount should be grossed up by the calculated tax. | |
| TAX_RELATED_INVOICE_ID | NUMBER | (15) | Tax Driver: Invoice ID of related document for tax purposes. | |
| TAXATION_COUNTRY | VARCHAR2 | (30) | Replaces a GDFF: This country sets the context for other tax drivers. The value defaults to the LE country but can be overridden by the user. | |
| DOCUMENT_SUB_TYPE | VARCHAR2 | (150) | Replaces a GDFF: In certain countries, a tax or governmental authority defines and classifies document types for reporting purposes. | |
| SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 | (150) | Replaces a GDFF: In some countries such as Thailand, there is a requirement to report on a supplier issued "tax" invoice that is distinct from the regular invoice. The tax invoice is either attached to the standard Supplier Invoice (in the case of Goods); or, the supplier may issue it when he receives the payment. | |
| SUPPLIER_TAX_INVOICE_DATE | DATE | Replaces a GDFF: To satisfy reporting requirements in certain countries, the Tax Invoice Date on the supplier-issued tax invoice needs to be recorded. | ||
| SUPPLIER_TAX_EXCHANGE_RATE | NUMBER | Replaces a GDFF: The supplier exchange rate is entered in online invoices to calculate the supplier tax amount for foreign currency invoices. The gain/loss in the tax amount for foreign currency invoices is the difference between the in-house tax amount using the in-house exchange rate and the supplier tax amount using the supplier exchange rate that you enter here. A manual journal entry is posted to the General Ledger to incorporate the gain/loss. | ||
| TAX_INVOICE_RECORDING_DATE | DATE | Replaces a GDFF: To satisfy reporting requirements in certain countries, the company-specific Tax Invoice Date and Number needs to be captured. This field is used to record the date the company receives/ records the supplier-issued tax invoice and is required to comply with reporting requirements. | ||
| TAX_INVOICE_INTERNAL_SEQ | VARCHAR2 | (150) | Replaces a GDFF: To satisfy reporting requirements in certain countries, the company-issued Tax Invoice Date and Number. This field is used to record the company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. This is required to comply with reporting requirements. | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Legal Entity Identifier | |
| LEGAL_ENTITY_NAME | VARCHAR2 | (50) | Legal Entity Name | |
| REFERENCE_1 | VARCHAR2 | (30) | A reference to a record in another application | |
| REFERENCE_2 | VARCHAR2 | (30) | A reference to a record in another application | |
| OPERATING_UNIT | VARCHAR2 | (240) | Unique internal identifier of the Operating Unit to which the invoice to be imported. Validated against HR_OPERATING_UNITS.NAME. | |
| 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. Validated against IBY_PAYMENT_METHODS_B. | |
| DELIVERY_CHANNEL_CODE | VARCHAR2 | (30) | Delivery channel code | |
| 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. | |
| NET_OF_RETAINAGE_FLAG | VARCHAR2 | (1) | Flag to indicate invoice amount is net of retainage | |
| REQUESTER_EMPLOYEE_NUM | VARCHAR2 | (30) | The employee number of the employee who requested goods or services on the invoice line. | |
| CUST_REGISTRATION_CODE | VARCHAR2 | (30) | Customer legal registration code | |
| CUST_REGISTRATION_NUMBER | VARCHAR2 | (30) | Customer legal registration number | |
| PARTY_ID | NUMBER | (15) | Party Unique Id from TCA tables. Validated against HZ_PARTIES.PARTY_ID. | |
| PARTY_SITE_ID | NUMBER | (15) | Party Site Unique identifer from TCA tables. Validated against HZ_PARTY_SITES.PARTY_SITE_ID. | |
| PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 | (30) | Type of payment processing transaction or document. | |
| PAYMENT_FUNCTION | VARCHAR2 | (30) | Function or purpose of the payment.Possible values are PAYABLES_DISB, AR_CUSTOMER_REFUNDS, LOANS_PAYMENTS.Validated against FND_LOOKUP_VALUES for lookup_type IBY_PAYMENT_FUNCTIONS. | |
| PAYMENT_PRIORITY | NUMBER | (2) | Number representing payment priority of a scheduled payment (1 to 99) | |
| 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 | |
| ACCTS_PAY_CODE_CONCATENATED | VARCHAR2 | (250) | Accounting Flexfield identifier for accounts payable liability account. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID | |
| PAY_AWT_GROUP_ID | NUMBER | (15) | Withholding tax group identifier at Payment time. Validated against AP_AWT_GROUPS.AWT_GROUP_ID. | |
| PAY_AWT_GROUP_NAME | VARCHAR2 | (25) | Withholding tax group name at Payment time. Validated against AP_AWT_GROUPS.NAME. | |
| 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. Validated against PO_VENDORS.VENDOR_NAME. | |
| REMIT_TO_SUPPLIER_ID | NUMBER | (15) | Unique supplier identifier to whom invoice amount can be remitted. PO_VENDORS.VENDOR_ID. | |
| REMIT_TO_SUPPLIER_SITE | VARCHAR2 | (240) | Name of the supplier site to whom invoice amount can be remitted. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE. | |
| REMIT_TO_SUPPLIER_SITE_ID | NUMBER | (15) | Unique supplier site identifier to whom invoice amount can be remitted. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID. | |
| 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. | |
| REMIT_TO_SUPPLIER_NUM | VARCHAR2 | (30) | Supplier number to whom invoice amount can be remitted |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, INVOICE_NUM
, INVOICE_TYPE_LOOKUP_CODE
, INVOICE_DATE
, PO_NUMBER
, VENDOR_ID
, VENDOR_NUM
, VENDOR_NAME
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, INVOICE_AMOUNT
, INVOICE_CURRENCY_CODE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, TERMS_ID
, TERMS_NAME
, DESCRIPTION
, AWT_GROUP_ID
, AWT_GROUP_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, 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
, STATUS
, SOURCE
, GROUP_ID
, REQUEST_ID
, PAYMENT_CROSS_RATE_TYPE
, PAYMENT_CROSS_RATE_DATE
, PAYMENT_CROSS_RATE
, PAYMENT_CURRENCY_CODE
, WORKFLOW_FLAG
, DOC_CATEGORY_CODE
, VOUCHER_NUM
, PAYMENT_METHOD_LOOKUP_CODE
, PAY_GROUP_LOOKUP_CODE
, GOODS_RECEIVED_DATE
, INVOICE_RECEIVED_DATE
, GL_DATE
, ACCTS_PAY_CODE_COMBINATION_ID
, USSGL_TRANSACTION_CODE
, EXCLUSIVE_PAYMENT_FLAG
, ORG_ID
, AMOUNT_APPLICABLE_TO_DISCOUNT
, PREPAY_NUM
, PREPAY_DIST_NUM
, PREPAY_APPLY_AMOUNT
, PREPAY_GL_DATE
, INVOICE_INCLUDES_PREPAY_FLAG
, NO_XRATE_BASE_AMOUNT
, VENDOR_EMAIL_ADDRESS
, TERMS_DATE
, REQUESTER_ID
, SHIP_TO_LOCATION
, EXTERNAL_DOC_REF
, PREPAY_LINE_NUM
, REQUESTER_FIRST_NAME
, REQUESTER_LAST_NAME
, APPLICATION_ID
, PRODUCT_TABLE
, REFERENCE_KEY1
, REFERENCE_KEY2
, REFERENCE_KEY3
, REFERENCE_KEY4
, REFERENCE_KEY5
, APPLY_ADVANCES_FLAG
, CALC_TAX_DURING_IMPORT_FLAG
, CONTROL_AMOUNT
, ADD_TAX_TO_INV_AMT_FLAG
, TAX_RELATED_INVOICE_ID
, 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
, LEGAL_ENTITY_NAME
, REFERENCE_1
, REFERENCE_2
, OPERATING_UNIT
, 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
, PAID_ON_BEHALF_EMPLOYEE_ID
, NET_OF_RETAINAGE_FLAG
, REQUESTER_EMPLOYEE_NUM
, CUST_REGISTRATION_CODE
, CUST_REGISTRATION_NUMBER
, PARTY_ID
, PARTY_SITE_ID
, PAY_PROC_TRXN_TYPE_CODE
, PAYMENT_FUNCTION
, PAYMENT_PRIORITY
, PORT_OF_ENTRY_CODE
, EXTERNAL_BANK_ACCOUNT_ID
, ACCTS_PAY_CODE_CONCATENATED
, PAY_AWT_GROUP_ID
, PAY_AWT_GROUP_NAME
, ORIGINAL_INVOICE_AMOUNT
, DISPUTE_REASON
, REMIT_TO_SUPPLIER_NAME
, REMIT_TO_SUPPLIER_ID
, REMIT_TO_SUPPLIER_SITE
, REMIT_TO_SUPPLIER_SITE_ID
, RELATIONSHIP_ID
, REMIT_TO_SUPPLIER_NUM
FROM AP.AP_INVOICES_INTERFACE;
AP.AP_INVOICES_INTERFACE does not reference any database object
AP.AP_INVOICES_INTERFACE is referenced by following:
APPS
AP_INVOICES_INTERFACE
|
|
|
|