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

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.

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.

Need the extract + dbt staging for AP_INVOICE_LINES_ALL?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us