Oracle Fusion · Data dictionary
AP_INVOICE_LINES_ALL
PayablesUsed in 19 subject areas58 reporting columns
Payables (AP), supplier invoice lines (item, freight, tax, miscellaneous charges).
Primary key: INVOICE_ID, LINE_NUMBER
Joins (inferred from key columns): INVOICE_ID → AP_INVOICES_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_DATE | ● | Accounting date. | |
| ADJUSTMENT_REASON | ● | Adjustment reason. | |
| AMOUNT | ● | Amount. | |
| ASSESSABLE_VALUE | ● | Assessable value. | |
| ASSETS_TRACKING_FLAG | ● | Indicator (Y/N) for the assets tracking. | |
| ASSET_BOOK_TYPE_CODE | ● | Code identifying the asset book type. | |
| BASE_AMOUNT | ● | Base amount. | |
| BUDGET_DATE | ● | Budget date. | |
| CANCELLED_FLAG | ● | Indicator (Y/N) for the cancelled. | |
| CONTROL_AMOUNT | ● | Control amount. | |
| CORRECTED_LINE_NUMBER | ● | Corrected line number. | |
| DESCRIPTION | ● | Description. | |
| DISCARDED_FLAG | ● | Indicator (Y/N) for the discarded. | |
| EXPENDITURE_ITEM_DATE | ● | Expenditure item date. | |
| FINAL_MATCH_FLAG | ● | Indicator (Y/N) for the final match. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| INCLUDED_TAX_AMOUNT | ● | Included tax amount. | |
| INCOME_TAX_REGION | ● | Income tax region. | |
| INVOICE_ID | PK | ○ | Identifier for the invoice. |
| INVOICE_INCLUDES_PREPAY_FLAG | ● | Indicator (Y/N) for the invoice includes prepay. | |
| LCM_ENABLED_FLAG | ● | Indicator (Y/N) for the lcm enabled. | |
| LINE_GROUP_NUMBER | ● | Line group number. | |
| LINE_NUMBER | PK | ● | Line number. |
| LINE_TYPE_LOOKUP_CODE | ● | Lookup code for the line type. | |
| MANUFACTURER | ● | Manufacturer. | |
| MATCH_TYPE | ● | Type of match. | |
| MODEL_NUMBER | ● | Model number. | |
| ORIGINAL_AMOUNT | ● | Original amount. | |
| ORIGINAL_BASE_AMOUNT | ● | Original base amount. | |
| ORIGINAL_ROUNDING_AMT | ● | Original rounding amount. | |
| PA_CC_AR_INVOICE_LINE_NUM | ● | Pa cc receivables invoice line number. | |
| PA_CC_PROCESSED_CODE | ● | Code identifying the pa cc processed. | |
| PERIOD_NAME | ● | Name of the period. | |
| PJC_EXPENDITURE_ITEM_DATE | ● | Pjc expenditure item date. | |
| PO_LINE_ID | ● | Identifier for the purchase order line. | |
| PREPAY_LINE_NUMBER | ● | Prepay line number. | |
| PRIMARY_INTENDED_USE | ● | Primary intended use. | |
| PRODUCT_CATEGORY | ● | Product category. | |
| PRODUCT_FISC_CLASSIFICATION | ● | Product fisc classification. | |
| PRODUCT_TYPE | ● | Type of product. | |
| PRORATE_ACROSS_ALL_ITEMS | ● | Prorate across all items. | |
| QUANTITY_INVOICED | ● | Quantity invoiced. | |
| ROUNDING_AMT | ● | Rounding amount. | |
| SERIAL_NUMBER | ● | Serial number. | |
| TAX | ● | Tax. | |
| TAX_ALREADY_CALCULATED_FLAG | ● | Indicator (Y/N) for the tax already calculated. | |
| TAX_CLASSIFICATION_CODE | ● | Code identifying the tax classification. | |
| TAX_JURISDICTION_CODE | ● | Code identifying the tax jurisdiction. | |
| TAX_RATE | ● | Tax rate. | |
| TAX_RATE_CODE | ● | Code identifying the tax rate. | |
| TAX_REGIME_CODE | ● | Code identifying the tax regime. | |
| TAX_STATUS_CODE | ● | Code identifying the tax status. | |
| TRX_BUSINESS_CATEGORY | ● | Transaction business category. | |
| TYPE_1099 | ● | Type 1099. | |
| UNIT_MEAS_LOOKUP_CODE | ● | Lookup code for the unit meas. | |
| UNIT_PRICE | ● | Unit price. | |
| USER_DEFINED_FISC_CLASS | ● | User defined fisc class. | |
| WARRANTY_NUMBER | ● | Warranty number. | |
| WFAPPROVAL_STATUS | ● | Status of the wfapproval. |
8 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to AP_INVOICE_LINES_ALL.
- Spain SII Report
- AP Invoice Detail Report with Tax Details
- AP Invoice Detail Report
- Input Goods and Services Tax Declaration Vietnam
- Financial Tax Register
- Payables Invoice Register
- Payables Invoice Audit Listing
- Payables Matching Detail Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Budgetary Control - Transactions Real Time
- Costing - Receipt Accounting Real Time
- Fiscal Document Capture Transactions Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
- Payables Invoices - Holds Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Procurement - Spend Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
- Sourcing - Supplier Responses Real Time
- Supplier Portal - Invoice Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for AP_INVOICE_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table