VRM_REV_DOC_LINE_SCHEDULES_ALL

SharedUsed in 1 subject areas23 reporting columns

Revenue Management (VRM) — transaction table (rows scoped across all operating units).

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

Columns

Column	In reports	Description (inferred)
ACCOUNTING_DATE	●	Accounting date.
ACCOUNT_CLASS	●	Account class.
ACCOUNT_SET_FLAG	●	Indicator (Y/N) for the account set.
ACCTD_AMOUNT	●	Acctd amount.
ADJ_GROSS_MARGIN_PERCENT	●	Adj gross margin percentage.
AMOUNT	●	Amount.
COMMENTS	●	Comments.
CREATED_BY	●	User who created the row.
CREATION_DATE	●	Date and time the row was created.
GL_POSTED_DATE	●	General ledger posted 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).
OFFSET_LINE_TYPE	●	Type of offset line.
ORIGINAL_ACCOUNTING_DATE	●	Original accounting date.
PERCENT	●	Percent.
POSTED_TO_SLA_FLAG	●	Indicator (Y/N) for the posted to sla.
POSTING_CONTROL_ID	●	Identifier for the posting control.
REC_OFFSET_FLAG	●	Indicator (Y/N) for the rec offset.
ROUNDING_CORRECTION_FLAG	●	Indicator (Y/N) for the rounding correction.
SCHEDULE_EVENT	●	Schedule event.
SCHEDULE_LINE_NUMBER	●	Schedule line number.
TERMINATED_FLAG	●	Indicator (Y/N) for the terminated.
USER_GENERATED_FLAG	●	Indicator (Y/N) for the user generated.

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

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