AR_CASH_RECEIPT_HISTORY_ALL

ReceivablesUsed in 2 subject areas17 reporting columns

Receivables (AR) — transaction table (rows scoped across all operating units).

Primary key: CASH_RECEIPT_HISTORY_ID

Columns

Column	Key	In reports	Description (inferred)
ACCTD_AMOUNT		●	Acctd amount.
ACCTD_FACTOR_DISCOUNT_AMOUNT		●	Acctd factor discount amount.
AMOUNT		●	Amount.
CASH_RECEIPT_HISTORY_ID	PK	○	Identifier for the cash receipt history.
CREATION_DATE		●	Date and time the row was created.
CURRENT_RECORD_FLAG		●	Indicator (Y/N) for the current record.
EXCHANGE_DATE		●	Exchange date.
EXCHANGE_RATE		●	Exchange rate.
FACTOR_DISCOUNT_AMOUNT		●	Factor discount amount.
FIRST_POSTED_RECORD_FLAG		●	Indicator (Y/N) for the first posted record.
GL_DATE		●	General ledger date.
GL_POSTED_DATE		●	General ledger posted date.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
POSTABLE_FLAG		●	Indicator (Y/N) for the postable.
REVERSAL_GL_DATE		●	Reversal general ledger date.
REVERSAL_GL_POSTED_DATE		●	Reversal general ledger posted date.
STATUS		●	Status.
TRX_DATE		●	Transaction date.

Change a column here and these are the reports that move with it — the blast radius for any change to AR_CASH_RECEIPT_HISTORY_ALL.

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

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