[Data Processing] POS sales of each store are imported

-- Capture POS data in the Western Region
Delete from poslsbf

Insert into poslsbf
Select *
From [192.168.1.100]. [scmis]. DBO. possrlbf where sldat> '123'
Order by 1

Insert into posxbbf
Select * From poslsbf where uid not in (select uid from posxbbf)
Order by 1

Delete from poslsdt

Insert into poslsdt
Select B. uid, B. ID, C. pluno, B. qty, B. AMT, B. disamt, B. mmno, B. ismmx, B. isback, B. isdel
From [192.168.1.100]. [scmis]. DBO. possrlbf A, [192.168.1.100]. [scmis]. DBO. possrldt B, [192.168.1.100]. [scmis]. DBO. basplumain C
Where a. uid = B. UID and B. pluid = C. pluid and A. sldat> '123'

Insert into posxbdt
Select * From poslsdt where uid not in (select uid from posxbdt)
Order by 1

-- Capture POS data in the east
Delete from poslsbf

Insert into poslsbf
Select *
From [192.168.2.102]. [scmis]. DBO. possrlbf where sldat> '123'
Order by 1

Insert into posdbbf
Select * From poslsbf where uid not in (select uid from posdbbf)
Order by 1

[Data Processing] POS sales of each store are imported