Back To Metadata Workbench

SHP01T103

商品明細

BusinessVersion: 2

ApprovedVersion: 2 | Review: Approved

No note.

Draft Review

Manage EntityType definition review here.

Current Status
Approved
Submitted
2026-07-24 03:29:30Z by Sql-20260724
Reviewed
2026-07-24 03:29:30Z by Sql-20260724
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].[ProductDetailId] AS [ProductDetailId],
    [M].[ProductId] AS [ProductId],
    [M].[DetailTopic] AS [DetailTopic],
    [M].[DetailDesc] AS [DetailDesc],
    [M].[DetailSort] AS [DetailSort],
    [M].[DetailType] AS [DetailType],
    [M].[VideoSubtitle] AS [VideoSubtitle]
FROM [SHP01T103] [M]
;

Projection Query JSON Preview

[
  {
    "ProductDetailId": "ProductDetailId-001",
    "ProductId": "ProductId sample",
    "DetailTopic": "DetailTopic sample",
    "DetailDesc": "DetailDesc sample",
    "DetailSort": 123,
    "DetailType": 123,
    "VideoSubtitle": "VideoSubtitle sample",
    "UpdatedAt": "2026-04-08T09:30:00Z"
  }
]

Attributes

Code Name Type Required PrimaryKey Active
ProductDetailId ProductDetailId string Y Y Y
CompanyId CompanyId string Y N N
Source Source string N N N
Locale Locale string N N N
ClientId ClientId string N N N
ProductId ProductId string N N Y
DetailTopic DetailTopic string Y N Y
DetailDesc DetailDesc string Y N Y
DetailSort DetailSort int N N Y
DetailType DetailType int Y N Y
VideoSubtitle VideoSubtitle string N N Y
ExternalSource ExternalSource string N N N
ExternalId ExternalId string N N N
ExtraData ExtraData string N N N

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
DetailDesc - DetailDesc M DetailDesc Direct 1 Y
DetailSort - DetailSort M DetailSort Direct 1 Y
DetailTopic - DetailTopic M DetailTopic Direct 1 Y
DetailType - DetailType M DetailType Direct 1 Y
ExternalId - ExternalId M ExternalId Direct 1 Y
ExternalSource - ExternalSource M ExternalSource Direct 1 Y
ExtraData - ExtraData M ExtraData Direct 1 Y
Locale - Locale M Locale Direct 1 Y
ProductDetailId - ProductDetailId M ProductDetailId Direct 1 Y
ProductId - ProductId M ProductId Direct 1 Y
Source - Source M Source Direct 1 Y
VideoSubtitle - VideoSubtitle M VideoSubtitle Direct 1 Y