VRM_REVENUE_DOC_LINES_ALL

SharedUsed in 2 subject areas37 reporting columns

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

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

Columns

Column	Key	In reports	Description (inferred)
ACTUAL_SHIPMENT_DATE		●	Actual shipment date.
CODE_COMBINATION_ID		●	Identifier for the code combination.
CONTINGENCY_COUNT		●	Contingency count.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
CUST_PO_NUMBER		●	Customer purchase order number.
EXTENDED_CARVED_OUT_AMOUNT		●	Extended carved out amount.
EXTENDED_REVENUE_PRICE_AMOUNT		●	Extended revenue price amount.
EXTENDED_UNIT_PRICE_AMOUNT		●	Extended unit price amount.
FREIGHT_TERMS_CODE		●	Code identifying the freight terms.
FULFILLMENT_DATE		●	Fulfillment date.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
LINE_NUMBER	PK?	●	Line number.
MEA_NUMBER		●	Mea number.
ORIG_QUANTITY		●	Orig quantity.
ORIG_RULE_DURATION		●	Orig rule duration.
ORIG_RULE_END_DATE		●	Orig rule end date.
ORIG_RULE_START_DATE		●	Orig rule start date.
ORIG_UNIT_SELLING_PRICE		●	Orig unit selling price.
PAYMENT_AMOUNT		●	Payment amount.
QUANTITY		●	Quantity.
QUANTITY_CREDITED		●	Quantity credited.
QUANTITY_INVOICED		●	Quantity invoiced.
REQUIRES_MANUAL_SCHEDULING		●	Requires manual scheduling.
REVENUE_DOC_HEADER_ID	PK?	○	Identifier for the revenue doc header.
REVENUE_RULE_NAME		●	Name of the revenue rule.
RULE_DURATION		●	Rule duration.
RULE_DURATION_PROCESSED		●	Rule duration processed.
RULE_END_DATE		●	Rule end date.
RULE_START_DATE		●	Rule start date.
SCHEDULED_AMOUNT		●	Scheduled amount.
SHIP_CONFIRM_DATE		●	Shipment confirm date.
SOURCE_DOCUMENT_LINE_NUMBER		●	Source document line number.
UNIT_CARVE_OUT_PRICE		●	Unit carve out price.
UNIT_REVENUE_PRICE		●	Unit revenue price.
UNIT_SELLING_PRICE		●	Unit selling price.
UNSCHEDULED_AMOUNT		●	Unscheduled amount.

Used by reports

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

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

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

Talk to us