`Organization` table

Column Type

Column	Type
`Organization_Id`	`String`
`Name`	`String`
`Contact_Name`	`String`
`Email`	`String`
`Is_Default_Org`	`Boolean`
`Language_Code`	`String`
`Fiscal_Year_Start_Month`	`String`
`Account_Created_Date`	`Date`
`Time_Zone`	`String`
`Is_Org_Active`	`Boolean`
`Currency_Id`	`String`
`Currency_Code`	`String`
`Currency_Symbol`	`String`
`Currency_Format`	`String`
`Price_Precision`	`Number`
`Is_Retainerinvoice_Enabled`	`Boolean`
`Previous_Invoicing_Option`	`String`
`Role_Id`	`String`
`Custom_Field_Type`	`Number`
`Weight_Unit`	`String`
`User_Role`	`String`
`Is_Sez`	`Boolean`
`Business_Type`	`String`
`Is_Trial_Period_Extended`	`Boolean`
`Is_Portal_Enabled`	`Boolean`
`Logo_Url`	`String`
`Date_Format`	`String`
`Store_Logo_Url`	`String`
`Field_Separator`	`String`
`Is_Estimate_Enabled`	`Boolean`
`Is_Public_Domain`	`Boolean`
`Primary_Domain_Name`	`String`
`Can_Show_Authentication_Warning`	`Boolean`
`Remit_To_Address`	`String`
`Tax_Id_Label`	`String`
`Fiscal_Year_Start_Date`	`Number`
`Service_User_Number`	`String`
`Is_Free_Zone`	`Boolean`
`Industry_Type`	`String`
`Industry_Size`	`String`
`Is_Designated_Zone`	`Boolean`
`Is_Project_Enabled`	`Boolean`
`Previous_Product_Option`	`String`
`Company_Id_Label`	`String`
`Store_Url`	`String`
`Company_Id_Value`	`String`
`Tax_Basis`	`String`
`Is_New_Customer_Custom_Fields`	`Boolean`
`Tax_Id_Value`	`String`
`Version`	`String`
`Unverified_Emails_Count`	`Number`
`Fax`	`String`
`Status`	`String`
`Is_Registered_For_Gst`	`Boolean`
`Address_Country`	`String`
`Address_Street_Address1`	`String`
`Address_City`	`String`
`Address_Street_Address2`	`String`
`Address_Longitude`	`String`
`Address_State`	`String`
`Address_State_Code`	`String`
`Address_Zip`	`String`
`Address_Latitude`	`String`
`Tax_Settings_Tax_Reg_No`	`String`
`Tax_Settings_Is_Tax_Registered`	`Boolean`
`Tax_Settings_Tax_Registered_Date`	`String`
`Tax_Settings_Tax_Reg_No_Label`	`String`
`Tax_Settings_International_Trade_Enabled`	`String`
`Tax_Settings_Flat_Rate_Scheme`	`String`
`Tax_Settings_Flat_Rate_Percentage`	`String`
`Tax_Settings_Tax_Return_Start_Date`	`String`
`Phone`	`String`
`Org_Address`	`String`
`Website`	`String`
`Dimension_Unit`	`String`
`Is_Late_Fee_Disabled`	`Boolean`
`Portal_Name`	`String`
`Is_Purchaseorder_Enabled`	`Boolean`
`Is_Salesorder_Enabled`	`Boolean`
`Mode`	`String`
`Payments_Url`	`String`
`Is_Composition_Scheme_Enabled`	`String`
`Tax_Group_Enabled`	`Boolean`
`Source`	`Number`
`IsOrgNotSupported`	`Boolean`
`Is_Registered_For_Tax`	`Boolean`
`Partners_Domain`	`String`
`State`	`String`
`Country`	`String`
`Digital_Signature_Mode`	`String`
`Country_Code`	`String`
`Org_Settings`	`Boolean`
`Is_Ziedition`	`Boolean`
`Account_Created_Date_Formatted`	`Date`
`Is_Tax_Registered`	`Boolean`
`Zoho_One_Org`	`String`
`Org_Type`	`String`
`Is_Sku_Enabled`	`Boolean`
`State_Code`	`String`
`Zi_Zb_Edition`	`Number`
`User_Status`	`Number`
`Org_Created_App_Source`	`Number`
`Zi_Zb_Client`	`Number`
`Can_Show_Document_Tab`	`Boolean`
`Is_Solo_Org`	`Boolean`
`Sales_Tax_Type`	`String`
`Version_Formatted`	`String`
`Is_Gst_India_Version`	`Boolean`
`User_Status_Formatted`	`String`
`Is_Sales_Inclusive_Tax_Enabled`	`Boolean`
`Is_Search460_Enabled`	`String`
`Is_International_Trade_Enabled`	`Boolean`
`Time_Zone_Formatted`	`String`
`Can_Change_Timezone`	`Boolean`
`Is_Quick_Setup_Completed`	`Boolean`
`Is_Dsign_Required`	`Boolean`
`Can_Sign_Invoice`	`Boolean`
`Is_User_Dsign_Mandatory`	`Boolean`
`Plan_Type`	`Number`
`IsOrgActive`	`Boolean`
`Plan_Name`	`String`
`Is_Hsn_Or_Sac_Enabled`	`Boolean`
`Plan_Period`	`String`
`Is_Trial_Expired`	`Boolean`
`Is_Invoice_Pmt_Tds_Allowed`	`Boolean`
`Is_Scan_Preference_Enabled`	`Boolean`
`Is_User_Accountant`	`Boolean`
`Org_Action`	`String`
`AppList`	`Array`
`Is_Zpayroll_Grid`	`Boolean`
`Is_Po_Enabled`	`String`
`Is_Inventory_Enabled`	`String`
`Is_Trial_Extended`	`String`
`Zi_Migration_Status`	`String`
`Is_Bill_Of_Supply_Enabled`	`String`
`Org_Joined_App_List`	`Array`

