{
  "dBType" : "DM",
  "mOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0013/psdedataqueries/DEFAULT/psdedqcodes/DM",
  "name" : "DM",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.QUANTITY*t21.UNITPRICE",
    "name" : "AMOUNT"
  }, {
    "expression" : "t1.CREATEDATE",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.CREATEMAN",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.IBIZSAMPLE0012ID",
    "name" : "IBIZSAMPLE0012ID"
  }, {
    "expression" : "t11.IBIZSAMPLE0012NAME",
    "name" : "IBIZSAMPLE0012NAME"
  }, {
    "expression" : "t1.IBIZSAMPLE0013ID",
    "name" : "IBIZSAMPLE0013ID"
  }, {
    "expression" : "t1.IBIZSAMPLE0013NAME",
    "name" : "IBIZSAMPLE0013NAME"
  }, {
    "expression" : "t1.IBIZUNIPRODUCTID",
    "name" : "IBIZUNIPRODUCTID"
  }, {
    "expression" : "t21.IBIZUNIPRODUCTNAME",
    "name" : "IBIZUNIPRODUCTNAME"
  }, {
    "expression" : "t1.QUANTITY",
    "name" : "QUANTITY"
  }, {
    "expression" : "t21.UNIT",
    "name" : "UNIT"
  }, {
    "expression" : "t21.UNITPRICE",
    "name" : "UNITPRICE"
  }, {
    "expression" : "t1.UPDATEDATE",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.UPDATEMAN",
    "name" : "UPDATEMAN"
  } ],
  "queryCode" : "SELECT\nt1.QUANTITY*t21.UNITPRICE AS AMOUNT,\nt1.CREATEDATE,\nt1.CREATEMAN,\nt1.IBIZSAMPLE0012ID,\nt11.IBIZSAMPLE0012NAME,\nt1.IBIZSAMPLE0013ID,\nt1.IBIZSAMPLE0013NAME,\nt1.IBIZUNIPRODUCTID,\nt21.IBIZUNIPRODUCTNAME,\nt1.QUANTITY,\nt21.UNIT,\nt21.UNITPRICE,\nt1.UPDATEDATE,\nt1.UPDATEMAN\nFROM T_IBIZSAMPLE0013 t1 \nLEFT JOIN T_IBIZSAMPLE0012 t11 ON t1.IBIZSAMPLE0012ID = t11.IBIZSAMPLE0012ID \nLEFT JOIN T_IBIZUNIPRODUCT t21 ON t1.IBIZUNIPRODUCTID = t21.IBIZUNIPRODUCTID \n",
  "rTMOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0013/psdedataqueries/DEFAULT/psdedqcodes/DM",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0013/PSDEDATAQUERIES/Default/PSDEDQCODES/DM.json"
}