| | |
|---|
| | | M.idUnitByPurchase as idUnitByPurchasecode,P.name as idUnitByPurchasename,M.idUnitBySale as idUnitBySalecode,S.name as idUnitBySalename, |
|---|
| | | M.idunitbymanufacture as idunitbymanufacturecode,F.name as idunitbymanufacturename,M.idinventoryclass as idinventoryclasscode,C.name as idinventoryclassname, |
|---|
| | | M.isPurchase,M.isSale,M.isMadeSelf,M.isMaterial,M.isMadeRequest,M.idwarehouse as idwarehousecode,H.name as idwarehousename,M.lowQuantity,M.topQuantity,M.safeQuantity, |
|---|
| | | M.status,U.username as lm_user,M.lm_date,M.data_sources,M.is_retdproc,M.default_route |
|---|
| | | M.status,U.username as lm_user,M.lm_date,M.data_sources,M.is_retdproc,M.default_route,M.priuserdefnvc1,M.priuserdefnvc2,M.priuserdefnvc3,M.priuserdefnvc4,M.priuserdefnvc5,M.priuserdefnvc6 |
|---|
| | | from TMateriel_Info M |
|---|
| | | left join TUnit T on M.idunit=T.code |
|---|
| | | left join TUnit R on M.idSubUnitByReport=R.code |
|---|
