Skip to main content

Stock Adjustments

Written by Nick Maxwell

Data Dictionary

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

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?