{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["QS-702C HAWA OCP-Trading Goods"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":189,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"QS-702C HAWA OCP-Trading Goods","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[2,1,2,8],[4,1,4,9]]}
[]
[]
[null,"MATERIAL CREATION AND MAINTENANCE FORM: Trading Goods (purchased FP) OCP to be handled by BU",null,null,null,null,null,null,null,"HAWA"]
[null,"View","Technical Field","J-Sox Relevant","Impact on EWM","Mandatory","NHS -RIMS - MDR","Data Owner","Field Description","Value"]
[null,"Initial and Basic Data"]
[null,"Initial Screen","MARA.MATNR","x",null,"X","X","Product Developer","Material Number (Max 18 char and based on suppliers code)","TEST","TEST1","TEST2","TEST3","TEST4"]
[null,"Classification - Material","Z_001_HAWA.Z_CE",null,null,"X",null,"RA Officer","CE mark","YES","YES","YES","YES","YES"]
[null,"Classification - Material","Z_001_HAWA.Z_GS1_EAN",null,null,"X",null,"MDG Specialist","GS1-EAN Code (= EAN code with 0) only last 13 char to enter","123456789","123456789","123456789","123456789","123456789"]
[null,"Classification - Material","Z_001_HAWA.Z_LEGAL_MANUF",null,null,"X","X","RA Officer","Legal Manufacturer","T0083 - Terumo BCT, Inc.","T0083 - Terumo BCT, Inc.","T0083 - Terumo BCT, Inc.","T0083 - Terumo BCT, Inc.","T0083 - Terumo BCT, Inc."]
[null,"Classification - Material","Z_001_HAWA.Z_REACH_FLAG",null,null,"X","X","RA Officer","REACH-flag 'SVHC present >0,1% (w/w)'","Y1","Y1","Y1","Y1","Y1"]
[null,"Classification - Material","Z_001_HAWA.Z_REACH_SUBSTANCE",null,null,{"$f":"IF(J10=\"Y1\",\"X\",\" \")","v":"X"},"X","RA Officer","REACH-SVHC Substance","DEHP – CAS No. 117-81-7","DEHP – CAS No. 117-81-7","DEHP – CAS No. 117-81-7","DEHP – CAS No. 117-81-7","DEHP – CAS No. 117-81-7"]
[null,"Classification - Material","Z_001_HAWA.Z_SPARE",null,null,"X",null,"RA Officer","Spare part","YES","YES","YES","YES","YES"]
[null,"Classification - Material","Z_001_HAWA.Z_STER",null,null,"X","X","RA Officer","Sterile","YES","YES","YES","YES","YES"]
[null,"Classification - Material","Z_001_HAWA.Z_AXEL-G_ITEMCLASS-VALUE",null,null,"X",null,"MDG Specialist","Item Value Class (Axel G-> based on input from TC)"]
[null,"Classification - Material","Z_001_HAWA.Z_PRODUCT_DEVELOPER",null,null,"X",null,"MDG Specialist","Product Developper (who requested material)"]
[null,"Classification - Material","Z_001_HAWA.Z_MRP_CONTROLLER",null,null,"X",null,"MDG Specialist","MRP Controller (who is the Inventory planning contact person)"]
[null,"Classification - Material","Z_001_HAWA.Z_LPP_FR",null,null,null,null,"Sales Branch","LPP code (+ text) for France (for reimbursable products in France)"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_1",null,null,"X",null,"RA Officer","DG Equipment battery 1 - nomenclature","No Batteries","No Batteries","No Batteries","No Batteries","No Batteries"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_1_QTY",null,null,{"$f":"IF(J18=\"No Batteries\",\" \",\"X\")","v":" "},null,"RA Officer","DG Equipment battery 1 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_1_WEIGHT",null,null,{"$f":"IF(J18=\"No Batteries\",\" \",\"X\")","v":" "},null,"RA Officer","DG Equipment battery 1 - weight"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_2",null,null,{"$f":"IF(ISBLANK(J21),\"\",\"X\")","v":""},null,"RA Officer","DG Equipment battery 2 - nomenclature"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_2_QTY",null,null,{"$f":"F21","v":""},null,"RA Officer","DG Equipment battery 2 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_2_WEIGHT",null,null,{"$f":"F21","v":""},null,"RA Officer","DG Equipment battery 2 - weight "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_3",null,null,{"$f":"IF(ISBLANK(J24),\"\",\"X\")","v":""},null,"RA Officer","DG Equipment battery 3 - nomenclature"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_3_QTY",null,null,{"$f":"F24","v":""},null,"RA Officer","DG Equipment battery 3 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_3_WEIGHT",null,null,{"$f":"F24","v":""},null,"RA Officer","DG Equipment battery 3 - weight "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_4",null,null,{"$f":"IF(ISBLANK(J27),\"\",\"X\")","v":""},null,"RA Officer","DG Equipment battery 4 - nomenclature"]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_4_QTY",null,null,{"$f":"F27","v":""},null,"RA Officer","DG Equipment battery 4 - qty "]
[null,"Classification - Material","Z_001_HAWA.Z_DG_BAT_4_WEIGHT",null,null,{"$f":"F27","v":""},null,"RA Officer","DG Equipment battery 4 - weight "]
[null,"Classification - Material","Z_001_HAWA.Z_LEGACY_TETRA_MMITCL",null,null,"X",null,"C&V Officer","Legacy Interface TETRA - Product Group"]
[null,"Classification - Material","Z_001_HAWA.Z_FDA",null,null,"X",null,"RA Officer","FDA related material","NO","NO","NO","NO","NO"]
[null,"Classification - Material","Z_001_HAWA.Z_DUAL_USE",null,null,"X",null,"RA Officer","Dual Use (Reg. No. 428/2009)","YES","YES","YES","YES","YES"]
[null,"Classification - Material","Z_001_HAWA.Z_DUAL_USE_CODE",null,null,{"$f":"IF(J32=\"YES\",\"X\",\" \")","v":"X"},null,"RA Officer","Dual Use Code"]
[null,"Classification - Material","Z_001_HAWA.Z_CHEM_SUBST",null,null,"X",null,"RA Officer","Hazardous Chemical (Reg. No. 649/2012)","YES","YES","YES","YES","YES"]
[null,"Classification - Material","Z_001_HAWA.Z_CHEM_SUBST_CODE",null,null,{"$f":"IF(J34=\"YES\",\"X\",\" \")","v":"X"},null,"RA Officer","Hazardous Chemical CAS number"]
[null,"Classification - Material","Z_001_HAWA.Z_PERC_US_COMP",null,null,"X",null,"Product Developer","How many % of US components contains the material (related to standard price)?"]
[null,"Classification - Material","Z_001_HAWA.Z_EQUIPMENT",null,null,"X",null,"RA Officer","Equipment material (Is the material an equipment?)","YES","YES","YES","YES","YES"]
[null,"Classification - Material","Z_001_HAWA.Z_BCP_RELEVANT",null,null,"X",null,"MRP Planner","BCP Relevant","YES","YES","YES","YES","YES"]
[null,"Classification - Batch (if batch managed)","Z_023_FERT.BATCH_NR_DER",null,null,"X",null,"RA Officer","Batch class (with or without Expiry Date: HAWA/HAWA2 or HAWA3)","HAWA - Lotnummer +  Expiry Date","HAWA - Lotnummer +  Expiry Date","HAWA - Lotnummer +  Expiry Date","HAWA - Lotnummer +  Expiry Date","HAWA - Lotnummer +  Expiry Date"]
[null,"Classification - Batch (if batch managed)","Z_023_HAWA*.ZCMN",null,null,"X",null,"MDG Specialist","CMN WBS Mandatory","NO","NO","NO","NO","NO"]
[null,"NHS - UDI-MDR Specific material information"]
[null,"Product Classification",null,null,null,"x","X","RA Officer","Medical Device Class (EU)","IIa","IIa","IIa","IIa","IIa"]
[null,"Product Classification",null,null,null,"x","X","RA Officer","Implanted Material","YES","YES","YES","YES","YES"]
[null,"Product Classification",null,null,null,null,"X","UK Tender","NHS eClass (Medical Device Classification of National Health Security UK)","4532453245","4532453245","4532453245","4532453245","4532453245"]
[null,"Product Classification",null,null,null,"x","X","RA Officer","GMDN (Global Medical Device Nomenclature) Code","45345345354","45345345354","45345345354","45345345354","45345345354"]
[null,"Product Classification",null,null,null,"x","X","RA Officer","UNSPSC (United Nations Standard Products and Services Code) Code","876786373753","876786373753","876786373753","876786373753","876786373753"]
[null,"Patient Traceability",null,null,null,null,"X","RA Officer","Serial Number Location","Serial number is on the trade item","Serial number is on the trade item","Serial number is on the trade item","Serial number is on the trade item","Serial number is on the trade item"]
[null,"Patient Traceability",null,null,null,"x","X","RA Officer","Control date on packaging (Expiration, manufacturing, …)","Manufacturing Date","Manufacturing Date","Manufacturing Date","Manufacturing Date","Manufacturing Date"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Device required to be labeled as containing natural rubber latex or dry natural rubber?","YES","YES","YES","YES","YES"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Device labeled as \"Not made with natural rubber latex\"?","YES","YES","YES","YES","YES"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Human Cell, Tissue or Cellular or Tissue-Based Product (HCT/P)","YES","YES","YES","YES","YES"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Labeled for presence of Phthalates (eg DEHP)","YES","YES","YES","YES","YES"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","MRI Compatibility (See comment for more explanation)","MRI_SAFE","MRI_SAFE","MRI_SAFE","MRI_SAFE","MRI_SAFE"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Sterilization Method","Ethylene oxide (ETO)","Ethylene oxide (ETO)","Ethylene oxide (ETO)","Ethylene oxide (ETO)","Ethylene oxide (ETO)"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Manufacturer Declared Reuse (See comment for more explanation)","REUSABLE","REUSABLE","REUSABLE","REUSABLE","REUSABLE"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Sterilization prior to use by end customer","YES","YES","YES","YES","YES"]
[null,"Patient Safety",null,null,null,"x","X","RA Officer","Sterilization Method if to be done by end customer prior to use","Ethylene oxide (ETO)","Ethylene oxide (ETO)","Ethylene oxide (ETO)","Ethylene oxide (ETO)","Ethylene oxide (ETO)"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size Type (1)","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size Value (1)","8657","8657","8657","8657","8657"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size UoM (1)","Atmosphere","Atmosphere","Atmosphere","Atmosphere","Atmosphere"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size Type (2)","Balloon Diameter","Balloon Diameter","Balloon Diameter","Balloon Diameter","Balloon Diameter"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size Value (2)","25778","25778","25778","25778","25778"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size UoM (2)","Centimeter","Centimeter","Centimeter","Centimeter","Centimeter"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size Type (3)","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir","Bag Capacity Of Flexible Venous Reservoir"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size Value (3)","75285","75285","75285","75285","75285"]
[null,"Product Specification",null,null,null,"x","X","RA Officer","Clinical size UoM (3)","French","French","French","French","French"]