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: AP.AP_CC_TRX_DETAILS

Object Details

Object Name:	AP_CC_TRX_DETAILS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_CC_TRX_DETAILS
Subobject Name:
Status:	VALID

This table stores detail-level credit card transaction information from the credit card acceptors that provide it. This information is used to create itemized expense reports.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_CC_TRX_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRX_DETAIL_ID	NUMBER	(15)	Yes	Unique ID.
LAST_UPDATE_DATE	DATE		Yes	AOL who column for last update date.
LAST_UPDATED_BY	NUMBER	(15)	Yes	AOL who column for LAST UPDATED BY.
LAST_UPDATE_LOGIN	NUMBER	(15)		AOL who column for LAST UPDATE LOGIN.
CREATION_DATE	DATE		Yes	AOL who column for CREATION DATE.
CREATED_BY	NUMBER	(15)	Yes	AOL who column for CREATED BY.
TRX_ID	NUMBER	(15)	Yes	Foreign key to credit card transaction.
TRANSACTION_AMOUNT	NUMBER			Transaction amount in the local currency of detail-level credit card transactions.
BILLED_AMOUNT	NUMBER			Billed amount in the billed currency of detail-level credit card transactions.
EXT_FOLIO_TYPE	VARCHAR2	(80)		Folio type that the credit card acceptor provides for detail-level credit card transactions.
FOLIO_TYPE	VARCHAR2	(80)		Folio type that OIE uses for detail-level transactions.
ITEM_SEQ_NUMBER	VARCHAR2	(5)		Sequence number for detail-level credit card transactions.
ITEM_DESCRIPTION	VARCHAR2	(240)		Description of item for detailed transaction.
TRANSACTION_DATE	DATE			Transaction date of item for detailed transaction.

Query Text

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


SELECT TRX_DETAIL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      TRX_ID
,      TRANSACTION_AMOUNT
,      BILLED_AMOUNT
,      EXT_FOLIO_TYPE
,      FOLIO_TYPE
,      ITEM_SEQ_NUMBER
,      ITEM_DESCRIPTION
,      TRANSACTION_DATE
FROM AP.AP_CC_TRX_DETAILS;

Dependencies

[top of page]

AP.AP_CC_TRX_DETAILS does not reference any database object

AP.AP_CC_TRX_DETAILS is referenced by following:

APPS: AP_CC_TRX_DETAILS