AR_CASH_RECEIPTS_ALL

ReceivablesUsed in 9 subject areas25 reporting columns

Receivables (AR) — customer cash receipts.

Primary key: CASH_RECEIPT_ID

Columns

Column	Key	In reports	Description (inferred)
ACTUAL_VALUE_DATE		●	Actual value date.
AMOUNT		●	Amount.
ANTICIPATED_CLEARING_DATE		●	Anticipated clearing date.
CASH_RECEIPT_ID	PK	○	Identifier for the cash receipt.
COMMENTS		●	Comments.
CONFIRMED_FLAG		●	Indicator (Y/N) for the confirmed.
CREATION_DATE		●	Date and time the row was created.
CUSTOMER_RECEIPT_REFERENCE		●	Customer receipt reference.
DEPOSIT_DATE		●	Deposit date.
DOC_SEQUENCE_VALUE		●	Doc sequence value.
EXCHANGE_DATE		●	Exchange date.
EXCHANGE_RATE		●	Exchange rate.
FACTOR_DISCOUNT_AMOUNT		●	Factor discount amount.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
MISC_PAYMENT_SOURCE		●	Misc payment source.
POSTMARK_DATE		●	Postmark date.
RECEIPT_DATE		●	Receipt date.
RECEIPT_NUMBER		●	Receipt number.
REFERENCE_TYPE		●	Type of reference.
REVERSAL_CATEGORY		●	Reversal category.
REVERSAL_COMMENTS		●	Reversal comments.
REVERSAL_DATE		●	Reversal date.
REVERSAL_REASON_CODE		●	Code identifying the reversal reason.
STATUS		●	Status.
TAX_RATE		●	Tax rate.
TYPE		●	Type.

Change a column here and these are the reports that move with it — the blast radius for any change to AR_CASH_RECEIPTS_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_RECEIPTS_ALL?

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