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_CARD_PROGRAMS_ALL

Object Details

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

AP_CARD_PROGRAMS_ALL stores information about credit card programs you
define. Information stored in this table determines the records
selected for the consolidated credit card issuer invoice and
the supplier for whom the invoice is created.
.
This table corresponds to the Card Programs window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_CARD_PROGRAMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CARD_PROGRAM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CARD_PROGRAM_NAME	VARCHAR2	(80)	Yes	Credit card program name
CARD_PROGRAM_ID	NUMBER	(15)	Yes	Credit card program identifier
CARD_CODE_SET_ID	NUMBER	(15)		Credit card code set identifier
CARD_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Credit card type lookup code
CARD_PROGRAM_CURRENCY_CODE	VARCHAR2	(15)		Credit card program currency code
VENDOR_ID	NUMBER	(15)		Supplier identifier
VENDOR_SITE_ID	NUMBER	(15)		Supplier site identifier
EXCLUDE_UNVERIFIED_FLAG	VARCHAR2	(1)		Do not pay status indicator
EXCLUDE_PERSONAL_FLAG	VARCHAR2	(1)		Do not pay status indicator
EXCLUDE_DISPUTED_FLAG	VARCHAR2	(1)		Do not pay status indicator
EXCLUDE_REJECTED_FLAG	VARCHAR2	(1)		Do not pay status indicator
EXCLUDE_ACCT_EXCEPTION_FLAG	VARCHAR2	(1)		Do not pay status indicator
EXCLUDE_UNRECONCILED_FLAG	VARCHAR2	(1)		Do not pay status indicator
EXCLUDE_HELD_FLAG	VARCHAR2	(1)		Do not pay status indicator
EXCEPTION_CLEARING_CCID	NUMBER	(15)		Exception clearing GL Account Code Combination identifier
ADMIN_EMPLOYEE_ID	NUMBER	(15)		Credit card program administrator employee identifier
EXPOSURE_LIMIT_AMOUNT	NUMBER			Reserved for future use
DESCRIPTION	VARCHAR2	(240)		Description
ORG_ID	NUMBER	(15)		Organization identifier
INACTIVE_DATE	DATE			Inactive date
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
CARD_BRAND_LOOKUP_CODE	VARCHAR2	(25)		Credit card brand lookup code
AUTO_ITEMIZE_ENABLED_FLAG	VARCHAR2	(1)		Enable automatic itemization flag
CARD_EXP_TYPE_SOURCE_COL	VARCHAR2	(30)		Card expense type mapping source column
CARD_EXP_TYPE_MAP_TYPE_CODE	VARCHAR2	(30)		Card expense type mapping rule
COUNTRY_MAP_TYPE_CODE	VARCHAR2	(30)		Country mapping rule
CARD_EMP_MATCHING_RULE	VARCHAR2	(30)		Credit Card, employee matching rule
SYSADMIN_ROLE_NAME	VARCHAR2	(320)		Workflow role name of the system administrator
EXPENSE_CLEARING_CCID	NUMBER	(15)		Expense clearing GL Account Code Combination identifier
PAYMENT_DUE_FROM_CODE	VARCHAR2	(30)		Determines where the source of the payment to the credit card issuer
DETAIL_WAITING_DURATION	NUMBER			Maximum number of days for credit card acceptor to provide detail-level information.
LAST_DOWNLOAD_DATE	DATE			Date data file was last downloaded. (reserved for future use)
LAST_DOWNLOAD_SIZE	NUMBER			Size of last data file that was last downloaded. (reserved for future use)
AVERAGE_DOWNLOAD_SIZE	NUMBER			Average size of all data files downloaded. (reserved for future use)
DOWNLOAD_COUNT	NUMBER			Number of times data files were downloaded. (reserved for future use)
DATA_FEED_LEVEL_CODE	VARCHAR2	(30)		Indicates the level at which credit card data feed is received.
CARD_EXP_TYPE_DETAIL_MAP_CODE	VARCHAR2	(30)		Card expense type detail mapping rule

Query Text

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


SELECT CARD_PROGRAM_NAME
,      CARD_PROGRAM_ID
,      CARD_CODE_SET_ID
,      CARD_TYPE_LOOKUP_CODE
,      CARD_PROGRAM_CURRENCY_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      EXCLUDE_UNVERIFIED_FLAG
,      EXCLUDE_PERSONAL_FLAG
,      EXCLUDE_DISPUTED_FLAG
,      EXCLUDE_REJECTED_FLAG
,      EXCLUDE_ACCT_EXCEPTION_FLAG
,      EXCLUDE_UNRECONCILED_FLAG
,      EXCLUDE_HELD_FLAG
,      EXCEPTION_CLEARING_CCID
,      ADMIN_EMPLOYEE_ID
,      EXPOSURE_LIMIT_AMOUNT
,      DESCRIPTION
,      ORG_ID
,      INACTIVE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CARD_BRAND_LOOKUP_CODE
,      AUTO_ITEMIZE_ENABLED_FLAG
,      CARD_EXP_TYPE_SOURCE_COL
,      CARD_EXP_TYPE_MAP_TYPE_CODE
,      COUNTRY_MAP_TYPE_CODE
,      CARD_EMP_MATCHING_RULE
,      SYSADMIN_ROLE_NAME
,      EXPENSE_CLEARING_CCID
,      PAYMENT_DUE_FROM_CODE
,      DETAIL_WAITING_DURATION
,      LAST_DOWNLOAD_DATE
,      LAST_DOWNLOAD_SIZE
,      AVERAGE_DOWNLOAD_SIZE
,      DOWNLOAD_COUNT
,      DATA_FEED_LEVEL_CODE
,      CARD_EXP_TYPE_DETAIL_MAP_CODE
FROM AP.AP_CARD_PROGRAMS_ALL;

Dependencies

[top of page]

AP.AP_CARD_PROGRAMS_ALL does not reference any database object

AP.AP_CARD_PROGRAMS_ALL is referenced by following:

APPS: AP_CARD_PROGRAMS; AP_CARD_PROGRAMS_ALL