VRM_SOURCE_DOC_LINES

SharedUsed in 4 subject areas32 reporting columns

Revenue Management (VRM) — line table — one row per line item under the header.

Likely primary key: SOURCE_DOC_HEADER_ID, LINE_NUM (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

Column	Key	In reports	Description (inferred)
ACCOUNTING_RULE_NAME		●	Name of the accounting rule.
ACTUAL_ARRIVAL_DATE		●	Actual arrival date.
ACTUAL_SHIPMENT_DATE		●	Actual shipment date.
BASE_PRICE		●	Base price.
COMMENTS		●	Comments.
COST_AMOUNT		●	Cost amount.
CREATION_DATE		●	Date and time the row was created.
DELIVERY_DATE		●	Delivery date.
DELIVERY_STATUS		●	Status of the delivery.
DISCOUNT_AMOUNT		●	Discount amount.
DISCOUNT_PERCENTAGE		●	Discount percentage.
DOCUMENT_DATE		●	Document date.
DOCUMENT_LINE_ID		●	Identifier for the document line.
GROSS_MARGIN_PERCENT		●	Gross margin percentage.
LAST_PERIOD_TO_CREDIT		●	Last period to credit.
LINE_AMOUNT		●	Line amount.
LINE_NUM	PK?	●	Line number.
LINE_TYPE		●	Type of line.
MEMO_LINE_NAME		●	Name of the memo line.
PAYMENT_TERM_NAME		●	Name of the payment term.
QUANTITY		●	Quantity.
QUANTITY_CANCELLED		●	Quantity cancelled.
QUANTITY_FULFILLED		●	Quantity fulfilled.
QUANTITY_ORDERED		●	Quantity ordered.
QUANTITY_SHIPPED		●	Quantity shipped.
REVENUE_REVERSAL_METHOD		●	Revenue reversal method.
SOURCE_DOC_HEADER_ID	PK?	○	Identifier for the source doc header.
UNIT_LIST_PCT_BASE_PRICE		●	Unit list percent base price.
UNIT_LIST_PRICE		●	Unit list price.
UNIT_SELLING_PCT_BASE_PRICE		●	Unit selling percent base price.
UNIT_SELLING_PRICE		●	Unit selling price.
VERSION_FLAG		●	Indicator (Y/N) for the version.
VERSION_NUMBER		●	Version number.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

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 VRM_SOURCE_DOC_LINES?

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