1. Tables and Views for Financials
  2. EXM_CC_AUTH_TRXNS

EXM_CC_AUTH_TRXNS

This table contains corporate card transaction authorization data from corporate card issuers.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

EXM_CC_AUTH_TRXNS_PK

TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSACTION_ID NUMBER 18 Yes Unique identifier of a corporate card transaction authorization.
CARD_BRAND_CODE VARCHAR2 30 Yes Name of the corporate card issuer.
PRE_AUTH_STATUS_CODE VARCHAR2 20 Code that indicates the state of the preauthorization, such as a normal preauthorization or an incremental preauthorization.
MESSAGE_SUB_TYPE_CODE VARCHAR2 20 Code that indicates the authorization request type, such as 0 for a normal request, 4 for a preauthorized request, 8 for account status inquiry service, and 9 for tokenization request or notification.
EXCHANGE_RATE NUMBER Conversion rate used by card issuer to convert from original currency to settlement currency.
CALL_REFERENCE_NUMBER VARCHAR2 240 Unique identifier of the card provider calling process.
COMPANY_NUMBER VARCHAR2 30 Corporate account number assigned by the corporate card issuer that uniquely identifes the company or its business unit.
AUTH_TRXN_NUMBER VARCHAR2 240 Yes Authorization identifier provided by the corporate card issuer.
TRANSACTION_TYPE_CODE VARCHAR2 30 The type of transaction provided such as Purchase, Mail Order or eCommerce.
TRANSACTION_DATE DATE Yes Date when the transaction occurred.
TRANSACTION_AMOUNT NUMBER Yes Amount charged at the time of transaction.
TRANSACTION_CURRENCY_CODE VARCHAR2 15 Yes Currency of the transaction amount.
DESCRIPTION VARCHAR2 240 The description for the corporate card charge.
MERCHANT_NAME VARCHAR2 240 Name of the merchant that submitted the authorization request.
CARD_ID NUMBER 18 Identifier of a corporate card.
LAST_SEGMENT VARCHAR2 30 Last segment (4-5 digits) of the card account number.
CARD_ACCOUNT_NUMBER VARCHAR2 80 SHA-256 hashed card account number.
TRANSACTION_STATUS VARCHAR2 30 Status of a transaction, such as Valid or Invalid.
NAME VARCHAR2 240 Corporate card holder's name that is embossed on the corporate card.
FIRST_NAME VARCHAR2 240 First name of the corporate card holder.
LAST_NAME VARCHAR2 240 Last name of the corporate card holder.
SERVICE_ESTABLISH_NUMBER VARCHAR2 80 Identifier of a merchant or service establishment.
MERCHANT_CATEGORY_CODE VARCHAR2 30 Code assigned to the merchant by the corporte card provider to classify the type of business.
PERSON_ID NUMBER 18 Identifier of a person who incurred the expense.
EMPLOYEE_NUMBER VARCHAR2 30 Number that uniquely identifies an employee within a company.
DOWNLOAD_STATUS VARCHAR2 1 Status indicating whether corporate card transaction authorization data is downloaded to a mobile device.
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.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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.
CC_NETWORK_REFERENCE_NUMBER VARCHAR2 240 Yes Unique identifier generated by the payment network for each corporate card authorization request.
MESSAGE_TYPE_CODE VARCHAR2 10 Code that identifies the type of authorization as authorization request or reversal request. Accepted values are 0100, 0120 and 0400.
AUTHORIZATION_AMOUNT NUMBER Amount approved  in the settlement currency designated by the card issuer.
AUTHORIZATION_CURRENCY_CODE VARCHAR2 15 Currency in which authorization was approved.
MERCHANT_STREET_NAME VARCHAR2 80 Street name where the merchant is located.
MERCHANT_IDENTIFIER VARCHAR2 30 Identifier of the merchant where the authorization originated.
MERCHANT_COUNTRY_CODE VARCHAR2 80 Country code where the merchant is located.
MERCHANT_CITY_NAME VARCHAR2 80 City where the merchant is located.
MERCHANT_STATE_PROVINCE_CODE VARCHAR2 80 State or province code where the merchant is located.
MERCHANT_POSTAL_CODE VARCHAR2 80 Zip or postal code where the merchant is located.
PROCESSOR_NUMBER VARCHAR2 30 Unique number assigned by the processor to bank issuing corporate cards.
CARD_ISSUER_REFERENCE_ID VARCHAR2 30 Number assigned by the payment processor that identifies a card issuer in the payment processor's system.
FINAL_AUTH_INDICATOR VARCHAR2 15 Indicates if it's a final authorization denoting there are no further incremental authorizations.
TRACE_IDENTIFIER VARCHAR2 240 An identifier that connects initial authorization, incremental authorization, and reversals. This is generated by the card issuer.
AUTH_EXP_NOTIFICATION_DATE DATE Date and time when the notification for the authorization expense was sent from Expenses.
AUTH_APPROVAL_CODE VARCHAR2 240 The authorization code provided by the corporate card issuer when a transaction is approved.
AUTHORIZATION_TIMESTAMP TIMESTAMP Date and time when the transaction authorization occurred at the merchant location.
EXPENSE_ID NUMBER 18 Unique identifier of a specific expense item.

Foreign Keys

Table Foreign Table Foreign Key Column
EXM_CC_AUTH_TRXNS exm_expenses EXPENSE_ID

Indexes

Index Uniqueness Tablespace Columns
EXM_CC_AUTH_TRXNS_N1 Non Unique Default AUTH_TRXN_NUMBER
EXM_CC_AUTH_TRXNS_N2 Non Unique Default PERSON_ID
EXM_CC_AUTH_TRXNS_N3 Non Unique Default CC_NETWORK_REFERENCE_NUMBER
EXM_CC_AUTH_TRXNS_N4 Non Unique Default EXPENSE_ID
EXM_CC_AUTH_TRXNS_PK Unique Default TRANSACTION_ID