TABLE DETAIL REFERENCE: Company
(Online 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 100TrueFalseFalseFalse%s
LegalCompanyName12 VARCHAR 100TrueFalseFalseFalse%s
AddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
AddressCity12 VARCHAR 255TrueFalseFalseFalse%s
AddressState12 VARCHAR 255TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
LegalAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
LegalAddressState12 VARCHAR 255TrueFalseFalseFalse%s
LegalAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
LegalAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr112 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr212 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr312 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr412 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerCity12 VARCHAR 255TrueFalseFalseFalse%s
CompanyAddressForCustomerState12 VARCHAR 255TrueFalseFalseFalse%s
CompanyAddressForCustomerPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
CompanyAddressForCustomerCountry12 VARCHAR 255TrueFalseFalseFalse%s
Phone12 VARCHAR 20TrueFalseFalseFalse%s
Email12 VARCHAR 100TrueFalseFalseFalse%s
CompanyEmailForCustomer12 VARCHAR 100TrueFalseFalseFalse%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
AccountantCopyExists-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountantCopyDividingDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD