DBA Data[Home] [Help] [Dependency Information]


TABLE: AP.AP_INVOICE_LINES_ALL

Object Details
Object Name: AP_INVOICE_LINES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_INVOICE_LINES_ALL
Subobject Name:
Status: VALID


This table holds invoice lines records entered manually, generated automatically or imported from the Open Interface tables. This table corresponds to the Invoice Lines tab of Invoice workbench.
AP_INVOICE_LINES_ALL holds invoice lines records entered manually, generated automatically or imported from the Open Interface tables. An invoice can have one or more invoice lines and an invoice line can have one or more invoice distributions. An invoice line represents goods (direct or indirect materials), service(s), and/or associated tax/freight/miscellaneous charges invoiced from a supplier. An invoice line contains all the attributes that are present on the physical or electronic invoice presented by the supplier. These attributes suffice in specifying the charge/expense/asset information that makes up the invoice line. An invoice line can be of any of the following types:
� Item
� Freight
� Miscellaneous
� Tax
� Prepayment
� Withholding Tax
� Retainage Release
� Invoice Price Variance
� Exchange Price Variance
� Tax Rate Variance
� Tax Exchange Rate Variance
Etc.,
Prepayment Lines are generated via prepayment application. Item type lines may represent a match to a purchase order or receipt, a price correction against an existing purchase order or receipt matched invoice line, a quantity correction against an existing purchase order or receipt matched invoice line, an invoice correction against an existing non-matched invoice line or a non-matched invoice line. Freight and Miscellaneous lines may represent a match to a Receipt or may be non-matched.
Freight and Miscellaneous type lines may be allocated to Item type lines whenever they are not themselves matched to a receipt. Rules for allocation may be entered in the Allocations module. Allocations are stamped on the distributions for such a Freight or Miscellaneous type line.

Lines may be generated automatically via any of the following methods:
� Match to purchase order or receipt requested from the invoice header
� Generation of Freight/Miscellaneous from purchase order or receipt matching windows
� Prepayment application
� Tax lines from E-Business Tax based on Tax drivers
� Withholding Tax based on Withholding tax code on Invoice header
Lines will also be created during import of Open Interface invoices.
It is the distributions for a line, and not the line itself, that will carry the status relative to Validation, Encumbrance, and Accounting. Furthermore, it is the Distributions for a line that get transferred to Oracle Assets and/or processed by Oracle Projects. However, lines will contain an Approval status.
A line may be discarded on its own or as part of cancellation of the invoice. A discarded line will have an amount of 0 and will be marked as discarded. During discarding of a line, appropriate distributions are generated to reverse the effect of any existing distributions for the line.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_INVOICE_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
ColumnLINE_NUMBER
AP_INVOICE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCOUNTING_DATE
AP_INVOICE_LINES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_SELECTED_FOR_APPL_FLAG
AP_INVOICE_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRCV_TRANSACTION_ID
AP_INVOICE_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_LOCATION_ID
AP_INVOICE_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnTASK_ID
AP_INVOICE_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAWARD_ID
AP_INVOICE_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORRECTED_INV_ID
AP_INVOICE_LINES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREPAY_INVOICE_ID
ColumnPREPAY_LINE_NUMBER
AP_INVOICE_LINES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes Unique internal identifier for the invoice line of the associated Invoice. Foreign key to the AP_INVOICES_ALL table.
LINE_NUMBER NUMBER
Yes Invoice line number
LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Type of invoice line.Possible values for this column are derived from FND_LOOKUP_VALUES for lookup_type 'INVOICE LINE TYPE'.
REQUESTER_ID NUMBER (15)
Requester of goods or services on invoice line. Used by Invoice Workflow Approval process to generate list of approvers. Valid values from active HR employees. Validated against PER_ALL_PEOPLE_F.PERSON_ID.
DESCRIPTION VARCHAR2 (240)
Invoice line description
LINE_SOURCE VARCHAR2 (30)
Source of the invoice line. Validated against AP_LOOKUP_CODES.LOOKUP_CODE for LOOKUP_TYPE LINE SOURCE
ORG_ID NUMBER (15)
Unique internal identifier of the Operating Unit to which the invoice belongs.
LINE_GROUP_NUMBER NUMBER

Group number assigned to the line during the Open Interface Import process to be used for generation of allocation rules
INVENTORY_ITEM_ID NUMBER

