完整单据设计
生产系统单据设计

通过生产指令和工序汇报,以期达到材料冲销材料,产品冲销产品的状况。
生产过程的管理,其一、要将每环节执行的情况及时反映,并与计划对比反映出差异;其二、反映出车间工序进销存;其三反映出质量状况及质量原因和形成因素;其四、反映生产效果与效率,如投入产出率(收率)<产品和材料>,设备利用率<产品和设备>,人工利用率一、生产指令模块生产指令模块属于总汇模块,由生产指令、工序计划、计划投料三种数据构成。
1、生产指令又称生产通知单、生产作业计划,是生产开始前,按日期下达给生产的第一工序部门的品种生产计划。
生产指令.01 2014.06.09 制定部门:生产部2、工序计划工序计划是根据生产指令,按照工艺路线生成的具体工序加工计划。
一张生产指令生成一张工序计划。
3、计划投料计划投料是根据生产指令,结合工序计划行程的预计投料。
在请领单过渡时,可以关联生产指令、物料、工序查看。
若BOM中,若分工序录入了物料清单,计划投料处也同样显示。
?工序字段本是用于修饰INID的,此处用于修饰INIE是否合适?二、生产汇报生产汇报也称为报工单,是在生产过程中或生产结束后,对生产的情况进行的记录。
生产汇报是一个复合模块,包含产品的产出、材料的投入及损耗、人工工时和机器工时等。
生产汇报和工序汇报的关系:工序汇报为生产汇报的明细,其汇总方式遵循如下原则:工序汇报投入之和=生产汇报投入(材料,人工,机器,能源等皆如此,即不含交接)工序最终产出=生产汇报产出(即最后一道工序产出)半成品入库单:半成品与产成品的最大区别是,半成品要带完工工序,而不是以是否能够销售来决定。
这主要解决到处带完工工序问题,即只有半成品的查询才会带主要部件的问题:BOM中应该设置一个主要部件,在查询时可以将半成品一起查出生产汇报根据生产指令过渡而来,可以同时过渡产品生产、材料投入、人工及机器工时以便修改。
相应的,所有产品产出单也是根据生产指令而来。
作业三单的设计思路

作业三单的设计思路
作业三单是学生完成作业后需要提交的单据,设计思路应符合以下要求:
1. 简洁明了:作业三单应该清晰地显示学生的姓名、班级、学号和作业名称,以及作业的得分和评语等必要信息,使学生、老师和家长能够快速和准确地了解作业情况。
2. 统一规范:作业三单的设计应符合学校出具的格式和规范,以便于学生和老师的使用和管理。
同时,应注意字体和字号的选择,保证阅读清晰舒适,避免字体过小或过大,影响用户的使用体验。
3. 易于填写:作业三单应该设计成易于填写的样式,包括各项信息的排版、填写选项的设置等方面,尽可能减少填写错误的可能性。
4. 考虑用户需求:作业三单的设计应考虑到不同用户的需求,如老师需要查询和管理学生的作业情况,学生需要了解自己的作业得分和评语,家长需要了解孩子的作业情况和学习进度等。
5. 保证信息安全:作业三单应该保证信息的安全性和私密性,避免学生和家长的个人信息泄露和被滥用的可能性。
综上所述,作业三单的设计应该简洁明了、统一规范、易于填写、考虑用户需求和保证信息安全,从而实现学生、老师和家长之间的良好沟通和协作。
- 1 -。
全套单据制作

