CompanyVendors
Return a list of all Vendors associated with a Company.
Columns
| Name | Type | References | |
| CompanyId | Integer |
Companies.Id | |
| Id [KEY] | Integer | ||
| Name | String | ||
| IsActive | Boolean | ||
| Company | String | ||
| EmailAddress | String | ||
| AbbreviatedName | String | ||
| Address | String | ||
| Attachments | String | ||
| AuthorizedBidder | Boolean | ||
| BiddingAffirmativeAction | Boolean | ||
| BiddingAfricanAmericanBusiness | Boolean | ||
| BiddingAsianAmericanBusiness | Boolean | ||
| BiddingCertifiedBusinessEnterprise | Boolean | ||
| BiddingDisadvantagedBusiness | Boolean | ||
| BiddingEightABusiness | Boolean | ||
| BiddingHispanicBusiness | Boolean | ||
| BiddingHistoricallyUnderutilizedBusiness | Boolean | ||
| BiddingMinorityBusinessEnterprise | Boolean | ||
| BiddingNativeAmericanBusiness | Boolean | ||
| BiddingSdvoBusiness | Boolean | ||
| BiddingSmallBusiness | Boolean | ||
| BiddingWomensBusiness | Boolean | ||
| BiddingDistribution | String | ||
| BusinessPhone | String | ||
| BusinessRegisterId | Integer | ||
| BusinessRegisterIdentifier | String | ||
| BusinessRegisterType | String | ||
| BusinessRegisterVerificationStatus | String | ||
| BusinessRegisterVerifiedAt | Datetime | ||
| ChildrenCount | Integer | ||
| City | String | ||
| StateCode | String | ||
| Zip | Integer | ||
| CountryCode | String | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime | ||
| FaxNumber | String | ||
| ContactCount | Integer | ||
| LaborUnion | String | ||
| LegalName | String | ||
| LicenseNumber | String | ||
| Logo | String | ||
| MobilePhone | String | ||
| NonUnionPrevailingWage | Boolean | ||
| Notes | String | ||
| OriginCode | String | ||
| OriginData | String | ||
| OriginId | String | ||
| ParentId | Integer | ||
| ParentName | String | ||
| Prequalified | Boolean | ||
| PrimaryContactBusinessPhone | String | ||
| PrimaryContactBusinessPhoneExtension | Integer | ||
| PrimaryContactCreatedAt | Datetime | ||
| PrimaryContactEmailAddress | String | ||
| PrimaryContactFaxNumber | String | ||
| PrimaryContactFirstName | String | ||
| PrimaryContactId | Integer | ||
| PrimaryContactLastName | String | ||
| PrimaryContactMobilePhone | String | ||
| PrimaryContactUpdatedAt | Datetime | ||
| ProjectIds | String | ||
| StandardCostCodes | String | ||
| SyncedToErp | Boolean | ||
| TradeName | String | ||
| Trades | String | ||
| UnionMember | Boolean | ||
| VendorGroupId | Integer | ||
| VendorGroupName | String | ||
| Website | String |