[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 |
AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import. Invoice data comes from sources including: EDI invoices from your suppliers that you load through Oracle e-Commerce Gateway, supplier invoices that you transfer through the Oracle XML Gateway, invoices that you load using Oracle SQL*Loader, lease invoices from Oracle Property Manager, lease payments from Oracle Assets, credit card transaction data that you load using the Credit Card Invoice Interface Summary, and invoices that you enter through the Invoice Gateway. There is one row for each invoice you import. Your Oracle Payables application uses this information to create invoice header information when you submit the Payables Open Interface program.
.
AP_INVOICES_INTERFACE contains a unique invoice ID which is used to interface with AP_INVOICES_ALL.
Please refer to the appendix of the Oracle Payables User Guide or online help for more detailed information on Open Interface table columns, including import validation and destination columns.
This is the open interface table for AP Invoices.
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 | Invoice identifier |
| INVOICE_NUM | VARCHAR2 | (50) | Invoice number | |
| INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Type of Invoice (can be STANDARD or CREDIT) | |
| INVOICE_DATE | DATE | Invoice date | ||
| PO_NUMBER | VARCHAR2 | (20) | Purchase order number | |
| VENDOR_ID | NUMBER | (15) | Supplier identifier. Validated against PO_VENDORS.VENDOR_ID | |
| VENDOR_NUM | VARCHAR2 | (30) | Supplier number | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
| VENDOR_SITE_ID | NUMBER | (15) | Supplier site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID | |
| VENDOR_SITE_CODE | VARCHAR2 | (15) | Supplier site code | |
| INVOICE_AMOUNT | NUMBER | Invoice amount | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Currency of invoice. Validated against FND_CURRENCIES.CURRENCY_CODE | |
| EXCHANGE_RATE | NUMBER | Exchange rate for foreign currency invoices | ||
| 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 name | |
| DESCRIPTION | VARCHAR2 | (240) | Invoice description | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding tax group identifier. Validated against AP_AWT_GROUPS.AWT_GROUP_ID | |
| AWT_GROUP_NAME | VARCHAR2 | (25) | Withholding tax group name | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| 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). | |
| 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). | |
| 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 | |
| SOURCE | VARCHAR2 | (80) | Source of the invoices | |
| GROUP_ID | VARCHAR2 | (80) | Group identifier | |
| 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 (must be EMU Fixed in Release 11) | |
| PAYMENT_CROSS_RATE_DATE | DATE | Cross currency payment rate date | ||
| PAYMENT_CROSS_RATE | NUMBER | Exchange rate between invoice and payment; in Release 11 the value is always 1 unless they are associated fixed-rate currencies | ||
| 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 payment method | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Name of pay group | |
| GOODS_RECEIVED_DATE | DATE | Date invoice items received | ||
| INVOICE_RECEIVED_DATE | DATE | Date invoice received | ||
| 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) | Organization identifier | |
| 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 you use Invoice Approval Workflow then you can define rules that use the 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 you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers 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 | |
| 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) | Organization 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) | Payment method identifier | |
| 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 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 | |
| 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) | External bank account identifier | |
| 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) | Used for payment withhholding tax group name | |
| 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) | Site code 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 | |
| REMIT_TO_SUPPLIER_NUM | VARCHAR2 | (30) | Number of the third party payee |
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:
AP
AP_INVOICES_INTERFACE#
|
|
|
|