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]

TABLE: AR.AR_CUSTOMER_BALANCE_ITF

Object Details

Object Name:	AR_CUSTOMER_BALANCE_ITF
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_CUSTOMER_BALANCE_ITF
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

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
AS_OF_DATE	DATE		Yes	As of date
ORGANIZATION_NAME	VARCHAR2	(60)	Yes	Organization name
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)	Yes	Functional currency code
CUSTOMER_NAME	VARCHAR2	(360)	Yes	Customer name
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes	Customer number
TAX_REFERENCE_NUM	VARCHAR2	(50)		Customer tax reference number
ADDRESS_LINE1	VARCHAR2	(240)		Customer bill-to address line 1
ADDRESS_LINE2	VARCHAR2	(240)		Customer bill-to address line 2
ADDRESS_LINE3	VARCHAR2	(240)		Customer bill-to address line 3
ADDRESS_LINE4	VARCHAR2	(240)		Customer bill-to address line 4
CITY	VARCHAR2	(60)		Customer bill-to city
STATE	VARCHAR2	(60)		Customer state
ZIP	VARCHAR2	(60)		Customer zip code
COUNTRY	VARCHAR2	(60)		Customer country
TRANS_TYPE	VARCHAR2	(20)	Yes	Invoice transaction type
TRX_NUMBER	VARCHAR2	(30)	Yes	Invoice number
TRANSACTION_DATE	DATE		Yes	Invoice transaction date
TRX_CURRENCY_CODE	VARCHAR2	(15)	Yes	Invoice currency code
TRANS_AMOUNT	NUMBER			Total invoice amount
TRANS_AMOUNT_REMAINING	NUMBER			Amount remaining on invoice/open balance
RECEIPT_AMOUNT	NUMBER			Transaction receipt amount
ADJUSTMENT_AMOUNT	NUMBER			Adjustment amount
EARNED_DISCOUNT_AMOUNT	NUMBER			Total discount amount
UNEARNED_DISCOUNT_AMOUNT	NUMBER			Accounted unearned total
INVOICE_CREDIT_AMOUNT	NUMBER			Total invoice credit amount
BANK_CHARGE	NUMBER			Bank charge
ON_ACCOUNT_CREDIT_AMOUNT	NUMBER			Total on-account credit amount
ON_ACCOUNT_RECEIPTS	NUMBER			Total on-account receipts
UNAPPLIED_RECEIPTS	NUMBER			Total unapplied receipts

Query Text

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


SELECT REQUEST_ID
,      AS_OF_DATE
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      TAX_REFERENCE_NUM
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      TRANS_TYPE
,      TRX_NUMBER
,      TRANSACTION_DATE
,      TRX_CURRENCY_CODE
,      TRANS_AMOUNT
,      TRANS_AMOUNT_REMAINING
,      RECEIPT_AMOUNT
,      ADJUSTMENT_AMOUNT
,      EARNED_DISCOUNT_AMOUNT
,      UNEARNED_DISCOUNT_AMOUNT
,      INVOICE_CREDIT_AMOUNT
,      BANK_CHARGE
,      ON_ACCOUNT_CREDIT_AMOUNT
,      ON_ACCOUNT_RECEIPTS
,      UNAPPLIED_RECEIPTS
FROM AR.AR_CUSTOMER_BALANCE_ITF;

Dependencies

[top of page]

AR.AR_CUSTOMER_BALANCE_ITF does not reference any database object

AR.AR_CUSTOMER_BALANCE_ITF is referenced by following:

APPS: AR_CUSTOMER_BALANCE_ITF