| 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 |
|