销售台账明细表-公式计算.xlsx

销售台账明细表-公式计算订单编号订单日期产品名称品类产品规格合同数量合同单价车牌号发货量(吨)件数发货日期交货天数收货地址实际单价实际金额开票日期开票金额发票号aASD0012021/4/29HREΦ22mm棒材螺纹1螺纹钢22335360ABC00131.999102021/5/22427743.76 230.00 aASD0022021/4/29HREΦ22mm棒材螺纹2螺纹钢32335510ABC00231.857102021/5/22869111.10 231.00 aASD0032021/4/30HREΦ22mm棒材螺纹3螺纹钢22335360ABC00331.953102021/5/32658467.55 232.00 aASD0042021/4/30HREΦ22mm棒材螺纹4螺纹钢32335510ABC00431.918102021/5/32116734.70 233.00 aASD0052021/4/30HREΦ22mm棒材螺纹5螺纹钢32335510ABC00531.995102021/5/32969470.52 234.00 aASD0062021/4/30HREΦ22mm棒材螺纹6螺纹钢32335510ABC00631.883102021/5/333210585.16 235.00 aASD0072021/4/30HREΦ22mm棒材螺纹7螺纹钢14175460ABC00716.08922021/5/21963153.44 236.00 aASD0082021/4/30HREΦ22mm棒材螺纹8螺纹钢1275510ABC0086.42552021/5/23382171.65 237.00 aASD0092021/4/30HREΦ22mm棒材螺纹9螺纹钢16105410ABC0099.63932021/5/22672573.61 238.00 aASD0102021/4/30HREΦ22mm棒材螺纹10盘螺10105460ABC0108.59642021/5/21521306.59 239.00 aASD0112021/4/30HREΦ22mm棒材螺纹11螺纹钢16135410ABC01112.86332021/5/21722212.44 240.00 aASD0122021/4/30HREΦ22mm棒材螺纹12螺纹钢12105510ABC0129.8142021/5/22732678.13 241.00 aASD0132021/4/30HREΦ22mm棒材螺纹13螺纹钢12335510ABC01332.347102021/5/12788992.47 242.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 合计26429871030287.3749100330875201.113068.00