Excel单证合集(自动换算).xls

发票号 IN20101201制单日期 证通号 L C NO 合同号ALI20101201日期 12月 01 2010 成交条件FOB QINGDAO 付款方式T T要求开证日期 合同交货期 贸易国消费国 运费付款方式 可否转船Y可否分装Y PackingIN PLYWOOD PALLET 船名提单号 装船港转船港目的港 提单正本分数3最终交货地 FORMA号标记 海关税则号给惠国 客户名称地址ABC co ltd 开证行 提单台头人 Consignee 通知人 Notify Form A收货人 汇票付款人 口麦 头AS ORDER 发票附注 箱单附注 提单附注 Form A附注 公共附注 发票货名willow baskets 发票货描as contact no 1234567 货号标题ITEM 货物明细 货号SIZEQUANTITY内装数件数单价金额毛重净重 尺码 110100cm30 pcs10360 0001800108 60 合 计90 3 1800000 000 折佣前加费金额0 折佣前扣费金额0 佣金 百分比0 0 00 最终总金额1800 00 手工输入 总金额0总毛重0总净重 0总尺码0 000 总件数0 发票货描 合计毛重 合计净重尺码 000 000 售售 货货 确确 认认 书书 SALES CONFIRMATION No IN20101201 Date 06 12月 06 To Messrs ABC co ltd The Undersigned Sellers and Buyers have agreed to close the following transactions according to terms and condions stipulated below 1 Commodity Quantity Unit price Amount willowwillow basketsbaskets ART NO SIZEPCSINNER QTYUSDUSD 110110100cm100cm3 30 01 10 06 60 0 0 00 01 18 80 00 0 0 00 0 TOTALTOTAL3 30 01 10 0 PCSPCSUSD1 800 001 800 00 2Loading Port and Destination FROM QINGDAO TO USA 3 Time of Shipment 1212月 月 31 1899 31 1899 4 Insurance A To be effected by the sellers for 110 of the invoice value against All Risks and War Risk as per C I C B To be effected by the buyers 5 Terms of payment T T 6 Packing IN PLYWOOD PALLET 7Mark AS ORDER 8 Other Terms with 10 more of less both in amount and quantity allowed at the Seller s option SELLERBUYER INVOICE INVOICE NO IN20101201 12月 31 1899 To Messrs ABC co ltd Marks No DESCRIPTIONQuantityUnit PriceTotal willow baskets AS ORDERas contact no 1234567 FOB QINGDAO 11030 pcsUS 60 00US 1 800 00 REF 90 pcsUSD 1 800 00 PACKING LIST INVOICE NO IN20101201 12月 31 1899 willow baskets Marks No Bales No QuantityITEM SIZE 1 3 1030pcs110100cm AS ORDER 60 3IN PLYWOOD PALLET TOTAL PACKED IN 3IN PLYWOOD PALLET REF REF REF AS ORDER WEIGHT PACKING LIST INVOICE NO IN20101201 Qingdao 12月 31 1899 willow baskets Marks No Bales No QuantityART NO GW CTNSNW CTNSMEAS CTNS 1 3 10 pcs108 REF REF REF REF REF REF 0 AS ORDER REF REF REF REF RE