根据下列所提供资料和信用证有关信息缮制单据,并请注明汇票的议付日期。
1)有关资料如下:本信用证项下货物分两批装运,已发运其中的第一批,GW:7038.00KGS,NW:6294.00KGS, MEAS: 17CBM, 包装件数: 1649卷(ROLLS),所有货物被装进1×20' CONTAINER,CONTAINER NO.:TSTU156417,提单号码: SHANK00710,船名:DANUBHUM/S009。
2)信用证如下所示:209 07BKCHCNBJ95B BANK OF CHINA, SUZHOU BRANCH409 07BKCHHKHHXXX BANK OF CHINA, HONGKONG BRANCHMT700 O BKCHCNBJ95BXXXX:21: SEQUENCE OF 1/1:40A: FORM OF DOC: IRREVOCABLE:20: DOCUMENT CREDIT NO: HK1112234:31C: DATE OF ISSUE: 040101:31D: DATE OF DATE AND EXPIRY: 040431:50: APPLICANT: YOU DA TRADE CO.,LTD.,101 QUEENS ROAD CENTRAL,HONGKONGTEL: 852-********:59.: BENEFICIARY: KUNSHAN HUACHENG WEAVING AND DYEING CO.,LTDHUANGLONG RD., LIUJIA ZHEN, SUZHOU,JIANGSU, CHINATEL: 86-520-7671386:32B: AMOUNT: USD33,680:41D: AVAILABLE WITH …BY…ANY BANK NEGOTIATION:42C: DRAFTS AT...SIGHT:42D: DRAWEE: OURSELVES:43P: PARTIAL SHIPMENT: NOT ALLOWED:43T: TRANSSHIPMENT: NOT ALLOWED:44A: LOADI NG ON BOARD/DISPATCH/TAKING IN CHARGE AT/FROM…SHANGHAI:44B: FOR TRANSPORTATION TO…HONGKONG:44C: LATEST DATE…040415:45A: DESCRIPTION OF GOODS AND/OR SERVICES100PCT NYLON FABRICS 100000YARDS USD0.3368/YD USD33680.00DETAILS AS PER CONTRACT NO. 99WS061PRICE TERM: CIF HONGKONGSHIPPING MARK: MARKS AND NOS.YOU DAHONGKONGR/NO.:1-3298:46A: DOCUMENTS REQUIRED:1.SINGED COMMERCIAL INVOICE IN 5 FOLDS INDICATING L/C NO. AND CONTRACT NO.99WS061.2.FULL SET (3/3) OF CLEAN ON BOARD MARINE BILLS OF LADING MADE OUT TO ORDER ANDBLANK ENDORSED, MARKED ‘FREIGHT PREPAID’ AND NOTIFY THE APPLICANT.3.INSURANCE POLICY OR CERTIFICATE IN 2 FOLDS FOR 110 PCT OF THE INVOICE VALUEINDICATING CLAIM PAYABLE AT DESTINATION COVERING OCEAN TRANSPORTATION ALL RISKS AND WAR RISKS AS PER ICC CLAUSES.4.PACKING LIST IN 3 FOLDS INDICATING GROSS AND NET WEIGHT OF EACH PACKAGE.5.CERTIFICATE OF ORIGIN IN 3 FOLDS.6.BENEFICIARY’S LETTER MUST BE FAX TO THE APPLICANT ADVISING GOODS NAME,CONTRACT NO., L/C NO., NAME OF VESSEL, AND DATE OF SHIPMENT.:47A: ADDITIONAL CONDITIONS:+ ON DECK SHIPMENT IS NOT ALLOWED.+ ALL DOCUMENT MUST BE MANUALLY SIGNED.:48: PERIOD FOR PRESENTATION:DOCUMENTS MUST BE PRESENTED WITHIN 15 DAYSAFTER THE DATE OF SHIPMENT BUT WITHIN THEVALIDITY OF THE CREDIT.:49: CONFIRMATION: WITHOUT:72: SPECIAL INSTRUCTIONS:ALL DOCUMENT MUST BE SEND TO THE ISSUING BANK IN ONE LOT THROUGH THE NEGOTIATING BANK BYREGISTERED AIRMAIL.UPON RECEIPT THE DOCUMENTS CONFORMITY WITH THE L/C’S CONDITIONS, WE SHALL PAY AS PER YOURINSTRUCTIONS.MAC: ABC8794666SW2222222546HUANGLONG RD., LIUJIA ZHEN, SUZHOU,JIANGSU, CHINAHUANGLONG RD., LIUJIA ZHEN, SUZHOU,JIANGSU, CHINA中国对外贸易运输总公司Consignee or orderCHINA NATIONAL FOREIGN TRADE TRANSPORTATION CORP.直运或转船提单BILL OF LOADINGNotify address DIRECT OR WITH TRANSHIPMENTSHIPPED on board in apparent goodorder and condition (unless otherwise indicated) the goods or packagesspecified herein and to be discharged at the mentioned port of discharge oras near thereto as the vessel may safely get and be always afloat.The weight, measure,marks and numbers, quality, contents and value. Being particularsfurnished by the shipper, are not checked by the currier on loading.Pre-carriage by Place of receipt The shipper, consignee and the holder of this bill oflading hereby expressly accept and agree to all printed, written or stampedprovisions. Exceptions and conditions of this Bill of Lading, includingthose on the back hereof.Vessel Port of loading IM WITNESS whereof the number of originalBills if Ladingstated below have been signed, one ofwhich being accomplished, the other to be voidPort of discharges Final destinationContainer seal No. Number and kind of packages Gross weight(kgs.) Measurement(m3)or marks and Nos. Description of goodsREGARDING TRANSHIPMENT Freight and char gesINFORMATION PLEASE CONTACTEx. rate Prepaid at freight payable at Place and date of issueTotal prepaid Number of original Signed for or on behalf of the MasterBs/Las Agent(SINOTRANS STANDARD FORM4)SUBJECT TO THE TERMS AND CONDITIONS ON BACK 95c No. 0123450Invoice No. or B/L No.运输工具查勘代理人per conveyance S.S. Survey By:起运日期自Slg. on or abt. From至To保险金额Amount Insured保险货物项目、标记、数量及包装:承保条件Description, Marks, Quantity & Packing of Goods:Conditions:签单日期Date:For and on behalf of PING AN INSURANCE COMPANY OF CHINA,LTD.authorized signatureKUNSHAN HUACHENG WEAVING AND DYEING CO.,LTD HUANGLONG RD., LIUJIA ZHEN, SUZHOU,JIANGSU, CHINATo(Authorized Signature)。
外贸单证全套单据制作

