Delete from HXERP_IEN.DBO. Logistics _ Billing _ Financial Import - Mun News Insert INTO HXERP_IEN.DBO. Logistics _ Billing _ Financial Import (Month (subsidiary number, accounting month, item number, batch number,) The library is unit price, the cost of the warehouse, the number of periods, the current cost, the number of finals, the number of time, the stock gap, the cost of the warehouse, the number of ware meters, the cost of the library , The number of foreign storage, the cost of the warehouse, the number of stores, other storage costs, the sales outline, sales outbound cost, the production area, the production of production, the number of outlets, other outbound Library cost)
SELECT 'HF', '2004/8/1', item number, '', cost price / inventory number, cost price / inventory number, stock number, cost price, inventory number, cost price, 0, 0, 0, 0 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 from HXERP.DBO. Raw material period $ Where? NOT NULL
INSERT INTO HXERP_IEN.DBO. Logistics _ Billing _ Financial Import - Millennation (Subsidic Number, Accounting Month, Item Number, Bottom Number, Invented Cost Price, Outbound Cost Price, Quantity, Event Cost, Difference Quantity, At the end of the final cost, the number of invested ware meters, the cost of the warehouse, the number of ware meters, the cost of the warehouse, the production of the warehouse, the production of the storage cost, the number of foreign storage, the number of foreign storage, the number of storage Other reservoir costs, sales of sales, sales cost, quantity of production, production, cost, other outbound, other outbound costs)
SELECT 'HF', '2004/8/1', item number, '', cost unit price / f4, cost unit price / f4, f4, cost unit price, F4, cost unit price, 0, 0, 0, 0, 0, 0 , 0, 0, 0, 0 from HXerp.dbo. Emergency season $ Where WHERE Item No. IS Not Null and F4 <> 0