Organizations

List, Insert, Update, delete organizations

Table Specific Information

Select

The component will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the component.

OrganizationId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Organizations WHERE OrganizationId = '3350895000000089001'

Insert

Insert can be executed by specifying the Name, CurrencyCode, PortalName and TimeZone column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Organizations (Name, CurrencyCode, PortalName, TimeZone) VALUES ('Test', 'USD', 'newportal', 'PST')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Organizations SET Name = 'test2' WHERE OrganizationId = '3285934000000136008'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM Organizations WHERE OrganizationId = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
OrganizationId [KEY]	String	True		ID of the organisation generated by the server.
AccountCreatedDate	Date	True		Date of creation of the account.
Name	String	False		Name of the Organisation.
Address	String	False		Billing address of the organisation
CurrencyCode	String	False		Code of currency.
Country	String	True		Country of Organization.
IsLogoUploaded	String	True		Boolean to check if logo of the organisation if available.
UserRole	String	True		Role of the user(s).
DateFormat	String	False		Format of Date.
FieldSeparator	String	False		Separator used to classify fields.
UserStatus	String	True		Status of the user.
ContactName	String	True		Name of the contact person of the organisation.
IndustryType	String	False		Business type.
CurrencyFormat	String	True		Format of currency.
CurrencyId	String	True		Id of currency.
CurrencySymbol	String	True		Symbol of currency.
Email	String	True		email.
FiscalYearStartMonth	String	False		Starting month of teh financial year.
IsDefaultOrg	Boolean	True		IsDefaultOrg.
IsOrgActive	Boolean	True		IsOrgActive.
LanguageCode	String	False		Language for use.
PortalName	String	False		Poratal name for the organisation.
PlanName	String	True		PlanName.
PlanPeriod	String	True		PlanPeriod.
PlanType	Integer	True		PlanType.
PricePrecision	Integer	True		PricePrecision.
TaxGroupEnabled	Boolean	True		TaxGroupEnabled.
TimeZone	String	False		Time zone in with the organization is located geographically..
OrgAddress	String	False		Billing address of the organisation
RemitToAddress	String	False		Shipping address of the organisation
IndustrySize	String	True		The size of the industry. The possibe values could be The allowed values are small scale, medium scale, large scale.
ZiMigrationStatus	Integer	True		ZiMigrationStatus.
BusinessStartDate	Date	True		Start date of the business.
BusinessType	String	True		Type of business.
FiscalYearStartDate	Integer	True		Start date of the fiscal year.
IsPortalEnabled	Boolean	True		Whether the portal is enabled.
LogoUrl	String	True		URL of the organization logo.
PaymentsUrl	String	True		URL for payments.
RoleId	Long	True		ID of the role.
Status	String	True		Status of the organization.
TaxSettings	String	True		Tax settings for the organization.
WeightUnit	String	True		Default weight unit.
CanShowAuthenticationWarning	Boolean	True		Whether to show authentication warning.
CompanyIdentificationLabelsList	String	True		List of company identification labels.
CustomerLanguages	String	True		Customer languages.
DimensionUnit	String	True		Default dimension unit.
FirstName	String	True		First name of the user.
InventoryStartDate	Date	True		Start date of inventory tracking.
IsNewCustomerCustomFields	Boolean	True		Whether new customer custom fields are enabled.
IsOldEmailFlow	Boolean	True		Whether the old email flow is used.
IsProjectEnabled	Boolean	True		Whether projects are enabled.
IsPublicDomain	Boolean	True		Whether the domain is public.
IsRetainerinvoiceEnabled	Boolean	True		Whether retainer invoices are enabled.
IsSez	Boolean	True		Whether the organization is in a special economic zone.
LabelForCompanyId	String	True		Label for the company ID field.
LastName	String	True		Last name of the user.
PreviousInvoicingOption	String	True		Previous invoicing option.
PreviousProductOption	String	True		Previous product option.
PrimaryDomainName	String	True		Primary domain name.
StoreLogoUrl	String	True		URL of the store logo.
StoreUrl	String	True		URL of the store.
TaxBasis	String	True		Tax basis for the organization.
UnverifiedEmailsCount	Integer	True		Count of unverified emails.