Inventory item identifier. Validated against MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
SERIAL_NUMBER VARCHAR2 (35)
Serial number for item
MANUFACTURER VARCHAR2 (30)
Name of manufacturer
MODEL_NUMBER VARCHAR2 (40)
Model information
WARRANTY_NUMBER VARCHAR2 (15)
Warranty number
GENERATE_DISTS VARCHAR2 (1)
Flag indicating whether distributions for the invoice line should be generated dynamically whenever possible
MATCH_TYPE VARCHAR2 (25)
Indicates the type of match if any. Validated against AP_LOOKUP_CODES with lookup type as INVOICE LINE MATCH TYPE
DISTRIBUTION_SET_ID NUMBER (15)
Distribution set identifier to be used in the generation of distributions for a Invoice line. Foreign key to the DISTRIBUTION_SET_ID of AP_DISTRIBUTION_SETS_ALL table.
ACCOUNT_SEGMENT VARCHAR2 (25)
Account segment value for overlay in generation of accounting flexfield during distribution generation
BALANCING_SEGMENT VARCHAR2 (25)
Balancing segment value for overlay in generation of accounting flexfield during distribution generation
COST_CENTER_SEGMENT VARCHAR2 (25)
Cost Center segment value for overlay in generation of accounting flexfield during distribution generation
OVERLAY_DIST_CODE_CONCAT VARCHAR2 (250)
Concatenated segments for overlay in generation of accounting flexfield during distribution generation
DEFAULT_DIST_CCID NUMBER (15)
Account to be used for automatic generation of a single distribution
PRORATE_ACROSS_ALL_ITEMS VARCHAR2 (1)
A value of Y indicates that the Freight or Miscellaneous type line should be prorated across all Item type lines
ACCOUNTING_DATE DATE
Yes Accounting date for invoice line. Used for defaulting to distributions
PERIOD_NAME VARCHAR2 (15)
Accounting date for invoice line. Used for defaulting to distributions
DEFERRED_ACCTG_FLAG VARCHAR2 (1)
Flag to indicates whether to generate deferred accounting for the invoice line. This flag corresponds to the 'Deferred Option' of Invoice Lines region in Invoice Workbench.
DEF_ACCTG_START_DATE DATE

The start date of the deferred expense period. This date column correspond to 'Deferred Start Date' of Invoice Lines region in Invoice Workbench. This date default to GL Date of invoice and it should be in an open period.
DEF_ACCTG_END_DATE DATE

The end date of the deferred expense period. This date column corresponds to 'Deferred End Date' of Invoice Lines region in Invoice Workbench.
DEF_ACCTG_NUMBER_OF_PERIODS NUMBER

Number of periods to generate deferred expenses. Used in combination with PERIOD_TYPE. This column corresponds to 'Deferred Number of Periods' of Invoice Lines region of Invoice Workbench. Either DEF_ACCTG_END_DATE or DEF_ACCTG_NUMBER_OF_PERIODS is mandatory for deferred accounting.
DEF_ACCTG_PERIOD_TYPE VARCHAR2 (30)
Period type used in combination with NUMBER_OF_PERIODS to generate deferred expenses. Validated against XLA_LOOKUPS with lookup type XLA_DEFERRED_PERIOD_TYPE
SET_OF_BOOKS_ID NUMBER (15) Yes Unique identifer for Ledger
AMOUNT NUMBER
Yes Line amount in invoice currency
BASE_AMOUNT NUMBER

Line amount in functional currency. This column gets populated for the invoice entered in non-functional currency and this column corresponds to the 'Functional Amount' field of Invoice Lines region in Invoice workbench.
ROUNDING_AMT NUMBER

Amount corresponding to rounding amount included in BASE_AMOUNT if any
QUANTITY_INVOICED NUMBER

Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit of measure for QUANTITY_INVOICED. Validated against MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE
UNIT_PRICE NUMBER

Unit price
WFAPPROVAL_STATUS VARCHAR2 (30) Yes Status of invoice line in Invoice Line Approval Workflow process. Default value is NOT REQUIRED
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL Transaction Code for creating U.S. Standard General Ledger journal entries (Oracle Public Sector Payables). Validated against GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE
DISCARDED_FLAG VARCHAR2 (1)
A value of Y indicates that the line has been discarded. When a line is discarded all its distributions are reversed and the AMOUNT is set to 0
ORIGINAL_AMOUNT NUMBER

