1. Tables and Views for Financials
  2. EXM_MATCHING_HISTORY

EXM_MATCHING_HISTORY

This table contains the expense status, starting from creation to automatic sweep.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

EXM_MATCHING_HISTORY_PK

MATCHING_HISTORY_ID

Columns

Name Datatype Length Precision Not-null Comments
MATCHING_HISTORY_ID NUMBER 18 Yes Identifier of events recorded in the table.
PERSON_ID NUMBER 18 Yes Person identifier of the individual on the corporate card.
EVENT_TYPE_CODE VARCHAR2 30 Yes Type of event, whether creation, matching, or submission.
EVENT_SOURCE_CODE VARCHAR2 30 Yes Source of the event, whether bot creation, bot update, resolution of potential matches, during the hourly matching process, after manual expense submission, or during the automatic submission process.
SOURCE_OBJECT_CODE VARCHAR2 30 Code to identify if the expense being matched is sourced from a vendor expense or from an existing expense.
EVENT_START_TIME TIMESTAMP Yes The time when the event started.
MATCHED_RULE_NAME VARCHAR2 240 Name of rule the expense was matched against, whether an auth transaction number, a receipt, an amount, or a merchant.
MATCHING_OUTCOME VARCHAR2 240 Results generated from matching digital expenses to card or authorization expenses while detecting duplicates.
RECEIPT_AMOUNT_MATCH_RULE VARCHAR2 240 Rule name using which the score is generated for Receipt Amount.
RECEIPT_DATE_MATCH_RULE VARCHAR2 240 Rule name using which the score is generated for Receipt Date.
RECEIPT_CURRENCY_MATCH_RULE VARCHAR2 240 Rule name using which the score is generated for Receipt Currency.
EXPENSE_TYPE_MATCH_RULE VARCHAR2 240 Rule name using which the score is generated for Expense Type.
EXPENSE_TYPE_CAT_MATCH_RULE VARCHAR2 240 Rule name using which the score is generated for Expense Type Category.
MERCHANT_NAME_MATCH_RULE VARCHAR2 240 Rule name using which the score is generated for Merchant Name.
RECEIPT_AMOUNT_MATCH_SCORE NUMBER Score of an uploaded digital assistant expense item's receipt amount that matches a corporate card transaction's transaction amount.
RECEIPT_DATE_MATCH_SCORE NUMBER Score of an uploaded digital assistant expense item's receipt date that matches a corporate card transaction's transaction date.
RECEIPT_CURRENCY_MATCH_SCORE NUMBER Score of an uploaded digital assistant expense item's receipt currency that matches a corporate card transaction's transaction currency.
EXPENSE_TYPE_MATCH_SCORE NUMBER Score of an uploaded digital assistant expense item's expense type that matches a corporate card transaction's expense type.
EXPENSE_TYPE_CAT_MATCH_SCORE NUMBER Score of an uploaded digital assistant expense item's expense type category that matches a corporate card transaction's expense type category.
MERCHANT_NAME_MATCH_SCORE NUMBER Score of an uploaded digital assistant expense item's merchant name that matches a corporate card transaction's merchant name.
LOCATION_MATCH_SCORE NUMBER Score generated by matching the location during duplicate expense detection.
DISTANCE_MATCH_SCORE NUMBER Score generated by matching the distance during duplicate expense detection.
DISTANCE_UNIT_MATCH_SCORE NUMBER Score generated by matching the distance unit during duplicate expense detection.
RECEIPT_TIME_MATCH_SCORE NUMBER Score generated by matching the receipt time during duplicate expense detection.
END_DATE_MATCH_SCORE NUMBER Score generated by matching the end date during duplicate expense detection.
APPROVAL_CODE_MATCH_SCORE NUMBER Score generated by matching the approval status code during duplicate detection.
TOTAL_MATCH_SCORE NUMBER Total score of an uploaded digital assistant expense item that matches a corporate card transaction.
MERGED_FLAG VARCHAR2 1 Option that indicates whether an expense item created from a digital assistant is already merged with an expense item created from a corporate card transaction.
GROUP_ID NUMBER 18 Identifies the group of duplicate expenses.
ANCHOR_EXPENSE_ID NUMBER 18 Identifies the anchor expense within a group of duplicate expenses.
ANCHOR_RANK NUMBER 18 Indicates the priority of anchors within a group of duplicate expenses.
DA_EXPENSE_ID NUMBER 18 Identifier of the expense item that was created from the digital assistant.
DA_AUTH_TRXN_NUMBER VARCHAR2 240 Credit card transaction authorization code captured by the digital assistant. The value is obtained from the credit card charge.
DA_RECEIPT_AMOUNT NUMBER Digital Assistant receipt amount in the receipt currency.
DA_RECEIPT_CURRENCY_CODE VARCHAR2 15 Receipt currency of a digital assistant expense item.
DA_MERCHANT_NAME VARCHAR2 80 Merchant where the expense was incurred, which was captured by the digital assistant.
DA_START_DATE DATE Date when the expense occurred or the first day of an expense that spans multiple days.
DA_END_DATE DATE Last day of the Digital Assistant expense, if it spans multiple days.
DA_APPROVAL_CODE VARCHAR2 240 Approval code for the Digital Assistant expense.
DA_EXPENSE_TYPE_CATEGORY_CODE VARCHAR2 30 Group of expense types and additional data fields for similar expenses. For example, the airfare group to include information such as class of fare, merchant, ticket number, and so on.
DA_CREATION_METHOD_CODE VARCHAR2 30 Method of expense item creation, such as mobile iOS device or mobile Android device.
DA_REPORT_ID NUMBER 18 Identifier of an expense report type related to a digital assistant expense.
DA_EXPENSE_TYPE_ID NUMBER 18 Identifier of an expense type related to a digital assistant expense.
DA_TYPE_KEYWORDS VARCHAR2 240 The keywords returned by IDR that are used to narrow down the expense type.
CC_EXPENSE_ID NUMBER 18 Identifier of the expense item created from a corporate card transaction.
CC_AUTH_TRXN_NUMBER VARCHAR2 240 Authorization transaction number provided by the corporate card issuer.
CC_RECEIPT_AMOUNT NUMBER Credit card expense amount of the receipt in the receipt currency.
CC_RECEIPT_CURRENCY_CODE VARCHAR2 15 Receipt currency of a credit card expense item.
CC_MERCHANT_NAME VARCHAR2 80 Merchant where the expense was incurred.
CC_START_DATE DATE Date when the Corporate Card expense occurred or the first day of an expense that spans multiple days.
CC_END_DATE DATE Last day of the Corporate Card expense, if it spans multiple days.
CC_TRANSACTION_DATE DATE Date when the credit card transaction occurred.
CC_APPROVAL_CODE VARCHAR2 240 Approval code for the Corporate Card expense.
CC_EXPENSE_TYPE_CATEGORY_CODE VARCHAR2 30 Classification of an expense item such as business or personal.
CC_EXPENSE_TYPE_ID NUMBER 18 Identifier of expense type in a credit card expense.
CC_CREATION_METHOD_CODE VARCHAR2 30 Method of expense item creation, such as mobile iOS device or mobile Android device.
CC_AIR_DEPARTURE_DATE DATE Departure date for the first leg of a multiple leg trip.
CC_HOTEL_DEPART_DATE DATE Departure date from a hotel for a credit card expense.
CC_HOTEL_ARRIVAL_DATE DATE Check-in date at hotel or scheduled arrival date in case of a no show.
CC_CAR_RETURN_DATE DATE Credit card expense date in which the car was returned.
CC_CAR_RENTAL_DATE DATE Credit card expense date in which the car was first rented.
CC_REPORT_ID NUMBER 18 Identifier of an expense report for credit card expenses.
CC_ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
CC_ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
CC_ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
CC_ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
CC_ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
CC_ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
CC_ATTRIBUTE_DATE1 DATE Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
CC_ATTRIBUTE_DATE2 DATE Descriptive Flexfield: Segment of the user descriptive flexfield for credit card expense item.
SOURCE_ATTRIBUTE_NAME1 VARCHAR2 240 Extensible column to capture the source attribute name for a custom configured similarity rule.
SOURCE_ATTRIBUTE_NAME2 VARCHAR2 240 Extensible column to capture the source attribute name for a custom configured similarity rule.
SOURCE_ATTRIBUTE_NAME3 VARCHAR2 240 Extensible column to capture the source attribute name for a custom configured similarity rule.
SOURCE_ATTRIBUTE_NAME4 VARCHAR2 240 Extensible column to capture the source attribute name for a custom configured similarity rule.
SOURCE_ATTRIBUTE_NAME5 VARCHAR2 240 Extensible column to capture the source attribute name for a custom configured similarity rule.
TARGET_ATTRIBUTE_NAME1 VARCHAR2 240 Extensible column to capture the target attribute name for a custom configured similarity rule.
TARGET_ATTRIBUTE_NAME2 VARCHAR2 240 Extensible column to capture the target attribute name for a custom configured similarity rule.
TARGET_ATTRIBUTE_NAME3 VARCHAR2 240 Extensible column to capture the target attribute name for a custom configured similarity rule.
TARGET_ATTRIBUTE_NAME4 VARCHAR2 240 Extensible column to capture the target attribute name for a custom configured similarity rule.
TARGET_ATTRIBUTE_NAME5 VARCHAR2 240 Extensible column to capture the target attribute name for a custom configured similarity rule.
SIMILARITY_RULE1 VARCHAR2 240 Extensible column to capture the rule name based on which the source and target attributes are considered similar.
SIMILARITY_RULE2 VARCHAR2 240 Extensible column to capture the rule name based on which the source and target attributes are considered similar.
SIMILARITY_RULE3 VARCHAR2 240 Extensible column to capture the rule name based on which the source and target attributes are considered similar.
SIMILARITY_RULE4 VARCHAR2 240 Extensible column to capture the rule name based on which the source and target attributes are considered similar.
SIMILARITY_RULE5 VARCHAR2 240 Extensible column to capture the rule name based on which the source and target attributes are considered similar.
SIMILARITY_SCORE1 NUMBER Extensible column to capture the score based on which the source and target attributes are considered similar.
SIMILARITY_SCORE2 NUMBER Extensible column to capture the score based on which the source and target attributes are considered similar.
SIMILARITY_SCORE3 NUMBER Extensible column to capture the score based on which the source and target attributes are considered similar.
SIMILARITY_SCORE4 NUMBER Extensible column to capture the score based on which the source and target attributes are considered similar.
SIMILARITY_SCORE5 NUMBER Extensible column to capture the score based on which the source and target attributes are considered similar.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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.

Indexes

Index Uniqueness Tablespace Columns
EXM_MATCHING_HISTORY_N1 Non Unique Default PERSON_ID
EXM_MATCHING_HISTORY_PK Unique Default MATCHING_HISTORY_ID