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_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRX_DETAIL_ID
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	(15)		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.
LEG_NUMBER	VARCHAR2	(15)		Air travel Leg Number
DEPARTURE_DATE	DATE			Air travel Departure Date
DEPARTURE_CITY_CODE	VARCHAR2	(80)		Air travel Departure City Code
ARRIVAL_CITY_CODE	VARCHAR2	(80)		Air travel Arrival City Code
ARRIVAL_DATE	DATE			Air Travel Arrival Date
CARRIER_CODE	VARCHAR2	(30)		Air travel Carrier Code
SERVICE_CLASS_CODE	VARCHAR2	(30)		Air travel Service Class Code
FARE_BASIS_CODE	VARCHAR2	(30)		Air travel Fare Basis Code
STOPOVER_CODE	VARCHAR2	(30)		Air travel Stopover Code
DOMESTIC_FLAG	VARCHAR2	(1)		Air Travel Domestic Flag
CONJUNCTION_TICKET_NUMBER	VARCHAR2	(80)		Conjunction Ticket Number

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
,      LEG_NUMBER
,      DEPARTURE_DATE
,      DEPARTURE_CITY_CODE
,      ARRIVAL_CITY_CODE
,      ARRIVAL_DATE
,      CARRIER_CODE
,      SERVICE_CLASS_CODE
,      FARE_BASIS_CODE
,      STOPOVER_CODE
,      DOMESTIC_FLAG
,      CONJUNCTION_TICKET_NUMBER
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:

AP: AP_CC_TRX_DETAILS#