ODBC Driver for MYOB

Build 24.0.9060

InventoryAdjustmentItems

Inventory adjustment items for an AccountRight company file.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type References Description
AdjustmentID Uuid

InventoryAdjustments.ID

Unique identifier in the form of a guid.
Amount Double Dollar amount assigned to the item.
Quantity Double The quantity of items to be adjusted.
UnitCost Double Unit cost assigned to the item/items.
RowID Integer Sequence of the entry within the inventory journal set.
Memo String Memo text describing the transaction line.
RowVersion String RowVersion. Required during update to identify the line item.
ItemID Uuid

Items.ID

Unique item identifier in the form of a guid.
ItemName String Name assigned to the item.
ItemNumber String Number assigned to the item.
ItemURI String Uniform resource identifier associated with the item object.
AccountID Uuid

Accounts.ID

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.
JobID Uuid

Jobs.ID

Unique job identifier in the form of a guid.
JobName String Name assigned to the job.
JobNumber String Number assigned to the job.
JobURI String Uniform resource identifier associated with the job object.
LocationID Uuid

Locations.ID

Unique identifier for the location in the form of a guid.
LocationIdentifier String Identifier assigned to the location.
LocationName String Name of the location.
LocationURI String Uniform resource identifier associated with the location object.

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