SHP01T118

商品規格

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

AttributeCode

AttributeName

DataType

Required

Primary Key

Active

Add Source Join

FromAlias

JoinType

JoinTableName

JoinAlias

JoinCondition

Sequence

Active

Add Source Mapping

Draft can configure mapping before approval.

Attribute

SourceAlias

SourceField

TransformType

TransformRule

ValueMap

VersionNo

Active

Source SQL Preview

API 查詢即以此 SQL 對讀取複本執行（ADR 0008）。

SELECT
    [M].[ProductSpecId] AS [ProductSpecId],
    [M].[ProductSpecTypeId] AS [ProductSpecTypeId],
    [M].[ProductSpecName] AS [ProductSpecName],
    [M].[OriginalPrice] AS [OriginalPrice],
    [M].[SpecialOffer] AS [SpecialOffer]
FROM [SHP01T118] [M]
;

Projection Query JSON Preview

[
  {
    "ProductSpecId": "ProductSpecId-001",
    "ProductSpecTypeId": "ProductSpecTypeId sample",
    "ProductSpecName": "ProductSpecName sample",
    "OriginalPrice": 123.45,
    "SpecialOffer": 123.45,
    "UpdatedAt": "2026-04-08T09:30:00Z"
  }
]

Attributes

Code	Name	Type	Required	PrimaryKey	Active
ProductSpecId	ProductSpecId	string	Y	Y	Y
ProductSpecTypeId	ProductSpecTypeId	string	N	N	Y
ProductSpecName	ProductSpecName	string	N	N	Y
OriginalPrice	OriginalPrice	decimal	N	N	Y
SpecialOffer	SpecialOffer	decimal	N	N	Y

Source Joins

No joins.

Source Mappings

Attribute	Alias	SourceField	Transform	Version	Active
OriginalPrice - OriginalPrice	M	OriginalPrice	Direct	1	Y
ProductSpecId - ProductSpecId	M	ProductSpecId	Direct	1	Y
ProductSpecName - ProductSpecName	M	ProductSpecName	Direct	1	Y
ProductSpecTypeId - ProductSpecTypeId	M	ProductSpecTypeId	Direct	1	Y
SpecialOffer - SpecialOffer	M	SpecialOffer	Direct	1	Y