Returns a Tax Code Summary Report for AccountRight files.

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: EndDate, StartDate, ReportingBasis, YearEndAdjust. All the other columns and operators are processed client side. The default behavior is EndDate as today's date, StartDate as the first day of the year, ReportingBasis as Cash, and YearEndAdjust as false; if the EndDate, StartDate, ReportingBasis, and YearEndAdjust filters are left unset.

SELECT * FROM TaxCodeSummaryReport

To override this behavior, the values can be set directly in the query. For example:

SELECT * FROM TaxCodeSummaryReport WHERE StartDate = "12/01/2018" AND EndDate = "01/04/2019" AND ReportingBasis = "Cash" AND YearEndAdjust = false

Columns

Name	Type	Description
PurchasesTotal	Decimal	Total Purchases amount for a Tax Code.
SalesTotal	Decimal	Total Tax Collected amount for a Tax Code.
TaxCodeCode	String	3 digit tax code.
TaxCodeID	Uuid	Unique guid identifier belonging to the assigned tax code.
TaxCodeURI	String	Uniform resource identifier associated with the tax code object.
TaxCollected	Decimal	Total Tax Collected amount for a Tax Code.
TaxPaid	Decimal	Total Tax Paid amount for a Tax Code.
TaxRate	Decimal	Tax Rate for the Tax Code.
StartDate	Date	Ending date of the period.
EndDate	Date	Starting date of the period.
ReportingBasis	String	Reporting basis for the period, will either be Cash or Accural.
YearEndAdjust	Boolean	If you are including Year end Adjustments. This is a true or False value.
CompanyFileId	String	The ID of the company file. Takes precedence over the CompanyFileId connection property.