Skip to main content

Stock Adjustments

Written by Nick Maxwell

Data Dictionary

Manual inventory count adjustments made to reconcile physical stock with system records, including reason codes and value differences.Useful for tracking shrinkage and write-offs over time, auditing who has made adjustments, identifying warehouses with frequent discrepancies, and understanding the financial impact of inventory corrections.

Field

Type

Notes

Account Code

Text

API: Stock Adjustment.AccountCode

Adjustment Date

Datetime

Derived from datetime with timezone conversion of Adjustment Date

Adjustment Number

Text

API: Stock Adjustment.AdjustmentNumber

Adjustment Reason

Text

API: Stock Adjustment.AdjustmentReason

Batch Numbers

Text

API: Array of Stock Adjustment Lines.BatchNumbers

Comment

Text

API: Stock Adjustment Lines.Comments

Confirmed By

Text

API: Stock Adjustment.ConfirmedBy

Confirmed On

Datetime

Derived from datetime with timezone conversion of Confirmed On

Connection ID

Integer

The Connectorly Connection ID. If you group Connectorly's together, then you will see a Connection ID for each one. Organisations has the corresponding Connection Name for each Connection ID.

Created

Datetime

Derived from datetime with timezone conversion of Created

Created By

Text

The email of the user that created the record, API: Stock Adjustment.CreatedBy

Data current as of

Datetime

Gives the date and time that this record was taken from Unleashed.

Line Number

Integer

API: Stock Adjustment Lines.LineNumber

Line Updated

Datetime

Derived from datetime with timezone conversion of Line Updated

New Actual Value

Number

API: Stock Adjustment Lines.NewActualValue

New Quantity

Number

API: Stock Adjustment Lines.NewQuantity

Product Description

Text

Derived from cleaning Product Description

Product GUID

Text

The Unique ID of a Product, API: Product.Guid

Serial Numbers

Text

API: Array of Stock Adjustment Lines.SerialNumbers

Status

Text

API: Stock Adjustment.Status

Stock Adjustment GUID

Text

API: Stock Adjustment.Guid

Stock Adjustment Line GUID

Text

API: Stock Adjustment Lines.Guid

Updated

Datetime

Derived from datetime with timezone conversion of Updated

Updated By

Text

API: Stock Adjustment.LastModifiedBy

Warehouse GUID

Text

The Unique ID of the Warehouse, API: Warehouse.Guid

Warehouse Name

Text

API: Warehouse.WarehouseName

Did this answer your question?