From 2ba495dce3e0c99ed4e59d5ac7b1514e188d4a83 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 25 4月 2024 10:00:19 +0800 Subject: [PATCH] 1 --- 使用文档/PDManer文件/原材料库标准化.pdma.json | 1156 +++++++++++++-------------------------------------------- 1 files changed, 262 insertions(+), 894 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 9e2c306..bb96134 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-25 09:36:35", + "updatedTime": "2024-4-25 10:00:13", "dbConns": [], "profile": { "default": { @@ -669,7 +669,7 @@ "#DDE5FF" ], "DDLToggleCase": "L", - "menuWidth": "283px", + "menuWidth": "293px", "extAttrProps": { "attr1": { "editType": "", @@ -33823,8 +33823,8 @@ }, { "id": "9EE1CECB-ADFE-4CF7-976A-DF78066FE724", - "defKey": "wms_receiptorder", - "defName": "鏀惰揣鍗�", + "defKey": "wms_order_asn", + "defName": "ASN涓昏〃", "comment": "", "properties": {}, "fields": [ @@ -33832,8 +33832,8 @@ "defKey": "Id", "defName": "Id涓婚敭", "comment": "", - "domain": "", - "type": "bigint", + "domain": "16120F75-6AA7-4483-868D-F07F511BB081", + "type": "", "len": "", "scale": "", "primaryKey": true, @@ -33857,11 +33857,28 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "OrderLargeCategory", - "defName": "鍗曟嵁澶х被", + "defKey": "AsnNo", + "defName": "ASN鍗曞彿", "comment": "", - "domain": "", - "type": "bigint", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "92368330-A11D-4ACE-8FE0-4A032E105EB3" + }, + { + "defKey": "AsnType", + "defName": "鍗曟嵁绫诲瀷", + "comment": "", + "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -33885,11 +33902,11 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "OrderSubclass", - "defName": "鍗曟嵁灏忕被", + "defKey": "AsnTypeName", + "defName": "鍗曟嵁绫诲瀷鍚嶇О", "comment": "", - "domain": "", - "type": "bigint", + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -33913,11 +33930,11 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "SOID", - "defName": "涓婁綅绯荤粺鍗曟嵁鍞竴璇嗗埆鐮�", + "defKey": "AsnStatus", + "defName": "鍗曟嵁鐘舵��", "comment": "", - "domain": "", - "type": "bigint", + "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -33941,12 +33958,12 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "NO", - "defName": "鍗曟嵁缂栧彿", + "defKey": "AsnStatusName", + "defName": "鍗曟嵁鐘舵�佸悕绉�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": true, @@ -33969,12 +33986,12 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "WMSNO", - "defName": "WMS鏀惰揣鍗曞彿", + "defKey": "TrackingNumber", + "defName": "鐗╂祦鍗曞彿", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -33997,71 +34014,15 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "Billdate", - "defName": "鍒涘缓鏃ユ湡", + "defKey": "ReleaseStatus", + "defName": "閲婃斁鐘舵��", "comment": "", - "domain": "", - "type": "datetimeoffset", + "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", + "type": "", "len": "", "scale": "", "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "4861B38E-22D3-4340-8ACD-6C6A7858B119", - "baseType": "63EB55D7-63DF-4EC4-94C6-71CA5CA55DB3", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "SourceBillNo", - "defName": "閫佽揣閫氱煡鍗曞彿", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "D9F5B826-2E97-4DC7-B643-E73E285457CB", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "Vendorcode", - "defName": "渚涘簲鍟嗙紪鐮�", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, + "notNull": true, "autoIncrement": false, "defaultValue": "", "hideInGraph": false, @@ -34081,15 +34042,15 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "Vendorname", - "defName": "渚涘簲鍟嗗悕绉�", + "defKey": "ReleaseStatusName", + "defName": "閲婃斁鐘舵�佸悕绉�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, - "notNull": false, + "notNull": true, "autoIncrement": false, "defaultValue": "", "hideInGraph": false, @@ -34110,11 +34071,11 @@ }, { "defKey": "Companyname", - "defName": "鍏徃鍚嶇О", + "defName": "棰勮鍒拌揣鏃堕棿", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "7CFFA0D3-6A93-4DDC-BC10-DF21211064DC", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -34137,263 +34098,11 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "WarehouseKeepername", - "defName": "浠撶鍛�", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "C2F94387-84E4-407A-8801-BC6B91C6AAC8", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "TradeMode", - "defName": "璐告槗鏂瑰紡", - "comment": "", - "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "7B14D606-F871-4B0A-941B-D6A38B190F4D", - "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "WarehouseCentername", - "defName": "浠撳偍涓績", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "CCF37C0C-9793-4AE6-874F-6B5CE1D9A415", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "StoreRoomname", - "defName": "浠撻棿", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "87D2E547-AA22-4750-B7E6-2574F7CA29E7", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "DeclarationCode", - "defName": "鎶ュ叧鍗曞彿", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "69295E50-BF8D-49CE-87A2-7659DCB364A6", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "Majorname", - "defName": "涓撲笟", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "1106F479-0D3F-41BB-A1CF-B3CC922D2533", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "Remarks", - "defName": "澶囨敞", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 500, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "3FF95263-3598-4734-BC33-0932E14735C0", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "ReceivingStatus", - "defName": "鏀惰揣鐘舵��", - "comment": "", - "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "BECF4F07-1FB4-4A8A-BC03-0E0031B23F5D", - "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "InspectionStatus", - "defName": "鎶ユ鐘舵��", - "comment": "", - "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "A4032440-0DA2-492A-8107-5FAA4E3D354B", - "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { "defKey": "CreatedTime", "defName": "鍒涘缓鏃堕棿", "comment": "", - "domain": "", - "type": "datetimeoffset", + "domain": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -34420,8 +34129,8 @@ "defKey": "UpdatedTime", "defName": "鏇存柊鏃堕棿", "comment": "", - "domain": "", - "type": "datetimeoffset", + "domain": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -34448,8 +34157,8 @@ "defKey": "CreatedUserId", "defName": "鍒涘缓鑰匢d", "comment": "", - "domain": "", - "type": "bigint", + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -34474,11 +34183,11 @@ }, { "defKey": "CreatedUserName", - "defName": "鍒涘缓鑰呭悕绉�", + "defName": "鍒涘缓浜�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 50, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -34504,8 +34213,8 @@ "defKey": "UpdatedUserId", "defName": "淇敼鑰匢d", "comment": "", - "domain": "", - "type": "bigint", + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -34530,11 +34239,11 @@ }, { "defKey": "UpdatedUserName", - "defName": "淇敼鑰呭悕绉�", + "defName": "淇敼浜�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 50, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -34560,9 +34269,9 @@ "defKey": "IsDeleted", "defName": "杞垹闄ゆ爣璁�", "comment": "", - "domain": "", - "type": "bit", - "len": 1, + "domain": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": true, @@ -34689,8 +34398,8 @@ }, { "id": "4CEB0052-B01C-4573-9B1A-997C752AF08F", - "defKey": "wms_receiptorder_details", - "defName": "鏀惰揣鍗曟嵁鏄庣粏琛�", + "defKey": "wms_order_asn_detail", + "defName": "ASN鏄庣粏琛�", "comment": "", "properties": {}, "fields": [ @@ -34698,8 +34407,8 @@ "defKey": "Id", "defName": "Id涓婚敭", "comment": "", - "domain": "", - "type": "bigint", + "domain": "16120F75-6AA7-4483-868D-F07F511BB081", + "type": "", "len": "", "scale": "", "primaryKey": true, @@ -34723,11 +34432,11 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "OrderId", - "defName": "鍗曟嵁Id", + "defKey": "AsnId", + "defName": "ASN鍗曟嵁Id", "comment": "", - "domain": "", - "type": "bigint", + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -34751,11 +34460,11 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "OID", - "defName": "涓婁綅绯荤粺鍗曟嵁鏄庣粏鍞竴璇嗗埆鐮�", + "defKey": "AsnNo", + "defName": "ASN鍗曞彿", "comment": "", - "domain": "", - "type": "bigint", + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -34779,15 +34488,15 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "Materialcode", - "defName": "鐗╂枡缂栧彿", + "defKey": "AsnLineNumber", + "defName": "ASN鍗曟槑缁嗚鍙�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, - "notNull": false, + "notNull": true, "autoIncrement": false, "defaultValue": "", "hideInGraph": false, @@ -34807,12 +34516,12 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "Materialname", - "defName": "鐗╂枡鍚嶇О", + "defKey": "PoNo", + "defName": "PO鍗曞彿", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -34835,12 +34544,12 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "Unit", - "defName": "鍩烘湰鍗曚綅", + "defKey": "PoLineNumber", + "defName": "PO琛屽彿", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -34863,13 +34572,47 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "Qty", - "defName": "鏁伴噺", + "defKey": "MaterialCode", + "defName": "鐗╂枡缂栧彿", "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "id": "19587B4C-8AA7-41A4-A23C-B3EF4A976CEE" + }, + { + "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": "26EDD584-5B22-4158-BB62-95C1718101E2" + }, + { + "defKey": "Quantity", + "defName": "閫佽揣鏁伴噺", + "comment": "", + "domain": "FF4459C5-6B45-4DBF-8FC0-E06239BC05B4", + "type": "", + "len": "", + "scale": "", "primaryKey": false, "notNull": true, "autoIncrement": false, @@ -34891,13 +34634,13 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "SingleLength", - "defName": "鍗曟牴闀垮害", + "defKey": "GoodQuantity", + "defName": "宸叉敹鏁伴噺", "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, + "domain": "FF4459C5-6B45-4DBF-8FC0-E06239BC05B4", + "type": "", + "len": "", + "scale": "", "primaryKey": false, "notNull": true, "autoIncrement": false, @@ -34919,13 +34662,13 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "TheoreticalWeight", - "defName": "鐞嗚閲嶉噺", + "defKey": "SupplierCode", + "defName": "渚涘簲鍟嗙紪鍙�", "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", + "scale": "", "primaryKey": false, "notNull": true, "autoIncrement": false, @@ -34947,13 +34690,13 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "Price", - "defName": "涓嶅惈绋庡崟浠�", + "defKey": "SupplierName", + "defName": "渚涘簲鍟嗗悕绉�", "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", + "scale": "", "primaryKey": false, "notNull": true, "autoIncrement": false, @@ -34975,13 +34718,13 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "SumPrice", - "defName": "鎴愭湰閲戦", + "defKey": "Unit", + "defName": "鍗曚綅", "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", + "scale": "", "primaryKey": false, "notNull": true, "autoIncrement": false, @@ -35003,12 +34746,12 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "ProjectCode", - "defName": "椤圭洰缂栧彿", + "defKey": "QcStatus", + "defName": "璐ㄦ鐘舵��", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -35031,12 +34774,12 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "ContractCode", - "defName": "鍚堝悓缂栧彿", + "defKey": "QcStatusName", + "defName": "璐ㄦ鐘舵�佸悕绉�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -35059,403 +34802,11 @@ "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" }, { - "defKey": "TACode", - "defName": "TA鍙�", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "58D9F0B9-2177-4773-BCE4-165C86B3B86B", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "TradeName", - "defName": "鎶ュ叧鍝佸悕", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "5DCF9180-B4B9-48F7-B353-6E61786E6E54", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "ItemNo", - "defName": "鎶ュ叧椤瑰彿", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "6542079E-1196-4D11-A1F0-0BD20DBE3A45", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "CustomsUnitName", - "defName": "鎶ュ叧鍗曚綅", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "DAAE4A17-0217-428E-95DB-E777089A12C1", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "CustomsNum", - "defName": "鎶ュ叧鏁伴噺", - "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "3E33A7AE-63CA-4EE9-8299-6D9BC70AF09B", - "baseType": "1A0BDC09-0792-4174-9E8E-80BE8DF44B8E", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "CustomsPrices", - "defName": "鎶ュ叧閲戦", - "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "96124284-3212-4A91-8EC2-679346D7D185", - "baseType": "1A0BDC09-0792-4174-9E8E-80BE8DF44B8E", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "SpecialNeeds", - "defName": "鐗规畩瑕佹眰", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 255, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "1E9570CA-DAA8-4553-8B8E-2B0693F01F6F", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "ContainerCode", - "defName": "鎵樼洏缂栫爜", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 50, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "035E6B73-9E72-4F27-9EB7-29A39D0349B1", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "PlaceCode", - "defName": "搴撲綅缂栫爜", - "comment": "", - "domain": "", - "type": "nvarchar", - "len": 50, - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "87AD33E8-E3CD-40DD-9E10-4E62562609F4", - "baseType": "F8A4AFB0-F3B7-4E32-A5F2-D4D8D3F4BACD", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "DeliveryQty", - "defName": "閫佽揣鏁伴噺", - "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "9DD836DF-76FB-4B04-8FD1-6C73D824315D", - "baseType": "1A0BDC09-0792-4174-9E8E-80BE8DF44B8E", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "ReceivedQty", - "defName": "鏀惰揣鏁伴噺", - "comment": "", - "domain": "", - "type": "decimal", - "len": 18, - "scale": 2, - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "9F1B2D07-1AD3-418E-B3C0-C9BB7968A942", - "baseType": "1A0BDC09-0792-4174-9E8E-80BE8DF44B8E", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "ReceivingStatus", - "defName": "鏀惰揣鐘舵��", - "comment": "", - "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "A902B6C5-0854-43DB-BD46-074EE82C5EEB", - "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "InspectionStatus", - "defName": "鎶ユ鐘舵��", - "comment": "", - "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "96883750-B94D-4506-8481-E5FCC3E086B1", - "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { - "defKey": "InspectionResultsEnum", - "defName": "鎶ユ缁撴灉", - "comment": "", - "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": true, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "attr1": "", - "attr2": "", - "attr3": "", - "attr4": "", - "attr5": "", - "attr6": "", - "attr7": "", - "attr8": "", - "attr9": "", - "id": "4744522A-338A-41E7-BC55-FB2694662E06", - "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811", - "extProps": {}, - "uiHint": "642D2E0A-8846-4549-BE56-8C0473F26EDE" - }, - { "defKey": "CreatedTime", "defName": "鍒涘缓鏃堕棿", "comment": "", - "domain": "", - "type": "datetimeoffset", + "domain": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -35482,8 +34833,8 @@ "defKey": "UpdatedTime", "defName": "鏇存柊鏃堕棿", "comment": "", - "domain": "", - "type": "datetimeoffset", + "domain": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -35510,8 +34861,8 @@ "defKey": "CreatedUserId", "defName": "鍒涘缓鑰匢d", "comment": "", - "domain": "", - "type": "bigint", + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -35538,9 +34889,9 @@ "defKey": "CreatedUserName", "defName": "鍒涘缓鑰呭悕绉�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 50, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -35566,8 +34917,8 @@ "defKey": "UpdatedUserId", "defName": "淇敼鑰匢d", "comment": "", - "domain": "", - "type": "bigint", + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "type": "", "len": "", "scale": "", "primaryKey": false, @@ -35594,9 +34945,9 @@ "defKey": "UpdatedUserName", "defName": "淇敼鑰呭悕绉�", "comment": "", - "domain": "", - "type": "nvarchar", - "len": 50, + "domain": "94107640-E002-4AB3-A2DC-B66F98D9645F", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": false, @@ -35622,9 +34973,9 @@ "defKey": "IsDeleted", "defName": "杞垹闄ゆ爣璁�", "comment": "", - "domain": "", - "type": "bit", - "len": 1, + "domain": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF", + "type": "", + "len": "", "scale": "", "primaryKey": false, "notNull": true, @@ -46769,7 +46120,7 @@ }, { "id": "DB5F4834-B505-42CD-AE08-4567BC104B5B", - "defKey": "wms_purchase_order", + "defKey": "wms_order_purchase", "defName": "閲囪喘璁㈠崟", "comment": "", "properties": {}, @@ -47292,7 +46643,7 @@ "codeRoot": "" } }, - "defKey": "wms_purchase_order_details", + "defKey": "wms_order_purchase_details", "defName": "閲囪喘璁㈠崟鏄庣粏", "comment": "", "properties": { @@ -47484,7 +46835,7 @@ "id": "214F72E5-203B-4E62-A85A-E5E0B97B20D6" }, { - "defKey": "LineNumber", + "defKey": "PoLineNumber", "defName": "琛屽彿", "comment": "", "type": "", @@ -47740,7 +47091,7 @@ "codeRoot": "" } }, - "defKey": "wms_purchase_order_sn", + "defKey": "wms_order_purchase_sn", "defName": "閲囪喘璁㈠崟鏉$爜琛�", "comment": "", "properties": { @@ -47898,6 +47249,23 @@ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64" }, { + "defKey": "PoId", + "defName": "PO鍗旾D", + "comment": "", + "type": "", + "len": "", + "scale": "", + "primaryKey": false, + "notNull": true, + "autoIncrement": false, + "defaultValue": "", + "hideInGraph": false, + "refDict": "", + "extProps": {}, + "domain": "717941D9-8B3F-435A-9F8E-8D13B7404D5B", + "id": "B3F31C54-B216-4D96-9319-C10B381238E5" + }, + { "defKey": "PoNo", "defName": "PO鍗曞彿", "comment": "", @@ -47915,7 +47283,7 @@ "id": "04B0739F-E483-42E1-BE17-8D9B916E4E58" }, { - "defKey": "LineNumber", + "defKey": "PoLineNumber", "defName": "PO鍗曟槑缁嗚鍙�", "comment": "", "type": "", @@ -49104,24 +48472,6 @@ "id": "B19256E6-87E6-4A43-AD65-67095F06819F" }, { - "defKey": "IdOrKey", - "defName": "涓婚敭鏍囪瘑bigint", - "applyFor": "87021CD5-DD8A-45AD-A867-A55DFE7993F5", - "len": "", - "scale": "", - "uiHint": "", - "id": "16120F75-6AA7-4483-868D-F07F511BB081" - }, - { - "defKey": "Name", - "defName": "鍚嶇О", - "applyFor": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64", - "len": 90, - "scale": "", - "uiHint": "", - "id": "54611CCC-CA4B-42E1-9F32-4944C85B85A6" - }, - { "defKey": "Int", "defName": "鏁存暟", "applyFor": "1D764C4A-6F9F-421E-B11A-6F3E23B51811", @@ -49140,13 +48490,13 @@ "id": "FF4459C5-6B45-4DBF-8FC0-E06239BC05B4" }, { - "defKey": "Money", - "defName": "閲戦(24,6)", - "applyFor": "1A0BDC09-0792-4174-9E8E-80BE8DF44B8E", - "len": 24, - "scale": 6, + "defKey": "Int1", + "defName": "闀挎暣鍨�", + "applyFor": "87021CD5-DD8A-45AD-A867-A55DFE7993F5", + "len": "", + "scale": "", "uiHint": "", - "id": "C3B1681B-99F9-4818-9E80-DE1652A51D85" + "id": "717941D9-8B3F-435A-9F8E-8D13B7404D5B" }, { "defKey": "DateTime", @@ -49158,6 +48508,15 @@ "id": "7CFFA0D3-6A93-4DDC-BC10-DF21211064DC" }, { + "defKey": "DateTime1", + "defName": "鏃ユ湡鏃堕棿datetimeoffset", + "applyFor": "63EB55D7-63DF-4EC4-94C6-71CA5CA55DB3", + "len": "", + "scale": "", + "uiHint": "", + "id": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97" + }, + { "defKey": "YesNo", "defName": "鏄惁", "applyFor": "7ECAE23D-9FDB-4015-93BC-459D56A1ACA1", @@ -49165,6 +48524,33 @@ "scale": "", "uiHint": "", "id": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF" + }, + { + "defKey": "IdOrKey", + "defName": "涓婚敭鏍囪瘑bigint", + "applyFor": "87021CD5-DD8A-45AD-A867-A55DFE7993F5", + "len": "", + "scale": "", + "uiHint": "", + "id": "16120F75-6AA7-4483-868D-F07F511BB081" + }, + { + "defKey": "Name", + "defName": "鍚嶇О", + "applyFor": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64", + "len": 90, + "scale": "", + "uiHint": "", + "id": "54611CCC-CA4B-42E1-9F32-4944C85B85A6" + }, + { + "defKey": "Money", + "defName": "閲戦(24,6)", + "applyFor": "1A0BDC09-0792-4174-9E8E-80BE8DF44B8E", + "len": 24, + "scale": 6, + "uiHint": "", + "id": "C3B1681B-99F9-4818-9E80-DE1652A51D85" }, { "defKey": "Dict", @@ -49183,24 +48569,6 @@ "scale": "", "uiHint": "", "id": "3E948CEC-3070-472C-AF92-F3CA11EC9D15" - }, - { - "defKey": "DateTime1", - "defName": "鏃ユ湡鏃堕棿datetimeoffset", - "applyFor": "63EB55D7-63DF-4EC4-94C6-71CA5CA55DB3", - "len": "", - "scale": "", - "uiHint": "", - "id": "E9456E44-8231-4BC0-B2CD-5FF4AEC6DE97" - }, - { - "defKey": "Int1", - "defName": "闀挎暣鍨�", - "applyFor": "87021CD5-DD8A-45AD-A867-A55DFE7993F5", - "len": "", - "scale": "", - "uiHint": "", - "id": "717941D9-8B3F-435A-9F8E-8D13B7404D5B" } ], "diagrams": [], -- Gitblit v1.9.3