From a49ea5273d65c8d425e870865c01c4c0d36d232b Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周三, 24 4月 2024 15:31:28 +0800 Subject: [PATCH] 1 --- 使用文档/PDManer文件/原材料库标准化.pdma.json | 729 ++++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 683 insertions(+), 46 deletions(-) diff --git "a/\344\275\277\347\224\250\346\226\207\346\241\243/PDManer\346\226\207\344\273\266/\345\216\237\346\235\220\346\226\231\345\272\223\346\240\207\345\207\206\345\214\226.pdma.json" "b/\344\275\277\347\224\250\346\226\207\346\241\243/PDManer\346\226\207\344\273\266/\345\216\237\346\235\220\346\226\231\345\272\223\346\240\207\345\207\206\345\214\226.pdma.json" index db480ab..d200acb 100755 --- "a/\344\275\277\347\224\250\346\226\207\346\241\243/PDManer\346\226\207\344\273\266/\345\216\237\346\235\220\346\226\231\345\272\223\346\240\207\345\207\206\345\214\226.pdma.json" +++ "b/\344\275\277\347\224\250\346\226\207\346\241\243/PDManer\346\226\207\344\273\266/\345\216\237\346\235\220\346\226\231\345\272\223\346\240\207\345\207\206\345\214\226.pdma.json" @@ -4,7 +4,7 @@ "avatar": "", "version": "4.1.3", "createdTime": "2024-4-12 12:56:29", - "updatedTime": "2024-4-24 11:14:06", + "updatedTime": "2024-4-24 15:31:08", "dbConns": [], "profile": { "default": { @@ -22332,24 +22332,6 @@ "extProps": {}, "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", "id": "03697579-7244-40F5-AA8B-C3D40CE812AC" - }, - { - "defKey": "PackagingId", - "defName": "瀹瑰櫒鍏崇郴ID", - "comment": "", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "extProps": {}, - "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", - "id": "32B76A0D-27DE-45C1-843B-42291C89BC37", - "baseType": "87021CD5-DD8A-45AD-A867-A55DFE7993F5" }, { "defKey": "SpecLength", @@ -46372,7 +46354,7 @@ } }, "defKey": "wms_container_packaging", - "defName": "鍖呰鍏崇郴鍩虹琛�", + "defName": "瀹瑰櫒鍏崇郴鍩虹琛�", "comment": "", "properties": { "partitioned by": "(date string)", @@ -47097,7 +47079,7 @@ }, { "id": "DB5F4834-B505-42CD-AE08-4567BC104B5B", - "defKey": "ware_purchase_order", + "defKey": "wms_purchase_order", "defName": "閲囪喘璁㈠崟", "comment": "", "properties": {}, @@ -47222,7 +47204,7 @@ "extProps": {} }, { - "defKey": "OrderStatus", + "defKey": "PoStatus", "defName": "璁㈠崟鐘舵��", "comment": "", "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", @@ -47239,7 +47221,7 @@ "extProps": {} }, { - "defKey": "OrderStatusName", + "defKey": "PoStatusName", "defName": "璁㈠崟鐘舵�佸悕绉�", "comment": "", "type": "", @@ -47276,9 +47258,9 @@ "defKey": "Erp_CreatedUserName", "defName": "ERP鍒涘缓浜�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 100, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": true, @@ -47310,9 +47292,9 @@ "defKey": "Erp_UpdatedUserName", "defName": "ERP淇敼浜�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 100, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": true, @@ -47327,9 +47309,9 @@ "defKey": "SupplierCode", "defName": "渚涘簲鍟嗙紪鍙�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 100, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": true, @@ -47344,9 +47326,9 @@ "defKey": "SupplierName", "defName": "渚涘簲鍟嗗悕绉�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 100, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": true, @@ -47620,7 +47602,7 @@ "codeRoot": "" } }, - "defKey": "ware_purchase_order_detail", + "defKey": "wms_purchase_order_details", "defName": "閲囪喘璁㈠崟鏄庣粏", "comment": "", "properties": { @@ -47778,6 +47760,142 @@ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64" }, { + "defKey": "PoNo", + "defName": "PO鍗曞彿", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "214F72E5-203B-4E62-A85A-E5E0B97B20D6" + }, + { + "defKey": "LineNumber", + "defName": "琛屽彿", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "68EC5031-C525-4014-A870-EEA563D7BD61" + }, + { + "defKey": "MaterialCode", + "defName": "鐗╂枡缂栧彿", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "1E1CA509-F19F-44CD-A687-77AED7909870" + }, + { + "defKey": "MaterialName", + "defName": "鐗╂枡鍚嶇О", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "988224E2-3C6E-4741-8CAD-F5946A04ACE9" + }, + { + "defKey": "Quantity", + "defName": "鏁伴噺", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "FF4459C5-6B45-4DBF-8FC0-E06239BC05B4", + "id": "8484494C-9F93-4DFC-9B29-D83B53247A08" + }, + { + "defKey": "GoodsQuantity", + "defName": "宸叉敹鏁伴噺", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "FF4459C5-6B45-4DBF-8FC0-E06239BC05B4", + "id": "7CB93857-C8CE-42A7-9207-596CDCED440D" + }, + { + "defKey": "PoDetailStatus", + "defName": "鐘舵��", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", + "id": "14C0B727-EBF2-4892-B030-14F9F3247CE0" + }, + { + "defKey": "PoDetailStatusName", + "defName": "鐘舵�佸悕绉�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573", + "id": "19D47B20-C306-4A19-969B-F4BE956CAF82" + }, + { "defKey": "CreatedUserName", "defName": "鍒涘缓浜�", "comment": "", @@ -47901,6 +48019,522 @@ "extProps": {}, "domain": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF", "id": "7E74E49B-9173-4369-A72B-A06B239B1B36", + "baseType": "7ECAE23D-9FDB-4015-93BC-459D56A1ACA1" + } + ], + "correlations": [], + "indexes": [] + }, + { + "id": "C22D87B4-5948-4F14-ACA8-02ADD529205B", + "env": { + "base": { + "nameSpace": "", + "codeRoot": "" + } + }, + "defKey": "wms_purchase_order_sn", + "defName": "閲囪喘璁㈠崟鏉$爜琛�", + "comment": "", + "properties": { + "partitioned by": "(date string)", + "row format delimited": "", + "fields terminated by ','": "", + "collection items terminated by '-'": "", + "map keys terminated by ':'": "", + "store as textfile;": "" + }, + "nameTemplate": "{defKey}[{defName}]", + "headers": [ + { + "refKey": "hideInGraph", + "hideInGraph": true + }, + { + "refKey": "defKey", + "freeze": false, + "hideInGraph": false + }, + { + "refKey": "defName", + "freeze": false, + "hideInGraph": false + }, + { + "refKey": "primaryKey", + "freeze": false, + "hideInGraph": false + }, + { + "refKey": "notNull", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "autoIncrement", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "domain", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "type", + "freeze": false, + "hideInGraph": false + }, + { + "refKey": "len", + "freeze": false, + "hideInGraph": false + }, + { + "refKey": "scale", + "freeze": false, + "hideInGraph": false + }, + { + "refKey": "comment", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "refDict", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "defaultValue", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "isStandard", + "freeze": false, + "hideInGraph": false + }, + { + "refKey": "uiHint", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "extProps", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr1", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr2", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr3", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr4", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr5", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr6", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr7", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr8", + "freeze": false, + "hideInGraph": true + }, + { + "refKey": "attr9", + "freeze": false, + "hideInGraph": true + } + ], + "fields": [ + { + "defKey": "Id", + "defName": "Id涓婚敭", + "comment": "", + "type": "", + "len": 32, + "scale": "", + "primaryKey": true, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": true, + "domain": "16120F75-6AA7-4483-868D-F07F511BB081", + "refDict": "", + "uiHint": "", + "id": "099B34CC-EE58-4004-BA32-62403FF5052F", + "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64" + }, + { + "defKey": "PoNo", + "defName": "PO鍗曞彿", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "04B0739F-E483-42E1-BE17-8D9B916E4E58" + }, + { + "defKey": "LineNumber", + "defName": "PO鍗曟槑缁嗚鍙�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "E14403FE-8560-4A67-836D-72006FB71ADB" + }, + { + "defKey": "MaterialCode", + "defName": "鐗╂枡缂栧彿", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "EC78D09D-1424-4FAA-BB92-9634C95A165A" + }, + { + "defKey": "MaterialName", + "defName": "鐗╂枡鍚嶇О", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "3B7232BC-8C44-44C6-8337-896743141946" + }, + { + "defKey": "Quantity", + "defName": "鏁伴噺", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "FF4459C5-6B45-4DBF-8FC0-E06239BC05B4", + "id": "E866F19F-2363-4BFB-8013-D4404DECF3E7" + }, + { + "defKey": "GoodQuantity", + "defName": "宸叉敹璐ф暟閲�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "FF4459C5-6B45-4DBF-8FC0-E06239BC05B4", + "id": "A994DF6C-2E98-4048-AC64-15FE4108DA11" + }, + { + "defKey": "PoSNStatus", + "defName": "鐘舵��", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", + "id": "BD33EA09-49D2-4C9D-85B6-29244B8F327D" + }, + { + "defKey": "PoSNStatusName", + "defName": "鐘舵�佸悕绉�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "1EED9880-A6EF-48B5-B739-8E5CF52ACDA0" + }, + { + "defKey": "DefaultGoodPlaceCode", + "defName": "榛樿鏀惰揣搴撳瓨鍦�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "69131063-0F12-4398-8884-0F1BDE06DCA3" + }, + { + "defKey": "SN_1d", + "defName": "涓�缁存潯鐮�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573", + "id": "667C4F0F-DD49-4B74-9F74-C38DF9998A8A" + }, + { + "defKey": "SN_2d", + "defName": "浜岀淮鏉$爜", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573", + "id": "C3801BA3-6565-4EFF-A05E-14FEA35F0E02" + }, + { + "defKey": "Unit", + "defName": "鍗曚綅", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "9D98E783-93C6-4467-94A0-5437BDD8220E" + }, + { + "defKey": "Package", + "defName": "鍖呰鍚嶇О", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573", + "id": "25CF711F-31AC-4D64-9E8F-FBDD0FCBC156" + }, + { + "defKey": "CreatedUserName", + "defName": "鍒涘缓浜�", + "comment": "", + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": true, + "refDict": "", + "uiHint": "", + "id": "0A907592-7DC8-4815-9F12-05A105564E91", + "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64" + }, + { + "defKey": "CreatedTime", + "defName": "鍒涘缓鏃堕棿", + "comment": "", + "domain": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": true, + "refDict": "", + "uiHint": "", + "id": "C1FD28B2-9A67-470C-A87C-F48EECA19159", + "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811" + }, + { + "defKey": "UpdatedUserName", + "defName": "淇敼浜�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "44DA680B-C590-4EFB-A459-C2D450187787", + "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD" + }, + { + "defKey": "UpdatedTime", + "defName": "淇敼鏃堕棿", + "comment": "", + "domain": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": true, + "refDict": "", + "uiHint": "", + "id": "615C0179-8EC8-4694-B020-2FC730A3D233", + "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64" + }, + { + "defKey": "CreatedUserId", + "defName": "鍒涘缓鑰匢d", + "comment": "", + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": true, + "refDict": "", + "uiHint": "", + "id": "9A224F59-E675-486A-9371-4491CA2D5825", + "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098" + }, + { + "defKey": "UpdatedUserId", + "defName": "淇敼鑰匢d", + "comment": "", + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": false, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": true, + "refDict": "", + "uiHint": "", + "id": "8DE1BBFC-CAB5-483B-A0A0-BBDDFA903286", + "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098" + }, + { + "defKey": "IsDeleted", + "defName": "杞垹闄ゆ爣璁�", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF", + "id": "7F58279F-6A3B-43E2-9AFC-9B90EBD0AFAA", "baseType": "7ECAE23D-9FDB-4015-93BC-459D56A1ACA1" } ], @@ -48489,7 +49123,10 @@ "defName": "鏀惰揣妯″潡", "refEntities": [ "DB5F4834-B505-42CD-AE08-4567BC104B5B", - "1E8FB3C6-3DE7-475D-974F-440A48C5557A" + "1E8FB3C6-3DE7-475D-974F-440A48C5557A", + "C22D87B4-5948-4F14-ACA8-02ADD529205B", + "9EE1CECB-ADFE-4CF7-976A-DF78066FE724", + "4CEB0052-B01C-4573-9B1A-997C752AF08F" ], "refViews": [], "refDiagrams": [], @@ -48734,6 +49371,15 @@ }, "domains": [ { + "defKey": "DefaultString2", + "defName": "瀛椾覆nvarchar50", + "applyFor": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", + "len": 50, + "scale": "", + "uiHint": "", + "id": "94107640-E002-4AB3-A2DC-B66F98D9645F" + }, + { "defKey": "DefaultString", "defName": "瀛椾覆varchar255", "applyFor": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64", @@ -48849,15 +49495,6 @@ "scale": "", "uiHint": "", "id": "717941D9-8B3F-435A-9F8E-8D13B7404D5B" - }, - { - "defKey": "DefaultString2", - "defName": "瀛椾覆nvarchar50", - "applyFor": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "len": 50, - "scale": "", - "uiHint": "", - "id": "94107640-E002-4AB3-A2DC-B66F98D9645F" } ], "diagrams": [], -- Gitblit v1.9.3