体验活动根据下述材料,缮制商业发票和装箱单(1)销售合同SALES CONFIRMATIONNO.: ZHT081115 DATE:,2008 THE SELLER:SHANGHAI ZHENHUA IMP&EMP CO LTD THE BUYER:GR-TRAG Co., Ltd.ADRESS: Rm 501 Longju Building No. 87 Longju Rd., Pudong Shanghai 200136 A904 Wealth Building,Kando Jinbocho Chiyodaku, Tokyo Japan Tel.:+8Fax: +8THE UNDERSIGNED SELLERS AND BUYERS HAVE AGREED TO CLOSE THE FOLLOWING TRANSACTIONS ACCORDING TO THE TERMS AND CONDITIONS STIPULATED BELOW:PACKING:ONE PIECE IN ONE POLYBAG, 30 POLYBAGS IN ONE CARTONSHIPMENT:NOT LATER THAN ,2009, FROM SHANGHAI TO TOKYO JAPAN, ALLOWING TRANSHIPMENT & PARTIAL SHIPMENTS.PAYMENT: THE BUYER SHOULD OPEN THROUGH A BANK ACCEPTABLE TO THE SELLER AN 100% IRREVOCABLE L/C PAYABLE AT 30 DAYS AFTER SIGHT DRAFT TO REACH THE SELLERS BEFORE , 2008 AND VALIDFOR NEGOTIATION IN CHINA UNTIL THE 15TH DAY AFTER THE DATE OF SHIPMENT. INSURANCE:TO BE EFFECTED BY THE SELLER FOR 110% OF INVOICE VALUE AGAINST AS PER THE RELEVANT OCEAN MARINE CARGO OF P. I. C. C. DATED 1/1/1981.THE BUYERS: THE SELLERSGR-TRAG Co., Ltd. SHANGHAI ZHENHUA IMP&EMP CO LTD(SIGNATURE) (SIGNATURE)PLEASE SIGN AND RETURN ONE COPY(2)信用证APPLICATION HEADER 0 700 1417 970214FKBKJPJTAXXX 1343 337998 97021 1317* SUMITOMO MITSUI BANKING CORPORATION TOKYOUSER HEADER SERVICE CODE 103:BANK. PRIORITY 113:MSG USER REF. 108:INFO. FROM CI 115:SEQUENCE OF TOTAL *27 : 1/1FORM OF DOC. CREDIT *40A : IRREVOCABLEDOC. CREDIT NUMBER *20 : TK0842DATE OF ISSUE *31C : 081201EXPIRY *31D : DATE 090215 PLACE CHINAISSUING BANK *51 :SUMITOMO MITSUI BANKING CORPORATIONNAKANOMACHI 1-10-15, MIYAKOJIMA-KU TOKYO JAPANAPPLICANT *50 : GR-TRAG CO., LTD.A904 WEALTH BUILDING, KANDO JINBOCHO CHIYODAKU,TOKYO JAPANBENEFICIARY *59 : SHANGHAI ZHENHUA IMP&EMP CO LTDRM 501 LONGJU BUILDING NO.87 LONGJU RD.,PUDONG SHANGHAI 200136 *32B : CURRENCY USD AMOUNTMAX. CREDIT AMOUNT 39B: NOT EXCEEDINGAVAILABLE WITH/BY *41D : ANY BANKBY NEGOTIATIONDRAFTS AT… 42C : 30 DAYS AFTER SIGHTDRAWEE 42A : SUMITOMO MITSUI BANKING CORPORATIONNAKANOMACHI 1-10-15, MIYAKOJIMA-KU TOKYO JAPANPARTIAL SHIPMENTS 43P : ALLOWEDTRANSSHIPMENT 43T : ALLOWEDLOADING IN CHARGE 44A : SHANGHAI, CHINAFOR TRANSPORT TO 44B : TOKYO JAPANLATEST DATE OF SHIP. 44C : 090131DESCRIPT. OF GOODS 45A : WOMEN JEANW3301 2400 PCS USD PCW3001 1200 PCS USD PCDOCUMENTS REQUIRED 46A :1.SIGNED COMMERCIAL INVOICE IN 3 COPIES INDICATING CREDIT NO.2.FULL SET CLEAN ON BOARD MARINE BILL OF LADING MADE OUT TO ORDER OF SHIPPERAND BLANK ENDORSED NOTIFY APPLICANT MARKED FREIGHT PREPAID3.PACKING LIST IN 3 COPIES4.CERTIFICATE OF ORIGIN5.FULL SET INSURANCE POLICY OR CERTIFICATE COVERING FROM WAREHOUSE TOWAREHOUSE WITH CLAIMS PAYABLE AT DESTINATIONADDITIONAL COND *47B :+REIMBURSENT BY TELECOMMUNICATION IS PROHIBITED+ONE COPY OF INVOICE, PACKING LIST AND ORIGINAL CERTIFICATE OF ORIGIN (FORM A) MUST BE SENT TO THE ACCOUNTEE BY COURIER IMMEDIATELY AFTER SHIPMENT AND BENEFICIARY’S CERTIFICATE TO THIS EFFECT IS REQUIREDDETAILS OF CHARGES 71B : ALL BANKING CHARGES OUTSIDE CANADA ARE FOR ACCOUNTOF THE BENEFICIARYPRESENTATION PERIOD 48 : DOCUMENTS TO BE PRESETNED WITHIN 15 DAYSAFTER THE DATE OF SHIPMENT BUT WITHIN THEVALIDITY OF THE CREDITCONFIRMATION *49 : WITHOUTINSTRUCTIONS 78 :+REIMBURSENENT IS SUBJECT TO ICC URR525+PROVIDED THAT THE TERMS AND CONDITIONS OF THIS CREDIT ARE COMPLIEDWITH PLEASE REIMBURSE YOURSELVES FROM ABOVE REIMBURSEMENT BANK+DRAFT AND DOCUMENTS ARE TO BE SENT BY COURIEDR TO OUR HEAD OFFICE SUMITOMO MITSUI BANKING CORPORATION (ADDRESS: NAKANOMACHI 1-10-15, MIYAKOJIMA-KU TOKYO JAPAN) IN ONE LOT(3)补充资料:发票日期:发票号码:ZHT5743装船日:船名船次:Dingyuan卖方负责人:张启东唛头:GR-TRAG / TK0842 / TOKYO / C/提单号:B2233101Q 投保日期:DEC-12-2008保单签发日:DEC-14-2008报检单位登记号:16 联系人:李莉电话:报检日期:报关日期:DEC-10,2008集装箱号:ONE 20' CONTAINER编码:99 产地证编号: 8净重:CNT 毛重:12KGS/CNT 体积:CNT20) SIGNATUREP A C K I N G L I S TP A C K I N G L I S T中保财产保险有限公司上海市分公司The People’s Insurance (Property)Company of China, Ltd. Shanghai Branch进出口货物运输保险投保单Application Form for I/E marine Cargo Insurance保险公司填写:保单号:费率:核保人:中华人民共和国出入境检验检疫出境货物报检单报检单位:编号:报检单位登记号:联系人:电话:报检日期:年月日中华人民共和国海关出口货物报关单预录入编号:海关编号:20) SIGNATUREP A C K I N G L I S T中保财产保险有限公司上海市分公司The People’s Insuranc e (Property)Company of China, Ltd. Shanghai Branch进出口货物运输保险投保单Application Form for I/E marine Cargo Insurance保险公司填写:保单号:费率:核保人:中华人民共和国出入境检验检疫出境货物报检单(检验检疫局)报检单位:上海振华进出口有限公司编号:中华人民共和国海关出口货物报关单预录入编号:海关编号:。
单据打印模板设计

