TaxCodes

Tax codes for an AccountRight company file.

Table Specific Information

Select

MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators. These columns support the above comparison types for server side filtering: ID, Code, Description, IsRateNegative, LuxuryCarTaxThreshold, Rate, Type, TaxCollectedAccountID, TaxCollectedAccountDisplayID, TaxCollectedAccountName, TaxPaidAccountID, TaxPaidAccountDisplayID, TaxPaidAccountName, WithholdingCreditAccountID, WithholdingCreditAccountDisplayID, WithholdingCreditAccountName, WithholdingPayableAccountID, WithholdingPayableAccountDisplayID, WithholdingPayableAccountName, ImportDutyPayableAccountID, ImportDutyPayableAccountDisplayID, ImportDutyPayableAccountName, LinkedSupplierID, LinkedSupplierDisplayID, LinkedSupplierName. All the other columns and operators are processed client side.

SELECT * FROM TaxCodes WHERE WithholdingPayableAccountID = "e1b278bb-9ba3-4d2a-8dda-a49d09dcc471"
SELECT * FROM TaxCodes WHERE Rate = 46.5
SELECT * FROM TaxCodes WHERE Description = "No ABN Withholding" AND Code = "ABN"

Insert

The following attributes are required when performing an insert: Code, Description, Type, TaxCollectedAccountID, TaxPaidAccountID.

INSERT INTO TaxCodes(Code, Description, Type, TaxCollectedAccountID, TaxPaidAccountID) VALUES ("CDE", "Example tax code", "NoABN_TFN", "446d2226-254b-4821-acc2-7031842e0166", "9421b774-20fa-4c5f-bced-fbb6ecd42ebd")

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Uuid	True	Unique identifier in the form of a guid.
Code	String	False	3 digit code assigned to the tax code.
Description	String	False	Description given to the tax code.
IsRateNegative	Boolean	False	True indicates the tax rate is a negative value. False indicates the tax rate is a positive value.
LuxuryCarTaxThreshold	Decimal	False	Dollar value which must be exceeded before tax is calculated using this tax code.
Rate	Decimal	False	Rate of tax assigned.
Type	String	False	Tax Types consist of the following: ImportDuty, SalesTax GST_VAT (Goods and Services Tax), InputTaxed, Consolidated, LuxuryCarTax, WithholdingsTax, NoABN_TFN.
TaxCollectedAccountID	Uuid	False	Unique identifier for the account in the form of a guid.
TaxCollectedAccountDisplayID	String	True	Account code. Format includes separator ie 4-1100
TaxCollectedAccountName	String	True	Name of the account.
TaxCollectedAccountURI	String	True	Uniform resource identifier associated with the account object.
TaxPaidAccountID	Uuid	False	Unique identifier for the account in the form of a guid.
TaxPaidAccountDisplayID	String	True	Account code. Format includes separator ie 4-1100
TaxPaidAccountName	String	True	Name of the account.
TaxPaidAccountURI	String	True	Uniform resource identifier associated with the account object.
WithholdingCreditAccountID	Uuid	False	Unique identifier for the account in the form of a guid.
WithholdingCreditAccountDisplayID	String	True	Account code. Format includes separator ie 4-1100
WithholdingCreditAccountName	String	True	Name of the account.
WithholdingCreditAccountURI	String	True	Uniform resource identifier associated with the account object.
WithholdingPayableAccountID	Uuid	False	Unique identifier for the account in the form of a guid.
WithholdingPayableAccountDisplayID	String	True	Account code. Format includes separator ie 4-1100
WithholdingPayableAccountName	String	True	Name of the account.
WithholdingPayableAccountURI	String	True	Uniform resource identifier associated with the account object.
ImportDutyPayableAccountID	Uuid	False	Unique identifier for the account in the form of a guid.
ImportDutyPayableAccountDisplayID	String	True	Account code. Format includes separator ie 4-1100
ImportDutyPayableAccountName	String	True	Name of the account.
ImportDutyPayableAccountURI	String	True	Uniform resource identifier associated with the account object.
LinkedSupplierID	Uuid	False	Unique guid identifier belonging to the assigned supplier contact.
LinkedSupplierDisplayID	String	True	Customer contact Card ID, can also be used as a unique supplier contact identifier.
LinkedSupplierName	String	True	Name of the supplier contact.
LinkedSupplierURI	String	True	Uniform resource identifier associated with the supplier contact object.
URI	String	True	Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
RowVersion	String	True	Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.
CompanyFileId	String	True	The ID of the company file. Takes precedence over the CompanyFileId connection property.

JDBC Driver for MYOB

TaxCodes

Table Specific Information

Select

Insert

Columns