DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.AR_CASH_RECEIPTS_S_V

Object Details
Object Name: AR_CASH_RECEIPTS_S_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_CASH_RECEIPTS_S_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
RCT_ACTUAL_VALUE_DATE DATE

The date cash is withdrawn or deposited in a bank account
RCT_CASH_RECEIPT_ID NUMBER (15) Yes Identifier of the cash receipt
RCT_COMMENTS VARCHAR2 (2000)
Comments about this receipt record
RCT_CUSTOMER_RECEIPT_REF VARCHAR2 (30)
This column is used to store a customer reference value that the customer supplies at confirmation time
RCT_DEPOSIT_DATE DATE

This will be a user column, and will have no significance within the system
RCT_DOC_SEQUENCE_ID NUMBER (15)
Identifies database sequence used to assign document number to receipt
RCT_DOC_SEQUENCE_VALUE NUMBER (15)
Value assigned to document receipt
RCT_DOC_SEQUENCE_CATEGORY VARCHAR2 (30)
RCT_ISSUER_NAME VARCHAR2 (50)
RCT_ISSUE_DATE DATE

RCT_MISC_PAYMENT_SOURCE VARCHAR2 (30)
RCT_PAY_FROM_CUSTOMER NUMBER (15)
RCT_POSTMARK_DATE DATE

RCT_RECEIPT_DATE DATE
Yes
RCT_RECEIPT_NUMBER VARCHAR2 (30)
RCT_REFERENCE_TYPE VARCHAR2 (30)
RCT_REVERSAL_COMMENTS VARCHAR2 (240)
RCT_REVERSAL_DATE DATE

RCT_REVERSAL_REASON_CODE VARCHAR2 (30)
RCT_TAX_RATE NUMBER

RCT_TYPE VARCHAR2 (20)
RCT_ATTR1 VARCHAR2 (150)
RCT_ATTR10 VARCHAR2 (150)
RCT_ATTR11 VARCHAR2 (150)
RCT_ATTR12 VARCHAR2 (150)
RCT_ATTR13 VARCHAR2 (150)
RCT_ATTR14 VARCHAR2 (150)
RCT_ATTR15 VARCHAR2 (150)
RCT_ATTR2 VARCHAR2 (150)
RCT_ATTR3 VARCHAR2 (150)
RCT_ATTR4 VARCHAR2 (150)
RCT_ATTR5 VARCHAR2 (150)
RCT_ATTR6 VARCHAR2 (150)
RCT_ATTR7 VARCHAR2 (150)
RCT_ATTR8 VARCHAR2 (150)
RCT_ATTR9 VARCHAR2 (150)
RCT_ATTR_CAT VARCHAR2 (30)
RCT_GLOBAL_ATTR1 VARCHAR2 (150)
RCT_GLOBAL_ATTR2 VARCHAR2 (150)
RCT_GLOBAL_ATTR3 VARCHAR2 (150)
RCT_GLOBAL_ATTR4 VARCHAR2 (150)
RCT_GLOBAL_ATTR5 VARCHAR2 (150)
RCT_GLOBAL_ATTR6 VARCHAR2 (150)
RCT_GLOBAL_ATTR_CAT VARCHAR2 (30)
RCT_REVERSAL_CAT VARCHAR2 (20)
RCT_USSGL_TRX_CODE VARCHAR2 (30)
RCT_USSGL_TRX_CODE_CT VARCHAR2 (30)
EVENT_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
LANGUAGE VARCHAR2 (20)
LEDGER_ID NUMBER (15)
XLA_PARTY_TYPE CHAR (1)
RCT_OPER_UNIT NUMBER (15)
RCT_APP_STATUS VARCHAR2 (30)
RCT_XLA_APPLIED_TO_APP_ID NUMBER

RCT_ENTITY_CODE CHAR (8)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      RCT_USSGL_TRX_CODE
,      RCT_USSGL_TRX_CODE_CT
,      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
FROM APPS.AR_CASH_RECEIPTS_S_V;

Dependencies

[top of page]

APPS.AR_CASH_RECEIPTS_S_V references the following:

SchemaAPPS
SynonymAR_CASH_RECEIPTS_ALL
SynonymAR_RECEIPT_METHODS
SynonymAR_XLA_LINES_EXTRACT

APPS.AR_CASH_RECEIPTS_S_V is not referenced by any database object