SHP01T117
商品規格分類
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].[ProductSpecTypeId] AS [ProductSpecTypeId],
[M].[ProductId] AS [ProductId],
[M].[ProductSpecTypeName] AS [ProductSpecTypeName]
FROM [SHP01T117] [M]
;
Projection Query JSON Preview
[
{
"ProductSpecTypeId": "ProductSpecTypeId-001",
"ProductId": "ProductId sample",
"ProductSpecTypeName": "ProductSpecTypeName sample",
"UpdatedAt": "2026-04-08T09:30:00Z"
}
]
Attributes
| Code | Name | Type | Required | PrimaryKey | Active |
|---|---|---|---|---|---|
| ProductSpecTypeId | ProductSpecTypeId | string | Y | Y | Y |
| ProductId | ProductId | string | N | N | Y |
| ProductSpecTypeName | ProductSpecTypeName | string | Y | N | Y |
Source Joins
No joins.
Source Mappings
| Attribute | Alias | SourceField | Transform | Version | Active |
|---|---|---|---|---|---|
| ProductId - ProductId | M | ProductId | Direct | 1 | Y |
| ProductSpecTypeId - ProductSpecTypeId | M | ProductSpecTypeId | Direct | 1 | Y |
| ProductSpecTypeName - ProductSpecTypeName | M | ProductSpecTypeName | Direct | 1 | Y |