【市场营销】客户订单管理明细表模板.xlsx
客客户户订订单单管管理理明明细细表表订订单单数数量量订订单单金金额额已已收收金金额额未未收收金金额额收收款款率率订单编码日日期期181887588758291629165842584233.30%33.30%MM-002MM-0022021/3/22021/3/2客客户户信信息息表表订订单单明明细细表表客客户户编编码码 客客户户名名称称 订订单单金金额额已已收收金金额额未未收收金金额额序序号号 订订单单编编号号日日期期101010111,320.00440.00880.001MM-0012021/3/110101022555.00185.00370.002MM-0022021/3/2101010331,081.00360.00721.003MM-0032021/3/310101044912.00303.00609.004MM-0042021/3/4101010551,234.00411.00823.005MM-0052021/3/510101066450.00150.00300.006MM-0062021/3/610101077560.00186.00374.007MM-0072021/3/710101088140.0046.0094.008MM-0082021/3/810101099375.00125.00250.009MM-0092021/3/9101011010540.00180.00360.0010MM-0102021/3/10101011111750.00250.00500.0011MM-0112021/3/11101011212496.00165.00331.0012MM-0122021/3/12101011313345.00115.00230.0013MM-0132021/3/1314MM-0142021/3/1415MM-0152021/3/1516MM-0162021/3/1617MM-0172021/3/1718MM-0182021/3/18客客户户编编码码 客客户户姓姓名名产产品品名名称称规规格格单单价价数数量量金金额额发发货货日日期期101010210101022 2后后护护肤肤一一套套水水岩岩套套装装15.0015.001515225.00225.002021/5/262021/5/26客客户户编编码码 客客户户姓姓名名产产品品名名称称规规格格单单价价数数量量金金额额发发货货日日期期10101011女神洗面奶320ML25.0015375.002021/5/2510101022后护肤一套水岩套装15.0015225.002021/5/2610101033SUM洗面奶250ML25.0025625.002021/5/2710101044珀莱雅洗面奶330ML28.0020560.002021/5/2810101055润膏洗发水680ML26.0035910.002021/5/2910101066沙宣洗发水450ML15.0030450.002021/5/3010101077口红Dior74016.0035560.002021/5/3110101088隔离霜Dior20g14.0010140.002021/6/110101099唇膏兰芝25.0015375.002021/6/2101011010眼线笔兰芝27.0020540.002021/6/3101011111防晒霜兰芝30.0025750.002021/6/4101011212口红阿玛尼6790 31.0016496.002021/6/5101011313隔离霜兰州450g15.0023345.002021/6/610101011眼霜80ML63.0015945.002021/6/710101022女神洗面奶320ML15.0022330.002021/6/810101033后护肤一套水岩套装19.0024456.002021/6/910101044SUM洗面奶250ML22.0016352.002021/6/1010101055珀莱雅洗面奶330ML27.0012324.002021/6/11-客客户户订订单单管管理理明明细细表表订订单单明明细细表表-运运单单号号订订单单状状态态 已已收收金金额额未未收收金金额额备备注注FH0125402FH0125402运运输输中中75.0075.00150.00150.00运运单单号号订订单单状状态态 已已收收金金额额未未收收金金额额备备注注FH0125401未发货125.00250.00FH0125402运输中75.00150.00FH0125403已签收208.00417.00FH0125404未发货186.00374.00FH0125405运输中303.00607.00FH0125406已签收150.00300.00FH0125407未发货186.00374.00FH0125408运输中46.0094.00FH0125409已签收125.00250.00FH0125410未发货180.00360.00FH0125411运输中250.00500.00FH0125412已签收165.00331.00FH0125413未发货115.00230.00FH0125414运输中315.00630.00FH0125415已签收110.00220.00FH0125416未发货152.00304.00FH0125417运输中117.00235.00FH0125418已签收108.00216.00