Amount of the line before discarding of the line or cancellation of the invoice
ORIGINAL_BASE_AMOUNT NUMBER

Base amount of the line before discarding of the line or cancellation of the invoice
ORIGINAL_ROUNDING_AMT NUMBER

Rounding amount of the line before discarding of the line or cancellation of the invoice
CANCELLED_FLAG VARCHAR2 (1)
A value of Y indicates that the line has been cancelled
INCOME_TAX_REGION VARCHAR2 (10)
Reporting region for invoice line for 1099 supplier. Defaults down to distributions
TYPE_1099 VARCHAR2 (10)
Income tax type, for 1099 reporting purposes. This column corresponds to 'Income Tax Type' field in Invoice Lines window. Foreign key to the AP_INCOME_TAX_TYPES (MISC types 1-14, except MISC9, MISC11 and MISC12) table.
STAT_AMOUNT NUMBER

Amount associated with a distribution for measuring statistical quantities. Used only for transferring the information during Open Interface Import process
PREPAY_INVOICE_ID NUMBER (15)
Prepayment Invoice unique identifier applied to the current invoice line. Validated against AP_INVOICES_ALL.INVOICE_ID.
PREPAY_LINE_NUMBER NUMBER

Line number for Prepayment line applied via current invoice line
INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2 (1)
Y indicates that prepayment is included in the invoice amount
CORRECTED_INV_ID NUMBER (15)
Invoice identifier for invoice corrected via current line. For price, quantity, or invoice line corrections
CORRECTED_LINE_NUMBER NUMBER

Invoice line number for invoice line corrected via current line. For price, quantity, or invoice line corrections
PO_HEADER_ID NUMBER

Purchase order header identifier. Used for PO matching. Validated against PO_HEADERS_ALL.PO_HEADER_ID
PO_LINE_ID NUMBER

Purchase order line identifier. Used for PO matching. Validated against PO_LINES_ALL.PO_LINE_ID
PO_RELEASE_ID NUMBER

Purchase order release identifier. Used for PO matching. Validated against PO_RELEASES_ALL.PO_RELEASE_ID
PO_LINE_LOCATION_ID NUMBER

Purchase order line location identifier. Used for PO matching. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID
PO_DISTRIBUTION_ID NUMBER

Purchase order distribution identifier. Used for PO matching. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
RCV_TRANSACTION_ID NUMBER

Receipt identifier. Used for RCV matching. Validated against RCV_TRANSACTIONS.TRANSACTION_ID
FINAL_MATCH_FLAG VARCHAR2 (1)
Final match indicator
ASSETS_TRACKING_FLAG VARCHAR2 (1)
Y indicates that the item should be treated as an asset
ASSET_BOOK_TYPE_CODE VARCHAR2 (15)
This column corresponds to the Asset Book and defaults from FA_BOOK_CONTROLS if a single Asset Book Type Code setup for the ledger the Invoice belongs to. Value in this column will default to the distributions if ASSETS_TRACKING_FLAG set to 'Y' and will be transferred to Oracle Assets.
ASSET_CATEGORY_ID NUMBER (15)
This column corresponds to the Asset Category of the Inventory item associated with Item line. Value in this column will default to the distributions if ASSETS_TRACKING_FLAG set to 'Y' and will be transferred to Oracle Assets.
PROJECT_ID NUMBER (15)
Project identifier for project related invoice lines
TASK_ID NUMBER (15)
Task identifier for project related invoice lines
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type for project related invoice lines
EXPENDITURE_ITEM_DATE DATE

Expenditure item date for project related Invoice Lines
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Expenditure organization identifier for project related invoice lines
PA_QUANTITY NUMBER