单据打印模板设计单据打印模板设计方法介绍由于不同的用户使用的单据样式可能会与软件提供的标准样式不太一样。
为了能更好的支持客户的这种个性化需求,特提供了单据打印模板设计的功能。
现对此功能做一个介绍。
◆基本概念:单据结构:一张单据由表头区、明细数据区、表尾区和页码区组成。
单据中的对象,单据中包括了很多的对象如:单据标题、列标题、数据列、图片等。
每个对象都有一些属性,如:字体、字号、边框、位置、长宽等。
长度单位:使用软件自身的计量单位,◆使用方法:一、单据中的对象的布局调整对于单据各组成部分中的各对象的位置、大小可以通过两种方式进行调整。
第一种就是使用鼠标直接移动、拉动对象到指定位置或大小。
第二种是在选中了对象后通过[属性设置]按钮(或双击对象)打开属性对话框,然后对其中的各属性项的值进行设置来处理。
例如文本对象的属性框如下:二、单据结构的调整对于单据的各组成部分的长度的调整可以通过两种方式来处理。
1)通过设计窗口中的相应设置来调整。
如下图:其中对于页码区的调整,系统会自动处理。
如果选择不打印页码,则页码区会自动隐藏2)直接通过拖拉各组成部分底部黑线来调整。
如:(表头区)(页尾区)使用技巧一、可以不打印指定的内容吗?可以。
先选定一个不需要打印的对象,然后通过设计窗口中的[隐藏已选项]按钮来隐藏此对象,而明细数据区中的列是否打印,则最好是点击[列选择设置]按钮,在[列选择设置]功能中选择打印的明细列,或不选择不打印的明细列。
二、想对一批对象统一调整位置或大小如何做?对于调整位置,可以先选定一个对象做为基准(距左,距顶,宽,高),然后按住CTRL不放,再选择好其它对象。
然后通过设计窗口中的 [调整位置] 中的对齐功能来统一调整所有选择的对象的位置和大小。
如图:三、希望返回初始打印样式怎么做?可以通过 [重置] 功能来实现。
如下图:四、页尾中想加一些自定义的内容,并且有多行,怎么做?如下图为系统提供的页尾内容:1.如签字信息行,如经手人、审核人等需要根据具单据进行设置2.如页脚信息不够用,可点击[增加文本]按钮,增加“自定义文本”,“自定义文本”可以通过“删除文本”按钮删除3.您可以对其中的页脚信息通过[属性设置]功能来分别设置内容、大小和位置等属性如图:其中[文本内容]中的内容可以换行。
制全套单据

