Type FinancialToAdvisor
Type category Entity
Description The relationship between a company's financial filing and its associated auditor or advisory firm for a given fiscal period, capturing the auditor name, company details, and calendar period to support audit trail and financial analysis.
Fields
Name Type Filters Description
key id string(36)* = The identifier that uniquely identifies each financial to advisor record, expressed as a string.
auditorName string(100) The name of the auditor or advisory firm associated with the financial filing.
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The batchRun that provided the data.
calendarQuarter long(1,4) The calendar quarter of the financial period to which this advisor relationship applies. Allowed values: 1 (Q1), 2 (Q2), 3 (Q3), 4 (Q4).
calendarYear long(1600,9999) The calendar year of the financial period to which this advisor relationship applies.
companyId long(-2147483648,2147483647) The S&P Cap IQ Company ID for the company that filed the financial statement.
companyIdAuditor long(-2147483648,2147483647) The S&P Cap IQ Company ID for the auditor company associated with the financial filing.
companyName string(100)* The name of the company that filed the financial statement.
financialToAdvisorId long(-2147483648,2147483647)* The native unique integer identifier for each financial to advisor record.
isDeleted boolean* Indicates that this record has been logically deleted and should no longer be considered active.
lastModifiedDate dateTime* The date and time when this record was last updated or modified in the source system.
latestFlag boolean* Indicates that this record represents the most recent advisor relationship for the company and financial period.
13 rows of 13 total
API Open API Specification