SELECT
T046.FuserId AS FuserId -- 用户ID
,T046.FbasicDataId046 AS FbasicDataId046 -- 基本信息ID
,T046.Fnumber046 AS Fnumber046 -- 基本信息编号
,T046.FsysTypeId046 AS FsysTypeId046 -- 系统类型ID
,T046.FsysSonTypeId046 AS FsysSonTypeId046 -- 系统子类型ID
,T046.Fpassword046 AS Fpassword046 -- 员工密码
,T046.FownId046 AS FownId046 -- 货主ID
,T046A.Fnumber046 AS FownId046Number -- 货主编号
,T046A.Fname046 AS FownId046Name -- 货主名称
,T046.FparentId046 AS FparentId046 -- 父级ID
,T046B.Fnumber046 AS FparentId046Number -- 父级编号
,T046B.Fname046 AS FparentId046Name -- 父级名称
,T046.FparentIdB046 AS FparentIdB046 -- 父级ID
,T046C.Fnumber046 AS FparentIdB046Number -- 父级编号
,T046C.Fname046 AS FparentIdB046Name -- 父级名称
,T046.FparentIdC046 AS FparentIdC046 -- 父级ID
,T046D.Fnumber046 AS FparentIdC046Number -- 父级编号
,T046D.Fname046 AS FparentICd046Name -- 父级名称
,T046.FinterfaceId046 AS FinterfaceId046 -- 接口ID
,T046.FinterfaceNumber046 AS FinterfaceNumber046 -- 接口编号
,T046.FbarcodeId046 AS FbarcodeId046
,T046.FbarcodeIdB046 AS FbarcodeIdB046
,T046.FbarcodeIdC046 AS FbarcodeIdC046
,T046.FbarcodeIdD046 AS FbarcodeIdD046
,T046.Fname046 AS Fname046
,T046.FnameEn046 AS FnameEn046
,T046.FbatchPropertyGroupId046 AS FbatchPropertyGroupId046
,T012C.Fnumber012 AS FbatchPropertyGroupId046Number
,T012C.Fname012 AS FbatchPropertyGroupId046Name
,T046.FpackId046 AS FpackId046
,T046E.Fnumber046 AS FpackId046Number
,T046E.Fname046 AS FpackId046Name
,T046.FunitId046 AS FunitId046
,T525.FshowName525 AS FunitId046Name
,T046.FbomId046 AS FbomId046
,T374.Fnumber374 AS FbomId046Number
,T374.Fname374 AS FbomId046Name
,T046.FlpnRule046 AS FlpnRule046 -- LPN生成规则
,T046.FwcId046 AS FwcId046
,T046.FshowMode046 AS FshowMode046
,T046.FsysFlag046 AS FsysFlag046
,T046.FuseFlag046 AS FuseFlag046
,T046.FenabledFlag046 AS FenabledFlag046
,T046.Fstate046 AS Fstate046
,T046.FaddTime046 AS FaddTime046
,T046.FaddEmpId046 AS FaddEmpId046
,T046.FaddEmpName046 AS FaddEmpName046
,T046.FeditTime046 AS FeditTime046
,T046.FeditEmpId046 AS FeditEmpId046
,T046.FeditEmpName046 AS FeditEmpName046
,T046.Fmemo046 AS Fmemo046
,T046.Udf01a046 AS Udf01a046
,T046.Udf02a046 AS Udf02a046
,T046.Udf03a046 AS Udf03a046
,T046.Udf04a046 AS Udf04a046
,T046.Udf05a046 AS Udf05a046
,T046.Udf06a046 AS Udf06a046
,T046.Udf07a046 AS Udf07a046
,T046.Udf08a046 AS Udf08a046
,T046.Udf09a046 AS Udf09a046
,T046.Udf10a046 AS Udf10a046
,T046.Udf11a046 AS Udf11a046
,T046.Udf12a046 AS Udf12a046
,T046.Udf13a046 AS Udf13a046
,T046.Udf14a046 AS Udf14a046
,T046.Udf15a046 AS Udf15a046
,T046.Udf16a046 AS Udf16a046
,T046.Udf17a046 AS Udf17a046
,T046.Udf18a046 AS Udf18a046
,T046.Udf19a046 AS Udf19a046
,T046.Udf20a046 AS Udf20a046
,T046.UDF21N046 AS UDF21N046
,T046.UDF22N046 AS UDF22N046
,T046.UDF23N046 AS UDF23N046
,T046.UDF24N046 AS UDF24N046
,T046.UDF25N046 AS UDF25N046
,T046.UDF26N046 AS UDF26N046
,T046.UDF27N046 AS UDF27N046
,T046.UDF28N046 AS UDF28N046
,T046.UDF29N046 AS UDF29N046
,T046.UDF30N046 AS UDF30N046
,T046.Udf31a046 AS Udf31a046
,T046.Udf32a046 AS Udf32a046
,T046.Udf33a046 AS Udf33a046
,T046.Udf34a046 AS Udf34a046
,T046.Udf35a046 AS Udf35a046
,T046.Udf36a046 AS Udf36a046
,T046.Udf37a046 AS Udf37a046
,T046.Udf38a046 AS Udf38a046
,T046.Udf39a046 AS Udf39a046
,T046.Udf40a046 AS Udf40a046
,T046.Udf41a046 AS Udf41a046
,T046.Udf42a046 AS Udf42a046
,T046.Udf43a046 AS Udf43a046
,T046.Udf44a046 AS Udf44a046
,T046.Udf45a046 AS Udf45a046
FROM BS_basicData046 T046 -- -
LEFT JOIN BS_basicData046 T046A -- 货主
ON T046.FuserId = T046A.FuserId
AND T046.FownId046 = T046A.FbasicDataId046
LEFT JOIN BS_basicData046 T046B -- -三级货类
ON T046.FuserId = T046B.FuserId
AND T046.FparentId046 = T046B.FbasicDataId046
LEFT JOIN BS_basicData046 T046C -- 二级货类
ON T046.FuserId = T046C.FuserId
AND T046.FparentId046 = T046C.FbasicDataId046
LEFT JOIN BS_basicData046 T046D -- 一级货类
ON T046.FuserId = T046D.FuserId
AND T046.FparentId046 = T046D.FbasicDataId046
LEFT JOIN BS_BOM374 T374 -- BOM
ON T046.FuserId = T374.FuserId
AND T046.FbomId046 = T374.FbomSerialId374
LEFT JOIN SYS_propertyGroup012 T012C --
ON T046.FuserId = T012C.FuserId
AND T046.FbatchPropertyGroupId046 = T012C.FpropertyGroupId012
LEFT JOIN BS_basicData046 T046E -- 包装
ON T046.FuserId = T046E.FuserId
AND T046.FpackId046 = T046E.FbasicDataId046
LEFT JOIN BS_packUnit525 T525 -- 单位
ON T046.FuserId = T525.FuserId
AND T046.FpackId046 = T525.FpackId525
AND T046.FunitId046 = T525.FunitId525
这是 v_BS_GOODS_base 视图 ,