SHP01T203
購物車優惠券
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].[CouponCode] AS [CouponCode],
[M].[DiscountAmount] AS [DiscountAmount],
[M].[AppliedAt] AS [AppliedAt]
FROM [SHP01T203] [M]
;
Projection Query JSON Preview
[
{
"ShoppingCartId": "ShoppingCartId-001",
"CouponCode": "CouponCode-001",
"DiscountAmount": 123.45,
"AppliedAt": "2026-04-08T09:30:00Z",
"UpdatedAt": "2026-04-08T09:30:00Z"
}
]
Attributes
| Code | Name | Type | Required | PrimaryKey | Active |
|---|---|---|---|---|---|
| ShoppingCartId | ShoppingCartId | string | Y | Y | Y |
| CouponCode | CouponCode | string | Y | Y | Y |
| DiscountAmount | DiscountAmount | decimal | Y | N | Y |
| AppliedAt | AppliedAt | datetime | Y | N | Y |
Source Joins
No joins.
Source Mappings
| Attribute | Alias | SourceField | Transform | Version | Active |
|---|---|---|---|---|---|
| AppliedAt - AppliedAt | M | AppliedAt | Direct | 1 | Y |
| CouponCode - CouponCode | M | CouponCode | Direct | 1 | Y |
| DiscountAmount - DiscountAmount | M | DiscountAmount | Direct | 1 | Y |
| ShoppingCartId - ShoppingCartId | M | ShoppingCartId | Direct | 1 | Y |