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: JA.JAI_AR_PAYMENT_AUDITS

Object Details

Object Name:	JAI_AR_PAYMENT_AUDITS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_AR_PAYMENT_AUDITS
Subobject Name:
Status:	VALID

This is the Audit/History table for ar_payment_schedules_all

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_PAYMENT_AUDITS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_AUDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_AUDIT_ID	NUMBER		Yes	Unique Identifier
CONCURRENT_REQ_NUM	NUMBER			Concurrent request number
PAYMENT_SCHEDULE_ID	NUMBER			Payment schedule unique identifier
CM_CUSTOMER_TRX_ID	NUMBER			Credit Memo customer transaction identifier
INVOICE_CUSTOMER_TRX_ID	NUMBER			Invoice customer transaction identifier
ORIGINAL_CUSTOMER_TRX_ID	NUMBER			Original customer transaction identifier
ADO_OLD	NUMBER			Old amount due original
TO_OLD	NUMBER			Old tax original
FO_OLD	NUMBER			Old freight original
AAPP_OLD	NUMBER			Old amount applied
ADR_OLD	NUMBER			Old amount due remaining
FR_OLD	NUMBER			Old freight remaining
TR_OLD	NUMBER			Old tax remaining
ACCTD_ADR_OLD	NUMBER			Old accounted amount due remaining
ACRED_OLD	NUMBER			Old amount Credited
ALIO_OLD	NUMBER			Old amount line items original
STATUS_OLD	VARCHAR2	(30)		Old Status
GL_DATE_CLOSED_OLD	DATE			Closed GL data
ACTUAL_DATE_CLOSED_OLD	DATE			Actual date closed
ADO_NEW	NUMBER			New amount due original
TO_NEW	NUMBER			New tax original
FO_NEW	NUMBER			New freight original
AAPP_NEW	NUMBER			New amount applied
ADR_NEW	NUMBER			New amount due remaining
TR_NEW	NUMBER			New tax remaining
FR_NEW	NUMBER			New freight remaining
ACCTD_ADR_NEW	NUMBER			New accounted amount due remaining
ACRED_NEW	NUMBER			New amount credited
ALIO_NEW	NUMBER			New amount line items original
STATUS_NEW	VARCHAR2	(30)		New Status
GL_DATE_CLOSED_NEW	DATE			New Closed GL date
ACTUAL_DATE_CLOSED_NEW	DATE			New actual date closed
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Request identifier
OBJECT_VERSION_NUMBER	NUMBER			Object version number

Query Text

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


SELECT PAYMENT_AUDIT_ID
,      CONCURRENT_REQ_NUM
,      PAYMENT_SCHEDULE_ID
,      CM_CUSTOMER_TRX_ID
,      INVOICE_CUSTOMER_TRX_ID
,      ORIGINAL_CUSTOMER_TRX_ID
,      ADO_OLD
,      TO_OLD
,      FO_OLD
,      AAPP_OLD
,      ADR_OLD
,      FR_OLD
,      TR_OLD
,      ACCTD_ADR_OLD
,      ACRED_OLD
,      ALIO_OLD
,      STATUS_OLD
,      GL_DATE_CLOSED_OLD
,      ACTUAL_DATE_CLOSED_OLD
,      ADO_NEW
,      TO_NEW
,      FO_NEW
,      AAPP_NEW
,      ADR_NEW
,      TR_NEW
,      FR_NEW
,      ACCTD_ADR_NEW
,      ACRED_NEW
,      ALIO_NEW
,      STATUS_NEW
,      GL_DATE_CLOSED_NEW
,      ACTUAL_DATE_CLOSED_NEW
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_PAYMENT_AUDITS;

Dependencies

[top of page]

JA.JAI_AR_PAYMENT_AUDITS does not reference any database object

JA.JAI_AR_PAYMENT_AUDITS is referenced by following:

APPS: JAI_AR_PAYMENT_AUDITS