今天用户让我导其中一个外包商的外协工单的单价,这可是从来没弄过,通过和用户沟通并阅读官方帮助,最终很容易就导出来了这份数据。
这里记录一下对应的Sql语句
<br/>--801<br/>Select <br/>T$mitm,T$tano,T$subr,T$indt,T$exdt<br/>From BAAN.Ttirou102801<br/>Where T$tano='9003'<br/>ORDER BY T$mitm;<br/>
官方解释如下:
<br/>The subcontracting rate factor, together with the subcontracting base rate, determines the cost of subcontracting.<br/>The value of this field depends on the setting of the calculation method for the subcontracting rate as recorded in the Subcontracting Rates (ticpr1160m000) session.<br/>If this field reads Operation Rate, the following construction is possible. You may depart from a base rate for subcontracting and further specify that base rate for each operation line.<br/><br/>Example<br/>Subcontracting rate is 100<br/>Subcontracting rate factor is 2<br/>The total cost of subcontracting is 200<br/>
相应的Session