EXM_CARDS
This table contains the corporate cards issued to individuals of the deploying company and the details of the corporate cards. Corporate cards can be Travel cards or Procurement cards.
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EXM_CARDS_PK |
CARD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CARD_ID | NUMBER | 18 | Yes | Unique identifier of a corporate card. | |
| PROGRAM_NAME | VARCHAR2 | 30 | Name of the process that created the corporate card. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Application that owns the process that created the corporate card. | ||
| PERSON_ID | NUMBER | 18 | Person identifier of the corporate card holder. | ||
| CARD_NUMBER | VARCHAR2 | 80 | Number assigned to a corporate card by the corporate card issuer. Stored only when the number is invalid. | ||
| CARD_REFERENCE_ID | NUMBER | 18 | Identifier of the corporate card in Oracle Fusion Payments. | ||
| CARDMEMBER_NAME | VARCHAR2 | 80 | Corporate card holder's name that is embossed on the corporate card. | ||
| LOCATION_ID | NUMBER | 18 | Not currently used. | ||
| MOTHERS_MAIDEN_NAME | VARCHAR2 | 80 | Not currently used. | ||
| DESCRIPTION | VARCHAR2 | 240 | Not currently used. | ||
| INACTIVE_DATE | DATE | Date from which the corporate card cannot be used. | |||
| CARD_EXPIRATION_DATE | DATE | Expiry date printed on the card which is the date from which the corporate card is no longer accepted. | |||
| CARD_PROGRAM_ID | NUMBER | 18 | Yes | Identifier of the corporate card program which is associated to the corporate card. | |
| COMPANY_ACCOUNT_ID | NUMBER | 18 | Identifier of the company account which is associated to the corporate card. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| MAX_PERIOD_AMOUNT | NUMBER | Maximum amount that can be charged to a card during the statement period. Applicable only for procurement cards. | |||
| TRX_LIMIT_AMOUNT | NUMBER | Maximum amount that can be charged to a corporate card for a single transaction. Applicable only for procurement cards. | |||
| CARD_STATUS_CODE | VARCHAR2 | 30 | Status of a corporate card at any given time, such as Active, Inactive, or Unassigned. | ||
| ACCOUNT_TYPE_CODE | VARCHAR2 | 30 | Type of corporate card, such as employee card and company card. | ||
| ACCOUNT_CATEGORY_CODE | VARCHAR2 | 30 | Category of a company card, such as centrally billed air travel card and centrally billed car rental card. | ||
| PROCESS_FILE_ID | NUMBER | 18 | Unique identifier of the upload process run on the transaction file. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| EXM_CARDS | per_persons | PERSON_ID |
| EXM_CARDS | exm_card_programs | CARD_PROGRAM_ID |
| EXM_CARDS | iby_creditcard | CARD_REFERENCE_ID |
| EXM_CARDS | exm_cc_company_accounts | COMPANY_ACCOUNT_ID |
| exm_card_holder_details | exm_cards | CARD_ID |
| exm_credit_card_trxns | exm_cards | CARD_ID |
| exm_card_usage | exm_cards | CARD_ID |
| exm_card_emp_candidates | exm_cards | CARD_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EXM_CARDS_N1 | Non Unique | Default | CARD_NUMBER |
| EXM_CARDS_N2 | Non Unique | Default | PERSON_ID |
| EXM_CARDS_N3 | Non Unique | Default | REQUEST_ID |
| EXM_CARDS_N4 | Non Unique | Default | CARD_REFERENCE_ID |
| EXM_CARDS_N5 | Non Unique | Default | TRUNC("CREATION_DATE") |
| EXM_CARDS_N6 | Non Unique | Default | CARD_PROGRAM_ID |
| EXM_CARDS_N7 | Non Unique | Default | COMPANY_ACCOUNT_ID |
| EXM_CARDS_N8 | Non Unique | Default | CARD_STATUS_CODE |
| EXM_CARDS_PK | Unique | Default | CARD_ID |