Tableau Connector for MYOB

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062