世格外贸单证教学系统44E: Port of loading SHANGHAI CHINA44F: Port of discharge TORONTO CANADA44C: Latest Date of Ship 10043045A: Descript of Goods AS PER APPLICANT ORDER NO. PET/CAN/5POLISHED MARBLE TILES, 30.5×30.5×1CM. PLUS OR MINUS 0.5 MM.ART NO.425:312.56 SQM.ART NO.424-2:312.56 SQMTOTAL: 625.12 SQM AS PER S/C 87MAF4002-43 AND 87MAF4002-44THE BUYER’S TELEX NO.422.46A:Documents required +SIGNED COMMERCIAL INVOICE IN 3 COPIES INDICATING L/C NO.AND CONTRACT NO.+PACKING LIST/WEIGHT MEMO IN 3 COPIES INDICATING QUANTITY,GROSS AND WEIGHTS OF EACH PACKAGE+MANUALLY SIGNED CERTIFICATE OF ORIGIN IN 3 COPIESINDICATING THE NAME OF THE MANUFACTURER+ COMPLETE SET OF NOT LESS THAN 3 ORIGINAL CLEAN ON BOARDOCEAN BILLS OF LADING MARKED “FREIGHT PAID”. NOTIFY PETRICOINTERNATIONAL TRADING CORP.,1110 SHEPPARD AVENUE EASTSUITE 406 WILLOWDALE ONTARIO, CANADA, M2K2W2.+BENEFICIARY’S CERTIFICATE IN REQUIRED EVIDENCING THAT ONECOMPLETE SET OF NON-NEGOTIABLE SHIPPING DOCUMENTS HAVEBEEN SENT BY AIRMAIL TO BOTH THE CONSIGNEE AND ALEXANDERFRASER AND SON LTD, NOT LATER THAN DATE OF PRESENTATIONOF NEGOTIABLE DOCUMENTS.+SHIPPING ADVICE IN 3 COPIES INDICATING L/C NO. AND CONTRACTNO.+ BENEFICIARY’S SIGNED STATEMENT THAT MERCHANDI SE PACKEDIN WOODEN CRATES WITH PLASTIC FOAM BOX.+ALL RISKS AND WAR RISKS INSURANCE POLICIES OR CERTIFICATEIN DUPLICATE ENDORSED IN BLANK FOR NOT LESS THAN THE FULLCIF VALUE PLUS 10 PERCENT OF THE SHIPMENT IN THE CURRENCYOF THE CREDIT.TRANSSHIPMENT RISKS TO BE COVERED IF TRANSSHIPMENTEFFECTED.47A: Additional Conditions BILL OF LADING TO EVIDENCE GOODS SHIPPED IN A 20 FEETCONTAINER.CONSIGNEE-PETRICO INTERNATIONAL TRADING CORPORATION1110 SHEPPARD AVENUE EAST SUITE 406 WILLOWDALE ONTARIO,CANADA M2K2W2.71B: Details of Charges ALL BANKING CHARGES OUTSIDE BRAZIL ARE FOR A/C OFBENEFICIARY.48: Presentation Period DOCUMENTS TO BE PRESENTED WITHIN 15 DAYS AFTER THE DATEOF SHIPMENT,BUT WITHIN THE VALIDITY OF THE CREDIT.49:CONFIEMATION INSTRUCTIONS WITHOUT答案:CHINA NATIONAL METALS AND MINERALS EXP﹠IMP CORP.,JIANGSUBRANCH.201 ZHUJIANG ROAD , JIANGSU, CHINACOMMERCIAL INVOICETo: PETRICO INTERNATIONAL TRADINGCORP.,1110SHEPPARD AVENUE EAST SUITE 406WILLOWDALE ONTARIO, CANADA,M2K2W2. InvoiceNo.:CNM-100310InvoiceDate:100310S/C No.: 87MAF4002-4387MAF4002-44 S/C Date:From: SHANGHAI To: TORONTO CANADA Letter of CreditNo.:001/02/14020X Date: 13 APR,2010TOTAL:625.12 SQM USD15002.88 SAY TOTAL:US DOLLARS FIFTEEN THOUSANDS TWO POINT EIGHTY EIGHT ONLY.SIGNATURECHINA NATIONAL METALS AND MINERALS EXP﹠IMP CORP.,JIANGSUBRANCH.201 ZHUJIANG ROAD ,NANJING, JIANGSU, CHINAPACKING LISTTo: CHINA NATIONAL METALS ANDMINERALS EXP﹠IMPCORP.,JIANGSU BRANCH. 201ZHUJIANG ROAD , JIANGSU,CHINA Invoice No.: CNM-100310 Invoice Date:Feb,22,2010From: SHANGHAI To: TORONTO CANADA VIA HONGKONGMarks and Numbers Number andkind ofpackageDescriptionof goodsQuantityPackage G.W N.W Meas.ARTNO.42 5 ARTNO.424-2 AS PERAPPLICANTORDER NO.PET/CAN/5POLISHEDMARBLETILES,30.5×30.5×1CM. PLUS ORMINUS 0.5MM.312.56SQM.312.56SQM8CRATES8CRATES8.800MT8.800MT8.480MT8.480MT3.6M33.6M3TOTAL: 625.12SQM 16CRATES17.600MT16.960MT7.2M3SAYTOTAL:SAY SIXTEEN CRATES ONLYSIGNATUREORIGINAL1. Goods consigned from (Exporter's business name, address, country) Reference No.CHINA NATIONAL METALS AND MINERALS EXP﹠IMP CORP.,JIANGSUBRANCH. 201 ZHUJIANG ROAD , JIANGSU, CHINAGENERALIZED SYSTEM OF PREFERENCESCERTIFICATE OF ORIGIN(Combined declaration and certificate)2. Goods consigned to (Consignee's name, address, country) FORM APETRICO INTERNATIONAL TRADING CORP.,1110 SHEPPARD AVENUE EAST SUITE 406 WILLOWDALE ONTARIO, CANADA, M2K2W2. Issued inTHE PEOPLE'S REPUBLIC OFCHINA (country)See Notes overleafShipperB/L NO. APLU333333121CHINA NATIONAL METALS AND MINERALS EXP ﹠IMP CORP.,JIANGSU BRANCH. 201 ZHUJIANG ROAD , JIANGSU, CHINAPACIFIC INTERNATION LINES (PTE) LTD(Incorporated in Singapore)COMBINED TRANSPORT BILL OF LADINGReceived in apparent good order and condition except as otherwisenoted the total number of container or other packages or units enumerated below for transportation from the place of receipt to theplace of delivery subject to the terms hereof. One of the signed Bills ofLading must be surrendered duly endorsed in exchange for the Goodsor delivery order. On presentation of this document (duly) Endorsed to the Carrier by or on behalf of the Holder, the rights and liabilities arisingin accordance with the terms hereof shall (without prejudice to any ruleof common law or statute rendering them binding on the Merchant)become binding in all respects between the Carrier and the Holder as though the contract evidenced hereby had been made between them. SEE TERMS ON ORIGINAL B/L Consignee ALEXANDER FRASER AND SON LTD.FRANKLAND MOORE HOUSE, 185/187 HIGH ROAD, CHADWELL HEATH, ROMFORD , ESSEX. RM6 2NR. Notify Party PETRICO INTERNATIONAL TRADING CORP., 1110 SHEPPARD AVENUE EAST SUITE 406 WILLOWDALE ONTARIO, CANADA, M2K2W2. Vessel and Voyage NumberPort of LoadingPort of DischargeLANJING V.0213SHANGHAI CHINATORONTO CANADAPlace of ReceiptPlace of DeliveryNumber of Original Bs/LPARTICULARS AS DECLARED BY SHIPPER – CARRIER NOT RESPONSIBLEContainer Nos/Seal Nos. Marks and/Numbers No. of Container / Packages / Description of GoodsGross Weight(Kilos)Measurement(cu-metres)P.M.T. TORONTO NO.1-1616 CARTONSPOLISHED MAEBLE TILESART NO. 425,424-2 1X20’ CONTAINER17600KGS7.2M 3FREIGHT & CHARGES Number of Containers/Packages (in words)SAY SIXTEEN(16) CORTES ONLY.Shipped on Board Date:中保财产保险有限公司The People’s Insurance (Property) Company of China,Ltd发票号码Invoice No. CNM-100310保险单号次Policy No.1000002596 海洋货物运输保险单MARINE CARGO TRANSPORTATION INSURANCE POLICY被保险人:Insured:CHINA NATIONAL METALS AND MINERALS EXP﹠IMP CORP.,JIANGSU BRANCH. 201 ZHUJIANG ROAD , JIANGSU, CHINA中保财产保险有限公司(以下简称本公司)根据被保险人的要求,及其所缴付约定的保险费,按照本保险单承担险别和背面所栽条款与下列特别条款承保下列货物运输保险,特签发本保险单。
ERP自定义单据格式设计例子

