{
  "dBType" : "SQLSERVER",
  "name" : "SqlServer",
  "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/SQLSERVER.json"
}