Back To Metadata Workbench

SHP01T104

分類商品關聯

BusinessVersion: 2

ApprovedVersion: 2 | Review: Approved

No note.

Draft Review

Manage EntityType definition review here.

Current Status
Approved
Submitted
2026-07-24 02:47:00Z by EntityTypeDrafts
Reviewed
2026-07-24 02:47:03Z by EntityTypeDrafts
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].[ProductCategoryId] AS [ProductCategoryId],
    [M].[ProductId] AS [ProductId],
    [M].[CollegeId] AS [CollegeId],
    [M].[Sort] AS [Sort]
FROM [SHP01T104] [M]
;

Projection Query JSON Preview

[
  {
    "ProductCategoryId": "ProductCategoryId-001",
    "ProductId": "ProductId-001",
    "CollegeId": "CollegeId sample",
    "Sort": 123,
    "UpdatedAt": "2026-04-08T09:30:00Z"
  }
]

Attributes

Code Name Type Required PrimaryKey Active
ProductCategoryId ProductCategoryId string Y Y Y
ProductId ProductId 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
CollegeId CollegeId string N N Y
Sort Sort int 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
CollegeId - CollegeId M CollegeId Direct 1 Y
CompanyId - CompanyId M CompanyId 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
ProductCategoryId - ProductCategoryId M ProductCategoryId Direct 1 Y
ProductId - ProductId M ProductId Direct 1 Y
Sort - Sort M Sort Direct 1 Y
Source - Source M Source Direct 1 Y