Company Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
Id 4 INTEGER 4 True False False False FQID 1.0 US, CA, UK
IsSampleCompany -7 BIT 2 True False False False
1
0
true
false
 3.0 US, CA, UK
CompanyName 12 VARCHAR 59 True False False False %s 1.0 US, CA, UK
LegalCompanyName 12 VARCHAR 59 True False False False %s 1.0 US, CA, UK
Address_Addr1 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
Address_Addr2 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
Address_Addr3 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
Address_Addr4 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
Address_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Address_City 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
Address_State 12 VARCHAR 21 True False False False %s 1.0 US, CA, UK
Address_PostalCode 12 VARCHAR 13 True False False False %s 1.0 US, CA, UK
Address_Country 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
Address_Note 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Address_BlockAddr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Address_BlockAddr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Address_BlockAddr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Address_BlockAddr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Address_BlockAddr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
LegalAddress_Addr1 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
LegalAddress_Addr2 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
LegalAddress_Addr3 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
LegalAddress_Addr4 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
LegalAddress_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
LegalAddress_City 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
LegalAddress_State 12 VARCHAR 21 True False False False %s 1.0 US, CA, UK
LegalAddress_PostalCode 12 VARCHAR 13 True False False False %s 1.0 US, CA, UK
LegalAddress_Country 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
LegalAddress_Note 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
CompanyAddress_ForCustomer_Addr1 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
CompanyAddress_ForCustomer_Addr2 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
CompanyAddress_ForCustomer_Addr3 12 VARCHAR 41 True False False False %s 1.0 US, CA, UK
CompanyAddress_ForCustomer_Addr4 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
CompanyAddress_ForCustomer_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
CompanyAddress_ForCustomer_City 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
CompanyAddress_ForCustomer_State 12 VARCHAR 21 True False False False %s 1.0 US, CA, UK
CompanyAddress_ForCustomer_PostalCode 12 VARCHAR 13 True False False False %s 1.0 US, CA, UK
CompanyAddress_ForCustomer_Country 12 VARCHAR 31 True False False False %s 1.0 US, CA, UK
CompanyAddress_ForCustomer_Note 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
CompanyAddress_BlockForCustomer_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
CompanyAddress_BlockForCustomer_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
CompanyAddress_BlockForCustomer_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
CompanyAddress_BlockForCustomer_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
CompanyAddress_BlockForCustomer_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Phone 12 VARCHAR 51 True False False False %s 1.0 US, CA, UK
Fax 12 VARCHAR 51 True False False False %s 1.0 US, CA, UK
Email 12 VARCHAR 1023 True False False False %s 1.0 US, CA, UK
CompanyWebSite 12 VARCHAR 128 True False False False %s 1.0 US, CA, UK
FirstMonthFiscalYear 12 VARCHAR 9 True False False False
January
February
March
April
May
June
July
August
September
October
November
December
 1.0 US, CA, UK
FirstMonthIncomeTaxYear 12 VARCHAR 9 True False False False
January
February
March
April
May
June
July
August
September
October
November
December
 1.0 US, CA, UK
CompanyType 12 VARCHAR 255 True False False False %s 1.0 US, CA, UK
EIN 12 VARCHAR 20 True False False False %s 2.0 US, CA, UK
SSN 12 VARCHAR 11 True False False False %s 2.1 US, CA, UK
TaxForm 12 VARCHAR 11 True False False False
Form1120
Form1120S
Form1065
Form990
Form990PF
Form990T
Form1040
OtherOrNone
 2.1 US, CA, UK
BusinessNumber 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
AccountantCopy_AccountantCopyExists -7 BIT 2 True False False False
1
0
true
false
 8.0 US, CA, UK
AccountantCopy_DividingDate 91 DATE 10 True False False False CCCC-MM-DD 8.0 US, CA, UK