FIELD NAME |
TYPE |
LENGTH |
QRY |
MOD |
INS |
REQ INS |
VALIDATE |
REL |
Id |
Integer |
13 |
True |
False |
False |
N/A |
FQID |
|
IsSampleCompany |
Bit |
5 |
True |
False |
False |
N/A |
1 0 true false |
|
CompanyName |
Varchar |
59 |
True |
False |
False |
N/A |
String |
|
LegalCompanyName |
Varchar |
59 |
True |
False |
False |
N/A |
String |
|
AddressAddr1 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressAddr2 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressAddr3 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressAddr4 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressAddr5 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressCity |
Varchar |
31 |
True |
False |
False |
N/A |
String |
|
AddressState |
Varchar |
21 |
True |
False |
False |
N/A |
String |
|
AddressPostalCode |
Varchar |
13 |
True |
False |
False |
N/A |
String |
|
AddressCountry |
Varchar |
31 |
True |
False |
False |
N/A |
String |
|
AddressNote |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressBlockAddr1 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressBlockAddr2 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressBlockAddr3 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressBlockAddr4 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
AddressBlockAddr5 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
LegalAddressAddr1 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
LegalAddressAddr2 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
LegalAddressAddr3 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
LegalAddressAddr4 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
LegalAddressAddr5 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
LegalAddressCity |
Varchar |
31 |
True |
False |
False |
N/A |
String |
|
LegalAddressState |
Varchar |
21 |
True |
False |
False |
N/A |
String |
|
LegalAddressPostalCode |
Varchar |
13 |
True |
False |
False |
N/A |
String |
|
LegalAddressCountry |
Varchar |
31 |
True |
False |
False |
N/A |
String |
|
LegalAddressNote |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerAddr1 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerAddr2 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerAddr3 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerAddr4 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerAddr5 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerCity |
Varchar |
31 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerState |
Varchar |
21 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerPostalCode |
Varchar |
13 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerCountry |
Varchar |
31 |
True |
False |
False |
N/A |
String |
|
CompanyAddressForCustomerNote |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressBlockForCustomerkAddr1 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressBlockForCustomerkAddr2 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressBlockForCustomerkAddr3 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressBlockForCustomerkAddr4 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
CompanyAddressBlockForCustomerkAddr5 |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
Phone |
Varchar |
51 |
True |
False |
False |
N/A |
String |
|
Fax |
Varchar |
51 |
True |
False |
False |
N/A |
String |
|
Email |
Varchar |
99 |
True |
False |
False |
N/A |
String |
|
CompanyWebSite |
Varchar |
128 |
True |
False |
False |
N/A |
String |
|
FirstMonthFiscalYear |
Varchar |
9 |
True |
False |
False |
N/A |
January February March April May June July August September October November December |
|
FirstMonthIncomeTaxYear |
Varchar |
9 |
True |
False |
False |
N/A |
January February March April May June July August September October November December |
|
CompanyType |
Varchar |
255 |
True |
False |
False |
N/A |
String |
|
EIN |
Varchar |
20 |
True |
False |
False |
N/A |
String |
|
SSN |
Varchar |
11 |
True |
False |
False |
N/A |
String |
|
TaxForm |
Varchar |
11 |
True |
False |
False |
N/A |
Form1120 Form1120S Form1065 Form990 Form990PF Form990T Form1040 OtherOrNone |
|