AccountRegister
Returns general ledger account activity.
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: ID, Activity, Adjustment, Month, Year, YearEndActivity, YearEndAdjustment, AccountID, AccountDisplayID, AccountName. All the other columns and operators are processed client side.
SELECT * FROM AccountRegister WHERE AccountID = "d3f55ef1-ce77-4ef2-a415-61d04db2c5fc" SELECT * FROM AccountRegister WHERE AccountName = "AccountName" SELECT * FROM AccountRegister WHERE Month = 6
Columns
Name | Type | Description |
ID [KEY] | Uuid | Unique identifier in the form of a guid. |
Activity | Decimal | Net activity within profit and loss account or net movement within balance sheet accounts. |
Adjustment | Decimal | Adjustments. |
Month | Integer | Month in which the activity was generated ie December = 12. |
Year | Integer | Year in which the activity was generated ie 2014. |
YearEndActivity | Decimal | Net activity within profit and loss account or net movement within balance sheet accounts for YearEndAdjustments. |
YearEndAdjustment | Decimal | General Journal entries recorded outside of the 12 month financial year. |
RowVersion | String | Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. |
URI | String | Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
UnitCount | Decimal | Quantity balance of the account. |
AccountID | Uuid | Unique identifier for the account in the form of a guid. |
AccountDisplayID | String | Account code. Format includes separator ie 4-1100 |
AccountName | String | Name of the account. |
AccountURI | String | Uniform resource identifier associated with the account object. |
CompanyFileId | String | The ID of the company file. Takes precedence over the CompanyFileId connection property. |