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. |