ICBOMGroup 视图

最新推荐文章于 2021-04-16 11:13:14 发布

原创最新推荐文章于 2021-04-16 11:13:14 发布 · 473 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍了如何在数据库中创建和替换三个特定的视图：V_NLMRPII_ICBOMGROUP、V_NLMRPII_BOM和V_NLMRPII_BOMENTRY，用于管理物料清单（BOM）数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE OR REPLACE VIEW V_NLMRPII_ICBOMGROUP (f_intbomgroupid, f_intparentid, f_strname, f_strnumber, f_intbootid) AS SELECT "FInterID", "FParentID", "FName", "FNumber", "FBootID" FROM icbomgroup@dblk1;

BOM

CREATE OR REPLACE VIEW V_NLMRPII_BOM (f_intbomid, f_intitemid, f_intbomgroupid, f_strbomnumber, f_strversion, f_intquantity, f_dtmcreateddatetime, f_intcreatorid, f_dtmauditeddate, f_intauditorid, f_isactive, f_strnote) AS SELECT "FInterID", "FItemID", "FBomType", "FBOMNumber", "FVersion", "FQty", "FCheckDate", "FCheckID", "FAudDate", "FCheckerID", "FStatus", "FNote" FROM ICBOM@DBLK1;

BOMEntry

CREATE OR REPLACE VIEW V_NLMRPII_BOMENTRY (f_intentryid, f_intbomentryid, f_intbomid, f_strnumber, f_intitemid, f_numquantity, f_strnote) AS SELECT "FDetailID", "FEntryID", "FInterID", "FPositionNo", "FItemID", "FQty", "FNote" FROM ICBOMCHILD@DBLK1;