|
楼主 |
发表于 2019-6-19 09:37:03
|
显示全部楼层
刷新数据失败! ,
执行KSQL出错, KSQL: SELECT WMS_TabInventory.*,WMS_TabStoreInfo.fName as fStoreName,WMS_TabStoreArea.fName as fStoreAreaName,WMS_TabWare.fName as fWareName,WMS_TabCargo.fCode as fCode,WMS_TabCargo.fName as fName,WMS_TabCargo.fCnName as fCnName,WMS_TabCargo.fEnName as fEnName,WMS_TabCargo.fBrand as fBrand,WMS_TabCargo.fSize as fSize,WMS_TabCargo.fStanNo as fStanNo,WMS_TabCargo.fStatus as fStatus,WMS_TabCargo.fColor as fColor,WMS_TabCargo.fTemperature as fTemperature,WMS_TabCargo.fLong as fLong,WMS_TabCargo.fWight as fWight,WMS_TabCargo.fHigh as fHigh,WMS_TabCargo.fVolume as fVolume,WMS_TabCargo.fWeight as fWeight,WMS_TabCargo.fVeeTypeCode as fVeeTypeCode,WMS_TabCargo.fVeeCode as fVeeCode,WMS_TabCargo.fPutawayRc as fPutawayRc,WMS_TabCargo.fWareRc as fWareRc,WMS_TabCargo.fBatchRc as fBatchRc,WMS_TabCargo.fInvRevRc as fInvRevRc,WMS_TabCargo.fAllotRc as fAllotRc,WMS_TabCargo.fReplenishRc as fReplenishRc,WMS_TabCargo.fQuaRc as fQuaRc,WMS_TabCargo.fVolRc as fVolRc,WMS_TabCargo.fWeiRc as fWeiRc,WMS_TabCargo.fFSheetRc as fFSheetRc,WMS_TabCargo.fInstoreStRc as fInstoreStRc,WMS_TabCargo.fOutstorStRc as fOutstorStRc,WMS_TabCargo.fCurrencyRc as fCurrencyRc,WMS_TabCargo.fPrice as fPrice,WMS_TabCargo.fTakeRc as fTakeRc,WMS_TabCargo.fSendRc as fSendRc,WMS_TabCargo.fPortCode as fPortCode,WMS_TabCargo.fLoginName as fLoginName,WMS_TabCargo.fOutboundRules as fOutboundRules,WMS_TabCargo.fUnit as fUnit,WMS_TabCargo.fBarcode as fBarcode,WMS_TabCargo.fCvsRatio as fCvsRatio,WMS_TabCargo.fUnitConversionid as fUnitConversionid,WMS_TabCargo.fCargoCode as fCargoCode,WMS_TabWare.fHouseSit as fWareHouseSit,WMS_TabWare.fCode as ffWareCode,WMS_TabWare.fRowNo as fRowNo,WMS_TabWare.fLayerNo as fLayerNo,WMS_TabWare.fShelf as fShelf,WMS_TabWare.fSitNo as fSitNo,WMS_TabWare.fGird as fGird,WMS_MCargoType.fName as fMCargoTypeName,WMS_MCargoType.fCode as fMCargoTypeCode,WMS_TabClient.fName as fClientName FROM WMS_TabInventory WMS_TabInventory optional join WMS_TabCargo WMS_TabCargo on WMS_TabInventory.fGoodsId = WMS_TabCargo optional join WMS_TabStoreInfo WMS_TabStoreInfo on WMS_TabInventory.fStoreId = WMS_TabStoreInfo optional join WMS_TabStoreArea WMS_TabStoreArea on WMS_TabInventory.fStoreAreaId = WMS_TabStoreArea optional join WMS_TabWare WMS_TabWare on WMS_TabInventory.fWareId = WMS_TabWare optional join WMS_MCargoType WMS_MCargoType on WMS_MCargoType = WMS_TabCargo.fCargoTypeId optional join WMS_TabClient WMS_TabClient on WMS_TabCargo.fCargoId = WMS_TabClient ORDER BY tabEditDate DESC LIMIT 0, 20
--> sql: SELECT WMS_TabInventory.fID AS WMS_TabInventory, WMS_TabCargo.FALLOTRC AS fAllotRc, WMS_TabInventory.FAREAINFOID AS fAreaInfoId, WMS_TabCargo.FBARCODE AS fBarcode, WMS_TabCargo.FBATCHRC AS fBatchRc, WMS_TabCargo.FBRAND AS fBrand, WMS_TabCargo.FCARGOCODE AS fCargoCode, WMS_TabClient.FNAME AS fClientName, WMS_TabCargo.FCNNAME AS fCnName, WMS_TabCargo.FCODE AS fCode, WMS_TabCargo.FCOLOR AS fColor, WMS_TabCargo.FCURRENCYRC AS fCurrencyRc, WMS_TabInventory.FCUSTOM1 AS fCustom1, WMS_TabInventory.FCUSTOM10 AS fCustom10, WMS_TabInventory.FCUSTOM11 AS fCustom11, WMS_TabInventory.FCUSTOM12 AS fCustom12, WMS_TabInventory.FCUSTOM13 AS fCustom13, WMS_TabInventory.FCUSTOM14 AS fCustom14, WMS_TabInventory.FCUSTOM15 AS fCustom15, WMS_TabInventory.FCUSTOM16 AS fCustom16, WMS_TabInventory.FCUSTOM17 AS fCustom17, WMS_TabInventory.FCUSTOM18 AS fCustom18, WMS_TabInventory.FCUSTOM19 AS fCustom19, WMS_TabInventory.FCUSTOM2 AS fCustom2, WMS_TabInventory.FCUSTOM20 AS fCustom20, WMS_TabInventory.FCUSTOM3 AS fCustom3, WMS_TabInventory.FCUSTOM4 AS fCustom4, WMS_TabInventory.FCUSTOM5 AS fCustom5, WMS_TabInventory.FCUSTOM6 AS fCustom6, WMS_TabInventory.FCUSTOM7 AS fCustom7, WMS_TabInventory.FCUSTOM8 AS fCustom8, WMS_TabInventory.FCUSTOM9 AS fCustom9, WMS_TabInventory.FCUSTOMDATE1 AS fCustomDate1, WMS_TabInventory.FCUSTOMDATE2 AS fCustomDate2, WMS_TabInventory.FCUSTOMDATE3 AS fCustomDate3, WMS_TabInventory.FCUSTOMNUMBER1 AS fCustomNumber1, WMS_TabInventory.FCUSTOMNUMBER2 AS fCustomNumber2, WMS_TabInventory.FCUSTOMNUMBER3 AS fCustomNumber3, WMS_TabInventory.FCUSTOMNUMBER4 AS fCustomNumber4, WMS_TabInventory.FCUSTOMNUMBER5 AS fCustomNumber5, WMS_TabCargo.FCVSRATIO AS fCvsRatio, WMS_TabInventory.FDESCRIPTION AS fDescription, WMS_TabCargo.FENNAME AS fEnName, WMS_TabCargo.FFSHEETRC AS fFSheetRc, WMS_TabWare.FGIRD AS fGird, WMS_TabInventory.FGOODSID AS fGoodsId, WMS_TabCargo.FHIGH AS fHigh, WMS_TabCargo.FINSTORESTRC AS fInstoreStRc, WMS_TabCargo.FINVREVRC AS fInvRevRc, WMS_TabWare.FLAYERNO AS fLayerNo, WMS_TabInventory.FLOCKQTYS AS fLockQtys, WMS_TabCargo.FLOGINNAME AS fLoginName, WMS_TabCargo.FLONG AS fLong, WMS_MCargoType.FCODE AS fMCargoTypeCode, WMS_MCargoType.FNAME AS fMCargoTypeName, WMS_TabCargo.FNAME AS fName, WMS_TabCargo.FOUTBOUNDRULES AS fOutboundRules, WMS_TabCargo.FOUTSTORSTRC AS fOutstorStRc, WMS_TabCargo.FPORTCODE AS fPortCode, WMS_TabCargo.FPRICE AS fPrice, WMS_TabCargo.FPUTAWAYRC AS fPutawayRc, WMS_TabInventory.FQTYS AS fQtys, WMS_TabCargo.FQUARC AS fQuaRc, WMS_TabCargo.FREPLENISHRC AS fReplenishRc, WMS_TabWare.FROWNO AS fRowNo, WMS_TabCargo.FSENDRC AS fSendRc, WMS_TabWare.FSHELF AS fShelf, WMS_TabWare.FSITNO AS fSitNo, WMS_TabCargo.FSIZE AS fSize, WMS_TabCargo.FSTANNO AS fStanNo, WMS_TabInventory.FSTATE AS fState, WMS_TabCargo.FSTATUS AS fStatus, WMS_TabInventory.FSTOREAREAID AS fStoreAreaId, WMS_TabStoreArea.FNAME AS fStoreAreaName, WMS_TabInventory.FSTOREID AS fStoreId, WMS_TabStoreInfo.FNAME AS fStoreName, WMS_TabInventory.FSUPPLIERID AS fSupplierId, WMS_TabCargo.FTAKERC AS fTakeRc, WMS_TabCargo.FTEMPERATURE AS fTemperature, WMS_TabCargo.FUNIT AS fUnit, WMS_TabCargo.FUNITCONVERSIONID AS fUnitConversionid, WMS_TabInventory.FUSABLEQTYS AS fUsableQtys, WMS_TabCargo.FVEECODE AS fVeeCode, WMS_TabCargo.FVEETYPECODE AS fVeeTypeCode, WMS_TabCargo.FVOLRC AS fVolRc, WMS_TabCargo.FVOLUME AS fVolume, WMS_TabWare.FHOUSESIT AS fWareHouseSit, WMS_TabInventory.FWAREID AS fWareId, WMS_TabWare.FNAME AS fWareName, WMS_TabCargo.FWARERC AS fWareRc, WMS_TabCargo.FWEIRC AS fWeiRc, WMS_TabCargo.FWEIGHT AS fWeight, WMS_TabCargo.FWIGHT AS fWight, WMS_TabWare.FCODE AS ffWareCode, WMS_TabInventory.TABCREATEDATE AS tabCreateDate, WMS_TabInventory.TABCREATORID AS tabCreatorId, WMS_TabInventory.TABCREATORNAME AS tabCreatorName, WMS_TabInventory.TABEDITDATE AS tabEditDate, WMS_TabInventory.TABEDITORID AS tabEditorId, WMS_TabInventory.TABEDITORNAME AS tabEditorName, WMS_TabInventory.TABISDELETE AS tabIsDelete, WMS_TabInventory.TABISSHOW AS tabIsShow, WMS_TabInventory.TABREMARK AS tabRemark, WMS_TabInventory.VERSION AS version FROM wms_tabinventory WMS_TabInventory LEFT JOIN WMS_TABCARGO WMS_TabCargo ON WMS_TabInventory.FGOODSID = WMS_TabCargo.fID LEFT JOIN WMS_TABSTOREINFO WMS_TabStoreInfo ON WMS_TabInventory.FSTOREID = WMS_TabStoreInfo.fID LEFT JOIN WMS_TABSTOREAREA WMS_TabStoreArea ON WMS_TabInventory.FSTOREAREAID = WMS_TabStoreArea.fID LEFT JOIN WMS_TABWARE WMS_TabWare ON WMS_TabInventory.FWAREID = WMS_TabWare.fID LEFT JOIN WMS_MCARGOTYPE WMS_MCargoType ON WMS_MCargoType.fID = WMS_TabCargo.FCARGOTYPEID LEFT JOIN WMS_TABCLIENT WMS_TabClient ON WMS_TabCargo.FCARGOID = WMS_TabClient.fID ORDER BY tabEditDate DESC
--> binds: []
编码:JUSTEP150210 |
|