BLUCom:Skripte

Aus PPwiki
Wechseln zu: Navigation, Suche

Hilfe, wenn Blucom Aufträge vor dem Abbuchen importiert wurden

select VMEEH, e_order_position.* from e_order_position 
 order by ORDER_HEADER_ID desc;
 
select * from e_order_header oh
  inner join E_ORDER_POSITION op
    on  oh.ORDER_HEADER_ID = op.ORDER_HEADER_ID
  where op.VMEEH is null
    and oh.status = 'S'
    and oh.absender = 'BLUECOM'
  order by op.ORDER_POSITION_ID desc; 
  
select vmeeh, e_order_position.* from E_ORDER_POSITION
  where ORDER_HEADER_ID = '2020091712133288464121';