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

TABLE: AR.OIR_PAYMENT_AUDIT

Object Details
Object Name: OIR_PAYMENT_AUDIT
Object Type: TABLE
Owner: AR
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OIR_PAYMENT_AUDIT_N1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_AUDIT_ID
Columns
Name Datatype Length Mandatory Comments
PAYMENT_AUDIT_ID NUMBER (15) Yes Unique identifier of payment transaction
PAYMENT_TYPE VARCHAR2 (50)
CUST_ACCOUNT_ID NUMBER (15) Yes
CUSTOMER_SITE_USE_ID NUMBER (15)
OIR_PAYMENT_STATUS VARCHAR2 (50)
Payment Transaction Status
CASH_RECEIPT_ID NUMBER (15)
RECEIPT_DATE DATE

RECEIPT_STATUS VARCHAR2 (30)
Explains where exactly the payment failed
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
AMOUNT NUMBER
Yes
INVOICES VARCHAR2 (4000) Yes
RESPONSIBILITY_ID NUMBER (15)
OPERATING_UNIT NUMBER (15)
TRANSACTIONID NUMBER

Payment System Order Number
Query Text

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


SELECT PAYMENT_AUDIT_ID
,      PAYMENT_TYPE
,      CUST_ACCOUNT_ID
,      CUSTOMER_SITE_USE_ID
,      OIR_PAYMENT_STATUS
,      CASH_RECEIPT_ID
,      RECEIPT_DATE
,      RECEIPT_STATUS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CURRENCY_CODE
,      AMOUNT
,      INVOICES
,      RESPONSIBILITY_ID
,      OPERATING_UNIT
,      TRANSACTIONID
FROM AR.OIR_PAYMENT_AUDIT;

Dependencies

[top of page]

AR.OIR_PAYMENT_AUDIT does not reference any database object

AR.OIR_PAYMENT_AUDIT is referenced by following:

SchemaAR
ViewOIR_PAYMENT_AUDIT#