ERP logistics

xiaoxiao2021-03-06  93

Select * from hxerp.dbo. Emergency season $ Where item number not in (SELECT item number from HXERP_IEN.DBO. Logistics _ Information _ Item Information Table)

Select * from hxerp.dbo. Raw material period $ Where WHERE Item No. NOT IN (SELECT Item No. FROM HXERP_IEN.DBO. Logistics - Database & Sql Blog Articles

// INSERT INTO logistics _ bill _ warehouse receipt / monthly report (subsidiary number, accounting month, item number, batch number, number of quantities, quantity), number of periods, number 2, number 3, number 4, number 4 The number of warents 1, the number of warents 2, the number of warents, the number of warents 4, the number of outlets, the number of outlets, the number of outlets, the number of outlets, the number of balances, the quantity number of balances, the amount of excess 3, the quantity of balance 4, the number of warehouses, the number of outlets)

SELECT 'HF', '2004/8/1', item number, '', inventory number, stock number, stock number, 0, 0, 0, 0, 0, 0, 0, 0, 0, Inventory number, 0, 0, 0, 0, 0 from HXERP.DBO. Raw material period $ Where IS not null //

INSERT INTO logistics _ account _ warehouse receiving and survival _ monthly report (subsidiary number, accounting month, item number, batch number, number of quantities, quantity quantity, number of period 2, number 3, number 4 The quantity 1, the number of wares 2, the number of wares 3, the number of warents 4, the number of outlets, the number of outlets, the number of outlets, the number of outlets, the quantity of the balance, the number of balances, the amount of excess 3, The quantity of balance 4, the number of warehouses, the number of outlets)

SELECT 'HF', '2004/8/1', item number, '', F4, F4, F4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, F4, 0 , 0, 0, 0, 0 from HXERP.DBO. Emergency season $ Where Item No. IS Not Null //

Delete from logistics _ inventory table _ with library batch number _ period INSERT INTO [HXERP_IEN]. [dbo]. [logistics _ inventory table _ band library batch number _ period early]

([Accounting Month], [Sub-bureau Number], [Item Number], [Library Number], [Batch No.], [Basic Quantity], [Quantity 1], [Quantity 2], [Quantity 3], [Quantity 4 ]) SELECT '2004/8/1', 'HF', Item Number, '01 ',' ', F4, F4, 0, 0 from HXerp.dbo. Events Perines Period $ Where Item Number Is Not Null and F4 is not null

INSERT INTO [HXERP_IEN]. [DBO]. [Logistics _ inventory table _ with library batch number _ period]

([Accounting Month], [Sub-bureau Number], [Item Number], [Library Number], [Batch No.], [Basic Quantity], [Quantity 1], [Quantity 2], [Quantity 3], [Quantity 4 ]) SELECT '2004/8/1', 'HF', Item Number, '05 ',' ', inventory number, inventory number, 0,0,0 from hxerp.dbo. Original product period $ Where IS not NULL And stock number is not null

SELECT * FROM logistics _ account _ warehouse receipt / monthly report where accounting month = '2004/8/1'

Delete from dbo. logistics _ account _ financial importance _ monthly report where accounting month = '2004/8/1'

Update dbo. logistics _ single application _ into and out of the warehouse list _ ordinary SET batch number = ''

SELECT DISTINCT batch number from dbo. Logistics_ 单 _ 进行 单 _ 细 单

转载请注明原文地址:https://www.9cbs.com/read-123226.html

New Post(0)