-- 导入销售策略old表 43220709
insert into db_account_book_strategy_match_shipment_old
select a.*from db_account_book_strategy_match_shipment a inner join ifc_shipment_amazon b on a.BussniessBillNumber=b.BillNumber
where b.OperateTime<'2022-03-01'
-- 删除销售策略
DELETE db_account_book_strategy_match_shipment from db_account_book_strategy_match_shipment,ifc_shipment_amazon
where db_account_book_strategy_match_shipment.BussniessBillNumber=ifc_shipment_amazon.BillNumber
and ifc_shipment_amazon.OperateTime<'2022-03-01'
-- 导入销售 OLD 16469560
insert into ifc_shipment_amazon_old
select *from ifc_shipment_amazon b
where b.OperateTime<'2022-03-01'
select MAX(AccountDate) from ifc_shipment_amazon_old
-- 2021-10-01 00:00:00
select min(AccountDate) from ifc_shipment_amazon b
where b.OperateTime<'2022-03-01'
-- 删除销售 16469560
delete from ifc_shipment_amazon
where OperateTime<'2022-03-01'
select COUNT(1) from ifc_shipment_amazon where OperateTime<'2022-03-01'
-- 导入销售关联应收费用 OLD 6406028
insert into ifc_shipmentbypayment_old (ShipmentID,PayMentCurrency,Quantity,ProductSales,SellingFees,AdsPayment,FBAStorageFee,FBAInboundFee,FBARemovalFee,FbaFees,OtherTransactionFees,LongTermStorageFee,CouponFee,AccountDate)
select ShipmentID,PayMentCurrency,Quantity,ProductSales,SellingFees,AdsPayment,FBAStorageFee,FBAInboundFee,FBARemovalFee,FbaFees,OtherTransactionFees,LongTermStorageFee,CouponFee,AccountDate from ifc_shipmentbypayment b
where b.AccountDate<'2022-03-01'
-- 删除销售关联应收费用 6406028
delete from ifc_shipmentbypayment
where AccountDate<'2022-03-01'
-- ===============================应收单迁移====
-- 导入应收策略old表 34389336
insert into db_account_book_strategy_match_payment_old
select a.*from db_account_book_strategy_match_payment a inner join ifc_payment_amazon b on a.BussniessBillNumber=b.BillNumber
where b.PostedDate<'2022-03-01'
-- 删除应收策略 34389336
DELETE db_account_book_strategy_match_payment from db_account_book_strategy_match_payment,ifc_payment_amazon
where db_account_book_strategy_match_payment.BussniessBillNumber=ifc_payment_amazon.BillNumber
and ifc_payment_amazon.PostedDate<'2022-03-01'
-- 导入应收 OLD 16130350
insert into ifc_payment_amazon_old
select *from ifc_payment_amazon b
where b.PostedDate<'2022-03-01' -- ********* ******
-- 删除应收 16130350
delete from ifc_payment_amazon
where PostedDate<'2022-03-01'
任务描述
