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: TableAR.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: TablespaceAPPS_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:

SchemaAPPS
SynonymAR_CUSTOMER_BALANCE_ITF