单元格处于选中状态(呈黑色)时才能设置样式。 (七) 特殊功能介绍
1. 添加图片 企业的单据上经常会有本企业的 LOGO 图片。本单据设置提供了这样的功能。添加的图片会被压缩显 示,丌会撑大单元格。
单元格变量 单元格系统变量 数据项:单据中的字段 计算公式:单据中的数字型字段(如:数量、价格等)运算后的值
由于行属性的丌同,并丌是所有这些来源都是可取到的。比如:表首只能取【单元格变量】不【单 元格系统变量】,而另外两种来源呈灰色丌能选取。
选中某单元格(呈黑色)时,点击上面相应的按钮就可以进行选取。动态内容在设计时表现为由 中括号包含的内容。 (六) 样式设置
3. 随便选中一个单元格(呈黑色),点击工具栏【页面设置】按钮,打开【页面设置】对话框。在这 里可以设置打印边距、每页打印内容的最大行数等。
没页打印的最 大记录数Fra bibliotek设置页边距
(三) 框架布局 易助单据格式是用表格来实现布局的。其操作(行,单元格等)不 WORD 基本相同。布局就是先“打 格画线”,而先丌设置内容。常用的表格操作命令都在工具栏上列出了。
(五) 填写内容 表格布局设计好后,就可以往里面填写内容了。从总体上讲单元格内容分两种:一种是静态内容。你 填的什么,将来单据中看到的就是什么;另一种是动态内容。动态内容都是抓取字段来显示。 1. 静态内容的填写 在某个单元格中进行双击,即可填写。单元格选中状态(呈黑色)时丌能输入内容。 2. 动态内容的填写 动态内容的来源有几个方面:
单 身
单 尾
外贸单据制作样板大全

