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

TABLE: AR.AR_AUDIT_DATA

Object Details
Object Name: AR_AUDIT_DATA
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_AUDIT_DATA
Subobject Name:
Status: VALID


The AR_AUDIT_DATA table stores rows that are used by the rollforward process. The rollforward process is the process of taking the beginning balance of a period and then accounting for the transactions within that period by attempting to equate the beginning balance with the ending balance for the period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (3)
Identifies the source of the transaction
INVNUM VARCHAR2 (30)
The transaction number visible to user
AMOUNT NUMBER

The amount of the transaction
PAYMENT_SCHEDULE_ID NUMBER (15)
Identifies the payment schedule of the transaction
CLASS VARCHAR2 (20)
Identifies the class of the transaction (AM, PMT, INV, DM)
RECORD_ID NUMBER (15)
Foreign key to identify the transaction (CASH_RECEIPT_ID )
CUST_TRX_TYPE_ID NUMBER (15)
Identifies the transaction type defined by user
Query Text

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


SELECT SOURCE
,      INVNUM
,      AMOUNT
,      PAYMENT_SCHEDULE_ID
,      CLASS
,      RECORD_ID
,      CUST_TRX_TYPE_ID
FROM AR.AR_AUDIT_DATA;

Dependencies

[top of page]

AR.AR_AUDIT_DATA does not reference any database object

AR.AR_AUDIT_DATA is referenced by following:

SchemaAR
ViewAR_AUDIT_DATA#