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 criteria 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 | References | 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 |
Accounts.Id |
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 |
Accounts.Id |
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 |
Accounts.Id |
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 |
Accounts.Id |
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 |
Accounts.Id |
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 |
Contacts.Id |
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. |