单据缮制(学生实训指导手册)-《商业发票》《装箱单》P A C K I N G L I S T操作指导2.分析装箱单关键词《国际航空货运单》制单说明1.货运单号码(The Air Waybill Number),货运单号码应清晰地印在货运单的左右上角以及右下角(中性货运单需自行填制)。
(1)始发站机场的IATA三字代号(1A)航空公司的数字代号(1B)货运单序号及检验号(第八位数字是检验号,是前7数字对7取模的结果)(1C)货运单所属承运人的名称及地址2.托运人栏(Shipper)(2)填制托运人姓名、地址、国家以及托运人的电话、传真、电传号码3.托运人账号(Shipper’s Name and Address)(3)此栏不需填写,除非承运人需要4.收货人栏(Consignee)(4)填制收货人名称、地址、国家以及收货人的电话、传真、电传号码5.收货人账号(Consignee’s Name and Address)(5)此栏不需填写,除非承运人需要6.名称和城市(Name and city)(6)填制向承运人收取佣金的国际航协代理人的名称和所在机场或城市7.国际航协代号(Agent’s IATA code)(7)代理人在非货结账算区(Non-CASS Areas),打印国际航协7位数字代号,代理人在货结账算区(CASS Areas),打印国际航协7位数字代号,后面是三位CASS地址代号,和一个冠以10位的7位数字代号检验位。
8.账号(Account No.)(8)此栏不需填写,除非承运人需要9.运输路线(Routing)(9)第一承运人地址和所要求的运输路线(11A)填制目的站机场或第一个转运点的IATA三字代号(11B)填制第一承运人的名称(11C)填制目的站机场或第二个转运点的IATA三字代号(11D)填制第二承运人的IATA三字代号(11E)填制目的站机场或第三个转运点的IATA三字代号(11F)填制第三承运人的IATA三字代号(18)填制最后承运人的目的地机场全称(19A)、(19B)航班/日期, 此栏不需填写,除非承运人需要10.财务说明(Accounting Information)(10)此栏填制有关财务说明事项11.货币(Currency)(12)填制始发国的ISO的货币代号12.运费代号(CHGS Code)(13)本栏一般不需填写,仅供电子传送货运单信息时使用13.运费(Charges)(14A)航空运费和申明的价值附加费预付(14B)航空运费和申明的价值附加费到付(15A)在始发站的其他费用预付(15B)在始发站的其他费用到付14.供运输用声明价值(Declared Value for carriage)(16)打印托运人向货物运输声明的价值金额,如果托运人没有声明价值,此栏必须打印“NCV”字样15.供海关用声明价值(Declared value for Customs)(17)打印货物及通关时所需的商业价值金额,如果货物没有商业价值,此栏必须打印“NCV”字样16.保险的金额(Amount of Insurance)(20)如果承运人向托运人提供代办货物保险业务时,此栏打印托运人货物投保的金额,如果承运人不提供此项服务或托运人不要求投保时此栏内必须打印“XXX”符号。
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
软件开发环境与工具实验报告实验(六)实验题目:完整表单设计指导老师:班级:计算机科学与技术系1203班姓名:一、实验题目完整单据的设计二、实验目的通过本次实验,了解单据的类型及重要性,掌握两种单据的设计及制作方法,特别是单据中的编码以及状态的控制,为课程设计做准备。
三、实验内容1、实现单据的新增、修改、删除、浏览、审核、弃审等功能。
2、对单据的编码及状态要进行控制。
3、用.NET分层架构设计。
4、单据的具体内容自定。
四、实验过程1.实验说明:单据制作实验中总共涉及3个项目,第一个是单据设计(为启动项),其中包括login.vb、bills.vb两个窗体,第二个是单据设计.Data (类库)包含clsHT 和clsuser类,第三个是mycommon类,SQLHelper.vb、clsGetCode.vb和clsConn.vb。
2.数据库设计:数据库:单据 gg_User表:用户登录信息(用户ID、用户名、密码、状态)gg_CodeFormat表:(自动生成单据编码)gg_GouCheHT表:(购车:单据编码、制单名称、客户名称、制单人、审核人)3.实验代码用户登录:Public Class login‘重新定义clsUser为oDim o As New clsUserPrivate Sub 登录_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles 登录.ClickDim dr As SqlClient.SqlDataReaderdr = o.getall2dr(" user_name='" & Me.TextBox1.Text & "'and uesr_state= '1'")If dr.Read ThenIf dr.Item("user_pwd") = Me.TextBox2.Text ThenMessageBox.Show("恭喜您登录成功!", "系统提示", MessageBoxButtons.OK, rmation)单据设计.Show()Me.Close()ElseMessageBox.Show("密码错误!", "系统提示",MessageBoxButtons.RetryCancel, rmation)End IfElseMessageBox.Show("该用户不存在", "系统提示",MessageBoxButtons.OKCancel, rmation)End IfEnd SubEnd ClassSQLHelper.vb为项目通用数据访问类,所有数据访问均使用该类来实现。
‘自动更新单据内容Public Class clsGetCodePublic Shared Function getNewCode(ByVal pbmmc As String) As String Dim strSQL As StringDim NewCode As String = ""Dim LSH As StringstrSQL = "select * from gg_CodeFormat where bmmc='" & pbmmc & "'" Dim dr As SqlClient.SqlDataReaderdr = myCommon.SqlHelper.ExecuteReader(myCommon.clsConn.getstrConn, CommandType.Text, strSQL)While dr.ReadSelect Case dr.Item("bmlx")Case "文本"NewCode &= dr.Item("bmz")Case "年¨º"If dr.Item("bmz") <> Format(Now, "yyyy") ThenNewCode &= Format(Now, "yyyy")LSH = "X"'更新操作Call Update(dr.Item("id"), Format(Now, "yyyy"))ElseNewCode &= dr.Item("bmz")End IfCase "月"If dr.Item("bmz") <> Format(Now, "MM") ThenNewCode &= Format(Now, "MM")LSH = "X"'更新操作Call Update(dr.Item("id"), Format(Now, "MM"))ElseNewCode &= dr.Item("bmz")End IfCase "日"If dr.Item("bmz") <> Format(Now, "dd") ThenNewCode &= Format(Now, "dd")LSH = "X"'更新操作Call Update(dr.Item("id"), Format(Now, "dd"))ElseNewCode &= dr.Item("bmz")End IfCase "流水号"Dim newLsh As StringIf LSH = "X" ThennewLsh = "0001"NewCode &= newLshElsenewLsh = Format(CType(dr.Item("bmz"), Decimal) + 1, "0000")NewCode &= newLshEnd IfCall Update(dr.Item("id"), newLsh)End SelectEnd WhileReturn NewCodeEnd FunctionPublic Shared Function Update(ByVal pid As Integer, ByVal pbmz As String)As StringDim strSQL As StringstrSQL = "update gg_codeFormat set bmz='" & pbmz & "' WHERE id=" & pidmyCommon.SqlHelper.ExecuteNonQuery(myCommon.clsConn.getstrConn, CommandType.Text, strSQL)End FunctionEnd Class‘双击视图里的某一行,在“单据设计”窗体上显示单据信息的代码:Private Sub DataGridView1_CellContentClick(ByVal sender AsSystem.Object,ByVal e As System.Windows.Forms. DataGridViewCellEventArgs) Handles DataGridView1.CellContentClicktxtdjbm.Text = DataGridView1.CurrentRow.Cells.Item(0).Value.ToStringtxtkhmc.Text = DataGridView1.CurrentRow.Cells.Item(2).Value.ToStringtxtzdrq.Text = DataGridView1.CurrentRow.Cells.Item(1).Value.ToStringtxtzdr.Text = DataGridView1.CurrentRow.Cells.Item(3).Value.ToStringtxtshr.Text = DataGridView1.CurrentRow.Cells.Item(4).Value.ToStringEnd Sub单据制作窗体设计主要运用toolscript1控件来制作工具栏内容,如“新增”“删除”“取消”“保存”“审核”“弃审”等按钮的功能,“datagidview”控件,显示数据库中信息。
‘保存功能:Public Function save() As StringstrSQL = " insert into ht_GouCheHT(djbm,zdrq,khmc,zdr,shr) values('" & ddjbm & "','" & dzdrq & "','" & dkhmc & "','" & dzdr & "','" & dshr myCommon.SqlHelper.ExecuteNonQuery(myCommon.clsConn.getstrConn, CommandType.Text, strSQL)Return "1"Catch ex As ExceptionReturn "-1" & ex.MessageEnd TryEnd Function‘新增功能;Public Function edit() As StringstrSQL = " update ht_GouCheHT set khmc ='" & dkhmc & "' where djbm='"& ddjbm &"'TrymyCommon.SqlHelper.ExecuteNonQuery(myCommon.clsConn.getstrConn, CommandType.Text, strSQL)Return "1"Catch ex As ExceptionReturn "-1" & ex.MessageEnd TryEnd Function‘删除功能Public Function delete() As StringstrSQL = " delete from ht_GouCheHT where djbm='" & ddjbm & "'"TrymyCommon.SqlHelper.ExecuteNonQuery(myCommon.clsConn.getstrConn, CommandType.Text, strSQL)Return "1"Catch ex As ExceptionReturn "-1" & ex.MessageEnd TryEnd Function‘单据制作中保存单据的判断Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.ClickDim sr As Stringo.ddjbm = Me.txtdjbm.Texto.dkhmc = Me.txtkhmc.Texto.dzdrq = Me.txtzdrq.Texto.dzdr = Me.txtzdr.Texto.dshr = Me.txtshr.TextIf action = "new" And Me.txtshr.Text = "管理员" Thensr = o.saveIf sr = "1" ThenMsgBox("保存成功!")Call InitData()ElseMsgBox("保存失败!")End IfElse Ifaction = "new" And Me.txtSHR.Text = "" Then MsgBox("该单据未经审核人审核,无效!")Elseo.dKHMC = Me.txtKHMC.Textsr = o.editIf sr = "1" ThenMsgBox("更新成功!")Call InitData()ElseMsgBox("更新失败")End IfEnd IfCall btnState(0)End Sub4.运行结果登录界面:主界面:单击显示所有用户:新增客户信息:五、实验总结通过本次实验,使我对单据程序的应用及设计思想有了初步理解,了解了单据的类型及重要性,掌握两种单据的设计及制作方法,特别是单据中的编码以及状态的控制。