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_BAL_SUMMARY#

Object Details

Object Name:	AR_TRX_BAL_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	(15)	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)
BEST_CURRENT_RECEIVABLES	NUMBER
TOTAL_DSO_DAYS_CREDIT	NUMBER
OP_INVOICES_VALUE	NUMBER
OP_INVOICES_COUNT	NUMBER
OP_DEBIT_MEMOS_VALUE	NUMBER
OP_DEBIT_MEMOS_COUNT	NUMBER
OP_DEPOSITS_VALUE	NUMBER
OP_DEPOSITS_COUNT	NUMBER
OP_BILLS_RECEIVABLES_VALUE	NUMBER
OP_BILLS_RECEIVABLES_COUNT	NUMBER
OP_CHARGEBACK_VALUE	NUMBER
OP_CHARGEBACK_COUNT	NUMBER
OP_CREDIT_MEMOS_VALUE	NUMBER
OP_CREDIT_MEMOS_COUNT	NUMBER
UNRESOLVED_CASH_VALUE	NUMBER
UNRESOLVED_CASH_COUNT	NUMBER
RECEIPTS_AT_RISK_VALUE	NUMBER
INV_AMT_IN_DISPUTE	NUMBER
DISPUTED_INV_COUNT	NUMBER
PENDING_ADJ_VALUE	NUMBER
LAST_DUNNING_DATE	DATE
DUNNING_COUNT	NUMBER
PAST_DUE_INV_VALUE	NUMBER
PAST_DUE_INV_INST_COUNT	NUMBER
LAST_PAYMENT_AMOUNT	NUMBER
LAST_PAYMENT_DATE	DATE
LAST_PAYMENT_NUMBER	VARCHAR2	(30)
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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BEST_CURRENT_RECEIVABLES
,      TOTAL_DSO_DAYS_CREDIT
,      OP_INVOICES_VALUE
,      OP_INVOICES_COUNT
,      OP_DEBIT_MEMOS_VALUE
,      OP_DEBIT_MEMOS_COUNT
,      OP_DEPOSITS_VALUE
,      OP_DEPOSITS_COUNT
,      OP_BILLS_RECEIVABLES_VALUE
,      OP_BILLS_RECEIVABLES_COUNT
,      OP_CHARGEBACK_VALUE
,      OP_CHARGEBACK_COUNT
,      OP_CREDIT_MEMOS_VALUE
,      OP_CREDIT_MEMOS_COUNT
,      UNRESOLVED_CASH_VALUE
,      UNRESOLVED_CASH_COUNT
,      RECEIPTS_AT_RISK_VALUE
,      INV_AMT_IN_DISPUTE
,      DISPUTED_INV_COUNT
,      PENDING_ADJ_VALUE
,      LAST_DUNNING_DATE
,      DUNNING_COUNT
,      PAST_DUE_INV_VALUE
,      PAST_DUE_INV_INST_COUNT
,      LAST_PAYMENT_AMOUNT
,      LAST_PAYMENT_DATE
,      LAST_PAYMENT_NUMBER
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_4
,      REFERENCE_5
FROM AR.AR_TRX_BAL_SUMMARY#;

Dependencies

[top of page]

AR.AR_TRX_BAL_SUMMARY# references the following:

AR: AR_TRX_BAL_SUMMARY

AR.AR_TRX_BAL_SUMMARY# is referenced by following:

APPS: AR_TRX_BAL_SUMMARY