Organization_Id

String

Name

String

Contact_Name

String

Email

String

Is_Default_Org

Boolean

Language_Code

String

Fiscal_Year_Start_Month

String

Account_Created_Date

Date

Time_Zone

String

Is_Org_Active

Boolean

Currency_Id

String

Currency_Code

String

Currency_Symbol

String

Currency_Format

String

Price_Precision

Number

Is_Retainerinvoice_Enabled

Boolean

Previous_Invoicing_Option

String

Role_Id

String

Custom_Field_Type

Number

Weight_Unit

String

User_Role

String

Is_Sez

Boolean

Business_Type

String

Is_Trial_Period_Extended

Boolean

Is_Portal_Enabled

Boolean

Logo_Url

String

Date_Format

String

Store_Logo_Url

String

Field_Separator

String

Is_Estimate_Enabled

Boolean

Is_Public_Domain

Boolean

Primary_Domain_Name

String

Can_Show_Authentication_Warning

Boolean

Remit_To_Address

String

Tax_Id_Label

String

Fiscal_Year_Start_Date

Number

Service_User_Number

String

Is_Free_Zone

Boolean

Industry_Type

String

Industry_Size

String

Is_Designated_Zone

Boolean

Is_Project_Enabled

Boolean

Previous_Product_Option

String

Company_Id_Label

String

Store_Url

String

Company_Id_Value

String

Tax_Basis

String

Is_New_Customer_Custom_Fields

Boolean

Tax_Id_Value

String

Version

String

Unverified_Emails_Count

Number

Fax

String

Status

String

Is_Registered_For_Gst

Boolean

Address_Country

String

Address_Street_Address1

String

Address_City

String

Address_Street_Address2

String

Address_Longitude

String

Address_State

String

Address_State_Code

String

Address_Zip

String

Address_Latitude

String

Tax_Settings_Tax_Reg_No

String

Tax_Settings_Is_Tax_Registered

Boolean

Tax_Settings_Tax_Registered_Date

String

Tax_Settings_Tax_Reg_No_Label

String

Tax_Settings_International_Trade_Enabled

String

Tax_Settings_Flat_Rate_Scheme

String

Tax_Settings_Flat_Rate_Percentage

String

Tax_Settings_Tax_Return_Start_Date

String

Phone

String

Org_Address

String

Website

String

Dimension_Unit

String

Is_Late_Fee_Disabled

Boolean

Portal_Name

String

Is_Purchaseorder_Enabled

Boolean

Is_Salesorder_Enabled

Boolean

Mode

String

Payments_Url

String

Is_Composition_Scheme_Enabled

String

Tax_Group_Enabled

Boolean

Source

Number

IsOrgNotSupported

Boolean

Is_Registered_For_Tax

Boolean

Partners_Domain

String

State

String

Country

String

Digital_Signature_Mode

String

Country_Code

String

Org_Settings

Boolean

Is_Ziedition

Boolean

Account_Created_Date_Formatted

Date

Is_Tax_Registered

Boolean

Zoho_One_Org

String

Org_Type

String

Is_Sku_Enabled

Boolean

State_Code

String

Zi_Zb_Edition

Number

User_Status

Number

Org_Created_App_Source

Number

Zi_Zb_Client

Number

Can_Show_Document_Tab

Boolean

Is_Solo_Org

Boolean

Sales_Tax_Type

String

Version_Formatted

String

Is_Gst_India_Version

Boolean

User_Status_Formatted

String

Is_Sales_Inclusive_Tax_Enabled

Boolean

Is_Search460_Enabled

String

Is_International_Trade_Enabled

Boolean

Time_Zone_Formatted

String

Can_Change_Timezone

Boolean

Is_Quick_Setup_Completed

Boolean

Is_Dsign_Required

Boolean

Can_Sign_Invoice

Boolean

Is_User_Dsign_Mandatory

Boolean

Plan_Type

Number

IsOrgActive

Boolean

Plan_Name

String

Is_Hsn_Or_Sac_Enabled

Boolean

Plan_Period

String

Is_Trial_Expired

Boolean

Is_Invoice_Pmt_Tds_Allowed

Boolean

Is_Scan_Preference_Enabled

Boolean

Is_User_Accountant

Boolean

Org_Action

String

AppList

Array

Is_Zpayroll_Grid

Boolean

Is_Po_Enabled

String

Is_Inventory_Enabled

String

Is_Trial_Extended

String

Zi_Migration_Status

String

Is_Bill_Of_Supply_Enabled

String

Org_Joined_App_List

Array

Examples

INSERT INTO
    Organization (
        [Name],
        Contact_Name,
        Email,
        Version,
        Currency_Code,
        Time_Zone,
        Address_State_Code
    )
VALUES
    (
        'ESL Two (India)',
        'zoho2',
        'zoho2@fastphotography.co.uk',
        'india',
        'INR',
        'Asia/Calcutta',
        'CG'
    )
UPDATE Organization
SET
    Address_Street_Address1 = 'Building 1'
WHERE
    Organization_Id = '20100387237'
DELETE FROM Organization
WHERE
    Organization_Id = '20100386941'

Organization table

Examples

`Organization` table