Technology Evaluation Centers Inc. Request for Information/Proposal Requirements Research
Instructions
Rating Legend Format
● The top of the RFI tab contains six response columns. ● TEC analysts developed the RFI based on past experience and research into the widest and deepest range of possible requirements. 3RD Response Explanation SUP Supported as delivered "out-of-the-box" MOD Supported via modifications (screen configurations, reports, GUI tailoring, etc) Supported via a third party solution Supported via customization (changes to source code) Will be supported in a future release Not supported 0 to 10, where 10 is most important
Priorities
Must Have = 10 Very Important = 8 Important = 6 Nice to Have = 4 Not Important = 2 No Need = 0 Note this file contains multiple sheets (tabs). This sheet contains instructions only. Click the tabs at the bottom of the window to access the criteria.
CST FUT NS Priority
Mandatory Yes, only for "must-have" factors
RFI Example Vendor Responses
● Complete the RFI worksheet by placing an X in the appropriate column for each criterion. ● The Xs must represent the current state of a product or service. 1 1.1 1.1.1 1.1.1.1 1.1.1.2 1.1.1.3 1.1.1.4 1.1.1.5 1.1.1.6 Hierarchy Module 1 Category of Module 1 Subcategory of Category 1 Criterion 1 Criterion 2 Criterion 3 Criterion 4 Criterion 5 Criterion 6 Criterion
© Technology Evaluation Centers Inc. 2007. This document may only be used for internal purposes. Reproduction and
User Responses
● Use the Priority column to indicate how important a particular criterion or entire group of criteria (module or category) is for your organization. ● The Mandatory column is useful for indicating absolute requirements. Note that a "Yes" would mean a vendor/provider fails if it does not support that criterion or group of criteria. It is often useful to use "No" as the general default response and only change to a "Yes" for an absolutely critical item. Don't forget to indicate your priorities and mandatory requirements for modules, categories, subcategories, and criteria.
RFI Example
Priority (0-10) 8 4 10 1 6 4 10 8 8 Mandatory (Y/N) N N N N Y N N N Y X X X X X X SUP MOD 3RD CST FUT NS
l purposes. Reproduction and redistribution are strictly prohibited.
Technology Evaluation Centers Inc. ERP for Mill-Based and Material Converting Environments Criteria Worksheet
Hierarchy Criterion Priority Mandatory SUP MOD 3RD CST (0-10) (Y/N)
1 1.1
Financials General Ledger
1.1.1 1.1.1.1
Parameters and Structuring Lean manufacturing accounting practices and methods (i.e., manufacturing overheads based on cycle time including labor) Fiscal calendar is defined by the user Calendar periods are defined by the user Calendar can be defined as uneven periods, adjustment periods, or into a maximum of 366 periods Multiple calendars
1.1.1.2 1.1.1.3 1.1.1.4
1.1.1.5
1.1.1.6 1.1.1.7 1.1.1.8
Multi-entity financial reporting Fiscal monthly period options for twelve or thirteen months Fiscal quarterly periods can be defined as 4-4-5, 5-4-4, or 4-5-4 Organization of the calendar period defined by the user Calendar may be organized in a variety of ways with up to 999 user periods Open any number of fiscal years or calendar periods at the same time Companies with different regional presences may set a default currency for the financial division of each region
1.1.1.9 1.1.1.10 1.1.1.11 1.1.1.12
1.1.1.13 1.1.1.14 1.1.1.15 1.1.1.16 1.1.1.17 1.1.1.18 1.1.1.19
The reporting entity may determine organization of the financial information Distinguish A/P transactions (of the same type) from different entities Each entity's ledger can have its own calendar and chart of accounts Each entity's ledger can have its own accounting periods opened and closed User may choose between data collection and real time posting modes Tracks items in the G/L and sub-ledger by quantity and value (in whichever currency is used) Maintain unit and dollar amount postings in GL and subledgers
1.1.1.20
1.1.1.21
1.1.1.22
User defined criteria for system purges for general ledger transactions, journal vouchers, and accounts payable data based on the number of years or months of data required to maintain--each purge type has its own unique criteria Sub-ledgers closed out prior to performing a purge. The closeout process sets all financial account balances in the sub-ledger to zero by posting an equal and offsetting transaction Specify a key and rules to have the system automatically purge all records related to the key throughout the system--sub-ledger accounts, sub-ledger transactions, tables, rates Automatic check to ensure that prior to deleting a financial record, the account balance must have been "closed out" i.e. nets to zero Translation of balance sheet accounts including the ability to have a default rate (spot) that can be overridden on an exception basis (historic), on an account-byaccount basis - do not want to set up a rate for every balance sheet account - the override rates will differ ledger to ledger Automatically insert actual account balances into the elapsed month's bucket in a future forecast file at the end of each accounting period when the system rolls into the next period Prevent roll from one accounting period to the next unless the last job run is the financial statements Audit log required for any changes to table information that may contain rates and information, which is used by the system in any way--before, after, change, date, and who
1.1.1.23
1.1.1.24
1.1.1.25
1.1.1.26
1.1.1.27
1.1.1.28
Flexible general ledger key with multiple levels
1.1.1.29
Exception reporting with drill down capabilities
1.1.1.30
Change cross charge percentages without retroactively changing previously published financial information Provision for use of standards that can be automatically propagated throughout the system to the various ledgers Integration with ADP electronic transmission of payroll data Use the budget forecast information to create automatic postings; accruals for any potential overhead item, for example, bonus, depreciation, professional fees, new product development, and marketing expense; support standard (automatically repeating) postings and 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 Automatic year-end rolling of balances in sub-ledgers and general ledger control accounts.
1.1.1.31
1.1.1.32 1.1.1.33
1.1.1.34
1.1.1.35 1.1.1.36 1.1.1.37 1.1.1.38 1.1.1.39 1.1.1.40 1.1.1.41
Automatic linking and posting of control accounts from related sub-ledger accounts Process jobs in edit and update mode Jobs required to include error and warning messages on reports Reports to include a control report that lists pages on which errors and warnings have occurred User-defined controls to allow specific jobs to update multiple times in a period View postings at the company, market, and title/SKU level Table master functionality--set parameters in a table, have jobs read the table and create postings or reports accordingly User-defined field names for tables Method for verifying keying to ensure only appropriate records updated Archiving of transaction history as well as purge from active files
1.1.1.42 1.1.1.43 1.1.1.44
1.1.2
Chart of Accounts Structure
1.1.3 1.1.4 1.1.5
This category contains 48 criteria below it. Ledger Development and Management This category contains 14 criteria below it. Enterprise Reporting Structure This category contains 15 criteria below it. Journal Entry and Reporting
1.1.6
This category contains 44 criteria below it. Journal Vouchers
1.1.7 1.1.8 1.1.9 1.1.10 1.1.11 1.2
This category contains 41 criteria below it. Controls for Ledgers This category contains 7 criteria below it. Multicurrency Capabilities This category contains 24 criteria below it. Online Inquiry Reporting This category contains 9 criteria below it. Report Writing Capabilities This category contains 65 criteria below it. Variable Analysis This category contains 3 criteria below it. Accounts Payable (A/P)
This category contains 245 criteria below it.
1.3
Fixed Assets
1.4
This category contains 94 criteria below it. Cost Accounting
1.5
This category contains 53 criteria below it. Cash Management
1.6
This category contains 16 criteria below it. Budgeting
1.7
This category contains 70 criteria below it. Accounts Receivable
1.8
This category contains 103 criteria below it. Financial Reporting
2
This category contains 36 criteria below it. Human Resources
2.1
Personnel Management
2.1.1 2.1.1.1 2.1.1.2 2.1.1.3 2.1.1.4 2.1.1.5 2.1.1.6 2.1.1.7 2.1.1.8 2.1.1.9 2.1.1.10
Recruitment Management Hiring personnel may access parameters for requisitions Searches for eligible applicants and employees based on job requirements, online Lists the postings, position, disposition, disposition date, and applicable codes of a position Tracks applicants using personal data, skill set, academic qualifications, training, and test results Workflow for forwarding resumes/CVs Schedules interviews Tracks interview results Customizes recruitment letters by merging files with a word processing template Offers and new hires processing Summarizes status and provides other information on applicant, and applicant requisition and recruitment costs Information about applicants' progression
2.1.1.11
2.1.1.12 2.1.1.13 2.1.1.14 2.1.1.15 2.1.1.16 2.1.1.17
Compares data on recruiting tasks to show their effectiveness Sourcing engine integration with career development, matching competencies of internal candidates Internet recruiting and tracking of skills inventory Resume scanning capabilities. Import resumes from the Internet or e-mail Enable competencies for applicants
2.1.1.18
Assign competencies to vacancies
2.1.1.19
Derive competencies automatically from the job or position competency requirements into vacancy competency requirements
2.1.1.20
Enable competence matching between applicant's competencies and vacancies
2.1.2 2.1.3 2.1.4 2.1.5 2.1.6 2.1.7 2.1.8 2.1.9 2.1.10 2.1.11
Profile of Personnel This category contains 14 criteria below it. Organizational Structures This category contains 16 criteria below it. Job Position and Wage Profiles This category contains 21 criteria below it. Career Development and Training This category contains 18 criteria below it. Management of Rewards This category contains 7 criteria below it. Budgeting and Cost Control This category contains 4 criteria below it. Government and Compliance Reporting This category contains 7 criteria below it. Employment History and Personnel Reporting This category contains 8 criteria below it. Track Discipline Actions This category contains 2 criteria below it. Competency Management
This category contains 5 criteria below it.
2.2
Benefits
2.3
This category contains 27 criteria below it. Payroll
2.4
This category contains 76 criteria below it. Employee Self-Service
2.5
This category contains 22 criteria below it. Data Warehousing
2.6
This category contains 13 criteria below it. Health and Safety This category contains 11 criteria below it. Workforce Management This category contains 165 criteria below it. Training This category contains 28 criteria below it.
2.7 2.8
3
Material Converting Manufacturing Management/Mill Industries
3.1 3.1.1
3.1.2 3.1.3
Cut-to-shape Environments Concurrently handle and track several inventory item attributes or specifications such as heat, dimension (width, length, gauge), form, diameter, shape, grade, grain direction or texture, density, and more Consideration of the information on chemical, metallurgical, and physical properties Tracking of inventory up and down the supply chain, including the lot, heat, tag and certifications. The system must deliver up-to-the-minute information about on-hand available inventory, in-transit inventory, replenishment orders, manufacturing schedules and lead times, all while taking the attributes into consideration. Trace the ancestry or genealogy of an inventory tag from PO receipt to customer delivery ticket Detailed search of history information by a master tag number or heat number
3.1.4 3.1.5
3.1.6
3.1.7
Provision of information that shows not only what each customer purchased, but also how much profit (or loss) was generated from that order, part, or tag Quickly configure quotes or sales orders based upon exacting customer specifications, while recognizing that inventory is multi-dimensional and multi-faceted. Convenient cost-plus pricing capabilities that allow users to associate profit margins with materials, labor, or overhead for configured and validated items
3.1.8
3.1.9 3.1.10 3.1.11 3.1.12
Conversion of several UOMs based on the material’s characteristics, such as specific weight or density UOM conversion by attribute can be linked to inventory movements Automatic reflection of changing commodity prices as end product prices Handle specific labeling requirements, packaging requirements, and materials handling capabilities, such as detailed certification or MTR Identification of the ideal raw materials needed to fulfill any given customer order, via a parsed item lookup feature and advanced sorting and filtering capabilities
3.1.13
3.1.14
3.1.15
Quickly view material on order and see when it will arrive, and what the specification and attributes are, when the stock on hand cannot satisfy the requirements for the order Handle buyouts or intra-company material transfers, as required
3.1.16
3.1.17
Specification of the material reservations or allocations by any of a number of attributes, including lot number, roll weight, roll width, and roll length User-definable attributes that can be associated and validated for each item and each piece of stock within that item’s inventory User-definable product attributes and characteristics that can be used for functions such as inventory look-up, order entry, sequencing and scheduling of jobs, etc.
3.1.18
3.1.19
Handle both standard products and non-standard subassemblies (products)
3.1.20
3.1.21
Production planning handles attributes available for scheduling and calculation of material quantities by attribute Variable "policies" for things such as receiving, manufacturing, and shipment, for example in terms of +/quantity or dimensional tolerances, quality or grade measurements, surcharge application, etc. Automatic consideration of shipments as complete when they are within a certain +/- quantity tolerance Accommodation of customer specifications without requiring a new BOM or routing for each new customer configuration during the quoting and order entry process, whereby historical cost and pricing data is available for instant retrieval Flexibility in terms of the user determining what constitutes a separate item number (e.g., a mild steel grade, a mild steel grade standard size sheet, or a mild steel grade standard size sheet that is an inch thick), whereby the end item variants can be handled under the same item number, but with a multiplicity of variations via attributes Optimization of cutting operations, such as dimensional slitting, to minimize waste Allow for blade widths (and accompanying waste) Current orders that can be nested with other open orders (even if for other customers) that can be produced from the same inventory set, whereby an optimal cutting layout to minimize yield is produced which identifies expected remnants, drops, and offcuts
3.1.22 3.1.23
3.1.24
3.1.25 3.1.26 3.1.27
3.1.28 3.1.29
Distinguish scrap and waste from expected remnants that can be further utilized Foresee when a remnant/offcut will be created and determine the size of the remnant
3.1.30
Automatic creation of new part numbers and pricing for the scraps returned to stock, if necessary
3.1.31
Recognition by the specialized MRP (or other planning) module of when current demand cannot be satisfied by the in stock inventory due to dimensional issues and the inclusion of that unsatisfied demand in its reorder messages Provision of the exact location, heat, size, and quantity of material to pull from inventory Display of the finished product, scrap, and remnants the company is expected to produce Employees may record actual products produced and record the time expended to produce them Production reporting capabilities that are attuned to operations such as mill rolls, coating, laminating, wide roll slitting, and tape slitting User definition of carriers, shipment methods, freight rates, and customer routes for shipping and receiving Interface with common third-party shipping and manifest software (e.g., Kewill's Clippership) RF or barcode functionality that provides the following transactions to help ease data collection: inventory move within a facility, print location labels, shipping, physical inventory, and cycle counting Configurable e-mail alerts that automatically notify the right people when an exception condition occurs Sales ordering by attribute affects pricing, lead times and promising, transport requirements, etc. User-defined attribute linking This category contains 16 criteria below it. Attribute Types This category contains 4 criteria below it.
3.1.32 3.1.33 3.1.34 3.1.35
3.1.36 3.1.37 3.1.38
3.1.39
3.1.40 3.1.41 3.1.42
3.2
3.3
Plastic Injection Molding, Blow Molding, Thermoforming, Transfer Molding, Reaction Injection Molding, Compression Molding, Vacuum Forming, and Extrusion Environments This category contains 27 criteria below it. Wire and Cable Manufacturers This category contains 13 criteria below it. Hazardous Material Reporting
3.4
3.5 3.6 3.7
This category contains 16 criteria below it. Quality Testing and Regulatory Compliance This category contains 5 criteria below it. Process Manufacturing Costing This category contains 9 criteria below it. Product Costing This category contains 107 criteria below it. Shop Floor Control
3.8
3.9
This category contains 391 criteria below it. Production Planning
4 4.1 4.1.1
This category contains 291 criteria below it. Inventory Management Inventory Management--Online Requirements Maintain item number history of usage, both planned and unplanned, and purged upon a specific date criteria Provide inquiry and reporting capability for inventory transactions by item number, location, and transaction type. Provide reporting capability by item number (all transactions since last cycle count) Provide inquiry and reporting capability for inventory transaction summary by from and to dates Provide inquiry and reporting capability for inventory status by item number and serial number
4.1.2
4.1.3 4.1.4 4.1.5
4.1.6 4.1.7
4.1.8 4.1.9 4.1.10 4.1.11 4.1.12 4.1.13 4.1.14 4.1.15
Provide inquiry and reporting capability for slow moving and obsolete inventory Provide inquiry and reporting capability for negative balance inventory and flagging upon this condition occurring Provide inquiry and reporting capability for shortages and backorders Provide capability to track items by lot or serial number Management of leasing and rotable spares Visibility and management of remote site or distributed inventories and rotable spares Identify type of transaction Identify the source of demand Part text files with forced viewing on screen System must be capable of managing harmonized part number information and integrating or maintaining harmonized information with third party (e.g.. freight forwarder) Multi-currency capability Vendor cross reference (infinite number of vendor pt. numbers) with wild-card search capability Internal cross-reference to vendor part numbers Ability to maintain files "up selling" parts based on certain other parts purchased. Ten year look at usage history by year and source of demand Inventory fields that accept part numbers and product configuration codes. Product configuration codes would allow logic behind randomly generated part numbers. On-line request for requisition generation and approval. Electronic "drop ship" capability between buyer/planner and vendors. Buyer/planner should have access to vendors' "on hand" information, launch order with "ship to" information Pricing (selling prices) must have ability to price given various conditions (i.e. export pricing multipliers, subsidiary pricing multipliers, domestic pricing multipliers). Selling prices may be controlled based on different commodity tables (for example, hydraulics carry different multipliers than "make parts" or other commercial parts). Bar coding of individual parts as received prior to warehousing, real time scanning, and inventory updates at picking, and real time scanning at shipping.
4.1.16 4.1.17 4.1.18 4.1.19 4.1.20 4.1.21
4.1.22 4.1.23
4.1.24
4.1.25
4.1.26
4.1.27 4.1.28 4.1.29 4.2 4.3 4.4
Ability to label and track country of origin on parts and in operating system. Automated pick system sorted by grid location. Ability to structure material to a buy item, supporting ECN control capabilities Processing Requirements This category contains 28 criteria below it. Data Requirements This category contains 12 criteria below it. Reporting and Interfacing Requirements (Inventory Management) This category contains 9 criteria below it. Locations and Lot Control This category contains 20 criteria below it. Forecasting This category contains 51 criteria below it. Reservations and Allocations This category contains 26 criteria below it. Adjusting Inventory This category contains 8 criteria below it. Purchasing Management
4.5 4.6 4.7 4.8 5
5.1 5.1.1 5.1.2 5.1.3 5.1.4 5.1.5
Profile of Suppliers Fields for supplier data such as shipping methods, item references, and conditions Suppliers may have more than one address Store e-mail addresses, web sites, and fax numbers in vendor profiles Associate items with vendors' descriptions Code different vendor production lead times, taking into account both supplier lead time and transport time Bill-to-entity information including currency, bank, account number, and mode of payment Data related to bank, accounts, payment methods, currency, etc., are included in the payment profile Vendor shipment process with terms and acceptance requirements for reception A primary vendor can be set as the default for each class Vendor group for miscellaneous purposes Identifier for approved vendors Commentary about suppliers On-line Requirements This category contains 20 criteria below it. Rating of Suppliers
5.1.6 5.1.7 5.1.8 5.1.9 5.1.10 5.1.11 5.1.12 5.2 5.3
5.4 5.5 5.6 5.7 5.8 5.9 5.10 5.11 5.12
6
This category contains 13 criteria below it. Requisitions and Quotations This category contains 13 criteria below it. Purchase Orders (POs) This category contains 62 criteria below it. Pricing This category contains 13 criteria below it. Vendor Contracts and Agreements This category contains 16 criteria below it. Management of POs This category contains 25 criteria below it. Procurement Reporting and Online Reporting This category contains 24 criteria below it. Repeat Procurement This category contains 19 criteria below it. Receipts for Procurement This category contains 30 criteria below it. Reporting and Interfacing Requirements for Purchasing Management This category contains 18 criteria below it. Quality Management
6.1 6.2 6.3 6.4 6.5 6.6 6.7 6.8 6.9 6.10 6.11 6.12 6.13 6.14 6.15
Defective or excess material return processing must update on-hand Damaged material--corrective action and failure analysis available to vendor on-line Flags need to perform inspection of a specific item or a supplier's items Receives items and records as “inventory on hold” when quality inspection is pending Identifies items awaiting or in process of inspection through an online query Validates inspection disposition using criteria that specify inspection process Tracks material inspection dispositions Tracks and reports on non-dispositioned rejects Tracks quantity rejected at inspection Assigns codes to reject descriptions Tracks unresolved rejections Processes material receipts which have failed inspection Corrective actions can be initiated, and processed, and tracked Tracks items for which there is no disposition, or which are rejected pending vendor approval Tracks items awaiting rework order
6.16 6.17 6.18 6.19 6.20 6.21 6.22 6.23 6.24 6.25 6.26 6.27 6.28
Tracks items for which use is conditional on QA statement of acceptable variance Tracks items awaiting return shipment to vendor Provides aggregate supplier quality data Transactions related to material returns to vendors can be performed online Tracks customer-rejected items awaiting disposition from original supplier Automatically updates schedule information for items returned to suppliers Lists authorized alternatives for substitution-approved items Lists authorized vendors for each item Prints document identifying point of return and justification Prints debit memo as part of return-to-supplier process Recalculates average item cost Quality data on-line Requirements grouping using collection plans
6.29 7
Quality document linkage with product master within PDM Sales Management
7.1 7.1.1 7.1.2 7.1.3 7.1.4 7.1.5 7.1.6
7.1.7 7.1.8 7.1.9 7.1.10 7.1.11 7.1.12
On-line Requirements (Sales Management) Accommodate an order type for a new order or quote Accommodate a status field indicating either a quote or a customer order for a new order or quote Create an order from a quote with a reference back to the quote, for a new order or quote Create an order from only selected lines of the quote Decrease the amount quoted Allow for customer account and sales order status online by customer name or number or by sales order number Process and print a special message or memo (at least 300 characters) on the following: 1) Invoice 2) Sales order or quote 3) Bill of lading Validate order dates/MRP dates Accommodate, primarily for the sales order, a customer requested ship date, a due date, and a company expected ship date
7.1.13 7.1.14
7.1.15 7.1.16 7.1.17 7.1.18 7.1.19
Process change orders easily, "pegging" these change orders to the original sales order Change prices easily, including limiting price override capability so that only the sales manager can use it beyond a certain percent of list price Automatically change all the prices by a certain percent or dollar amount Override capability to the automatic pricing Accommodate multiple ship-to addresses for each bill-to address Link each sales order to the appropriate shipping facility (i.e. production facility, etc.) Allow sorting and printing each of the booking, billing, backlog, and backorder reports by sales order number Allow sorting and printing each of the booking, billing, backlog, and backorder reports by customer name Allow sorting and printing each of the booking, billing, backlog, and backorder reports by customer code Allow sorting and printing each of the booking, billing, backlog, and backorder reports by product category Allow sorting and printing each of the booking, billing, backlog, and backorder reports by part number Allow sorting and printing each of the booking, billing, backlog, and backorder reports by representative/sales person Allow sorting and printing each of the booking, billing, backlog, and backorder reports by region Allow sorting and printing each of the booking, billing, backlog, and backorder reports by company Allow sorting and printing each of the booking, billing, backlog, and backorder reports by distribution center Provide on-line order history file displaying past orders for the customer Provide on-line invoice history file displaying past customer invoices Allow for on-line production status inquiry by customer purchase order number and customer code Allow for customer master file inquiry that displays the billing address for a customer Allow for customer master file inquiry that displays the shipping address (multiple) for a customer Allow for customer master file inquiry that displays the credit standing for a customer Allow for customer master file inquiry that displays the billing and shipping terms for a customer Allow for customer master file inquiry that displays the special instructions for a customer
7.1.20 7.1.21 7.1.22 7.1.23 7.1.24
7.1.25 7.1.26 7.1.27 7.1.28 7.1.29 7.1.30 7.1.31 7.1.32 7.1.33 7.1.34 7.1.35
7.1.36
7.1.37 7.1.38 7.1.39 7.1.40 7.1.41
Support a competitive information system whereby competitive quotes are entered from the field and reported centrally Provide a management summary report showing on-time shipments Calculate split commissions automatically Apply sales tax automatically Create a backorder for under shipped or unshipped lines Provide the ability to allocate inventory to customers based on a customer priority code in the customer master record Quotes and sales orders are viewable by salespersons (direct or agent) that are involved (commission structure) Reporting and Interfacing Requirements (Sales Management) This category contains 49 criteria below it. Available-to-Promise (ATP)
7.1.42
7.2
7.3
7.4
This category contains 10 criteria below it. Pricing and Discounting
7.5 7.6
This category contains 76 criteria below it. Customer Service and Returned Goods Handling This category contains 29 criteria below it. Customer Relationship Management (CRM) and ECommerce Requirements
This category contains 23 criteria below it.
8
Product Technology
8.1 8.1.1 8.1.1.1 8.1.1.1.1 8.1.1.1.2 8.1.1.1.3 8.1.1.1.4 8.1.1.1.5 8.1.1.1.6 8.1.1.1.7 8.1.1.2
Architecture Data Integration Technologies Data Management Options Relational database design Normalized tables SQL APIs for calls or data requests Multi-RDBMS portability Transaction tracking system Replicates database master files, fields, and structures Supports Disaster Recovery Institute procedures Database Gateway Options This category contains 8 criteria below it. Server/Host Relational DBMS Options This category contains 8 criteria below it. Metadata Management This category contains 9 criteria below it. Logical Repository Model This category contains 8 criteria below it. Repository Metadata Tools This category contains 5 criteria below it. Repository User Interface This category contains 8 criteria below it. Business Modeling/Repository Tool This category contains 17 criteria below it. Non-operational Data Warehousing This category contains 6 criteria below it. Messaging Protocols This category contains 15 criteria below it. Device Interfaces This category contains 27 criteria below it.
8.1.1.3 8.1.1.4 8.1.1.5 8.1.1.6 8.1.1.7 8.1.1.8 8.1.1.9 8.1.2 8.1.3
8.1.4 8.1.5 8.1.6 8.1.7 8.1.8 8.2 8.3 8.4 8.5 8.6 8.6.4
Architectural Foundation This category contains 15 criteria below it. Web Enablement This category contains 108 criteria below it. Organizational Structure This category contains 7 criteria below it. Application Security This category contains 7 criteria below it. Multisite Management This category contains 17 criteria below it. User Interface This category contains 8 criteria below it. Platforms This category contains 36 criteria below it. Application Tools This category contains 23 criteria below it. Workflow and Document Management This category contains 6 criteria below it. Reporting This category contains 3 criteria below it. Active or inactive status
heet
FUT NS Description Financial system modules for bookkeeping and ensuring accounts are paid or received on time. General ledger keeps centralized charts of accounts and corporate financial balances. It supports all aspects of the business accounting process. In this module, financial accounting transactions are posted, processed, summarized, and reported. It maintains a complete audit trail of transactions and enables individual business units to view their financial information, while parent companies can roll up all business subsidiaries and view the consolidated information.
Lean manufacturing typically refers to paperless (or less paper) production and accounting. Instead of recording costs for every single order, the idea is to record these for certain determined cycles or schedules.
Multiple calendars may be useful for different accounting scenarios. For example, different financial entities may need separate fiscal calendars--one set of books might require a quarterly calendar while another would require a different term. If a merger results in two financial entities that have different fiscal calendars, the accounting system will need to maintain both calendars and normalize the data (Q2 for Entity A is equal to Q3 for Entity B). This may also be useful for what-if scenarios. A financial reporting entity is a business unit which can legally make financial reports.
The 4-4-5 calendar period uses a four week, four week, five week pattern. Likewise, the 5-4-4 calendar period uses a five week, four week, four week pattern; and analagously for the 4-5-4 pattern.
The calendar can be organized in a limitless form, with up to 999 user periods, per calendar The ability to have any number of fiscal years or calendar periods open concurrently The ability to set a default currency by entity. For example, if a large company has one entity responsible for conducting business in the US and another entity for the UK, the default currency may be dollars for the US and British sterling for the UK.
The ability to decide how to organize data when defining the organization of an enterprise's financial information account payable (A/P) The ability to define a specific period calendar and chart of accounts for each entity ledger By controlling when an account is open and closed, the posting of information in an account period can restricted. Allows for instant processing or batch processing general ledger (G/L) The ability to change the currency used in balance sheet accounts to another currency using a default rate. It is possible to override this default rate for particular accounts. Moreover, it is possible to set different default rates for different subledgers.
A general ledger key typically is an identifier attached to accounts to put the accounts into groups. For example, there may be fifteen accounts in the chart of accounts related to payroll, and all fifteen accounts will be assigned the same key (perhaps "PAYROLL"). Thus the system can purge or set other rules to all chart of accounts with the same key.
The ability to cumulatively incorporate results from the previous accounting period into the current accounting period, but only when the last document generated in the previous period was the financial statement.
The ability to cumulatively incorporate results from the previous accounting period into the current accounting period, but only when the last document generated in the previous period was the financial statement.
General ledgers are designed to present values for creating financial statements. The multiple level for a ledger key means the system will have a more complex and functional key structure--one that supports a hierarchy of keys. The ability to automatically, rather than manually, identify open receivables exceptions by using user-defined conditions (for example, very large amount invoices, exceeding credit line, etc.)
ADP refers to automatic data processing. For future expenses that have not been received. Upon invoice receipt, differences are posted to a particular G/L account.
This is different from a purge because the balance still exists but 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
The ability to process jobs that are in the midst of being edited or updated
The ability to create a report subsection that indicates which pages of the report mention errors and warnings The ability to decide if a particular job should be updated more than once during a given time period The ability to look up entries in the ledger by company, by market, and by stock keeping unit (SKU) The ability to define variables within a tabular array of data so that jobs are performed and postings or reports are created accordingly
This refers to enterprise resource planning (ERP) database tables, not, for example, report tables. The ability check data entry to make sure that only the correct records are updated
The chart of accounts is a list of ledger account names and account numbers, creating consistency in terminology and eliminates redundant accounts. A chart of accounts structure should include fields for account and ledger descriptions, to prevent shadow accounts from being created. Data tree tools allow users to see the structure of the fields and summaries, to help with reporting requirements, foster change, etc.
The accounting department is typically responsible for recording all transactions in the company in the journal (GL). All of the criteria that fall Journal Entry and Reporting relate to various ways to record journal transactions. For example payroll is an AP item. As paychecks are cut the AP items need to be reconciled with the cash outflow. A software feature might be the automatic reconciliation of payroll deductions when paychecks are issued (as opposed to having an accountant have to key the transactions by hand).
A journal voucher (JV) is a document that authorizes payment for services performed, or for goods that are received or exchanged. As a means to record ledger transactions, JVs may have different approvals for different accounts. For example when someone submits an expense report that money is typically associated with an account on the chart of accounts in the G/L. The account may require a JV for posted entries. The JV may include copies of receipts and a sign off from a manager before the entry can be posted.
Accounts payable schedules bill payments to suppliers and distributors, and keeps accurate information about owed money, due dates, and available discounts. It provides functionality and integration to other areas such as customer service, purchasing, inventory, and manufacturing control. The software should support the following functionality: AP company policies and procedures; suppliers/voucher master data; payment controls; invoice processing and aging analysis; payment processing; journal voucher processing; AP ledger posting; check processing; AP transactions and controls; and AP reporting.
Fixed assets manages depreciation and other costs associated with tangible assets such as buildings, property and equipment. The software should support the following functionality: fixed assets records; asset transactions; asset depreciation; depreciation books; revaluation and interest calculation; and tax reporting.
Cost accounting analyzes corporate costs related to overhead, products, and manufacturing orders. It provides a variety of costing approaches such as standard, FIFO, LIFO, average, target, and activity-based costing (ABC). The software should support the following functionality: cost data; cost allocation definitions; cost allocation process; cost management; cost and sales price calculation; activity based costing (ABC); and activity based cost tracing and tracking.
Cash management involves the capability of the system to record cash charges or deposits, recording of cash payments and receipts, cash projection reporting, calculation of expected cash uses/sources, current cash availability, etc. It monitors and analyzes cash holdings, financial deals, and investment risks.
Budgeting involves budgetary controls, budget accounting, budget development, and budget allocation. The software should provide sufficient tools to enable detailed budget development and analysis. Additional functionality should be available to integrate with project management software applications either natively or with external interfaces.
Accounts receivable tracks payments due to a company from its customers. It contains tools to control and expedite the receipt of money from the entry of a sales order to posting payments received. The software should support the following functionality: AR company policies and procedures; customers/voucher master data; bill processing and aging analysis; credit management; cash/payment application, receipt processing; journal voucher processing; AR ledger posting; multicurrency accounting and conversions; AR transactions and controls; and AR reporting.
Financial reporting enables robust analysis of company performance through delivered reports. These reports will allow individual business units to view their financial information, while parent companies can roll up all business subsidiaries and view the consolidated information. Additionally, solutions should provide user generated reporting tools that are easy to use and provide sufficient depth of and access to the financial data to permit comprehensive analysis.
Human resources encompasses all the applications necessary for handling personnel-related tasks for corporate managers and individual employees. Modules include personnel management, benefit management, payroll management, employee self service, data warehousing, and health and safety.
Personnel management automates personnel processes including recruitment, personnel profile, organizational structure, career development & training, reward management, job position and wage profiles, and business travel and vacation allotments. The software should support the following functionality: recruitment management; personnel information and tracking; organizational structuring; job position and salary profile; career development, training and performance management; compensation management; budgeting and cost control; government compliance reporting; expenses management; union information; discipline actions and grievances tracking; and employment history/personnel reporting.
Requisition parameters are used for information on recruiting issues and department personnel needs
A typical feature in employment management systems, resume routing is the ability to divert resumes to the appropriate department or hiring manager.
New hires are personnel that have been recently acquired by the company.
Applicant flow statistics are derived from applicant data, and include information on education, job history, etc. These numbers can be used for effective marketing to further strengthen recruitment, create non-discriminatory policy, create applicant flow reports etc.
Competencies are comprised of skill sets, which are mapped to an organization's needs and strategic goals. Human resources (HR) uses competencies and competency models to determine what skills are linked to a position, what skills need to be enhanced, and what skills are not necessary or no longer valid for a particular job or area. They can also be used to create behavioral tests or other candidate screening tools.
Competencies are comprised of skill sets, which are mapped to an organization's needs and strategic goals. Human resources (HR) uses competencies and competency models to determine what skills are linked to a position, what skills need to be enhanced, and what skills are not necessary or no longer valid for a particular job or area. They can also be used to create behavioral tests or other candidate screening tools. Competencies are comprised of skill sets, which are mapped to an organization's needs and strategic goals. Human resources (HR) uses competencies and competency models to determine what skills are linked to a position, what skills need to be enhanced, and what skills are not necessary or no longer valid for a particular job or area. They can also be used to create behavioral tests or other candidate screening tools. Competency requirements are the necessary skills that a candidate must possess in order to satisfactorily operate in a position.
Competencies are comprised of skill sets, which are mapped to an organization's needs and strategic goals. Human resources (HR) uses competencies and competency models to determine what skills are linked to a position, what skills need to be enhanced, and what skills are not necessary or no longer valid for a particular job or area. They can also be used to create behavioral tests or other candidate screening tools.
Competency management is used to map the skill sets required in a position to ensure the organization or departments needs and strategic goals are met. It employs competency models to determine what skills are linked to a position, what skills need to be enhanced, and what skills are not necessary or no longer valid for a particular job or area. They can also be used to create behavioral tests or other candidate screening tools.
Benefits administers a diverse range of benefit plans such as health and medical, life and supplemental life insurance, accidental death and dismemberment (AD&D), disability plans, flexible benefits, 401(k) plans, profit sharing plans, stock plans, retirement plans, and leave plans including vacation and sick leave accruals. The software should support the following functionality: base benefits; employee benefit plan profile; benefits administration; and pension administration.
Payroll handles accounting and preparation of checks related to employee salaries, wages, and bonuses. The software should support the following functionality: employee payroll profile; earnings and deductions; eligibility controls; user balances; tax deductions and calculation; payroll calculation; payroll and payment processing; check processing and printing; labor distribution and accounting; payroll and regulatory reporting; IRS documentation; security and audit; and automated timesheets.
Employee self-service lets workers access their personal information and benefit allocations on-line to manage life events and benefit selections without having to send forms to human resources. The software should also support benefit enrollment programs and new hire initiation. Data warehousing simply defined, is a place for data, whereas data warehousing describes the process of defining, populating, and using a data warehouse. Creating, populating, and querying a data warehouse typically carries an extremely high price tag, but the return on investment can be substantial.
Health and safety provides the tools to administer compliance with the health and safety regulations, accident and injury reporting, and tracking of lost time by employee.
A mill is a factory where value is added to raw materials by processing it into a form suitable either for further manufacturing or for immediate end-use. Outside the food industry, where traditional mills turn grain into flour or extract sucrose from sugar beet and cane, other processes comply with the foregoing definition. Milling applies to a wide range of industrial activities. These include the spinning and weaving mills of the textiles and carpets sectors to the rolling plants of steel, aluminum, and other metals semi-fabricators, to the continuous outputs of paper and board mills. There are several broad categories of non-food mills: 1. Metals--typically rolling cast steel or aluminum into sheets and coils or extruding profiles that are sold either to manufacturers or to distributors 2. Plastics--similar to metals, these may also be thermally extruded and formed 3. Paper--products usually delivered direct to printers and packaging manufacturers or to wholesalers and distributors 4. Packaging--heavier paper-based products such as foil and plastics that mostly go direct to manufacturers across all sectors; deliveries must align with users' production schedules 5. Textiles--woven fabrics produced mostly for apparel manufacturers and the décor trade, but also for the retail sector 6. Carpets--supplied to the retail trade cut-to-order for commercial and domestic applications; some specialist mills make-to-order (MTO) for corporate applications such as store chains, hotels, cruise i.e., metals, plastic, paper, textile, etc. Typical inventory materials are coils or a bundle of sheets, pipes, tubes, ingots, slabs, billets, bars, wire reels, etc.
The system creates the inventory part, whereby each inventory part includes information pertinent to material type and dimensional characteristics. The software has to allow the user enterprise to efficiently manage and control inventory, effectively plan production, and perform the necessary quality control and traceability processes all the way down to each steel heat and the particular national standard grades (e.g., for mild or carbon steel, for stainless steel, aluminum alloys, etc.).
PO = purchase order One has to be able to enter a master tag number or heat number for a coil or a bundle of sheets, pipes, or tubes, and be able to see every single piece produced from the master tag along with what processes were performed, at what cost, while also providing details as to who purchased the piece, when, and for how much.
When the user company offers products in different dimensions (e.g., length, width, thickness, diameter, etc.), the software's formula engine should be able to ensure the validity of the configured items.
Since because each customer usually wants to be invoiced in their preferred unit of measure (UOM), such as pieces, pounds, hundred weight, lot, kilo, and more
The software solution must handle these inventory and document management requirements seamlessly. MTR = material/mill test reports The feature must allow for effective item searches down to the cut piece level, and efficiently display attributes that users will define, such as gauge, width, length, heat number, schedule, thickness, internal diameter (ID), and outer diameter (OD). There should also be flexible "information browser" functions with the ability to easily select, filter, and sequence information to meet the ad hoc needs of different people and situations.
In case users do not stock the item the customer is requesting, or have never purchased the item before, resulting buyouts must be handled quickly without disrupting the normal order flow. These buyouts might have to be drop-shipped directly from the supplier to the end customer or sub-contractor if outside value added services are being performed.
Attributes can be quantity-based with minimum, maximum, and actual values for dimensional needs like width, length, and gauge, and they can also be predefined sets, such as hexagonal, square, rectangle, or irregular, used to define shape of the product.
The starting material, for example, would be an aluminum or steel coil ranging from 42 to 60 inches in width, and weighing between 2,000 and 10,000 pounds. When shipped to a customer as finished goods, a coil has to be slit, cleaned, etched, anodized, dyed, and sealed. While standard products are manufactured and placed into inventory to meet sales forecast demand as well as long term contracts with customers, often the more numerous non-standard sub-assemblies are only fabricated upon receipt of actual customer orders—they are typically not placed into inventory, but are rather shipped directly to the customer upon completion of the fabrication process. Each product, whether standard or not, has to be sized, packaged, and coated to customer specifications at the ship-to/lineitem level. These specifications can change from one order to the next, and are communicated to the production floor so that appropriate action and documentation takes place, as, in many cases, the completion of specific activities must be certified for the customer.
This criterion refers to flexible system configuration capabilities with overrides at multiple levels (i.e. customer, order, line, etc.) for things like shipment +/- tolerances, commodity pricing, surcharges, etc. This is in fact the ability to add virtually unlimited user-defined data fields and use them for selection, sequencing, calculations, etc.
Bills of materials (BOM) are often not required, since the starting item (e.g., sheet metal or a coil) and the finished item (an assortment of cut and converted items) are the same item in the customer’s mind, and the system has to follow that logic.
Generic enterprise resource planning (ERP) systems customarily require each order (or even worse, each order line item) to be treated as a new product or item number, creating redundant work, an item nomenclature glut, and delays, to the dismay of customers and the user company’s employees (e.g., its sales force or shipping personnel that has to plow through a number of illogical item numbers, with the likelihood that several redundant item numbers refer to the same actual physical product). A so-called material selection optimizer feature should come in handy to pre-filter inventory whose dimensions, or chemical or physical properties do not match the order specifications. When processing a quotation or a sales order for cut sheet, rod, or tube products, the resulting yields are automatically calculated and displayed from existing inventory and inventory master items based upon customer-specific dimensional requirements. A cutting workflow is created if any cutting operations are required, with blade widths taken into account in yield calculations.
The software has to be able to optimize the useful remnant inventory, in terms of multiple units of measure (UOM); heat, lot, and serial tracking; and material/mill test reports (MTR). This piece can be put back in stock, under the same item number as the original sheet (but with different "size" attributes). The software has to be able to optimize the useful remnant inventory, in terms of multiple units of measure (UOM); heat, lot, and serial tracking; and material/mill test reports (MTR). With this feature, waste can be significantly reduced, since the system sends remnants back into stock with the automatic creation of part numbers and values, they become part of the inventory from which new orders are calculated. This feature encompasses the issuing of raw material to the job, receipting the cut item, and placing remnants back into stock, automatically creating new inventory codes and updating the cost of goods sold (COGS) on that line item. Furthermore, remnants returned to stock can be put back at zero cost or have a value placed according to need.
Traditional manufacturing resource planning (MRP) systems only look at quantity on hand, demand quantity, and on order quantity, and are able to advise users whether there is enough tonnage to meet the customer demand. However, they cannot discern whether the available total tonnage on stock meets the specific customer dimensional specifications.
RF = radio frequency
For example, a customer service representative would be immediately notified when the schedule date is changed on a customer’s order, or Quality would be immediately alerted when a heat or test result is out of spec.
Plastic sheets cut-to-size would be handled in the previous section, whereas this category covers criteria for mass producing plastic parts, formed to any shape, in custom-made tools.
While there are many similarities with sheets, wires and cables have special requirements because of both shape and different industry practices. In the case that some dangerous goods are used for the composition of materials, these goods need to be reported and controlled to satisfy regulatory requirements. Hazard data should be on documentation such as goods receipt notes, quality assurance (QA) test sheets, production orders, selection lists, consignment/dispatch. Safety information should contain storage conditions, flash points, disposal details, COSHH codes, CAS numbers, EINECS codes, MSDS numbers, packing group, and transport class.
Product costing analyzes product costs related to overhead, labor, material, and manufacturing costs. It provides a variety of costing approaches such as standard, actual, and average. Shop floor control provides control and tracking of the status of production orders in the plant. It involves production orders dispatching, capacity planning, resource allocation, production tracking and reporting, and waste/reject tracking. Production planning performs capacity planning and creates a daily/weekly/monthly production schedule for a company’s manufacturing plants. It involves forecasting, production scheduling, and material planning. Solutions for inventory management are used for the record-keeping of goods that are warehoused, and managing the movement of these goods to, from, and through warehouses.
Any individual item descriptions are pushed to be viewed on the screen. The term "harmonized" refers to standardized codes set by a higher authority (e.g., government or national/international organizations). Thus, the system should be capable of using such standard codes, particularly for interactions with third parties.
Up selling refers to selling upgrades, add-ons, or enhancements to a specific product or service.
The ability to encode data on bar codes on individual parts as they are received, so that their subsequent warehousing and other activities may be monitored in a real time manner using the bar code information.
The ability to change some materials' designation from being "manufactured" in-house to being "purchased" outside, while keeping the engineering change number (ECN) in the loop.
Purchasing management encompasses a group of applications that controls purchasing of raw materials needed to build products and that manages inventory stocks. It also involves creating purchase orders/contracts, supplier tracking, goods receipt and payment, and regulatory compliance analysis and reporting.
PO = purchase order
Quality management encompasses applications for operational techniques and activities used to fulfill requirements for quality control, inspection plan creation, and management, defective item control and processing and inspection procedure collection planning.
The system can group quality requirements, such as different tolerances, by a collection plan. Collection plans may be the way one collects samples from the batch--for statistical process control (for example, random, every two hours, at the end of the shift, etc.)
Sales Management encompasses a group of applications that automates the data entry process of customer orders and keeps track of the status of orders. It involves order entry, order tracing and status reporting, pricing, invoicing, etc. It also provides a basic functionality for lead tracking, customer information, quote processing, pricing & rebates, etc.
A backorder is an unfilled customer order or commitment. A backorder is an immediate (or past due) demand against an item whose inventory is insufficient to satisfy the demand.
Automated available-to-promise (ATP) is achieved by giving order takers access to inventory and capacity information, and in some cases even vendor information, so that they are able to commit to reliable delivery dates while the customer is still on the phone.
Pricing and discounting modules help automate the data entry process of customer orders and track the status of orders. It involves order entry, order tracing and status reporting, pricing, and invoicing. It also provides basic functionality for lead tracking, customer information, quote processing, and pricing and rebates.
Ranges from simple, off-the-shelf contact management solutions to high-end interactive selling suites that combine sales, marketing, and executive information tools. These include product configuration, quote and proposal management, and marketing encyclopedias. Some systems extend functions to include complex pricing, promotions, commission plans, team selling, and campaign management. Enterprise-level solutions installed at large companies with hundreds or even thousands of users have capabilities for call centers/help desks, field service, forecasting, and analysis.
This category defines the technical architecture of the product, and the technological environment in which the product can successfully run. Criteria include product and application architecture, software usability and administration, platform and database support, application standards support, communications and protocol support and integration capabilities. Relative to the other evaluation criteria, best practice selections place a lower relative importance, on the product technology category. However, this apparently lower importance is deceptive, because the product technology category usually houses the majority of the selecting organization's mandatory criteria, which usually include server, client, protocol, and database support, application scalability and other architectural capabilities. The definition of mandatory criteria within this set often allows the client to quickly narrow the long list of potential vendors to a short list of applicable solutions that pass muster relative to the most basic mandatory selection criteria. During the process of product selection a great deal of attention is given to the functional capabilities of the software being evaluated. While this aspect is obviously important, ignoring the technical mechanisms by which the software actually operates can be fatal to a project.
Relational database management systems (RDBMS) are a type of database management systems (DBMS) that store data in the form of related tables. The ability to make copies of master files, fields, and structures
Gateways are interfaces that convert protocols in order to connect different networks.
The ability to categorize items based on whether their activity status is active or inactive
FactorID MasterMo delID 441130 195121 441131 195122
441132 441133
195123 195124
441134 441135 441136
195125 195126 195127
441137
195128
441138 441139 441140
195129 195130 195131
441141 441142 441143 441144
195132 195133 195134 195135
441145 441146 441147 441148 441149 441150 441151
195136 195137 195138 195139 195140 195141 195142
441152
195143
441153
195144
441154
195145
441155
195146
441156
195147
441157
195148
441158
195149
441159
195150
441160
195151
441161
195152
441162
195153
441163
195154
441164 441165
195155 195156
441166
195157
441167 441168 441169 441170 441171 441172 441173
195158 195159 195160 195161 195162 195163 195164
441174 441175 441176
195165 195166 195167
441177
195168
441226 441241 441257
195217 195232 195248
441302
195293
441344 441352 441377 441387 441453 441457
195335 195343 195368 195378 195444 195448
441703
195694
441798
195789
441852
195843
441869
195860
441940
195931
442052
196043
444610
196138
444611
196139
444612 444613 444614 444615 444616 444617 444618 444619 444620 444621 444622
196140 196141 196142 196143 196144 196145 196146 196147 196148 196149 196150
444623
196151
444624 444625 444626 444627 444628 444629
196152 196153 196154 196155 196156 385277
444630
385278
444631
385279
444632
385280
444633 444648 444665 444687 444706 444714 444719 444727 444736 444739
196157 196167 196182 196204 196223 196231 196236 196244 196253 385679
444745
196256
444773
196284
444850
196361
444873
196384
444887
196398
444899 445065
327684 385685
444609
444531
444532 444535
444455 444456
444536 444537
444457 444458
444538 444539
444459 444460
444540
444461
444541
444462
444542
444463
444543 447081 444544 444545
444464 447079 444465 444466
444546
444467
444547
444468
444548
444469
444549
444470
444550
444471
444551
444472
444552
444473
447082
447080
444553
444474
444554 444555
444475 444476
444556
444477
444557 444558 444559
444478 444479 444480
444560 444561
444481 444482
444562
444483
444563
444484
444564 444565 444566 444567
444485 444486 444487 444488
444568 444569 444570
444489 444490 444491
444571
444492
447083 447084 447101
447073 447056 447074
444533
444493
444534
444519
442480
197611
442497 442503 442560
197628 197634 196411
442668
196524
443060
197045
443352 443353 443354
197691 197692 197693
443355
197694
443356 443357 443358
197695 197696 197697
443359 443360
197698 197699
443361 443362 443363 443364 443365 443366 443367 443368
197700 197701 197702 197703 197704 197705 197706 197707
443369 443370 443371 443372 443373 443374
197708 197709 197710 197711 197712 197713
443375 443376
197714 197715
443377
197716
443378
197717
443379
197718
443380 443381 443382 443383 443412 443425
197719 197720 197721 197722 197751 197764
443435 443456 443509 443536 443545
197774 197795 197848 197875 197884
443546 443547 443548 443549 443550 443551
197885 197886 197887 197888 197889 197890
443552 443553 443554 443555 443556 443557 443558 441941 443559
197891 197892 197893 197894 197895 197896 197897 195932 197898
443573 443587 443650 443664 443681 443707 443732 443752 443796
197912 197926 197990 198004 198021 198047 198072 198092 198138
443815
198157
443816 443817 443818 443819 443820 443821 443822 443823 443824 443825 443826 443827 443828 443829 443830
198158 198159 198160 198161 198162 198163 198164 198165 198166 198167 198168 198169 198170 198171 198172
443831 443832 443833 443834 443835 443836 443837 443838 443839 443840 443841 443842 443843
198173 198174 198175 198176 198177 198178 198179 198180 198181 198182 198183 198184 198185
443844 443845
198186 198187
443846 443847 443848 443849 443850 443851 443852
198188 198189 198190 198191 198192 198193 198194
443853 443854 443855 443856 443857 443858
198195 198196 198197 198198 198199 198200
443859 443860
198201 198202
443861 443862 443863 443864 443865
198203 198204 198205 198206 198207
443866 443867 443868 443869 443870
198208 198209 198210 198211 198212
443871 443872 443873 443874 443875 443876 443877 443878 443879 443880 443881
198213 198214 198215 198216 198217 198218 198219 198220 198221 198222 198223
443882
198224
443883 443884 443885 443886 443887
198225 198226 198227 198228 198229
443888
198230
443889
198231
443939
198281
443950
198292
444027 444057
198370 198400
444081
198424
444082 444083 444084 444085 444086 444087 444088 444089 444090 444091 444092
198425 198426 198427 198428 198429 198430 198431 198432 198433 198434 198435
444101 444110 444120 444129 444135 444144 444162 444169 444185
198444 198453 198463 198472 198478 198487 198505 198512 198528
444213 444229 444338 444346 444354 444372 444381 444418 444442 444449 444453
198556 198572 198681 198689 198697 198715 198724 198761 198785 198792 198796