最近在做成本计算时经常会要去考虑里面的一些关联表,这里我整理了下,仅供参考
select * from T_HS_STOCKDIMENSION --(核算维度表)
select * from T_BD_MATERIALINVPTY--(物料库存属性)
select * from T_HS_OUTACCTG--(出库核算表)
select * from T_HS_CALDIMENSIONS--(存货核算计算维度表)
select * from T_HS_OUTINSTOCKSEQ where FORDERNUMBER=''--(出入库序列表)
select * from T_HS_OUTINSTOCKSEQ_H where FORDERNUMBER!=''--出入库序列历史表
select * from T_HS_BALANCE--(核算维度余额表)、历史表
select * from T_HS_BALANCE_H--核算维度余额历史表
select * from T_HS_INIVBALANCE--(库存维度余额表)、历史表
select * from T_HS_INIVBALANCE_H--库存维度余额历史表
select * from T_HS_OUTSTOCKINDEXENTRY--(出入库序列配置)
select * from t_cb_proorderdime as a
left join t_cb_proorderinfo as b on a.FPRODUCTDIMEID=b.FPRODUCTDIMEID
select * from t_cb_proorderdime as a
left join t_cb_proorderinfo as b on a.FPRODUCTDIMEID=b.FPRODUCTDIMEID
select * from T_CB_PROORDERTYPE
推荐阅读