Analytics Catalog/Data dictionary/VRM_SOURCE_DOCUMENTS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

VRM_SOURCE_DOCUMENTS

SharedUsed in 4 subject areas11 reporting columns

Revenue Management (VRM).

Primary key: not yet catalogued for VRM_SOURCE_DOCUMENTS — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
CANCELLED_FLAGIndicator (Y/N) for the cancelled.
CUSTOMER_CONTRACT_NUMBERCustomer contract number.
CUST_PO_NUMBERCustomer purchase order number.
DOCUMENT_DATEDocument date.
DOCUMENT_NUMBERDocument number.
MEA_FLAGIndicator (Y/N) for the mea.
QUOTE_NUMBERQuote number.
RETURN_REASON_CODECode identifying the return reason.
SALES_AGREEMENT_NUMBERSales agreement number.
SOURCE_SYSTEMSource system.
SOURCE_TYPE_CODECode identifying the source type.

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_SOURCE_DOCUMENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us