{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Instructions","Glossary","Summary","1-GL","2-AP","3-AR","4-TR","5-FA","6-Bud","7-Rec","8-EB","9-Payroll","10-LMS","11-EPMAS","12-EOD","13-Procurement","14-Travel","15-AM","16-NF","KEY"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":23,"comments":0,"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":"Instructions","index":0,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
["I)          General Information"]
[]
["This workbook contains Glossary, Summary  and 16 Detailed Functional and Non Function Requirement sheets."]
["Vendors are requested to respond in the format that has been provided without any modifications to the layout, content and structure."]
[]
["Glossary "]
["The Glossary sheet contains a brief explanation or expansion of abbreviations used in this document."]
[]
["II)          Functional Requirements"]
["Detailed  sheets contain functional requirements identified by OPCW per the following definitions."]
["1  -> Must have"]
["2  -> Very important"]
["3  -> Important"]
["4  -> Nice to have"]
[]
[]
["III)                Instructions"]
[]
["Summary Sheet"]
["Please enter the name of your organisation."]
[]
["The 'Summary sheet contains the total number of  functional  requirements and displays the number of cells filled in. It will update filled in number automatically."]
["If all required values are filled it will be shown as complete. If any one sheet is not complete, when you click the \"Validate \" button it will point to the unfilled cell."]
[]
["Detailed Sheets"]
["Please respond to the functional requirements by indicating a value in the ‘Vendor Response ’ column for each requirement based on the following key:"]
[]
["For Functional Requirements"]
["Y— Yes->Requirement will be met"]
["N— No->Requirement will not be provided"]
["C1— Customisation->Requirement will be met by customising existing software or through the use of software tools"]
["C2— Customisation->Requirement will be met by customising existing software as a suplementary service"]
["UD— Under Development->Requirement will be met by packaged software that is currently under development"]
["P— Planned for a future release ->Requirement is planned for a future release"]
["TH— Supplied by 3rd Party->Requirement will be met by Integration with 3rd party software package which can included in the final proposal"]
[]
["For Non  Functional Requirements"]
["Y— Yes->Requirement will be met"]
["N— No->Requirement will not be provided"]
["C1— Work-around-> Service can be provided  as part of the basic software package"]
["C2— Work-around->  Service can be provided as a suplementary service"]
["UD— Under Development-> Required service  is currently under development"]
["P— Planned for a future release ->Requirement is planned for a future release"]
["TH— Supplied by 3rd Party->Requirement will be met by Integration with 3rd party Solution/Service  which can included in the final proposal."]
["Please comment only where appropriate.  Detailed description of each module is not required.  Use mostly to clarify answer, as when functionality barely meets requirement,  “work around”, involves partner product, or core strength etc."]

{"sheet":"Glossary","index":1,"n_rows":88,"n_cols":3,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
["No","Acronym","Description"]
[1,"ADS","Active Directory Service"]
[{"$f":"A3+1","v":2},"AHU","Asset Holding Unit"]
[{"$f":"A4+1","v":3},"AMS","Application Management Service"]
[4,"AP","Accounts Payable"]
[5,"API","Application Program Interface"]
[6,"AR","Accounts Receivable"]
[7,"BI","Business Intelligence"]
[8,"BIC","Bank Identifier Code"]
[9,"CIFS","Common Internet File System"]
[10,"CMDB","Configuration Management Database"]
[11,"CMS","Communication Management System"]
[12,"CoA","Chart of Account"]
[13,"CTO","Compensated Time Off"]
[14,"DDG","Deputy Director General"]
[15,"DDI","Death and Disability Insurance"]
[16,"DG","Director General"]
[17,"DPO","Direct Purchase Order"]
[18,"DSA","Daily Subsistence Allowance"]
[19,"E&B","Entitlement and Benefit"]
[20,"EAM","Enterprise Asset Management"]
[21,"EOD","Entry On Duty"]
[22,"EOL","End Of Life"]
[23,"EPAF","Employee Performance Appraisal Form"]
[24,"EPMAS","Employee Performance and Management Appraisal System"]
[25,"ERP","Enterprise Resource Planning"]
[26,"ESS","Employee Self Service"]
[27,"ETL","Extract, Tranform,Load"]
[28,"FA","Fixed Asset"]
[29,"FIFO","First In, First Out"]
[30,"FOB","Free on Board"]
[31,"FOREX","Foreign Exchange"]
[32,"FT","Fixed Term"]
[33,"GF","General Fund"]
[34,"GL","General Ledger"]
[35,"HL","Home Leave"]
[36,"HLT","Home Leave Travel"]
[37,"HR","Human Resource"]
[38,"HRB","Human Resource Branch"]
[39,"IBAN","International Bank Account Number"]
[40,"IBT","International Bank Transfer"]
[41,"IPSAS","International Public Sector Accounting Standard"]
[42,"ISAE","International Standard on Assurance Engagements"]
[43,"ISB","Information Service Branch"]
[44,"ISS","Infrastructure and Support Service"]
[45,"JV","Journal Voucher"]
[46,"LMS","Learning Management System"]
[47,"MFA","Ministry of Foreign Affairs of the Netherlands"]
[48,"MTD","Month to Date"]
[49,"NSDDI","Non-Service Death and Disability Insurance"]
[50,"OPCW","Organization for the Prohibition of Chemical Weapons"]
[51,"OPEUR","OPCW - EURO Ledger"]
[52,"PDA","Personal digital assistant (Barcode scanner)"]
[53,"PFO","Principal Finance Officer"]
[54,"PHF","Personal History Form"]
[55,"PO","Purchase Order"]
[56,"PPE","Property; Plant and Equipment"]
[57,"PR","Purchase Requisition"]
[58,"PRV","Payment Request Voucher"]
[59,"PSB","Procurement and Support Services Branch"]
[60,"PSC","Program Support Cost"]
[61,"RFQ","Request For Quotation"]
[62,"SAAS","Software As A Service"]
[63,"SAN","Storage Area Network"]
[64,"SCORM","Sharable Content Object Reference Model"]
[65,"SEPA","Single Euro Payment Area"]
[66,"SLWOP","Special Leave Without Pay"]
[{"$f":"A68+1","v":67},"SLWP","Special Leave With Pay"]
[68,"SMTP","Simple Mail Transfer Protocol"]
[69,"SOFI ","Social Fiscal number"]
[70,"SP","State Party ( Member State)"]
[71,"SPA","Special Post Allowance"]
[72,"SQL","Structured Query Language"]
[73,"SSA","Special Service Agreement"]
[74,"STC","Short Term Contract"]
[75,"SWIFT ","Society for Worldwide Interbank Financial Telecommunication"]
[76,"T&M","Time and Material"]
[77,"TA","Travel Advance"]
[78,"TAC","Temporary Assistance Contract"]
[79,"TR","Travel Request"]
[80,"UML","Unified Modelling Language"]
[81,"UNDP","United Nations Development Programme"]
[82,"UNLP","United Nations Laissez-Passer"]
[83,"UNOPS","United Nations Office for Project Services"]
[84,"UNSPSC","United nations Standard Products and Services Code"]
[85,"VAT","Value Added Tax"]
[86,"YTD","Year to Date"]

{"sheet":"Summary","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Please fill in the name of your Organization:"]
[null,"xxx"]
[]
[null,null,"Total","Filled in","Status"]
[1,"General Ledger (GL)",{"$f":"COUNTA('1-GL'!C4:C49,'1-GL'!C52:C84,'1-GL'!C87:C105,'1-GL'!C108:C128,'1-GL'!C131:C152,'1-GL'!C155:C189,'1-GL'!C192:C195,'1-GL'!C198:C202,'1-GL'!C205:C211,'1-GL'!C214:C285)","v":264},{"$f":"COUNTA('1-GL'!D4:D49,'1-GL'!D52:D84,'1-GL'!D87:D105,'1-GL'!D108:D128,'1-GL'!D131:D152,'1-GL'!D155:D189,'1-GL'!D192:D195,'1-GL'!D198:D202,'1-GL'!D205:D211,'1-GL'!D214:D285)","v":0},{"$f":"IF(C5=D5,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[2,"Accounts Payable (AP)",{"$f":"COUNTA('2-AP'!C4:C26,'2-AP'!C29:C47,'2-AP'!C50:C88,'2-AP'!C91:C94,'2-AP'!C97:C98,'2-AP'!C101:C140)","v":127},{"$f":"COUNTA('2-AP'!D4:D26,'2-AP'!D29:D47,'2-AP'!D50:D88,'2-AP'!D91:D94,'2-AP'!D97:D98,'2-AP'!D101:D140)","v":0},{"$f":"IF(C7=D7,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[3,"Accounts receivable (AR)",{"$f":"COUNTA('3-AR'!C4:C23,'3-AR'!C26:C38,'3-AR'!C41:C80,'3-AR'!C88:C89,'3-AR'!C92,'3-AR'!C95,'3-AR'!C98:C116,'3-AR'!C119:C131)","v":109},{"$f":"COUNTA('3-AR'!D4:D23,'3-AR'!D26:D38,'3-AR'!D41:D80,'3-AR'!D88:D89,'3-AR'!D92,'3-AR'!D95,'3-AR'!D98:D116,'3-AR'!D119:D131)","v":0},{"$f":"IF(C9=D9,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[4,"Treasury (TR)",{"$f":"COUNTA('4-TR'!C4:C11,'4-TR'!C14:C24,'4-TR'!C27:C48,'4-TR'!C51:C55,'4-TR'!C58:C71)","v":60},{"$f":"COUNTA('4-TR'!D4:D11,'4-TR'!D14:D24,'4-TR'!D27:D48,'4-TR'!D51:D55,'4-TR'!D58:D71)","v":0},{"$f":"IF(C11=D11,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[5,"Fixed Assets (FA)",{"$f":"COUNTA('5-FA'!C4:C14,'5-FA'!C17:C23,'5-FA'!C26:C30,'5-FA'!C33:C59,'5-FA'!C62:C74)","v":63},{"$f":"COUNTA('5-FA'!D4:D14,'5-FA'!D17:D23,'5-FA'!D26:D30,'5-FA'!D33:D59,'5-FA'!D62:D74)","v":0},{"$f":"IF(C13=D13,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[6,"Budgeting (BUD)",{"$f":"COUNTA('6-Bud'!C4:C53,'6-Bud'!C56:C100,'6-Bud'!C103:C109,'6-Bud'!C112:C115,'6-Bud'!C118:C126,'6-Bud'!C129:C132,'6-Bud'!C135:C150)","v":135},{"$f":"COUNTA('6-Bud'!D4:D53,'6-Bud'!D56:D100,'6-Bud'!D103:D109,'6-Bud'!D112:D115,'6-Bud'!D118:D126,'6-Bud'!D129:D132,'6-Bud'!D135:D150)","v":0},{"$f":"IF(C15=D15,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[7,"Recruitment (REC)",{"$f":"COUNTA('7-Rec'!C4:C18,'7-Rec'!C21:C26,'7-Rec'!C29:C35,'7-Rec'!C38:C51,'7-Rec'!C54:C67,'7-Rec'!C70:C96,'7-Rec'!C99:C114,'7-Rec'!C117:C151)","v":134},{"$f":"COUNTA('7-Rec'!D4:D18,'7-Rec'!D21:D26,'7-Rec'!D29:D35,'7-Rec'!D38:D51,'7-Rec'!D54:D67,'7-Rec'!D70:D96,'7-Rec'!D99:D114,'7-Rec'!D117:D151)","v":0},{"$f":"IF(C17=D17,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[8,"Entitlement & Benefit (E&B)",{"$f":"COUNTA('8-EB'!C4:C19,'8-EB'!C22:C46,'8-EB'!C49:C85,'8-EB'!C88:C110,'8-EB'!C113:C116,'8-EB'!C119:C122,'8-EB'!C125:C155,'8-EB'!C158:C177)","v":160},{"$f":"COUNTA('8-EB'!D4:D19,'8-EB'!D22:D46,'8-EB'!D49:D85,'8-EB'!D88:D110,'8-EB'!D113:D116,'8-EB'!D119:D122,'8-EB'!D125:D155,'8-EB'!D158:D177)","v":0},{"$f":"IF(C19=D19,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[9,"Payroll",{"$f":"COUNTA('9-Payroll'!C4:C20,'9-Payroll'!C23:C32,'9-Payroll'!C35:C51,'9-Payroll'!C54:C83,'9-Payroll'!C86:C92,'9-Payroll'!C95:C99,'9-Payroll'!C102:C106,'9-Payroll'!C109:C114,'9-Payroll'!C117:C123)","v":104},{"$f":"COUNTA('9-Payroll'!D4:D20,'9-Payroll'!D23:D32,'9-Payroll'!D35:D51,'9-Payroll'!D54:D83,'9-Payroll'!D86:D92,'9-Payroll'!D95:D99,'9-Payroll'!D102:D106,'9-Payroll'!D109:D114,'9-Payroll'!D117:D123)","v":0},{"$f":"IF(C21=D21,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[10,"Learning and Management System (LMS)",{"$f":"COUNTA('10-LMS'!C4:C14,'10-LMS'!C17:C23,'10-LMS'!C26:C58,'10-LMS'!C61:C64,'10-LMS'!C67:C69,'10-LMS'!C72:C78,'10-LMS'!C81:C83,'10-LMS'!C86:C92,'10-LMS'!C95:C102,'10-LMS'!C105:C110,'10-LMS'!C113:C120)","v":97},{"$f":"COUNTA('10-LMS'!D4:D14,'10-LMS'!D17:D23,'10-LMS'!D26:D58,'10-LMS'!D61:D64,'10-LMS'!D67:D69,'10-LMS'!D72:D78,'10-LMS'!D81:D83,'10-LMS'!D86:D92,'10-LMS'!D95:D102,'10-LMS'!D105:D110,'10-LMS'!D113:D120)","v":0},{"$f":"IF(C23=D23,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[11,"Employee Performance Appraisal (EPMAS)",{"$f":"COUNTA('11-EPMAS'!C4:C10,'11-EPMAS'!C13:C32,'11-EPMAS'!C35:C38,'11-EPMAS'!C41:C44)","v":35},{"$f":"COUNTA('11-EPMAS'!D4:D10,'11-EPMAS'!D13:D32,'11-EPMAS'!D35:D38,'11-EPMAS'!D41:D44)","v":0},{"$f":"IF(C25=D25,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[12,"Employee Official Documents",{"$f":"COUNTA('12-EOD'!C4:C6,'12-EOD'!C9:C23,'12-EOD'!C26:C34,'12-EOD'!C37:C57)","v":48},{"$f":"COUNTA('12-EOD'!D4:D6,'12-EOD'!D9:D23,'12-EOD'!D26:D34,'12-EOD'!D37:D57)","v":0},{"$f":"IF(C27=D27,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[13,"Procurement",{"$f":"COUNTA('13-Procurement'!C4:C16,'13-Procurement'!C19:C28,'13-Procurement'!C31:C84,'13-Procurement'!C87:C90,'13-Procurement'!C93:C100,'13-Procurement'!C103:C106,'13-Procurement'!C109:C115,'13-Procurement'!C118:C133)","v":116},{"$f":"COUNTA('13-Procurement'!D4:D16,'13-Procurement'!D19:D28,'13-Procurement'!D31:D84,'13-Procurement'!D87:D90,'13-Procurement'!D93:D100,'13-Procurement'!D103:D106,'13-Procurement'!D109:D115,'13-Procurement'!D118:D133)","v":0},{"$f":"IF(C29=D29,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[14,"Travel",{"$f":"COUNTA('14-Travel'!C4:C24,'14-Travel'!C27:C95,'14-Travel'!C98:C99,'14-Travel'!C102:C112,'14-Travel'!C115:C123,'14-Travel'!C126:C133)","v":120},{"$f":"COUNTA('14-Travel'!D4:D24,'14-Travel'!D27:D95,'14-Travel'!D98:D99,'14-Travel'!D102:D112,'14-Travel'!D115:D123,'14-Travel'!D126:D133)","v":0},{"$f":"IF(C31=D31,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
[15,"Asset Management (AM)",{"$f":"COUNTA('15-AM'!C4:C12,'15-AM'!C15:C29,'15-AM'!C32:C41,'15-AM'!C44:C51,'15-AM'!C54:C66,'15-AM'!C69:C76,'15-AM'!C79:C103,'15-AM'!C106:C113,'15-AM'!C116:C139)","v":120},{"$f":"COUNTA('15-AM'!D4:D12,'15-AM'!D15:D29,'15-AM'!D32:D41,'15-AM'!D44:D51,'15-AM'!D54:D66,'15-AM'!D69:D76,'15-AM'!D79:D103,'15-AM'!D106:D113,'15-AM'!D116:D139)","v":0},{"$f":"IF(C33=D33,\"Complete\", \"Incomplete\")","v":"Incomplete"}]
[]
["16","Non-Functional requirement (NF)",{"$f":"COUNTA('16-NF'!D4:D14,'16-NF'!D17:D25,'16-NF'!D28:D41,'16-NF'!D44:D48,'16-NF'!D51:D66,'16-NF'!D69:D75,'16-NF'!D78:D81,'16-NF'!D84:D87,'16-NF'!D90:D92)","v":73},{"$f":"COUNTA('16-NF'!E4:E14,'16-NF'!E17:E25,'16-NF'!E28:E41,'16-NF'!E44:E48,'16-NF'!E51:E66,'16-NF'!E69:E75,'16-NF'!E78:E81,'16-NF'!E84:E87,'16-NF'!E90:E92)","v":0},{"$f":"IF(C35=D35,\"Complete\", \"Incomplete\")","v":"Incomplete"}]

{"sheet":"1-GL","index":3,"n_rows":285,"n_cols":5,"rows_kept":285,"cut":false,"hidden":false,"merged":[]}
[null," General Ledger","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Support International Public Sector Accounting Standards (IPSAS)","1  -> Must have"]
["1.1.2","Budgetary transactions to be posted simultaneously with IPSAS transactions, based on Cash Based Budgetary (OPEUR) rules","1  -> Must have"]
["1.1.3","Automatic identification, tracking and reporting of differences between IPSAS and OPEUR for:\n- Income and expenses.\n- Cash flow statement","1  -> Must have"]
["1.1.4","Supports user defined fiscal calendar ","1  -> Must have"]
["1.1.5","Supports user defined calendar periods ","1  -> Must have"]
["1.1.6","Supports multiple calendar definition options: up to 366 periods, uneven periods, adjustment periods ","1  -> Must have"]
["1.1.7","Supports multiple calendars ","1  -> Must have"]
["1.1.8","Supports multiple financial reporting entities/ledger","1  -> Must have"]
["1.1.9","Supports fiscal monthly period options: 12 or 13 months ","2  -> Very important"]
["1.1.10","Supports Fiscal quarterly period options: 4-4-5, 5-4-4 ","1  -> Must have"]
["1.1.11","Supports User defined calendar period organization ","1  -> Must have"]
["1.1.12","Supports up to 14 user periods per calendar ","2  -> Very important"]
["1.1.13","Calendars that span multiple calendar periods or fiscal years ","2  -> Very important"]
["1.1.14","Base currency designation by financial entity ","4  -> Nice to have"]
["1.1.15","Supports Reporting entity definition/structure ","1  -> Must have"]
["1.1.16","Supports entity ledger assignment ","1  -> Must have"]
["1.1.17","Supports period calendar and chart of accounts for each entity ledger ","2  -> Very important"]
["1.1.18","Supports  opening and closure of calendar periods by entity ","1  -> Must have"]
["1.1.19","User option of real-time versus data collection mode ( eg . Batch Posting or Online Posting)","1  -> Must have"]
["1.1.20","Supports accounting periods: monthly, quarterly, year-to-date ","1  -> Must have"]
["1.1.21","Supports User defined accounting periods ","1  -> Must have"]
["1.1.22","Accounting periods: fiscal and calendar year ","2  -> Very important"]
["1.1.23","Supports Sub ledger system (AP/AR/FA etc)","1  -> Must have"]
["1.1.24","Maintain unit and euro amount postings in GL and sub ledgers ","1  -> Must have"]
["1.1.25","User defined criteria for system archive for general ledger transactions, journal vouchers and accounts payable data based on the number of years / months of data required to maintain - each archive type would have its own unique criteria ","1  -> Must have"]
["1.1.26","Sub ledgers closed out prior to performing an archive: The closeout process sets all financial account balances in the sub ledger to zero by posting an equal and offsetting transaction ","1  -> Must have"]
["1.1.27","Specify a key & rules to have the system automatically archive all records related to the key throughout the system - sub ledger accounts /sub ledger transactions / tables / rates ","1  -> Must have"]
["1.1.28","If postings exist on an account code, system should not allow to delete an account code","1  -> Must have"]
["1.1.29","Translation of Balance Sheet accounts: ability to have a default rate that can be overridden on an exception basis (historic) on an account by account basis - do not want to set up a rate for every balance sheet account - the override rates will differ ledger to ledger ","1  -> Must have"]
["1.1.30","Carry forward account balances from one period to the next","1  -> Must have"]
["1.1.31","Prevent roll over from one accounting period to the next unless the last job run for the financial statements(eg. Adjustment journal posting should have completed before year end carry over)","1  -> Must have"]
["1.1.32","Audit trail required for any changes to table information that may contain rates / information that is used by the system in any way - before / after / change / date / who ","1  -> Must have"]
["1.1.33","Flexible general ledger key with multiple levels, e.g.(entity, programme code, account code, project code etc.)","1  -> Must have"]
["1.1.34","Exception reporting with drill down capabilities ","1  -> Must have"]
["1.1.35","Integration for electronic transmission of payroll data ","1  -> Must have"]
["1.1.36","Ability to use the budget / forecast information to create automatic posting / accruals for any potential overhead item e.g. Employee  benefits, professional fees, i.e. support standard (automatically repeating) postings / entries that are generated each month with reference to amounts maintained in budget fields for the month. The amounts may or may not be the same from month to month ","1  -> Must have"]
["1.1.37","Provide automatic year-end rolling of balances in sub ledgers and general ledger control accounts. This differs from an archive in that the balance still exists, it has been moved to another account. This allows for the automatic aging of account balances from a current file to a prior file and is required to maintain separate balances relating to customers acquired in the current year and in prior years ","1  -> Must have"]
["1.1.38","Automatic linking and posting of control accounts from related sub ledger accounts ","1  -> Must have"]
["1.1.39","Process jobs in edit and update mode ","1  -> Must have"]
["1.1.40","Jobs required to include error/warning messages on reports ","1  -> Must have"]
["1.1.41","Reports to include a control report that lists pages on which errors/warnings have occurred ","1  -> Must have"]
["1.1.42","User defined controls to allow specific jobs to update multiple times in a period (e.g. multiple account closures, soft close).","1  -> Must have"]
["1.1.43","View postings at the organization, section, unit level ","1  -> Must have"]
["1.1.44","Archiving of transaction history from active files ","1  -> Must have"]
["1.1.45","User could configure approval work flow for transactions e.g..( Journal voucher, Chart of Account )","1  -> Must have"]
["1.1.46","Batch upload facility for  e.g..( Journal voucher, Chart of Account, Currency, Exchange Rate) )","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2," Chart of Accounts Structure","N/A","N/A"]
["1.2.1","Define account structures online ","1  -> Must have"]
["1.2.2","Account number 30 characters or more ","2  -> Very important"]
["1.2.3","Use only number of  characters actually required ","1  -> Must have"]
["1.2.4","Common chart of accounts ","1  -> Must have"]
["1.2.5","Chart of account shared with sub ledgers ","1  -> Must have"]
["1.2.6","Alphanumeric account numbers ","2  -> Very important"]
["1.2.7","Required logical/sequencing-numbering scheme for accounts, cost centres, units ","2  -> Very important"]
["1.2.8","Account creation restricted when initial transaction posting occurs ","1  -> Must have"]
["1.2.9","Account creation based on chart of account structure ","1  -> Must have"]
["1.2.10","Account description of at least 25 characters ","1  -> Must have"]
["1.2.11","Account types: Asset, Liability, Revenue (exchange/non-exchange), Expense, Others, Equity","1  -> Must have"]
["1.2.12","Supports alphanumeric account key ","1  -> Must have"]
["1.2.13","Statistical accounts ","3  -> Important"]
["1.2.14","Supports unlimited cost centre entities ","1  -> Must have"]
["1.2.15","User-defined fields/segments in each account structure-- e.g., fund code, Programme Code, account code, Project Code, Cost centre, Resserve1, Reserve2 ","1  -> Must have"]
["1.2.16","User-defined analysis fields ","1  -> Must have"]
["1.2.17","Sub-account numbers ","1  -> Must have"]
["1.2.18","Supports multiple units, divisions e.g. - Chapter, Division, Programme Code","1  -> Must have"]
["1.2.19","Supports multiple companies, entities ","1  -> Must have"]
["1.2.20","Unlimited organization structures, unlimited levels ","2  -> Very important"]
["1.2.21","Multiple hierarchy roll-ups ","2  -> Very important"]
["1.2.22","Account hierarchy maintenance using drag-and-drop interface ","2  -> Very important"]
["1.2.23","Description flex fields to add custom fields without programming ","2  -> Very important"]
["1.2.24","Account currency designation ","1  -> Must have"]
["1.2.25","Budget accounts: annual and monthly ","2  -> Very important"]
["1.2.26","Budget accounts: current year and next year ","2  -> Very important"]
["1.2.27","Account titles and narrative account descriptions ","1  -> Must have"]
["1.2.28","Maintenance of history for five years (viewing) and  ten years (reporting) ","1  -> Must have"]
["1.2.29","Standard chart of accounts that can be automatically copied from one ledger to the new ledger - to result in the automatic creation of a standard set of financial statements e.g. Balance Sheets, Income Statements.","1  -> Must have"]
["1.2.30","Provide validity checks to ensure existence of standard accounts ","1  -> Must have"]
["1.2.31","Approval required to adjust Chart of Accounts (CoA)","1  -> Must have"]
["1.2.32","Changes in CoA updated simultaneously on multiple ledgers (IPSAS/budget)","1  -> Must have"]
["1.2.33","Ability of restriction on chart of account combination (e.g. fund code x office to enable only certain branches to access trust fund, funding objective x expense account) ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3," Multi Currency Capabilities","N/A","N/A"]
["1.3.1","Transactions and reporting in any predefined currencies(e.g. USD, EUR, GBP)","1  -> Must have"]
["1.3.2"," Support all major currencies, approximately 150 currencies","1  -> Must have"]
["1.3.3","Ability to set up user defined Base Currency- e.g.. Euro","1  -> Must have"]
["1.3.4","Maintain ledger in multiple currencies ","1  -> Must have"]
["1.3.5","Automatic or manual entry of exchange rates ","1  -> Must have"]
["1.3.6","Facility to upload UN exchange rate from excel/csv file.","1  -> Must have"]
["1.3.7","Automatic currency conversion ","1  -> Must have"]
["1.3.8","Currency conversion at current rate","1  -> Must have"]
["1.3.9","Currency conversion at given rate","1  -> Must have"]
["1.3.10","Currency conversion at average rate","1  -> Must have"]
["1.3.11","Currency conversion at historical rate","1  -> Must have"]
["1.3.12","Currency conversion at transaction level ","1  -> Must have"]
["1.3.13","Translation of actual or budget balances or prior year balances ","1  -> Must have"]
["1.3.14","Rate options: daily, period-end, historical, weighted average ","1  -> Must have"]
["1.3.15","Calculation of unrealized gains and losses ","1  -> Must have"]
["1.3.16","Re-measurement and revaluation processing ","1  -> Must have"]
["1.3.17","Revaluation of foreign currency accounts ","1  -> Must have"]
["1.3.18","State prior results with a different historical exchange rate ","3  -> Important"]
["1.3.19","Foreign exchange gain/loss for reporting ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Ledger  Management  and control","N/A","N/A"]
["1.4.1","Maintain multiple ledger:  financial statement, internal reporting, IPSAS reporting","1  -> Must have"]
["1.4.2","User-assigned Chart of Accounts for each entity ledger ","3  -> Important"]
["1.4.3","Inheritance or ability to copy ledger calendar and chart of accounts into assigned books ","3  -> Important"]
["1.4.4","Ability to set base currency and reporting year per entity","3  -> Important"]
["1.4.5","Sub ledger coding to accommodate: units, sub-units, cost centres, expense categories, projects/contracts ","1  -> Must have"]
["1.4.6","Subtotals by account, sub-account groups without sequential account numbers ","1  -> Must have"]
["1.4.7","Translate data within the GL and sub ledgers according to pre-set or calculated parameters defining allocation of postings ","2  -> Very important"]
["1.4.8","Ability of system to generate the calculation and posting of expense items based on a predefined set of allocation models ","2  -> Very important"]
["1.4.9","Ability to work online with financial systems while closing jobs are in process ","1  -> Must have"]
["1.4.10","Inactive account flag to prevent posting to account ","1  -> Must have"]
["1.4.11","Suspend account for transactions of errors allowing post and later correction ","1  -> Must have"]
["1.4.12","Multiple error suspense acts by error type/code (i.e. suspense accounts for errors in uploads/interfaces/business rules, e.g. rounding errors)","1  -> Must have"]
["1.4.13","Validation rules for accounts ","1  -> Must have"]
["1.4.14","Validation of account/sub-account/cost centre combinations ","1  -> Must have"]
["1.4.15","Entity, Ledger, account, User security ","1  -> Must have"]
["1.4.16","Reduce need for interfund postings by automatically assigning VAT / FOREX to Trust Fund directly rather than through General Fund  (through business rules)","2  -> Very important"]
["1.4.17","Code Trust Fund agreements for those with/without conditions","2  -> Very important"]
["1.4.18","Link revenue recognition to expenses for trust funds with conditions","2  -> Very important"]
["1.4.19","Recognise revenue when contract signed (i.e. before cash receipt)","2  -> Very important"]
["1.4.20","Trust funds - business rules tailored to grant conditions (i.e. interest retained or repaid)","2  -> Very important"]
["1.4.21","Separately display inter-fund movements as transfers instead of income and expenditure","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.5,"Journal Entry ","N/A","N/A"]
["1.5.1","Accept automatic entries from AP ","1  -> Must have"]
["1.5.2","Accept automatic entries from Inventory ","1  -> Must have"]
["1.5.3","Accept automatic entries from Treasury","1  -> Must have"]
["1.5.4","Accept automatic entries / interface with/from  Payroll ","1  -> Must have"]
["1.5.5","Accept direct journal entries ","1  -> Must have"]
["1.5.6","Real-time journal entry with immediate update of balance ","1  -> Must have"]
["1.5.7","Online journal entry with comments ","1  -> Must have"]
["1.5.8","Standard journal entries with pre-defined journal voucher number ","1  -> Must have"]
["1.5.9","Support standard (automatically repeating) journal entries ","1  -> Must have"]
["1.5.10","Recurring journal entries ","1  -> Must have"]
["1.5.11","Reversing journal entries ","1  -> Must have"]
["1.5.12","Full online journal validation and balancing ","1  -> Must have"]
["1.5.13","Batch totals and total checking ","1  -> Must have"]
["1.5.14","Document reference number and date for all sub ledger journals ","1  -> Must have"]
["1.5.15","Manipulate historical data with appropriate security ","1  -> Must have"]
["1.5.16","Move balances from one period to another with appropriate security ","1  -> Must have"]
["1.5.17","Capability for point and click drill down for AP data, journal entries, and other GL input ","1  -> Must have"]
["1.5.18","Translate accounts at different exchange rates - one account could be at the spot foreign exchange rate, another account could be at the historic exchange rate ","1  -> Must have"]
["1.5.19","Create postings using year to date information: automatically reverse the previous month's posting and replace it with the current posting - can be done monthly / quarterly ","1  -> Must have"]
["1.5.20","Create automatic posting based on predefined calculation and information contained in the general ledger. E.g. 110% of an overhead unit ","2  -> Very important"]
["1.5.21","Create/generate reversal postings for transactions generated from a journal entry posted in error ","1  -> Must have"]
["1.5.22","Automatically assign JV number and use specific coding to identify manual/automated/IPSAS/OPEUR JVs","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Journal Voucher Transactions","N/A","N/A"]
["1.6.1","Electronic approvals","1  -> Must have"]
["1.6.2","Option to attach supporting documents for JV","1  -> Must have"]
["1.6.3","Online voucher entry and editing ","1  -> Must have"]
["1.6.4","Import/export transactions to another database ","1  -> Must have"]
["1.6.5","Journal voucher suspense for error correction ","1  -> Must have"]
["1.6.6","Batch reporting updated by transactions (scheduled/online batch processes)","1  -> Must have"]
["1.6.7","Real-time posting (update) of clean journal vouchers ","1  -> Must have"]
["1.6.8","Separate columns for debits/credits on journal voucher entry screen ","1  -> Must have"]
["1.6.9","Flexible period debit/credit balances (balances can be translated in multiple currencies)","1  -> Must have"]
["1.6.10","Journal entry/event simultaneously posted in multiple sets of ledgers","1  -> Must have"]
["1.6.11","System generated batch control totals ","1  -> Must have"]
["1.6.12","Automatic posting of recurring journals ","1  -> Must have"]
["1.6.13","Automatic reversal of month-end accruals beginning of next period ","1  -> Must have"]
["1.6.14","Automatic generation of offsetting entries for clearing account ","1  -> Must have"]
["1.6.15","User-specified start/stop dates for standard journals ","1  -> Must have"]
["1.6.16","User-specified start/stop dates for recurring journals ","1  -> Must have"]
["1.6.17","Journal voucher posted to current period if previous still open ","1  -> Must have"]
["1.6.18","Prior period adjustments ","1  -> Must have"]
["1.6.19","Mass reversal to remove journal vouchers ","1  -> Must have"]
["1.6.20","User-specified number of periods of history ","1  -> Must have"]
["1.6.21","Detailed or summary postings from sub ledgers ","1  -> Must have"]
["1.6.22","Continuous transaction numbering with multiple numbering schemes ","2  -> Very important"]
["1.6.23","Detailed audit trails for internal and external auditing ","1  -> Must have"]
["1.6.24","Post to different accounts in several ledger with the same posting source e.g. journal voucher ","1  -> Must have"]
["1.6.25","Posting to both the general ledger and sub ledger simultaneously ","1  -> Must have"]
["1.6.26","Automatic inter-organization posting when entry being posted to more than one ledger within the system at the same time or using the same source e.g. journal voucher ","3  -> Important"]
["1.6.27","Creation of additional financial transactions based on statistical / non financial data entered by journal voucher ","2  -> Very important"]
["1.6.28","Exchange rate to be calculated automatically when journal is created in any currency other than base currency","1  -> Must have"]
["1.6.29","Ability to generate posting to recognize exchange rate gain/loss when  posting a journal entry with currency other than base currency and book the gain/loss to designated exchange rate gain/ loss account","1  -> Must have"]
["1.6.30","Allows entry of any currency other than base currency on Journal Voucher ","1  -> Must have"]
["1.6.31","User defined calculations and postings for monthly jobs by utilizing tables ","1  -> Must have"]
["1.6.32","Automatic posting of transactions to GL from bank statement (e.g. based on identifier codes for payments)","3  -> Important"]
["1.6.33","Automatic posting of Program Support Cost  when eligible expenses incurred for Trust Funds","2  -> Very important"]
["1.6.34","Identify transfers between Trust Funds  separately from expenses/income.","2  -> Very important"]
["1.6.35","Posting of budgetary Prior Year  adjustments as IPSAS expense depending on date of delivery of services.","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.7,"IPSAS","N/A","N/A"]
["1.7.1","Facility to perform actuarial adjustment in separate account","1  -> Must have"]
["1.7.2","Facility to extract Unliquidated Obligations  and generate automatic journal on monthly/yearly basis  to book expenses for actual goods/services delivered ","1  -> Must have"]
["1.7.3","Facility to calculate staff benefits based on HR data and generate accrual journal at year end  (i.e. education grant and annual leave accruals)","1  -> Must have"]
["1.7.4","Facility to calculate interest on time deposits and generate accrual journal to recognize interest income at month end/year-end. ","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.8,"Closure","N/A","N/A"]
["1.8.1","Flexible accounting close processing (e.g. soft/hard close)","1  -> Must have"]
["1.8.2","Multiple periods open at one time ","1  -> Must have"]
["1.8.3","Start New Year before prior year  is closed ","2  -> Very important"]
["1.8.4","Year-end close: automatic clearing of expense accounts into accumulated surplus/deficit on finalisation of accounts.","2  -> Very important"]
["1.8.5","Re-run capability on closed periods (e.g. adjustments to prior periods)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.9,"Enterprise Reporting Structure","N/A","N/A"]
["1.9.1","Facility to define financial reporting  structure","1  -> Must have"]
["1.9.2","Unlimited hierarchical organization levels for building multi-level entity structure ","1  -> Must have"]
["1.9.3","Account mapping across business units with different chart of accounts (e.g. allocate specific account codes to specific business units)","1  -> Must have"]
["1.9.4","Many-to-many relationships mapping across enterprise, entities, accounts ","3  -> Important"]
["1.9.5","Use of mathematical functions in creating report structures ","3  -> Important"]
["1.9.6","Multi-level unit reporting structures ","1  -> Must have"]
["1.9.7","Multiple account allocation ","1  -> Must have"]
[null,null,"N/A","N/A"]
[2,"Report Capabilities","N/A","N/A"]
["2.0.1","Automated reconciliations between sub-ledgers and GL, identifying differences only. Combine with exception reports for Special Ledger-GL interfaces.","1  -> Must have"]
["2.0.2","Report Writer should provide the user with the ability to design standard monthly reports as well as \"one-off' reports ","1  -> Must have"]
["2.0.3","Support numerous and complex formulas and user defined column formatting ","2  -> Very important"]
["2.0.4","Support percentage formulas ","2  -> Very important"]
["2.0.5","Support statistical formulas ","2  -> Very important"]
["2.0.6","Restate prior year results with a different exchange rate ","2  -> Very important"]
["2.0.7","Support cutting and pasting within report writing application and allow for exporting data to spreadsheet files ","1  -> Must have"]
["2.0.8","Account current balances ","1  -> Must have"]
["2.0.9","Previous 60 month account balances ","2  -> Very important"]
["2.0.10","Current period account budget amounts ","1  -> Must have"]
["2.0.11","Journal and journal entry ID number report ","1  -> Must have"]
["2.0.12","Journal entry date report ","1  -> Must have"]
["2.0.13","Journal entry description report ","1  -> Must have"]
["2.0.14","General ledger account numbers report ","1  -> Must have"]
["2.0.15","Journal entry amount report (manual and automatic)","1  -> Must have"]
["2.0.16","AP summary entries report ","1  -> Must have"]
["2.0.17","Fixed asset depreciation and gain/loss entries report ","1  -> Must have"]
["2.0.18","Inventory summary entries report ","1  -> Must have"]
["2.0.19","Cash summary entries report ","1  -> Must have"]
["2.0.20","Trial balance ","1  -> Must have"]
["2.0.21","Trial balance at both detail and summary level ","1  -> Must have"]
["2.0.22","Profit and loss statement and balance sheet ","1  -> Must have"]
["2.0.23","Comparative budget statement ","1  -> Must have"]
["2.0.24","Run monthly and quarterly statements and budgets reports simultaneously","1  -> Must have"]
["2.0.25","Comparative income statement ","3  -> Important"]
["2.0.26","Comparative balance sheet ","3  -> Important"]
["2.0.27","GL reports at both detail and summary level ","1  -> Must have"]
["2.0.28","Balance forward reports containing transactions from multiple periods (i.e. roll forward account closing balances by period (month/year)).","1  -> Must have"]
["2.0.29","User option to select specific reports ","1  -> Must have"]
["2.0.30","Flexible financial statement report formats ","1  -> Must have"]
["2.0.31","Spreadsheet-ready exports in tab delimited format ","1  -> Must have"]
["2.0.32","Produce reports on standard operating system default ","1  -> Must have"]
["2.0.33","Account maintenance transaction report ","1  -> Must have"]
["2.0.34","Exception reporting ","1  -> Must have"]
["2.0.35","Chart of accounts listing ","1  -> Must have"]
["2.0.36","Entity account, sub-account cost centre and project reporting ","1  -> Must have"]
["2.0.37","Automatic accrual/reversal audit trail report ","1  -> Must have"]
["2.0.38","Source cross-reference transaction journal (i.e. trace summarised JV in GL to detailed JV in sub ledger)","1  -> Must have"]
["2.0.39","Division reporting without use of report writer - user friendly interface to customise reports","1  -> Must have"]
["2.0.40","As of reporting for any user-specified date ","1  -> Must have"]
["2.0.41","Account analysis report with user-specified selection criteria ","1  -> Must have"]
["2.0.42","Member State Contribution reporting by country (voluntary and assessed)","1  -> Must have"]
["2.0.43","Allocation flow reporting with to/from accounts (i.e. cost allocation across multiple accounts - payroll, rent, trust funds).","1  -> Must have"]
["2.0.44","Expense report showing actual/budget/variance by accounting period ","2  -> Very important"]
["2.0.45","Export into Excel, tab delimited format ","1  -> Must have"]
["2.0.46","User-controlled report totals by account code, account group, roll-up series of account/centre, user-specified groups ","1  -> Must have"]
["2.0.47","Ability to configure/customise financial reporting ","1  -> Must have"]
["2.0.48","System maintain multiple options for running same report (pdf, excel, csv) ","1  -> Must have"]
["2.0.49","User-defined titles/distribution information ","2  -> Very important"]
["2.0.50","User-defined column headings ","2  -> Very important"]
["2.0.51","User-defined date line formats in same report ","2  -> Very important"]
["2.0.52","Determines number of print lines per page ","1  -> Must have"]
["2.0.53","Calculation using multiple factors ","1  -> Must have"]
["2.0.54","Calculation with user-specified factors (e.g. allocation of bank interest/charges between Trust Funds)","1  -> Must have"]
["2.0.55","Calculation with multiple constants ","1  -> Must have"]
["2.0.56","Specifies spacing between columns ","2  -> Very important"]
["2.0.57","Unlimited totalling/subtotalling ","1  -> Must have"]
["2.0.58","Format total line different than data line ","2  -> Very important"]
["2.0.59","Specifies rounding by report ","2  -> Very important"]
["2.0.60","Specifies rounding by column ","2  -> Very important"]
["2.0.61","User-specified rounding on system reports ","2  -> Very important"]
["2.0.62","Rounded reports cross foot with total lines (i.e. set rounds)","2  -> Very important"]
["2.0.63","Separate report options by unit/entity ","1  -> Must have"]
["2.0.64","Reporting with multiple graphing options: pie charts, histograms, bar charts ","3  -> Important"]
["2.0.65","Exception reporting - ability of the system to identify a variance and then drill down to identify the source of the variance - back to an invoice details if required ","2  -> Very important"]
["2.0.66","Versatile end user reporting tool - flexible report format / rounding options / calculation options / variance analysis - that can easily access the underlying data contained in the general ledger data base ","3  -> Important"]
["2.0.67","Current year versus prior year(s) comparison ","2  -> Very important"]
["2.0.68","Drill downs: summary accounts, detail accounts, journal entries, payable invoices, funds available, variance calculations ","1  -> Must have"]
["2.0.69","Automation of key financial statements from Trial Balance  through pre-designated and adjustable mapping:\n- Position\n- Performance\n- Equity\n- Cash flow statement\n- Budget vs actuals\n- Segment reporting - assets and liabilities, income and expenses","1  -> Must have"]
["2.0.70","Further IPSAS notes:\n- Liquidity risk\n- PPE & Intangible assets\n- Recoverable / receivables / prepayments\n- Inventories\n- Cash and cash equivalents (incl restricted cash)\n- Accounts payable / Working capital fund / cash surplus / other liabilities\n- Employee benefit liabilities (based on upload of actuarial information)\n- Provisions\n- Revenue (by type)\n- Expenses (Employee benefit / general operating / other operating)\n- Finance income / expense\n- Lease and capital commitments\n- Segment reporting\n- IPSAS-OPEUR reconciliation (cash flows and surplus/deficit).","1  -> Must have"]
["2.0.71","Budgetary accounts financial statements, cash surplus and quarterly I&E report automated","1  -> Must have"]
["2.0.72","Automation of Budgetary Accounts annexes:\n- Status of appropriations - General Fund\n- Statement of cash and investments (term deposits) - all funds\n- Income, expenditure and changes in reserves and fund balances - all funds\n- Assets, liabilities and reserves and fund balances - all funds\n- Statement of cash surpluses - General Fund\n- Status of assessed annual contributions - General Fund\n- Status of advances to the Working Capital Fund\n- Statement of expenditure by funding programme and major expenditure category - all funds\n- Statement of budgetary obligations by funding programme and major expenditure category - all funds\n- Statement of savings on prior year's obligations - all funds\n- Statement of cash surpluses credited to Member States - General Fund\n- Reimbursements for inspections under Articles IV&V of the Chemical Weapons Convention - all funds\n- Voluntary contributions by donor","1  -> Must have"]

{"sheet":"2-AP","index":4,"n_rows":140,"n_cols":5,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[null,"Accounts Payable","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Supports multiple payable entities, and programme, sub-programme","1  -> Must have"]
["1.1.2","Supports separate processing cycle for each entity, each account code ","1  -> Must have"]
["1.1.3","Supports common or shared vendor database for all entities ","1  -> Must have"]
["1.1.4","Supports maintenance of selected vendors restricted by  branch, division or entity ","1  -> Must have"]
["1.1.5","User-defined data fields - at least 20 fields for Payment vouchers ","1  -> Must have"]
["1.1.6","Supports at least 50 numeric fields for invoice and 100 text fields for description to be captured on bank transfer detail  ","1  -> Must have"]
["1.1.7","Supports  validation of account and fund codes combinations ","1  -> Must have"]
["1.1.8","Supports Accrual-basis accounting ","1  -> Must have"]
["1.1.9","Support user defined payment terms (Net 30, Net 15 etc.)","1  -> Must have"]
["1.1.10","Automatic discount calculation based on credit terms and voucher amount ","1  -> Must have"]
["1.1.11","Automatic discount/date net pay date calculation ","1  -> Must have"]
["1.1.12","Supports multiple banks and bank accounts and be able to pay single payment request voucher  from multiple accounts","1  -> Must have"]
["1.1.13","Support real-time update of the transactions","1  -> Must have"]
["1.1.14","Support multi currency transactions","1  -> Must have"]
["1.1.15","User defined option for  detail or summary  GL Posting.","1  -> Must have"]
["1.1.16","Fully integrated with the GL and allow drill down to the transactions and invoice details and Purchase Order and Goods/Service Receipt details","1  -> Must have"]
["1.1.17","System security based on organizational/legal entity control ","1  -> Must have"]
["1.1.18","Automated workflow - A/P automatically updates and sends message to the General Accounting group that a transaction has taken place based on user defined business rule","1  -> Must have"]
["1.1.19","Supports printing of Payment Request Voucher (PRV)","3  -> Important"]
["1.1.20","Supports catalogue description or alternate user defined description of items at PO level which will be copied to payment request voucher","1  -> Must have"]
["1.1.21","Supports editing of  Payment Request Voucher before approval","1  -> Must have"]
["1.1.22","Facility to send reminders to Receiving Officers or Ship-Tos when invoices are due for payment","1  -> Must have"]
["1.1.23","Facility to default Accrual Effective Date (AED) based on the modification date of the Payment Request Voucher","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Vendor Details","N/A","N/A"]
["1.2.1","Maintain the vendor details (International postal codes, Vendor name ,Vendor number /ID, Vendor type, Vendor currency , Contact phone number)","1  -> Must have"]
["1.2.2","Maintain User-defined vendor types and classifications","1  -> Must have"]
["1.2.3","Vendor demographics (Domestic and International)","1  -> Must have"]
["1.2.4","Vendor Performance history / vendor evaluation  (i.e., initial response quality, condition of receipts, on time delivery, price to quote)","1  -> Must have"]
["1.2.5","Vendor Bank account","1  -> Must have"]
["1.2.6","Supports one vendor with multiple locations/addresses/currencies ","1  -> Must have"]
["1.2.7","Supports default account distributions for posting by vendor or vendor group ","1  -> Must have"]
["1.2.8","Supports creation of one time vendor","1  -> Must have"]
["1.2.9","Supports user defined workflow for the approval of vendor master","1  -> Must have"]
["1.2.10","Support tracking  of correspondence with vendors.","1  -> Must have"]
["1.2.11","Allow vendor  record for an employee ","1  -> Must have"]
["1.2.12","Audit trail report for any changes to the Vendor Master file - it should show the information before the change, indicate what was changed, who changed it and the new information ","1  -> Must have"]
["1.2.13","Automatic vendor inactivation after specified period of inactivity ","1  -> Must have"]
["1.2.14","Automatic vendor id generation based on predefined prefix or suffix by vendor group. E.g. Staff Members, Member states, Commercial Vendors, UN etc.","1  -> Must have"]
["1.2.15","Ability to delete vendor id  if there is no transaction record exist","1  -> Must have"]
["1.2.16","Link between vendor id and  customer id  ( Some vendors could also be customers and vice versa)","1  -> Must have"]
["1.2.17","Masking of bank account number to facilitate editing ","1  -> Must have"]
["1.2.18","Masking of bank account to structure number scheme ","1  -> Must have"]
["1.2.19","Masking capability on bank account number for reporting and inquiry ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Accounts Payable Transactions","N/A","N/A"]
["1.3.1","Support searching  a voucher/invoice by Vendor ID or number, Vendor name, partial name or sounds like name, Voucher number, Purchase order number, Invoice number, supports lower case and upper case","1  -> Must have"]
["1.3.2"," Capability to minimize data input and matching of incoming invoices to Purchase orders (3 way/4 way matching)","1  -> Must have"]
["1.3.3","Ability to check invoiced amounts against the defined tolerances for the organization and vendor, with the availability of an optional override","1  -> Must have"]
["1.3.4","Ability to hold open status obligation per line item based on tolerance limit","1  -> Must have"]
["1.3.5","Maintain voucher status information including: Pending,Approved,Hold,Paid.","1  -> Must have"]
["1.3.6","Maintain voucher status information automatically by payable entity","1  -> Must have"]
["1.3.7","Support bulk/batch review and approve/release prior to payment","1  -> Must have"]
["1.3.8","Receipt transactions should allow the scanning and attaching  of support documents (emails and fax)","1  -> Must have"]
["1.3.9","Alternate methods of data entry: scanning, data upload using excel, text file etc.","1  -> Must have"]
["1.3.10","Support various disbursement methods with the bank including Check, Wire transfer, EFT with unique transaction source codes in multiple currencies","1  -> Must have"]
["1.3.11","Duplicate vendor invoice number check (Vendor ID, Invoice number, Invoice date, Gross amount)","1  -> Must have"]
["1.3.12","Automatic and  manual  number generation options for  invoice/payment vouchers etc.","1  -> Must have"]
["1.3.13","Maintain at least 15 years of invoice details (current year plus 15 prior years)","1  -> Must have"]
["1.3.14","Allow authorized users to override General Ledger date/ accrual date at voucher entry.","1  -> Must have"]
["1.3.15","Allow users to post to a non-current open period.","1  -> Must have"]
["1.3.16","Support tracking travel reimbursements against advances","1  -> Must have"]
["1.3.17","Supports date to be scheduled for voucher payment","1  -> Must have"]
["1.3.18","Provide warning message for unsettled advance payment for the vendors during invoice creation","1  -> Must have"]
["1.3.19","Supports expense account distribution at the time of data entry (Transaction-specific or pre-defined distribution rule)","1  -> Must have"]
["1.3.20","Supports the validation of data entry including the accounting distribution","1  -> Must have"]
["1.3.21","Supports fund availability check","1  -> Must have"]
["1.3.22","Automatic generation of associated transactions to liquidate encumbrances generated from Purchasing","1  -> Must have"]
["1.3.23","Automatic calculation  of exchange gain or loss when processing non EUR currency invoices","1  -> Must have"]
["1.3.24","Accept invoices with out  PO (Direct invoice below user defined threshold currently 250 EUR)","1  -> Must have"]
["1.3.25","Recurring payments by user selected frequency (monthly, quarterly, annually, semi-annually, weekly )","1  -> Must have"]
["1.3.26","Support prepayment and advance","1  -> Must have"]
["1.3.27","Debit/credit memos on account or invoice ","1  -> Must have"]
["1.3.28","Support Vendor payable adjustment (Allow settlement of credit note against debit note)","1  -> Must have"]
["1.3.29","Allow matching of payments/receipts with outstanding amounts","1  -> Must have"]
["1.3.30","Provides a full audit trail of the AP transaction detail","1  -> Must have"]
["1.3.31","Support  user defined workflow  for  routing of invoices  for approval","1  -> Must have"]
["1.3.32","Allow staff entitlements to be disbursed through accounts payable e.g. assignment grant","1  -> Must have"]
["1.3.33","Sends warning message when entering Goods Receipt date relating to prior year","1  -> Must have"]
["1.3.34","Supports booking to ledger based on the receipt date with a possibility to override","1  -> Must have"]
["1.3.35","Facility to route advance payment details in a predefined workflow","2  ->Very  Important"]
["1.3.36","Supports cash advance settlement/clerance","2  ->Very  Important"]
["1.3.37","Supports automatic calculation of exchange rate for the expenses from actual currency to EUR for cash advance settlement","2  ->Very  Important"]
["1.3.38","Supports electronic workflow for handling cash disbursements with capturing electronic signature of the recipient in a mobile or hand held devices","3  -> Important"]
["1.3.39","Supportd automatic matching disbursed amount against obligated amount( Unencumber for expense)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Payment Controls","N/A","N/A"]
["1.4.1","Prevents inactivation of vendors with open PO, unpaid invoice","1  -> Must have"]
["1.4.2","Hold payment at vendor level","1  -> Must have"]
["1.4.3","Release payment at vendor level, invoice level and/or line item","1  -> Must have"]
["1.4.4","Supports selective payment by vendor type","3  -> Important"]
[null,null,"N/A","N/A"]
[1.5,"Vendor Portal","N/A","N/A"]
["1.5.1","Vendors can upload invoices through a vendor portal / electronic data transfer","1  -> Must have"]
["1.5.2","Vendors and internal resources can  access the status of payments through self service","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Report Capabilities","N/A","N/A"]
["1.6.1","Bank Account Listing","1  -> Must have"]
["1.6.2","Voucher Register","1  -> Must have"]
["1.6.3","Posted Voucher Listing","1  -> Must have"]
["1.6.4","Recurring Vouchers","1  -> Must have"]
["1.6.5","Payment History by Vendor","1  -> Must have"]
["1.6.6","Summary Payment Register","1  -> Must have"]
["1.6.7","Detailed Payment Register","1  -> Must have"]
["1.6.8","Payment Advice","1  -> Must have"]
["1.6.9","Payment Forecast","1  -> Must have"]
["1.6.10","Outstanding/Open invoices for a user-defined period ","1  -> Must have"]
["1.6.11","Vendor Detail Report","1  -> Must have"]
["1.6.12","Vendor Listing Report","1  -> Must have"]
["1.6.13","Payment Archive Report","1  -> Must have"]
["1.6.14","Voucher Archive Report","1  -> Must have"]
["1.6.15","Payment History Archive Report","1  -> Must have"]
["1.6.16","Voucher History Archive Report","1  -> Must have"]
["1.6.17","Aged Open Payable Listing","1  -> Must have"]
["1.6.18","Accounts Payable Checks/Remittance Advice","1  -> Must have"]
["1.6.19","Not invoiced Receipts Report","1  -> Must have"]
["1.6.20","Cash Requirement Report due for payment on the current pay cycle","1  -> Must have"]
["1.6.21","Vendors and Vouchers Placed on Payment Hold Report ","1  -> Must have"]
["1.6.22","Detailed employee expense report: Travel, Advances etc. ","1  -> Must have"]
["1.6.23","Detailed employee expense report: MTD, YTD ","1  -> Must have"]
["1.6.24","Summary expense report by funding objects(Expense type)","1  -> Must have"]
["1.6.25","Summary expense report by cost centre/division /branch","1  -> Must have"]
["1.6.26","Open travel advance report ","1  -> Must have"]
["1.6.27","Schedule of recurring payments report ","1  -> Must have"]
["1.6.28","Creation of ad hoc reports by user (e.g. vendor payment history report) ","1  -> Must have"]
["1.6.29","Tax reporting: summary by vendor/invoice of all input tax credits processed in the month by the AP system ","1  -> Must have"]
["1.6.30","Employee receivables statements ","1  -> Must have"]
["1.6.31","Travel expense reporting capability ","1  -> Must have"]
["1.6.32","Vendor Aging by due date ","1  -> Must have"]
["1.6.33","Vendor Aging by invoice date ","1  -> Must have"]
["1.6.34","Cleared invoices for a user-defined period","1  -> Must have"]
["1.6.35","Hold invoices for a user-defined period","1  -> Must have"]
["1.6.36","Vendor debit balance report","1  -> Must have"]
["1.6.38","Provide separate balance sheet reports showing (a) all transactions posted to accounts (e.g. 1601) and (b) only unmatched transaction (i.e. eliminating all matched Cr and Dr from report).","1  -> Must have"]
["1.6.39","Report on advance payment vs disbursed","1  -> Must have"]
["1.6.40","Facility to generate  payment status report on obligation document(PO)  on demand  by user defined filter criteria","1  -> Must have"]
["1.6.41","AP drilldown by vendor/staff member and link to AR records.","1  -> Must have"]

{"sheet":"3-AR","index":5,"n_rows":131,"n_cols":5,"rows_kept":131,"cut":false,"hidden":false,"merged":[]}
[null,"Accounts Receivables","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Supports multiple receivable entities, and programme, sub-programme","1  -> Must have"]
["1.1.2","Separate processing cycle for each entity, each account code ","1  -> Must have"]
["1.1.3","Common or shared customer database for all entities ","1  -> Must have"]
["1.1.4","User-defined data fields for capturing additional structured information ","1  -> Must have"]
["1.1.5","Supports  validation of receivable account codes ","1  -> Must have"]
["1.1.6","Support multiple receivable types (1. Assessed Contributions ,2.Voluntary Contribution 3.  Services rendered (Article IV &V, 4. VAT Collections etc.)\n","1  -> Must have"]
["1.1.7","Support single customer to have multiple receivable types (i.e. same customer master data with multiple income types - assessed contributions art IV/V etc.)","1  -> Must have"]
["1.1.8","Ability to track receivables  by fund code, Programme code or by agreement","1  -> Must have"]
["1.1.9","Support classification of short term and long term assets  for supporting aging of receivables  or current year income and deferred income  based on due dates","1  -> Must have"]
["1.1.10","Support user defined customer payment plan","1  -> Must have"]
["1.1.11","Supports multiple due dates/Multi year payment plan for a single receivable (Ex: 1M with 200K to be received over the next 5 years ) i.e. ability to schedule receivables based on user defined parameter","1  -> Must have"]
["1.1.12","Automatic discount calculation based on payment plan and amount (This option might be useful for application of cash surplus)","3  -> Important"]
["1.1.13","Supports multiple banks and bank accounts for receiving payments ","1  -> Must have"]
["1.1.14","Support real-time update of the transactions","1  -> Must have"]
["1.1.15","Support multi currency transactions","1  -> Must have"]
["1.1.16","User defined option for  detail or summary  GL Posting.","1  -> Must have"]
["1.1.17","Fully integrated with the GL/FA and allow drill down to the transactions and invoice details","1  -> Must have"]
["1.1.18","System security based on organizational/legal entity control ","1  -> Must have"]
["1.1.19","Automated workflow - A/R automatically updates and sends message to the General Accounting group that a transaction has taken place ","1  -> Must have"]
["1.1.20","Allocation of receipts against predefined order of receivable regardless of payment advice received from State Party","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Customer Details","N/A","N/A"]
["1.2.1","Maintain a customer table with the following data: 1) Name 2) Multiple addresses,3) Multiple contacts, including name, location, title, phone and fax","1  -> Must have"]
["1.2.2","Maintain User-defined customer types and classifications(State Party, Employee, Other UN Organisation)","1  -> Must have"]
["1.2.3","Maintain a summarized history of all customers","1  -> Must have"]
["1.2.4","Supports one customer with multiple locations/addresses/currencies ","1  -> Must have"]
["1.2.5","Supports maintaining customer group(State Party, Employee, Other UN Organisation)","1  -> Must have"]
["1.2.6","Supports default account distributions for posting by customer or customer group ","1  -> Must have"]
["1.2.7","Supports creation of one time customer","1  -> Must have"]
["1.2.8","Supports user defined workflow for the approval of customer master","1  -> Must have"]
["1.2.9","Support tracking  of correspondence with customers.","1  -> Must have"]
["1.2.10","Allow customer record for a vendor( a Member State can be a vendor or service provider)","1  -> Must have"]
["1.2.11","Audit trail for any changes to the  customer master file - it should show the information before the change, indicate what was changed, who changed it and the new information ","1  -> Must have"]
["1.2.12","Facility to inactivate customers","1  -> Must have"]
["1.2.13","Payment history from 1993 onwards","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Accounts Receivable Transactions(Assessed contribution, Invoice, Receipts/Adjustment)","N/A","N/A"]
["1.3.1","Identify each transaction through manual/automatic number generation","1  -> Must have"]
["1.3.2","Supports user defined workflow of approval for routing of the transactions  based on the transaction type","1  -> Must have"]
["1.3.3","Supports searching  a  receivable document by Customer ID or number, customer name, partial name or sounds like name, transaction number","1  -> Must have"]
["1.3.4","Supports receivables based on  assessment % split between Member States and recognize revenue in an automated transaction","1  -> Must have"]
["1.3.5","Facility to apply the cash surplus based on  user defined criteria ( Receipt of arrears up to certain period)","1  -> Must have"]
["1.3.6","Maintain history of  application of cash surplus by customer","1  -> Must have"]
["1.3.7","Supports creation of  receivables document/invoice for assessed contributions","1  -> Must have"]
["1.3.8","Supports generation of assessment letters for Member State Accounts Receivable in the receiving country's currency (internal invoice letter with multiple currencies)","1  -> Must have"]
["1.3.9","Calculation of cash surplus impact on assessed contributions calculated by system and reflected in assessment letters and reminders","1  -> Must have"]
["1.3.10","Allow upload of assessed contribution scale with system calculating each State Party's  allocation & invoice generation.","1  -> Must have"]
["1.3.11","Supports  automated reminders based on days outstanding (Ex. 30/60/90/120/180 days) through word document and incorporating details of previous payments","1  -> Must have"]
["1.3.12","Supports  issue of assessment letters / invoices in multiple languages(English,French,Spanish,Russian,Arabic,Chinese) based on the receiving customer's language","1  -> Must have"]
["1.3.13","Supports inter fund receivables and payable in a linked transaction  to recognise inter fund revenue based on the Fund type (Ex. program support costs)","1  -> Must have"]
["1.3.14","Linkage of customer accounts to same accounts payable - same master data record.","1  -> Must have"]
["1.3.15","Creation of automatic invoice(Article IV &V)  in draft status  for  new reimbursable  cost items related to inspection  in PO/Obligation documents based on a pre-defined criteria such as account code, mission code etc. To include non-financial info from travel system (e.g. mission code, staff names, duration and dates of visit) & single mission code identifier.","1  -> Must have"]
["1.3.16","Include standard costs in article IV/V invoices (e.g. fixed salary cost per day)","1  -> Must have"]
["1.3.17","One report for all costs incurred on a mission (currently several needed for different expenses)","1  -> Must have"]
["1.3.18","Supports  batch invoice creation from excel/csv file.","1  -> Must have"]
["1.3.19","Facility to generate invoice in word/pdf file in a predefined format (incl foreign VAT), complete with CMS reference.","1  -> Must have"]
["1.3.20","Facility to generate note verbale (receipt voucher) in word/pdf file in a predefined format, complete with CMS reference","1  -> Must have"]
["1.3.21","Support manual entry or automatic  upload of cash receipts and adjustments with GL accounts and effective dates (use of unique identifier to match payment and AR automatically)","1  -> Must have"]
["1.3.22","Supporting  posting of incoming cash to a suspense account until the proper application is known","1  -> Must have"]
["1.3.23","Supports debit memo and credit memo transactions","1  -> Must have"]
["1.3.24","Supports distribution of all cash receipts to multiple customers or accounts or fund code (Trust fund/Special fund)","1  -> Must have"]
["1.3.25","Supports distribution of all cash receipts to cover multiple invoices( Adjustment of  customer credit documents with debit documents)","1  -> Must have"]
["1.3.26","Facility to write comments  with cash transactions","1  -> Must have"]
["1.3.27","Facility to record transaction which is to be applied to future periods or charges (i.e. receipts in advance and revenue posting for future period revenue)","1  -> Must have"]
["1.3.28","Supports entry of full receipts or partial receipts  by invoice","1  -> Must have"]
["1.3.29","Supports  notification to be sent to the relevant user to advise that a receipt has been recorded and needs further action ","1  -> Must have"]
["1.3.30","Supports an automated reserve for write down on receivables over a certain age (Ex. 2 Years) and generation of report & letter summarising amounts for DG approval","1  -> Must have"]
["1.3.31","Allow drill-down in system to view all transactions per customer.","1  -> Must have"]
["1.3.32","Facility to support cheque payments","1  -> Must have"]
["1.3.33","Automated posting of Article IV/V expenses to AR suspense account.","1  -> Must have"]
["1.3.34","Ability to automate invoicing of fixed asset sales (from FA module)","1  -> Must have"]
["1.3.35","Ability to create Accounts Receivable and recognize amount as a payable in a situation where OPCW  is acting as an agent to acquire 3rd party services. ","1  -> Must have"]
["1.3.36","Post VAT expense/payable directly to trust fund accounts","1  -> Must have"]
["1.3.37","Automated rental invoices with annual payment schedule and link to RPI increases (allow automated indexation of rent).","1  -> Must have"]
["1.3.38","Delegate an individual expenses flagged to AR suspense account (with event code and person) to allow invoicing to Member States","1  -> Must have"]
["1.3.39","Functionality to deal with UNDP cash advances, staff receivables and prepayments to vendors.","1  -> Must have"]
["1.3.40","Functionality to deal with advance payments to implementing partners (e.g. UNOPS).","1  -> Must have"]
["1.3.41","Automatically match receipts to AR","1  -> Must have"]
["1.3.42","Allow easy allocation of overheads to customers (e.g. Art IV/V)","1  -> Must have"]
["1.3.43","Automatically post receivable for Art IV/V expenses incurred","1  -> Must have"]
["1.3.44","Automated invoice generation and posting","1  -> Must have"]
["1.3.45","Automatically post 7% Program Support Cost  revenue/expense when posting expenses in Restricted Fund (Trust Fund); tagging of account/fund to determine if functionality used.","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.4,"Trust Fund/Special fund","N/A","N/A"]
["1.4.1","Supports maintain conditions and phases of Receivables for  Trust Fund/Voluntary Contributions (ex: committed, received, implemented)","1  -> Must have"]
["1.4.2","Supports expiration notifications based on the phases of Trust Fund/ Voluntary Contributions  (Ex. 30 days prior to expiration by Phase ex: committed, received, implemented )","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"Invoice Controls","N/A","N/A"]
["1.5.1","Hold  application of cash surplus at customer level  for those who did not clear arrears ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Customer Portal","N/A","N/A"]
["1.6.1","Customer and internal resources can  access the status of Invoice/receipts through self service","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.7,"Report Capabilities","N/A","N/A"]
["1.7.1","Supports periodic/monthly accounts receivable arrears / aging reports by Member State /Other customers","1  -> Must have"]
["1.7.2"," Provide past due reporting by receivable type","1  -> Must have"]
["1.7.3","Facility to produce a daily, weekly, or monthly detailed cash/bank receipt journal","1  -> Must have"]
["1.7.4","Facility to prepare monthly receipt summary showing total receipts","1  -> Must have"]
["1.7.5","Outstanding/Open  receivable invoices for a user-defined period ","1  -> Must have"]
["1.7.6","Produce an accounts receivable aging reports by 1)user-defined time buckets 2) Either by invoice date or  due date ","1  -> Must have"]
["1.7.7","Supports generation of report on voting eligibility by country based  on the arrears payment","1  -> Must have"]
["1.7.8","Supports tracking of prepaid, receivables and advances.","1  -> Must have"]
["1.7.9","Supports track and report on exchange rate gains and losses  for AR and Deferred Revenue","1  -> Must have"]
["1.7.10","Supports automated currency valuations (Ex. On a monthly basis) of Balance sheet accounts ","1  -> Must have"]
["1.7.11","Supports automated accrual  based on goods and services received but not yet invoiced","1  -> Must have"]
["1.7.12","Customer account statement report (showing AR and AP)","1  -> Must have"]
["1.7.13","Customer summary report (Assessed Contribution, current and outstanding, last payment made, voluntary contributions and reimbursement for other invoices)","1  -> Must have"]
["1.7.14","Integrated reporting to show all receivables by SP","1  -> Must have"]
["1.7.15","Voting rights by SP report based on number of years in arrears","1  -> Must have"]
["1.7.16","Auto linking to scanned expense claims (hyperlink) in article IV/V report","1  -> Must have"]
["1.7.17","VAT report in correct format for Dutch tax authorities and overseas suppliers, with hyperlink to supporting invoices.","1  -> Must have"]
["1.7.18","Donor and management reporting for Trust Funds - bespoke reporting needed.","1  -> Must have"]
["1.7.19","Generate report by donor and their past payment dates for forecasting timing of future payment for cash inflow projection.","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.8,"Trust funds","N/A","N/A"]
["1.8.1","Indicate contracts with conditions (through checkbox) and link revenue to expenses depending on whether conditions present.","1  -> Must have"]
["1.8.2","Ability to charge 7% Program Support Cost (PSC) to all Trust Fund (TF) expenditure (automated with expense recognition).","1  -> Must have"]
["1.8.3","Integration of grants management module with AR/AP","1  -> Must have"]
["1.8.4","Multi-year modality with separate budget rules to GF0.","1  -> Must have"]
["1.8.5","Contract start/end date fields","1  -> Must have"]
["1.8.6","Reporting timetable function.","1  -> Must have"]
["1.8.7","Allocation of common costs and income across funds (e.g. bank charges/interest).","1  -> Must have"]
["1.8.8","Business rule tailoring for specific conditions (e.g. whether bank interest can be retained or is repayable to donor).","1  -> Must have"]
["1.8.9","Accrual and commitment accounting functionality.","1  -> Must have"]
["1.8.10","Allow fund/pool transfers","1  -> Must have"]
["1.8.11","Allocation of expenses across countries based on percentage contribution to fund/individual fund balance.","1  -> Must have"]
["1.8.12","Supports generation of statement of account  for each member state country to show breakdown of movement in all trust funds.","1  -> Must have"]
["1.8.13","Forecasting functionality.","1  -> Must have"]

{"sheet":"4-TR","index":6,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[null,"Treasury","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","System integrated with AP/AR/GL/Payroll module","1  -> Must have"]
["1.1.2","User configurable accounting distribution  for GL posting ","1  -> Must have"]
["1.1.3","Transaction number will be generated manually or automatically","1  -> Must have"]
["1.1.4","Allow inter-fund transfers","1  -> Must have"]
["1.1.5","Supports multiple payment methods( Check, Cash, International Bank Transfer, SEPA)","1  -> Must have"]
["1.1.6","Support user defined accounting distribution for different payment methods","1  -> Must have"]
["1.1.7","Support different payment entities ( Vendor, Employee, Regular  payroll, Short Term payroll etc.)","1  -> Must have"]
["1.1.8","System to support transaction processes via correspondent bank","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Bank Details","N/A","N/A"]
["1.2.1","Facility to enter organisation's bank and  bank account details","1  -> Must have"]
["1.2.2","Supports multiple bank accounts/currencies","1  -> Must have"]
["1.2.3","Facility to maintain bank balance in bank currency and reporting currency or base currency","1  -> Must have"]
["1.2.4","Supports multiple  bank transfer formats(IBT,SEPA etc.) ","1  -> Must have"]
["1.2.5","Supports user defined accounting distribution for different bank accounts","1  -> Must have"]
["1.2.6","Facility to enter  Vendor Bank Details (Name on account, Country, Bank Number,BIC/Swift Code, Bank name, Branch name, Bank Account Number(IBAN number), IBAN Check Digit et)  for  employees and suppliers. Account Number should allow minimum 30 charcters","1  -> Must have"]
["1.2.7","Supports entering bank details of the different countries ( OPCW make transactions with 190 countries)","1  -> Must have"]
["1.2.8","Supports multiple vendor bank details for the same vendor","1  -> Must have"]
["1.2.9","Facility to enter multiple vendor location and address.","1  -> Must have"]
["1.2.10","Supports inactivation of bank accounts which are not used any more","1  -> Must have"]
["1.2.11","Supports inactivation of bank accounts when a staff member separate from the Organisation","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Treasury Transactions","N/A","N/A"]
["1.3.1","Facility to enter cash/bank  receipt transactions for the incoming payments","1  -> Must have"]
["1.3.2","Facility to attach scanned image/pdf files for the receipt transactions","1  -> Must have"]
["1.3.3","Recording of cash receipts automatically from bank ","1  -> Must have"]
["1.3.4","Supports different payment  transactions(Cash Payment/  Bank Transfer/ Check payment)","1  -> Must have"]
["1.3.5","Supports for generating or adding user defined payment reference  number to the payment transactions","1  -> Must have"]
["1.3.6","Supports Electronic Funds Transfer / Direct Deposit for employees ","1  -> Must have"]
["1.3.7","Support generating bank transfer details for the payments selected by the user","1  -> Must have"]
["1.3.8","Facility to print bank transfer details in pdf or similar format by bank account, payment method etc.","1  -> Must have"]
["1.3.9","Void any payment/ check (no longer payable by system), reverse original distributions and adjust the outstanding payment lists leaving a complete audit trail ","1  -> Must have"]
["1.3.10","Reinstate  invoice status(still payable by the system) when cancel a check/payment ","1  -> Must have"]
["1.3.11","Support grouping of payments based user defined criterion (Fund code, payable entity, payment methods etc.)","1  -> Must have"]
["1.3.12","Facility to upload bank statement","1  -> Must have"]
["1.3.13","Supports automatic bank reconciliation and clearance","1  -> Must have"]
["1.3.14","Facility to make manual bank clearance  by Bank Name, Bank Account, Payment reference number, Payment method","1  -> Must have"]
["1.3.15","Supports user defined work flow for payment processing/ cash/bank receipt transactions","1  -> Must have"]
["1.3.16","Supports bank transfer to the pre-paid Debit Cards through payment process.","1  -> Must have"]
["1.3.17","Supports calculation and accrual of interest on short term investments based pre-defined interest rate and duration of the investment ","1  -> Must have"]
["1.3.18","Allow posting of bank charges for one account across multiple trust funds based on average monthly balances.","1  -> Must have"]
["1.3.19","Allow posting of month/year-end currency revaluation for one account across multiple trust funds based on average monthly balances.","1  -> Must have"]
["1.3.20","Capacity to account for more complex financial instruments should OPCW diversify its investment policy (i.e. IPSAS 28-30; recognition, measurement and disclosure of main classes of financial instruments)","3  -> Important"]
["1.3.21","Ability to add field for credit rating of financial institutions and to update automatically from Rating Agency feed.","3  -> Important"]
["1.3.22","Functionality to support imprest accounts if needed.","3  -> Important"]
[null,null,"N/A","N/A"]
[1.4,"Payment Controls","N/A","N/A"]
["1.4.1","Supports cancel/reverse payments","1  -> Must have"]
["1.4.2","Support hold payments","1  -> Must have"]
["1.4.3","Prevent payment for inactivated vendors ","1  -> Must have"]
["1.4.4","Supports segregation of duties in Treasury","1  -> Must have"]
["1.4.5","Support both automated payment release and manual payment release, connected to e-banking system of the bank.","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"Report Capabilities","N/A","N/A"]
["1.5.1","Listing of individual cash receipts and deposits","1  -> Must have"]
["1.5.2","Daily cash activity by bank account","1  -> Must have"]
["1.5.3","Cash projection reporting ","1  -> Must have"]
["1.5.4","Cash projections by entity, bank, expected date, terms, history ","4  -> Nice to have"]
["1.5.5","Current cash availability ","3  -> Important"]
["1.5.6","Report on expected cash resources (AR,  miscellaneous cash, Voluntary contributions) ","2  -> Very important"]
["1.5.7","Report on expected cash uses (purchasing, AP miscellaneous cash) ","3  -> Important"]
["1.5.8","User defined report on maturity and value of short term investments","1  -> Must have"]
["1.5.9","Report on bounced back payment","3  -> Important"]
["1.5.10","Calculation and report on interest allocations by fund balance for pooled contributions","1  -> Must have"]
["1.5.11","IPSAS compliant cash reporting, indicating:\n- Restricted funds (Trust Fund or Special fund with specified conditions attached); and\n- Separate reporting of \"cash and cash equivalents\", and \"short-term investments\", based on investment length.","1  -> Must have"]
["1.5.12","Further IPSAS compliant cash reporting, indicating:\n- Credit risk per rating agency classification (e.g. Moody Investor Service Ratings P-1, B+ etc)\n- Liquidity risk tables ageing certain liabilities & integration with cash flow forecasting above.","3  -> Important"]
["1.5.13","Automated cash flow forecast statements for the  given fund code (General Fund, Trust fund etc)","1  -> Must have"]
["1.5.14","Support comparison of budgetary vs IPSAS cash flows (IPSAS 24, for presenting in Financial Statements).","2  -> Very important"]

{"sheet":"5-FA","index":7,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,"Fixed Assets","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","System integrated with Procurement/AP/AR/GL/EAM modules - fixed asset management and financial reporting should be integrated (i.e. no use of HardCat going forward).","1  -> Must have"]
["1.1.2","User configurable accounting distribution  for GL posting ","1  -> Must have"]
["1.1.3","Asset number generated manually or automatically with a predefined parameters","1  -> Must have"]
["1.1.4","Supports alpha numeric characters for asset number, minimum 12 characters","1  -> Must have"]
["1.1.5","Support multiple financial year and periods, 12 periods/financial year fixed asset reporting","1  -> Must have"]
["1.1.6","User defined fields for recording additional information of the assets","1  -> Must have"]
["1.1.7","Supports user defined asset location","1  -> Must have"]
["1.1.8","User defined minimum cost for asset capitalisation ( Currently 1000 EUR threshold) which may be adjusted by asset class.","1  -> Must have"]
["1.1.9","Tracking of all assets purchased, regardless of thresholds (for asset managament purposes), with business rules dictating IPSAS postings for asset capitalisation and IPSAS reporting.","1  -> Must have"]
["1.1.10","Restrictions on who may edit master data, approve transactions, etc","1  -> Must have"]
["1.1.11","Allow different asset recognition thresholds per asset category (e.g. 1,000 for acquired software, 50,000 for leasehold improvements).","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Depreciation / Amortization Setup","N/A","N/A"]
["1.2.1","User-defined depreciation / amortization calendars ","1  -> Must have"]
["1.2.2","Depreciation  / amortization options: year-to-date, period-by-period ","1  -> Must have"]
["1.2.3","Supports option to calculate depreciation / amortization  by selected methods such as straight line, declining balance, sum-of-the-years digits , accelerated","1  -> Must have"]
["1.2.4","Standard and user-controlled depreciation methods (i.e. based on asset category with ability to edit); ability to prospectively account for change in useful lives of assets (i.e. extension/reduction of useful life midway through ownership).","1  -> Must have"]
["1.2.5","First year conventions: actual period, half year, actual months, months after, modified half year, full year ","1  -> Must have"]
["1.2.6","Retirement year conventions: actual period, half year, actual months, months after, modified half year, full year ","1  -> Must have"]
["1.2.7","Allow different depreciation/amortization periods for the same asset class (e.g. leasehold improvements where Useful Life depends on length of lease)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Asset Category","N/A","N/A"]
["1.3.1","User defined asset categories(Inspection & Verification equipment, Security and Health Equipment, Furniture & Office Equipment,Vehicle,Hardware and IT Equipment, Acquired Software, Internally Developed Software, Asset Under Construction, software under development etc.)","1  -> Must have"]
["1.3.2","User configurable accounting distribution  for GL posting  by asset category","1  -> Must have"]
["1.3.3","Supports user defined useful life for each asset category and individual assets if required","1  -> Must have"]
["1.3.4","Supports user defined depreciation method for each asset category and individual assets if required","1  -> Must have"]
["1.3.5","Ability to identify leasehold improvements by location.","2  -> Very important"]
[null,null,"N/A","kkkkkN/A"]
[1.4,"Fixed Asset Transactions","N/A","N/A"]
["1.4.1","Record  asset masters details  (Asset number, Asset description, Barcode, Asset type, Asset class, Asset location, Asset serial number, Acquisition cost, Purchase order number, General Ledger account,sub-account,programme code, project code etc,Date of acquisition, In-Service date, Useful life/replacement date, Disposal information, Net book value, Year to date Depreciation / amortization, Life to depreciation, impairment)","1  -> Must have"]
["1.4.2","Personal assignment of assets, location and other asset management information to assist with asset stewardship.","2  -> Very important"]
["1.4.3","User defined fields for recording additional information of the assets (Invoice number, Division, Branch etc.)","1  -> Must have"]
["1.4.4","User defined status for asset ( Pending for disposal, Written off,Damaged,Obsolete etc.)","1  -> Must have"]
["1.4.5","Purchase of a fixed asset will automatically trigger an entry into the fixed asset system.  (through use of a material catalogue so that requisitioners do not make accounting decisions).","1  -> Must have"]
["1.4.6","Support work flow process with the purchase of a new fixed asset to ensure its entry into the fixed asset system is completed.","1  -> Must have"]
["1.4.7","Supports to maintain parent and child relationship between assets (i.e. facilitate componentisation but splitting assets into components with separate, definable useful lives and other characteristics).","1  -> Must have"]
["1.4.8","Supports creation of asset under construction (including services received, with dates of services received set through electronic Service Entry Sheets).","1  -> Must have"]
["1.4.9","Facility to capitalise asset under construction to a fixed asset.","1  -> Must have"]
["1.4.10","Supports Periodic(Monthly/Annual) Asset depreciation","1  -> Must have"]
["1.4.11","Supports periodic/annual asset inventory with results automatically posted to FAR (including overseas assets).","1  -> Must have"]
["1.4.12","Supports import /export asset inventory  from / or to  a portable computing / reading device(PDA) for taking asset inventory ","1  -> Must have"]
["1.4.13","Supports upward\\downward revaluation","1  -> Must have"]
["1.4.14","Supports retirement/disposal of asset","1  -> Must have"]
["1.4.15","Supports impairment of asset","1  -> Must have"]
["1.4.16","Supports asset write-off ","1  -> Must have"]
["1.4.17","Supports reversal of retirement","1  -> Must have"]
["1.4.18","Facility to simulate depreciation projection","1  -> Must have"]
["1.4.19","Support bulk upload of historical asset details","1  -> Must have"]
["1.4.20","Facility to integrate with third party software/ system  such as barcoding system, Asset maintenance system","1  -> Must have"]
["1.4.21","In-service date automatically set through online goods receipting process","1  -> Must have"]
["1.4.22","Manual asset creation within fixed asset register (e.g. for donated goods) with ability to post CR entry to revenue.","1  -> Must have"]
["1.4.23","Internally developed software - ability to collate all costs relating to a project to allow review of whether eligible for capitalisation, and if possible allocate to research and development stages. ","1  -> Must have"]
["1.4.24","Ability to assign full or partial personnel costs to project (intangible or fixed asset) in user-friendly, integrated method using e.g. timesheets.","2  -> Very important"]
["1.4.25","Ability to assign and keep records of initial costs, subsequent costs, fair value (in case of revaluation).","2  -> Very important"]
["1.4.26","Finance leases - link asset to finance lease liability upon recognition of asset/liability. Automatic calculation of Finance Lease liability based on asset fair value/present value of minimum lease payments as per IPSAS 13 (IAS 17).","2  -> Very important"]
["1.4.27","Ability to track operating lease assets and report on outstanding commitments at balance sheet date.","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.5,"Report Capabilities","N/A","N/A"]
["1.5.1","Asset register  by Asset, category, location ","1  -> Must have"]
["1.5.2","User defined reports","1  -> Must have"]
["1.5.3","Monthly/Annual depreciation/amortization report","1  -> Must have"]
["1.5.4","Current year and life-to date depreciation report","1  -> Must have"]
["1.5.5","Missing / not in use report","1  -> Must have"]
["1.5.6","Retirement, transfers, additions, deletions and changes","1  -> Must have"]
["1.5.7","Depreciation / amotization Journals","1  -> Must have"]
["1.5.8","Fixed Asset Journal","1  -> Must have"]
["1.5.9","Asset Disposal Report","1  -> Must have"]
["1.5.10","Full IPSAS compliant fixed asset and intangible asset notes comprising (per asset category for current and previous  year for comparison):\n- Opening balance (gross and net)\n- Opening accumlated depreciation & impairment\n- Additions (cost)\n- Disposals (cost)\n- Depreciation/amortization charge for year\n- Depreciation reversal for disposals\n- Impairment charge\n- Impairment reversal\n- Transfers\n- Exchange differences\n- Closing balance (gross and net)\n- Closing accumlated depreciation & impairment\n","1  -> Must have"]
["1.5.11","Capital commitment reporting","2  -> Very important"]
["1.5.12","Automated sub-legder - GL reconciliations","2  -> Very important"]
["1.5.13","Total expenditure in research phase of intangible assets","2  -> Very important"]

{"sheet":"6-Bud","index":8,"n_rows":150,"n_cols":5,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
[null,"Budgeting","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System and Policy Parameters"]
["1.1.1","Supports for a tight integration between the budget module and the General Ledger module","1  -> Must have"]
["1.1.2","Supports multiple budget scenarios (percentage increases/decreases, flat funding, etc.)","1  -> Must have"]
["1.1.3","Allows the definition of Proposed summary budget","1  -> Must have"]
["1.1.4","Allows the definition of Proposed detail budget","1  -> Must have"]
["1.1.5","Allows the definition of Approved budget","1  -> Must have"]
["1.1.6","Allows the definition of Allotment","1  -> Must have"]
["1.1.7","Supports maintenance of  details of adjustments between each budget level","1  -> Must have"]
["1.1.8","Supports integration with Human Resources module for staff positions","1  -> Must have"]
["1.1.9","Allows budgeting and forecasting data from the Human Resource module to be carried into budget work files","1  -> Must have"]
["1.1.10","Supports integration with Procurement and Travel modules","1  -> Must have"]
["1.1.11","Supports identification of Programme/Branch  staffing positions by the Position Control module","1  -> Must have"]
["1.1.12","Provides user-friendly budget view online/dashboards","1  -> Must have"]
["1.1.13","Provides Programme Managers to create their own building level budgets","1  -> Must have"]
["1.1.14","Provides Programme Managers to view budget during the entire budgeting process","1  -> Must have"]
["1.1.15","Provides Programme Managers  to track their budget ","1  -> Must have"]
["1.1.16","Provides detail and summary budget within the budget planning module","1  -> Must have"]
["1.1.17","Allows previous year’s budget to be carried into budget development files based on any element within the account code or in total","1  -> Must have"]
["1.1.18","Allows the previous year’s budget to be carried forward multiple times","2  -> Very important"]
["1.1.19","Provides the security to prevent programme manager  from accessing budget information not under their control at both application and data base levels.","1  -> Must have"]
["1.1.20","Allows data from various expenditure classifications (human resources/payroll, employee benefits, vendor payables) to be accessible for aggregation to various levels of summary","1  -> Must have"]
["1.1.21","Allows proposed budget amounts to be adjusted by fund, by individual element with the account structure or in total","1  -> Must have"]
["1.1.22","Supports a flexible budget based upon user-defined relationships among various accounts [module allows to pick data from different sources; idea of a Pivot Tables per programme]","1  -> Must have"]
["1.1.23","Provides automatic updates of the beginning budget fields for both revenue and expenditure accounts for the new fiscal year (both Trust Funds and General Fund)","1  -> Must have"]
["1.1.24","Allows multiple detail accounts to be associated with a single budgetary control account (regrouping detail accounts into one item, main funding object broken down into funding object).","1  -> Must have"]
["1.1.25","Provides the ability to enter specific budgeted amounts for each account by defined cost centre","1  -> Must have"]
["1.1.26","Allows transactions posted to detailed accounts to draw against the control level budget (funds sufficiency check at various levels)","1  -> Must have"]
["1.1.27","Allows distribution of budget amount by period or a percentage distribution of an annual budget figure by period","1  -> Must have"]
["1.1.28","Allows users to be restricted from accessing proposed budget amounts after they have been rolled into approved fields","1  -> Must have"]
["1.1.29","Provides an unlimited number of control accounts to be defined","2  -> Very important"]
["1.1.30","Allows the budget to be entered at the detail account level and the control account level detail will be consolidated automatically.","1  -> Must have"]
["1.1.31","Allows on-line inquiry for both available control account budget and detail account budget amounts for OPCW staff only.","1  -> Must have"]
["1.1.32","Allows on-line inquiry for all transactions posted to accounts","1  -> Must have"]
["1.1.33","Provides a variety of budgetary and comparative reports such as budget variance and comparative financial statements","1  -> Must have"]
["1.1.34","Provides full general ledger account budgeting ability","1  -> Must have"]
["1.1.35","Provides budget worksheets including actual numbers","1  -> Must have"]
["1.1.36","Provides the ability to upload and download budgets to an Excel spreadsheet in a number format including formulas for totals","1  -> Must have"]
["1.1.37","Provides the capability to import actual data into budget fields","1  -> Must have"]
["1.1.38","Permits budgetary data to be entered at the detail or summary level for “what if” analysis","1  -> Must have"]
["1.1.39","Provides a flexible account number hierarchy such as fund, category, program, object, sub-object,  cost centre (in OPCW current terminology it refers to the Account Key Structure (Fund Code, Funding Object, Programme Object, Cost-Centre, Donor/Country Code))","1  -> Must have"]
["1.1.40","Supports expenditure details by transaction, for each line item","1  -> Must have"]
["1.1.41","Provides support for automated budget forms for multiple approval levels","1  -> Must have"]
["1.1.42","Provides on-line budget transaction capability.","1  -> Must have"]
["1.1.43","Provides the ability to develop next year’s budget while the current budget is open","1  -> Must have"]
["1.1.44","Allows users to perform “what if” budget planning","1  -> Must have"]
["1.1.45","Provides the ability to access successive levels of budget detail; to view transactions from purchase requisition through liquidation of the encumbrance","1  -> Must have"]
["1.1.46","Allows users during budget creation to use drop down menus of budget codes","1  -> Must have"]
["1.1.47","Provides support for user-defined budget consolidation to accommodate reorganizations with the ability to provide comparisons to former organization structures (mapping).","1  -> Must have"]
["1.1.48","Provides  a roll-up capability from the lowest to highest level of budgeting","1  -> Must have"]
["1.1.49","Provides the ability to consolidate budgets by fund,  category, program, object, sub-object, location","1  -> Must have"]
["1.1.50","Provides the ability to budget revenues (allotment) as well as expenditures","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Budget Preparation","N/A","N/A"]
["1.2.1","Supports Budget worksheets ","1  -> Must have"]
["1.2.2","Supports  Budgeting tools integrated with system ","1  -> Must have"]
["1.2.3","Supports  Budget creation from historical budget, historical actual ","1  -> Must have"]
["1.2.4","Supports  Budget creation from historical budget/actual and percent increased and decreased ","3  -> Important"]
["1.2.5","Supports  Budget reports rolled up to a summary for management review ","1  -> Must have"]
["1.2.6","Supports  Trend reports from historical budgets, historical actuals ","1  -> Must have"]
["1.2.7","Supports  Variable budgeting based on: rates, standard costs (staff, travel, etc.), volumes, user-specified factors ","1  -> Must have"]
["1.2.8","Supports  Automatic budget projection from historical budget, historical actuals ","1  -> Must have"]
["1.2.9","Supports  Automatic update budget from projections ","1  -> Must have"]
["1.2.10","Supports  Multiple budgets: current and prior years ","1  -> Must have"]
["1.2.11","Supports  Multiple budgets: multiple versions of current ","1  -> Must have"]
["1.2.12","Supports  Multiple budgets: prior year revisions ","3  -> Important"]
["1.2.13","Supports  Budgets to actual reports online ","1  -> Must have"]
["1.2.14","Supports  Budget versus actual comparisons ","1  -> Must have"]
["1.2.15","Supports  Budget versus forecast comparisons ","1  -> Must have"]
["1.2.16","Supports  Calculation / creation of budget/forecast balances / records using data from multiple tables ","1  -> Must have"]
["1.2.17","Supports  Budget for same title/item over several months ","1  -> Must have"]
["1.2.18","Supports  Bypass a specified title/item from budget calculation ","1  -> Must have"]
["1.2.19","Supports  Provide on-line edit capability onto the budget/forecast master files to make top-line adjustments ","1  -> Must have"]
["1.2.20","Supports  Budget reports in format analogous to standard financial reports, but 12 months of data instead of one ","1  -> Must have"]
["1.2.21","Supports  customized reports which could be launched on standard operating system default ","2  -> Very important"]
["1.2.22","Supports  Produce the report rounded to EURO / hundreds / thousands ","1  -> Must have"]
["1.2.23","Supports  multiple budgeting cycles (for separate lines of business) ","3  -> Important"]
["1.2.24","Supports  Increase / decrease overheads by entering a percentage for specific account or for group of accounts ","3  -> Important"]
["1.2.25","Supports  Allocate an amount across accounts ","1  -> Must have"]
["1.2.26","Supports  allocation based on percentages, which are based on statistical account balances, such as head count, floor space, etc. ","1  -> Must have"]
["1.2.27","Supports  automatically inserted actual account balances into the elapsed months' buckets at the end of each accounting period when the system rolls into the next period ","1  -> Must have"]
["1.2.28","Supports  Roll actual information for the current accounting period into the future forecast bucket prior to the system rolling into the next accounting period ","3  -> Important"]
["1.2.29","Supports  Make changes to a future forecast bucket and then roll the future forecast into the current forecast - once established the budget / current forecast do not change - current forecast will only change when replaced by the future forecast ","3  -> Important"]
["1.2.30","Supports  Minimum of five budget / forecast files, including budget (Supports maintaining multiple version of the file ) ","1  -> Must have"]
["1.2.31","Supports  Minimum of five budget / forecast files, including current forecast ","1  -> Must have"]
["1.2.32","Supports  Minimum of five budget / forecast files, including next years' budget ","1  -> Must have"]
["1.2.33","Supports  Report against budget and current forecast and prior year actual (euro amount and percentage) ","1  -> Must have"]
["1.2.34","Supports  Allow more than one set of cross charge percentages (for the current year as well as forecast and future year) ","1  -> Must have"]
["1.2.35","Supports  Change the percentages mid year without changing the numbers retroactively which would result in already reported numbers changing ","1  -> Must have"]
["1.2.36","Supports  Automatically recalculate the budget / current forecast at the current exchange rate or at whatever rate is requested. (This recalculation is for reporting purposes only.) ","1  -> Must have"]
["1.2.37","Supports  Support an unlimited number of budget buckets (i.e.: this would allow the ability to retain more than one forecast and do variance analysis) ","3  -> Important"]
["1.2.38","Supports  Flexibility for forecasting selected business entities at different time frames ","3  -> Important"]
["1.2.39","Supports  Retention of historical data for minimum of 24 months ","1  -> Must have"]
["1.2.40","Supports comparisons, within a report, last year's actuals or budgeted to this year's actuals and budgeted","1  -> Must have"]
["1.2.41","Supports  Capability for user to download the file from the system, create a spreadsheet version of the file for manipulation and editing by other users, then upload altered file to the system ","1  -> Must have"]
["1.2.42","Supports  Maintain budget and forecast comparative data in the GL and sub ledgers for viewing and reporting for both balance sheet accounts and income statement accounts ","3  -> Important"]
["1.2.43","Supports  Restate the budget / forecast / prior year results at the current foreign exchange rate and quantify what the change is due to the change in foreign exchange rates ","3  -> Important"]
["1.2.44","Supports  Run actual, budget and forecast statements at the same time using different exchange rates ","3  -> Important"]
["1.2.45","Supports  Real time update (i.e., does not require batch processing to update) of budget generation ","1  -> Must have"]
[null,null,"N/A","N/A"]
["1.3","Budget Setup","N/A","N/A"]
["1.3.1","Supports budgeting for selected balance sheets/income statements accounts","1  -> Must have"]
["1.3.2","Supports Budgets for  multiple account types: income, expense, liability, asset","1  -> Must have"]
["1.3.3","Supports multiple budgets per account ","1  -> Must have"]
["1.3.4","Supports Budgeting periods: monthly, quarterly, annually, or user-defined ","1  -> Must have"]
["1.3.5","Supports generation of financial statements with budgets. Cash based budgeting with option to shift to accruals based. ","1  -> Must have"]
["1.3.6","Supports to pro-rate annual budget into quarterly, monthly, or user-defined accounting periods ","1  -> Must have"]
["1.3.7","Supports to pro-rate quarterly budget into monthly accounting periods ","1  -> Must have"]
[null,null,"N/A","N/A"]
["1.4","Budget Allotment","N/A","N/A"]
["1.4.1","Supports allocation processing with budgets ","1  -> Must have"]
["1.4.2","supports budget distribution from high level to detail by account groups, organizational units, departments, product lines, projects ","1  -> Must have"]
["1.4.3","Supports budget distribution by proportional allocation to accounts/other groups ","1  -> Must have"]
["1.4.4","Supports budget allotment distribution by user defined percentage or by amount (eg. Certain percentage of the budget to be kept aside for cost related to support)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"Budget Control","N/A","N/A"]
["1.5.1","Supports user-defined budgetary control rules at any account structure component, at any combination of levels ","1  -> Must have"]
["1.5.2","Supports budgetary control rules by document source, by document type  (Purchase Request, Purchase Order, invoice etc.), by user, by fund, by programme, sub-programme","1  -> Must have"]
["1.5.3","Supports user-set control tolerances and overrides ","1  -> Must have"]
["1.5.4","Supports flexible period intervals ","2  -> Very important"]
["1.5.5","Provides real time access of transaction activity from all other financial modules, including pre-encumbrance,encumbrance,disbursement accounting from the purchase request, purchase order creation and accounts payable modules(s), as well as transaction accounting from other modules such as accounts payable, payroll, journal entry,","1  -> Must have"]
["1.5.6","Provides facility to transfer budget from one detail account to another detail account/programme.","1  -> Must have"]
["1.5.7","Provides facility to make adjustments to existing allotment commitment/expenditure.","1  -> Must have"]
["1.5.8","Supports  automatic checking of  fund availability during purchase request, travel authorisation and invoice transaction.","1  -> Must have"]
["1.5.9","Supports  updating of POs requisitions/travel approved commitments/encumbrance ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Other Obligating Documents/Transfer Request","N/A","N/A"]
["1.6.1","Facility to make electronic request for obligating documenst by designated staff members with a user defined workflow( This is used for reserving fund SSA/TAC/STC recruitment )","3  -> Important"]
["1.6.2","Facility to make electronic request for miscellaneous obligating documents by designated staff members with a user defined workflow( This is used for reserving fund  for expenditure related to different events)","1  -> Must have"]
["1.6.3","Facility to make electronic request for fund transfer by designated  staff members with a user defined workflow( This is used for  tranfering allotment value from one fund to another)","1  -> Must have"]
["1.6.4","Supports user defined validation rule for fund trasfer (eg. Fund Transfer between Chapter 1 and 2 ar not alowed)","1  -> Must have"]
[null,null,"N/A","N/A"]
["1.7","Report capabilities","N/A","N/A"]
["1.7.1","Budget Planning Calendar","1  -> Must have"]
["1.7.2","Budget reports on demand","1  -> Must have"]
["1.7.3","Annual cash budget, with revenue and expenditure projections","3  -> Important"]
["1.7.4","Cash budget status reports","1  -> Must have"]
["1.7.5","Budget status reports (real time incl. Trust Funds)","1  -> Must have"]
["1.7.6","Provides Monthly and Quarterly budget report","2  -> Very important"]
["1.7.7","Provides    Statement of budgeted expenditures compared to actual expenditures for the fiscal year, daily, monthly, quarterly","1  -> Must have"]
["1.7.8","Provides  Statement of estimated revenues compared to actual revenues for the fiscal year, monthly, and quarterly","1  -> Must have"]
["1.7.9","Provides Budget worksheets with all accounts and prior year budget amounts","1  -> Must have"]
["1.7.10","Supports Revenues and expenditures report by user accessible fields","1  -> Must have"]
["1.7.11","Provides Month-to-date totals for expenditures and encumbrances  showing unencumbered balance and percentage over and under budget ","1  -> Must have"]
["1.7.12","Supports creation of  customized budget reports with the use of queries","1  -> Must have"]
["1.7.13","Supports availability of donor reports in PDF format (as they cannot be amended, in particular important for Official Reports)","1  -> Must have"]
["1.7.14","Supports exporting reports to Excel in number format & incl. formulas","1  -> Must have"]
["1.7.15","Provides real time reports, as oppose to overnight reports using yesterdays data, particularly useful nearing year-end when changes are made more often; so that one does not have to wait next day for the changes to be reflected.","1  -> Must have"]
["1.7.16","Reports for Obligations (incl. prior year obligations)","1  -> Must have"]

{"sheet":"7-Rec","index":9,"n_rows":151,"n_cols":5,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
[null,"Recruitment","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Supports automatic generation of Vacancy notice number based on predefined numbering format","1  -> Must have"]
["1.1.2","Ability to automatically generate the Closing date of the Vacancy Notice according to predefined number of days from the open date (e.g. closing date is in ,15,30 or 45 days)- Automatically count number of days for closing","2  -> Very important"]
["1.1.3","Facility to choose days working days/calendar days for determining the closing days","2  -> Very important"]
["1.1.4","Facility to send notification for various HR activities, Contract expiration (FT/STC) etc.  before certain predefined date criteria","2  -> Very important"]
["1.1.5","Automatic sending of confirmation letter to the applicant within predefined timeframe on completion of application submission","2  -> Very important"]
["1.1.6","Ability to generate reminders automatically when the vacancy closes","1  -> Must have"]
["1.1.7","Supports maintenance of predefined templates for regret/confirmation notifications","1  -> Must have"]
["1.1.8","System should be accessible internally and externally (Intranet\\Extranet)","1  -> Must have"]
["1.1.9","Supports automatic generation of Employee number ","2  -> Very important"]
["1.1.10","Supports role based security allows access for multiple users with different security levels simultaneously.","1  -> Must have"]
["1.1.11","Supports integration with travel system (Interview Travel/Employee COB)","1  -> Must have"]
["1.1.12","Facility for Recruitment administrators to make changes in the PHF (Application Template) format.","1  -> Must have"]
["1.1.13","Facility to notify applicants regarding the data privacy and data protection ,data retaining policy.","2  -> Very important"]
["1.1.14","Facility to track to-do list for the HR recruitment team with effective tracking of the action taken. Eg( Dash board facility or Email Notification to Recruitment Email group)","2  -> Very important"]
["1.1.15","Support user friendly interface for recording transaction and reporting","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.2,"HR Planning","N/A","N/A"]
["1.2.1","Supports dissemination of HR guidelines and planning documentation","2  -> Very important"]
["1.2.2","Supports the assignment of  resources to programs (Ex. Including costing of positions and  approved budget)","2  -> Very important"]
["1.2.3","Supports the development of HR Plans including  future resource requirements for all entities (Ex: actions for existing Positions, and actions for Proposed Positions)","1  -> Must have"]
["1.2.4","Supports workflow approval of HR plans","1  -> Must have"]
["1.2.5","Supports multiple versions of the HR plan","1  -> Must have"]
["1.2.6","Supports the hiring manager to generate recruitment requests capturing standard position parameters","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Position Management","N/A","N/A"]
["1.3.1","Supports the creation, updating (including extension), redefinition, reclassification or abolishing of positions (fixed-term positions, temporary positions, local positions )","1  -> Must have"]
["1.3.2","Supports position parameters including for all contractual mechanisms (fixed-term positions, temporary positions and local positions/assignment for Country Offices):  Title, Position Number & Allotment number (funding source), Unit (HQ or Country Office), Location, Effective Date, Grade, Duration of position, Position Description, Classified grade,  Supervisor, 1st and 2nd levels etc.","1  -> Must have"]
["1.3.3","Facility to generate Position number/Job number automatically through predefined format by employment category","1  -> Must have"]
["1.3.4","Supports for identification of position cost by grade","1  -> Must have"]
["1.3.5","Supports for reclassification of a position while maintaining post history","1  -> Must have"]
["1.3.6","Supports the creation of organizational charts at the organisational level, Division, Branch, section","1  -> Must have"]
["1.3.7","Ability to define or add Job Descriptin for the position as note and attachment","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Vacancy Notice","N/A","N/A"]
["1.4.1","Facility to conduct Pre-vacancy tracking (Record details such as Cause of recruitment, Reference number, Post code, Post Owner, Available from, Start date, Comments)","1  -> Must have"]
["1.4.2","Ability to create Vacancy Notice (Post Level, Vacancy Ref., Branch, Division, Date/Closing Date, Job description, etc.) in multiple language","2  -> Very important"]
["1.4.3","Facility to preview the Vacancy Notice before publishing it.","1  -> Must have"]
["1.4.4","Ability to record/amend Job Description","1  -> Must have"]
["1.4.5","Allows to create obligation document integrated with Budget module","1  -> Must have"]
["1.4.6","User defined workflow for budget approval","2  -> Very important"]
["1.4.7","Supports ability to advertise Vacancy Notice","1  -> Must have"]
["1.4.8","Screening questions, drop-down menu should allow more than 300 characters","1  -> Must have"]
["1.4.9","Vacancy Notice details (e.g. Experience details) should be more than 300 characters","1  -> Must have"]
["1.4.10","Facility to publish vacancy notice internally and externally","1  -> Must have"]
["1.4.11","Facility to block visibility access  of internal vacancy to external candidates (Non OPCW Staff members)","1  -> Must have"]
["1.4.12","Ability to derive the Vcancy Notice from the Job description electronically - both Job description and Vcancy Notice stored electronically with signatures","1  -> Must have"]
["1.4.13","Automatic calculation salary for displaying in Vcancy Notice","2  -> Very important"]
["1.4.14","Facility advertise Vcancy Notice for different type of position/employment type (FT/TAC/STC/SSA)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"Applicant Self Service","N/A","N/A"]
["1.5.1","Applicant should be able to view the details of the Vacancy ( Post Level, Vacancy Ref., Branch, Division, Date/Closing Date, Job description, etc.)","1  -> Must have"]
["1.5.2","Applicant should be able to login into the system using email and password","1  -> Must have"]
["1.5.3","Ability  for  internal and external candidates to apply to vacancies electronically.","1  -> Must have"]
["1.5.4","Facility to record Personal details (Title, First name, last Name, Date of birth, Place of Birth, Marital status, Nationality, Citizenship, etc.)","1  -> Must have"]
["1.5.5","Facility to record contact details, Dependents information, Relatives, Language skills","1  -> Must have"]
["1.5.6","Facility to record Education skills, Computer skills, employment information, Additional information, References, add new fields","1  -> Must have"]
["1.5.7","Facility to view information in the format of Personal History Form","1  -> Must have"]
["1.5.8","Facility to attach Supporting documents ","2  -> Very important"]
["1.5.9","Supports  internal and external candidates to create and administer their own recruitment profile and permit electronic applications to vacancies, interfacing with social networks (e.g. LinkedIn)","2  -> Very important"]
["1.5.10","Ability to upload resumes from  Word, PDF files","2  -> Very important"]
["1.5.11","Ability to amend/modify PHF( Application) after applying up to the Vcancy Notice closing date","3  -> Important"]
["1.5.12","Ability to subscribe to the Vcancy Notice for the skills sets by the applicants ","3  -> Important"]
["1.5.13","Facility to configure PHF(Application) in a user defined format (OPCW template).","1  -> Must have"]
["1.5.14","Facility to see the status of the recruitment by the applicants ","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.6,"Application Screening and Selection","N/A","N/A"]
["1.6.1","Ability to add/create filter questions, define fields for additional information about candidates","1  -> Must have"]
["1.6.2","Supports the sorting of candidates through specific screening questions","1  -> Must have"]
["1.6.3","Supports pre-screening of candidates through specific screening questions/skills criteria. Eg. Education , Language skills","2  -> Very important"]
["1.6.4","Supports ability to view information about applicants and attached documents","1  -> Must have"]
["1.6.5","Ability to make comments/remarks  by HR administrators on candidates","1  -> Must have"]
["1.6.6","Facility to make evaluation matrix. User should be able to assign weights and indicative scores to each relevant competency, test/interview results. Some questions have weights, percentage, coloured fields (if an applicant is eligible or not)","1  -> Must have"]
["1.6.7","Supports testing of candidates in multiple languages and recording/reporting results","1  -> Must have"]
["1.6.8","Facility to sort/screen candidate according to their scores ","1  -> Must have"]
["1.6.9","Ability to generate notifications to shortlisted/not-shortlisted candidates","1  -> Must have"]
["1.6.10","Allows to amend predefined templates for notifications","1  -> Must have"]
["1.6.11","Ability to record assignments/tests for selected candidates","1  -> Must have"]
["1.6.12","User defined multi-step workflow for conducting interviews","1  -> Must have"]
["1.6.13","Ability to update status after panel meeting","1  -> Must have"]
["1.6.14","Supports repository of all applicants' CVs and Supports talent pool searches (of both internal and external individuals) by key criteria and position attributes","1  -> Must have"]
["1.6.15","Supports a roster of candidates for all posts (e.g. Including internal staff, pre-screened and external talent pool candidates) ","1  -> Must have"]
["1.6.16","Supports electronic interaction between the candidates and the HR administrator on specific recruiting processes.","1  -> Must have"]
["1.6.17","Supports electronic interaction between the hiring manager and the HR administrator on specific recruiting processes.","1  -> Must have"]
["1.6.18","Supports hiring mangers/post owners to monitor and track their particular recruitment processes.","2  -> Very important"]
["1.6.19","Supports generating notification to stakeholders involved in specific tasks required for their action on a particular recruiting process. ","2  -> Very important"]
["1.6.20","Supports maintaining  the repository of pdf documents from both candidates (internal or external) and parties involved (HR administrator and hiring manager) in the recruiting process.","1  -> Must have"]
["1.6.21","Supports  ability to capture multiple recruitment processes (Ex. Different categories of personnel)","1  -> Must have"]
["1.6.22","Supports Electronic Interview reports with signatures of panel members","2  -> Very important"]
["1.6.23","System supports  mobile and handheld devices such as tablets, IPad  for updating selection reports by the interviewers electronically ","4  -> Nice to have"]
["1.6.24","Ability to track applicants based on the qualification, skills, competency. (E.g.. Candidates with Civil Engineering Degree, etc)","2  -> Very important"]
["1.6.25","Facility to attach  external testing result to the candidate's profile","2  -> Very important"]
["1.6.26","Facility generate interview report automatically by selection data from the Vacancy Notice","2  -> Very important"]
["1.6.27","Facility to record Note Verbal(Memo) received from State Parties","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.7,"Appointment","N/A","N/A"]
["1.7.1","Supports process hiring and prepare offers","1  -> Must have"]
["1.7.2","Supports generation of appointment notifications in accordance with contract type using templates","1  -> Must have"]
["1.7.3","Supports user configuration of  appointment notifications through the addition or deletion of specific criterion (i.e.: benefits applicable to one person but not another, despite having the same contract type).","1  -> Must have"]
["1.7.4","Supports electronic on boarding process that will permit the selected candidate to complete appointment procedures.","1  -> Must have"]
["1.7.5","Supports interface with the budget and finance module to update relevant information on new employees.","1  -> Must have"]
["1.7.6","Supports role based security allows access to multiple users with different security levels and simultaneously.","2  -> Very important"]
["1.7.7","The system shall determine entitlements on appointment of short-term contracts based on contract length (90 days or less; <12 months; >6 months) for purpose of PF participation, partial or full health insurance coverage, shipment entitlements/lump sum, etc.","2  -> Very important"]
["1.7.8","Supports electronic approval / signatures for the appointment (this task is performed by senior management)","2  -> Very important"]
["1.7.9","Supports access to the system through the internet/intranet","1  -> Must have"]
["1.7.10","Ability to verify previous employment history including performance of the former employees","2  -> Very important"]
["1.7.11","Ability to integrate with a pre-recorded video recruitment interview system (such as Cammio, Launchpad)","3  -> Important"]
["1.7.12","Facility to add flag to remove/archive dataset based on user defined format.","3  -> Important"]
["1.7.13","Ability to generate statistical data even after the  removal of the record.","3  -> Important"]
["1.7.14","Ability to generate Medical Questionnaire in predefined format by vacancy notice.","2  -> Very important"]
["1.7.15","Ability to generate security clearance form.","2  -> Very important"]
["1.7.16","Ability to generate consent form in predefined format by vacancy notice.","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.8,"Report Capabilities","N/A","N/A"]
["1.8.1","Generate rosters of applicants","1  -> Must have"]
["1.8.2","Listings of screened candidates","1  -> Must have"]
["1.8.3","Vacancy Summary","1  -> Must have"]
["1.8.4","Consolidated list of Status of Vacancies","1  -> Must have"]
["1.8.5","Status of Recruitment","1  -> Must have"]
["1.8.6","Personnel Grades","1  -> Must have"]
["1.8.7","Total No of experience","1  -> Must have"]
["1.8.8","Validation reports","1  -> Must have"]
["1.8.9","Post structure and Placements (as of date/ as of now)","1  -> Must have"]
["1.8.10","Job category by Contract Type","1  -> Must have"]
["1.8.11","Applicants from country by Applicant Name","1  -> Must have"]
["1.8.12","Staff members by Citizenship Country","1  -> Must have"]
["1.8.13","Assignment History","1  -> Must have"]
["1.8.14","Post history with Incumbents","1  -> Must have"]
["1.8.15","OPCW Post Structure and Placements (as of date)","1  -> Must have"]
["1.8.16","Composition of the Technical Secretariat by Division (As Of Date)","1  -> Must have"]
["1.8.17","Composition of the Technical Secretariat by Region and Nationality (As Of Date, Contract Type, Subtype, Job Category, Grade Type)","1  -> Must have"]
["1.8.18","Composition of the Technical Secretariat by Region and Nationality (As Of Date, Contract Type, Subtype, Job Category, Grade Type, Regional Group)","1  -> Must have"]
["1.8.19","Composition of the Technical Secretariat by Region and Nationality (As Of Date, Contract Type, Subtype, Job Category, Grade Type and Branch)","1  -> Must have"]
["1.8.20","Composition of the Technical Secretariat by Grade, Gender and Category (As Of Date, Contract Type, Job Category, Grade Type)","1  -> Must have"]
["1.8.21","Composition of the Technical Secretariat by Region and Nationality (As Of Date, Contract Type, Subtype, Job Category, Grade Type) EC-version","1  -> Must have"]
["1.8.22","Job Category and Grade by Gender (As Of Date, Contract Type, Job Category, Grade Type)","1  -> Must have"]
["1.8.23","Job Category by Contract Type (As Of Date, Contract Type, Job Category, Grade Type)","1  -> Must have"]
["1.8.24","Member States by Region (As Of Date, Representation Status)","1  -> Must have"]
["1.8.25","Applicants from Country by Applicant Name (Country, As Of Period, Period Mode)","1  -> Must have"]
["1.8.26","Staff Members by Primary Citizenship Country (As Of Date, Contract Type, Job Category, Country, SPA)","1  -> Must have"]
["1.8.27","Assignment History (Single Name)","1  -> Must have"]
["1.8.28","Post History with Incumbents (Post Title/ID)","1  -> Must have"]
["1.8.29","Applicants by Gender","1  -> Must have"]
["1.8.30","Applications by Region - Country","1  -> Must have"]
["1.8.31","Applications for Vacancy Announcement (Application Stage, Vacancy Reference)","1  -> Must have"]
["1.8.32","Staff Members by Primary Citizenship Country (Member States) with End Date (As Of Date, Contract Type, Job Category, Country, SPA)","1  -> Must have"]
["1.8.33","Vacancies posted (from to)","1  -> Must have"]
["1.8.34","Recruitment module and core HR module should be well integrated available for reporting.","1  -> Must have"]
["1.8.35","Facility to generate Note Verbale in predefined format for Vacancy Notice published","2  -> Very important"]

{"sheet":"8-EB","index":10,"n_rows":177,"n_cols":5,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
[null,"Entitlement & Benefits","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Fully integrated with the GL/AP/Budget/Recruitment/Payroll","1  -> Must have"]
["1.1.2","Allows the details to be predefined such as Rate Table, Rate Table Code e.g. Salary Scale, Medical Insurance Rate","1  -> Must have"]
["1.1.3","Supports user defined Assignment reason","1  -> Must have"]
["1.1.4","Supports user defined contract type (FT,TAC,STC,Consultants / Interns / Student Work Training / Short term language staff), employment type (P,GS,D)","1  -> Must have"]
["1.1.5","Facility to define user defined Personal action type (Step increment, Marital status, Dependency status)","1  -> Must have"]
["1.1.6","User defined workflow message notification to finance branch on completion of personal action","1  -> Must have"]
["1.1.7","Supports User defined pay group and pay elements","1  -> Must have"]
["1.1.8","Supports User defined  benefits plan","1  -> Must have"]
["1.1.9","Supports mass salary adjustments/updates by salary grade and by employment type (Profession  & General Services)","1  -> Must have"]
["1.1.10","Supports notification of all personnel actions","1  -> Must have"]
["1.1.11","Supports audit trail for all personnel actions including the identification of the user making the entry","1  -> Must have"]
["1.1.12","Ability to control mandatory fields when creating a new employee record","1  -> Must have"]
["1.1.13","Supports user defined leave type ","1  -> Must have"]
["1.1.14","Supports allocation of employee's earnings to more than one fund based upon percentages or hourly allocations.","1  -> Must have"]
["1.1.15","Supports user defined option to pay employees with or without time sheet entries","1  -> Must have"]
["1.1.16","Supports system guided workflow/validation for entering all mandatory details of new staff members before their status is active","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Appointment","N/A","N/A"]
["1.2.1","Supports generation of appointment notifications in accordance with contract type using templates","1  -> Must have"]
["1.2.2","Supports multiple employment contract types and must be able to generate letters of appointment, contract extensions, reassignment and transfer notices and separation documentation.","1  -> Must have"]
["1.2.3","Supports  version control by individual contract","1  -> Must have"]
["1.2.4","Supports version history by individual contract/assignment","1  -> Must have"]
["1.2.5","Supports alerts/notifications to  E&B  to process and approve contract creation, amendment and deletion. It will also verify eligibility for extension of appointments within established parameters (e.g. max contract length of  7 Years for  FT- P staff)","1  -> Must have"]
["1.2.6","Supports alerts/notifications and reports to all types of contract holders  (Ex. Short term professional contracts, medical examinations and clearance process)","1  -> Must have"]
["1.2.7","Supports clearance process prior to approving contract actions (recruitment, extensions)","1  -> Must have"]
["1.2.8","Supports recording Employee Assignment details (Primary assignment, End date, Occupancy, Time, Hours per week, Obligation number, Fund code, Ledger entity, Account Code, Programme Code etc.).","1  -> Must have"]
["1.2.9","Supports recording GL Distribution information (Fund code, Ledger entity, Account Code, Programme Code) for payroll accounting ","1  -> Must have"]
["1.2.10","Supports user-defined fields to capture additional information  (e.g. Obligation number, Reference Date)","1  -> Must have"]
["1.2.11","Supports recording Employee Employment details(Pay Status, Pay group, Work time, Employment type, Professional Category, Labour group, Time reporting method, Pay element Control Group  etc.)","1  -> Must have"]
["1.2.12","Allows integration for Time reporting method, Check Pay element Control Group with Payroll module","1  -> Must have"]
["1.2.13","Supports entering next increment date, EOD date","1  -> Must have"]
["1.2.14","Supports recording  Employee personal information (Birthdate, Birth country, Marital Status, Citizenship Country 1,Citizenship Country 2,  Employee Dependents, Contacts, Employee Address, etc.)","1  -> Must have"]
["1.2.15","Supports recording Employee Address details (Address1-Present address, Address2-Home leave Address, Address3-Place of recruitment, etc.)","1  -> Must have"]
["1.2.16","Supports recording Employee Dependents Contacts details (Dependent and Contact, Emergency contact, Relationship, Birthdate, Sex, Name (First, Last), Address(Address, Phone)","1  -> Must have"]
["1.2.17","Supports entering multiple dependents & contacts  such as Dependent type(Spouse, Son , Daughter etc.), Dependent name","1  -> Must have"]
["1.2.18","Ability to record spouse id","1  -> Must have"]
["1.2.19","Supports recording Employee Hire details (Employer, Hire date, First Name, Last Name, Position, Organisational Unit, Employment type, )","1  -> Must have"]
["1.2.20","Facility to attach documents (Employee Official Documents)","1  -> Must have"]
["1.2.21","Supports recording and reporting of changes in status for all contract types","1  -> Must have"]
["1.2.22","Supports storage and display employee photos","1  -> Must have"]
["1.2.23","Supports processing special post allowance (Establish, Discontinue)","1  -> Must have"]
["1.2.24","Facility to modify or amend prior assignment record with out modifying current assignment details( eg.Past FT details and current assignment )","1  -> Must have"]
["1.2.25","Hire and rehiring  of current staff members with future assignment start date , eg.SSA  contract details can be entered without depending  payroll processing  ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Entitlement & Benefits","N/A","N/A"]
["1.3.1","Supports the administration of defined benefit programs for employees with varying eligibility and contribution requirements  e.g. Employee Category (P,G) , joining date","1  -> Must have"]
["1.3.2","Supports maintenance of participant and dependent information such as Names, Birth dates,Gender,Relationship to employee/participant, status, effective date, end date etc.     ","1  -> Must have"]
["1.3.3","Supports calculation of the benefits amount based on the eligibility criteria , rate, period etc.","1  -> Must have"]
["1.3.4","Supports recording  salary and other earnings","1  -> Must have"]
["1.3.5","Supports recording  deductions such as staff association contributions, other deductions","1  -> Must have"]
["1.3.6","Supports recording of an employee’s pay status, Full time, Part time, Hourly ","1  -> Must have"]
["1.3.7","Supports processing Assignment Grant. ","1  -> Must have"]
["1.3.8","Supports processing (Establish, Discontinue) of predefined Benefit plans such as  DDI (Service and Non-Service), Optional Additional coverage NSDDI","1  -> Must have"]
["1.3.9","Supports processing  (Establish, Discontinue) of Dependency Allowance Higher Dependency Allowance for Disabled Child","1  -> Must have"]
["1.3.10","Facility to record Dependents details: Name, Dependent Code, Start date of Dependency allowance, Indicator of participation","1  -> Must have"]
["1.3.11","Supports processing ( Establish, Update/Early review, Discontinue) of Government Grant","1  -> Must have"]
["1.3.12","Supports processing of US tax reimbursements with supporting documents","1  -> Must have"]
["1.3.13","Ability to link covered dependent name with benefits  option assigned to him/her  from the predefined  list","1  -> Must have"]
["1.3.14","Supports processing Home Leave such as recording eligibility status, Availability Date","1  -> Must have"]
["1.3.15","Supports processing(Establish, Discontinue/Changes) Medical Insurance (Subsidised/Unsubsidised), ","1  -> Must have"]
["1.3.16","Supports computation of Rental Subsidy","1  -> Must have"]
["1.3.17","Supports workflow enabled employee personnel action processing for different type of entitlements","1  -> Must have"]
["1.3.18","Facility to record approval comments on employee personnel action form processing","1  -> Must have"]
["1.3.19","Automatically close pending personnel action processing once staff members separates","1  -> Must have"]
["1.3.20","Supports electronic processing Education Grant with proration by contract duration of the staff member or period of school attendance","1  -> Must have"]
["1.3.21","Facility to generate a warning message  for Education Grant if it is already reimbursed for the same period and facility to display calculation details","1  -> Must have"]
["1.3.22","Facility to maintain multiple version dependant's details","1  -> Must have"]
["1.3.23","Supports automatic computation of Government grant with proper proration","1  -> Must have"]
["1.3.24","Facility to display employee personal action form by types (Child Care/Education Grant, etc.)","1  -> Must have"]
["1.3.25","Facility to display employee personal action form details with dependant details in the overview","1  -> Must have"]
["1.3.26","Supports predefined format of printable  Employee Personal Actions Form ","1  -> Must have"]
["1.3.27","Facility to record  and process  rental subsidy entitlement ","1  -> Must have"]
["1.3.28","Supports automatic generation of Employee Personal Actions Form one month before separation with a possibility to cancel it if required and also facility to track in \"To do list\"","1  -> Must have"]
["1.3.29","Facility to  separately attach invoices and proof of payment for child care payments   and mandatory validation for both documents","1  -> Must have"]
["1.3.30","Facility to redirect  rejected  child care  claims to staff member for resubmission with correct documentation","1  -> Must have"]
["1.3.31","Supports payment of education grant directly to the schools","1  -> Must have"]
["1.3.32","Supports sending of notification to Staff Member once the payment process is completed","1  -> Must have"]
["1.3.33","Supports inquiry of historical data per entitlement to simplify or provide  user friendly approval processes","1  -> Must have"]
["1.3.34","Supports automatic Stopping/ Discontinuation of the Dependency Allowance (including Dependency rate of the Net Base Salary) pending provision of required documentation submission  by staff members","1  -> Must have"]
["1.3.35","Supports automatic Stopping/ Discontinuation  of Rental Subsidy pending provision of required documentation submission by staff members","1  -> Must have"]
["1.3.36","Supports automatic notification/reminder for submission of supporting documentation for the  entitlements such as  Dependency Allowance, Rental Subsidy etc.  with in  a user defined schedule ,period (e.g.. Quarterly, within 30 days of end date of the entitlement)","1  -> Must have"]
["1.3.37","Support for clearly defined duration (effective and end dates) of all entitlements with facility to send automatic notification before the end date of the entitlements","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Time and Attendance","N/A","N/A"]
["1.4.1","Supports defining leave eligibility for each type of leave by contract type","1  -> Must have"]
["1.4.2","Supports recording official holiday schedules","1  -> Must have"]
["1.4.3","Supports tracking leave entitlements by employee","1  -> Must have"]
["1.4.4","Supports tracking employee attendance history records","1  -> Must have"]
["1.4.5","Supports tracking leave details such as Sick leave, Family Leave, Maternity Leave, Paternity Leave, Home Leave, Annual Leave, Special Leave, CTO(Compensatory time off), Replacement Day etc.","1  -> Must have"]
["1.4.6","Supports user defined rules and policies (Leave, Time and attendance) by type  (e.g.. Different entitlement rule for different leave types) ","1  -> Must have"]
["1.4.7","Supports workflow enabled leave management and provides quick and easy leave request and authorisation, and maintenance of leave balance","1  -> Must have"]
["1.4.8","Facility to process leave without pay.","1  -> Must have"]
["1.4.9","Supports automatic calculation/updating of  employee’s leave accruals according to defined policies and record  Projected start and end dates, Actual start and end dates, Reason for leave, Leave balances, Leave accruals, Leave entitlements, Leaves taken, Carry-over etc.  for each employee","1  -> Must have"]
["1.4.10","Supports workflow notification when leave  request created, approved to  the respective stakeholders","1  -> Must have"]
["1.4.11","Supports maintenance of leave history with details  such as Start and end dates, Reasons for leave","1  -> Must have"]
["1.4.12","Supports year-end roll-over calculation and process for leave type and processes","1  -> Must have"]
["1.4.13","Supports facility for leave adjustment","1  -> Must have"]
["1.4.14","Supports calculation of leave without pay automatically for payroll processing","1  -> Must have"]
["1.4.15","Supports  planning of shift workers schedule","1  -> Must have"]
["1.4.16","Supports employee scheduling  based on  availability, shift preferences, response statistics","1  -> Must have"]
["1.4.17","Supports different type of  work shift  Rotating (days, nights, afternoons), Day on, day off,  Continual shifts","1  -> Must have"]
["1.4.18","Supports shift exchanging","1  -> Must have"]
["1.4.19","Supports calculation of  overtime and night differential automatically for payroll processing","1  -> Must have"]
["1.4.20","Supports recording of time and attendance for FT,STC,TAC,SSA etc.","1  -> Must have"]
["1.4.21","Supports user defined workflow for start/stop car parking deduction (Allow more than one car)","1  -> Must have"]
["1.4.22","Supports overtime to be blocked at 40 hours per month an employee, More than 40 hours to be routed for additional approval from HR department","1  -> Must have"]
["1.4.23","Supports scheduling of shift work","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"Employee Review/Status","N/A","N/A"]
["1.5.1","Ability to generate automatically Review date and Review end date from Contract start date","1  -> Must have"]
["1.5.2","Facility to record Performance rating, comments","1  -> Must have"]
["1.5.3","Ability to view Employee Status (re-hire employee, hire date, Position ID)","1  -> Must have"]
["1.5.4","Allows for recording Dependency review details (Review Date, Review Status, Review Type, Review Period Begin, Review Period End, Reviewing Manager ID)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Extensions, Separation/Resignation, Promotion","N/A","N/A"]
["1.6.1","Supports tracking of contract expiration","1  -> Must have"]
["1.6.2","Facility to record Termination Date, Reason, Pay-through-date, Pay status","1  -> Must have"]
["1.6.3","Ability to update information for Medical Insurance, Medical Insurance for terminated staff","1  -> Must have"]
["1.6.4","Facility to make electronic submission of  Check out form different employment type (FT,STC,TAC,SSA,etc)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.7,"Employee Self-Service","N/A","N/A"]
["1.7.1","User friendly interface with dashboard facility  to view and request all  Benefits & entitlements","1  -> Must have"]
["1.7.2","Supports self-service management, allowing staff members to update and use employee-specific information, online via a browser, that is personalized to an individual's role, experience, work content, language, and information needs","1  -> Must have"]
["1.7.3","Supports capture of evidence of some aspects of personal information (Ex. Marital status, birth certificates, adoption, divorce, death, educational background) and will allow the upload of Supporting documentation","1  -> Must have"]
["1.7.4","Supports  initiation of education grants (Regular requests and special education grants for disabled children) ","1  -> Must have"]
["1.7.5","Supports validation to prevent submit request for Education Grant Advances if previous advance has not been settled (including notification)","1  -> Must have"]
["1.7.6","Facility to view education grant calculation details once payment is processed or approved","1  -> Must have"]
["1.7.7","Supports changes in staff member bank details with validation check for SEPA (e.g. Swift Code, IBAN Number) and interface any changes to payroll","1  -> Must have"]
["1.7.8","Supports request for salary advances ","1  -> Must have"]
["1.7.9","Supports requests for all leave types  (Ex. annual leave, advance leave, home leave, leave without pay, leave with full or partial pay, sick leave, sick leave under insurance cover, family leave or family emergency leave , maternity and paternity leave) ","1  -> Must have"]
["1.7.10","Supports reporting of compliance training and initiate requests/reminders","1  -> Must have"]
["1.7.11","Supports initiate requests and send reminders for action against all self-service fields","1  -> Must have"]
["1.7.12","Supports reporting on the status of all information changes made by individuals.","1  -> Must have"]
["1.7.13","Supports  processing requests for reimbursement of allowable expenses","1  -> Must have"]
["1.7.14","Supports version control and self-service history","1  -> Must have"]
["1.7.15","Supports  requests for part-time work ( 80%,  60%, 50% etc.) for any combination","1  -> Must have"]
["1.7.16","Supports dashboard functionalities for tracking eligibility and status of entitlements.","1  -> Must have"]
["1.7.17","Supports staff members to make requests for different class of travel based on eligibility","1  -> Must have"]
["1.7.18","Supports automated requests for night differential, standby duty","1  -> Must have"]
["1.7.19","Staff Member and HR users can have an overview of CTO","1  -> Must have"]
["1.7.20","Supports Revision /Amendment of leave request","1  -> Must have"]
["1.7.21","Facility to make electronic requests for   SLWP / SPA / Resignations / change in HL / advance and deferred HL / salary advances","1  -> Must have"]
["1.7.22","Facility to make  electronic requests  for Makro / American Express card","1  -> Must have"]
["1.7.23","Facility to generate employment verification letter automatically with electronic signature","1  -> Must have"]
["1.7.24","Facility to make electronic submission of Dependency Review ","1  -> Must have"]
["1.7.25","Facility to make electronic submission of Checkout form by staff members with a user defined workflow","1  -> Must have"]
["1.7.26","Facility to make request by choosing Medical insurance category and duration (Upto 6months) for the separating staff ","1  -> Must have"]
["1.7.27","Facility to see child care calculation sheet by self service user/administrators(HRB/Payroll)","1  -> Must have"]
["1.7.28","Facility to make child care assistance request by choosing  name of the child, age and fill up the relevant information: hours/month, hours/week, amount paid, invoice number.","1  -> Must have"]
["1.7.29","Facility to make assignment grant request electronically with predefined eligibility rule and workflow, Also provide notification facility at different stage of the transaction","1  -> Must have"]
["1.7.30","Facility to make Non Removal lump sum request electronically with predefined eligibility rule, calculation and workflow, Also provide notification facility at different stage of the transaction","1  -> Must have"]
["1.7.31","Facility to make Hospitality claim request electronically  with a predefined workflow, Also provide notification facility at different stage of the transaction","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.8,"Report Capabilities","N/A","N/A"]
["1.8.1","List of active employees by category, division for given period or as on date","1  -> Must have"]
["1.8.2","Dependency review comparison","1  -> Must have"]
["1.8.3","Dependents having subsidised medical insurance and turning age25 as on date","1  -> Must have"]
["1.8.4","Dependents whose unsubsidised medical insurance expires as of given period","1  -> Must have"]
["1.8.5","List of  SPA(Special Post Allowance) assignment as of date","1  -> Must have"]
["1.8.6","Posts with SPA  and newly  hired  Non-SPA incumbents","1  -> Must have"]
["1.8.7","Posts with SPA and Non-SPA incumbents","1  -> Must have"]
["1.8.8","List  of primary dependents turning 18 as of period","1  -> Must have"]
["1.8.9","STC/TAC staff members whose contract expires as of period","1  -> Must have"]
["1.8.10","Staff members due to step increment as of period","1  -> Must have"]
["1.8.11","Staff members whose contract expires as of period  by contract type","1  -> Must have"]
["1.8.12","Staff members whose Non Service Incurred DDI category expires as of period  ","1  -> Must have"]
["1.8.13","Staff members whose probation period expires as of period  ","1  -> Must have"]
["1.8.14","Staff members whose rental contract details need to be updated.","1  -> Must have"]
["1.8.15","Reports on SSA's / interns / short term language staff ","1  -> Must have"]
["1.8.16","IPSAS 25 Reporting (Home Leave Education Grant Travel, Removal Cost, Repatriation Cost, Promotions, Death Benefits). In general, active population as of 31 December (including all details and history of contract), expected separation, benefits paid by year, terminated vested.  In particular, for short-term employee benefits (annual leave, sick leave, education grant, US tax) - cut off analysis as of 31 December, including advance payment, annual leave paid etc.  For long-term employee benefits (home leave) -  benefits paid and settled and unsettled amounts by year, entitled but not paid yet. For post employment benefits (repatriation grant, travel cost, removal cost) - estimated costs, terminated vested, benefit paid by year, separation and separated date.","1  -> Must have"]
["1.8.17","Reports on change in rental %","1  -> Must have"]
["1.8.18","Ad hoc reports on staff member details","1  -> Must have"]
["1.8.19","Ad hoc reports on benefits by staff member or groups","1  -> Must have"]
["1.8.20","Configurable and customisable reporting function based on specified user requirements (exportable to excel)","1  -> Must have"]

{"sheet":"9-Payroll","index":11,"n_rows":123,"n_cols":5,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[null,"PAYROLL","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Supports user defined pay period (Monthly, Bi-Weekly etc.)","1  -> Must have"]
["1.1.2","Facility to  setup payroll type and pay period with disbursal date.","1  -> Must have"]
["1.1.3","Supports maintaining master data of all employees - Personal Data with Basic Salary and other allowances applicable","1  -> Must have"]
["1.1.4","Supports maintaining unique master code for each employee from recruitment till retirement across the organisation even in case of transfers etc.","1  -> Must have"]
["1.1.5","Supports user defined rules for payroll calculation based on the employee entitlements(Percentage, Fixed Amount, Predefined Rate table etc.) with predefined eligibility and effective date","1  -> Must have"]
["1.1.6","Supports multiple bank accounts for employee for salary transfer by predefined  percentage","2  -> Very important"]
["1.1.7","Supports multiple bank accounts(Participant account A,B,C) for employee for provident fund transfer","1  -> Must have"]
["1.1.8","Supports different payroll group based on  the different entitlement of the staff members(FT/TAC/STC) ","1  -> Must have"]
["1.1.9","Supports configuration of United  Nations salary scale(USD,EUR)","1  -> Must have"]
["1.1.10","Supports conversion of applicable salary scale ( e.g. Professional salary scale)  from USD to EUR using monthly exchange rate and post adjustment factor","1  -> Must have"]
["1.1.11","Supports different categories of employees (Professional-International, Professional-Local, General- Service Local, General- Service International  and fixed term, Temporary, Short  term) tied to the currency they are paid","1  -> Must have"]
["1.1.12","Supports different salary scale depending on the individual Grade (P3- Step1,2 .., GS4-Step1,2..)","1  -> Must have"]
["1.1.13","Supports proration in calculation of  payroll based on the number of days worked by total number of working days/month (21.75 Days/Month)","1  -> Must have"]
["1.1.14","User defined option for  detail or summary  GL Posting of payroll journals.","1  -> Must have"]
["1.1.15","Fully integrated with the GL/AP/Budget and allow drill down to the transactions","1  -> Must have"]
["1.1.16","System security based on organizational/legal entity control and supports read only access for payroll staff to HR data","1  -> Must have"]
["1.1.17","Facility to process separating employee in different pay group(Exit Payroll) after the separation date.","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Pay Element Details","N/A","N/A"]
["1.2.1","Supports different pay element types(Earning, Deduction, Employer Cost, Calculation)","1  -> Must have"]
["1.2.2","Supports unlimited number of pay elements  both earning and deductions  (eg,Gross Salary,Dependance Allowance, Staff Assessment, Provident Fund Contribution, Subsidised Medical Insurance etc.) More details in the  Payroll Annex","1  -> Must have"]
["1.2.3","Supports differentiation of employee cost(Deduction) and employer cost ","1  -> Must have"]
["1.2.4","Supports activation or inactivation of pay elements with effective date","1  -> Must have"]
["1.2.5","Supports accounting distribution by pay elements","1  -> Must have"]
["1.2.6","Supports pay elements consolidation into earning statements","1  -> Must have"]
["1.2.7","Supports user to choose salary steps for short term and TAC in an exceptional circumstances based on pre-defined business rule.","1  -> Must have"]
["1.2.8","Supports alignment of pay element start and end date with EPAF action","1  -> Must have"]
["1.2.9","Supports a one-off agent fee payment  for rental subsidy","1  -> Must have"]
["1.2.10","Supports closure of pending EPAF upon separation of a staff member","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Payroll Control","N/A","N/A"]
["1.3.1","Supports retroactive calculation of repatriation grant","1  -> Must have"]
["1.3.2","Controls pay elements by start/stop dates ","1  -> Must have"]
["1.3.3","Calculation earning by multiplying factors( Post Adjust rate, Exchange Rate)","1  -> Must have"]
["1.3.4","Calculation of deduction by percentage of earnings","1  -> Must have"]
["1.3.5","Calculation of earning/deduction by fixed amount","1  -> Must have"]
["1.3.6","Calculation of deduction by  using user defined rate table","1  -> Must have"]
["1.3.7","Calculation of medical insurance cost(Employee/Employer contribution) by using user defined  percentage in rate table","1  -> Must have"]
["1.3.8","Calculation of medical insurance administration cost(Employee/Employer contribution)  by using user defined fixed amount in rate table","1  -> Must have"]
["1.3.9","Supports user defined eligibility rules by employee, grade, contract type etc.","1  -> Must have"]
["1.3.10","Block/Exclude employees whose entitlement records are being modified by HR department  from the payroll during that time","1  -> Must have"]
["1.3.11","Calculation of unsubsidised MI admin costs upon separation ","1  -> Must have"]
["1.3.12","Supports automatic calculation of SSA, SSA Inspectors fees, FT/STC/TAC","1  -> Must have"]
["1.3.13","Supports automatic calculation of overtime and CTO based on pre-defined business rule with restriction of maximum amount of overtime hours allowed in a given period","1  -> Must have"]
["1.3.14","Supports automated calculation of night differential, standby duty","1  -> Must have"]
["1.3.15","Supports automatic calculation of MI and NSDDI","1  -> Must have"]
["1.3.16","Supports validation of official travel and overtime claim date E.g. staff cannot claim overtime during duty travel.","1  -> Must have"]
["1.3.17","Supports automatic holding of 20% of salary in final payroll, when checkout form has not been submitted","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Payroll Processing","N/A","N/A"]
["1.4.1","Supports simulating payroll","1  -> Must have"]
["1.4.2","Error message for validating payroll master data(e.g.. User friendly Error message in case any master data is missing) also at recruitment level","1  -> Must have"]
["1.4.3","Facility to exclude selected employees from payroll processing.","1  -> Must have"]
["1.4.4","Supports payroll processing in different date by the payroll group( FT-Payroll, TAC-Pay roll,STC-Payroll)","1  -> Must have"]
["1.4.5","Supports retroactive calculation/payroll processing (e.g.. Salary scale change, Step Increment, etc.)","1  -> Must have"]
["1.4.6","Supports preparing bank transfer file for each employees with net payable amount.","1  -> Must have"]
["1.4.7","Support recurring monthly deductions with a defined limit","1  -> Must have"]
["1.4.8","Supports preparing bank transfer file for each employees with provident fund contribution amount to different participant accounts (A,B,C)","1  -> Must have"]
["1.4.9","Automatic liquidation of the encumbrance of commitment amount in funds control in case of TAC/STC/SSA payroll","1  -> Must have"]
["1.4.10","Automatic liquidation of the encumbrance of commitment amount in funds control - to be extended to FT payroll","1  -> Must have"]
["1.4.11","General ledger distribution of payroll transactions by pay elements","1  -> Must have"]
["1.4.12","Maintain payment history by employee, by pay period","1  -> Must have"]
["1.4.13","Supports facility to record additional comments on payslips","1  -> Must have"]
["1.4.14","Supports release of repatriation grant through payroll with automatic matching against obligation","2  -> Very important"]
["1.4.15","Supports calculation of medical insurance to be able to apply upon separation for any length of time, not just a flat month","1  -> Must have"]
["1.4.16","Supports Special leave without pay: ability for the system to  calculate non-service and medical  insurance during period at own expense of Staff Member including admin costs","1  -> Must have"]
["1.4.17","Supports Car parking deduction for more than one car","1  -> Must have"]
["1.4.18","Supports Electronic certification of services for all SSA's  , short term","2  -> Very important"]
["1.4.19","Supports pro-rating of government grant","1  -> Must have"]
["1.4.20","Supports user defined workflow for a checkout form","1  -> Must have"]
["1.4.21","Supports Electronic Workflow for establishment and discontinuance of car parking deduction (Allows more than one car parking per employee)","1  -> Must have"]
["1.4.22","Non-removal upon separation should be paid through final payroll","2  -> Very important"]
["1.4.23","Supports automatic calculation of MI and NSDDI in case of  Special leave without pay ","1  -> Must have"]
["1.4.24","Supports automatic calculation of medical insurance upon separation - any category for any length of time up to 6 months ","1  -> Must have"]
["1.4.25","Facility to give a warning message when staff member is on sick leave without pay (SLWOP) or due for separation","1  -> Must have"]
["1.4.26","Supports automatic calculation of childcare amount based on the predefined rule on Staff Salary,","1  -> Must have"]
["1.4.27","Facility to generate Invoice/PRV automatically for the calculated  child care payment","1  -> Must have"]
["1.4.28","Facility to send notification to Staff Members when the  child care transaction is processed","1  -> Must have"]
["1.4.29","Supports bulk upload of multiple  voucher  for child care transaction","1  -> Must have"]
["1.4.30","Supports retroactive calculation  of child care to take account of salary rate changes and other user defined parameters e.g. period","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"Internship Stipend Processing","N/A","N/A"]
["1.5.1","Facility to record internship key information electronically when the intern  ID profile is created: dates of contract, branch (account code), bank details, optional medical insurance.","1  -> Must have"]
["1.5.2","Supports calculation of stipend based  number of days of the intern stipend per month including: medical insurance, days to be deducted ( uncertificated holidays…. )","1  -> Must have"]
["1.5.3","Facility to link  fund code and internship assignment details with possibility of fund check.","1  -> Must have"]
["1.5.4","Supports hold last payment automatically until the check out form is received electronically.","1  -> Must have"]
["1.5.5","Supports Electronic certification of services for  internship by the supervisors with work dates and deduction, if it applies ","1  -> Must have"]
["1.5.6","Supports sending of notification  to the intern when the stipend is paid","1  -> Must have"]
["1.5.7","Facility to inquire internship assignment/contract ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Freelance Interpreters ,Translators  Payment Processing","N/A","N/A"]
["1.6.1","Supports notification facility to the payroll unit when the appointment is made and advance payment to be done for travel","1  -> Must have"]
["1.6.2","Supports Electronic certification of services by the certifying officer with duration of appointment and obligation document number","1  -> Must have"]
["1.6.3","Facility to calculate payment  automatically based  on the salary rate and days (duration)  from  HR assignment details","1  -> Must have"]
["1.6.4","Supports electronic payment claim form which displays the advance paid automatically","1  -> Must have"]
["1.6.5","Facility to send notification with earning statement to Freelancers through external email","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.7,"Corporate Credit Card Payment settlement","N/A","N/A"]
["1.7.1","Facility to create corporate credit card expenditure report with attachment of credit card statement and forward for confirmation by the card holder","1  -> Must have"]
["1.7.2","Supports electronic approval workflow for credit card expenditure report","1  -> Must have"]
["1.7.3","Supports calculation of settlement amount using UN exchange rate ","1  -> Must have"]
["1.7.4","Facility to link obligation document number to the expenditure report and send notification if the fund is not sufficient","1  -> Must have"]
["1.7.5","Remainder notification if the expenditure report is not submitted with in a user defined period","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.8,"Private communication charge recovery","N/A","N/A"]
["1.8.1","Facility to create report with attachment of telephone bill and forward for confirmation by the telephone holder by Communication System administrator  periodically (bi-monthly) for the total amount more 30 EUR","1  -> Must have"]
["1.8.2","Facility to declare the private calls/ official call separately","1  -> Must have"]
["1.8.3","Supports electronic approval workflow for declaration amount  more than 250 EUR","1  -> Must have"]
["1.8.4","Supports sending request to multiple user  if the same  telephone is attached to multiple users ","1  -> Must have"]
["1.8.5","Supports automatic deduction of applicable amount through payroll","1  -> Must have"]
["1.8.6","Remainder notification if the certification is not submitted within a user defined period","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.9,"Report Capabilities","N/A","N/A"]
["1.9.1","Facility to generate monthly payslip in pdf or similar format with password protection for FT/STS/TAC/SSA/Intern","1  -> Must have"]
["1.9.2","Facility to generate annual earning statement in EUR/USD currency amount and in pdf or similar format with password protection with user defined date filter criteria (Year, From Date, To Date)","1  -> Must have"]
["1.9.3","Facility to generate medical contribution amount by employee, by pay period","1  -> Must have"]
["1.9.4","Facility to generate monthly/periodic  earning statement in EUR/USD currency amount by pay element type e.g.. Basic salary, overtime; etc.. For all types of employment (FT,TAC,STC etc..)","1  -> Must have"]
["1.9.5","Facility to generate adhoc reports  on EPAF  based on a user defined parameter E.g.. Staff list with step increment in a given period","1  -> Must have"]
["1.9.6","Facility to define Annual Earning Statement elements on yearly basis before the  predefined  time period and publishing same at user defined period","1  -> Must have"]
["1.9.7","Facility to send Annual Earning Statement  automatically for all separated  staff members for the current year","1  -> Must have"]

{"sheet":"10-LMS","index":12,"n_rows":120,"n_cols":5,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Learning Management System","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Supports summary view of employee training history","1  -> Must have"]
["1.1.2","Supports maintaining  a record of all requested courses","1  -> Must have"]
["1.1.3","Allows students (employee) to register for multiple courses at once ","1  -> Must have"]
["1.1.4","Allows user defined course type  such as  Skills development, Technical training, Managerial training, Functional training, Personal development, Certification training","1  -> Must have"]
["1.1.5","Supports maintaining course details such as Course name, Course dates, Course description, Training provider. Type of training, Course competencies","1  -> Must have"]
["1.1.6","User defined instruction types such as  Instructor led, Self-study, Computer assisted, Interactive video","1  -> Must have"]
["1.1.7","Supports user defined training request form","1  -> Must have"]
["1.1.8","Supports user defined workflow for training approval","1  -> Must have"]
["1.1.9","Facility to make user defined catalogue for ( Course ,Material, Provider)","1  -> Must have"]
["1.1.10","Supports user defined evaluation form by training type/course","1  -> Must have"]
["1.1.11","Supports user defined screens and fields","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Integration Requirement","N/A","N/A"]
["1.2.1","Integrated with HR, AP, Procurement, Budget","1  -> Must have"]
["1.2.2","Ability to link to the HR system, organizational learning plans, and performance management system","2  -> Very important"]
["1.2.3","Selected staff data held in HR system including name, title, grade, Division/Branch/section, contract start and end date etc. should be accessible to the system","1  -> Must have"]
["1.2.4","Supports integration capabilities with other systems (learning platforms, travel system and/or ERP)","1  -> Must have"]
["1.2.5","Vendor list for all training should be available Procurement/AP module for preparing purchase order/invoice processing","1  -> Must have"]
["1.2.6","Supports integration capabilities with third party system such as mission planning systems for updating training scheduling","2  -> Very important"]
["1.2.7","Supports integration with travel system","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.3,"Course/Event Management ","N/A","N/A"]
["1.3.1","Supports facility to schedule and track individual training (attended hours, completed hours, grades, or results of successful/non-successful completion, etc.)","1  -> Must have"]
["1.3.2","Supports doing a learning and development needs assessment","1  -> Must have"]
["1.3.3","Supports  automatic notification for mandatory courses to target audiences, tracking compliance, updating Employee history","1  -> Must have"]
["1.3.4","Supports group training administration for Individuals with common training requirements can be flagged to be trained together","2  -> Very important"]
["1.3.5","Supports  mass registration of training group","1  -> Must have"]
["1.3.6","Supports  mass correspondence","2  -> Very important"]
["1.3.7","For internal group training, it should be possible to establish and publicise courses through the online Training Calendar, including courses for specific staff groups, for example, Security Guards, Floor Wardens or Inspectorate Team Leaders.  ","1  -> Must have"]
["1.3.8","Supports Group post training evaluation","1  -> Must have"]
["1.3.9","Supports an unlimited number of course/event providers to be recorded","1  -> Must have"]
["1.3.10","Supports an unlimited number of courses/events to be recorded","1  -> Must have"]
["1.3.11","Supports  an unlimited number of course/event sections to be recorded","1  -> Must have"]
["1.3.12","Supports an unlimited number of students per course/event","1  -> Must have"]
["1.3.13","Supports  creation of Standard curriculums for students","2  -> Very important"]
["1.3.14","Supports tracks student completion of a course defined in the curriculum","2  -> Very important"]
["1.3.15","Supports Required and optional courses identification  in the curriculum","2  -> Very important"]
["1.3.16","Supports tracking of self-study course’s estimated beginning and ending dates","1  -> Must have"]
["1.3.17","Supports  tracking of self-study course’s actual beginning and ending dates","1  -> Must have"]
["1.3.18","Supports  course schedule such as Daily, Weekly, Bi-weekly, Monthly, Quarterly, Annually, By user defined cycle, By enrolment level (minimums and maximums)","1  -> Must have"]
["1.3.19","Supports different validations  when scheduling course such as double bookings, instructor’s availability, facilities availability, public holidays, prerequisites ","1  -> Must have"]
["1.3.20","Supports different  course registration features such as Minimum & Maximum size can be enrolled","1  -> Must have"]
["1.3.21","Supports Waiting lists generation when class maximum is exceeded","1  -> Must have"]
["1.3.22","Supports mass registration of students","1  -> Must have"]
["1.3.23","Supports mass preparation  and personalisation  such as confirmation letters, student materials list,  class rosters, Name badges, Certificates, Grade notices","1  -> Must have"]
["1.3.24","Supports  the creation of Training Resource rosters and dates","1  -> Must have"]
["1.3.25","Supports  various course calendars such as  Daily, Weekly ,Monthly, Other periods based upon user-entered beginning and ending dates","1  -> Must have"]
["1.3.26","Allows pre-qualified instructors to be assigned to courses","3  -> Important"]
["1.3.27","Facility to capture instructors information  such as Demographic information, Qualifications, Competency, Availability","2  -> Very important"]
["1.3.28","Supports the recording of class results","1  -> Must have"]
["1.3.29","Facility to provide a student evaluation summary report","1  -> Must have"]
["1.3.30","Supports student transcripts by On-line, Print, Email","1  -> Must have"]
["1.3.31","Supports course budgeting and accounting information such as Course budget ,Budget variance, Course costs including employee travel","1  -> Must have"]
["1.3.32","Supports facility to add Course owners and Training Administrators who can create group courses, publish them to the Training Calendar, and administer the course during its workflow. ","1  -> Must have"]
["1.3.33","Supports uploading and publishing of training material","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Training Request and workflow","N/A","N/A"]
["1.4.1","Supports workflow enabled external training request","1  -> Must have"]
["1.4.2","The System should support online training requests and the related workflows for the different training types available through OPCW: 1- Internal group; 2- External group; 3- External individual (offered by another training provider). ","1  -> Must have"]
["1.4.3","Supports configurable workflow and be able to send automatic notifications by email at any stage of the workflow","1  -> Must have"]
["1.4.4","Supports sending reminders (i.e. course announcements, any change data, evaluations, impact assessment).","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"External Individual Training requests and workflow","N/A","N/A"]
["1.5.1","Supports staff to submit an online training request (according to a template) which would go to their supervisor (this task can be delegated) for approval, when they apply to attend an external training event. ","1  -> Must have"]
["1.5.2","Supports sending a confirmation and joining instructions e-mail to training participants","1  -> Must have"]
["1.5.3","Allows for the uploading of scanned copies of external training certificates against staff records","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.6,"Testing and Closure of course","N/A","N/A"]
["1.6.1","Supports the ability to devise and set online tests for trainees taking OPCW courses for Course owners/Training Administrators.  ","1  -> Must have"]
["1.6.2","Supports an automated marking and score reporting capability. ","1  -> Must have"]
["1.6.3","Allows the Training Administrator to enter test results when tests are carried out by trainers off line (i.e. in the classroom or in the field).","1  -> Must have"]
["1.6.4","Ability to record attendance information ","1  -> Must have"]
["1.6.5","Facility to enter confirmation about whether course requirements have been fully met  and  other trainer comments","1  -> Must have"]
["1.6.6","Supports producing automatically certificates of completion.","1  -> Must have"]
["1.6.7","Supports uploading and storing training certificates to the individual's records","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.7,"Training Evaluation","N/A","N/A"]
["1.7.1","Supports the capability for an on-line Evaluation system.  ","1  -> Must have"]
["1.7.2","Supports Notification for completion of evaluation form for individual external training, need to send up to 3 reminders until the Evaluation form is completed","1  -> Must have"]
["1.7.3","Facility to send Training Impact Survey three or six months after any training which also needs to be completed by staff members and submitted on line by them,  counter ‘signed’ by their supervisor.  ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.8,"Employee Self-Service","N/A","N/A"]
["1.8.1","Ability to view personal training history ","1  -> Must have"]
["1.8.2","Search for available courses based on topic, text, language, schedule","1  -> Must have"]
["1.8.3","Capacity to view courses calendar and details ","1  -> Must have"]
["1.8.4","Enrol in or cancel participation in courses ","1  -> Must have"]
["1.8.5","Pre-book for courses not yet scheduled ","1  -> Must have"]
["1.8.6","Self-registration facility for staff to register (self-nominated) for open courses online and be targeted to take part in certain mandated training.","1  -> Must have"]
["1.8.7","Facility to  record Training Impact Survey  and view the previous survey completed","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.9,"External User Self-Service","N/A","N/A"]
["1.9.1","Supports self registration for events/courses by external user other than OPCW staff members","2  -> Very important"]
["1.9.2","Supports self registration for eLearning  by external user(Customs Officer, Members of National Authorities etc.)","2  -> Very important"]
["1.9.3","Supports user defined workflow for activating external user account with email notification","2  -> Very important"]
["1.9.4","Facility to record Personal details (Title, First name, last Name, Date of birth, Place of Birth, Marital status, Nationality, Citizenship, etc.)","2  -> Very important"]
["1.9.5","Ability to attach supporting documents such as Copy of the passport","2  -> Very important"]
["1.9.6","External user should be able to login into the system using email and password","2  -> Very important"]
["1.9.7","Ability  for external user to apply for events/course electronically.","2  -> Very important"]
["1.9.8","Ability  for external user to withdraw from participation in courses/events ","2  -> Very important"]
[null,null,"N/A","N/A"]
["2.0","Couse/Event/ELearning Administration and  Management","N/A","N/A"]
["2.0.1","Supports uploading, publishing and administration of (SCORM compliant) eLearning modules","1  -> Must have"]
["2.0.2","Supports restriction of available training course/events/eLearning based on the user group( External user will have access to limited number of training course/events/course)","1  -> Must have"]
["2.0.3","Supports user defined workflow for training course/event/ eLearning request approval","1  -> Must have"]
["2.0.4","Facility for course/event administrators to select/shortlist participants","2  -> Very important"]
["2.0.5","Facility to record travel details( Departure Location, Date, Arrival Location, Date etc.) of the participants for the events ","2  -> Very important"]
["2.0.6","Supports automatic notification for the selected/non selected participants with user defined message","2  -> Very important"]
[null,null,"N/A","N/A"]
["2.1","Report Capabilities","N/A","N/A"]
["2.1.1","Reports that identify staff with specific set of skills, competencies or expertise","1  -> Must have"]
["2.1.2","Ability to print a course catalogue","1  -> Must have"]
["2.1.3","Supports summary view of employee training history","1  -> Must have"]
["2.1.4","Reports on completion of mandatory training by employee.","1  -> Must have"]
["2.1.5","Reports on no completion of evaluation form by employee, training","1  -> Must have"]
["2.1.6","Reports on list of external participant applied  by events ","1  -> Must have"]
["2.1.7","Reports on list of external participants applied  by events, country","1  -> Must have"]
["2.1.8","Reports on list of external participants selected for the event","1  -> Must have"]

{"sheet":"11-EPMAS","index":13,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,"Employee Performance Appraisal","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters"]
["1.1.1","Supports  master records for probation, annual and other appraisals in English","1  -> Must have"]
["1.1.2","Supports user defined performance objectives","1  -> Must have"]
["1.1.3","Supports definition performance appraisal cycle (Yearly, Mid Year etc.)","1  -> Must have"]
["1.1.4","Supports user defined performance rating(Partially meets performance expectations,  Does not meet performance expectations, Successfully meets performance expectations etc.)","1  -> Must have"]
["1.1.5","Supports different type of objectives (Mandatory, Optional, Managerial)","1  -> Must have"]
["1.1.6","Supports definition  probation appraisal cycle  by staff member, contract type","1  -> Must have"]
["1.1.7","Fully integrated with HRMS & Payroll","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Employee Performance","N/A","N/A"]
["1.2.1","Supports definition of employee yearly work plan","1  -> Must have"]
["1.2.2","Supports definition of employee probation work plan","1  -> Must have"]
["1.2.3","Capability of automatically selecting mandatory objectives associated to the job functions","3  -> Important"]
["1.2.4","Supports individual competency-based performance evaluation on predefined objectives","4  -> Nice to have"]
["1.2.5","Supports the establishment of the individual learning and development plan based on the performance assessment of the employee","4  -> Nice to have"]
["1.2.6","Supports multiple evaluation cycles that can be accessed simultaneously even when supervisory changes have occurred","4  -> Nice to have"]
["1.2.7","Supports sending reminders of the completion of each step throughout the process regardless of the cycle (i.e. Probationary Period, Regular Reporting Cycle, etc.)","2  -> Very important"]
["1.2.8","Allows for modifications  of work plan objectives during the reporting cycle","3  -> Important"]
["1.2.9","Supports entering details of the Performance Appraisal system","2  -> Very important"]
["1.2.10","Supports linking  step increment based on performance ratings; capability to generate employee personnel action request for step increment on completion performance evaluation and achieving satisfactory ratings","1  -> Must have"]
["1.2.11","Ability to maintain the appraisal ratings and feedback in the system for the current year","2  -> Very important"]
["1.2.12","Capability to store the results of the employee’s performance evaluation  details  such as Start and End Date for evaluation, Manager,  final rating, Comment by first appraising  Officer, Second Appraising Officer","2  -> Very important"]
["1.2.13","Ability to archive appraisal ratings and feedback in the system for previous years","3  -> Important"]
["1.2.14","Supports multi-level workflow for routing  annual work plan, probation work plan, midyear evaluation, annual evaluation based on supervisory relationship structure","2  -> Very important"]
["1.2.15","Facility to initiate performance improvement plan based on the performance rating","2  -> Very important"]
["1.2.16","Provision for appraise feedback and sign-of","2  -> Very important"]
["1.2.17","Facility for administrator to view the status of appraisal for all employees","2  -> Very important"]
["1.2.18","Facility to specify training needs, recommendations as a part of the performance evaluation","2  -> Very important"]
["1.2.19","Supports the creation and routing of career management plans","4  -> Nice to have"]
["1.2.20","Supports upward appraisal","4  -> Nice to have"]
[null,null,"N/A","N/A"]
[1.3,"Employee Self-Service","N/A","N/A"]
["1.3.1","Facility to initiate performance objectives either by employee or supervisor","1  -> Must have"]
["1.3.2","Capacity for approving/rejecting requested performance objectives by supervisor","1  -> Must have"]
["1.3.3","Provision for employees to view appraisal summary and history","2  -> Very important"]
["1.3.4","Facility to sign-off the work plan, performance evaluation by employee and supervisor","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Report Capabilities","N/A","N/A"]
["1.4.1","Reports on the historic performance at the individual and organizational levels","2  -> Very important"]
["1.4.2","List of staff members on probation","1  -> Must have"]
["1.4.3","List of completed or incomplete  probation appraisal evaluation","1  -> Must have"]
["1.4.4","List of completed or incomplete  End-year appraisal evaluation","1  -> Must have"]

{"sheet":"12-EOD","index":14,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,"Employee Official Documents","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Fully integrated with the HR system","1  -> Must have"]
["1.1.2","Facility to add different document type (MFA,VISA, Passport,UNLP,SSA Certificate, Vehicle Registration)","1  -> Must have"]
["1.1.3","Facility to add visa requirements by country  for 200 countries","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Employee Official Documents","N/A","N/A"]
["1.2.1","Supports recording Passport  details( Passport type, Passport Number, Issue Date, Expiry date,  Issuing Country)","1  -> Must have"]
["1.2.2","Supports recording  Passport status( Valid, Cancelled). Validity checked by Expiry Date","1  -> Must have"]
["1.2.3","Supports entering UNLP eligibility details for each staff member ","3  -> Important"]
["1.2.4","Facility make electronic request  for UNLP with a user defined workflow","3  -> Important"]
["1.2.5","Supports recording UNLP details( UNLP type, UNLP Number, Issue Date, Expiry date,  Issuing Organisation, log date, expected return date, location of the document( Mission, Fire king)","1  -> Must have"]
["1.2.6","Facility to add remarks /comments in UNLP Details","1  -> Must have"]
["1.2.7","Supports recording  UNLP status( Valid, Cancelled)","1  -> Must have"]
["1.2.8","Supports recording  VISA details( Issuing country, Issue date, Expiry date)","1  -> Must have"]
["1.2.9","Supports recording  VISA status( Valid, Expired, Used, UNLP Cancelled)","1  -> Must have"]
["1.2.10","Supports recording MFA details( MFA Document type, MFA ID Number, MFA holder's name, Issue Date, Expiry date,  Issuing Organisation, return date to MFA.) for staff members and eligible family members","1  -> Must have"]
["1.2.11","Supports recording  MFA status( Valid, Cancelled)","1  -> Must have"]
["1.2.12","Facility to generate invitation letter/Note Verbale in predefined format based on the request","3  -> Important"]
["1.2.13","Supports recording SSA Certificate details","1  -> Must have"]
["1.2.14","Supports recording vehicle registration details ( Registration Number, Model of Vehicle)","1  -> Must have"]
["1.2.15","Supports Country Details (Visa Requirements per country, and allow for comments)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Employee Self Service","N/A","N/A"]
["1.3.1","Facility to enter passport details by staff members","3  -> Important"]
["1.3.2","Facility to attach supporting documents ( Copy of passport and UNLP)","3  -> Important"]
["1.3.3","Facility to make request for visa assistance electronically  by staff member for self ","3  -> Important"]
["1.3.4","Facility to make request for visa assistance electronically  by staff member for their friends/relatives  with a user defined workflow","3  -> Important"]
["1.3.5","Facility to make request for visa assistance electronically  by Recruitment staff for the new staff member and family members to facilitate coming on board","3  -> Important"]
["1.3.6","Facility to make request for MFA card registration electronically  by staff member","3  -> Important"]
["1.3.7","Facility to make request for vehicle registration electronically by staff member","3  -> Important"]
["1.3.8","Facility to make request for change foreign driving license to Dutch electronically by staff member","3  -> Important"]
["1.3.9","Facility to advise changes to address, new passport using the MFA format","3  -> Important"]
[null,null,"N/A","N/A"]
[1.4,"Report Capabilities","N/A","N/A"]
["1.4.1","List of MFAid cards as on Date for Active Staff Members","1  -> Must have"]
["1.4.2","List of Vehicles as on Date for Active Staff Members","1  -> Must have"]
["1.4.3","List with all staff members per grade","1  -> Must have"]
["1.4.4","List with all staff members dependants","1  -> Must have"]
["1.4.5","List with all separations per year","1  -> Must have"]
["1.4.6","Statiustics of MFA id cards issued per year","1  -> Must have"]
["1.4.7","Statistics of Vehicles registered/de-registered per year","1  -> Must have"]
["1.4.8","Weekly Notification  with  list of MFA as on Date for Active Staff Members and Family Members Expiring in Next 45 days ","1  -> Must have"]
["1.4.9","Separation Staff Details","1  -> Must have"]
["1.4.10","Passport and UNLP Details for Inspection Staff","1  -> Must have"]
["1.4.11","UNLP Expiration As On Date","1  -> Must have"]
["1.4.12","Visa Expiration As On Date","1  -> Must have"]
["1.4.13","Visa Availability\\Validity By Employee  by Country","1  -> Must have"]
["1.4.14","UNLP Returned As On Date","1  -> Must have"]
["1.4.15","Statistics of Visa Issued By country by year","1  -> Must have"]
["1.4.16","Holders of UNLPs","1  -> Must have"]
["1.4.17","List of UNLP","1  -> Must have"]
["1.4.18","Weekly Notification  with SSA Expiration as on date","1  -> Must have"]
["1.4.19","Weekly Notification  with List of Inspectors on leave for next 10 days","1  -> Must have"]
["1.4.20","Weekly Notification  with Visa expiration in next 180 days by country (eg USA,Russia)","1  -> Must have"]
["1.4.21","Weekly Notification  with UNLP expiration in next 365 days by country ","1  -> Must have"]
[null,null,"N/A","N/A"]

{"sheet":"13-Procurement","index":15,"n_rows":133,"n_cols":5,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[null,"Procurement","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Fully integrated with the GL/AP/Budget","1  -> Must have"]
["1.1.2","Supports central vendor master database","1  -> Must have"]
["1.1.3","Supports facility to upload items code (UNSPSC code for Goods or Services)","1  -> Must have"]
["1.1.4","Supports automatic/manual number generation for  requisition/purchase order numbers based on user defined prefix-suffix","1  -> Must have"]
["1.1.5","Supports purchase site/business unit","1  -> Must have"]
["1.1.6","Supports entering buyer details","1  -> Must have"]
["1.1.7","Supports entering FOB Code,Frieght term code","1  -> Must have"]
["1.1.8","Supports entering calendar","1  -> Must have"]
["1.1.9","Supports entering deliver to; ship to; and  bill to address","1  -> Must have"]
["1.1.10","Ability to add standard phrase","2  -> Very important"]
["1.1.11","Ability to add  default accounting distribution by site,busines unit, item group, item code","1  -> Must have"]
["1.1.12","Supports user defined multi step workflow for approval ","1  -> Must have"]
["1.1.13","Supports  facility to delegate approval rights to alternate approver for certain period, date etc.","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Vendor Master","N/A","N/A"]
["1.2.1","Supports unlimited number of vendors to be defined with a user-defined vendor number ","1  -> Must have"]
["1.2.2","Multiple address type such as Ship to, Order To, Remittance To(Bill to) per vendor","1  -> Must have"]
["1.2.3","Supports recording email addresses, web sites, fax , phone number","1  -> Must have"]
["1.2.4","Supports maintaining  purchasing and remittance addresses for each vendor; if remittance address is entered, it will be used automatically on accounts payable invoice otherwise, the purchase order address will be used ","1  -> Must have"]
["1.2.5","Supports providing default values  such as items, shipping terms, payment terms, cash discount etc. for each vendor; default values will automatically be entered on purchase orders and can be overridden as necessary","1  -> Must have"]
["1.2.6","Supports user-defined payment priority for each vendor which will  be used in processing of  invoice","1  -> Must have"]
["1.2.7","Allows free-form text comments to be entered for each vendor record","1  -> Must have"]
["1.2.8","Supports inactivation of vendors which are not used","1  -> Must have"]
["1.2.9","Record Vendor performance by price, quality, delivery","1  -> Must have"]
["1.2.10","Supports creation of one time vendor ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Procurement Transactions (PR,RFQ,Quotation,PO)","N/A","N/A"]
["1.3.1","Supports purchase  requisition creation with  required date, item code, description, qty,unit price, unit of measurement, GL accounting distribution etc.","1  -> Must have"]
["1.3.2","Supports pre-encumbrance of funds against the available budget for requisitions","1  -> Must have"]
["1.3.3","Supports multiple sources of funds and programs per requisition  (one requisition to many funds and programs)","1  -> Must have"]
["1.3.4","Ability to assign buyer to a particular requisition","1  -> Must have"]
["1.3.5","Supports creation of purchase orders from previously entered requisitions","1  -> Must have"]
["1.3.6","Supports creation of requisitions by copying a previous requisition","3  -> Important"]
["1.3.7","Supports display of detailed requisition lines for each requisition during the requisition approval process","1  -> Must have"]
["1.3.8","Supports adding notes to requisition during creation and approval","1  -> Must have"]
["1.3.9","Supports RFQ processing ","1  -> Must have"]
["1.3.10","Supports generation of RFQ as stand alone by entering the details or automatically from requisitions","1  -> Must have"]
["1.3.11","Supports generation of one or more on-line requisitions to an  RFQ","1  -> Must have"]
["1.3.12","Facility to send RFQ copy to multiple vendors","1  -> Must have"]
["1.3.13","Ability to record offers/bids into the system manually or automatic upload.","1  -> Must have"]
["1.3.14","Supports recording bid details","1  -> Must have"]
["1.3.15","Supports  Offer/Quotation comparison  and rank the offers received based on defined parameters","1  -> Must have"]
["1.3.16","Supports evaluation of  offer on-line for technical and commercial aspects","1  -> Must have"]
["1.3.17","Supports multi currency purchase order","1  -> Must have"]
["1.3.18","Supports encumbrances against Funds and Programs for purchase order","1  -> Must have"]
["1.3.19","Supports attaching supporting documents either electronically or by scanning during requisition or Purchase Order creation","1  -> Must have"]
["1.3.20","Supports cancellation of a line item  from PO by removing the entire line","1  -> Must have"]
["1.3.21","Supports cancellation/amendement  of an approved PO which should be routed through a user defined workflow","1  -> Must have"]
["1.3.22","Supports purchase order inquiry by PO number, vendor name or part number","1  -> Must have"]
["1.3.23","Allows purchase order information to be  tracked on-line for each detail line including: quantity ordered,quantity canceled,quantity received, quantity paid","1  -> Must have"]
["1.3.24","Supports different types for purchase order such as Normal, Multi Delivery,Multi-Year, Blanket","1  -> Must have"]
["1.3.25","Supports creation of PO combining multiple requisitions from different branch/sections/busines unit which should be routed through a user defined workflow with multiple approvers based on branch,section, business unit, funding source etc.","2  -> Very important"]
["1.3.26","Supports fund availability check for requisition/po amounts against the available budget and trigger exception transactions for management approval","1  -> Must have"]
["1.3.27","Supports geneartion of bids & quotes  by PDF","1  -> Must have"]
["1.3.28","Provides the ability to inquire on-line by purchase order number, requisition, vendor or requesting department","1  -> Must have"]
["1.3.29","Supports notification by email for approval or rejection to the line item level or document level","1  -> Must have"]
["1.3.30","Supports scheduling reminders for pending task  prior to the effective date","3  -> Important"]
["1.3.31","Supports printing a draft copy of the purchase order for review","1  -> Must have"]
["1.3.32","Supports recording expected receiving date (due date) for each PO","1  -> Must have"]
["1.3.33","Supports entering general ledger account codes on every Requisition and PO line item","1  -> Must have"]
["1.3.34","Supports automatic posting of a balancing encumbrance entry for each expense account used on  a  purchase order","2  -> Very important"]
["1.3.35","Supports unlimited number of detail lines and description lines on each purchase order","1  -> Must have"]
["1.3.36","Supports unlimited number of fund and account codes to be used on detail purchase orders","1  -> Must have"]
["1.3.37","Supports entry of an alternate ship-to code on each purchase order","3  -> Important"]
["1.3.38","Supports user-defined message to be entered on each purchase order","2  -> Very important"]
["1.3.39","Supports encumbrances against current or next year’s budget","1  -> Must have"]
["1.3.40","Supports fractional quantities to be entered in the detail line, using up to four decimal places (eg.1.500)","1  -> Must have"]
["1.3.41","Supports generation of contracts or blanket orders as stand alone by entering the details or automatically from requisitions","2  -> Very important"]
["1.3.42","Supports  closure of outstanding purchase orders automatically through the invoice accrual process","2  -> Very important"]
["1.3.43","Allows an authorized user to close purchase orders manually to liquidate any remaining encumbrance balances","1  -> Must have"]
["1.3.44","Supports detailed audit trail of closed purchase orders for on-line inquiry","1  -> Must have"]
["1.3.45","Supports calculatiion of costs using a percentage discount from list or quoted prices","1  -> Must have"]
["1.3.46","Supports tracking of total of purchase order releases against blanket orders","1  -> Must have"]
["1.3.47","Supports partial receipts of POs or PO line items, with user option to keep remaining balance to be open or cancel.","1  -> Must have"]
["1.3.48","Supports receipt of  a quantity greater than the PO quantity without modification to the PO, within a user-defined tolerance","1  -> Must have"]
["1.3.49","Supports matching multiple POs against a single receiving list (e.g., vendor shipped multiple purchase orders in a single shipment)","1  -> Must have"]
["1.3.50","Supports creation of  a PO without Requisition","1  -> Must have"]
["1.3.51","Supports the ability to electronically transmit the  approved  purchase order after receiving the electronic signature of an authorized  approving officer","1  -> Must have"]
["1.3.52","Supports ability to use contract models to draft solicitations, contracts, and  be able to generate all initial award information e.g., award letters, notice to proceed issuance.","1  -> Must have"]
["1.3.53","Supports mutiline payment schedule","2  -> Very important"]
["1.3.54","User defined multi step workflow for approval by fund used, busines unit, item group in the purchase request, purchase order","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Procurement Transactions (GR)","N/A","N/A"]
["1.4.1","Supports recording mutiple receipt for each purchase order","1  -> Must have"]
["1.4.2","Supports capability to default expected quantities from the purchase order into the receiving  entry screen.","1  -> Must have"]
["1.4.3","Supports integration with the Fixed Asset/Inventory System when receiving purchases or stock items or capital assets","1  -> Must have"]
["1.4.4","Supports mass receiving of all expected quantities from the purchase order (with the ability to suppress)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.5,"Contract Management ","N/A","N/A"]
["1.5.1","Supports  creation of standard multiple contract types (Procurement, Donor and Other of 3rd Party Agreements)","1  -> Must have"]
["1.5.2","Supports the workflow of approval routing of the  contract documents","2  -> Very important"]
["1.5.3","Supports multiple versions of the contracts where amendments are agreed and approved","1  -> Must have"]
["1.5.4","Supports  tracking changes:  drafted, reviewed, revised, approved and published ","1  -> Must have"]
["1.5.5","Supports notifications based on the workflows","2  -> Very important"]
["1.5.6","Supports scanned attachments","1  -> Must have"]
["1.5.7","Supports electronic signature capability for contracts","1  -> Must have"]
["1.5.8","Supports tracking  of  contracts and expiration dates and send email alerts","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Procurement Transaction Controls","N/A","N/A"]
["1.6.1","Supports multiple approval workflow by funding code, branch, division, price","1  -> Must have"]
["1.6.2","Supports fund availability check for requisition/po amounts against the available budget and trigger exception transactions for management approval","1  -> Must have"]
["1.6.3","Supports holding new orders to  a selected vendor","1  -> Must have"]
["1.6.4","Supports validation of  accounting distribution entries or requisitions and purchase orders against the general ledger chart of accounts","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.7,"Vendor Portal","N/A","N/A"]
["1.7.1","Support vendor online registration ","1  -> Must have"]
["1.7.2","Facility to activate the vendor for releasing for procurement process by buyer or procurement department","1  -> Must have"]
["1.7.3","Supports publishing tender online","1  -> Must have"]
["1.7.4","Supports registered  vendor to access the tender document/RFQ  online","1  -> Must have"]
["1.7.5","Supports vendor to submit quotation online.","1  -> Must have"]
["1.7.6","Supports vendor to view the status of tender/quotation","1  -> Must have"]
["1.7.7","Supports to view the PO details.","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.8,"Report Capabilities","N/A","N/A"]
["1.8.1","Requisitions List Open/Pending/in Approval","1  -> Must have"]
["1.8.2","PO Processing Report by Buyer, Vendor, Due Date","1  -> Must have"]
["1.8.3","Purchase Order List by PO Date,by Vendor,by Buyer,by Status","1  -> Must have"]
["1.8.4","Purchase Order Details by PO Date,by Vendor,by Buyer,by Status, by Item Type","1  -> Must have"]
["1.8.5","List of Unprocessed purchase requisitions ","1  -> Must have"]
["1.8.6","List of Approved requisition reports","1  -> Must have"]
["1.8.7","Amended/Revised purchase orders by number range or date","1  -> Must have"]
["1.8.8","Open purchase orders by number range","1  -> Must have"]
["1.8.9","All purchase orders by the fiscal year by number range","1  -> Must have"]
["1.8.10","Single purchase orders by purchase order number","1  -> Must have"]
["1.8.11","List of vendors by location, Country, Status","1  -> Must have"]
["1.8.12","Vendor analysis report which calculates period-to-date and year-to-date by: Quantity ordered,Quantity received,Average purchase price,Last purchase price,Currency value of transactions","1  -> Must have"]
["1.8.13","Purchase history report  by vendor, item, business unit","1  -> Must have"]
["1.8.14","Purchase requisitions to be selectively printed by: Requisition number or range of numbers","1  -> Must have"]
["1.8.15","Recipt details by Receipt number, Purchase Order Number, Transaction Date","1  -> Must have"]
["1.8.16","Support generation purchase order in a predfined format at different status  (Draft/ Approved/Ammended)","1  -> Must have"]

{"sheet":"14-Travel","index":16,"n_rows":133,"n_cols":5,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[null,"Travel","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Fully integrated with the GL/AP/Budget/HR ","1  -> Must have"]
["1.1.2","Supports automatic display of staff member details from HR system e.g., Name as per Passport , Home Leave address","1  -> Must have"]
["1.1.3","Supports facility to upload DSA (per diem) and exchange rate tables","2  -> Very important"]
["1.1.4","Supports making different type of  Travel Request (Interview, Home Leave, Education Grant Travel, Repatriation, Coming On Board, Duty Travel, Mission  Travel, Conference Travel, Training Travel Interpreter Travel,  SSA travel etc. )","1  -> Must have"]
["1.1.5","Supports  multiple cost type  by travel type ,Should also support different cost types( DSA, Terminal Expenses, Excess baggage and Transportation, National Transportation, Rental of Premises, Interpretation, Cash advance, cash insurance, training on-site support fees, catering expenditures etc).","1  -> Must have"]
["1.1.6","All date fields should have drop down menus with a calendar listed to select a date.","4  -> Nice to have"]
["1.1.7","Display date of birth for children of staff members in Travel request/Travel Authorisation for HR travel types","1  -> Must have"]
["1.1.8","Date fields can be entered in user defined formats  e.g.. dd/mm/yyyy or dd/mm/yy. ","2  -> Very important"]
["1.1.9","Format for dates displayed as a default in the date field. (e.g. date field shows dd/mm/yyyy and the user can overwrite this.)","1  -> Must have"]
["1.1.10","Destination (To) location fields defaulted to the value. “Please select…”","3  -> Important"]
["1.1.11","Departure (From) location field defaulted to the value. “Please select…”","3  -> Important"]
["1.1.12","Supports  both manual and automatic number generation for  travel request/ travel authorisation.  ","1  -> Must have"]
["1.1.13","Automatic number generatio should be based on user defined suffix and prefix.Travel request number: (Unique 3 letter abbreviation for each type of TR)+(Full Year)+(1 digit sequential number) e.g. for Duty Travel DTY20071, Authorisation  Number: (20)+(last digit of Year)+(4 digit sequential number)","1  -> Must have"]
["1.1.14","Supports maintaining revsision number with user defined suffix eg 1/2/3 or A/B/C","1  -> Must have"]
["1.1.15","Facility to default expenditure chart of account based on the travel type, travel cost element and business unit of the requesting user.","2  -> Very important"]
["1.1.16","Supports multi step workflow with user defined routing parameters( fund code, Travel Type)","1  -> Must have"]
["1.1.17","Facility to restrict travel type based on employment type/role ( FT -International, Intern, SSA, STC, TAC etc.)  (Eg .Home Leave travel is applicable to FT-International, Duty Travel/Inspection - Appilicable to all staff members/Non Staff )","2  -> Very important"]
["1.1.18","All non EUR amounts calculated need to be converted to € by using applicable exchange rate (eg. DSA rates are standard in USD, but need to be converted to Euro.) ","2  -> Very important"]
["1.1.19","Facility to send notification of the action taken by travel unit/travel administrator","1  -> Must have"]
["1.1.20","Different type of access level permission by user group ( Read only, Read;/Write etc)  by travel type","1  -> Must have"]
["1.1.21","Supports multiple transaction status ( Draft, Pending, In Approval, Approved, Cancelled, Settled etc) to monitor status of the travel request/ Travel authorisation","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Travel Transactions","N/A","N/A"]
["1.2.1","Supports travel request with authorised  travel itinerary such as From (Point of Origin), To (Destination), Date of travel","1  -> Must have"]
["1.2.2","Supports travel request with private travel itinerary such as From (Point of Origin), To (Destination), Date of travel","1  -> Must have"]
["1.2.3","For HR Travel only one staff member can be on a Travel request, Family members/dependents traveling with the staff member  can be added to the same request. ","1  -> Must have"]
["1.2.4","Supports ability  to choose lump sum payment options for  Home Leave, Education Grant Travel, Repatriation travel","1  -> Must have"]
["1.2.5","Supports entering shipment return dates, (This is when shipment is to be returned from the destination.), if lump sum options/payments is not selected","1  -> Must have"]
["1.2.6","System sends reminder emails to staff members informing them that they are due to take Home Leave Travel.","2  -> Very important"]
["1.2.7","Display the date where the last home leave was taken in the Travel Request. ","3  -> Important"]
["1.2.8","Supports facility to integrate with an external travel solution/ in-house mission planning software ( Generate draft travel request/authorisation with details such as  Traveller details , Destination , Date of travel, Location etc)","2  -> Very important"]
["1.2.9","Supports automatic DSA Calculation depending on destinations provided in the travel request/Travel authorisation with possibility to make manual change on the calculation Eg.additional DSA to be obligated or Hotel accomadation paid by organisation but chraged to the DSA line","1  -> Must have"]
["1.2.10","Supports different DSA rates and percentages for every person on a travel authorisation document and also several rates and percentages for the same person for different dates of the same trip.","1  -> Must have"]
["1.2.11","Facility to record travel cost estimation by splitting different cost elements like  Duty Travel,HR Travel( Transport, DSA, Terminal allowance) Inspection Travel( transport costs inspection, DSA inspection, national travel, general expenses, terminals, cargo, rental of premises, advance payment, interpretation, other contractual services, insurance, other operating expenses). Inspection Training ( transport costs training, DSA training, misc costs training, terminals, room rate, training on site support, catering services, training course fees), etc by travel Type","1  -> Must have"]
["1.2.12","Facility to view  the running balance of different cost by  Travel Request/ Travel Authorisation","2  -> Very important"]
["1.2.13","Supports terminal expenses calculation depending on number of destinations provided and predefined rate by locations with possibility of adding additional terminal depending on the location( Eg. In some location more than one terminal applicable)","1  -> Must have"]
["1.2.14","Supports Danger Pay calculation as the business rule","1  -> Must have"]
["1.2.15","Facility to indicate full amount and reduced amount when transport is provided","2  -> Very important"]
["1.2.16","Facility to indicate if transportation was provided from departure and destination location  by travel type  with possibility to modify details at later stage.  Eg. for inspection travel this information can be added after the completion of travel","2  -> Very important"]
["1.2.17","Supports reduced DSA calculation based on the facilities provided  such as meals and accommodation provided(DSA for each city is reduced by 10% per meal, Each night accommodation specified = 50% DSA reduction for that day)","1  -> Must have"]
["1.2.18","Supports calculation reimbursement for travel with Privately owned Vehicle (e.g. number of kilometres need to be captured) ","1  -> Must have"]
["1.2.19","Supports modification of travel request until travel authorisation creation","1  -> Must have"]
["1.2.20","Support multiple ammendment  or revision  of Travel Request/Travel Authorisation .Ability to withdraw before approval and edit after approval and to be re-approved since there are often multiple changes after the creation of  Travel Authorisation.","1  -> Must have"]
["1.2.21","Support facility to highlight amendment/changes","2  -> Very important"]
["1.2.22","Supports automatic determination of default values for fund account code based on the travel type, expense items (DSA,Ticket,Terminal Expenses, Other expenses),branch, division","3  -> Important"]
["1.2.23","Supports manual selection of fund account code based on mission/specific travel and change from system defaulted value","2  -> Very important"]
["1.2.24","Supports request for exceptions such as additional DSA due to special hotel request,-Business Class for flights < 10 hours, Specific route request (e.g. Visa Restrictions),Cash Request, Others","1  -> Must have"]
["1.2.25","When an exception is requested, request need to be  routed through a user defined workflow ","1  -> Must have"]
["1.2.26","Supports  cancellation of travel request/travel authorisation","1  -> Must have"]
["1.2.27","Supports revision/amendment of travel request/travel authorisation","1  -> Must have"]
["1.2.28","Supports email notification informing approver that request is Pending his/her approval.","1  -> Must have"]
["1.2.29","Supports email Reminder after 1 day informing approver that request is Pending his/her approval. (re-occurring). Reminders also to person specified as designated approver.","1  -> Must have"]
["1.2.30","Supports display of  the signature of the approver that has approved the TR/TA when the document is printed. (Instead if listing the user name of the approver) ","1  -> Must have"]
["1.2.31","Supports adding action note and send it to the requestor for final confirmation of ticket issuance  by travel type (Home Leave,Duty Travel etc). For Inspection Travel ticket purchased separately based on approval of Mission Planners, regardless of whether or not the Travel Authorisation has been approved ","1  -> Must have"]
["1.2.32","Supports email reminders sent to traveller based on deadline entered in “Note” (7 days before the deadline,3 days before the deadline,2 days before the deadline,1 day before the deadline)  by travel type (Home Leave,Duty Travel etc). Not applicable for Inspeection Travel","1  -> Must have"]
["1.2.33","Supports to add 6 digit PNR number in “note” sent to traveller. System should captures the itinerary in view trip and saves it together with the “note”  by travel type (Home Leave,Duty Travel etc).Not applicable for Inspeection Travel","1  -> Must have"]
["1.2.34","Facility to enter actual fare. ","1  -> Must have"]
["1.2.35","Facility  to view Travel Authorizations and are displayed in the following order  such as  Urgent (TR’s with a departure < 7 days from the current day),Inbox (Approved TR with Travel Agency work Finalized),In-draft (TA’s that a TU person has taken ownership of),Pending Approval (TR’s pending approval),Approved TA’s (In-Tray and Completed TR’s),Query (All TR’s are displayed here regardless of their status)","3  -> Important"]
["1.2.36","Possibility to Recalculate all the calculations in the TA in case of rate/duration of stay changes. All calculations should be re-calculated e.g. DSA,Terminal Expenses, Travel Advance, Miscellaneous Expenses, Travel Dates etc","1  -> Must have"]
["1.2.37","Capability to select from a predetermined list of approval workflows.","1  -> Must have"]
["1.2.38","Facility to create multiple travel request through bulk upload using predefined excel template which  has travel details such as travellers, date of birth, source and destination etc.","1  -> Must have"]
["1.2.39","Facility to create travel request for  Single or  multiple travellers(30 or more) (Staff Members/Non Staff members) with different travel dates , different departure and destination locations.","1  -> Must have"]
["1.2.40","Supports travel obligation encumbrance against Funds and Program Budgets chosen in the travel request/authorisation for the approved estimated travel cost.","2  -> Very important"]
["1.2.41","Facility to specify advance payment amount based on the predefined rule for the travel type.","1  -> Must have"]
["1.2.42","Supports employee travel advances linked to the travel request\\authorization with different %  such as 80%,100% (eg. Non Staff 80%) with possibility to override manually","1  -> Must have"]
["1.2.43","Supports the upload of the invoice details from an external travel vendor","1  -> Must have"]
["1.2.44","User defined  for workflow which can be configured based on the travel type,busines unit, expenditure fund code used in the  travel request/Travel authorisation","1  -> Must have"]
["1.2.45","Supports facility to record cost centre/ mission code in the Travel authorisation","1  -> Must have"]
["1.2.46","Facility to indicate  whether Travel Authorisation billable or not","2  -> Very important"]
["1.2.47","Facility to generate a  draft receivable invoice automatically based on the billable indication in the travel authorisation with a possibility to complete it by Users in  Accounts section","2  -> Very important"]
["1.2.48","Supports notification facility such as  Notification to  Payroll in cases of DSA changes, Danger Pay, Treasury in cases of cash/advance  requests, Travel Unit in case of cash insurance requests.","1  -> Must have"]
["1.2.49","Supports shipment request for Household goods,Excess Baggage etc.","2  -> Very important"]
["1.2.50","Supports assigning alternate approver (by approver when on leave/duty travel)","1  -> Must have"]
["1.2.51","Supports assigning multiple users to be able to work on same travel request simultaneously","1  -> Must have"]
["1.2.52","Facility to make travel requets for non-staff members by entering their personal details","1  -> Must have"]
["1.2.53","Facility to record security training completion for Staff Memmbers( eg. If the training not completed , Staff Members should not be allowed to create travel request)","1  -> Must have"]
["1.2.54","Notification e-mail should be send when sending notes in the Travel Request/ Travel Authorisation document, or in case Travel Request/ Travel Authorisation is rejected or approver needs more clarification before approving/rejecting Travel Request/ Travel Authorisation","1  -> Must have"]
["1.2.55","Supports sending external e-mail via  Travel Request/ Travel Authorisation notes,This option is used when a cash insurance request is needed; A note/comment with catchword cash insurance in subject and system send this note to our cash insurance supplier","1  -> Must have"]
["1.2.56","Ability to quickly attach e-mail received to TR/TA","1  -> Must have"]
["1.2.57","Facility to add cash advance details  in all currencies and also allocate details of  more than one cash custodians in the Travel Authorisation","2  -> Very important"]
["1.2.58","Facility to transfer  balance cash advance detail from one Travel Authorisation to another or from once custodians to another","2  -> Very important"]
["1.2.59","Supports User defined workflow based on the parameters such as cash request/prepaid card , UNDP, ,etc which includes approval  of Treasury Section. ","1  -> Must have"]
["1.2.60","Supports remainder for cash requests  which are not approved before the 7 day deadline, to the Project officer/clerk/requester with a possibility to override by user","2  -> Very important"]
["1.2.61","Facility to record insurance requirement, security clearance, medical clearance with possibility to attach supporting documents","1  -> Must have"]
["1.2.62","Ability to add remarks in Travel Request/ Travel Authorisation during workflow","1  -> Must have"]
["1.2.63","'Supports automatic payment voucher generation through travel systems for advances to be paid, Voucher status should be \"Draft\"","1  -> Must have"]
["1.2.64","Supports automatic email notification to the requester when advance payment processing completed","1  -> Must have"]
["1.2.65","Supports automatic notification/remainder for unsettled travel claims transaction  which has not been submitted with in the permitted time to the requester/ traveller based on travel type","2  -> Very important"]
["1.2.66","Support linking travel claim to the travel authorisation to check the travel dates, mode of travel and other informations.","1  -> Must have"]
["1.2.67","Supports automatic calculation of settlement anount by deducting adavnce paid.( Advance Paid amount to be taken from AP) by travel authorisation document","1  -> Must have"]
["1.2.68","Supports user defined multi step workflow for  travel claim processing","1  -> Must have"]
["1.2.69","Integration with payroll for  claim recovery  for staff members/SSA/TAC/STC","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.3,"Transaction Controls","N/A","N/A"]
["1.3.1","Supports fund availability check during travel request/travel authorisation creation","3  -> Important"]
["1.3.2","Supports validation of DSA rate with a pre-defined DSA tariff per country, location","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Employee Self Service-User","N/A","N/A"]
["1.4.1","Facility to create travel request by staff members for different travel type (Home Leave, Education Grant Travel, Duty Travel) for self and family members","1  -> Must have"]
["1.4.2","Facility to  submit travel claim settlement online by  staff members/inspectors/focal points  with a userdefined workflow  by travel type with scanned details of the supporting documents","1  -> Must have"]
["1.4.3","Facility to  submit travel claim settlement online by  staff members choosing their Travel Request/ Travel Authorisation (eg One Travel Request can have multiple Travellers) with a user defined workflow  by travel type","1  -> Must have"]
["1.4.4","Facility to  submit travel certification online by  staff members in the case of lump sum options with a user defined workflow  by travel type(HR Travel) with scanned details of the supporting documents(eg. Boarding Pass, Ticket etc.)","1  -> Must have"]
["1.4.5","Supports validation of  mandatory fields while submitting the travel claim( eg, Meals Provided, Transportation provided etc)","1  -> Must have"]
["1.4.6","Facility to attach additional documents(pdf,word, excel) to the travel claim/travel request","1  -> Must have"]
["1.4.7","Facility to submit additional information after approvers request (instead of revising and submitting Travel Request again)","1  -> Must have"]
["1.4.8","Facility to make comments for approval and rejection , also notification to the requestor for the same","2  -> Very important"]
["1.4.9","Facility to view the Itinerary through View trip portal using the reservation number and last name","1  -> Must have"]
["1.4.10","Facility to view the note added by travel unit/administrators online","2  -> Very important"]
["1.4.11","Facility to view the travel claim settlement details ","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.5,"Employee Self Service- Administrator(Travel Unit/OPB/IMB/HRB/ICA/Budget) ","N/A","N/A"]
["1.5.1","Facility to create travel request for other travellers/ staff member by  Travel administrators (Travel Unit, OPB, IMB,HR)","1  -> Must have"]
["1.5.2","Supports facility to upload DSA rate by travel unit administrators for the given predefined locations ","1  -> Must have"]
["1.5.3","Supports adjustment/modification  of DSA/Terminal expense etc (manual override) in case any mistake while creating travel request","1  -> Must have"]
["1.5.4","Facility to  submit multiple documents such as  travel invoice/travel settlement/certification of service (Inspection Travel, Conference Travel,Duty travel and HR travel (Repatriation, Coming on Board, Home Leave, Education Grant Travel etc)","1  -> Must have"]
["1.5.5","Facility to attach multiple travel invoices/settlements, etc. after checked and approved","1  -> Must have"]
["1.5.6","Calculate different DSA percentage for by employee or group of employee","1  -> Must have"]
["1.5.7","Facility to add destinations, codes, Requestor etc, add administrators etc","1  -> Must have"]
["1.5.8","Facility to add new budget code ","1  -> Must have"]
["1.5.9","Dash board facility for payments which are due ( 1 week before for advances/2 months before for HLT etc)","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.6,"Report Capabilities","N/A","N/A"]
["1.6.1","Facility to print travel request and attachment(s) any time after creation and during Authorization also after fully approved TR/TA. ","1  -> Must have"]
["1.6.2","Supports generation of summary and detail travel report by Employee; Branch, Division , Destination etc","1  -> Must have"]
["1.6.3","Supports generation of summary and detail travel report by Mission, Country ","1  -> Must have"]
["1.6.4","Supports generation of summary and detail travel report by cost elements  such as  interpretation, rental of premises, national travel etc.","1  -> Must have"]
["1.6.5","Supports generation of summary and detail travel report by Official and Private categories","2  -> Very important"]
["1.6.6","Supports generation of  list of travel details  by (Traveler,Destination, Date of travel, Estimated Cost, Actual Cost in EUR) by  Travel type ( Home Leave, Education Travel, Inspection Travel, Duty Travel , Repartriation, Coming on Board Travel , etc.)","1  -> Must have"]
["1.6.7","Facility generate forecast report for  shipment removal, repatriation travel, home leave travel by employee , destination country","2  -> Very important"]
["1.6.8","Supports IPSAS 25 Reporting (Home Leave and Home Leave Travel, Education Grant Travel,  Repatriation Travel  and Removal Cost)","2  -> Very important"]

{"sheet":"15-AM","index":17,"n_rows":139,"n_cols":5,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
[null,"Assets and Inventory","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"System Policy and Parameters "]
["1.1.1","Fully integrated with the GL/AP/AR/FA/Procurement","1  -> Must have"]
["1.1.2","Supports central Asset database","1  -> Must have"]
["1.1.3","Facility to upload historical data","1  -> Must have"]
["1.1.4","Supports user defined maintenance category and tasks","1  -> Must have"]
["1.1.5","Supports user defined maintenance cycle","1  -> Must have"]
["1.1.6","Supports User defined  Asset Group( Non expendable (unit value > € 1,000),  Attractive item (unit value > € 250 but less than € 1,000, Expendable assets and Stock/Consumables  etc.)","1  -> Must have"]
["1.1.7","Supports User defined asset categories(Inspection & Verification equipment, Security and Health Equipment, Furniture & Office Equipment,Vehicle,Hardware and IT Equipment, Acquired Software, Internally Developed Software, Asset Under Construction, Software under development etc.)","1  -> Must have"]
["1.1.8","Supports processing/maintaining of depreciation details","1  -> Must have"]
["1.1.9","Supports multi level user role permissions ( eg  1. Super user (Manage Master Data) 2. Core user (Manage Asset details) 3. Inquiry User)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.2,"Asset  Management","N/A","N/A"]
["1.2.1","Supports automatic asset creation  when it is purchased in procurement system when purchase order is approved in the system, Asset status should be pending receipt/Imported.","1  -> Must have"]
["1.2.2","Facility to create asset manually by entering purchase order number, invoice number","1  -> Must have"]
["1.2.3","Record  the following asset  details from procurement system automatically Purchasing AHU (i.e. Branch), Item Code (as maintained in the Procurement System),Item Description, Purchase price (excluding  VAT), PO Number (used to purchase item), Estimated Serviceable Life (# of years), Budget Code used (applicable only for “purchase” mode of acquisition),Date of Purchase (PO date), Mode of Acquisition = Purchased, Additional information / remarks","1  -> Must have"]
["1.2.4","Recording asset receipt details  such as Receiving Office/AHU  (initial location of the property e.g. Room #),Date of Delivery, Asset  Barc Code (given by OPCW), Item Code (as maintained in the Procurement System),  Item Description, Item Model Number, Item serial number· ","1  -> Must have"]
["1.2.5","Supports recording following details in the asset master. Asset Bar Code (given by OPCW), Item code (on property where available), Category (i.e. Laptop), Type (i.e. Dell LX3480),  Classification (e.g. Consumable / non-consumable item),Description (brief description of item),Purchase order number, Number of unit items (number of same units), Item Unit Price (in euro excluding VAT), Mode of Acquisition (Purchased, Donation, Loan, Rented or Leased),  Estimated Serviceable Life (# of years),       Budget Code used ,Additional information / remarks, Status of inventory item (In use, Presented to PSB, Disposed), AHU responsible for item(s) (e.g. ISB, ISS…),Additional information / remarks","1  -> Must have"]
["1.2.6","Facility to record different cost items e.g. installation; transportation; training cost etc.","1  -> Must have"]
["1.2.7","System should provide warning message when same bar code has been used for Asset and Stocks and must not allow the process to continue.","1  -> Must have"]
["1.2.8","Supports facility to record property that was received  on loan or donation  from another organization","1  -> Must have"]
["1.2.9","Record asset in hierarchical structure(Parent/child relationship)","3  -> Important"]
["1.2.10","Supports recording  components, subcomponents and equipment","1  -> Must have"]
["1.2.11","Supports attaching  asset related documents such as drawing, manuals, contracts, pictures etc.","1  -> Must have"]
["1.2.12","Facility to record intangible asset detail( Acquired Software, Internally Developed Software, Asset Under Construction, Software under development)  barcode, decription, type of license, number of license purchased, used , available, location(eg. Data centre)","1  -> Must have"]
["1.2.13","Supports asset id with multipe qty( eg  Software license with multiple qty)","2  -> Very important"]
["1.2.14","Supports modification of asset at any point of time (like  Status, Comments,Finacial information, Purchase Order number etc)","1  -> Must have"]
["1.2.15","Supports creation of asset copying an existing asset with new asset id/barcode","2  -> Very important"]
[null,null,"N/A","N/A"]
[1.3,"Asset  Tracking","N/A","N/A"]
["1.3.1","Supports identification of asset  in the system by scanning the OPCW barcode given to the Asset","1  -> Must have"]
["1.3.2","Existing (OPCW) barcodes and all type scanners/PDA  must be able to be used in the system. ","1  -> Must have"]
["1.3.3","Facility to reprint BarCode (In case not readable or damaged)","2  -> Very important"]
["1.3.4","Supports the temporary loan of a property item to another AHU/Person/Other organisation","1  -> Must have"]
["1.3.5","Branch/Section/Person that the property is being transferred to is identified by scanning a barcode assigned to them. ","1  -> Must have"]
["1.3.6","Facility to add comments while making asset transfer","1  -> Must have"]
["1.3.7","Supports asset assignment within or outside the AHU/Business unit  and  entering assignment details (Bar Code, Property recipient (name of person who received/signed for property receipt), Date of Transfer, (New) Location (The Hague, Rijswijk) + Room Location (e.g. B.09), Additional information / remarks","1  -> Must have"]
["1.3.8","Supports Asset history with details of persons/branches/missions  for whom item assigned , date assigned and return date.","1  -> Must have"]
["1.3.9","Ability to conduct periodic scans using a barcode reader on current assets  and updating the database on who the property is assigned to and its location. This is mandatory  for end of year reporting and daily use","1  -> Must have"]
["1.3.10","Barcode reader should support 1) Bluetooth wireless; 2)Retain value of location, destination and or source during scanning 3) Option to submit & received data from/to PDA","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.4,"Mission Check Out and Check In","N/A","N/A"]
["1.4.1","Ability to assign property (including equipment, consumables and kits) to an OPCW mission. The mission code is to be used as the location code. Mission code will have details of asset, consumables. kitts and  Date of Transfer,  Additional information / remarks etc.","1  -> Must have"]
["1.4.2","Ability to print a document detailing property assigned to a mission for the purpose of recipient signature. The following fields will be printed on the form  such as Category (i.e. Laptop), Type (i.e. Dell SX280), Item Barcode (on property where available), Quantity (number of unique items)","1  -> Must have"]
["1.4.3","Items returned from mission should be checked in individually. Kits must be checked in on return from mission as a single item and its content controlled at a later stage.","1  -> Must have"]
["1.4.4","Kit’s content must be checked in at a later stage after check in from mission. Individual items in the kit will be checked and replenished. Items missing will be recorded in the system as lost or used and replaced in the kit","1  -> Must have"]
["1.4.5","Items already assigned, under repair, written-off or to be written-off (presented to the Property Survey Borad for disposal)  or Inactive must not be allowed to be checked out again to missions","1  -> Must have"]
["1.4.6","Supports generation of equipment dispatch details report in multiple languages(English,French,Spanish,Arabic,Russian,Chinese)","1  -> Must have"]
["1.4.7","Ability to retain destination or source location  during mission checkout and checkin of asset/stock","1  -> Must have"]
["1.4.8","An option to create a user defined summary report of what has been checked-in / checked-out and by whom with date & time stamped.","3  -> Important"]
[null,null,"N/A","N/A"]
[1.5,"Inventory/Stock","N/A","N/A"]
["1.5.1","Capability to group individual inventory items together into a grouping called a “Kit”. Items comprising more than one element must be handled as kits (e.g. medical equipment, Satellite phones, x-Ray instruments, Decontamination kit)","1  -> Must have"]
["1.5.2","A kit must allow control of individual items (non-expendable, attractive and consumables)","1  -> Must have"]
["1.5.3","A kit must be handled as only one item at the check out or check in, but items in the kit must be treated as individual items for property control (i.e.: non-expendable and attractive must be listed separately in inventory reports","1  -> Must have"]
["1.5.4","Facility to record Inventory information of the content of the kit and expiration date ","1  -> Must have"]
["1.5.5","Expiration date of consumable must be recorded for purposes of stock control.","1  -> Must have"]
["1.5.6","Ability to view on the number of items currently not assigned to a person or other AHU. These items are the stock/surplus. Functionality is used to manage stock and ensure sufficient surplus available to suit demand and may trigger request for procurement","2  -> Very important"]
["1.5.7","Provision to automatically generate item numbers based on system parameters","3  -> Important"]
["1.5.8","Supports Item variant and alternate items","3  -> Important"]
["1.5.9","Supports item groups based on user-defined criteria for analysing, querying and reporting","2  -> Very important"]
["1.5.10","Supports multiple units of measurement and conversion factors as generic or specific to stocks","3  -> Important"]
["1.5.11","Supports lot number and serial number type for an item","2  -> Very important"]
["1.5.12","Maintains a master set of standard remarks / reasons used for transactions","3  -> Important"]
["1.5.13","Support  asset/stock details inquiry in many ways (eg.  Quantity consumed/checked out/In Stock  in time period, Quantity checked out/consumed by Mission , Asset type, Purchase Order etc)","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.6,"Storage and Stock Maintenance","N/A","N/A"]
["1.6.1","Supports multiple levels of storage addressing location, warehouse, zone, bin","3  -> Important"]
["1.6.2","Supports warehouse without zones and bins","3  -> Important"]
["1.6.3","Facility to allocate storage for items requiring specific storage environment to a specific area","4  -> Nice to have"]
["1.6.4","Facility to maintain stock status as accepted / rejected / held / assigned","1  -> Must have"]
["1.6.5","Supports stock/Goods receipt","2  -> Very important"]
["1.6.6","Supports  stock issue","1  -> Must have"]
["1.6.7","Supports stock valuation methods such as FIFO, weighted average and standard cost","1  -> Must have"]
["1.6.8","Ability for the AHU to create consumable categories/subcategories and manage  it's own items","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.7,"Asset  Maintenance","N/A","N/A"]
["1.7.1","Ability to define measurable attributes of an equipment as parameters which reflect the condition of the equipment","1  -> Must have"]
["1.7.2","Supports attaching notes, drawings or any other document to equipment","1  -> Must have"]
["1.7.3","Supports maintenance work order creation  and attaching documents e.g. Maintenance Contract ","1  -> Must have"]
["1.7.4","Ability to generate maintenance forecast by equipment/ group of equipment","1  -> Must have"]
["1.7.5","Supports recording running hours/meter readings  and generate periodic maintenance automatically","3  -> Important"]
["1.7.6","Supports scheduling of periodic maintenance.","1  -> Must have"]
["1.7.7","Enter replacement/maintenance schedule with details such as Type (Replacement/Service),Cycle (e.g. daily, weekly, annually),Resources required (contractor/ OPCW staff member),Comments.","1  -> Must have"]
["1.7.8","Supports notification for replacement /service via an email reminder and/or report  with details such as Item,Description,Location,Type (Replacement/Service), Date due","1  -> Must have"]
["1.7.9","Supports recording contact information such as  internal departments/locations or external service provider details.","1  -> Must have"]
["1.7.10","Supports recording warranty information about the asset","2  -> Very important"]
["1.7.11","Supports creation of maintenance work order with the details of  equipment/repair procedures, parts, spares and other costing types  and attaching documents e.g. Maintenance Contract.","1  -> Must have"]
["1.7.12","Supports creation of urgent work order","3  -> Important"]
["1.7.13","Supports generation of purchase requisition from maintenance work order","3  -> Important"]
["1.7.14","Supports creation of service request to record any problem to be included in the future maintenance work order","2  -> Very important"]
["1.7.15","Supports maintaining asset history which includes previous maintenance history, cost warranty information, current work orders etc.","1  -> Must have"]
["1.7.16","Supports automatic notification if the same components or parts are replaced during warranty period ","3  -> Important"]
["1.7.17","Supports preparation of maintenance budgets for individual equipment locations for a fiscal year, on the basis of expense history","1  -> Must have"]
["1.7.18","Supports entering equipment fault/problem details such as  Description, Date sent for repair, Date of (return from) repair, Contractor (Company) or OPCW personnel (Name of technician) who repaired the fault, Total cost of repair, Name OPCW personnel who tested the repair work & date tested, Location work is carried out","1  -> Must have"]
["1.7.19","Capability to view the repair history of a specific asset such as number of times the property was repaired,  Total cost of repair work etc.","1  -> Must have"]
["1.7.20","Supports recording test results","2  -> Very important"]
["1.7.21","Supports recording calibration details","2  -> Very important"]
["1.7.22","Supports creation of a trouble shooting guide by associating a set of problems, their causes and the corresponding solutions to failure groups","1  -> Must have"]
["1.7.23","Facility to record details of contracts for maintenance of equipment and supply of resources","1  -> Must have"]
["1.7.24","Supports inquiry of  the status of each property item (Status: Available, Maintenance and Assigned)","1  -> Must have"]
["1.7.25","Facility to update asset location after completion of the repair. Eg. After repair asset could be placed in a store room/assigned location. List of all asset placed in the store room should be viewable  in the system and could be exported in excel.","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.8,"Asset Disposal/Write Off","N/A","N/A"]
["1.8.1","Supports workflow for disposal/write off transactions with possibility to add comments during approval process.","3  -> Important"]
["1.8.2","Supports asset write off/ disposal request with details such as Asset Code (given by OPCW),  Case number (e.g. 003/07 - Sequential number + Year),   Requesting Officer (person requesting the disposal), Requesting officers Functional title, Requesting Office (Division and Branch requesting the disposal, Asset serial number, Barcode,Purchase Order Number, Quantity, Description, Year of purchase, Purchase Value, Net Book Value,  Carrying  amount,Choice of destruction(Sale, Donation etc), Reason for write Off(Wear & Tear, Loss, Damage etc), Justification,Delivery date (date item was received),Mode of acquisition (i.e. donation, purchase) etc","1  -> Must have"]
["1.8.3","Supports updating  Asset status to  “Submitted to PSB”  or Awaiting Disposal","3  -> Important"]
["1.8.4","Supports view disposal/write-off request displaying details such as Asset Code (given by OPCW),  Case number (e.g. 003/07 - Sequential number + Year),   Requesting Officer (person requesting the disposal), Requesting officers Functional title, Requesting Office (Division and Branch requesting the disposal, Asset serial number, Barcode,Purchase Order Number, Quantity, Description, Year of purchase, Purchase Value, Net Book Value,  Carrying  amount,Choice of destruction(Sale, Donation etc), Reason for write Off(Wear & Tear, Loss, Damage etc), Justification,Delivery date (date item was received),Mode of acquisition (i.e. donation, purchase) etc","1  -> Must have"]
["1.8.5","Supports recording of disposal/write off review details such as Decision of the board (Approved/Rejected), Date of decision PFO, Date of decision DG (where required),  Reference number (unique number used by requestor), Other information / remark (free text)","1  -> Must have"]
["1.8.6","Supports recording details such as condition of equipment (i.e. Obsolete, Broken), Method of disposal (i.e. Donation)","1  -> Must have"]
["1.8.7","Supports recording receipt of property transfer(Third party) (a signed attachment),Reference number of memo to Finance, Amount of miscellaneous income ","1  -> Must have"]
["1.8.8","Facility to run reports including or excluding Assets /Items having the status “written-off”   from inventory reports. ","1  -> Must have"]
[null,null,"N/A","N/A"]
[1.9,"Report Capabilities","N/A","N/A"]
["1.9.1","Supports running reports in multiple languages(English,French,Spanish,Arabic,Russian,Chinese)","1  -> Must have"]
["1.9.2","Supports exporting reports to excel,word, pdf format","1  -> Must have"]
["1.9.3","Report on stock control of a particular item (Description, Category, Quantity, location, expiry date)","1  -> Must have"]
["1.9.4","Automatic report on items expiry in user defined days with user defined filter criteria must be preloaded and sent by email to predefined users (Listing, Item Name, Expiry date and location which could be a place in the building or a Mission name)","1  -> Must have"]
["1.9.5","List of items per mission, location, on loan (Fields displayed are Category, Description,  Quantity, location,  expiry date,type of asset)","1  -> Must have"]
["1.9.6","List of items under repair, or written off (Fields displayed are Category, Description,  Quantity, location,  expiry date,type of asset)","1  -> Must have"]
["1.9.7","Facility to create user defined reports on all data captured in the system","1  -> Must have"]
["1.9.8","Capability to report on the maintenance cost of an inventory item or group of items.","1  -> Must have"]
["1.9.9","Detailed reports on all assets maintained and located in a given property holding unit","1  -> Must have"]
["1.9.10","Detailed reports on all assets purchased or donated or on loan or leased or rented by the whole organization in any given period with additional filter criteria","1  -> Must have"]
["1.9.11","Detailed reports on all assets written off by the OPCW (and a given AHU) within a range of period","1  -> Must have"]
["1.9.12","Detailed reports on all assets valued by the OPCW (and a given AHU) between 250-1000 euro","1  -> Must have"]
["1.9.13","Detailed reports on all assets valued by the OPCW (and a given AHU) above 1000 euro","1  -> Must have"]
["1.9.14","Detailed reports on all  locations within the organization of a certain asset type","1  -> Must have"]
["1.9.15","Detailed reports should have the following details  Barcode ,PO Number (If purchased PO number used to acquire the item,Item No. (Ascending number w/row count, not unique), Date of Acquisition, Date of Delivery/Inservice , Category (generic categorization designated by the user. e.g. table), Description (long description of the item), Unit Price (cost of each item excluding Tax.),Units (number of unique items held), Mode of Acquisition Purchased, On Loan, Serviceable Life  (number of years the item is expected to last), Property Holding Unit ISB, ISS etc. (3 digit code of the Asset Holding Unit),Status Values(In use, Presented to PSB, Disposed).  User should be able to filter asset by different filter criteria ( Asset categories, barcodes, PO numbers, etc)","1  -> Must have"]
["1.9.16","Total value of asset held grouped by AHU with additional filter criteria.","2  -> Very important"]
["1.9.17","Status of current asset items grouped by AHU with additional filter criteria","3  -> Important"]
["1.9.18","Status of current inventory items on assignment/loan within the OPCW with additional filter criteria","2  -> Very important"]
["1.9.19","Assets issued to an OPCW employee with additional filter criteria.","2  -> Very important"]
["1.9.20","Supports user defined report functionality using all fields available in Asset, Stock and/or Maintenance modules","1  -> Must have"]
["1.9.21","Supports calculation function in the user report","1  -> Must have"]
["1.9.22","Supports reports on \"imported\" or pending \"receipt assets\"","1  -> Must have"]
["1.9.23","Support reporting and filtering on many ways (eg.  Quantity consumed/checked out/In Stock  in time period, Quantity checked out/consumed by Mission , Asset type, Purchase Order etc)","1  -> Must have"]
["1.9.24","Supports printing out the individual requests for  disposal/ write-off for submission to the Board","1  -> Must have"]

{"sheet":"16-NF","index":18,"n_rows":92,"n_cols":6,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[null,"Non-Functional Requirements","OPCW Comments","OPCW Priorities \n(1 - 5)","Vendor Response","Vendor Comment"]
[]
[1.1000000000000001,"IT-Infrastructure Requirements"]
["1.1.1","Supports SMTP Integration","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","1  -> Must have"]
["1.1.2","Supports Integration with  MS Office/Office 365","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","2  -> Very Important"]
["1.1.3","Application  client runs on Windows operating system and Supports Browser based client (Internet Explorer/Chrome etc) and Browser Independent ","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","1  -> Must have"]
["1.1.4","System uses Microsoft SQL Server as back end database.","This requirement is valid for in-house IT Delivery Scenario (if fully outsourced requirement is about integration, not necessarily platform)","1  -> Must have"]
["1.1.5","Supports storing data in unicode characters( Supports recording Item description in 6 languages ( English, Spanish, French, Arabic,Russian,Chinese)","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","1  -> Must have"]
["1.1.6","Supports mobile  and hand held devices devices, (Android, IOS, Blackberry,Windows OS)","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","3  -> Important"]
["1.1.7","Support  data migration and profiling tools",null,"1  -> Must have"]
["1.1.8","(DR) Recovery Time = 5 business day or less","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","1  -> Must have"]
["1.1.9","(DR) Recovery Point = 1 business day or less","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","1  -> Must have"]
["1.1.10","A backup solution for the overall system (data, application, models, etc) must be available","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","1  -> Must have"]
["1.1.11","Is compatible, supported and certified for deployment with VMWare virtualization, NetApp SAN and Bluecoat proxy","This requirement is valid for in-house IT Delivery Scenario","1  -> Must have"]
[null,null,null,"N/A","N/A"]
[1.2,"Integration",null,"N/A","N/A"]
["1.2.1","Supports Integration with SharePoint","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","3  -> Important"]
["1.2.2","Supports security integration with Active Directory Service (ADS) and supports single sign-on.",null,"4  -> Nice to have"]
["1.2.3","Supports future integration and interfaces by means of open architecture and/or APIs (eg.  Capability to integrate with((Library  Management system, Mission Planning Tool, Communications Manager, Medical Administration system, Online Banking system (Acess online) )",null,"2  -> Very Important"]
["1.2.4","Supports back end integration/data sharing with Windows SQL Databases",null,"1  -> Must have"]
["1.2.5","Supports ad interim integration with legacy systems in scope of ERP project (if phased approach)","This requirement is only valid if implementation approach is phased (if big bang there's no need)","2  -> Very important"]
["1.2.6","Supports security certificates from either internal CA or public CA  eg. Https,PKI","Which one will depend on delivery model","2  -> Very Important"]
["1.2.7","Support file attachments hosted in CIFS server, if external storage for attachments is needed","This requirement is only valid if attachments are stored outside the system; otherwise it is not relevant","3  -> Important"]
["1.2.8","Light weight remote access of the system  by users and system administrators","This requirement is valid for in-house IT Delivery Scenario","3  -> Important"]
["1.2.9","Supports Electronic data interchange (EDI) for electronic exchang eof documents ( Purchase Order, Invoice, etc.)","This requirement is valid for any IT Delivery scenario (in-house, outsourced)","4  -> Nice to have"]
[null,null,null,"N/A","N/A"]
[1.3,"IT Security & Control",null,"N/A","N/A"]
["1.3.1","Configurable User, role, and group security to establish segregation of duties and restrict application accessibility as needed",null,"1  -> Must have"]
["1.3.2","Supports profiling with AD Groups","This requirement is valid for in-house IT Delivery Scenario","4  -> Nice to have"]
["1.3.3","Supports security module for updating user roles in all functional areas (Grant/Change/Revocation)",null,"3  -> Important"]
["1.3.4","Supports delegations based upon user roles ",null,"2  -> Very Important"]
["1.3.5","Supports user name and password along with an integrated security grid for user access rights",null,"2  -> Very Important"]
["1.3.6","Supports audit log mainly recording successful and unsuccessful attempts to the following: Logon, Transaction, Report, changes to Master and Audit Records ","OPCW Policy (AD/ADM/017) 4.17","1  -> Must have"]
["1.3.7","Supports procedures for labelling and handling sensitive information ","OPCW Policy (AD/ADM/017) 1.05","2  -> Very important"]
["1.3.8","Shall allow configuration  of controls for proper protection when taking sensitive ERP assets offsite  ","OPCW Policy (AD/ADM/017) 3.02","2  -> Very important"]
["1.3.9","Access to ERP applications shall granted based on app accounts that can be uniquely traced back to individuals  using their OPCW Staff ID","OPCW Policy (AD/ADM/017) 5.02a, 5.05","2  -> Very important"]
["1.3.10","All users must be able to change their own account password(if system doesn't support single sign on)","OPCW Policy (AD/ADM/017) 5.06","1  -> Must have"]
["1.3.11","Passwords must not be transmitted in clear text","OPCW Policy (AD/ADM/017) 5.05,5.08","1  -> Must have"]
["1.3.12","All applications storing/processing sensitive personal information (e.g. Sofi Numbers,Passport Numbers,Driver’s license number, Country identification numbers) shall encrypt such information at any level: field, file, database, or disk.","This requirement is valid for outsourced  IT Delivery Scenario","2  -> Very Important"]
["1.3.13","All applications storing/processing sensitive health & safety information  (e.g. Health and medical information) shall encrypt such information at any level: field, file, database, or disk.","This requirement is valid for outsourced  IT Delivery Scenario","2  -> Very Important"]
["1.3.14","All applications storing/processing sensitive financial information (e.g. Credit card numbers,Bank account numbers) shall encrypt such information at any level: field, file, database, or disk.","This requirement is valid for outsourced  IT Delivery Scenario","2  -> Very Important"]
[null,null,null,"N/A","N/A"]
[1.4,"BI Capabilities",null,"N/A","N/A"]
["1.4.1","Delivers ad-hoc analysis, report creation and dashboarding as either an integrated component or as a recommended and certified third party solution",null,"1  -> Must have"]
["1.4.2","Delivers pre-packaged reporting and analytics as either an integrated component or as a recommended and certified third party solution","Existing Cognos toolset is EOL and to be replaced within the scope of the ERP project","3  -> Important"]
["1.4.3","Supports delivery of reports in English, Spanish, French, Arabic,Russian,Chinese",null,"2  -> Very Important"]
["1.4.4","Supports drill-down capability of transactional activities to display the underlying transactions",null,"3  -> Important"]
["1.4.5","Supports inclusion of non-ERP data into the BI solution without ETL or modular integration",null,"4  -> Nice to have"]
[null,null,null,"N/A","N/A"]
[1.5,"System Support",null,"N/A","N/A"]
["1.5.1","Software components must be fully supported by vendor without need of major/forklift upgrade/system overhaul under at least 7 years beyond implementation","Regular updates/patches are fine","1  -> Must have"]
["1.5.2","12/5 Technical support facility for the application, Provides supports to OPCW by telephone, portal or email  between 08.00 AM TO 20.00 PM ( Netherlands time)",null,"1  -> Must have"]
["1.5.3","Provide different modes support services( Self Service /Remote/Onsite)",null,"3  -> Important"]
["1.5.4","Facility to reports incident electronically through support portal and sets priority of incident based on the severity and urgency. Vendor provide the support as per the prioritisation of the incident ",null,"3  -> Important"]
["1.5.5","Supports a platform with Frequently Asked Question  and Knowledge base database for solving common first line support issues.",null,"2  -> Very Important"]
["1.5.6","Provide 3rd level remote access supports for critical issues",null,"3  -> Important"]
["1.5.7","Provide root cause analysis of the critical issues and provide solution for preventing such incident in the future",null,"2  -> Very Important"]
["1.5.8","Application support as per the agreed service leval agreement between OPCW and the vendor",null,"1  -> Must have"]
["1.5.9","Notify application administration team for major and minor  new releases of the product with change  on the data structure,  Graphical User Interface, Reports, limitations on backward compatibility, Web browser version support, Mobile devices support and whether or not new releases are mandatory.",null,"3  -> Important"]
["1.5.10","Product support is backward compatible across major releases for at least 7 years from version release date","This requirement is valid for in-house IT Delivery Scenario","3  -> Important"]
["1.5.11","Provide user group support",null,"3  -> Important"]
["1.5.12","Supports for management of upgrades (new releases) in the solution by the vendor (eg.Comparison current customisation which need to  upgraded or not)",null,"2  -> Very Important"]
["1.5.13","Supports  release of individual patches/cummulative patches",null,"2  -> Very Important"]
["1.5.14","Provide application supporting tools such as up to date documents/education or training/Process documentation/online help etc.",null,"3  -> Important"]
["1.5.15","Supports delivery of As-Built documentation for updating CMDB",null,"2  -> Very Important"]
["1.5.16","Provide end user web based learning tool that delivers out-of-the-box training ",null,"4  -> Nice to have"]
[null,null,null,"N/A","N/A"]
["1.6","System and Information Architecture",null,"N/A","N/A"]
["1.6.1","The architecture for the transactional solution (ie not including BI) is singular and unified with fully native integration of common data and processing elements across function areas and modules","Solution must have an operating model with lowest potential cost (budget and staffing)","2  -> Very Important"]
["1.6.2","Solution supports import and process modelling standards such as UML",null,"4  -> Nice to have"]
["1.6.3","Solution can potentially be deployed in a multi-company format with separation of data, security and processes","This is relevant for both in-house and hosted formats and may be required for potential JV's or shared-services concepts","3  -> Important"]
["1.6.4","Solution has a proven track record in hosted environments with system capabilities supporting ISAE 3402 compliance ","This is relevant for both traditional 'on-premise' but hosted and SAAS formats ","2  -> Very Important"]
["1.6.5","Solution has certified integration with document management solutions to access/store organisational records needed in administration processes (eg. commercial contracts)","This is relevant for both in-house and hosted formats ","3  -> Important"]
["1.6.6","Solution has configurable archiving capability for transactional records such that operational performance is optimised and historical data is searchable while containing infrastructure costs to minimum","This is valid for in-house IT Delivery Scenario","3  -> Important"]
["1.6.7","When solution is designed and certified to operate as a hybrid architecture such that some functions and processes can be deployed on-premise while others are hosted externally or accessible on a subscription basis",null,"2  -> Very Important"]
[null,null,null,"N/A","N/A"]
[1.7,"Solution Marketplace",null,"N/A","N/A"]
["1.7.1","The provider has an active product advisory board for the solution in scope with significant presence by non-profit sector customers","This is relevant for both in-house and hosted formats ","1  -> Must have"]
["1.7.2","The solution provider has a channel-partner strategy that includes specialisation in non-profit sector",null,"3  -> Important"]
["1.7.3","The solution supports and has certified partners that deliver externalised AMS and user provisioning","This is valid for in-house IT Delivery Scenario","2  -> Very Important"]
["1.7.4","Local support and consultation capability (without incurring international T&M) delivered either by direct staffing from supplier or certified channel partner","This includes technical and functional consulting/trouble-shooting capability","1  -> Must have"]
[null,null,null,"N/A","N/A"]
[1.8,"Data Management",null,"N/A","N/A"]
["1.8.1","Supports regular back up of all data using appropriate and reliable storage media","This requirement is valid for outsourced  IT Delivery Scenario","1  -> Must have"]
["1.8.2","Retain backup copies for six months or more  and supports restoration of backup at any given time based on request","This requirement is valid for outsourced  IT Delivery Scenario","1  -> Must have"]
["1.8.3","Supports data transfer upon termination or expiration of the agreement in mutually agreed format with sufficient automatic tools/methods","This requirement is valid for outsourced  IT Delivery Scenario","1  -> Must have"]
["1.8.4","The provider is registered in one of the following Member States of the OPCW that have recognised the privileges and immunities of the OPCW; the provider further complies with the requirements to support data storage and maintenance location restricted exclusively to the territory of the following Member States of the OPCW .Albania,2.Argentina,3.Austria,4.Belarus,5.Bosnia and Herzegovina,6.Bulgaria,7.Burkina Faso,8.Burundi,9.Chile,10.Cyprus,11.Czech Republic,12.Denmark,13.Dominican Republic,14.El Salvador,15.Estonia,16.Finland,17.Greece,18.Kenya,19.Latvia,20.Mali,21.Malta,22.Mauritius,23.Netherlands,24.Panama,25.Philippines,26.Poland,27.Portugal,28.Republic of Korea,29.Serbia,30.Slovakia,31.South Africa,32.Spain,33.Switzerland,34.United Arab Emirates,35.United Kingdom,36.United States of America,37.Uruguay)","This requirement is valid for outsourced  IT Delivery Scenario","1  -> Must have"]
[null,null,null,"N/A","N/A"]
[1.9,"System Configuration Tools",null,"N/A","N/A"]
["1.9.1","Built-in risk mitigation tools for configuring and enabling audit trails for important transactions","This requirement is valid for outsourced  IT Delivery Scenario","1  -> Must have"]
["1.9.2","Built-in business process management configuring workflow automation, enforce controls and implementation of rules & policies.","This requirement is valid for outsourced  IT Delivery Scenario","3  -> Important"]
["1.9.3","Supports User development kit for adding or configuring  forms, controls , workflow etc. (Eg. Creating a new screen for making request for Salary Advance with a electronic workflow)","This requirement is valid for outsourced  IT Delivery Scenario","3  -> Important"]

{"sheet":"KEY","index":19,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["1. Priority: "]
[]
["1  -> Must have"]
["2  -> Very important"]
["3  -> Important"]
["4  -> Nice to have"]
[]
[]
["2. Response Code - Functional Requirement",null,"Short Definition"]
[]
["Y","—Yes","Requirement will be met"]
["N","—No","Requirement will not be provided"]
["C1","—Customisation","Requirement will be met by customising existing software or through the use of software tools"]
["C2","—Customisation","Requirement will be met by customising existing software as a suplementary service"]
["UD","—Under Development","Requirement will be met by packaged software that is currently under development"]
["P","—Planned for a future release","Requirement is planned for a future release"]
["TH","—Supplied by 3rd Party","Requirement will be met by Integration with 3rd party software package which can included in the final proposal"]
[]
[]
["3. Response Code - Non- Functional Requirement",null,"Short Definition"]
[]
["Y","—Yes","Requirement will be met"]
["N","—No","Requirement will not be provided"]
["C1","—Work-around","Service can be provided  as part of the basic software package"]
["C2","—Work-around","Service can be provided as a suplementary service"]
["UD","—Under Preparation","Required service  is currently under development"]
["P","—Planned for a future release","Requirement is planned for a future release"]
["TH","—Supplied by 3rd Party","Supplied by 3rd Party-Requirement will be met by Integration with 3rd party Solution/Service  which can included in the final proposal."]