SELECT
goods_base.FuserId AS FuserId --??ID
,goods_base.FbasicDataId046 AS FbasicDataId046 --??ID
,goods_base.Fnumber046 AS Fnumber046 --????
,goods_base.FsysTypeId046 AS FsysTypeId046 --????ID
,goods_base.FsysSonTypeId046 AS FsysSonTypeId046 --?????ID
,goods_base.FownId046 AS FownId046 --???ID
,goods_base.FownId046Number AS FownId046Number --?????
,goods_base.FownId046Name AS FownId046Name --?????
,goods_base.FlpnRule046 AS FlpnRule046 --????????xxm??
,goods_base.FparentId046 AS FparentId046 --????ID
,goods_base.FparentId046Number AS FparentId046Number --??????
,goods_base.FparentId046Name AS FparentId046Name --??????
,goods_base.FparentIdB046 AS FparentIdB046 --????ID
,goods_baseA.Fnumber046 AS FparentIdB046Number --??????
,goods_baseA.Fname046 AS FparentIdB046Name --??????
,goods_base.FparentIdC046 AS FparentIdC046 --????ID
,goods_baseB.Fnumber046 AS FparentIdC046Number --??????
,goods_baseB.Fname046 AS FparentIdC046Name --??????
,goods_base.FinterfaceId046 AS FinterfaceId046 --??ID
,goods_base.FinterfaceNumber046 AS FinterfaceNumber046 --????
,goods_base.FbarcodeId046 AS FbarcodeId046 --????
,GOODS_BASE.FBARCODEIDB046 AS FbarcodeIdb046
,goods_base.Fname046 AS Fname046 --????
,goods_base.FnameEn046 AS FnameEn046 --??????
,goods_base.FbatchPropertyGroupId046 AS FbatchPropertyGroupId046 --?????Id
,goods_base.FbatchPropertyGroupId046Number AS FbatchPropertyGroupId046Number --???????
,goods_base.FbatchPropertyGroupId046Name AS FbatchPropertyGroupId046Name --???????
,goods_base.FpackId046 AS FpackId046 --??
,goods_base.FpackId046Number AS FpackId046Number --????
,goods_base.FpackId046Name AS FpackId046Name --????
,goods_base.FunitId046 AS FunitId046 --??ID
,goods_base.FunitId046Name AS FunitId046Name --????
,goods_base.FshowMode046 AS FshowMode046 --????
,goods_base.FsysFlag046 AS FsysFlag046 --????
,goods_base.FuseFlag046 AS FuseFlag046 --????
,goods_base.FenabledFlag046 AS FenabledFlag046 --????
,goods_base.Fstate046 AS Fstate046 --??
,goods_base.FaddTime046 AS FaddTime046 --????
,goods_base.FaddEmpId046 AS FaddEmpId046 --????ID
,goods_base.FaddEmpName046 AS FaddEmpName046 --??????
,goods_base.FeditTime046 AS FeditTime046 --????
,goods_base.FeditEmpId046 AS FeditEmpId046 --????ID
,goods_base.FeditEmpName046 AS FeditEmpName046 --??????
,goods_base.Fmemo046 AS Fmemo046 --??
,goods_base.udf01a046 AS udf01a046
,goods_base.udf02a046 AS udf02a046
,goods_base.udf03a046 AS udf03a046
,goods_base.udf04a046 AS udf04a046
,goods_base.udf05a046 AS udf05a046
,goods_base.udf06a046 AS udf06a046
,goods_base.udf07a046 AS udf07a046
,goods_base.udf08a046 AS udf08a046
,goods_base.udf09a046 AS udf09a046
,goods_base.udf10a046 AS udf10a046
,goods_base.udf11a046 AS udf11a046
,goods_base.udf12a046 AS udf12a046
,goods_base.udf13a046 AS udf13a046
,goods_base.udf14a046 AS udf14a046
,goods_base.udf15a046 AS udf15a046
,goods_base.udf16a046 AS udf16a046
,goods_base.udf17a046 AS udf17a046
,goods_base.udf18a046 AS udf18a046
,goods_base.udf19a046 AS udf19a046
,goods_base.udf20a046 AS udf20a046
,goods_base.udf33a046 AS udf33a046
,goods_base.udf40a046 AS udf40a046
,T004.FRFIDable004 AS FRFIDable004 --RFID启用标记
,T004.FgoodsId004 AS FgoodsId004 --??ID
,T004.FgrossWeight004 AS FgrossWeight004 --??
,T004.FnetWeight004 AS FnetWeight004 --??
,T004.Fcubic004 AS Fcubic004 --??
,T004.FunitPrice004 AS FunitPrice004 --??
,T004.Fdensity004 AS Fdensity004 --??
,T004.FexpirationDay004 AS FexpirationDay004 --???
,T004.FexpirationUnit004 AS FexpirationUnit004 --?????
,T004.FQCFlag004 AS FQCFlag004 --????
,T004.FweightMode004 AS FweightMode004 --??????
,T004.FoverInRate004 AS FoverInRate004 --????
,T004.FSNdigitFrom004 AS FSNdigitFrom004 --??????
,T004.FSNdigitTO004 AS FSNdigitTO004 --??????
,T004.FINVTurnover004 AS FINVTurnover004 --????
,T004.FaddTime004 AS FaddTime004 --????
,T004.FeditTime004 AS FeditTime004 --????
,T004.FSNFlag004 AS FSNFlag004
,T004.Fwarehouseid004 AS Fwarehouseid004 -- ????
,T046A.Fname046 AS Fwarehouseid004name
,T046A.Fnumber046 AS Fwarehouseid004number
,T004.Fsupplierid004 AS Fsupplierid004 -- ?????
,T046B.Fname046 AS Fsupplierid004name
,T046B.Fnumber046 AS Fsupplierid004number
FROM BS_goods004 T004 --???
LEFT JOIN
v_BS_GOODS_base goods_base --????
ON goods_base.FuserId = T004.FuserId
AND goods_base.FbasicDataId046 = T004.FgoodsId004
AND goods_base.FsysTypeId046 = 'GOODS'
LEFT JOIN
BS_basicData046 goods_baseA --????
ON goods_baseA.FuserId = goods_base.FuserId
AND goods_baseA.FbasicDataId046 = goods_base.FparentIdB046
AND goods_baseA.FsysTypeId046 = 'CLASS'
LEFT JOIN
BS_basicData046 goods_baseB --????
ON goods_baseB.FuserId = goods_base.FuserId
AND goods_baseB.FbasicDataId046 = goods_base.FparentIdC046
AND goods_baseB.FsysTypeId046 = 'CLASS'
LEFT JOIN BS_BASICDATA046 T046A -- ????
ON T004.Fwarehouseid004 = T046A.Fbasicdataid046
AND T046A.fsystypeid046 = 'ORGANIZE' AND T046A.fsyssontypeid046 = 'WAREHOUSE'
LEFT JOIN BS_BASICDATA046 T046B -- ???
ON T004.Fsupplierid004 = T046B.Fbasicdataid046
AND T046B.fsystypeid046 = 'CUSTOM' AND T046B.fsyssontypeid046 = 'CUSTOM02' 这是wms系统的一个货品信息视图 ,分析 每个字段的含义 分析是什么表 关系是什么
最新发布