1. Tables and Views for Financials
  2. AR_CASH_RECEIPTS_S_V

AR_CASH_RECEIPTS_S_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

RCT_ACTUAL_VALUE_DATE

RCT_CASH_RECEIPT_ID

RCT_COMMENTS

RCT_CUSTOMER_RECEIPT_REF

RCT_DEPOSIT_DATE

RCT_DOC_SEQUENCE_ID

RCT_DOC_SEQUENCE_VALUE

RCT_DOC_SEQUENCE_CATEGORY

RCT_ISSUER_NAME

RCT_ISSUE_DATE

RCT_MISC_PAYMENT_SOURCE

RCT_PAY_FROM_CUSTOMER

RCT_POSTMARK_DATE

RCT_RECEIPT_DATE

RCT_RECEIPT_NUMBER

RCT_REFERENCE_TYPE

RCT_REVERSAL_COMMENTS

RCT_REVERSAL_DATE

RCT_REVERSAL_REASON_CODE

RCT_TAX_RATE

RCT_TYPE

RCT_ATTR1

RCT_ATTR10

RCT_ATTR11

RCT_ATTR12

RCT_ATTR13

RCT_ATTR14

RCT_ATTR15

RCT_ATTR2

RCT_ATTR3

RCT_ATTR4

RCT_ATTR5

RCT_ATTR6

RCT_ATTR7

RCT_ATTR8

RCT_ATTR9

RCT_ATTR_CAT

RCT_GLOBAL_ATTR1

RCT_GLOBAL_ATTR2

RCT_GLOBAL_ATTR3

RCT_GLOBAL_ATTR4

RCT_GLOBAL_ATTR5

RCT_GLOBAL_ATTR6

RCT_GLOBAL_ATTR_CAT

RCT_REVERSAL_CAT

EVENT_ID

LINE_NUMBER

LANGUAGE

LEDGER_ID

XLA_PARTY_TYPE

RCT_OPER_UNIT

RCT_APP_STATUS

RCT_XLA_APPLIED_TO_APP_ID

RCT_ENTITY_CODE

Query

SQL_Statement

SELECT cra.actual_value_date rct_actual_value_date ,

cra.cash_receipt_id rct_cash_receipt_id ,

cra.comments rct_comments ,

cra.customer_receipt_reference rct_customer_receipt_ref ,

cra.deposit_date rct_deposit_date ,

cra.doc_sequence_id rct_doc_sequence_id ,

cra.doc_sequence_value rct_doc_sequence_value ,

DECODE(cra.doc_sequence_value, NULL, NULL, rm.name) RCT_DOC_SEQUENCE_CATEGORY ,

cra.issuer_name rct_issuer_name ,

cra.issue_date rct_issue_date ,

cra.misc_payment_source rct_misc_payment_source ,

cra.pay_from_customer rct_pay_from_customer ,

cra.postmark_date rct_postmark_date ,

cra.receipt_date rct_receipt_date ,

cra.receipt_number rct_receipt_number ,

cra.reference_type rct_reference_type ,

cra.reversal_comments rct_reversal_comments ,

cra.reversal_date rct_reversal_date ,

cra.reversal_reason_code rct_reversal_reason_code ,

cra.tax_rate rct_tax_rate ,

cra.type rct_type ,

cra.attribute1 RCT_ATTR1 ,

cra.attribute10 RCT_ATTR10 ,

cra.attribute11 RCT_ATTR11 ,

cra.attribute12 RCT_ATTR12 ,

cra.attribute13 RCT_ATTR13 ,

cra.attribute14 RCT_ATTR14 ,

cra.attribute15 RCT_ATTR15 ,

cra.attribute2 RCT_ATTR2 ,

cra.attribute3 RCT_ATTR3 ,

cra.attribute4 RCT_ATTR4 ,

cra.attribute5 RCT_ATTR5 ,

cra.attribute6 RCT_ATTR6 ,

cra.attribute7 RCT_ATTR7 ,

cra.attribute8 RCT_ATTR8 ,

cra.attribute9 RCT_ATTR9 ,

cra.attribute_category RCT_ATTR_CAT ,

cra.global_attribute1 RCT_GLOBAL_ATTR1 ,

cra.global_attribute2 RCT_GLOBAL_ATTR2 ,

cra.global_attribute3 RCT_GLOBAL_ATTR3 ,

cra.global_attribute4 RCT_GLOBAL_ATTR4 ,

cra.global_attribute5 RCT_GLOBAL_ATTR5 ,

cra.global_attribute6 RCT_GLOBAL_ATTR6 ,

cra.global_attribute_category RCT_GLOBAL_ATTR_CAT ,

cra.reversal_category RCT_REVERSAL_CAT ,

l.event_id event_id ,

l.line_number line_number ,

l.language language ,

l.ledger_id ledger_id ,

'C' xla_party_type ,

cra.org_id rct_oper_unit ,

cra.status rct_app_status ,

222 rct_xla_applied_to_app_id ,

'RECEIPTS' rct_entity_code

FROM ar_cash_receipts_all cra ,

ar_xla_lines_extract l ,

ar_receipt_methods rm

WHERE cra.cash_receipt_id = l.cash_receipt_id

AND l.level_flag = 'H'

AND l.event_class_code = 'CREDIT_MEMO'

AND cra.receipt_method_id = rm.receipt_method_id