--发料
select * from [192.168.0.246].EMPCSK.[dbo].ZZ_MO_IssueDoc
select * from [192.168.0.246].EMPCSK.[dbo].[ZZ_MO_IssueDocLine]
alter view sfp_file
as
select [DocNo] sfp01, [BusinessDate] sfp02, [DocType] sfp06, [MoDeptCode] sfp07, [CreatedBy] sfp16, [Status] sfp04,'' sfpconf,'' RBA001 from [192.168.0.246].EMPCSK.[dbo].ZZ_MO_IssueDoc
go
alter view sfs_file
as
select [DocNo] sfs01, [DocLineNo] sfs02, [MoCode] sfs03, [ProductCode] sfb05, [ItemCode] sfb04, [ItemName] ima02, [ItemSpesc] ima021, [InvUom] sfs06, [Qty] sfs05, [WhCode] sfs07,'' sfs10,[BinCode] sfs08,[Batch] sfs09,'Y' sfs22 from [192.168.0.246].EMPCSK.[dbo].[ZZ_MO_IssueDocLine]
go

--调拨
select * from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_TransferIn]
select * from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_TransInLine]

alter view imm_file
as
select [DocNo] imm01, [BusinessDate] imm02, [CreatedBy] imm16, [DebitDate] imm17, [IsPost] imm03, [Status] immconf from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_TransferIn]
go
alter view imn_file
as
select [TransferApply] imn01, [DocLineNo] imn02, [ItemInfo_ItemCode] imn03, [ItemInfo_ItemName] ima02,'' IMA021, [TransOutWh] imn04, [TransOutWhName] outwarehousecode, [TransOutBin_Name] imn05, [TransOutBatch] imn06, [TransOutQty] imn10, [TransOutUom] imn09, [TransInWh] imn15, [TransInWhName] inwarehousecode, [TransInBin_Name] imn16, [TransInBatch] imn17, [TransInQty] imn22, [transInUom] imn20,'' imnud03,'' IDD05_I,'' IDD06_I,'' IDD17_I,'' idd05_O,'' idd06_O,'' idd17_O from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_TransInLine]
go

--杂收
select * from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_MiscRcvTrans]
select * from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_MiscRcvTransL]
alter view ina_file
as
select [DocType] ina00, [DocNo] ina01, [BusinessDate] ina03, [DeptCode] ina04, [DeptName] inaorig, [CreatedBy] inaoriu,'' inapost,'' inaconf from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_MiscRcvTrans]
go
alter view inb_file
as
select [DocNo] inb01, [DocLineNo] inb03, [ItemCode] inb04, [ItemName] ima02, [ItemSpece] ima021, [Wh] inb05, [InvUon] inb08, [Qty] inb09, [ApplyQty] inb16,'' inb06,'' inb07 from [192.168.0.246].EMPCSK.[dbo].[ZZ_InvDoc_MiscRcvTransL]
go

--采购订单
SELECT * FROM [192.168.0.246].[EMPCSK].[dbo].[ZZ_PM_PurchaseOrder]
SELECT * FROM [192.168.0.246].[EMPCSK].[dbo].[ZZ_PM_PoLine]


--单头
select [DocNo] pmm01,[DocType] pmm02,[BusinessDate] pmm04,[SupplierCode] pmm09,[SupplierName] supplierFullName,[SupplierShortName] pmc03,[Status] pmm25,[PersonCode] pmm12,[PersonName] gen02--,[PurDept] pmm13
,[DeptCode] pmm13,[DeptName] gem02,[TaxCode]  pmm21,[CreatedBy] pmmoriu,'' pmmacti,'' pmm20,'' pma02,'' pmm22,[Tax] pmm43 from [192.168.0.246].[EMPCSK].[dbo].[ZZ_PM_PurchaseOrder]
--单身

IMA视图

USE [Udit.Mms]
GO

/****** Object:  View [dbo].[ima_file]    Script Date: 2024/5/9 15:09:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

 CREATE   VIEW [dbo].[ima_file]  
 AS   

select [ItemCode] ima01
,[ItemName] ima02
,[ItemSpecs] ima021
,[ItemClassCode] ima06
,[ItemABC] IMA07
,[InvUom] ima25
,[WhCode] ima35
,[CreateOn] IMA901
,[SurceCode] ima08
,[IsEffective] imaacti
,'' IMA71
,[StardardBox] ta_ima35
,'' imaoriu
,[ItemDeptCode] imaorig
,[ItemClassName] imz02
,[ItemMSD] ta_ima41
,[IsPb] ta_ima42
,[IsGms] ima24
,[Status] ima1010
from [192.168.0.246].[EMPCSK].[dbo].[PYS_CBO_ItemMaster]

GO