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_ACCEPTORS

Object Details

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

This table stores information about credit card acceptors who provide detail-level transaction information, such as itemized transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CARD_ACCEPTOR_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.
CARD_PROGRAM_ID	NUMBER	(15)	Yes	Foreign key to credit card program.
ACCEPTOR_NAME	VARCHAR2	(200)		Credit card acceptor name.
ACCEPTOR_STREET_ADDRESS	VARCHAR2	(240)		Credit card acceptor street address.
ACCEPTOR_CITY	VARCHAR2	(60)		Credit card acceptor city.
ACCEPTOR_STATE_PROVINCE	VARCHAR2	(60)		Credit card acceptor state or province.
ACCEPTOR_POSTAL_CODE	VARCHAR2	(60)		Credit card acceptor postal code.
ACCEPTOR_COUNTRY_CODE	VARCHAR2	(60)		Credit card acceptor ISO country code.
ACCEPTOR_BUSINESS_CODE	VARCHAR2	(100)		Credit card acceptor business code.
ACCEPTOR_TAXPAYER_NUMBER	VARCHAR2	(20)		Credit card acceptor taxpayer ID.
ACCEPTOR_VAT_NUMBER	VARCHAR2	(20)		Card acceptor VAT registration number.
ACCEPTOR_DUNS_NUMBER	VARCHAR2	(15)		Credit card acceptor duns number.
DETAIL_WAITING_DURATION	NUMBER		Yes	Maximum number of days for credit card acceptor to provide detail-level information.

Query Text

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


SELECT CARD_ACCEPTOR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CARD_PROGRAM_ID
,      ACCEPTOR_NAME
,      ACCEPTOR_STREET_ADDRESS
,      ACCEPTOR_CITY
,      ACCEPTOR_STATE_PROVINCE
,      ACCEPTOR_POSTAL_CODE
,      ACCEPTOR_COUNTRY_CODE
,      ACCEPTOR_BUSINESS_CODE
,      ACCEPTOR_TAXPAYER_NUMBER
,      ACCEPTOR_VAT_NUMBER
,      ACCEPTOR_DUNS_NUMBER
,      DETAIL_WAITING_DURATION
FROM AP.AP_CC_ACCEPTORS;

Dependencies

[top of page]

AP.AP_CC_ACCEPTORS does not reference any database object

AP.AP_CC_ACCEPTORS is referenced by following:

APPS: AP_CC_ACCEPTORS