NZGSTReport
Returns a GST report for New Zealand 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 criteria can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: EndDate, ReportingPeriod, ReportingBasis, YearEndAdjust. All the other columns and operators are processed client side.
The default behavior is EndDate as today's date, ReportingPeriod as 6m, ReportingBasis as Cash, and YearEndAdjust as false; if the EndDate, ReportingPeriod, ReportingBasis, and YearEndAdjust filters are left unset.
SELECT * FROM NZGSTReportTo override this behavior, the values can be set directly in the query. For example:
SELECT * FROM NZGSTReport WHERE EndDate = "01/04/2019" AND ReportingBasis = "Cash" AND ReportingPeriod = "6m" AND YearEndAdjust = false
Columns
Name | Type | References | Description |
Address | String | The Address of the Company. | |
CompanyName | String | The name of the Business. | |
CreditAdjustments | Decimal | The Credit Adjustments amount for the given date range. | |
DebitAdjustments | Decimal | The Debit Adjustments amount for the given date range. | |
IrdNumber | String | The IRD number of the Company, format xxx-xxx-xxx. | |
NetGSTSales | Decimal | The Net GST Sales amount for the given date range. | |
PaymentAmount | Decimal | Total Payment Amount for the given date range. | |
PhoneNumber | String | The Phone number for the Company. | |
TotalGSTCollected | Decimal | Total GST Collected for the given date range. | |
TotalGSTCollectedOnPurchases | Decimal | Total GST Collected on Purchases for the given date range. | |
TotalGSTCollectedOnSales | Decimal | Total GST Collected on Sales for the given date range. | |
TotalGSTCredit | Decimal | Total GST Credit for the given date range. | |
TotalPurchases | Decimal | Total Amount of Purchases for the given date range. | |
TotalSales | Decimal | Total Amount of Sales for the given date range. | |
URI | String | Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. | |
ZeroRatedSupplies | Decimal | Total Zero Rated Supplies for the given date range. | |
EndDate | Date | Starting date of the period. | |
ReportingPeriod | String | Reporting Period for the report. This will either be 1m, 2m or 6m. | |
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. |