Y003 - DB SDMA

PHOTO EMBED

Wed Mar 31 2021 07:19:23 GMT+0000 (Coordinated Universal Time)

Saved by @khairil114

SELECT PORDERP.[Order no.], PORDERP.[Line], PORDERP.NETPRI_0, PORDERQ.QTYUOM_0, PRECEIPTD.PTHNUM_0, PRECEIPTD.PTDLIN_0,PRECEIPTD.LINAMT_0, 
PINVOICED.NUM_0, PORDER.CCE_0, PORDER.CCE_1, GACCDUDATE.AMTLOC_0, GACCDUDATE.PAYLOC_0
FROM $Purchase orders$ as PORDER 
LEFT OUTER JOIN $Purchase orders - quantities$ as PORDERQ ON PORDER.[Order no.] = PORDERQ.[Order no.] 
LEFT OUTER JOIN $Purchase order lines$ as PORDERP ON PORDERP.[Order no.] = PORDERQ.[Order no.] AND PORDERP.[Line] = PORDERQ.[Line] 
LEFT OUTER JOIN $Detail receipts$ as PRECEIPTD ON PORDER.[Order no.] = PRECEIPTD.[Order no.] AND PORDERP.[Line] = PRECEIPTD.[Line] 
LEFT OUTER JOIN $Purchase invoices$ as PINVOICED ON PINVOICED.[Source Document] = PRECEIPTD.PTHNUM_0 AND PINVOICED.[Line] = PRECEIPTD.[Line]  
LEFT OUTER JOIN $Purchase invoice lines$ as PINVOICED ON PINVOICED.NUM_0 = PINVOICE.NUM_0 
LEFT OUTER JOIN $Open items$ as GACCDUDATE ON PINVOICE.NUM_0 = GACCDUDATE.NUM_0
content_copyCOPY

code dari query david