Project item quantity for project related invoice lines
PA_CC_AR_INVOICE_ID NUMBER (15)
For an intercompany invoice from Oracle Projects, this is the identifier of the corresponding receivable intercompany invoice in Oracle Receivables
PA_CC_AR_INVOICE_LINE_NUM NUMBER (15)
For an intercompany invoice from Oracle Projects, this is the line number of the corresponding receivable intercompany invoice in Oracle Receivables
PA_CC_PROCESSED_CODE VARCHAR2 (1)
The processing status of this invoice line by Oracle Projects in the receiver operating unit
AWARD_ID NUMBER (15)
Reserved for use by Oracle Grants Management. Defaults to distributions
AWT_GROUP_ID NUMBER (15)
Withholding Tax group identifier at Invoice Validation time. This column correspods to 'Invoice Withholding Tax Group'.
REFERENCE_1 VARCHAR2 (30)
A reference to a record in another application
REFERENCE_2 VARCHAR2 (30)
A reference to a record in another application
RECEIPT_VERIFIED_FLAG VARCHAR2 (1)
Indicates whether your payables department received for the expense line. Used for expense reports.
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether you payables department requires that a receipt be sent to them for the expense line. Used for expense reports.
RECEIPT_MISSING_FLAG VARCHAR2 (1)
Indicates whether the employee does not possess a receipt for an expense line. Used for expense reports.
JUSTIFICATION VARCHAR2 (240)
Expense justification given while submitting expense report.
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.
START_EXPENSE_DATE DATE

Date when incurred expense started. Used for expense reports
END_EXPENSE_DATE DATE

Date when incurred expense ended. Used for expense reports
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
DAILY_AMOUNT NUMBER

Indicates the amount charged daily for a multi-day receipt, for example, the daily rate of a rental car or hotel room. Used for expense reports.
WEB_PARAMETER_ID NUMBER

Self-Service Web applications parameter identifier. Used by Self-Service web applications like iExpenses.
ADJUSTMENT_REASON VARCHAR2 (240)
Reason your payables department adjusted (reduced) the expense line amount, or reason your payables department short paid an expense line.
MERCHANT_DOCUMENT_NUMBER VARCHAR2 (80)
Third party document number. Used for expense reports.
MERCHANT_NAME VARCHAR2 (80)
Third party name. Used for expense reports
MERCHANT_REFERENCE VARCHAR2 (240)
Third party reference. Used for expense reports
MERCHANT_TAX_REG_NUMBER VARCHAR2 (80)
Third party tax registration number. Used for expense reports
MERCHANT_TAXPAYER_ID VARCHAR2 (80)
Third party tax identification number. Used for expense reports
COUNTRY_OF_SUPPLY VARCHAR2 (5)
Country where services or goods were originated. Used for expense reports
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.
COMPANY_PREPAID_INVOICE_ID NUMBER (15)
Invoice ID when this line is a prepaid credit card transaction
CC_REVERSAL_FLAG VARCHAR2 (1)
Indicates if this line is a Credit Card reversal. Used by expense reports.
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. Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. 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
Yes 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. 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.
PROGRAM_APPLICATION_ID NUMBER (15)
Enhanced Who column Concurrent Program who column - application id of the program that last updated this row. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table.
PROGRAM_ID NUMBER (15)
Enhanced Who column Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table.
PROGRAM_UPDATE_DATE DATE

Enhanced Who column Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER (15)
Enhanced Who column Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table.
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment column
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
LINE_SELECTED_FOR_APPL_FLAG VARCHAR2 (1)
A value of Y indicates that this line on the prepayment invoice is selected for prepayment application. Used for Prepayment invoices.
PREPAY_APPL_REQUEST_ID NUMBER (15)
Request identifier of the Payables Open Interface Import program that selected this line on the prepayment invoice for prepayment application
APPLICATION_ID NUMBER (15)
Unique internal application identifier. Foreign key to the APPLICATION_ID column of the 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_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.
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.
TOTAL_REC_TAX_AMOUNT NUMBER

Total recoverable tax allocated to this taxable line.
TOTAL_NREC_TAX_AMOUNT NUMBER

Total non-recoverable tax allocated to this taxable line.
TOTAL_REC_TAX_AMT_FUNCL_CURR NUMBER

Total recoverable tax amount in functional currency.
TOTAL_NREC_TAX_AMT_FUNCL_CURR NUMBER

Total non recoverable tax amount in functional currency.
INCLUDED_TAX_AMOUNT NUMBER

Included tax amount for taxable line of type inclusive.
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.
TAX_ALREADY_CALCULATED_FLAG VARCHAR2 (1)
Internal processing flag for Payables, indicating whether tax has already been calculated.
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. This column corresponds to 'Fiscal Classification' of Invoice Workbench.
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. This column corresponds to 'Business Category' field of Invoice Lines region in Invoice Workbench.
SUMMARY_TAX_LINE_ID NUMBER

