TABLE DETAIL REFERENCE: Company
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
Id4 INTEGER 4TrueFalseFalseFalseFQID
IsSampleCompany-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CompanyName12 VARCHAR 59TrueFalseFalseFalse%s
LegalCompanyName12 VARCHAR 59TrueFalseFalseFalse%s
AddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
AddressCity12 VARCHAR 31TrueFalseFalseFalse%s
AddressState12 VARCHAR 21TrueFalseFalseFalse%s
AddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
AddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
AddressNote12 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
LegalAddressState12 VARCHAR 21TrueFalseFalseFalse%s
LegalAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
LegalAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
LegalAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
LegalAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
LegalAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr112 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr212 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr312 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr412 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr512 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerCity12 VARCHAR 31TrueFalseFalseFalse%s
CompanyAddressForCustomerState12 VARCHAR 21TrueFalseFalseFalse%s
CompanyAddressForCustomerProvince12 VARCHAR 21TrueFalseFalseFalse%s
CompanyAddressForCustomerCounty12 VARCHAR 21TrueFalseFalseFalse%s
CompanyAddressForCustomerPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
CompanyAddressForCustomerCountry12 VARCHAR 31TrueFalseFalseFalse%s
CompanyAddressForCustomerNote12 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr112 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr212 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr312 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr412 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr512 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 51TrueFalseFalseFalse%s
Fax12 VARCHAR 51TrueFalseFalseFalse%s
Email12 VARCHAR 99TrueFalseFalseFalse%s
CompanyWebSite12 VARCHAR 128TrueFalseFalseFalse%s
FirstMonthFiscalYear12 VARCHAR 9TrueFalseFalseFalse
January
February
March
April
May
June
July
August
September
October
November
December
FirstMonthIncomeTaxYear12 VARCHAR 9TrueFalseFalseFalse
January
February
March
April
May
June
July
August
September
October
November
December
CompanyType12 VARCHAR 255TrueFalseFalseFalse%s
EIN12 VARCHAR 20TrueFalseFalseFalse%s
SSN12 VARCHAR 11TrueFalseFalseFalse%s
TaxForm12 VARCHAR 11TrueFalseFalseFalse
Form1120
Form1120S
Form1065
Form990
Form990PF
Form990T
Form1040
OtherOrNone
BusinessNumber12 VARCHAR 16TrueFalseFalseFalse%s
SubscribedServicesServiceName12 VARCHAR 50TrueFalseFalseFalse%s
SubscribedServicesServiceDomain12 VARCHAR 50TrueFalseFalseFalse%s
SubscribedServicesServiceServiceStatus12 VARCHAR 10TrueFalseFalseFalse
Active
Expired
Never
Pending
Suspended
Terminated
Trial
AccountantCopyAccountantCopyExists-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountantCopyDividingDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD