MERCHANT CATEGORY Table
View exposing merchant-category reference data including merchant category code, description, active indicator, and last-update audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_ACTIVE_MERCHANT |
Indicator identifying whether active merchant (Y/N). |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user associated with the record. |
VARCHAR2 |
12 |
MERCHANT_CATEGORY |
Merchant category associated with the record. |
VARCHAR2 |
60 |
MERCHANT_CATEGORY_CODE |
Code identifying merchant category. |
VARCHAR2 |
4 |
MERCHANT_CATEGORY_KEY |
Surrogate key identifying the merchant category. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |