1
SELECT o.ad_client_id,2
o.ad_org_id,3
o.isactive,4
o.created,5
o.createdby,6
o.updated,7
o.updatedby,8
o.pp_order_id,9
o.documentno,10
o.docstatus,11
o.m_warehouse_id,12
o.m_product_id,13
o.qtyentered,14
o.qtyreject,15
o.qtyscrap,16
o.qtybatchs,17
o.qtybatchsize,18
o.dateordered,19
o.datepromised,20
o.datestart,21
o.datestartschedule,22
o.datefinish,23
o.datefinishschedule,24
o.dateconfirm,25
o.datedelivered,26
o.lot,27
o.pp_product_bom_id,28
o.ad_workflow_id,29
( SELECT p.weight30
FROM m_product p31
WHERE (p.m_product_id = o.m_product_id)) AS weight,32
o.c_doctypetarget_id,33
o.m_attributesetinstance_id,34
o.planner_id,35
o.priorityrule,36
o.ad_orgtrx_id,37
o.user1_id,38
o.user2_id,39
o.c_doctype_id,40
o.line,41
o.description,42
o.s_resource_id,43
o.floatbefored,44
o.floatafter,45
o.c_uom_id,46
o.qtyordered,47
o.qtydelivered,48
o.yield,49
o.c_project_id,50
o.c_campaign_id,51
o.c_activity_id,52
o.isapproved,53
o.isprinted,54
o.isselected,55
o.processed,56
o.assay,57
o.isqtypercentage,58
o.ordertype,59
o.issotrx,60
o.scheduletype,61
o.serno62
FROM pp_order o;