{
  "dBType" : "DM",
  "name" : "DM",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.QUANTITY*t21.UNITPRICE",
    "name" : "AMOUNT"
  }, {
    "expression" : "t1.CREATEDATE",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.CREATEMAN",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.IBIZSAMPLE0010ID",
    "name" : "IBIZSAMPLE0010ID"
  }, {
    "expression" : "t11.IBIZSAMPLE0010NAME",
    "name" : "IBIZSAMPLE0010NAME"
  }, {
    "expression" : "t1.IBIZSAMPLE0011ID",
    "name" : "IBIZSAMPLE0011ID"
  }, {
    "expression" : "t1.IBIZSAMPLE0011NAME",
    "name" : "IBIZSAMPLE0011NAME"
  }, {
    "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.IBIZSAMPLE0010ID,\nt11.IBIZSAMPLE0010NAME,\nt1.IBIZSAMPLE0011ID,\nt1.IBIZSAMPLE0011NAME,\nt1.IBIZUNIPRODUCTID,\nt21.IBIZUNIPRODUCTNAME,\nt1.QUANTITY,\nt21.UNIT,\nt21.UNITPRICE,\nt1.UPDATEDATE,\nt1.UPDATEMAN\nFROM T_IBIZSAMPLE0011 t1 \nLEFT JOIN T_IBIZSAMPLE0010 t11 ON t1.IBIZSAMPLE0010ID = t11.IBIZSAMPLE0010ID \nLEFT JOIN T_IBIZUNIPRODUCT t21 ON t1.IBIZUNIPRODUCTID = t21.IBIZUNIPRODUCTID \n",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0011/PSDEDATAQUERIES/Default/PSDEDQCODES/DM.json"
}