Merchant Company Relationships

Snowflake table name : CYBERSYN.MERCHANT_COMPANY_RELATIONSHIPS

View documentation here.

Name	Description	Type	Example
MERCHANT_ID	Unique identifier assigned by Cybersyn to each merchant.	VARCHAR	2b640777af42594722b0cf8b8d994a51
MERCHANT_NAME	The name of the merchant.	VARCHAR	HOLIDAY STATIONSTORES
COMPANY_ID	Unique identifier assigned by Cybersyn to each company. Joinable to the COMPANY_INDEX table.	VARCHAR	04416c4877f99c6e9b4af624aa3c1216
COMPANY_NAME	The name of the company.	VARCHAR	99 CENTS ONLY STORES LLC
IS_TOP_LEVEL_PARENT	Specifies if the company is the top level (i.e., ultimate) parent for the merchant. Takes on TRUE and FALSE values. For example, 'SAFEWAY INC' is the parent of merchant SAFEWAY (a supermarket chain) but 'ALBERTSONS COMPANIES, INC.', which owns 'SAFEWAY INC', is the top level parent of merchant SAFEWAY. Thus, 'SAFEWAY INC' would be FALSE but 'ALBERTSONS COMPANIES, INC.' would be TRUE in column IS_TOP_LEVEL_PARENT.	BOOLEAN	False
RELATIONSHIP_START_DATE	The beginning of a merchant being associated with the company. In cases where the start date is unknown, NULL is assigned.	DATE	N/A
RELATIONSHIP_END_DATE	The ending of the relationship being valid for the merchant and the company. In cases where a relationship is currently valid, an end date of NULL is assigned.	DATE	N/A