FulfillmentEvents
Tracks events related to the lifecycle of fulfillments, including creation, shipment, and delivery updates.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the fulfillment event. | |
| OrderId [KEY] | Long | False |
Orders.Id |
The ID of the order associated with this fulfillment event. |
| FulfillmentId [KEY] | Long | False |
Fulfillments.Id |
The unique numeric identifier for the fulfillment record related to this event. |
| ShopId | Long | True |
Shop.Id |
The unique numeric identifier for the shop where the fulfillment event occurred. |
| Status | String | False |
The current status of the fulfillment event. Valid values include: 'confirmed', 'in_transit', 'out_for_delivery', 'delivered', and 'failure'. | |
| EstimatedDeliveryAt | Datetime | False |
The estimated date and time when the fulfillment is expected to be delivered to the customer. | |
| Message | String | False |
An optional message describing the fulfillment event status, which may be provided by the shipping carrier. | |
| City | String | False |
The city where the fulfillment event occurred. | |
| Province | String | False |
The province or state where the fulfillment event occurred. | |
| Zip | String | False |
The postal or ZIP code of the location where the fulfillment event occurred. | |
| Country | String | False |
The country where the fulfillment event occurred. | |
| Address1 | String | False |
The street address associated with the fulfillment event. | |
| Latitude | Double | False |
The geographic latitude coordinate indicating the north–south position of the fulfillment event. | |
| Longitude | Double | False |
The geographic longitude coordinate indicating the east–west position of the fulfillment event. | |
| CreatedAt | Datetime | True |
The date and time when the fulfillment event was created. | |
| UpdatedAt | Datetime | True |
The date and time when the fulfillment event was last updated. | |
| HappenedAt | Datetime | True |
The actual date and time when the fulfillment event occurred. |