首頁 探索 說明
登入
U9_Coos_PDA
/
CustApi_and_Plugin_zky
7
0
複刻 0
檔案 問題管理 0 合併請求 0 Wiki
分支: master
分支列表 標籤列表
CustApi_and_...
/
bulk
/
Unconfiged
/
MetadataScript
/
UFIDA.U9.Cust.Kusi.CJJ.RestApi_Metadata.sql

UFIDA.U9.Cust.Kusi.CJJ.RestApi_Metadata.sql 40 KB
永久連結 文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142 
  1. 	declare	@SNIndex bigint
    2. 

  2. 	if object_id('InnerAllocSerials') is null
    3. 

  3. 	    exec	[dbo].[AllocSerials]
    4. 

  4. 			    @AllocCount = 20000,
    5. 

  5. 			    @StartSN = @SNIndex output
    6. 

  6. 

  7. 	else
    8. 

  8. 	    exec	[dbo].[InnerAllocSerials]
    9. 

  9. 			    @AllocCount = 20000,
    10. 

  10. 			    @StartSN = @SNIndex output
    11. 

  11. --Valid @SNIndex
    12. 

  12. 

  13. 

  14. execute sp_UninstallMDProject '9991f6b4-43ad-4398-b2aa-3d808d9cbc8a'
    15. 

  15. INSERT INTO UBF_MD_Project(Name, ID, AssemblyName, CreateOp, ComponentType, ModifyTime, ModifyOp, CreateTime) VALUES('RestApi', '9991f6b4-43ad-4398-b2aa-3d808d9cbc8a', 'UFIDA.U9.Cust.Kusi.CJJ.RestApi', 'Administrator', 'SV', '2022-10-26T11:49:02', '', '2022-10-26T11:49:02')
    16. 

  16. INSERT INTO UBF_MD_Import(Source_ID, Imported_ID) VALUES('9991f6b4-43ad-4398-b2aa-3d808d9cbc8a', 'd62d005c-8d70-4592-b6dc-1600738192f0')
    17. 

  17. INSERT INTO UBF_MD_Import(Source_ID, Imported_ID) VALUES('9991f6b4-43ad-4398-b2aa-3d808d9cbc8a', '8a97edaa-7ccf-4270-813c-74a07f236995')
    18. 

  18. INSERT INTO UBF_MD_Component(Local_ID, Kind, Name, ID, AssemblyName, CreateOp, ModifyTime, Version, ModifyOp, MD_Module_ID, CreateTime) VALUES(@SNIndex+0, 'SV', 'RestApi', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', 'UFIDA.U9.Cust.Kusi.CJJ.RestApi', 'Administrator', '2022-10-26T11:49:03', '', '', '9991f6b4-43ad-4398-b2aa-3d808d9cbc8a', '2022-10-26T11:49:03')
    19. 

  19. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('aeb4fae6-4766-4816-936b-81049740746c', 'CreateRcvRptDocCostWithPackage', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+1, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.CreateRcvRptDocCostWithPackage', 0, 1, 0, '1f214add-11d6-4e71-89e6-249fe5768a06', 1, 'UFIDA.UBF.MD.Business.Service')
    20. 

  20. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('a8c799f0-5ea1-4db0-b8e3-0bb422375261', 'LineDTOs', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+2, 'aeb4fae6-4766-4816-936b-81049740746c', @SNIndex+1, '32410574-e5e5-4767-9cae-43ba503fbfc5', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '80df73d3-5b74-4206-a39f-a30e5c55ad10', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    21. 

  21. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('f237ddf6-b9a8-4701-bd0a-330631ea7911', 'POToRcvBCSVWithPackage', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+3, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.POToRcvBCSVWithPackage', 0, 1, 0, '8867ef21-57a8-4de4-9909-a3501d0f9957', 1, 'UFIDA.UBF.MD.Business.Service')
    22. 

  22. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('672be4a2-8085-44f5-9480-870009da203d', 'SrcDocBarCodes', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+4, 'f237ddf6-b9a8-4701-bd0a-330631ea7911', @SNIndex+3, 'cf687e6e-2246-4ce3-87de-07124494e496', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '4ab0e474-1bd6-4f5d-b0cb-0596a0f4222a', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    23. 

  23. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('8bf0c345-64b2-47cd-996b-e878a7da23d1', 'CreateDocByQuickTransInWithPackage', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+5, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.CreateDocByQuickTransInWithPackage', 0, 1, 0, '24cb13cb-82f3-49b9-bb7e-8d9466f1870f', 1, 'UFIDA.UBF.MD.Business.Service')
    24. 

  24. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('d28944e6-e9dc-4f6d-b7a4-b8ece518dabd', 'ParamInList', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+6, '8bf0c345-64b2-47cd-996b-e878a7da23d1', @SNIndex+5, '4a78bb9b-46c2-4769-8c56-6f2f6f159d91', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '0413ba4b-8222-4c48-8885-09929c832405', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    25. 

  25. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('15aae3a6-20f1-40f8-b557-8909d2a1b2a9', 'CreateMiscRcvTransWithPackage', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+7, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.CreateMiscRcvTransWithPackage', 0, 1, 0, '1f214add-11d6-4e71-89e6-249fe5768a06', 1, 'UFIDA.UBF.MD.Business.Service')
    26. 

  26. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('b9969e17-b912-4dcb-b1bd-a783b8ecf7cd', 'LineDTOs', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+8, '15aae3a6-20f1-40f8-b557-8909d2a1b2a9', @SNIndex+7, 'd6a023cf-8916-45e2-8dc7-98f168c5b6d1', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '6b952f4c-db2f-4823-bd36-970c60f2286b', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    27. 

  27. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('e5adce25-bb7a-483d-ab71-e9fb16234dd6', 'CreateMiscShipmentWithPackageSV', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+9, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.CreateMiscShipmentWithPackageSV', 0, 1, 0, '3d174255-fd12-47f7-8844-3b5e4fae9e8c', 1, 'UFIDA.UBF.MD.Business.Service')
    28. 

  28. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('666fb81b-476a-4040-80e7-ea651a348eeb', 'LineDTOs', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+10, 'e5adce25-bb7a-483d-ab71-e9fb16234dd6', @SNIndex+9, 'd6a023cf-8916-45e2-8dc7-98f168c5b6d1', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 'f8cbae53-f287-49ee-879c-5a07ba29fa3e', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    29. 

  29. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('17ba8cbd-409e-4fd0-bf99-f2c37d1651e4', 'FileUploadService', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+11, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.FileUploadService', 0, 1, 0, 'd7c6031e-d3fe-41aa-a397-5edd86c10cae', 1, 'UFIDA.UBF.MD.Business.Service')
    30. 

  30. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('3541f71b-6aa4-4482-b66c-680ac783473f', 'FileInfos', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+12, '17ba8cbd-409e-4fd0-bf99-f2c37d1651e4', @SNIndex+11, '8170a9f0-f2ae-483f-ac7c-476242649562', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 'ad9f6c5f-c1d7-4c4c-9f04-c5bee164190f', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    31. 

  31. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('84f8eca8-4c57-4cc3-a0dd-ce223f62e011', 'GetItemBarCodeDetails', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+13, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.GetItemBarCodeDetails', 0, 1, 0, '591a3b96-f95e-405c-88ea-54be7b221754', 1, 'UFIDA.UBF.MD.Business.Service')
    32. 

  32. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('f21c701c-7822-4980-ac4f-97aa1884faec', 'BarCodeInfo', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+14, '84f8eca8-4c57-4cc3-a0dd-ce223f62e011', @SNIndex+13, '675706a9-bb6c-4190-ab5f-f4812918d759', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '7373d39b-85e0-4547-b3ae-54b641e045a1', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    33. 

  33. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('e619bc2f-5219-47ae-88b2-71c4b04ea280', 'AnalyzeDocBarCodeSV', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+15, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.AnalyzeDocBarCodeSV', 0, 1, 2, '84f8bcfa-3eaf-4987-a67b-ebcbbd7a5ac9', 1, 'UFIDA.UBF.MD.Business.Service')
    34. 

  34. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('9a5d124a-0a6d-412f-9cc7-d7caaafa9da8', 'BarCodes', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+16, 'e619bc2f-5219-47ae-88b2-71c4b04ea280', @SNIndex+15, '90d4945f-8682-4da2-83c0-fdd784530934', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '1657cf15-5a01-414e-ab76-f755bdeed4bf', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    35. 

  35. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('f40352b9-4e52-4679-af1a-d6318c25cb1c', 'DeleteAttachmentSV', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+17, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.DeleteAttachmentSV', 0, 1, 0, 'd7c6031e-d3fe-41aa-a397-5edd86c10cae', 1, 'UFIDA.UBF.MD.Business.Service')
    36. 

  36. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('a0025f60-a0ae-4418-a9af-2ab8f74b3a1d', 'DeleteInfos', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+18, 'f40352b9-4e52-4679-af1a-d6318c25cb1c', @SNIndex+17, '4dcae8a8-631a-494d-b588-72d5b2c81010', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '318444df-5bc0-426c-b257-3f1403ed1ce5', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    37. 

  37. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('313cf1ac-074b-4093-bcbc-4289751981fd', 'GetBarCodeUsedWhBinInfoSV', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+19, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.GetBarCodeUsedWhBinInfoSV', 0, 1, 2, '986dc553-ea41-487b-8068-f4ff92b712ed', 1, 'UFIDA.UBF.MD.Business.Service')
    38. 

  38. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('34dcb3a0-cf67-478d-8772-8fed4a7c7170', 'BarCodeUsedIDs', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+20, '313cf1ac-074b-4093-bcbc-4289751981fd', @SNIndex+19, 'ba391065-6c27-4c82-acc8-b52b1c93a910', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 'e50e27bb-3c78-4ff0-859a-6b04d799a77b', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    39. 

  39. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('3330c9e0-073f-4da7-b9b5-f0d0627718ee', 'GetBarCodeExtInfoSV', 'Administrator', '2022-10-26T11:49:03', 'Administrator', '2022-10-26T11:55:11', @SNIndex+21, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.GetBarCodeExtInfoSV', 0, 1, 2, 'e3f1f9af-5243-4d7f-b5f9-a48cd86fac08', 1, 'UFIDA.UBF.MD.Business.Service')
    40. 

  40. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('8d052fcc-97c1-4481-a663-377dd3e2de52', 'BarCodes', 'Administrator', '2022-10-26T11:49:03', '', '2022-10-26T11:49:03', @SNIndex+22, '3330c9e0-073f-4da7-b9b5-f0d0627718ee', @SNIndex+21, '90d4945f-8682-4da2-83c0-fdd784530934', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '745310be-c848-454a-9b33-01f727dde706', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    41. 

  41. INSERT INTO UBF_MD_Class (ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_ParentClass_ID, MD_Component_ID, Local_Component_ID, ClassType, FullName, IsDefault, IsService, TransactionType, ReturnTypeID, IsAuthority, Discriminator) VALUES ('55d4c613-4712-4338-a5b1-bc1aa0f48dde', 'ShipPickConfirmUpdateBarCodeFirstSV', 'Administrator', '2022-10-26T11:49:29', 'Administrator', '2022-10-26T11:55:11', @SNIndex+23, '00000000-0000-0000-0000-000000000000', '95ba9be8-c788-4535-8acf-e8d3b66b20d7', @SNIndex+0, 7, 'UFIDA.U9.Cust.Kusi.CJJ.RestApi.ShipPickConfirmUpdateBarCodeFirstSV', 0, 1, 0, '378d45b4-375d-4b5d-8748-abc9575c26b3', 1, 'UFIDA.UBF.MD.Business.Service')
    42. 

  42. INSERT INTO UBF_MD_Attribute(ID, Name, CreateOp, CreateTime, ModifyOp, ModifyTime, Local_ID, MD_Class_ID, Local_Class_ID, DataTypeID, GroupName, IsCollection, DefaultValue, Length, Precision, Sequence, Scale, MaxValue, MinValue, IsKey, IsNullable, IsReadOnly, Visibility, IsCalculation, IsGlobalization, IsSystem, IsBusinessKey, IsQueryAttribute, IsForAsso, GroupID, IsModifyControl, IsDynamic, IsImpressible, IsInCache, IsKeySerializable, IsColumnDefine, IsFilterDefine, IsSortDefine, IsDefaultColumn, IsEntityData, DefaultColumnName, DataTypeFlag,ForOBAImport) VALUES('7b59f02e-7c85-495f-895b-d96b4c0a8bac', 'DocInfo', 'Administrator', '2022-10-26T11:54:10', '', '2022-10-26T11:54:10', @SNIndex+24, '55d4c613-4712-4338-a5b1-bc1aa0f48dde', @SNIndex+23, 'f638d3a0-9ede-480c-bb1b-20fe1a258e91', 'Misc', 1, '', 50, 5, 0, 0, '', '', 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 'a69eb67a-c1ec-4f84-b669-60b600463447', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, '', 4,0)
    43.