[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_INVOICE_LINES_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_INVOICE_LINES_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
This is the lines interface table for the AP Invoice Open Interface. Used in conjunction with AP_INVOICES_INTERFACE table to import Invoices from external sources.
Data in this table is used to create one or more records in AP_INVOICE_LINES _ALL and AP_INVOICE_DISTRIBUTIONS _ALL using Payables open interface import. Data in this interface table can be viewed thru Payables Open Interface window.
For example, if a Tax line is inserted in this table and this line is prorated across multiple Item lines, during Open Interface Import the system may create multiple Tax invoice distributions based on the single Tax line in this table.
Please refer to the Oracle Payables Reference Guide for more detailed information on Open Interface table columns, including import validation and destination columns.
The accounting code combinations used in this table is meta data for creating accounting entries in Subledger Accounting. Payables provides the code combinations used 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 used in this table or stored in AP_INVOICE_DISTRIBUTIONS_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.
Table Description
Scope: public
Lifecycle: active
Display Name: AP Invoice Lines Interface
Product: AP
Category: BUSINESS_ENTITY AP_INVOICE
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_INVOICE_LINES_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INVOICE_LINE_ID
|
| AP_INVOICE_LINES_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INVOICE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier. Validated against AP_INVOICES_INTERFACE.INVOICE_ID |
| INVOICE_LINE_ID | NUMBER | (15) | Unique identifier for a invoice line. | |
| LINE_NUMBER | NUMBER | (15) | Unique line number for an Invoice. | |
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Type of invoice line (Item, Freight, Tax, Miscellaneous) | |
| LINE_GROUP_NUMBER | NUMBER | Value to identify each item line to which you want to prorate | ||
| AMOUNT | NUMBER | Line amount | ||
| ACCOUNTING_DATE | DATE | Accounting date | ||
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | No Longer Used | |
| PRORATE_ACROSS_FLAG | VARCHAR2 | (1) | Prorate indicator for this line to be prorated across all lines with the same LINE_GROUP_NUMBER | |
| TAX_CODE | VARCHAR2 | (15) | Tax code. Validated against ZX_TAXES_B. | |
| FINAL_MATCH_FLAG | VARCHAR2 | (1) | Final match indicator for distribution line matched to purchase order | |
| PO_HEADER_ID | NUMBER | Purchase order header identifier used for PO matching. Validated against PO_HEADERS_ALL.PO_HEADER_ID | ||
| PO_NUMBER | VARCHAR2 | (20) | Purchase order number used for PO matching. Validated against PO_HEADERS_ALL.SEGMENT1 | |
| PO_LINE_ID | NUMBER | Purchase order line identifier used for PO matching. Validated against PO_LINES_ALL.PO_LINE_ID | ||
| PO_LINE_NUMBER | NUMBER | Purchase order line number used for PO matching. Validated against PO_LINES_ALL.PO_LINE_NUM | ||
| PO_LINE_LOCATION_ID | NUMBER | Purchase order line location identifier used for PO matching. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID | ||
| PO_SHIPMENT_NUM | NUMBER | Purchase order shipment number used for PO matching. Validated against PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM | ||
| PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution line identifier used for PO matching. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID | ||
| PO_DISTRIBUTION_NUM | NUMBER | Purchase order distribution line number used for PO matching. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_NUM | ||
| PO_UNIT_OF_MEASURE | VARCHAR2 | (25) | No longer used | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier. Validated against MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory item description | |
| QUANTITY_INVOICED | NUMBER | Quantity invoiced against purchase order shipment | ||
| SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | During matching to purchase order shipment if value for either PO_SHIPMENT_NUM or PO_LINE_LOCATION_ID then value to SHIP_TO_LOCATION_CODE can be entered. Validated against PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID. | |
| UNIT_PRICE | NUMBER | Unit Price of the distribution line item(s). Used for purchase order matching. If UNIT_PRICE is entered and QUANTITY_INVOICE is not entered, then system will derive a value for QUANTITY_INVOICED during Payables Open Interface Import (QUANTITY_INVOICED = AMOUNT/ UNIT_PRICE). | ||
| DISTRIBUTION_SET_ID | NUMBER | (15) | Distribution set identifier. Validated against AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID | |
| DISTRIBUTION_SET_NAME | VARCHAR2 | (50) | Distribution set name. Validated against AP_INVOICE_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_NAME | |
| DIST_CODE_CONCATENATED | VARCHAR2 | (250) | Accounting flexfield for account associated with a distribution line | |
| DIST_CODE_COMBINATION_ID | NUMBER | (15) | Accounting flexfield identifier for account associated with a distribution line. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding tax group identifier at Invoice Validation time. Validated against AP_AWT_GROUPS.GROUP_ID | |
| AWT_GROUP_NAME | VARCHAR2 | (25) | Withholding tax group name at Invoice Validation time. Validated against AP_AWT_GROUPS.NAME. | |
| 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_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| 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. | |
| 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. | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| 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 localizations | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific localizations | |
| PO_RELEASE_ID | NUMBER | Blanket purchase order release identifier used for PO matching. Validated against PO_RELEASES_ALL.PO_RELEASE_ID | ||
| RELEASE_NUM | NUMBER | Blanket purchase order release number used for PO matching. Validated against PO_RELEASES_ALL.RELEASE_NUM | ||
| ACCOUNT_SEGMENT | VARCHAR2 | (25) | Value for account segment of accounting flexfield. Payables will overlay this value on the accounting flexfield during import | |
| BALANCING_SEGMENT | VARCHAR2 | (25) | Value for balancing segment of accounting flexfield. Payables will overlay this value on the accounting flexfield during import | |
| COST_CENTER_SEGMENT | VARCHAR2 | (25) | Value for cost center segment of accounting flexfield. Payables will overlay this value on the accounting flexfield during import | |
| PROJECT_ID | NUMBER | (15) | Identifier for project used to build default accounting flexfield. Validated against PA_PROJECTS_ALL.PROJECT_ID | |
| TASK_ID | NUMBER | (15) | Identifier for project task used to build default accounting flexfield. Validated against PA_TASKS.TASK_ID | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Project expenditure type used to build default accounting flexfield. Validated against PA_EXPENDITURE_TYPES.EXPENDITURE_TYPE | |
| EXPENDITURE_ITEM_DATE | DATE | Project expenditure item date used to build default accounting flexfield | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Identifier for project organization used to build default accounting flexfield. Validated against PA_EXP_ORGS_IT.ORGANIZATION_ID | |
| PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | No longer used | |
| PA_ADDITION_FLAG | VARCHAR2 | (1) | Flag that indicates if project related invoice distributions have been transferred into Oracle Projects (Y or N) | |
| PA_QUANTITY | NUMBER | (22) | Project item quantity used to build accounting flexfield for project-related distribution line | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables). Validated against GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE | |
| STAT_AMOUNT | NUMBER | Amount associated with a distribution line for measuring statistical quantities | ||
| TYPE_1099 | VARCHAR2 | (10) | Income Tax type for 1099 reporting purposes. The value must be a valid and active value in the AP_INCOME_TAX_TYPES table (MISC types 1-14, except MISC9, MISC11 and MISC12), and the supplier for this record must be defined as federally reportable. | |
| INCOME_TAX_REGION | VARCHAR2 | (10) | Reporting region for distribution line for 1099 supplier. Validated against AP_INCOME_TAX_REGIONS.REGION_SHORT_NAME | |
| ASSETS_TRACKING_FLAG | VARCHAR2 | (1) | Value should be populated as 'Y' if the invoice distribution should be imported into Oracle Assets using the Create Mass Additions for Assets program. If value is null for this column and the line has an Asset type account populated for it, then Payables will automatically set this value to 'Y' during import. | |
| PRICE_CORRECTION_FLAG | VARCHAR2 | (1) | This flag is used for price correction when a supplier sends an invoice for a change in unit price for an invoice that has been matched to a purchase order. To make this invoice as a price correction, this flag needs to be set as 'Y' for a Standard or Credit invoice and need to populate the base-matched invoice in the PRICE_CORRECT_INV_NUM column. | |
| ORG_ID | NUMBER | (15) | Unique internal identifier of the Operating Unit to which the invoice belongs | |
| RECEIPT_NUMBER | VARCHAR2 | (30) | The receipt number to which an invoice will be matched. Validated against RCV_SHIPMENT_HEADERS.RECEIPT_NUM | |
| RECEIPT_LINE_NUMBER | VARCHAR2 | (25) | The receipt line number to which an invoice will be matched. Validated against RCV_SHIPMENT_LINES.LINE_NUM | |
| MATCH_OPTION | VARCHAR2 | (25) | The value of the Invoice Match option on the PO shipment | |
| PACKING_SLIP | VARCHAR2 | (25) | No Longer used | |
| RCV_TRANSACTION_ID | NUMBER | Receipt identifier used for Receipt matching. Validated against RCV_TRANSACTIONS.TRANSACTION_ID | ||
| PA_CC_AR_INVOICE_ID | NUMBER | (15) | Identifier of the corresponding receivable intercompnay invoice in Oracle Receivables | |
| PA_CC_AR_INVOICE_LINE_NUM | NUMBER | (15) | Line number of the corresponding receivable intercomany invoice in Oracle Receivables | |
| REFERENCE_1 | VARCHAR2 | (30) | A reference to a record in another application | |
| REFERENCE_2 | VARCHAR2 | (30) | A reference to a record in another application | |
| PA_CC_PROCESSED_CODE | VARCHAR2 | (1) | Indicates the processing status of this invoice line by Oracle Projects in the Receiver Operating Unit | |
| TAX_RECOVERY_RATE | NUMBER | No Longer Used | ||
| TAX_RECOVERY_OVERRIDE_FLAG | VARCHAR2 | (1) | No Longer Used | |
| TAX_RECOVERABLE_FLAG | VARCHAR2 | (1) | No Longer Used | |
| TAX_CODE_OVERRIDE_FLAG | VARCHAR2 | (1) | No Longer Used | |
| TAX_CODE_ID | NUMBER | (15) | Tax code identifier for the tax code to be used. Validated against ZX_TAXES_B. | |
| CREDIT_CARD_TRX_ID | NUMBER | (15) | Identifies the credit card transaction from which the expense line is derived. This column is populated when credit card transactions for expense reports entered in Oracle Internet Expenses are exported. | |
| AWARD_ID | NUMBER | (15) | Grants requirement to store award | |
| VENDOR_ITEM_NUM | VARCHAR2 | (25) | Supplier item number on the purchase order. Used during purchase order matching. If you have limited purchase order information, you can enter a supplier item number in the column and the system will attempt to match the invoice to a purchase order line. Validated against PO_LINES_ALL.VENDOR_PRODUCT_NUM | |
| TAXABLE_FLAG | VARCHAR2 | (1) | Not used in R12 | |
| PRICE_CORRECT_INV_NUM | VARCHAR2 | (50) | Number of the invoice that this price correction invoice is correcting. Validated against AP_INVOICES_ALL.INVOICE_NUM. | |
| EXTERNAL_DOC_LINE_REF | VARCHAR2 | (240) | Internal document reference number from Accounts Receivables system. Used for XML invoices | |
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial number for item | |
| MANUFACTURER | VARCHAR2 | (30) | Name of the manufacturer | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model information | |
| WARRANTY_NUMBER | VARCHAR2 | (15) | Warranty number | |
| DEFERRED_ACCTG_FLAG | VARCHAR2 | (1) | Flag that indicates whether to generate deferred accounting for this line | |
| DEF_ACCTG_START_DATE | DATE | The start date of the deferred expense period | ||
| DEF_ACCTG_END_DATE | DATE | The end date of the deferred expense period | ||
| DEF_ACCTG_NUMBER_OF_PERIODS | NUMBER | Number of periods to generate deferred expenses. Used in combination with PERIOD_TYPE. Alternative to END_DATE | ||
| DEF_ACCTG_PERIOD_TYPE | VARCHAR2 | (15) | Period type used in combination with NUMBER_OF_PERIODS to generate deferred expenses. Validated against XLA_LOOKUPS with lookup type XLA_DEFERRED_PERIOD_TYPE | |
| UNIT_OF_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of Measure for quantity invoiced. Validated against MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE | |
| PRICE_CORRECT_INV_LINE_NUM | NUMBER | Invoice line subject to the price correction | ||
| ASSET_BOOK_TYPE_CODE | VARCHAR2 | (15) | Asset Book Defaults to the distributions candidate for transfer to Oracle Assets | |
| ASSET_CATEGORY_ID | NUMBER | (15) | Asset Category Defaults to the distributions candidate for transfer to Oracle Assets | |
| REQUESTER_ID | NUMBER | (15) | Requester identifier. Valid values from active HR employees. Validated against PER_ALL_PEOPLE_F.PERSON_ID | |
| 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. | |
| REQUESTER_EMPLOYEE_NUM | VARCHAR2 | (30) | The employee number of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. | |
| 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 | |
| PURCHASING_CATEGORY | VARCHAR2 | (2000) | Item category concatenated segments | |
| PURCHASING_CATEGORY_ID | NUMBER | (15) | Item category unique identifier | |
| COST_FACTOR_ID | NUMBER | (15) | Identifier of the cost component class. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on. | |
| COST_FACTOR_NAME | VARCHAR2 | (80) | Cost component class name. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on. | |
| CONTROL_AMOUNT | NUMBER | Optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document. | ||
| ASSESSABLE_VALUE | NUMBER | User-enterable amount to be used as taxable basis | ||
| DEFAULT_DIST_CCID | NUMBER | (15) | Already addressed by lines projectTax Driver: Code combination identifier of the GL account associated with the transaction line. Note that this is necessary to support the Account Method VAT feature. | |
| PRIMARY_INTENDED_USE | VARCHAR2 | (30) | Tax Driver: The purpose for which a product may be used. The actual use will be stored at the distribution level. | |
| SHIP_TO_LOCATION_ID | NUMBER | (15) | Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched. | |
| PRODUCT_TYPE | VARCHAR2 | (240) | Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user. | |
| PRODUCT_CATEGORY | VARCHAR2 | (240) | Tax Driver: Product Category identifies the taxable nature of a non-Inventory based item for tax determination or tax reporting purposes. | |
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | (240) | Tax Driver: Product Fiscal Classification identifies the taxable nature of an Inventory item for tax determination or tax reporting purposes. | |
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (240) | Tax Driver: User Defined Fiscal Classification used to to classify any tax requirement that you cannot define using the seeded fiscal classification types. | |
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Tax Driver: Transaction category assigned. Transaction business category used to identify and classify your business transactions for tax calculation purpose. | |
| TAX_REGIME_CODE | VARCHAR2 | (30) | Tax Regime Code: The set of tax rules that determines the treatment of one or more taxes administered by a tax authority. e.g., VAT Regime in Argentina. | |
| TAX | VARCHAR2 | (30) | A classification of a charge imposed by a government through a fiscal or tax authority. | |
| TAX_JURISDICTION_CODE | VARCHAR2 | (30) | Internal ID of the Tax Jurisdiction. | |
| TAX_STATUS_CODE | VARCHAR2 | (30) | Tax status code. e.g., taxable standard rate, zero rated, exempt, non-taxable. | |
| TAX_RATE_ID | NUMBER | (15) | Internal identifier for tax rate effective on the invoice date. | |
| TAX_RATE_CODE | VARCHAR2 | (150) | Tax rate name associated with tax rate identifier. Tax_rate_id is unique while a tax_rate_code may have different tax rates based on date ranges. | |
| TAX_RATE | NUMBER | The rate specified for a tax status in effect for a period of time. | ||
| INCL_IN_TAXABLE_LINE_FLAG | VARCHAR2 | (1) | Flag to indicate if the amount in the tax line is included or not in the taxable line. | |
| SOURCE_APPLICATION_ID | NUMBER | Source document application identifier | ||
| SOURCE_ENTITY_CODE | VARCHAR2 | (30) | Source document entity code | |
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | (30) | Source document event class code | |
| SOURCE_TRX_ID | NUMBER | Source document transaction identifier | ||
| SOURCE_LINE_ID | NUMBER | Identifier of the lowest level for which Tax is calculated | ||
| SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | (30) | Source document transaction level type | |
| TAX_CLASSIFICATION_CODE | VARCHAR2 | (30) | Tax classification codes used by Payables for calculating the Taxes also called Standard Tax Classification Code (STCC) approach to tax determination. These are the codes that E-Business Tax migrates from 11i including tax codes within a tax group as �Input Tax classification codes�. Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'ZX_INPUT_CLASSIFICATIONS'. | |
| CC_REVERSAL_FLAG | VARCHAR2 | (1) | Indicates reversal flag that marks if this line is a Credit Card reversal | |
| COMPANY_PREPAID_INVOICE_ID | NUMBER | (15) | Invoice ID when this line is a prepaid credit card transaction | |
| EXPENSE_GROUP | VARCHAR2 | (80) | Expense group: User-defined label used to identify a group of expense lines contained on a single receipt, for example, a hotel bill | |
| JUSTIFICATION | VARCHAR2 | (240) | Expense justification given while submitting expense report | |
| MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | (80) | Merchant Details for Credit Card and Expense transactions. | |
| MERCHANT_NAME | VARCHAR2 | (80) | Merchant Details for Credit Card and Expense transactions. | |
| MERCHANT_REFERENCE | VARCHAR2 | (240) | Merchant Details for Credit Card and Expense transactions. | |
| MERCHANT_TAX_REG_NUMBER | VARCHAR2 | (80) | Merchant Details for Credit Card and Expense transactions. | |
| MERCHANT_TAXPAYER_ID | VARCHAR2 | (80) | Merchant Details for Credit Card and Expense transactions. | |
| RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of receipt. Used for expense reports | |
| RECEIPT_CONVERSION_RATE | NUMBER | Exchange rate for currency of receipt. Used for expense reports | ||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | Amount in receipt currency. Used for expense reports | ||
| COUNTRY_OF_SUPPLY | VARCHAR2 | (5) | Country where services or goods were originated. Used for expense reports | |
| 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. |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, INVOICE_LINE_ID
, LINE_NUMBER
, LINE_TYPE_LOOKUP_CODE
, LINE_GROUP_NUMBER
, AMOUNT
, ACCOUNTING_DATE
, DESCRIPTION
, AMOUNT_INCLUDES_TAX_FLAG
, PRORATE_ACROSS_FLAG
, TAX_CODE
, FINAL_MATCH_FLAG
, PO_HEADER_ID
, PO_NUMBER
, PO_LINE_ID
, PO_LINE_NUMBER
, PO_LINE_LOCATION_ID
, PO_SHIPMENT_NUM
, PO_DISTRIBUTION_ID
, PO_DISTRIBUTION_NUM
, PO_UNIT_OF_MEASURE
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, QUANTITY_INVOICED
, SHIP_TO_LOCATION_CODE
, UNIT_PRICE
, DISTRIBUTION_SET_ID
, DISTRIBUTION_SET_NAME
, DIST_CODE_CONCATENATED
, DIST_CODE_COMBINATION_ID
, AWT_GROUP_ID
, AWT_GROUP_NAME
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, 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
, PO_RELEASE_ID
, RELEASE_NUM
, ACCOUNT_SEGMENT
, BALANCING_SEGMENT
, COST_CENTER_SEGMENT
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID
, PROJECT_ACCOUNTING_CONTEXT
, PA_ADDITION_FLAG
, PA_QUANTITY
, USSGL_TRANSACTION_CODE
, STAT_AMOUNT
, TYPE_1099
, INCOME_TAX_REGION
, ASSETS_TRACKING_FLAG
, PRICE_CORRECTION_FLAG
, ORG_ID
, RECEIPT_NUMBER
, RECEIPT_LINE_NUMBER
, MATCH_OPTION
, PACKING_SLIP
, RCV_TRANSACTION_ID
, PA_CC_AR_INVOICE_ID
, PA_CC_AR_INVOICE_LINE_NUM
, REFERENCE_1
, REFERENCE_2
, PA_CC_PROCESSED_CODE
, TAX_RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG
, TAX_RECOVERABLE_FLAG
, TAX_CODE_OVERRIDE_FLAG
, TAX_CODE_ID
, CREDIT_CARD_TRX_ID
, AWARD_ID
, VENDOR_ITEM_NUM
, TAXABLE_FLAG
, PRICE_CORRECT_INV_NUM
, EXTERNAL_DOC_LINE_REF
, SERIAL_NUMBER
, MANUFACTURER
, MODEL_NUMBER
, WARRANTY_NUMBER
, DEFERRED_ACCTG_FLAG
, DEF_ACCTG_START_DATE
, DEF_ACCTG_END_DATE
, DEF_ACCTG_NUMBER_OF_PERIODS
, DEF_ACCTG_PERIOD_TYPE
, UNIT_OF_MEAS_LOOKUP_CODE
, PRICE_CORRECT_INV_LINE_NUM
, ASSET_BOOK_TYPE_CODE
, ASSET_CATEGORY_ID
, REQUESTER_ID
, REQUESTER_FIRST_NAME
, REQUESTER_LAST_NAME
, REQUESTER_EMPLOYEE_NUM
, APPLICATION_ID
, PRODUCT_TABLE
, REFERENCE_KEY1
, REFERENCE_KEY2
, REFERENCE_KEY3
, REFERENCE_KEY4
, REFERENCE_KEY5
, PURCHASING_CATEGORY
, PURCHASING_CATEGORY_ID
, COST_FACTOR_ID
, COST_FACTOR_NAME
, CONTROL_AMOUNT
, ASSESSABLE_VALUE
, DEFAULT_DIST_CCID
, PRIMARY_INTENDED_USE
, SHIP_TO_LOCATION_ID
, PRODUCT_TYPE
, PRODUCT_CATEGORY
, PRODUCT_FISC_CLASSIFICATION
, USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY
, TAX_REGIME_CODE
, TAX
, TAX_JURISDICTION_CODE
, TAX_STATUS_CODE
, TAX_RATE_ID
, TAX_RATE_CODE
, TAX_RATE
, INCL_IN_TAXABLE_LINE_FLAG
, SOURCE_APPLICATION_ID
, SOURCE_ENTITY_CODE
, SOURCE_EVENT_CLASS_CODE
, SOURCE_TRX_ID
, SOURCE_LINE_ID
, SOURCE_TRX_LEVEL_TYPE
, TAX_CLASSIFICATION_CODE
, CC_REVERSAL_FLAG
, COMPANY_PREPAID_INVOICE_ID
, EXPENSE_GROUP
, JUSTIFICATION
, MERCHANT_DOCUMENT_NUMBER
, MERCHANT_NAME
, MERCHANT_REFERENCE
, MERCHANT_TAX_REG_NUMBER
, MERCHANT_TAXPAYER_ID
, RECEIPT_CURRENCY_CODE
, RECEIPT_CONVERSION_RATE
, RECEIPT_CURRENCY_AMOUNT
, COUNTRY_OF_SUPPLY
, PAY_AWT_GROUP_ID
, PAY_AWT_GROUP_NAME
FROM AP.AP_INVOICE_LINES_INTERFACE;
AP.AP_INVOICE_LINES_INTERFACE does not reference any database object
AP.AP_INVOICE_LINES_INTERFACE is referenced by following:
APPS
AP_INVOICE_LINES_INTERFACE
|
|
|
|