Type CompanyRelationships
Type category Entity
Description The CompanyRelationships table contains data for MMD company relationships.
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
categoryCode long Category code of the Firm.
categoryName string(150) Category name of the Firm.
link company Company MMD Company id, foreign key that links to the Company entity.
companyName string(120) Company Name of the Firm.
datasetName string(50) Name of the dataset for the entity.
link relatedCompany Company MMD company id of the related Firm, this is a foreign key that links to the Company entity.
relatedCompanyCategoryCode long Category code of the related Firm.
relatedCompanyCategoryName string(150) Category name of the related Firm.
relatedCompanyDescription string(160) Description of the relation type.
relatedCompanyName string(120) Company Name of the related Firm.
relatedCompanyType string(6) Relation Type of the related Firm.
updateDate dateTime Most recent update status of company relationship.
15 rows of 15 total
API Open API Specification