SHP01T204
購物車庫存預留
BusinessVersion: 1
ApprovedVersion: 1 | Review: Approved
No note.
Draft Review
Manage EntityType definition review here.
- Current Status
- Approved
- Submitted
- Not submitted
- Reviewed
- Not reviewed
- Comment
- No review comment.
No draft.
Source Query
Add Attribute
Add Source Join
Add Source Mapping
Draft can configure mapping before approval.
Source SQL Preview
API 查詢即以此 SQL 對讀取複本執行（ADR 0008）。
SELECT
[M].[ShoppingCartInventoryReservationId] AS [ShoppingCartInventoryReservationId],
[M].[ShoppingCartId] AS [ShoppingCartId],
[M].[Sku] AS [Sku],
[M].[MaterialsID] AS [MaterialsID],
[M].[Quantity] AS [Quantity],
[M].[Status] AS [Status],
[M].[ExpiresAt] AS [ExpiresAt]
FROM [SHP01T204] [M]
;
Projection Query JSON Preview
[
{
"ShoppingCartInventoryReservationId": "ShoppingCartInventoryReservationId-001",
"ShoppingCartId": "ShoppingCartId sample",
"Sku": "Sku sample",
"MaterialsID": "MaterialsID sample",
"Quantity": 123,
"Status": "Status sample",
"ExpiresAt": "2026-04-08T09:30:00Z",
"UpdatedAt": "2026-04-08T09:30:00Z"
}
]
Attributes
| Code | Name | Type | Required | PrimaryKey | Active |
|---|---|---|---|---|---|
| ShoppingCartInventoryReservationId | ShoppingCartInventoryReservationId | string | Y | Y | Y |
| ShoppingCartId | ShoppingCartId | string | Y | N | Y |
| Sku | Sku | string | Y | N | Y |
| MaterialsID | MaterialsID | string | Y | N | Y |
| Quantity | Quantity | int | Y | N | Y |
| Status | Status | string | Y | N | Y |
| ExpiresAt | ExpiresAt | datetime | Y | N | Y |
Source Joins
No joins.
Source Mappings
| Attribute | Alias | SourceField | Transform | Version | Active |
|---|---|---|---|---|---|
| ExpiresAt - ExpiresAt | M | ExpiresAt | Direct | 1 | Y |
| MaterialsID - MaterialsID | M | MaterialsID | Direct | 1 | Y |
| Quantity - Quantity | M | Quantity | Direct | 1 | Y |
| ShoppingCartId - ShoppingCartId | M | ShoppingCartId | Direct | 1 | Y |
| ShoppingCartInventoryReservationId - ShoppingCartInventoryReservationId | M | ShoppingCartInventoryReservationId | Direct | 1 | Y |
| Sku - Sku | M | Sku | Direct | 1 | Y |
| Status - Status | M | Status | Direct | 1 | Y |