table Dim_PackInfo
	lineageTag: f420be02-8dc1-467f-8e0e-a8231e8b72e6

	column PACK_COD
		dataType: string
		lineageTag: 2fe29ac4-ec3b-42cb-86ce-17e060fec44f
		summarizeBy: none
		sourceColumn: PACK_COD

		annotation SummarizationSetBy = Automatic

	column PACK_DES
		dataType: string
		lineageTag: 58063e41-a010-4665-b743-4555f3a1abb4
		summarizeBy: none
		sourceColumn: PACK_DES

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column PACK_LCH
		dataType: string
		lineageTag: d93fc95d-29c0-4675-88cc-e26d87032d6d
		summarizeBy: none
		sourceColumn: PACK_LCH

		annotation SummarizationSetBy = Automatic

	column PROD_COD
		dataType: string
		lineageTag: fb0d1cb1-2984-456e-8707-4cfebe4169ec
		summarizeBy: none
		sourceColumn: PROD_COD

		annotation SummarizationSetBy = Automatic

	column PROD_DES
		dataType: string
		lineageTag: 703c6908-b2f7-4b8e-a565-1d91e603dc0f
		summarizeBy: none
		sourceColumn: PROD_DES

		annotation SummarizationSetBy = Automatic

	column PROD_DES_C
		dataType: string
		lineageTag: 254e868a-b297-4e27-b186-744ecb658faf
		summarizeBy: none
		sourceColumn: PROD_DES_C

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column CMPS_COD
		dataType: string
		lineageTag: b65462b8-5280-4819-8036-14d112376e9f
		summarizeBy: none
		sourceColumn: CMPS_COD

		annotation SummarizationSetBy = Automatic

	column CMPS_DES
		dataType: string
		lineageTag: 6cac86f3-c1f3-407e-9ae0-eceb64695b7b
		summarizeBy: none
		sourceColumn: CMPS_DES

		annotation SummarizationSetBy = Automatic

	column CMPS_DES_C
		dataType: string
		lineageTag: eff3f2c2-8119-4111-af35-5f8174133e2a
		summarizeBy: none
		sourceColumn: CMPS_DES_C

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column ATC1_COD
		dataType: string
		lineageTag: 5de4d0d0-f003-4024-a369-081d4a5fd080
		summarizeBy: none
		sourceColumn: ATC1_COD

		annotation SummarizationSetBy = Automatic

	column ATC1_DES
		dataType: string
		lineageTag: f02d78fd-d5df-4397-a894-8f114424385d
		summarizeBy: none
		sourceColumn: ATC1_DES

		annotation SummarizationSetBy = Automatic

	column ATC1_DES_C
		dataType: string
		lineageTag: 7cbbfb49-2ca2-406d-8c00-fddf33b2c6e4
		summarizeBy: none
		sourceColumn: ATC1_DES_C

		annotation SummarizationSetBy = Automatic

	column ATC2_COD
		dataType: string
		lineageTag: d908ea98-f389-43ab-8966-2706f25c9d5a
		summarizeBy: none
		sourceColumn: ATC2_COD

		annotation SummarizationSetBy = Automatic

	column ATC2_DES
		dataType: string
		lineageTag: 688a385b-1d0c-45c6-a413-d7be0b988afe
		summarizeBy: none
		sourceColumn: ATC2_DES

		annotation SummarizationSetBy = Automatic

	column ATC2_DES_C
		dataType: string
		lineageTag: ecef3c5f-149f-46c1-be65-71afea59b523
		summarizeBy: none
		sourceColumn: ATC2_DES_C

		annotation SummarizationSetBy = Automatic

	column ATC3_COD
		dataType: string
		lineageTag: 8a726f1a-32b9-42ef-9f29-09c244c03cf3
		summarizeBy: none
		sourceColumn: ATC3_COD

		annotation SummarizationSetBy = Automatic

	column ATC3_DES
		dataType: string
		lineageTag: 4ef7d78b-b807-4d0d-ae87-36aed8c6ff6d
		summarizeBy: none
		sourceColumn: ATC3_DES

		annotation SummarizationSetBy = Automatic

	column ATC3_DES_C
		dataType: string
		lineageTag: 98f4fec7-f457-4b07-ac94-b07ddd3c88fc
		summarizeBy: none
		sourceColumn: ATC3_DES_C

		annotation SummarizationSetBy = Automatic

	column ATC4_COD
		dataType: string
		lineageTag: 704ef81d-1d26-44c7-9d9d-3ac119e628c7
		summarizeBy: none
		sourceColumn: ATC4_COD

		annotation SummarizationSetBy = Automatic

	column ATC4_DES
		dataType: string
		lineageTag: 4363ec7f-9e85-4090-a928-20af2c065002
		summarizeBy: none
		sourceColumn: ATC4_DES

		annotation SummarizationSetBy = Automatic

	column ATC4_DES_C
		dataType: string
		lineageTag: 49efe84f-b9c1-44fb-bb66-6aac7e3cee31
		summarizeBy: none
		sourceColumn: ATC4_DES_C

		annotation SummarizationSetBy = Automatic

	column APP1_COD
		dataType: string
		lineageTag: b3fdbbd8-cc0e-44a2-8bc3-74de2b77e64a
		summarizeBy: none
		sourceColumn: APP1_COD

		annotation SummarizationSetBy = Automatic

	column APP1_DES
		dataType: string
		lineageTag: 240c79e5-5336-42c4-ad35-ea1e615b128d
		summarizeBy: none
		sourceColumn: APP1_DES

		annotation SummarizationSetBy = Automatic

	column APP1_DES_C
		dataType: string
		lineageTag: dd56abcc-b68f-4b97-b1e2-ff1d292c8656
		summarizeBy: none
		sourceColumn: APP1_DES_C

		annotation SummarizationSetBy = Automatic

	column APP2_COD
		dataType: string
		lineageTag: dcf72800-3021-4ad2-a70f-f838a6e68012
		summarizeBy: none
		sourceColumn: APP2_COD

		annotation SummarizationSetBy = Automatic

	column APP2_DES
		dataType: string
		lineageTag: d04d2892-16be-4ebd-adcd-ce0f3c517527
		summarizeBy: none
		sourceColumn: APP2_DES

		annotation SummarizationSetBy = Automatic

	column APP2_DES_C
		dataType: string
		lineageTag: 8531419e-be46-4f02-9908-dc5fbab04158
		summarizeBy: none
		sourceColumn: APP2_DES_C

		annotation SummarizationSetBy = Automatic

	column APP3_COD
		dataType: string
		lineageTag: 52a1dea4-4dbb-44b6-9b79-9a285776c384
		summarizeBy: none
		sourceColumn: APP3_COD

		annotation SummarizationSetBy = Automatic

	column APP3_DES
		dataType: string
		lineageTag: aa57090b-6402-4c0d-a5ad-818e746ce79c
		summarizeBy: none
		sourceColumn: APP3_DES

		annotation SummarizationSetBy = Automatic

	column APP3_DES_C
		dataType: string
		lineageTag: 2b7ce819-150d-46aa-8bdb-05793fdde0db
		summarizeBy: none
		sourceColumn: APP3_DES_C

		annotation SummarizationSetBy = Automatic

	column GENE_ORIG_DESC
		dataType: string
		lineageTag: 7f805bf6-850d-4925-964d-015e6f7ea4fd
		summarizeBy: none
		sourceColumn: GENE_ORIG_DESC

		annotation SummarizationSetBy = Automatic

	column VBP_DESC
		dataType: string
		lineageTag: 72ac4722-00b5-49b3-adce-5153b1a464e1
		summarizeBy: none
		sourceColumn: VBP_DESC

		annotation SummarizationSetBy = Automatic

	column CORP_COD
		dataType: string
		lineageTag: e3d5a1e0-d797-4022-84a7-ca5f19e39750
		summarizeBy: none
		sourceColumn: CORP_COD

		annotation SummarizationSetBy = Automatic

	column GEN_RN
		dataType: string
		lineageTag: 8b12411b-233e-4d8d-bb2b-a23d1b2893c0
		summarizeBy: none
		sourceColumn: GEN_RN

		annotation SummarizationSetBy = Automatic

	column MOLECULE_CODE_DESC = IF([CMPS_DES] = "-"," - " , [CMPS_DES]& " - " & [CMPS_DES_C])
		lineageTag: 3527bbbc-a941-4357-b996-3161d6ae5a2d
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC1_CODE_DESC = [ATC1_COD] & " - " & [ATC1_DES_C]
		lineageTag: 95dfd568-a634-4ee6-93b7-b9eaad5fee0f
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC2_CODE_DESC = [ATC2_COD] & " - " & [ATC2_DES_C]
		lineageTag: 08396fc1-0b78-48fa-af64-6e9aba7debd8
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC3_CODE_DESC = [ATC3_COD] & " - " & [ATC3_DES_C]
		lineageTag: d2937c33-2fd4-4f4a-8d79-c4360bc318fd
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC4_CODE_DESC = [ATC4_COD] & " - " & [ATC4_DES_C]
		lineageTag: e8147896-2b3d-4784-8af9-808f6f4e0807
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column APP1_COD_DES_C = [APP1_COD] & " - " & [APP1_DES_C]
		lineageTag: eaeaa2d6-77ad-4b2e-8875-32a8e69af1ad
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column APP2_COD_DES_C = [APP2_COD] & " - " & [APP2_DES_C]
		lineageTag: 5a58d6c4-f2a8-4acf-9c92-cd45836c81b5
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column APP3_COD_DES_C = [APP3_COD] & " - " & [APP3_DES_C]
		lineageTag: ca0b9bee-0c36-476c-b411-41338150964d
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column MOLECULE_DES_C = [CMPS_DES_C] & " - " & [CMPS_DES]
		lineageTag: e9eaccb6-c51f-459d-8bc0-15d15b0e98b8
		summarizeBy: none
		sortByColumn: CMPS_RN

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column PROD_PACK = [PROD_DES] & " - " & [PACK_DES]
		lineageTag: 4b881842-d882-4f6d-b879-34b69bc0a5dd
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column PROD_CORP = [CORP_DES] & "(" & [PROD_DES]&")"
		lineageTag: c781d692-765e-4f49-9945-eac15e0f41e4
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column CORP_DES
		dataType: string
		lineageTag: d8dc8bf5-0104-4acc-b3b7-1f97e88dde0d
		summarizeBy: none
		sourceColumn: CORP_DES

		annotation SummarizationSetBy = Automatic

	column CORP_DES_C
		dataType: string
		lineageTag: 94a183de-e511-4b7a-b71e-1214f25538a3
		summarizeBy: none
		sourceColumn: CORP_DES_C

		annotation SummarizationSetBy = Automatic

	column PROD_CORP_C = [PROD_DES_C] & "(" & [CORP_DES_C]&")"
		lineageTag: c800e12c-120a-4f7f-a34c-9cd432a66a4b
		summarizeBy: none
		sortByColumn: PROD_RN

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column MANU_DES
		dataType: string
		lineageTag: 891e1902-4bc3-4512-9381-a11f03dc8af5
		summarizeBy: none
		sourceColumn: MANU_DES

		annotation SummarizationSetBy = Automatic

	column PACK_RN
		dataType: string
		lineageTag: 04e027ce-98d3-4d89-b8a7-0952fad4f687
		summarizeBy: none
		sourceColumn: PACK_RN

		annotation SummarizationSetBy = Automatic

	column PROD_RN
		dataType: string
		lineageTag: 12a207d7-e23f-4b08-b4c5-d91825f5003e
		summarizeBy: none
		sourceColumn: PROD_RN

		annotation SummarizationSetBy = Automatic

	column PROD_PACK_CORP = [PROD_DES_C] & " " & [PACK_DES]& "(" & [CORP_DES_C]&")"
		lineageTag: 990697ca-2f91-4375-b79c-2d412bf92652
		summarizeBy: none
		sortByColumn: PACK_RN

		changedProperty = SortByColumn

		annotation SummarizationSetBy = Automatic

	column CMPS_RN
		dataType: string
		lineageTag: c7289ec0-4351-47e3-b711-3f2a24f4cbdd
		summarizeBy: none
		sourceColumn: CMPS_RN

		annotation SummarizationSetBy = Automatic

	column DATA_SOURCE
		dataType: string
		lineageTag: 65bd749b-1888-4022-87e2-e04c2f68ebc5
		summarizeBy: none
		sourceColumn: DATA_SOURCE

		annotation SummarizationSetBy = Automatic

	column PACK_SOURCE = ```
			[PACK_COD] & [DATA_SOURCE]  & [NEW_CODE] 
			```
		lineageTag: edc6d470-39af-4bd9-bd1b-76a8c703ad23
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column STGH_DES
		dataType: string
		lineageTag: 7af92276-177a-4f3c-908e-cdbb55f1e263
		summarizeBy: none
		sourceColumn: STGH_DES

		annotation SummarizationSetBy = Automatic

	column BIO_DESC
		dataType: string
		lineageTag: ba2d591e-23e5-4876-802c-786d1c4a02e9
		summarizeBy: none
		sourceColumn: BIO_DESC

		annotation SummarizationSetBy = Automatic

	column ETH_OTC_DESC
		dataType: string
		lineageTag: 43d019d0-858d-49cf-9309-79e73e1b3ab9
		summarizeBy: none
		sourceColumn: ETH_OTC_DESC

		annotation SummarizationSetBy = Automatic

	column NRDL_DESC
		dataType: string
		lineageTag: d9473b87-f987-4314-a595-7f3e21f7a7af
		summarizeBy: none
		sourceColumn: NRDL_DESC

		annotation SummarizationSetBy = Automatic

	column NRDL_ENTRY_DATE
		dataType: string
		lineageTag: d85ebc8a-ce77-4d40-9d3e-b579ba9c3726
		summarizeBy: none
		sourceColumn: NRDL_ENTRY_DATE

		annotation SummarizationSetBy = Automatic

	column EDL_DESC
		dataType: string
		lineageTag: a9f3707a-6f6c-4c22-aae7-3f89bb72e3e8
		summarizeBy: none
		sourceColumn: EDL_DESC

		annotation SummarizationSetBy = Automatic

	column TCM_DESC
		dataType: string
		lineageTag: b7d1757a-dac5-44b2-8250-be28e33330e2
		summarizeBy: none
		sourceColumn: TCM_DESC

		annotation SummarizationSetBy = Automatic

	column PAED_DESC
		dataType: string
		lineageTag: aa6ff961-ad17-4a2e-bfcc-8978247015f2
		summarizeBy: none
		sourceColumn: PAED_DESC

		annotation SummarizationSetBy = Automatic

	column GQCE_DESC
		dataType: string
		lineageTag: 6e5f859b-63c0-4863-8d3d-08b10af5eaba
		summarizeBy: none
		sourceColumn: GQCE_DESC

		annotation SummarizationSetBy = Automatic

	column MANU_COD
		dataType: string
		lineageTag: 64df9695-aa3d-445c-934f-9331fb3e7495
		summarizeBy: none
		sourceColumn: MANU_COD

		annotation SummarizationSetBy = Automatic

	column MNFL_COD
		dataType: string
		lineageTag: e2bd7f82-e90f-4bf2-a9b0-fdaf2f929669
		summarizeBy: none
		sourceColumn: MNFL_COD

		annotation SummarizationSetBy = Automatic

	column VBP_BATCH
		dataType: string
		lineageTag: a7cd1c88-73b3-4ee3-ba8d-f6b9f19fc053
		summarizeBy: none
		sourceColumn: VBP_BATCH

		annotation SummarizationSetBy = Automatic

	column VBP_IMPLEMENTING_TIME
		dataType: string
		lineageTag: c14e7f12-4f6d-4eb5-b579-ae212f3c1f9b
		summarizeBy: none
		sourceColumn: VBP_IMPLEMENTING_TIME

		annotation SummarizationSetBy = Automatic

	column ATC
		dataType: string
		lineageTag: 685c7c74-076b-473d-8bcb-36e463db339b
		summarizeBy: none
		sourceColumn: ATC

		annotation SummarizationSetBy = Automatic

	column NEW_CODE
		dataType: string
		lineageTag: b104776c-f0a4-43f7-bede-73bff24b0c09
		summarizeBy: none
		sourceColumn: NEW_CODE

		annotation SummarizationSetBy = Automatic

	column COMMON_NAME
		dataType: string
		lineageTag: 11ab4733-a410-407b-9916-c77b59821e17
		summarizeBy: none
		sourceColumn: COMMON_NAME

		annotation SummarizationSetBy = Automatic

	column PRODUCT_NAME
		dataType: string
		lineageTag: 11043a28-b76c-4c5a-9f07-895f22721e87
		summarizeBy: none
		sourceColumn: PRODUCT_NAME

		annotation SummarizationSetBy = Automatic

	column MANU_DES_XIEHE
		dataType: string
		lineageTag: 1c72ae6d-abac-40d4-ab4d-c56663c1187e
		summarizeBy: none
		sourceColumn: MANU_DES_XIEHE

		annotation SummarizationSetBy = Automatic

	column PACK_DES_XIEHE
		dataType: string
		lineageTag: 3772d845-a962-4ceb-9e5e-865188a5cbbb
		summarizeBy: none
		sourceColumn: PACK_DES_XIEHE

		annotation SummarizationSetBy = Automatic

	column DRUG_DELIVERY_ROUTE
		dataType: string
		lineageTag: 2a43e243-63d3-46b8-9609-8d4ae1103245
		summarizeBy: none
		sourceColumn: DRUG_DELIVERY_ROUTE

		annotation SummarizationSetBy = Automatic

	column NFC
		dataType: string
		lineageTag: 06a7141c-139e-4450-9984-e8c9c2e407fe
		summarizeBy: none
		sourceColumn: NFC

		annotation SummarizationSetBy = Automatic

	column CORP_TYPE
		dataType: string
		lineageTag: b0fc0260-0803-4528-a425-4ef5836a6378
		summarizeBy: none
		sourceColumn: CORP_TYPE

		annotation SummarizationSetBy = Automatic

	column LAUNCHTIME
		dataType: string
		lineageTag: b04aa76a-f488-4396-ab8b-25cd35b5e0db
		summarizeBy: none
		sourceColumn: LAUNCHTIME

		annotation SummarizationSetBy = Automatic

	column PROD_VBP = [PROD_DES_C] & "(" & [VBP_BRAND]&")"
		lineageTag: 3ac4bcbe-deab-40cc-ae2c-2284761b7d94
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column MANU_DES_C
		dataType: string
		lineageTag: 88125f10-9755-4d68-975c-4f0fe9f670af
		summarizeBy: none
		sourceColumn: MANU_DES_C

		annotation SummarizationSetBy = Automatic

	column MOLECULE_SOURCE = [CMPS_DES] & [DATA_SOURCE]
		lineageTag: a6c0b55a-e20a-41c1-8e2a-ea8ebdcce51d
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column PACK_SOURCE_AUTH = [PACK_COD] & [DATA_SOURCE]
		lineageTag: fd424c49-1925-4ea9-9a91-49693c20f53a
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column MANU_C = ```
			[CORP_DES_C] 
			```
		lineageTag: 6dd9a1e4-a6eb-4530-a8a9-53b495d6188a
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column Data_Surce2 =
			
			IF([DATA_SOURCE] = "THC(Quarterly)","THC")
		lineageTag: cc0ecd7a-e99d-4554-8706-494e26b155a8
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column VBP_BRAND
		dataType: string
		lineageTag: 0d4070ed-40b3-4040-b940-3f8817716f50
		summarizeBy: none
		sourceColumn: VBP_BRAND

		annotation SummarizationSetBy = Automatic

	column PROD_CORP_EN = [PROD_DES] & "(" & [CORP_DES]&")"
		lineageTag: 3f4e8882-261b-4f5e-87d5-c937d3bfc839
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column PROD_PACK_CORP_EN = [PROD_DES] & "-" & [PACK_DES]& "(" & [CORP_DES]&")"
		lineageTag: 7b021f40-cc80-4fca-b194-dc8c117cc0ab
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column PROD_VBP_EN = [PROD_DES] & "(" & [VBP_BRAND]&")"
		lineageTag: f9340cc0-8601-4b9d-8231-0c07f6e408a9
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column APP1_COD_DES = [APP1_COD] & " - " & [APP1_DES]
		lineageTag: ea41a7f4-7a3f-4072-baa0-c9ae77de2b3a
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column APP2_COD_DES = [APP2_COD] & " - " & [APP2_DES]
		lineageTag: 55856921-d3c3-4b23-bb34-a5ff9eed6a83
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column APP3_COD_DES = [APP3_COD] & " - " & [APP3_DES]
		lineageTag: e1410049-e27b-4ecb-b70f-604285fa986c
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC1_CODE_DESC_EN = [ATC1_COD] & " - " & [ATC1_DES]
		lineageTag: 5f6ad3a8-63cc-469c-bc3e-cc5cdc02c474
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC2_CODE_DESC_EN = [ATC2_COD] & " - " & [ATC2_DES]
		lineageTag: bc49d8e8-3f57-4ef8-b989-5db5fd0e869a
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC3_CODE_DESC_EN = [ATC3_COD] & " - " & [ATC3_DES]
		lineageTag: cfc7c2ec-66ef-40f6-9410-e884d6e0dbfa
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column ATC4_CODE_DESC_EN = [ATC4_COD] & " - " & [ATC4_DES]
		lineageTag: f4c0292a-91d1-47e5-9671-f5b87a72649b
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column PROD_DES_C_S
		dataType: string
		lineageTag: c2a0347a-d4ed-45b6-995c-c6c0a638cbcd
		summarizeBy: none
		sourceColumn: PROD_DES_C_S

		annotation SummarizationSetBy = Automatic

	column PROD_DES_S
		dataType: string
		lineageTag: c1f98745-7939-41f4-9726-71c68b2eae7d
		summarizeBy: none
		sourceColumn: PROD_DES_S

		annotation SummarizationSetBy = Automatic

	partition Dim_PackInfo = m
		mode: import
		queryGroup: 非首页
		source = ```
				let
				    Source = 
				Value.NativeQuery(
				        Databricks.Catalogs(
				            ServerAddress, HttpPath, [
				                Catalog = CatalogName,
				                Database = null,
				                EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
				            ]
				        ){
				            [Name = CatalogName, Kind = "Database"]
				        }[Data],
				"
				with dim_pack (
				  select CMPS_COD,min(CMPS_DES_C) CMPS_DES_C, min(CMPS_RN) CMPS_RN 
				  from dm.DM_TD_EXTERNAL_PACKINFO group by 1
				),
				
				dim_manu as (
				  select PACK_COD,DATA_SOURCE,max(MANU_DES_C) MANU_DES_C 
				  from DM.dm_td_external_packinfo_temp2
				  group by 1,2)
				,result (
				SELECT
				    DISTINCT A.PACK_COD,
				    PACK_DES,
				    PACK_LCH,
				    A.PROD_COD,
				    A.PROD_DES,
				    PROD_DES_C,
				    A.CMPS_COD,
				    case when A.CMPS_DES is null or A.CMPS_DES='' then '-' else upper(A.CMPS_DES) end as CMPS_DES,
				    case when B.CMPS_DES_C is null or B.CMPS_DES_C='' then '-' else upper(B.CMPS_DES_C) end as CMPS_DES_C,
				    A.VBP_BATCH,
				    A.VBP_IMPLEMENTING_TIME,
				    STGH_DES,
				    BIO_DESC,
				    ETH_OTC_DESC,
				    NRDL_DESC,
				    NRDL_ENTRY_DATE,
				    EDL_DESC,
				    TCM_DESC,
				    A.PAED_DESC,
				    GQCE_DESC,
				    MANU_COD,
				    MANU_DES,
				    MNFL_COD,
				    ATC1_COD,
				    ATC1_DES,
				    ATC1_DES_C,
				    ATC2_COD,
				    C.MANU_DES_C,
				    ATC2_DES,
				    ATC2_DES_C,
				    ATC3_COD,
				    ATC3_DES,
				    ATC3_DES_C,
				    ATC4_COD,
				    ATC4_DES,
				    ATC4_DES_C,
				    APP1_COD,
				    APP1_DES,
				    APP1_DES_C,
				    APP2_COD,
				    APP2_DES,
				    APP2_DES_C,
				    APP3_COD,
				    APP3_DES,
				    APP3_DES_C,
				    GENE_ORIG_DESC,
				    VBP_DESC,
				    VBP_BRAND,
				    CORP_COD,
				    GEN_RN,
				    CORP_DES,
				    CORP_DES_C,
				    PACK_RN,
				    PROD_RN,
				    B.CMPS_RN,
				    A.DATA_SOURCE,
				    ATC,
				    NEW_CODE,
				    COMMON_NAME,
				    PRODUCT_NAME,
				    MANU_DES_XIEHE,
				    PACK_DES_XIEHE,
				    DRUG_DELIVERY_ROUTE,
				    NFC,
				    CORP_TYPE,
				    LAUNCHTIME
				FROM
				    DM.DM_TD_EXTERNAL_PACKINFO A 
				left join dim_pack B ON A.CMPS_COD = B.CMPS_COD
				left join dim_manu C ON A.PACK_COD = C.PACK_COD and A.DATA_SOURCE = C.DATA_SOURCE
				union all
				select 
				'DTPOTHERS' PACK_COD
				,'DTPOTHERS' PACK_DES
				,'Y2005M03' PACK_LCH
				,'DTPOTHERS' PROD_COD
				,'DTPOTHERS' PROD_DES
				,'DTPOTHERS' as PROD_DES_C
				,'DTPOTHERS' as CMPS_COD
				,'DTPOTHERS' as CMPS_DES
				,'DTPOTHERS' as CMPS_DES_C
				,'DTPOTHERS' as VBP_BATCH
				,'DTPOTHERS' as VBP_IMPLEMENTING_TIME
				,'DTPOTHERS' as STGH_DES
				,'DTPOTHERS' as BIO_DESC
				,'DTPOTHERS' as ETH_OTC_DESC
				,'DTPOTHERS' as NRDL_DESC
				,'DTPOTHERS' as NRDL_ENTRY_DATE
				,'DTPOTHERS' as EDL_DESC
				,'DTPOTHERS' as TCM_DESC
				,'DTPOTHERS' as PAED_DESC
				,'DTPOTHERS' as GQCE_DESC
				,'DTPOTHERS' as MANU_COD
				,'DTPOTHERS' as MANU_DES
				,'DTPOTHERS' as MNFL_COD
				,'L' as ATC1_COD
				,'ANTINEOPLAST+IMMUNOMODUL' as ATC1_DES
				,'抗肿瘤药及免疫调节剂' as ATC1_DES_C
				,'L01' as ATC2_COD
				,'' MANU_DESC_C
				,'ANTINEOPLASTICS' as ATC2_DES
				,'抗肿瘤药' as ATC2_DES_C
				,'DTPOTHERS' as ATC3_COD
				,'DTPOTHERS' as ATC3_DES
				,'DTPOTHERS' as ATC3_DES_C
				,'DTPOTHERS' as ATC4_COD
				,'DTPOTHERS' as ATC4_DES
				,'DTPOTHERS' as ATC4_DES_C
				,'DTPOTHERS' as APP1_COD
				,'DTPOTHERS' as APP1_DES
				,'DTPOTHERS' as APP1_DES_C
				,'DTPOTHERS' as APP2_COD
				,'DTPOTHERS' as APP2_DES
				,'DTPOTHERS' as APP2_DES_C
				,'DTPOTHERS' as APP3_COD
				,'DTPOTHERS' as APP3_DES
				,'DTPOTHERS' as APP3_DES_C
				,'DTPOTHERS' as GENE_ORIG_DESC
				,'DTPOTHERS' as VBP_DESC
				,'VBP-IN' as VBP_BRAND
				,'DTPOTHERS' as CORP_COD
				,'DTPOTHERS' as GEN_RN
				,'DTPOTHERS' as CORP_DES
				,'DTPOTHERS' as CORP_DES_C
				,'DTPOTHERS' as PACK_RN
				,'DTPOTHERS' as PROD_RN
				,'DTPOTHERS' as CMPS_RN
				,'DTPOTHERS' as DATA_SOURCE
				,NULL as ATC
				,'' as NEW_CODE
				,NULL as COMMON_NAME
				,NULL as PRODUCT_NAME
				,NULL as MANU_DES_XIEHE
				,NULL as PACK_DES_XIEHE
				,NULL as DRUG_DELIVERY_ROUTE
				,NULL as NFC
				,'MNC' as CORP_TYPE
				,NULL as LAUNCHTIME)
				
				select t1.* 
				,if( t2.prod_cod is not null , concat(t1.PROD_DES_C,'(',t1.prod_cod,')(',t1.cmps_cod,')'),t1.PROD_DES_C) as PROD_DES_C_S 
				,if( t2.prod_cod is not null , concat(t1.PROD_DES,'(',t1.prod_cod,')(',t1.cmps_cod,')'),t1.PROD_DES) as PROD_DES_S 
				from result t1
				left join dm.dm_td_exchange_packinfo_m_prod t2 on t1.prod_cod = t2.prod_cod and t1.cmps_cod = t2.cmps_cod and t1.data_source = t2.data_source
				         "
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_ResultType = Table

	annotation PBI_NavigationStepName = Navigation