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: ONT.OE_PAYMENTS_HISTORY

Object Details

Object Name:	OE_PAYMENTS_HISTORY
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_PAYMENTS_HISTORY
Subobject Name:
Status:	VALID

Table to store payment audit trail.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_PAYMENTS_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HIST_CREATION_DATE HEADER_ID LINE_ID PAYMENT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_LEVEL_CODE	VARCHAR2	(30)	Yes	Payment Level Code,either Header or Line
HEADER_ID	NUMBER		Yes	Foreign key reference to oe_order_headers_all
LINE_ID	NUMBER			Foreign key reference to oe_order_lines_all
PAYMENT_TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code for oe_payment_type
PAYMENT_TRX_ID	NUMBER			Foreign key reference to ap_bank_accounts_all or ra_customer_trx_all
PAYMENT_SET_ID	NUMBER			Foreign key reference to AR to uniquely identify receipts created for an order
PAYMENT_NUMBER	NUMBER		Yes	System generated number to uniquely identify payments within an order header or an order line
RECEIPT_METHOD_ID	NUMBER			Foreign key reference to ar_receipt_methods
PAYMENT_COLLECTION_EVENT	VARCHAR2	(30)		Lookup code for oe_payment_collection_event
PREPAID_AMOUNT	NUMBER			Net amount successfully created for an order
COMMITMENT_APPLIED_AMOUNT	NUMBER			Commitment promised amount
COMMITMENT_INTERFACED_AMOUNT	NUMBER			Commitment amount interfaced to AR
CREDIT_CARD_CODE	VARCHAR2	(80)		Lookup code for credit card such as Visa, Master Card,etc
CREDIT_CARD_NUMBER	VARCHAR2	(80)		Credit card number
CREDIT_CARD_HOLDER_NAME	VARCHAR2	(80)		Credit card holder name
CREDIT_CARD_EXPIRATION_DATE	DATE			Credit card expiration date
CREDIT_CARD_APPROVAL_CODE	VARCHAR2	(80)		Credit card approval code
CREDIT_CARD_APPROVAL_DATE	DATE			Credit card approval date
TANGIBLE_ID	VARCHAR2	(80)		System generated number to uniquely identify a transaction in iPayment
CHECK_NUMBER	VARCHAR2	(50)		Check number for payment type Check
PAYMENT_AMOUNT	NUMBER			Amount of payment (to be) processed
REASON_CODE	VARCHAR2	(30)		Reason code for change
HIST_COMMENTS	VARCHAR2	(2000)		Comments for payment attributes changed
HIST_TYPE_CODE	VARCHAR2	(30)	Yes	Type of transaction for which history was created
HIST_CREATION_DATE	DATE			Date on which audit history is created
HIST_CREATED_BY	NUMBER			Standard Who column
RESPONSIBILITY_ID	NUMBER			Standard Who column
LOCK_CONTROL	NUMBER			For internal use only
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Concurrent request that last changed row
PROGRAM_APPLICATION_ID	NUMBER			Application of concurrent program that last updated row
PROGRAM_ID	NUMBER			Concurrent program that last changed row
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield segment
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment

Query Text

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


SELECT PAYMENT_LEVEL_CODE
,      HEADER_ID
,      LINE_ID
,      PAYMENT_TYPE_CODE
,      PAYMENT_TRX_ID
,      PAYMENT_SET_ID
,      PAYMENT_NUMBER
,      RECEIPT_METHOD_ID
,      PAYMENT_COLLECTION_EVENT
,      PREPAID_AMOUNT
,      COMMITMENT_APPLIED_AMOUNT
,      COMMITMENT_INTERFACED_AMOUNT
,      CREDIT_CARD_CODE
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      CREDIT_CARD_APPROVAL_DATE
,      TANGIBLE_ID
,      CHECK_NUMBER
,      PAYMENT_AMOUNT
,      REASON_CODE
,      HIST_COMMENTS
,      HIST_TYPE_CODE
,      HIST_CREATION_DATE
,      HIST_CREATED_BY
,      RESPONSIBILITY_ID
,      LOCK_CONTROL
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM ONT.OE_PAYMENTS_HISTORY;

Dependencies

[top of page]

ONT.OE_PAYMENTS_HISTORY does not reference any database object

ONT.OE_PAYMENTS_HISTORY is referenced by following:

ONT: OE_PAYMENTS_HISTORY#