Tax table

Column Type

Tax_Id

String

Tax_Name

String

Tax_Name_Formatted

String

Tax_Percentage

Number

Tax_Type

String

Tax_Factor

String

Tds_Payable_Account_Id

String

Tax_Authority_Id

String

Tax_Authority_Name

String

Is_Value_Added

String

Tax_Specific_Type

String

Country

String

Country_Code

String

Purchase_Tax_Expense_Account_Id

String

Is_State_Cess

String

End_Date

String

Start_Date

String

Tax_Specification

String

Diff_Rate_Reason

String

Tax_Account_Id

String

Tax_Account_Tracking

String

Purchase_Tax_Account_Id

String

Purchase_Tax_Account_Name

String

Output_Tax_Account_Name

String

Is_Editable

Boolean

Is_Inactive

Boolean

Is_Default_Tax

Boolean

Status

String

Last_Modified_Time

Timestamp

Examples

INSERT INTO Tax (Tax_Name, Tax_Percentage) VALUES ('S Reduced rate', 17.5)
UPDATE Tax SET Tax_Percentage=17.75 WHERE Tax_Id='579676000000165002'
DELETE FROM Tax WHERE tax_name='S Reduced rate'