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

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•