ODBC Driver for MYOB

Build 24.0.9060

ProfitLossDistributions

Returns the Profit and Loss Distribution of an AccountRight company file.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type References Description
Entity String Entity of the Profit and Loss Distribution.
HeaderAccountID Uuid

Accounts.ID

Unique identifier for the header account in the form of a guid.
HeaderAccountDisplayID String Header Account code. Format includes separator ie 4-1100
HeaderAccountName String Name of the header account.
HeaderAccountURI String Uniform resource identifier associated with the header account object.
RetainedEarningsAccountID Uuid

Accounts.ID

Unique identifier for the retained earnings account in the form of a guid.
RetainedEarningsAccountDisplayID String Retained Earnings Account code. Format includes separator ie 4-1100
RetainedEarningsAccountName String Name of the retained earnings account.
RetainedEarningsAccountURI String Uniform resource identifier associated with the retained earnings account object.
CurrentEarningsAccountID Uuid

Accounts.ID

Unique identifier for the current earnings account in the form of a guid.
CurrentEarningsAccountDisplayID String Current Earnings Account code. Format includes separator ie 4-1100
CurrentEarningsAccountName String Name of the current earnings account.
CurrentEarningsAccountURI String Uniform resource identifier associated with the current earnings account object.
Value Double Value to be allocated to the account.
Unit String Unit that the Value is measured in.
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.
CompanyFileId String The ID of the company file.

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