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

AR_MISC_CASH_DISTRIBUTIONS_ALL

ReceivablesUsed in 1 subject areas3 reporting columns

Receivables (AR), accounting distribution lines, the GL coding behind each transaction line.

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

Columns

ColumnKeyIn reportsDescription (inferred)
GL_DATE●General ledger date.
MISC_CASH_DISTRIBUTION_IDPK?○Identifier for the misc cash distribution.
PERCENT●Percent.
POSTING_CONTROL_ID●Identifier for the posting control.

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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.

Need the extract + dbt staging for AR_MISC_CASH_DISTRIBUTIONS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Aging as of any date · Reporting without memory · The export ceiling