Unique internal identifier for summary tax line of E-Business Tax repository. This identifier is used to fetch the summary tax line information for an invoice line from Tax repository and displayed if 'Tax Details' button is pressed. Foreign key to the SUMMARY_TAX_LINE_ID column of the ZX_LINES_SUMMARY table.
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.
TAX_CODE_ID NUMBER (15)
Identifier for existing tax code in Payables. Necessary for upgrade and reporting purposes.
HISTORICAL_FLAG VARCHAR2 (1)
Flag to represents whether the document / invoice has been upgraded from a prior release or whether it has been newly created.
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'.
SOURCE_APPLICATION_ID NUMBER

Source document application identifier.
SOURCE_EVENT_CLASS_CODE VARCHAR2 (30)
Source document event class code.
SOURCE_ENTITY_CODE VARCHAR2 (30)
Source document entity code.
SOURCE_TRX_ID NUMBER

Source document transaction identifier.
SOURCE_LINE_ID NUMBER

Source document transaction line identifier.
SOURCE_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the source document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
RETAINED_AMOUNT NUMBER

The retained amount is based on the contractual terms defined in the service procurement contract or purchase order line.
RETAINED_AMOUNT_REMAINING NUMBER

Retained amount available for release
RETAINED_INVOICE_ID NUMBER (15)
Retained Invoice Identifier
RETAINED_LINE_NUMBER NUMBER

