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 |
