eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: AR.AR_TRX_SUMMARY#

Object Details

Object Name:	AR_TRX_SUMMARY#
Object Type:	VIEW
Owner:	AR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CUST_ACCOUNT_ID	NUMBER	(15)	Yes
SITE_USE_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)
CURRENCY	VARCHAR2	(30)	Yes
AS_OF_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OP_BAL_HIGH_WATERMARK	NUMBER
OP_BAL_HIGH_WATERMARK_DATE	DATE
TOTAL_CASH_RECEIPTS_VALUE	NUMBER
TOTAL_CASH_RECEIPTS_COUNT	NUMBER
TOTAL_INVOICES_VALUE	NUMBER
TOTAL_INVOICES_COUNT	NUMBER
INV_PAID_AMOUNT	NUMBER
INV_INST_PMT_DAYS_SUM	NUMBER
TOTAL_BILLS_RECEIVABLES_VALUE	NUMBER
TOTAL_BILLS_RECEIVABLES_COUNT	NUMBER
TOTAL_CREDIT_MEMOS_VALUE	NUMBER
TOTAL_CREDIT_MEMOS_COUNT	NUMBER
TOTAL_DEBIT_MEMOS_VALUE	NUMBER
TOTAL_DEBIT_MEMOS_COUNT	NUMBER
TOTAL_CHARGEBACK_VALUE	NUMBER
TOTAL_CHARGEBACK_COUNT	NUMBER
TOTAL_EARNED_DISC_VALUE	NUMBER
TOTAL_EARNED_DISC_COUNT	NUMBER
TOTAL_UNEARNED_DISC_VALUE	NUMBER
TOTAL_UNEARNED_DISC_COUNT	NUMBER
TOTAL_ADJUSTMENTS_VALUE	NUMBER
TOTAL_ADJUSTMENTS_COUNT	NUMBER
TOTAL_DEPOSITS_VALUE	NUMBER
TOTAL_DEPOSITS_COUNT	NUMBER
SUM_APP_AMT_DAYS_LATE	NUMBER
SUM_APP_AMT	NUMBER
COUNT_OF_TOT_INV_INST_PAID	NUMBER
COUNT_OF_INV_INST_PAID_LATE	NUMBER
COUNT_OF_DISC_INV_INST	NUMBER
LARGEST_INV_AMOUNT	NUMBER
LARGEST_INV_DATE	DATE
LARGEST_INV_CUST_TRX_ID	NUMBER	(15)
DAYS_CREDIT_GRANTED_SUM	NUMBER
NSF_STOP_PAYMENT_COUNT	NUMBER
NSF_STOP_PAYMENT_AMOUNT	NUMBER
REFERENCE_1	VARCHAR2	(240)
REFERENCE_2	VARCHAR2	(240)
REFERENCE_3	VARCHAR2	(240)
REFERENCE_4	VARCHAR2	(240)
REFERENCE_5	VARCHAR2	(240)

Query Text

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


SELECT CUST_ACCOUNT_ID
,      SITE_USE_ID
,      ORG_ID
,      CURRENCY
,      AS_OF_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OP_BAL_HIGH_WATERMARK
,      OP_BAL_HIGH_WATERMARK_DATE
,      TOTAL_CASH_RECEIPTS_VALUE
,      TOTAL_CASH_RECEIPTS_COUNT
,      TOTAL_INVOICES_VALUE
,      TOTAL_INVOICES_COUNT
,      INV_PAID_AMOUNT
,      INV_INST_PMT_DAYS_SUM
,      TOTAL_BILLS_RECEIVABLES_VALUE
,      TOTAL_BILLS_RECEIVABLES_COUNT
,      TOTAL_CREDIT_MEMOS_VALUE
,      TOTAL_CREDIT_MEMOS_COUNT
,      TOTAL_DEBIT_MEMOS_VALUE
,      TOTAL_DEBIT_MEMOS_COUNT
,      TOTAL_CHARGEBACK_VALUE
,      TOTAL_CHARGEBACK_COUNT
,      TOTAL_EARNED_DISC_VALUE
,      TOTAL_EARNED_DISC_COUNT
,      TOTAL_UNEARNED_DISC_VALUE
,      TOTAL_UNEARNED_DISC_COUNT
,      TOTAL_ADJUSTMENTS_VALUE
,      TOTAL_ADJUSTMENTS_COUNT
,      TOTAL_DEPOSITS_VALUE
,      TOTAL_DEPOSITS_COUNT
,      SUM_APP_AMT_DAYS_LATE
,      SUM_APP_AMT
,      COUNT_OF_TOT_INV_INST_PAID
,      COUNT_OF_INV_INST_PAID_LATE
,      COUNT_OF_DISC_INV_INST
,      LARGEST_INV_AMOUNT
,      LARGEST_INV_DATE
,      LARGEST_INV_CUST_TRX_ID
,      DAYS_CREDIT_GRANTED_SUM
,      NSF_STOP_PAYMENT_COUNT
,      NSF_STOP_PAYMENT_AMOUNT
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
FROM AR.AR_TRX_SUMMARY#;

Dependencies

[top of page]

AR.AR_TRX_SUMMARY# references the following:

AR: AR_TRX_SUMMARY

AR.AR_TRX_SUMMARY# is referenced by following:

APPS: AR_TRX_SUMMARY