SHP01T201
購物車
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].[ShoppingCartId] AS [ShoppingCartId],
[M].[CompanyId] AS [CompanyId],
[M].[ClientId] AS [ClientId],
[M].[Currency] AS [Currency],
[M].[Subtotal] AS [Subtotal],
[M].[DiscountTotal] AS [DiscountTotal],
[M].[TaxTotal] AS [TaxTotal],
[M].[ShippingTotal] AS [ShippingTotal],
[M].[GrandTotal] AS [GrandTotal],
[M].[Status] AS [Status],
[M].[Source] AS [Source],
[M].[Locale] AS [Locale],
[M].[ExpiredAt] AS [ExpiredAt],
[M].[VisitorId] AS [VisitorId]
FROM [SHP01T201] [M]
;
Projection Query JSON Preview
[
{
"ShoppingCartId": "ShoppingCartId-001",
"CompanyId": "CompanyId sample",
"ClientId": "ClientId sample",
"Currency": "Currency sample",
"Subtotal": 123.45,
"DiscountTotal": 123.45,
"TaxTotal": 123.45,
"ShippingTotal": 123.45,
"GrandTotal": 123.45,
"Status": "Status sample",
"Source": "Source sample",
"Locale": "Locale sample",
"ExpiredAt": "2026-04-08T09:30:00Z",
"VisitorId": "VisitorId sample",
"UpdatedAt": "2026-04-08T09:30:00Z"
}
]
Attributes
| Code | Name | Type | Required | PrimaryKey | Active |
|---|---|---|---|---|---|
| ShoppingCartId | ShoppingCartId | string | Y | Y | Y |
| CompanyId | CompanyId | string | Y | N | Y |
| ClientId | ClientId | string | N | N | Y |
| Currency | Currency | string | Y | N | Y |
| Subtotal | Subtotal | decimal | Y | N | Y |
| DiscountTotal | DiscountTotal | decimal | Y | N | Y |
| TaxTotal | TaxTotal | decimal | Y | N | Y |
| ShippingTotal | ShippingTotal | decimal | Y | N | Y |
| GrandTotal | GrandTotal | decimal | Y | N | Y |
| Status | Status | string | Y | N | Y |
| Source | Source | string | N | N | Y |
| Locale | Locale | string | N | N | Y |
| ExpiredAt | ExpiredAt | datetime | N | N | Y |
| VisitorId | VisitorId | string | N | N | Y |
Source Joins
No joins.
Source Mappings
| Attribute | Alias | SourceField | Transform | Version | Active |
|---|---|---|---|---|---|
| ClientId - ClientId | M | ClientId | Direct | 1 | Y |
| CompanyId - CompanyId | M | CompanyId | Direct | 1 | Y |
| Currency - Currency | M | Currency | Direct | 1 | Y |
| DiscountTotal - DiscountTotal | M | DiscountTotal | Direct | 1 | Y |
| ExpiredAt - ExpiredAt | M | ExpiredAt | Direct | 1 | Y |
| GrandTotal - GrandTotal | M | GrandTotal | Direct | 1 | Y |
| Locale - Locale | M | Locale | Direct | 1 | Y |
| ShippingTotal - ShippingTotal | M | ShippingTotal | Direct | 1 | Y |
| ShoppingCartId - ShoppingCartId | M | ShoppingCartId | Direct | 1 | Y |
| Source - Source | M | Source | Direct | 1 | Y |
| Status - Status | M | Status | Direct | 1 | Y |
| Subtotal - Subtotal | M | Subtotal | Direct | 1 | Y |
| TaxTotal - TaxTotal | M | TaxTotal | Direct | 1 | Y |
| VisitorId - VisitorId | M | VisitorId | Direct | 1 | Y |