登录
注册
开源
企业版
高校版
搜索
帮助中心
使用条款
关于我们
开源
企业版
高校版
私有云
模力方舟
AI 队友
登录
注册
轻量养虾，开箱即用！低 Token + 稳定算力，Gitee & 模力方舟联合出品的 PocketClaw 正式开售！点击了解详情
代码拉取完成，页面将自动刷新
开源项目
>
WEB应用开发
>
Web开发框架
&&
捐赠
捐赠前请先登录
取消
前往登录
扫描微信二维码支付
取消
支付完成
支付提示
将跳转至支付宝完成支付
确定
取消
Watch
不关注
关注所有动态
仅关注版本发行动态
关注但不提醒动态
9.9K
Star
14.5K
Fork
4.2K
GVP
dotNET China
/
Furion
代码
Issues
0
Pull Requests
0
统计
流水线
服务
质量分析
Jenkins for Gitee
腾讯云托管
腾讯云 Serverless
悬镜安全
阿里云 SAE
Codeblitz
SBOM
开发画像分析
我知道了，不再自动展开
更新失败，请稍后重试！
移除标识
内容风险标识
本任务被
标识为内容中包含有代码安全 Bug 、隐私泄露等敏感信息，仓库外成员不可访问
使用数据库生成模型tools/cli.ps1，从数据库表生成的实体异常
已完成
#I3PL18
molan68
创建于
2021-05-04 15:54
> 特别说明：如果 Issue 报告为问题且开发成员回复确认问题之后但**三天内**都不能得到反馈，则视为无效Issue。 ### Furion 版本号 哪个版本号？ 2.2.5 ----------- ### Web 项目类型 - [x] WebApi - [ ] Mvc - [ ] Razor Pages - [ ] Blazor Server ----------- ### 描述你的问题 发生了什么？ 使用数据库生成模型，从数据库表生成的实体异常。 ----------- ### 异常堆栈信息 异常堆栈是什么？  ----------- ### 代码或代码仓库 什么代码导致？ 请见sqlserver表 ``` USE [Dilon] GO /****** Object: Table [dbo].[Starlite_SUZ_Test$Inventory Line] Script Date: 2021/5/4 15:39:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Starlite_SUZ_Test$Inventory Line]( [timestamp] [timestamp] NOT NULL, [Inv Document Type] [int] NOT NULL, [Document No_] [varchar](20) NOT NULL, [Line No_] [int] NOT NULL, [Item No_] [varchar](20) NOT NULL, [Posting Date] [datetime] NOT NULL, [Entry Type] [int] NOT NULL, [Source No_] [varchar](20) NOT NULL, [Description] [varchar](50) NOT NULL, [Location Code] [varchar](10) NOT NULL, [Inventory Posting Group] [varchar](10) NOT NULL, [Source Posting Group] [varchar](10) NOT NULL, [Quantity] [decimal](38, 20) NOT NULL, [Invoiced Quantity] [decimal](38, 20) NOT NULL, [Unit Amount] [decimal](38, 20) NOT NULL, [Unit Cost] [decimal](38, 20) NOT NULL, [Amount] [decimal](38, 20) NOT NULL, [Discount Amount] [decimal](38, 20) NOT NULL, [Salespers__Purch_ Code] [varchar](10) NOT NULL, [Source Code] [varchar](10) NOT NULL, [Applies-to Entry] [int] NOT NULL, [Item Shpt_ Entry No_] [int] NOT NULL, [Shortcut Dimension 1 Code] [varchar](20) NOT NULL, [Shortcut Dimension 2 Code] [varchar](20) NOT NULL, [Indirect Cost %] [decimal](38, 20) NOT NULL, [Source Type] [int] NOT NULL, [Reason Code] [varchar](10) NOT NULL, [Recurring Method] [int] NOT NULL, [Expiration Date] [datetime] NOT NULL, [Recurring Frequency] [varchar](32) NOT NULL, [Drop Shipment] [tinyint] NOT NULL, [Transaction Type] [varchar](10) NOT NULL, [Transport Method] [varchar](10) NOT NULL, [Country_Region Code] [varchar](10) NOT NULL, [New Location Code] [varchar](10) NOT NULL, [New Shortcut Dimension 1 Code] [varchar](20) NOT NULL, [New Shortcut Dimension 2 Code] [varchar](20) NOT NULL, [Qty_ (Calculated)] [decimal](38, 20) NOT NULL, [Qty_ (Phys_ Inventory)] [decimal](38, 20) NOT NULL, [Last Item Ledger Entry No_] [int] NOT NULL, [Phys_ Inventory] [tinyint] NOT NULL, [Gen_ Bus_ Posting Group] [varchar](10) NOT NULL, [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL, [Entry_Exit Point] [varchar](15) NOT NULL, [Document Date] [datetime] NOT NULL, [External Document No_] [varchar](20) NOT NULL, [Area] [varchar](10) NOT NULL, [Transaction Specification] [varchar](10) NOT NULL, [Posting No_ Series] [varchar](10) NOT NULL, [Unit Cost (ACY)] [decimal](38, 20) NOT NULL, [Source Currency Code] [varchar](10) NOT NULL, [Document Type] [int] NOT NULL, [Document Line No_] [int] NOT NULL, [Job No_] [varchar](20) NOT NULL, [Job Task No_] [varchar](20) NOT NULL, [Job Purchase] [tinyint] NOT NULL, [Prod_ Order No_] [varchar](20) NOT NULL, [Variant Code] [varchar](10) NOT NULL, [Bin Code] [varchar](20) NOT NULL, [Qty_ per Unit of Measure] [decimal](38, 20) NOT NULL, [New Bin Code] [varchar](20) NOT NULL, [Unit of Measure Code] [varchar](10) NOT NULL, [Derived from Blanket Order] [tinyint] NOT NULL, [Quantity (Base)] [decimal](38, 20) NOT NULL, [Invoiced Qty_ (Base)] [decimal](38, 20) NOT NULL, [Level] [int] NOT NULL, [Flushing Method] [int] NOT NULL, [Changed by User] [tinyint] NOT NULL, [Cross-Reference No_] [varchar](20) NOT NULL, [Originally Ordered No_] [varchar](20) NOT NULL, [Originally Ordered Var_ Code] [varchar](10) NOT NULL, [Out-of-Stock Substitution] [tinyint] NOT NULL, [Item Category Code] [varchar](10) NOT NULL, [Nonstock] [tinyint] NOT NULL, [Purchasing Code] [varchar](10) NOT NULL, [Product Group Code] [varchar](10) NOT NULL, [Transfer Order No_] [varchar](20) NOT NULL, [Planned Delivery Date] [datetime] NOT NULL, [Order Date] [datetime] NOT NULL, [Value Entry Type] [int] NOT NULL, [Item Charge No_] [varchar](20) NOT NULL, [Inventory Value (Calculated)] [decimal](38, 20) NOT NULL, [Inventory Value (Revalued)] [decimal](38, 20) NOT NULL, [Variance Type] [int] NOT NULL, [Inventory Value Per] [int] NOT NULL, [Partial Revaluation] [tinyint] NOT NULL, [Applies-from Entry] [int] NOT NULL, [Invoice No_] [varchar](20) NOT NULL, [Unit Cost (Calculated)] [decimal](38, 20) NOT NULL, [Unit Cost (Revalued)] [decimal](38, 20) NOT NULL, [Applied Amount] [decimal](38, 20) NOT NULL, [Update Standard Cost] [tinyint] NOT NULL, [Amount (ACY)] [decimal](38, 20) NOT NULL, [Correction] [tinyint] NOT NULL, [Adjustment] [tinyint] NOT NULL, [Applies-to Value Entry] [int] NOT NULL, [Type] [int] NOT NULL, [No_] [varchar](20) NOT NULL, [Operation No_] [varchar](10) NOT NULL, [Work Center No_] [varchar](20) NOT NULL, [Setup Time] [decimal](38, 20) NOT NULL, [Run Time] [decimal](38, 20) NOT NULL, [Stop Time] [decimal](38, 20) NOT NULL, [Output Quantity] [decimal](38, 20) NOT NULL, [Scrap Quantity] [decimal](38, 20) NOT NULL, [Concurrent Capacity] [decimal](38, 20) NOT NULL, [Setup Time (Base)] [decimal](38, 20) NOT NULL, [Run Time (Base)] [decimal](38, 20) NOT NULL, [Stop Time (Base)] [decimal](38, 20) NOT NULL, [Output Quantity (Base)] [decimal](38, 20) NOT NULL, [Scrap Quantity (Base)] [decimal](38, 20) NOT NULL, [Cap_ Unit of Measure Code] [varchar](10) NOT NULL, [Qty_ per Cap_ Unit of Measure] [decimal](38, 20) NOT NULL, [Starting Time] [datetime] NOT NULL, [Ending Time] [datetime] NOT NULL, [Prod_ Order Line No_] [int] NOT NULL, [Routing No_] [varchar](20) NOT NULL, [Routing Reference No_] [int] NOT NULL, [Prod_ Order Comp_ Line No_] [int] NOT NULL, [Finished] [tinyint] NOT NULL, [Unit Cost Calculation] [int] NOT NULL, [Subcontracting] [tinyint] NOT NULL, [Stop Code] [varchar](10) NOT NULL, [Scrap Code] [varchar](10) NOT NULL, [Work Center Group Code] [varchar](10) NOT NULL, [Work Shift Code] [varchar](10) NOT NULL, [Service Order No_] [varchar](20) NOT NULL, [Serial No_] [varchar](20) NOT NULL, [Lot No_] [varchar](20) NOT NULL, [Warranty Date] [datetime] NOT NULL, [New Serial No_] [varchar](20) NOT NULL, [New Lot No_] [varchar](20) NOT NULL, [New Item Expiration Date] [datetime] NOT NULL, [Item Expiration Date] [datetime] NOT NULL, [Return Reason Code] [varchar](10) NOT NULL, [Phys Invt Counting Period Code] [varchar](10) NOT NULL, [Phys Invt Counting Period Type] [int] NOT NULL, [Production No_] [varchar](20) NOT NULL, [Sales Order No_] [varchar](20) NOT NULL, [Custom Declared Qty_] [decimal](38, 20) NOT NULL, [Declared Unit of Measure] [varchar](10) NOT NULL, [Provide Certificate of Quality] [tinyint] NOT NULL, [Customer No_] [varchar](20) NOT NULL, [Machine] [varchar](10) NOT NULL, [Comment] [varchar](100) NOT NULL, [Grammage] [decimal](38, 20) NOT NULL, [Depth] [decimal](38, 20) NOT NULL, [Width] [decimal](38, 20) NOT NULL, [Length] [decimal](38, 20) NOT NULL, [Thickness] [decimal](38, 20) NOT NULL, [Height] [decimal](38, 20) NOT NULL, [Depth UOM] [varchar](10) NOT NULL, [Width UOM] [varchar](10) NOT NULL, [Thickness UOM] [varchar](10) NOT NULL, [Height UOM] [varchar](10) NOT NULL, [Weight UOM] [varchar](10) NOT NULL, [Weight] [decimal](38, 20) NOT NULL, [Handling Price] [decimal](38, 20) NOT NULL, [Conversion Factor] [decimal](38, 20) NOT NULL, [Handling Quantity] [decimal](38, 20) NOT NULL, [Handling Unit of Measure] [varchar](10) NOT NULL, [Quote Unit of Measure] [varchar](10) NOT NULL, [Purchase Unit Price] [decimal](38, 20) NOT NULL, [Purchase Price Formula] [varchar](10) NOT NULL, [Purchase Price Factor] [decimal](38, 20) NOT NULL, [Inventory Unit Formula] [varchar](10) NOT NULL, [envelop] [decimal](38, 20) NOT NULL, [Source Quantity] [decimal](38, 20) NOT NULL, [Use Document Header] [tinyint] NOT NULL, [Document Running No_] [varchar](10) NOT NULL, [Total No_ of Pallet] [int] NOT NULL, [Qty_ of This pallet] [int] NOT NULL, [Qty_ of Package] [int] NOT NULL, [Package Qty] [int] NOT NULL, [Mantissa Qty] [int] NOT NULL, [Overhead Rate] [decimal](38, 20) NOT NULL, [Single-Level Material Cost] [decimal](38, 20) NOT NULL, [Single-Level Capacity Cost] [decimal](38, 20) NOT NULL, [Single-Level Subcontrd_ Cost] [decimal](38, 20) NOT NULL, [Single-Level Cap_ Ovhd Cost] [decimal](38, 20) NOT NULL, [Single-Level Mfg_ Ovhd Cost] [decimal](38, 20) NOT NULL, [Rolled-up Material Cost] [decimal](38, 20) NOT NULL, [Rolled-up Capacity Cost] [decimal](38, 20) NOT NULL, [Rolled-up Subcontracted Cost] [decimal](38, 20) NOT NULL, [Rolled-up Mfg_ Ovhd Cost] [decimal](38, 20) NOT NULL, [Rolled-up Cap_ Overhead Cost] [decimal](38, 20) NOT NULL, [English Name] [varchar](100) NOT NULL, [Chinese Name] [varchar](100) NOT NULL, [Inventory Unit of Measure] [varchar](10) NOT NULL, [Unit Factor Purchase-Inventory] [decimal](38, 20) NOT NULL, [Product Group View Type] [int] NOT NULL, [OC delivery Date] [datetime] NOT NULL, [Paper Grain] [decimal](38, 20) NOT NULL, [Sub Type Code] [varchar](10) NOT NULL, [Blanket Sales Order No_] [varchar](20) NOT NULL, [Production Doc No_] [varchar](20) NOT NULL, [Vendor Prod_ Lot] [varchar](30) NOT NULL, [Rel_ Document No] [varchar](20) NOT NULL, [Reservation Entry No_] [int] NOT NULL, [SL Prod_ Document Type] [int] NOT NULL, [SL Prod_ Order No_] [varchar](20) NOT NULL, [SL Prod_ Job Item No_] [int] NOT NULL, [SL Prod_ Process Line No_] [int] NOT NULL, [SL Prod_ Job Sheet No_] [varchar](20) NOT NULL, [SL Prod_ Process Description] [varchar](50) NOT NULL, [Ship-to Code] [varchar](20) NOT NULL, [Ship-to Name] [varchar](100) NOT NULL, [Ship-to Address] [varchar](120) NOT NULL, [Machine Center No_] [varchar](20) NOT NULL, [Inventory Tag Code] [varchar](50) NOT NULL, [IO Doc Type] [int] NOT NULL, [IO Entry No_] [int] NOT NULL, [Pallet No_] [varchar](20) NOT NULL, [Shortcut Dimension 4 Code] [varchar](20) NOT NULL, [Vendor No_] [varchar](20) NOT NULL, [Purch_ Order No_] [varchar](30) NOT NULL, [SL Prod_ Resource Line No_] [int] NOT NULL, [Reserved] [tinyint] NOT NULL, CONSTRAINT [Starlite_SUZ_Test$Inventory Line$0] PRIMARY KEY CLUSTERED ( [Inv Document Type] ASC, [Document No_] ASC, [Line No_] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) --ON [Data Filegroup 2] )-- ON [Data Filegroup 2] GO ``` ----------- ### 数据库信息 - [ ] Sqlite - [x] SqlServer - [ ] Mysql - [ ] Oracle - [ ] PGSql - [ ] Firebird - [ ] Cosmos ----------- ### 期待结果 期待的结果是？ -----------
> 特别说明：如果 Issue 报告为问题且开发成员回复确认问题之后但**三天内**都不能得到反馈，则视为无效Issue。 ### Furion 版本号 哪个版本号？ 2.2.5 ----------- ### Web 项目类型 - [x] WebApi - [ ] Mvc - [ ] Razor Pages - [ ] Blazor Server ----------- ### 描述你的问题 发生了什么？ 使用数据库生成模型，从数据库表生成的实体异常。 ----------- ### 异常堆栈信息 异常堆栈是什么？  ----------- ### 代码或代码仓库 什么代码导致？ 请见sqlserver表 ``` USE [Dilon] GO /****** Object: Table [dbo].[Starlite_SUZ_Test$Inventory Line] Script Date: 2021/5/4 15:39:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Starlite_SUZ_Test$Inventory Line]( [timestamp] [timestamp] NOT NULL, [Inv Document Type] [int] NOT NULL, [Document No_] [varchar](20) NOT NULL, [Line No_] [int] NOT NULL, [Item No_] [varchar](20) NOT NULL, [Posting Date] [datetime] NOT NULL, [Entry Type] [int] NOT NULL, [Source No_] [varchar](20) NOT NULL, [Description] [varchar](50) NOT NULL, [Location Code] [varchar](10) NOT NULL, [Inventory Posting Group] [varchar](10) NOT NULL, [Source Posting Group] [varchar](10) NOT NULL, [Quantity] [decimal](38, 20) NOT NULL, [Invoiced Quantity] [decimal](38, 20) NOT NULL, [Unit Amount] [decimal](38, 20) NOT NULL, [Unit Cost] [decimal](38, 20) NOT NULL, [Amount] [decimal](38, 20) NOT NULL, [Discount Amount] [decimal](38, 20) NOT NULL, [Salespers__Purch_ Code] [varchar](10) NOT NULL, [Source Code] [varchar](10) NOT NULL, [Applies-to Entry] [int] NOT NULL, [Item Shpt_ Entry No_] [int] NOT NULL, [Shortcut Dimension 1 Code] [varchar](20) NOT NULL, [Shortcut Dimension 2 Code] [varchar](20) NOT NULL, [Indirect Cost %] [decimal](38, 20) NOT NULL, [Source Type] [int] NOT NULL, [Reason Code] [varchar](10) NOT NULL, [Recurring Method] [int] NOT NULL, [Expiration Date] [datetime] NOT NULL, [Recurring Frequency] [varchar](32) NOT NULL, [Drop Shipment] [tinyint] NOT NULL, [Transaction Type] [varchar](10) NOT NULL, [Transport Method] [varchar](10) NOT NULL, [Country_Region Code] [varchar](10) NOT NULL, [New Location Code] [varchar](10) NOT NULL, [New Shortcut Dimension 1 Code] [varchar](20) NOT NULL, [New Shortcut Dimension 2 Code] [varchar](20) NOT NULL, [Qty_ (Calculated)] [decimal](38, 20) NOT NULL, [Qty_ (Phys_ Inventory)] [decimal](38, 20) NOT NULL, [Last Item Ledger Entry No_] [int] NOT NULL, [Phys_ Inventory] [tinyint] NOT NULL, [Gen_ Bus_ Posting Group] [varchar](10) NOT NULL, [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL, [Entry_Exit Point] [varchar](15) NOT NULL, [Document Date] [datetime] NOT NULL, [External Document No_] [varchar](20) NOT NULL, [Area] [varchar](10) NOT NULL, [Transaction Specification] [varchar](10) NOT NULL, [Posting No_ Series] [varchar](10) NOT NULL, [Unit Cost (ACY)] [decimal](38, 20) NOT NULL, [Source Currency Code] [varchar](10) NOT NULL, [Document Type] [int] NOT NULL, [Document Line No_] [int] NOT NULL, [Job No_] [varchar](20) NOT NULL, [Job Task No_] [varchar](20) NOT NULL, [Job Purchase] [tinyint] NOT NULL, [Prod_ Order No_] [varchar](20) NOT NULL, [Variant Code] [varchar](10) NOT NULL, [Bin Code] [varchar](20) NOT NULL, [Qty_ per Unit of Measure] [decimal](38, 20) NOT NULL, [New Bin Code] [varchar](20) NOT NULL, [Unit of Measure Code] [varchar](10) NOT NULL, [Derived from Blanket Order] [tinyint] NOT NULL, [Quantity (Base)] [decimal](38, 20) NOT NULL, [Invoiced Qty_ (Base)] [decimal](38, 20) NOT NULL, [Level] [int] NOT NULL, [Flushing Method] [int] NOT NULL, [Changed by User] [tinyint] NOT NULL, [Cross-Reference No_] [varchar](20) NOT NULL, [Originally Ordered No_] [varchar](20) NOT NULL, [Originally Ordered Var_ Code] [varchar](10) NOT NULL, [Out-of-Stock Substitution] [tinyint] NOT NULL, [Item Category Code] [varchar](10) NOT NULL, [Nonstock] [tinyint] NOT NULL, [Purchasing Code] [varchar](10) NOT NULL, [Product Group Code] [varchar](10) NOT NULL, [Transfer Order No_] [varchar](20) NOT NULL, [Planned Delivery Date] [datetime] NOT NULL, [Order Date] [datetime] NOT NULL, [Value Entry Type] [int] NOT NULL, [Item Charge No_] [varchar](20) NOT NULL, [Inventory Value (Calculated)] [decimal](38, 20) NOT NULL, [Inventory Value (Revalued)] [decimal](38, 20) NOT NULL, [Variance Type] [int] NOT NULL, [Inventory Value Per] [int] NOT NULL, [Partial Revaluation] [tinyint] NOT NULL, [Applies-from Entry] [int] NOT NULL, [Invoice No_] [varchar](20) NOT NULL, [Unit Cost (Calculated)] [decimal](38, 20) NOT NULL, [Unit Cost (Revalued)] [decimal](38, 20) NOT NULL, [Applied Amount] [decimal](38, 20) NOT NULL, [Update Standard Cost] [tinyint] NOT NULL, [Amount (ACY)] [decimal](38, 20) NOT NULL, [Correction] [tinyint] NOT NULL, [Adjustment] [tinyint] NOT NULL, [Applies-to Value Entry] [int] NOT NULL, [Type] [int] NOT NULL, [No_] [varchar](20) NOT NULL, [Operation No_] [varchar](10) NOT NULL, [Work Center No_] [varchar](20) NOT NULL, [Setup Time] [decimal](38, 20) NOT NULL, [Run Time] [decimal](38, 20) NOT NULL, [Stop Time] [decimal](38, 20) NOT NULL, [Output Quantity] [decimal](38, 20) NOT NULL, [Scrap Quantity] [decimal](38, 20) NOT NULL, [Concurrent Capacity] [decimal](38, 20) NOT NULL, [Setup Time (Base)] [decimal](38, 20) NOT NULL, [Run Time (Base)] [decimal](38, 20) NOT NULL, [Stop Time (Base)] [decimal](38, 20) NOT NULL, [Output Quantity (Base)] [decimal](38, 20) NOT NULL, [Scrap Quantity (Base)] [decimal](38, 20) NOT NULL, [Cap_ Unit of Measure Code] [varchar](10) NOT NULL, [Qty_ per Cap_ Unit of Measure] [decimal](38, 20) NOT NULL, [Starting Time] [datetime] NOT NULL, [Ending Time] [datetime] NOT NULL, [Prod_ Order Line No_] [int] NOT NULL, [Routing No_] [varchar](20) NOT NULL, [Routing Reference No_] [int] NOT NULL, [Prod_ Order Comp_ Line No_] [int] NOT NULL, [Finished] [tinyint] NOT NULL, [Unit Cost Calculation] [int] NOT NULL, [Subcontracting] [tinyint] NOT NULL, [Stop Code] [varchar](10) NOT NULL, [Scrap Code] [varchar](10) NOT NULL, [Work Center Group Code] [varchar](10) NOT NULL, [Work Shift Code] [varchar](10) NOT NULL, [Service Order No_] [varchar](20) NOT NULL, [Serial No_] [varchar](20) NOT NULL, [Lot No_] [varchar](20) NOT NULL, [Warranty Date] [datetime] NOT NULL, [New Serial No_] [varchar](20) NOT NULL, [New Lot No_] [varchar](20) NOT NULL, [New Item Expiration Date] [datetime] NOT NULL, [Item Expiration Date] [datetime] NOT NULL, [Return Reason Code] [varchar](10) NOT NULL, [Phys Invt Counting Period Code] [varchar](10) NOT NULL, [Phys Invt Counting Period Type] [int] NOT NULL, [Production No_] [varchar](20) NOT NULL, [Sales Order No_] [varchar](20) NOT NULL, [Custom Declared Qty_] [decimal](38, 20) NOT NULL, [Declared Unit of Measure] [varchar](10) NOT NULL, [Provide Certificate of Quality] [tinyint] NOT NULL, [Customer No_] [varchar](20) NOT NULL, [Machine] [varchar](10) NOT NULL, [Comment] [varchar](100) NOT NULL, [Grammage] [decimal](38, 20) NOT NULL, [Depth] [decimal](38, 20) NOT NULL, [Width] [decimal](38, 20) NOT NULL, [Length] [decimal](38, 20) NOT NULL, [Thickness] [decimal](38, 20) NOT NULL, [Height] [decimal](38, 20) NOT NULL, [Depth UOM] [varchar](10) NOT NULL, [Width UOM] [varchar](10) NOT NULL, [Thickness UOM] [varchar](10) NOT NULL, [Height UOM] [varchar](10) NOT NULL, [Weight UOM] [varchar](10) NOT NULL, [Weight] [decimal](38, 20) NOT NULL, [Handling Price] [decimal](38, 20) NOT NULL, [Conversion Factor] [decimal](38, 20) NOT NULL, [Handling Quantity] [decimal](38, 20) NOT NULL, [Handling Unit of Measure] [varchar](10) NOT NULL, [Quote Unit of Measure] [varchar](10) NOT NULL, [Purchase Unit Price] [decimal](38, 20) NOT NULL, [Purchase Price Formula] [varchar](10) NOT NULL, [Purchase Price Factor] [decimal](38, 20) NOT NULL, [Inventory Unit Formula] [varchar](10) NOT NULL, [envelop] [decimal](38, 20) NOT NULL, [Source Quantity] [decimal](38, 20) NOT NULL, [Use Document Header] [tinyint] NOT NULL, [Document Running No_] [varchar](10) NOT NULL, [Total No_ of Pallet] [int] NOT NULL, [Qty_ of This pallet] [int] NOT NULL, [Qty_ of Package] [int] NOT NULL, [Package Qty] [int] NOT NULL, [Mantissa Qty] [int] NOT NULL, [Overhead Rate] [decimal](38, 20) NOT NULL, [Single-Level Material Cost] [decimal](38, 20) NOT NULL, [Single-Level Capacity Cost] [decimal](38, 20) NOT NULL, [Single-Level Subcontrd_ Cost] [decimal](38, 20) NOT NULL, [Single-Level Cap_ Ovhd Cost] [decimal](38, 20) NOT NULL, [Single-Level Mfg_ Ovhd Cost] [decimal](38, 20) NOT NULL, [Rolled-up Material Cost] [decimal](38, 20) NOT NULL, [Rolled-up Capacity Cost] [decimal](38, 20) NOT NULL, [Rolled-up Subcontracted Cost] [decimal](38, 20) NOT NULL, [Rolled-up Mfg_ Ovhd Cost] [decimal](38, 20) NOT NULL, [Rolled-up Cap_ Overhead Cost] [decimal](38, 20) NOT NULL, [English Name] [varchar](100) NOT NULL, [Chinese Name] [varchar](100) NOT NULL, [Inventory Unit of Measure] [varchar](10) NOT NULL, [Unit Factor Purchase-Inventory] [decimal](38, 20) NOT NULL, [Product Group View Type] [int] NOT NULL, [OC delivery Date] [datetime] NOT NULL, [Paper Grain] [decimal](38, 20) NOT NULL, [Sub Type Code] [varchar](10) NOT NULL, [Blanket Sales Order No_] [varchar](20) NOT NULL, [Production Doc No_] [varchar](20) NOT NULL, [Vendor Prod_ Lot] [varchar](30) NOT NULL, [Rel_ Document No] [varchar](20) NOT NULL, [Reservation Entry No_] [int] NOT NULL, [SL Prod_ Document Type] [int] NOT NULL, [SL Prod_ Order No_] [varchar](20) NOT NULL, [SL Prod_ Job Item No_] [int] NOT NULL, [SL Prod_ Process Line No_] [int] NOT NULL, [SL Prod_ Job Sheet No_] [varchar](20) NOT NULL, [SL Prod_ Process Description] [varchar](50) NOT NULL, [Ship-to Code] [varchar](20) NOT NULL, [Ship-to Name] [varchar](100) NOT NULL, [Ship-to Address] [varchar](120) NOT NULL, [Machine Center No_] [varchar](20) NOT NULL, [Inventory Tag Code] [varchar](50) NOT NULL, [IO Doc Type] [int] NOT NULL, [IO Entry No_] [int] NOT NULL, [Pallet No_] [varchar](20) NOT NULL, [Shortcut Dimension 4 Code] [varchar](20) NOT NULL, [Vendor No_] [varchar](20) NOT NULL, [Purch_ Order No_] [varchar](30) NOT NULL, [SL Prod_ Resource Line No_] [int] NOT NULL, [Reserved] [tinyint] NOT NULL, CONSTRAINT [Starlite_SUZ_Test$Inventory Line$0] PRIMARY KEY CLUSTERED ( [Inv Document Type] ASC, [Document No_] ASC, [Line No_] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) --ON [Data Filegroup 2] )-- ON [Data Filegroup 2] GO ``` ----------- ### 数据库信息 - [ ] Sqlite - [x] SqlServer - [ ] Mysql - [ ] Oracle - [ ] PGSql - [ ] Firebird - [ ] Cosmos ----------- ### 期待结果 期待的结果是？ -----------
评论 (
1
)
登录
后才可以发表评论
状态
已完成
待办的
进行中
已完成
已关闭
负责人
未设置
百小僧
monksoul
负责人
协作者
+负责人
+协作者
标签
漏洞
优化
未设置
标签管理
里程碑
Furion 2021
未关联里程碑
Pull Requests
未关联
未关联
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
未关联
分支 (
-
)
标签 (
-
)
开始日期 - 截止日期
-
置顶选项
不置顶
置顶等级：高
置顶等级：中
置顶等级：低
优先级
不指定
严重
主要
次要
不重要
参与者（2）
C#
1
https://gitee.com/dotnetchina/Furion.git
git@gitee.com:dotnetchina/Furion.git
dotnetchina
Furion
Furion
点此查找更多帮助
搜索帮助
Git 命令在线学习
如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
仓库举报
回到顶部
登录提示
该操作需登录 Gitee 帐号，请先登录后再操作。
立即登录
没有帐号，去注册
