[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 |
AP_INVOICE_LINES_INTERFACE stores information
used to create one or more invoice distributions. Note
that one row in this table may create, during the import
process, more than one invoice distribution. For
example, if you enter a Tax line in this table and prorate
it 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 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 lines interface table for the AP Invoice Open
Interface. Use it in conjunction with AP_INVOICE_INTERFACE table.
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) | Invoice line identifier | |
| LINE_NUMBER | NUMBER | (15) | Invoice line number | |
| 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 | (30) | Tax code. Validated against AP_TAX_CODES_ALL.NAME | |
| 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) | Ship to location code | |
| UNIT_PRICE | NUMBER | Unit price for purchase order matched invoice items | ||
| 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. Validated against AP_AWT_GROUPS.GROUP_ID | |
| AWT_GROUP_NAME | VARCHAR2 | (25) | Withholding tax group name | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| 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 FND_LOGINS.LOGIN_ID). | |
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| 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) | 1099 type | |
| 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) | Flag that indicates if distribution line is tracked in Oracle Assets (Y or N) | |
| PRICE_CORRECTION_FLAG | VARCHAR2 | (1) | Flag that indicates if line produces price correction | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| 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) | Packing slip identifier | |
| 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 AP_TAX_CODES_ALL.TAX_ID | |
| CREDIT_CARD_TRX_ID | NUMBER | (15) | Credit card transaction ID if the line is a credit card charge | |
| AWARD_ID | NUMBER | (15) | Grants requirement to store award | |
| VENDOR_ITEM_NUM | VARCHAR2 | (25) | Optional. Validated against PO_LINES_ALL.VENDOR_PRODUCT_NUM | |
| TAXABLE_FLAG | VARCHAR2 | (1) | A value of Y indicates that the line is taxable | |
| 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 you use Invoice Approval Workflow then you can define rules that use therequester 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 therequester 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. If you use Invoice Approval Workflow then you can define rules that use therequester 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 | |
| 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. | |
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | (240) | Tax Driver: Product fiscal classification | |
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (240) | Tax Driver: Fiscal Classification. | |
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | Tax Driver: Transactions category assigned by user. | |
| 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 Code | |
| 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_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) | This field contains Withholding tax id which will be applied during the payment time | |
| PAY_AWT_GROUP_NAME | VARCHAR2 | (25) | Used for payment withhholding tax group name | |
| EXPENSE_START_DATE | DATE | Start Expense Date | ||
| EXPENSE_END_DATE | DATE | End Expense Date | ||
| MERCHANT_NAME#1 | VARCHAR2 | (240) | Merchant Details for Credit Card and Expense transactions. |
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_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
, EXPENSE_START_DATE
, EXPENSE_END_DATE
, MERCHANT_NAME#1
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:
AP
AP_INVOICE_LINES_INTERFACE#
|
|
|
|