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


VIEW: AR.AR_CASH_REMIT_REFS_ALL#

Object Details
Object Name: AR_CASH_REMIT_REFS_ALL#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REMIT_REFERENCE_ID NUMBER (15) Yes
AUTOMATCH_SET_ID NUMBER (15)
CASH_RECEIPT_ID NUMBER (15)
LINE_NUMBER NUMBER (15)
REFERENCE_SOURCE VARCHAR2 (30)
CUSTOMER_ID NUMBER (15)
CUSTOMER_NUMBER VARCHAR2 (30)
BANK_ACCOUNT_NUMBER VARCHAR2 (30)
TRANSIT_ROUTING_NUMBER VARCHAR2 (35)
INVOICE_REFERENCE VARCHAR2 (50)
MATCHING_REFERENCE_DATE DATE

RESOLVED_MATCHING_NUMBER VARCHAR2 (30)
RESOLVED_MATCHING_INSTALLMENT NUMBER

RESOLVED_MATCHING_DATE DATE

INVOICE_CURRENCY_CODE VARCHAR2 (15)
AMOUNT_APPLIED NUMBER

AMOUNT_APPLIED_FROM NUMBER

TRANS_TO_RECEIPT_RATE NUMBER

INVOICE_STATUS VARCHAR2 (30)
MATCH_RESOLVED_USING VARCHAR2 (30)
ORG_ID NUMBER (15) Yes
CUSTOMER_TRX_ID NUMBER (15)
PAYMENT_SCHEDULE_ID NUMBER (15)
CUSTOMER_REFERENCE VARCHAR2 (240)
AUTO_APPLIED VARCHAR2 (1)
MANUALLY_APPLIED VARCHAR2 (1)
INSTALLMENT_NUMBER NUMBER (30)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
RECEIPT_REFERENCE_STATUS VARCHAR2 (30) Yes
BATCH_ID NUMBER (15)
TRANSMISSION_ID NUMBER (15)
INSTALLMENT_REFERENCE NUMBER

MATCH_SCORE_VALUE NUMBER (15)
Query Text

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


SELECT REMIT_REFERENCE_ID
,      AUTOMATCH_SET_ID
,      CASH_RECEIPT_ID
,      LINE_NUMBER
,      REFERENCE_SOURCE
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      BANK_ACCOUNT_NUMBER
,      TRANSIT_ROUTING_NUMBER
,      INVOICE_REFERENCE
,      MATCHING_REFERENCE_DATE
,      RESOLVED_MATCHING_NUMBER
,      RESOLVED_MATCHING_INSTALLMENT
,      RESOLVED_MATCHING_DATE
,      INVOICE_CURRENCY_CODE
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      TRANS_TO_RECEIPT_RATE
,      INVOICE_STATUS
,      MATCH_RESOLVED_USING
,      ORG_ID
,      CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_REFERENCE
,      AUTO_APPLIED
,      MANUALLY_APPLIED
,      INSTALLMENT_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      RECEIPT_REFERENCE_STATUS
,      BATCH_ID
,      TRANSMISSION_ID
,      INSTALLMENT_REFERENCE
,      MATCH_SCORE_VALUE
FROM AR.AR_CASH_REMIT_REFS_ALL#;

Dependencies

[top of page]

AR.AR_CASH_REMIT_REFS_ALL# references the following:

SchemaAR
TableAR_CASH_REMIT_REFS_ALL
AR.AR_CASH_REMIT_REFS_ALL# is referenced by following:

SchemaAPPS
SynonymAR_CASH_REMIT_REFS
SynonymAR_CASH_REMIT_REFS_ALL