TABLE DETAIL REFERENCE: Company
(USA VERSION)
| Id | 4 | INTEGER | 4 | True | False | False | False | FQID | |
| IsSampleCompany | -7 | BIT | 1 | True | False | False | False |
1
0
true
false
| |
| CompanyName | 12 | VARCHAR | 59 | True | False | False | False | %s | |
| LegalCompanyName | 12 | VARCHAR | 59 | True | False | False | False | %s | |
| AddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| AddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| AddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| AddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| AddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| AddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| AddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| LegalAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| LegalAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| LegalAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| LegalAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| LegalAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| LegalAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| LegalAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| LegalAddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| LegalAddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| LegalAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| LegalAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| LegalAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressForCustomerAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressForCustomerAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressForCustomerAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressForCustomerAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressForCustomerAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressForCustomerCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| CompanyAddressForCustomerState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| CompanyAddressForCustomerProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| CompanyAddressForCustomerCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| CompanyAddressForCustomerPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| CompanyAddressForCustomerCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| CompanyAddressForCustomerNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressBlockForCustomerAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressBlockForCustomerAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressBlockForCustomerAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressBlockForCustomerAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CompanyAddressBlockForCustomerAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| Phone | 12 | VARCHAR | 51 | True | False | False | False | %s | |
| Fax | 12 | VARCHAR | 51 | True | False | False | False | %s | |
| Email | 12 | VARCHAR | 99 | True | False | False | False | %s | |
| CompanyWebSite | 12 | VARCHAR | 128 | True | False | False | False | %s | |
| FirstMonthFiscalYear | 12 | VARCHAR | 9 | True | False | False | False |
January
February
March
April
May
June
July
August
September
October
November
December
| |
| FirstMonthIncomeTaxYear | 12 | VARCHAR | 9 | True | False | False | False |
January
February
March
April
May
June
July
August
September
October
November
December
| |
| CompanyType | 12 | VARCHAR | 255 | True | False | False | False | %s | |
| EIN | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| SSN | 12 | VARCHAR | 11 | True | False | False | False | %s | |
| TaxForm | 12 | VARCHAR | 11 | True | False | False | False |
Form1120
Form1120S
Form1065
Form990
Form990PF
Form990T
Form1040
OtherOrNone
| |
| BusinessNumber | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| SubscribedServicesServiceName | 12 | VARCHAR | 50 | True | False | False | False | %s | |
| SubscribedServicesServiceDomain | 12 | VARCHAR | 50 | True | False | False | False | %s | |
| SubscribedServicesServiceServiceStatus | 12 | VARCHAR | 10 | True | False | False | False |
Active
Expired
Never
Pending
Suspended
Terminated
Trial
| |
| AccountantCopyAccountantCopyExists | -7 | BIT | 1 | True | False | False | False |
1
0
true
false
| |
| AccountantCopyDividingDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
