CAMDS Auxiliary Input Tool (CIE) User's Manual
Contents
1. ed 14 3 Ingredients 15 Item No click this 18 19 Quick tools Build Tree 0 i 1 TE Ze A 1 2 24 1 2 1 1 oz d d dd 26 121111 2T 28 29 we p tame The MDS level is Component1 Character 30 Character 100 Character 100 not allowed to Semi Component 2 exceed twenty Material 3 Substance 4 16 Item Group system section Component i Item Character 100 core Remark Character 100 Character 200 range 0 lt X lt 1000000 range 0 lt X 1000000 range precision 0 000001 precision 0 precisi IA a A A A AA A A To delete many continuous rows choose the row number in the front and pull downwards to select many continuous rows Then click Del Row to delete all the selected rows 15 item No 1 2 3 4 5 6 7 8 9 10 11 16 Item Group System section Componentsection The MDS level is Component 1 Character 30 Character 100 Character 100 Character 100 Character 100 Character 200 Jrange OsXs1000000 range 0 lt X lt 1000000 range it t not allovved to Semi Component 2 precision 0 000001 Jprecision 0 preci aie exceedtwenty Material 3 18 Substance 4 Quick tools Del Row Build Tree C 1 1 AE SS A SS EY AA e A O AO AA I Ha AA o A A EE A A A EE AAA ERA BEE EE A AA AAA AAA E CAE A AO WS A A A AA A VA 125111 EO AE OOO lee AAA AAA AAA AAA AAA To delete spaced rows press Ctrl to choose row numbers before clicking Del Row Then click Del Row to del2. ESME ceshi 0816 1 mb CATARC Saha 35232532 mo 101 ME 100 Pa 9901 e 0 sd od 9010 19 12 00 00 2010 11 19 1 De 0 O 0 ag t n Pal MAP POPEO PROP POP B R IBID PRSH BARR B R PRSH PAR B R POP B R B R IBID BARE S R PRSH IPII B R OOP gt IPIP POP DARDH DAIRO OPROEP A DAAR HOE PAD R R IBIP DAL S R IBID PAR B R HN 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 a a t PtH N tt n st n we n 4 1 tt H MOM IBID MO MO BOSH PADLO DANO PAN MDN OOP NMN N MO MO NN NN y i CA g 37077 he T R an CANT a m i ge gt Bar 1 i n TIS H2102 shi pa 100 2010 01 28 12 00 00 2010 01 28 12 00 00 2010 01 28 Note the file name should not contain the character of in browsing box 5 Sheet Upload Methods and Notes CATARC authorized users have the authority to upload There has the item of Upload in the menu of Others My MDS Request is Folow Up Messages Modify Password Settings Upload Upload Download Statistics Click the button of Browse to upload CSV files needed GO ma le arar P BR EZ 0 am S i EER ms 2011 01 19 16 16 23 RARR HE Cv 20110114091027 zip 2011 1 14 9 09 WinRAR ZIF sa Sh aaa csv 2011 1 26 15 45 Microsoft C 2011 01 19 16 16 06 111111111 csv Y Saas CA_5_17242
3. tet P uj rge 100 od 0 9901 10 70 0 o 2010 11 19 12 00 00 2010 11 19 12 00 00 2010 11 19 1 o lid Pa MA OO PA POIDO GOILO S R PODIO DADIL DAN 3839 3937 Se S PAS S R S R PAN HN NN N y MAP PA PA DOIDO MOE POP B R O DADL DANO O DAN MN HN NN NH 3 3 3 3 3 3 3 3 3 3 3 El 3 3 3 El 3 3 3 3 3 3 3 3 3 3 3 3 3 mn 2 we Pr n wu PA IP t t eu yu 3 3 3 3 3 3 3 3 3 I P MOM MA MO OO OOP GAIRO IBID III DOIDO DOIDO DOIDO DOIDO POIDO R R B R IBID R R B R B R BOR POS POS POS POS IPIP MN NN NN NN ee 8 37T0TT 125 tet CANDSET R R sig 4a if n 11 Pu we IS S H2102 we 100 1 00 2010 01 28 12 00 00 2010 01 28 12 00 00 9010 01 28 12 DO OO ad ad ms ial ee ah a e wg 100 PPI HR 2929 3 3 3 3 3 3 n 1 n n Se MAP OM IBID PRSH MOE DOR GOPE DOIDO DOIE DOIDO PAS PAR S R SAIDO GOIE POIDO IBID IBID MOE S R DOIDO SOIL O DOIDO OP OOP PAR IBID S R PARA PATA P t 1937 3 3 3 3 3 3 3 3 3 3 we ne PAID he te ne we we IPI IIO ee ot wily we nrin 1 wen nu n P i 2971 Silicon i TE 7440 21 3 231 130 Pra tt n So we e lid wu n we n Se we a Br s Us 9 r e dla a Us 0 05 Example damaged CSV file SSE EFO SEM ENH upplierInformation N S DHE CA 3 40387 7 ARTE FREE K O10 67832387 O10 67832388 kangyifeifcat
4. 45 E m eas ael Fan CA 5 172 ee 3 20110126163810 zip 2011 1 26 16 37 WinRAR ZIP FESE 1221 Gj vo ES 1221 Sr 454 TE EA BF E r 3451 iq REFE e CA 5 17228 d ES SKEB E CA 5 17224 ER 3Eceshiyingyon SE KB ceshiyingyong EL AE C Tan CA 5 17218 Ga LENOVO D e 1 EN Spit 1488 TR CA 5 17215 F CA 5 17214 The format of downloaded file is Zip Right click to unzip the file WinRAR ZIP rag EOS Y ESA BE 20110126163810 E E EditPlus 3 E a HARI Sas ER 3600 H Drie HFH RET E BioExcess DE FEE BESIN EE ST de T JS 20110114081027 zip 2011 1 14 9 09 WinRAR ZIP FEES 2 KB SH E CA 5 17242 csv 20111714 9 10 Microsoft Office 5 KB dl AAA The name of CSV 1s the key ID of root node 6 2 Downloaded CSV file format The same as 4 2 exported CSV file format 7 Sheet Import Methods and notes 7 1 The Sheet has the node which has been already generated Click Import to pop up Tree dialog Node Name MAE tend E Contract Choose node 1 1 in the tree structure to be imported click Confirm to pop up import dialog i CA_5_17242 csv V ESE not allovved to Semi Component 2 8 N exceed twenty Material 3 s Substance 4 Gj ESSE w Build Tree nooo fp Na uoo h H u2 b T Al am Ls h IE RI Hs N daa EE TT A Op CSV csv Op INN EN SU Tau aro N Cl
5. item name PUCHA 30 E Item note 8 Quick tools Del Row Row Jessie sunstanco Details a There are 7 search conditions such as CAS No ENName and Synonym Entry of any condition will find the desired result The results are searched according to the intersection of the searching condition Fuzzy researching is supported Note the field of basic substance is automatically assigned value Apart from Confidential please do not alter other fields manually The default field of Confidential is No Please choose Yes in the combo box under the field of confidential substance to make it confidential 6 Add Application for Basic substance If necessary click the button of Application to add application for Basic substance When it is not necessary to add application for Basic substance after clicking the button of Application a message box pops up saying No need to select an application for the basic substance Please Choose Application Code Substance Application Not applicable Check operation BE I ea BG BH BI BJ Application Code 55 56 57 58 59 60 contenta Application Constitute Constitute Type Weight Proportion Type Type Propor D Yes 1 Character2 Weight 2 range 0 X 1000000 Range 1 range 0 lt X No 0 Proportion 3 precision 0 000001 Fixed 2 precision 0 Rest3 Application Click the button of Check
6. Entry of any condition will find the desired result The results are searched according to the intersection of the searching condition Fuzzy researching is supported Note the Material field of Standard material is assigned value to correspondent cell Manual revision of some contents 1s not recommended 3 Choose Classification Choose the material types to be added by clicking the button of Classification Those include unselected can not be chosen BGR FK AN25 hd f mr 1 Z Check TT E TR 3 Kasi Steels cast steel sintered steel i 34 unalloyed low alloyed 14 3 Ingredients hi Gly alloyed 15 Item No Cast iron Cast iron with lamellar graphite tempered cast iron Cast iron with nodular graphite vermicular cast iron Highly alloyed cast iron BSH Boj Light alloys cast and wrought alloys mot selectable Aluminium and aluminium alloys Cast aluminium alloys Wrought aluminium alloys Magnesium and magnesium alloys Cast magnesium alloys Wrought magnesium alloys Ek Titanium and titanium alloys E ES Rank Heavy metals cast and wrought alloys mot selectable id GER Copper e g copper amounts in cable harnesses m 16 Item Group Material 17 Item name Classification codelSymI Character 30 Character 600 Charac Item note 19 Quick tools Del Row Classification Classification LY MI me mM MRR Si ts Es
7. T Nye Ne sr k k k DPDPDPDP DP DPD HDHDHDHDHD HDHD WS Copper alloys Hat Zinc alloys 2 NE MEDE INN NN 22 o o o wae i ckal alloys 23 Oooo o o N a Lead Ed a N LE Ko Special metals not selectable 24 i Platinum rhodium h Breit E Other special metals 26 E ET N RAWH BE Polymer ler not selectable A HAXA Ati CIAT ThavmanLa efnat ralan shlal 27 o 28 Confirm Cancel 29 EEN o OOo caim a 4 Choose Norm Standard Choose the quoted standards and code of materials by clicking the button of Norm Standard Multi choice is supported When choose many items of Norm Standard all the material standards and numbers will be assigned value to the cell of Norm Standard with the separation of 5 item No 40 47 43 44 45 46 47 Item Group JE ia Normi Standard Test Test Report No Reg Release date 1D range 0 X Ed Character Character 600 Character 50 Item note Quick tools Del Row IL stancara_ Standard Basic Sut Confirm Cancel 5 Add Substance Click the button of Substance to manually add basic substances La Et s m Jia Boz 0 2 Aa pe ls Gi Fa shk p Please click the search button after the entry of search condition AW27 Q f CAS Ho ENName Synonym CNName PJ a B GADSL EU Index Check EC Index 4 3 Ingredients Search 5 Item No 7 6 item Group Substance secti ee was a
8. node ID of the upload CSV must belong to the user s organization I Upload with the same material ID When user s self defined data CAMDS number of ID of self built material are same the system regards them as the same material and only checks the first material while building one time system information Item Group E 100 Character 100 Character 100 Character 200 YYYY MM DD YYYY MM DD YYYY MM DD Character 30 Character 120 GE E 100 Charack pre hh mm ss hh mm ss hh mm ss Quick tools _Del Row Row Standard Material GE Ee GE I N Ai EO N al ma aa eee TT lA yop LL lani laa aa candi A o ui 1231 Node Name E 1 1 1 aaa dh 1 1 1 1 Heptachlorofluor opropane Ed 1 2 1 bbb 20 1 2 1 1 Molybdenum bis di tridecylcarbamodi thicato di mu ox Confirm 9Cancel LY WExtend a Contract Check Ingredients after successful exporting uploaded information Es ES Y cas 4 GEE 3 213 ss Ingredients 30 123 Details Supplier Information 3 aaa A Heptachlorofluoropropane Type Component Recipient data 3 321 3 f aaa ID Version CA 5 17345 0 01 fa Heptachlorofluoropropane E Supplier recycle of viecle EN y Article Name 213 Article Name FR Foreign Component No 3 Measured Mass ETE per Item 466 e N Calculated Mass per Item 466 Deviation 0 Polymeric part s wo Yes Parts marked as required on drawing O No Parts not marked
9. to show errors and warnings of the current Sheet Click the positioning of lines and columns to target the errors w 3 3 1 2 PEA 15 16 17 3 Ingredients Item No Item Group item name Item note Quick tools E Character 30 KAR EA ca Character 100 Character 200 range not allovved to Semi Component 2 precision exceed twenty Material 3 Substance 4 Del Row Build Tree A AA e EPIA O h e O IO S a error The name of MOS is blank warning No entry of Component No error No error Ne error Ne error No Sheet entry rules entry of the Measured Mass per Item or the entry is wrong calculation of Calculated Mass per Item or the entry is wrong calculation of Deviation or the entry is wrong entry of the Tolerance or the entry is wrong TD cell can not be filled in manually To introduce the existing components in CAMDS sheet with CSV format is needed to be downloaded before importing the node positions needed to be added ID is not needed to be filled in if the component is self built Apart from Material for many self established materials of the same type CAMDS a number can be filled in ID cell see 5 3 3 3 3 1 Add component into the component section Information about Name Component No Measured Mass per Item Quantity Calculated Mass per Item Deviation and Tolerance of component child node can be added in t
10. All rights reserved CAMDS Auxiliary Input Tool CIE User s Manual Version 2 3 China Automotive Material Data System Management Center S N Version Revised Date Major Revised Content Remarks l V1 0 2011 01 01 Established 2 V1 1 2011 05 01 Modify 3 V2 0 2011 11 04 Version upgrade Add Modify functions such as batch computing Revise some pictures in the manual and so on 4 V2 3 2014 06 25 Version upgrade Modify Maintenance about measured recyclability rate and measured recoverability rate and basic data update and so on 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Note this version releases the altered content Purpose This manual explains the input procedures and notes of CAMDS interface tool that has been in operation since January 1 2011 CATARC Standard Material Datasheet is hereinafter abbreviated as CAMDS interface tool 2 What is CAMDS interface tool CAMDS interface tool is made for the convenience of component enterprises to better match with CAMDS system CAMDS interface tool Composed of MDS check messages and entry skills CATARC should be updated in a timely manner to obtain the latest Editor Excel sheet 2 1 Sheet update To get the latest version contact with CATARC and download the latest version of software and relevant files from designated website 2 2 Configuration performance PC with the following c
11. MDS hierarchy is shown in tree structure Root node is 1 and its Child node is 1 1 1 2 Following the same rule the level number of all child nodes is generated by parent node plus 1 Check Pia aly A 14 3 Ingredients 5 15 item No 16 Item Group nae SE renn The MDS level is Component1 It t not allowed to Semi Component PEN exceed twenty Material 3 18 Substance 4 19 Quick tools Del Row Build Tree Click Confirm in the tree structure dialog box to generate MDS level in designated node Click Cancel to close the tree structure dialog box Click Extend to extend the tree structure Click Contract to close it At the same time the symbols of and can also be optional to extend or close the tree structure 3 2 3 Enter information about Component section Semi component section Material section Substance section and Node section 1 Enter information about Component field in Component Section 3 Ingredients Item No Item Group Component section Character 30 Character 100 Character 100 Character 100 Character 100 Character 200 range 0 X 1000000 range 0 X 1000000 range 0 lt X 1000000 precision 0 000001 fange precision 0 000001 precision 0 precision 0 000001 precis Calculate Calculate Quick tools Del Row Entry rules 6 Measured Mass per Item Range 0 lt X lt 1000000 Req
12. Pa IE o wew Ee he ah ne OS A IO IO IESO IESO FE po ISSO IESO IES IES IESO IES There are two pieces of recipient s information records After clicking Add recipients after uploading assign value to the column of Enterprise information Two options for Forwarding is allowed Yes marked as 1 and No marked as 0 Note all the cells should be filled in with half width English character 4 Sheet Export Methods and Notes 4 1 Sheet export rules Click the button of Export 1t will popups It may take a long time to check this MDS Do you want to check it If you select yes then it will check this MDS if you select no it will not check If you choose to check the MDS and the CSV meet the conditions of seven see Appendix I then the MDS export success If you do not check the MDS a file browsing dialog will pop up Choose save route fill in CSV file name click Save to export CSV file to selected route BEEK Xx Microsoft Office Eg ER ec RR i ih CA_5_17242 csv 2011 1 14 9 10 Microsoft wr hag not allowed to Semi Co exceed twenty Material Substane Build Tree dl ui L E I EE TE ed gt EN dd EER 4 GREHE CSVIZHE csv E 1 1 1 2 amp MEES 1 1 1 3 4 N E Administrator tao Abd fz 1 1 1 4 amp E 1 1 1 5 4 nz EN N N N mmm N N N N N EN NN EN EN EN EEN If choose to check the MDS a message box of CSV
13. csv 2011 1 14 9 10 Microsoft C 2011 01 05 19 08 46 BIN CSVESH csv 2011 01 05 19 07 55 Bizet 4 csv E 2011 01 05 19 07 41 EE G csv E ms 2010 12 14 16 04 42 ELAS FRAG csv sai 12 204 FFR sos 2010 12 14 15 49 28 LAS RE cov al RET 2010 12 14 15 48 41 BIRARE CV d ER 2010 12 14 15 47 49 BRAZ RRIE Cc dT He r TIFE N z n 2010 12 14 15 47 23 BERAZ FRISUE csv After selection click the button of Upload Errors will pop up 1f the Sheet has errors Upload MDS CSV File Time ANUAR 2011 01 26 15 5 Upload MDS O O Z O 22 2011 01 26 15 52 Validation error 2011 01 19 16 1 error The root of the MDS in the upload CSV can not be the existing MDS in the systems 2011 01 19 16 1 2011 01 05 19 0 2011 01 05 19 0 2011 01 05 19 0 2010 12 14 160 error 1 The root of the MDS in the upload CSY can not be the 2010 12 14 15 4 i existing MDS in the systemo 2010 12 14 15 4 CA CA CA CA CA Jump T After Close select the failed uploaded items and there has the button of Delete on the right corner of the dialog If there has no error in the Sheet a message box pops up saying Successful uploading CSV File Time 2011 01 26 15 5 Upload MDS SARAS 2011 01 26 15 5 Validation error PR sia warning 1 Component Sen 2011 01 26 15 5 2011 01 19 16 1 2011 01 19 1671 2011 01 05 19 0 2011 01 05 19 0 CA 5 11 CA a 11 CA 5 11 C
14. export succeeded pops up Click Confirm to shift to a page of Check Message to show the warning contents Check Import Export 3 Ingredients Item No 1 2 3 item Group JAPIA prompt i me o The MDS level is Component1 Character 30 CSV export succeeded it t not allovved to Semi Component 2 OE exceed hventy Material 3 Substance 4 Quicktoois DelRow Buiatree ae o 7 8 9 Component Measured Mass per Quantity No Item cter 100 Character 100 Character 200 range 0 X 1000000 range 0 lt X 10000 precision 0 000001 precision 0 oo CA 5 17242 emk Ass 1 1 CA 5 1124 A aleRA2sa23 das si AAA A Error Infornation Return Ivarningl No entry of Component No Errors pop up if the sheet has errors E L D E F G H Error Information Return 1 2 R22C6 error The name of MDS is blank RZZCa lrarning No entry of Component No EO IE 3 0 IE HE 4 2 Export CSV File Format 4 2 1 Supplier Information Supplier Information is the identification of suppliers One or more lines below supplier identification shall be the relevant information about the supplier 4 2 2 Recipient Information Recipient Data is the identification of recipients The detailed information of the line below recipient identification and the fields correspond to the MDS data respectively 4 2 3 MDS Information Ingredients are the identification of MDS One or mo
15. type is Weight weight field 1s assigned value 3 3 3 Add material into the component section Information about Name Material No and Material Classification of material child node should be added in the section of Material Information about node constitute type of material should be added under the section of Node constitute Material T Frame Supplier Material No Remark Trade Name Name Classification code Symbol Norm Standard Test Test Report No No Character 30 Character 120 Character 120 Character 100 Character 100 Character 500 Character 120 Character 30 Character600 Character 600 Character 50 range precis Standard Material Material Classification Standard Node section tion onstitute Weight kaa z cta Min Max Proportion LEI UTIL i precision o 000001 Fed precision 0 000001 Go FMN Rest3 Proportion When Node constitute type is Weight Marked as 2 and weight cell is assigned value ID cell can not be filled in manually To introduce standard material click the button of Standard material to get result through search conditions If it is self built material then ID cell is empty and material names and types can be filled in When directly or indirectly adding material of 5 1 x 5 4 x or 5 5 1 type that is over 100 g or adding materials of 5 2 or 5 3 type that is over 200g into component section polymeric p
16. 05 19 11 25 Received 33 1221 123 CA 5 17252 0 01 recycle of viecle 2011 01 05 17 12 13 PPP x 34 DA 123 CA_5_17251 0 01 recycle of viede 2011 01 05 17 00 31 Classification Analysis Recovery an doa 35 1221 123 CA_5_17249 0 01 recycle of viecle 2011 01 05 16 47 42 Analysis 36 454 A 5 17244 0 01 recycle of viecle 2011 01 05 14 49 20 Management gt 37 ER 234 CA 5 17242 1 00 recycle of viecle 2011 01 05 14 18 52 Ui MDS Request gt 38 3451 234 CA 5 17229 0 01 recycle of viecle 2011 01 04 15 24 49 acres gt 39 Tap CA 5 17228 CA 5 17228 0 01 recycle of viecle 2011 01 04 14 06 44 ER CA 5 17224 CA 5 17224 0 01 recycle of viecle 2011 01 04 11 12 35 Check one or more check box click Download to pop up file download dialog and choose download route after Save Every CSV has a correspondent MDS which is in the Zip file 31 ant CA 5 1725 Modify E recycle of viecle PATA RRR A 32 component R 20110126163810 zip recycle of viecle 201 X WinRAR ZIP iam 1221 HE 6024758113 recycle of viecle 201 1221 HFD 277 8 recycle of viecle 201 recycle of viecle 201 recycle of viecle 201 TE ae ci 38 3451 recycle of viecle 201 30 Sap CA 5 17228 CA 5 17228 0 01 racycle of viecle 201 40 eit CA 5 17224 CA 5 17224 0 01 recycle of viecle 201 pP MDSs amp Modules Search mam vil 31 32 33 34 39 40 41 42 43
17. A gt 11 After Confirm select the successfully uploaded items There are two buttons on the right corner which are View and Delete Click View to go to MDS details dialog Main Menu Main Menu MDS Ingredients Supplier Information Recipient data Ingredients BEY cor Y G E E s 213 SQ 123 g aaa Cuprate 4 mu 3 3 3 3 di hydroxy kappa O 1 3 O 2131 3 k bbb 2 1 4 Benzenedicarboxylic acid polymer with 1 1 1 Type ID Version Supplier Article Name Article Name Foreign Component No Measured Mass per Item Calculated Mass per Item Deviation Tolerance calculated recyclability rate measured recyclability rate vetste N Component CA 5 17342 0 01 EN v 213 FR y 12312 243 ge 243 0 0 1 The selected uploaded record can be deleted after clicking the button of Delete 5 1 Check of CSV format One record takes up one line Each field must be separated with 4 Note please do not open CSV file with Excel Please open CSV file with Wordpad to check whether The embedded comma must be put in a double quotation mark like 571 The embedded double quotation mark must be separated vvith a double quotation mark and the double quotation mark in the data shall be doubled The blank space is omitted in the beginning and in the end ni Error Error The embedded line feed field shall be included in a dou
18. DARDH MO OOP OOP OOP OOP OOP DAL MA MA B R P R B R B R NHN Hn 3 3 3 3 3 3 3 3 3 3 3 3 3 3 MO MO OO IBID IBID PAPLO PAN IBID DNM MN III VP e e 52 9 jo a se Si li T So 7 4 4 0 9 1 3 4 So 4 o 3 1 1 3 0 3 3 3 3 3 3 3 3 3 3 3 1 1 e on 3 8 P B R IP IP HO SD IP HO IIA t HO IP IP N 3 3 3 3 3 3 3 1 P at PASH ee POS HN NMN VN MM PEIE IBID MA MA MA MA MOM MOM MOM MOM MOM MO MO OO OO OO OO OO OOP OOP DO III III Hn 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 af ry PAR HH HH HMB HH HH PAR BARR B R H gt a af 3 3 Py a 1 1 Pr 2 wf ME ES ke Ge Ue 2936 aj imin F 7429 90 of 231 Q72 P St 34 Or PRO BIR MP OOP PRA t PHH H a s a 3 3 3 3 3 3 3 A gr P Aa P POS POS IBID MH IBID POS HAM HAM HA HA MA MA IBID MOM MOM MO MO MO MO OO OO OO OO OOP HMG HN NHG PES HN HH III Hn 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 we pe nn we we ae we HE 2999 we UO n ve H wow O Ma H PA PEIE PEPEO HA 7 2947 Manganese tir 7439 96 5 231 105 3 3 3 3 3 3 3 3 1 t t t H MA MOM HO Ha HO S R APP O 1 a 3 3 Le be de MAP III N 3 3 3 3 3 3 3 3 3 3 st MM N ts 3 3 3 3 3 3 4 P POS POS POS POPL PON NN N MM MM MM SOD MA MA MOM MOM MOM MO MO MO OO OO OO OO OOP OOP OOP GAIL O DAIL O DN II III 3939 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 SE Note please do not alte
19. OHRA Rs fea ite BST Al HE RSA Mo ONE CETERA I MALA AAA SE E Seo AE Ree ratse SAP TTA Se SET AREA LI AE RE 3 1 2 Macro security setting of Excel 2007 After entering into Excel click Macro Security in the Developer tab and choose Enable all Marcos Wie TESS At ME EE WE AFATE m n Rae Y MA TES gt PHB CASA 7 iis iss N aj Qi SSE Shi Ee a os mu ar Po II II fus oe EE EER arse ee a FEES ESEE E23 ee EFE KRAS a ActiveX ER ZAREZ HEUERID Pla B c O HAS 1 rae St RAMBANES DIESE SETE al se TRAREEE 4 3 MDSf 8 GAMES 5 ARS 1 SE VBA TENER 6 sn SRA e 3 2 Editor Excel sheet entring procedures ZI Enter information about Supplier Recipient field Click the first button of in the left column to extend or hide Supplier Recipient field Check Import Export 1 Supplier Informatiga Del Row 2 Recipient data Pa WES SES Drawing re Purchase Bill of Del Row Supplier Code IDS code No Nam Drawing No Change Report No ardor MO hei Report date 3 Ingredients Item No 1 2 3 4 5 6 7 8 9 10 11 Item Group Component section y tem name em mwe m tame Frame sunnier AS Remark Mom CO The MDS level is Component1 Character 30 Character 100 Character 100 Character 100 Character 100 Character 200 range 0 lt X 1000000 rang
20. arc ac cn R nien Data Ingredients cs i 17 1 CA 5 16618 APE id 20101201 KARA 3244223332 1000 BARRIOS 1018 1 8 Oy GO 2010 12 07 12 00 00 2010 14 07 12 00 00 2010 12 07 3 19 t HIO HH Pd wy 80 49 wy MA POS POS IBID III 3939 ve PAP PROP IBID S R PAR POP t t n MAP POS POS POS POS POS DADL O DADO IPIP NN 339 N 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 Mer p t MO MOT POP POP PROP HN NN 1 17 1 CA 5 15982 SEBO ceshi 0816 1 CATARC REAL 35232539 1017 3 100 0 9901 10 0 0 QO 2010 11 19 12 00 00 2010 11 19 12 00 00 2010 11 19 12 na PAIE Me PEOD HA HA HR HE HR HE HE RR HE RE HE HE EE HR HE HE RE RE HE HE HE HE HE HE HE HA HE HE HA H 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 t t t P BOR PRA T POS POS POS POP t t 3 3 3 3 3 3 3 3 3 i 1 P B J HA HO HA HA HA HA HA HAM HAM MM MOM MA MA MOM MO MO MO MO OO OO OO OOP OOP a a a er NHN 3937 TA 8 37077 a 3 EE 12 III CANDSET R R MP eo wn vn 11 we IS S H2102 o 00 100 9010 gt 01 99 12 00 00 9010 01 28 12 00 00 o010 01 99 12 00 00 ee af ja Ha ae af me wer sie sige ge 100 i af dd MAP PFS 3 i E 1 H n So MAP PEIL B R B R HO IBID HA HA HAM PRSH MOM MOM MOM MO MO MO
21. art should be marked as Yes Name e Deaton Tone Calculate Calculate 3 3 4 Add semi component into the semi component section Add Name Semi component No of semi componet child node in the section of Semi component And choose Proportion marked as 3 in Node constitute type Application Constitute Type Weight Proportion Type Max Proportion Character Weight 2 range 0 X 1000000 Range 1 range 0 x 100 range 0 x 100 range 0 x 100 Proportion 3 precision 0 000001 Fixed 2 precision 0 000001 precision 0 000001 precision 0 000001 Rests There are 3 types of proportions Range marked as 1 Fixed marked as 2 and Rest marked as 3 When Range is chosen the cells of max and min values should be assigned value When Fixed is chosen fixed value cell should be assigned value No value assigned when Rest is chosen Confidential Application Constitute Type Weight Proportion Type Min Proportion Max Proportion Character Weight 2 range 0 X 1000000 Range 1 range 0 lt X 100 range02X 100 range 0 lt X 100 Proportion 3 precision 0 000001 Fixed 2 precision 0 000001 precision 0 000001 precision 0 000001 3 3 5 Add material into the semi component section Information about Name Material No and Classification of material child node can be added in the section of Material Node constitute information of material sho
22. as required The self built materials in CAMDS interface tool will be released automatically in the system after being uploaded and become independent MDS As self build ones component and semi component are still independent MDS after being uploaded item Group rial secti i i i Character 100 Character 200 YYYY MM DD YYYY MM DD YYYY MM DD Character 30 Character 120 Character 120 Character 100 Character 100 C hh mm ss hh mm ss hh mm ss Item note Quicktools Del Row Standard Material IKE IN IE EIE EI EE O He rg E A A A HE selfbuitlmateria lt n i 28 OI whnodD TT TT N TT Check Ingredients after the exported file is uploaded Fa BB T caps G Es Es g 213 ag 123 O h aaa Heptachlorofluoropropane sd 321 a h bbb A Molybdenum bis ditridecylcarbamodithioato di r 1 mT F Type ID Version Supplier Article Name Article Name Foreign Component No Measured Mass per Item Calculated Mass per Item Deviation Polymeric part s marked Component CA 5 17347 0 01 M recycle of viecle EN 213 FR 466 mg 466 0 t Yes Parts marked as required on drawing e No Parts not marked as required Not Applicable Parts do not require marking due to Fillin Organization and Name in Supplier information before clicking Next supplier information MDS status Edit mode Ingredients Supplier Informat
23. ble quotation mark the data in CSV file is damaged or not How to check Right click CSV and operate as the following screen to check CSV file CSV file ER CA 5 16438 csv 2010 12 29 10 34 Microsoft Office 33 KB ER eo csv BEE 11 52 Microsoft Office 6 KB Microsoft Office Microsoft Office EditPlus 3 HARI EA 360725 HE le Microsoft Office Excel 25H AMES ELA E gt el BEF rar T REMO HH E mail ER BE rar E mail BioExcess WRLABTATRAR V BESIN 20m ERC A REAS D a M EIER Example normal CSV file a EEU cv EF LEES IF FRE TO SEM KShH suppli ierlnformation Da a ws Ze ol WAR CA 3 40387 7 ARTE BEEK O10 67832387 010 67832388 kangyifeifcatarc ac cn OAR ged Ingredients yk gji Ng CA 5 16618 abt MA 20101201 11 ao Vd FA 3244223332 1000 1018 1 87 6 60 80 0 2010 12 07 12 00 00 2010 12 07 112 00 00 2010 12 07 12 Pra MO PROP B R IPID IBID PRSH PRSH OOP DER IBID IPIP GOILO PRSH PRSH POP S R PEIRO GOIR GOILO GOIR GOILO DOIDO GOILO GAIRO B R B R PAR PAS PES O DAN MA HN PROP H 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 tt tt we MM Pitt HO POP OOP PDIP 3939 3 i ia I CA 5 15932 EE ceshi 0816 1 Lt CATARC Sh 35232532
24. e 0 lt X 1000000 ran lemaal not allowed to Semi Component 2 precision 0 000001 precision 0 pre exceed twenty Material 3 am Oiibhatanan Entry rules are as follows Time Y Y Y Y MM DD its 50 l digits 60 digits 40 Text digits 40 1ts 20 l its 20 l its 20 l phhmmss OOO Drawing Change level Text digits 20 Text digits 20 Time Y Y Y Y MM DD Optional hh mm ss 3 2 2 Enter MDS types and level Qn Ed AE CAMDSH SISA RUE ig V2 3 xls EES Microsoft Excel E X St er a Ala BERG E 7 z ii Y BAKR A A a Al Jea Baule A eS AE BR E FA SHA BF Ex rit RE D31 7 A 1 1 2 A B Check 25 3 Ingredients 26 Item No 27 Item Group Component Measured Mass per l f 28 Item name FRName Supplier No Remark ese Quantity twa me o name Frame The MDS level is Component1 Character 30 Character 100 Character 100 Character 100 Character 100 Character 200 range 0 X 1000000 range 0 lt x lt 1000000 not allowed to Semi Component 2 precision 0 000001 precision 0 exceed twenty Material 3 Substance 4 20 Quick tools Del Row Build Tree WIN Item note Choose Type cell first to identify node as Component Marked as 1 Semi Component Marked as 2 Material Marked as 3 or Substance Marked as 4 Then click the button of Build Tree to create Level
25. ection 3 Ingredients p r prij M 48 49 50 51 52 53 54 55 56 Item Group FAA Faj 2 section Item name ecindex Index synonym conndentia Application Constitute Constitute Type weight Proportion Proportion Type Proportion Character 20 Character 300 bal 1 Character 2 Weight 2 range 0 X 1000000 Range 1 range 0 lt X 100 range 0 X 100 range 0 lt xX 100 Proportion 3 precision 0 000001 Fixed 2 precision 0 000001 precision 0 000001 precision 0 00000 Item note EE es 3 Quick tools Del vo Application Entry rules Constitute Type Choose Weight Required Proportion Weight 2 Proportion 3 Weight Range 0 lt X lt 1000000 Required when Precision 0 000001 choose Weight Proportion Type Choose Range Fixed or Rest Required when choose Proportion Range 1 Fixed 2 Re st 3 Fixed proportion Range 0 lt X 5 100 Required when choose Fixed Precision 0 000001 Minimum proportion Range 0 X 100 Required when choose Range Precision 0 000001 Maximum proportion Range 0 lt X 5 100 Required when choose Range Precision 0 000001 Enter information about Semi component Material and Basic substance constitute type in Node Section 3 2 4 Page Layout 1 Del Row operation While entering Excel if there is a row of error entry choose the row number in the front and click the button of Del Row to delete the error
26. eidcatarc ac cn aca aa AS TT em mm Character 30 Semi Component 2 Es exceed twenty Material 3 Substance 4 JAPIA prompt CSV import succeeded p Component Measured Mass per Quantity No Item ci A Character 100 Character 200 range 0 lt X 1000000 range 0 X 100000 precision 0 000001 precision 0 Build Tree 1 CA siria recycle of 234 d5 1 1 hi CA SB 172411 Nr recycle of 234123 Ja EE O ESC EN o IESO IEA 8 Conclusion CAMDS interface tool developed by CATARC it will be updated in a timely manner according to regulations and CAMDS updates Appendixes I All the required items must be filled in Error The node checking rules shall be met Error All the numeric fields shall be number and meet the corresponding F rror requirement of range and Precision level The nodes on the same level in a MDS tree shall be of the same type 2 l 3 i Error Components and semi components can not be at the same level It is not allowed to introduce MDSs component semi component material or basic substance with the same ID under one node The sum of the content of confidential substance and wildcard substance cannot exceed 10 of the total material The sum of the maximum cannot Error exceed10 of the total material The sum of the child node proportion shall be 100 When child node proportion is filled in with a range the sum of the average of the range sha
27. ete the selected rows 14 3 Ingredients 15 Item No 1 2 3 4 5 6 7 8 9 10 16 Item Group system section JEomponent section to choose Item name Level FRName EOS gomas ql Quantity 17 Item Character 100 twe tame The MDS level is Component1 Character 30 Character 100 Character 100 it t not allowed to Semi Component 2 oni exceed twenty Material 3 18 Substance 4 19 Quick tools Del Row Build Tree 1 A a E EE ENE EE FEE TEE EES EES HEES HEI press Ctrl Daa ig tp _ MEE EE ANOS EE Ce row mmber f J NN ARANA 2 Add Standard Material If node type 1s chosen as material click Standard Material to add con Remark Character 100 Character200 range 0 X 1000000 range 0 X 1000000 precision 0 000001 precision 0 4 _ a E _ A Ged A a Bi a e REK ra Ed ag FAR TE aar Pt a n y B ZU I FI A IE Please click the search button after the entry of search condition Bik E A Material ID Classification 4G25 v ENName CNName De a E Material code Symbol Horm Standard 1 2 Check 3 14 3 Ingredients 15 Item No 16 Item Group Item name Character 30 Item note 18 a Y 19 Quick tools Del Row E andard veters 20 ENE AE 21 NEE EE 22 NEE EE 23 EEN dl 24 Sees EI 26 27 OE 28 Be E 29 EEN EE 30 4 Details Confirm There are 6 search conditions such as Material ID Classification ENName
28. he section of Component a QE FRName Supplier Component Measured Mass per Quantity Calculated Mass Deviation No Item per Item Es Character 100 Character 100 Character 100 Character200 JOOVE vooor z EE ane a Calculate Calculate All information about component node is filled in the section of Component Calculated Mass per Item is obtained by clicking the button of Calculation below Measured mass per Item of the node component can be added manually Calculation deviation of component can be obtained by clicking the button of Calculation under Deviation Fill in Tolerance manually which should not be less than the calculated Deviation 3 3 2 Add semi component into the component section 99 Information about Name and Semi component No of semi component child node should be added in the section of Semi component Information about node constitute of semi component should be added to the section of Node constitute 3 Ingredients Item No 18 19 23 24 25 26 Item Group Item name Release date e al Creation date Check date Release date Character 30 Character 100 Character 100 Character 100 Character 100 Character 200 YYYY MM DD YYYY MM DD YYYY MM DD hh mm ss hh mm ss hh mm ss Item note Quick tools Del Row precision o 000001 Fixed Rest3 AO EE ed MN eg rd Pda When node constitute
29. he system material The upload check rules include check rules of the on line system S No 1 designated validation rule of CIEsystem No 4 errors that can be captured and caused by altering of CSV No 2 3 5 10 and rules about uploading in the Design Document of CIE 5 2 1 Node ID of MDS If ID of MDS is existed it will be regarded as the MDS already existed in the system the only work is to judge its type and whether it matches with ID If it matches information about MDS s child node will be quoted directly without checking its correctness After successful uploading the page 1s showed as below Upload MDS CSV File Time File Name Status MI 2011 01 26 15 55 21 Be tH cov Success CA_5 17344 AMMES 2011 01 26 15 55 05 Bete cov Success CA 5 17343 2011 01 26 15 52 48 111111111 sv Success CA 5 17342 A Upload successfully 2011 01 14 14 50 43 111111111 05 Success CA 5 17297 2011 01 14 14 43 48 111111111 csv Success CA 5 17296 2011 01 14 14 42 59 111111111 csv Success CA 5 17295 2011 01 14 14 41 17 111111111 05 Success CA 5 17294 2011 01 14 14 41 01 111111111 csv Failure Root node ID of MDS in the upload CSV should not be the ID already existed in the system The download CSV can not be regarded as root node to be imported into CAMDS interface tool and then uploaded into the system directly 5 2 2 ID information about the user ID of the upload CSV must belong to MDS list of the user s organization that is to say
30. ick Open CSV file is imported into CAMDS interface tool 1 2 10 System section pie Component Measured Mass per Quantity No Item The MDS level is Component1 Character 30 acter ad Character 100 Character 200 range 0 lt X lt 1000000 range 0 lt X 10 not allowed to Semi Component 2 precision 0 000001 precision 0 exceed twenty Material 3 Build Tree Ele OS E tf O EN A TP 1 2 AAA ASA 1 3 E NN EN N N N N Laci RAE recycle of 234 Y titi CA 5 17241118 MPR Mi recycle of 234123 1 1 1 1 1 1 EA Kl A LILLE A id did EE 1 1 1 1 1 4 ENE 1 1 1 1 1 5 MEE The imported CSV root node becomes the child node of node 1 1 and the tree structure is as follows Node Name 1 1 gamma Butyrolactone 1 2 Acrylic resin jconfirm i 1 1 1 1 3 polytetrafluoroethylene 1 1 1 4 Glyeol cancel LY QExtend A Contract 7 2 No data in the sheet Click Import to pop up browsing box directly x AFA QO AE user Desktop rr ov SEE E i 0 3 El BIJAVE lt za seri ER CA 5 17242 csv 2011 1 26 16 38 Microsoft we Characte EG isj EF E sie d ER EE EE ae EEN E ee Im em dT N ER po teNovo 03 E FT g saam Coo Em TRU Select CSV to be imported click Open CSV is imported into CAMDS interface tool Import Export seal SHA 3 4038 RE 010 6783231010 678323lkanevi f
31. ion E Enterprise Name recycle of viecle Recipient data Organization zhizaobu X DUNS No Address KARTE Country China MDS Creator MDS gt gt supplier data BE 010 67832387 MDS Contact person 010 67832388 Name REX Tel No 010 67832387 Fax No 010 67832388 E mail kangyifei catarc ac cn kanagyifei catarc ac cn Assign value to Enterprise information after choosing Add recipients You Have tomotive Material Data System recipient status MDS status Edit mode Enterprise information Supplier code 32 o E component Material CAMDS management committee No assigned by the IWEQW customer Add recipients Name REM Drawing No Copyright c China Year four digits Month two digits Day two Drawing date digits Drawing Change Level Report No Year four digits Month two digits Day two Report date Purchase order No 6 Sheet Download Methods and notes 6 1 Analysis on the download page Users authorized by CATARC have the authority to download The search result will be shown on the search page of MDSs amp Modules Search Only the integral version of MDS has check box Search gt gt MDS Search results MDSs amp Modules Search Descending order by Creation date DownLoad ve Sent 32 component CA_5_17253 0 01 of viecle 2011 01
32. ll be 100 The deviation between the measured value and the calculated value cannot Error Error exceed the tolerance In a MDS tree on the same level Only one semi component one material or Error one basic substance could fillin Rest in proportion When introducing material of 5 1 x 5 4 x or 5 5 1 type that is over 100 g or introducing materials of 5 2 or 5 3 type that is over 200g into a component no Error entry of polymer mark for the component An application must be selected for the material When 1 a material containing Nullable restricted substance is introduced into a component 2 a e l Error material containing Nullable restricted substance is introduced into a semi component then the semi component is introduced into a component Non basic substance must be further decomposed The lowest level of a MDS F rror must be basic substance When introducing material of 5 1 x 5 4 x or 5 5 1 type that is over 100 g or pd GUY introducing materials of 5 2 or 5 3 type that is over 200g into a component Warning the polymer mark is No The content of basic substance in a self built material by a user exceeds the control limit Proportion X Y Maximum Value M Y X O lt X lt 7 5 M lt 3 37 5 lt X lt 20 M lt 5 20 lt X lt 100 M lt 10 D Warning When introducing a material into a semi component the range of proportion U
33. me FRwame Supplier Material wo Remark Trade name Classification quer Nom Stander YYYY MM DD YYYY MM DD JCharacter 30 Character 120 Character 120 Character 100 Character 100 Character 500 Character 120 Character 30 Character 600 Character 600 tem note hh mm ss hh mm ss Quick tools Del Row Standard Material Classification Standard Entry rules Text digits 120 Text digits 120 6 Fem TE A Classification Text te diets 30 Required Choose by clicking A button of Classification Material Code Symbol Text digits 600 Optional JI Norm Standard Text digits 600 Click the button of Norm ae ma ooo Test Report No Text digits 50 Optional 12 Creation Check and Time YY Y Y MM DD Optional Release date hh mm ss 4 Enter information about Basic Substance field in Substance Section 3 Ingredients Item No Item Group E o Item name Release date YYYY MM DD Chao 30 Character 480 Character 200 Character 20 af Character 30 Character 20 Character 300 er Character 2 Weight2 JI 2 tem note p Proportion 3 e Quick tools Del Row Basic Substance Application saj Entry rules Text digits 30 Required and obtained by clicking Basic substance button Application Text digits 2 Required when Root node is component and needs to be added Obtained by clicking Application button 5 Enter information about Node field in Node S
34. n for the material exceeds the permissible range the range of the maximum share of material shall meet the following rule 0 lt X lt 100 M lt 20 The nodes on the same level in a MDS tree shall be of the same type Warning ON Components could be positioned as the same level as materials or Warning semi components and materials can be at the same level Appendixes Il The node of the same level has already existed The parent node doesn t exist NEER Ee NN
35. onfiguration is required to handle CAMDS interface tool CPU Pentium II 350MHz or more Memory 512 MB or above HDD Volume 100MB OS Windows XP or above Excel Excel 2003 or above Information when the PC configuration is unsatisfying and the memory space is scarce PC performance slows down 3 Illustration of Excel Input Procedures and Notes 3 1 Preparation of Editor Excel sheet CAMDS interface tool sets up security function and needs password to visit 3 1 1 Macro security setting of Excel 2003 The follovving message appears after opening into Editor Excel sheet C Documents and Settingskzg ER SASheet PI xls P S 5 Al Aet ferh AA IKE ie Bi Rae a EEA NE eam T Click Enable Macro button to enter into the Sheet Macro security Click Tools menu to choose security level Ki Microsoft Excel SASheet H4 e EE R WE BAD ta IED AE Cs BAM SH PA FEES ES ii MB ea GY ARKE MUCliek E sey ee a Ae 71 HS THEE DI B HST HERE CB i A E F E H I RAP E 1 2 ESBLEME MI e F 3 ABE ON 14 C3 MDSEH is as 16 Fi Bes E a FARER r me sa MEM 0 THREE Lu ND JE A cee ear me S Visual Basic MERO Altii F FE ei Microsoft Plasmas WW Alttshifttril Security dialog box pops up Check the level of medium as the following KYU PP BPS CT CO HEB Ee AJET Se Sai BERIG RAM TUS SS AMA WE e Om an KIT A SERGE Rae B
36. r the information in CSV file 5 2 Uploading rule check Error in the check of the field data format Please do not alter the field information of the CSV directly Unified error reporting of rules in Error in the upload information Please CAMDS interface tool apart from the do not alter the field information of the errors caused by the online rules and CSV directly characters Errors occur when the basic substance The basic substance which are defined as which are defined as D P D P in D P D P in GADSL as well as the GADSL as well as the basic substances basic substance whose CAS No are whose CAS No are System are selected system can not be selected as as Confidential substance confidential substance MDS contains deleted or non existed Error in the referenced MDS MDS or MDS ID of uploaded CSV is not in the enterprises no content no Supplier Error in the format of CSV file Information no Recipient Data and no MDS information No MDS information in the upload CSV The root of MDS in the upload CSV is the The root of the MDS in the upload CSV existing MDS in the system can not be the existing MDS in the system ID of the basic substance does not exist The basic substance does not exist ID of the material classification does not The material classification does not exist exist 11 The Norms Standards of the material do Error in the Norms Standards of the not exist in t
37. re lines belovv MDS identification shall be the detailed information of the MDS data put in order according to the level of nodes The fields shall correspond to the MDS data For specific information please refer to 2 2 3 Excel File Format WZ BEE HO BBV BBH H SupplierInformation ZE OHI CA 3 4038 ALONE RE K 010 67832387 O10 67832388 kangyifei catarc ac cn SB CA 5 16578 DY Ht sju aes ie ps st E ij of gs st K 5 16578 EE CA 5 16578 t t P S VRA Pt eae 20000 III 10000 50 65 Q de ue 9010 19 06 12 00 00 ft 3 192 06 12 00 00 tt pese MAP B R OP B R OPROEP PP MA S R B R MA OPE PP MAP PIR tit wy we PAP III enw at tt wen we Pt Pn wn we B R B R B R S R B R a PP OP Yon age T5 CA 5 16579 y DE CA 5 16579 yeu hy Ale yeu Yew 10007 o 1000 0 0 GE is id 901 0 12 06 12 0 0 won Be une we ke UR HARARE HA va an 2020 vo S nH ba wa na ne 2929 Me he HE HR Me ne he 2090 nu 2929 Me E 9929 1929 2020 2090 2090 2024 1 1 as qe CA 5 16438 R id Fe od EE EKAA 3244223332 mo 1000 Q i m 3 as a 60 20 od O010 12 00 00 2010 12 07 12 00 ER HA HE HE HE HE HE HE HE HE HE HE HE HE HE HE HE HE HE HE HE HE HE HA ae af n an AAIE PEIE HRALO PAIE DAIRO t t ae ie IP D SH PES t t mi is 1 1 k CA 5 15932
38. uired Precision 0 000001 Quantity Range 0 lt X lt 1000000 Required when Precision 0 Component is child node Calculated Mass per Item Range 0 lt X lt 1000000 Obtain by clicking Precision 0 000001 the following button of Calculation 10 Deviation Precision 0 000001 Obtain by clicking Calculation button Precision 0 000001 12 Polymeric part marked Choose Yes No or Required 1 Yes 2 Inapplicable No 3 Not Applicable when the material types and mass requirements are met 13 Creation Check and Release Time YY YY MM DD Optional date hh mm ss 2 Enter information about Semi component field in Semi Component Section 3 Ingredients Item No dT 18 19 20 21 22 23 24 25 26 tem Group EE EE EE SE NG GE REDE RE YYYY MM DD Character 30 Character 100 Character 100 Character 100 Character 100 Character 200 JYYYY MM DD hh mm ss hh mm ss Item note ne eg ee A A A EA AAA YYYY MM DD YYYY MM DD hh mm ss hh mm ss Quick tools Del Row item name Release date Entry rules to Text digits 30 Optional Optional Text digits 100 Optional Text digits 200 Optional Creation Check and Time YY Y Y MM DD Optional Release date hh mm ss 3 Enter information about Material field in Material section 3 Ingreaients Item No 25 26 27 28 29 30 31 32 33 34 35 36 Item Group Material section tem name Check date Release date to Na
39. uld be added in Node constitute Node constitute type 1s chosen as Proportion with 3 types available 3 3 6 Add material into the material section Same as the above 3 3 7 Add basic substance into the material section Basic substance of child node must be searched by clicking Basic substance in Basic substance section The result can be obtained and selected by inputting search conditions Correspondent field of basic substance can be assigned value to correspondent cell Node constitute type is chosen as Proportion with 3 types available Each and every basic substance needs to be selected as confidential substance or not Yes marked as 1 No marked as 0 Substance a YE ENName CNName CAS No GADSL EU Index EC Index Synonym Comtuentia Application ae Chararter 480 Character 200 Character 20 N aa Character 20 Character 300 Yes 1 Character 3 3 8 Information about Suppliers It is optional and based on the enterprises that own the login ID after being uploaded 1 Supplier Informati 3 3 9 Information about Recipients 2 Recipient data Recipients information will be shown in Enterprise information after being uploaded It can be seen after introducing recipients information Note only the first recipient s information record can be uploaded 1 Supplier Informatio OO AO 0 HIE pr e O iy A H p po p O pa 2 Recipient data he pas
Download Pdf Manuals
Related Search