Retained invoice line number
LINE_SELECTED_FOR_RELEASE_FLAG VARCHAR2 (1)
Flag to indicate invoice is currently being processesed for release
LINE_OWNER_ROLE VARCHAR2 (320)
This column contains the owner of invoice line derived by AME rule.
DISPUTABLE_FLAG VARCHAR2 (1)
Indicates whether the line is disputable
RCV_SHIPMENT_LINE_ID NUMBER (15)
Receipt Shipment line unique identifier. Used for PO matching. Validated against RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID.
AIL_INVOICE_ID NUMBER (15)
AIL_DISTRIBUTION_LINE_NUMBER NUMBER (15)
AIL_INVOICE_ID2 NUMBER (15)
AIL_DISTRIBUTION_LINE_NUMBER2 NUMBER (15)
AIL_INVOICE_ID3 NUMBER (15)
AIL_DISTRIBUTION_LINE_NUMBER3 NUMBER (15)
AIL_INVOICE_ID4 NUMBER (15)
PAY_AWT_GROUP_ID NUMBER (15)
Withholding Tax group identifier at Payment time. This column corresponds to 'Payment Withholding Tax Group'
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_ID
,      LINE_NUMBER
,      LINE_TYPE_LOOKUP_CODE
,      REQUESTER_ID
,      DESCRIPTION
,      LINE_SOURCE
,      ORG_ID
,      LINE_GROUP_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      SERIAL_NUMBER
,      MANUFACTURER
,      MODEL_NUMBER
,      WARRANTY_NUMBER
,      GENERATE_DISTS
,      MATCH_TYPE
,      DISTRIBUTION_SET_ID
,      ACCOUNT_SEGMENT
,      BALANCING_SEGMENT
,      COST_CENTER_SEGMENT
,      OVERLAY_DIST_CODE_CONCAT
,      DEFAULT_DIST_CCID
,      PRORATE_ACROSS_ALL_ITEMS
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      DEFERRED_ACCTG_FLAG
,      DEF_ACCTG_START_DATE
,      DEF_ACCTG_END_DATE
,      DEF_ACCTG_NUMBER_OF_PERIODS
,      DEF_ACCTG_PERIOD_TYPE
,      SET_OF_BOOKS_ID
,      AMOUNT
,      BASE_AMOUNT
,      ROUNDING_AMT
,      QUANTITY_INVOICED
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      WFAPPROVAL_STATUS
,      USSGL_TRANSACTION_CODE
,      DISCARDED_FLAG
,      ORIGINAL_AMOUNT
,      ORIGINAL_BASE_AMOUNT
,      ORIGINAL_ROUNDING_AMT
,      CANCELLED_FLAG
,      INCOME_TAX_REGION
,      TYPE_1099
,      STAT_AMOUNT
,      PREPAY_INVOICE_ID
,      PREPAY_LINE_NUMBER
,      INVOICE_INCLUDES_PREPAY_FLAG
,      CORRECTED_INV_ID
,      CORRECTED_LINE_NUMBER
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      RCV_TRANSACTION_ID
,      FINAL_MATCH_FLAG
,      ASSETS_TRACKING_FLAG
,      ASSET_BOOK_TYPE_CODE
,      ASSET_CATEGORY_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      PA_QUANTITY
,      PA_CC_AR_INVOICE_ID
,      PA_CC_AR_INVOICE_LINE_NUM
,      PA_CC_PROCESSED_CODE
,      AWARD_ID
,      AWT_GROUP_ID
,      REFERENCE_1
,      REFERENCE_2
,      RECEIPT_VERIFIED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      RECEIPT_MISSING_FLAG
,      JUSTIFICATION
,      EXPENSE_GROUP
,      START_EXPENSE_DATE
,      END_EXPENSE_DATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CONVERSION_RATE
,      RECEIPT_CURRENCY_AMOUNT
,      DAILY_AMOUNT
,      WEB_PARAMETER_ID
,      ADJUSTMENT_REASON
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_NAME
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      CREDIT_CARD_TRX_ID
,      COMPANY_PREPAID_INVOICE_ID
,      CC_REVERSAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      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
,      LINE_SELECTED_FOR_APPL_FLAG
,      PREPAY_APPL_REQUEST_ID
,      APPLICATION_ID
,      PRODUCT_TABLE
,      REFERENCE_KEY1
,      REFERENCE_KEY2
,      REFERENCE_KEY3
,      REFERENCE_KEY4
,      REFERENCE_KEY5
,      PURCHASING_CATEGORY_ID
,      COST_FACTOR_ID
,      CONTROL_AMOUNT
,      ASSESSABLE_VALUE
,      TOTAL_REC_TAX_AMOUNT
,      TOTAL_NREC_TAX_AMOUNT
,      TOTAL_REC_TAX_AMT_FUNCL_CURR
,      TOTAL_NREC_TAX_AMT_FUNCL_CURR
,      INCLUDED_TAX_AMOUNT
,      PRIMARY_INTENDED_USE
,      TAX_ALREADY_CALCULATED_FLAG
,      SHIP_TO_LOCATION_ID
,      PRODUCT_TYPE
,      PRODUCT_CATEGORY
,      PRODUCT_FISC_CLASSIFICATION
,      USER_DEFINED_FISC_CLASS
,      TRX_BUSINESS_CATEGORY
,      SUMMARY_TAX_LINE_ID
,      TAX_REGIME_CODE
,      TAX
,      TAX_JURISDICTION_CODE
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_CODE_ID
,      HISTORICAL_FLAG
,      TAX_CLASSIFICATION_CODE
,      SOURCE_APPLICATION_ID
,      SOURCE_EVENT_CLASS_CODE
,      SOURCE_ENTITY_CODE
,      SOURCE_TRX_ID
,      SOURCE_LINE_ID
,      SOURCE_TRX_LEVEL_TYPE
,      RETAINED_AMOUNT
,      RETAINED_AMOUNT_REMAINING
,      RETAINED_INVOICE_ID
,      RETAINED_LINE_NUMBER
,      LINE_SELECTED_FOR_RELEASE_FLAG
,      LINE_OWNER_ROLE
,      DISPUTABLE_FLAG
,      RCV_SHIPMENT_LINE_ID
,      AIL_INVOICE_ID
,      AIL_DISTRIBUTION_LINE_NUMBER
,      AIL_INVOICE_ID2
,      AIL_DISTRIBUTION_LINE_NUMBER2
,      AIL_INVOICE_ID3
,      AIL_DISTRIBUTION_LINE_NUMBER3
,      AIL_INVOICE_ID4
,      PAY_AWT_GROUP_ID
FROM AP.AP_INVOICE_LINES_ALL;

Dependencies

[top of page]

AP.AP_INVOICE_LINES_ALL does not reference any database object

AP.AP_INVOICE_LINES_ALL is referenced by following:

SchemaAPPS
SynonymAP_INVOICE_LINES
SynonymAP_INVOICE_LINES_ALL
TriggerIGI_AP_INVOICE_LINES_EXP_T1
TriggerIGI_AP_INVOICE_LINES_T1
TriggerIGI_AP_INVOICE_LINES_T2
TriggerJAI_AP_ILA_ARIUD_T1