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