1C:Enterprise 8.3. Developer Guide. Contents 1C:Enterprise 8.3. Developer Guide. Contents INTRODUCTION STRUCTURE OF THE GUIDE WHAT YOU NEED TO KNOW THE BOOKS INCLUDED IN THE DOCUMENTATION ABOUT 1C:ENTERPRISE 8 PAGE AGREED NOTATION CHAPTER 1. CONCEPT OF THE SYSTEM 1.1. CONFIGURABILITY 1.2. FUNCTIONING OF THE SYSTEM 1.3. BASIC CONCEPTS OF THE SYSTEM 1.3.1. Configuration Concept 1.3.2. Configuration Object 1.3.2.1. Properties of Configuration Objects 1.3.2.2. Basic Types of Configuration Objects 1.3.2.3. Subordinate Object Groups 1.3.2.4. Typed and Type-Specifying Objects 1.3.3. Command Interface 1.3.4. Form 1.3.5. Module 1.3.6. Template 1.4. OPERATION MODES 1.4.1. File Mode 1.4.2. Client/Server Mode 1.5. DEVELOPMENT TOOLS CHAPTER 2. WORK WITH CONFIGURATION 2.1. OPENING CONFIGURATION 2.2. SAVING CONFIGURATION 2.3. CLOSING CONFIGURATION 2.4. SAVING CONFIGURATION TO FILE 2.5. LOADING CONFIGURATION FROM FILE 2.6. CONFIGURATION OBJECT TREE 2.7. METADATA TREE SORT SETTINGS 2.8.1. Create Configuration Objects 2.8.2. Deletion of Configuration Objects 2.8.3. References to Configuration Objects 2.9. PROPERTIES PALETTE 2.10. MORE WINDOW 2.11. OBJECT EDITING WINDOW 2.12. CREATE HELP CONTENT SECTION 2.13.1. Database Configuration Object Tree 2.13.2. Update of Database Configuration 2.13.3.1. General information 2.13.3.2. Background database configuration update dialog 2.13.4. Saving Database Configuration to File 2.13.5. Comparison of Configuration and Database Configuration 2.13.6. Cancellation of Configuration Changes 2.14. 1C:ENTERPRISE LAUNCH 2.15. DOWNLOAD/UPLOAD OF CONFIGURATION FILES 2.16. CONFIGURATION DUMP AND RESTORATION 2.18. CONFIGURATION REPORT 2.19. GLOBAL SEARCH AND REPLACEMENT 2.20. CUSTOMIZATION OF DESIGNER WORK SPACE 2.20.1. Panel Customization 2.20.2. Configuration Window 2.20.3. Use of Window Display Modes CHAPTER 3. APPLICATION INTERFACE 3.1. OPEN FORMS IN SEPARATE WINDOWS 3.1.1. Main Application Window 3.1.1.1. Sections Panel 3.1.1.2. Navigation Panel 3.1.1.3. Actions Panel 3.1.1.4. Information Panel 3.1.1.5. System Commands Area 3.1.2. Auxiliary Window 3.1.2.1. Form Navigation Panel 3.1.2.2. Form Command Bar 3.1.2.3. System Commands Area 3.2. OPEN FORMS IN TABS 3.2.1. The Main Application Window 3.2.1.1. The Sections Panel 3.2.1.2. The Navigation Panel 3.2.1.3. The Actions Panel 3.2.1.4. The Information Panel 3.2.1.5. The System Commands Area 3.2.2. The Auxiliary Window 3.3. TAXI INTERFACE 3.3.1. Main application window 3.3.1.1. The start page 3.3.1.2. The Sections panel 3.3.1.3. The current section command panel 3.3.1.4. The opened items panel 3.3.1.5. History 3.3.1.6. Favorites 3.3.1.7. The toolbar 3.3.1.8. Full text search form 3.3.1.9. The system commands area 3.3.1.10. Panel setup 3.3.2. The auxiliary window 3.3.2.1. The form navigation panel 3.3.2.2. The form command bar CHAPTER 4. 1C:ENTERPRISE SCRIPT 4.1. BRIEF DESCRIPTION AND PURPOSE OF 1C:ENTERPRISE SCRIPT 4.2. SOURCE TEXT FORMAT IN PROGRAM MODULES 4.2.2. Program Module Execution Context 4.2.2.1. Global Context 4.2.2.2. Local Context 4.2.3. Types of Program Modules 4.2.3.1. Managed Application Module 4.2.3.2. External Connection Module 4.2.3.3. Session Module 4.2.3.4. Common Modules 4.2.3.5. Application Object Modules 4.2.3.6. Object Manager Modules 4.2.3.7. Form Modules 4.2.3.8. Command Modules 4.2.4. Program Module Format 4.2.4.1. Comments 4.2.4.2. Operator Format 4.2.4.3. Names of Variables, Procedures and Functions 4.2.4.4. Program Module Script 4.2.4.5. Case Sensitivity of Program Module Text 4.2.4.6. Reserved Words 4.2.5. Special Characters Used in Source Text 4.3. PRIMITIVE DATA TYPES 4.4. ASSIGNMENT OPERATOR 4.5. SCRIPT EXPRESSIONS 4.5.1. Arithmetic Operations 4.5.2. Concatenation Operation 4.5.3. Logical Operations 4.6. OPERATORS AND SYNTACTIC CONSTRUCTS 4.7.1. Calls to Object Properties 4.7.2. Enhancement of Object and Form Context 4.7.3. Passing Procedure and Function Parameters 4.7.3.1. Call without Transferring Control from the Client to the Server 4.7.3.2. Call with Transferring Control from the Client to the Server 4.7.3.3. General Considerations for Specifying Parameters 4.7.4. Work with Collections of Values 4.7.5. Use of Numbers and Indices 4.7.6. Work with System Enumerations 4.7.7.1. Object Manager 4.7.7.2. PredefinedValue() Function 4.8. SYSTEM STARTUP VERSIONS 4.8.1. Execution of Procedures and Functions 4.8.1.1. Differences Between Preprocessor Instructions and Compiler Directives 4.8.1.2. Preprocessor Instructions 4.8.1.3. Compiler Directives 4.8.2. Use of Objects, Their Properties and Methods CHAPTER 5. CONFIGURATION OBJECTS 5.1. CONFIGURATION PROPERTIES 5.1.1. General Property Category 5.1.2. Presentation Property Category 5.1.3. Development Property Category 5.1.4. Help Content Property Category 5.1.5. Compatibility Property Category 5.2. MANAGED APPLICATION MODULE 5.3. EXTERNAL CONNECTION MODULE 5.4. SESSION MODULE 5.5. COMMON CONFIGURATION BRANCH 5.5.1. Subsystems 5.5.2. Common Modules 5.5.2.1. Various Contexts and Common Modules 5.5.2.2. Reuse of Return Values 5.5.3. Session Parameters 5.5.4.1. Overview 5.5.4.2. Privileged Mode of Operation 5.5.4.3. Safe Mode of Operation 5.5.4.4. Data Deletion Modes 5.5.4.5. Rules of Role Sets 5.5.4.6. Access Rights Editor 5.5.4.7. View and Edit All Roles 5.5.4.8. Data Access Restriction 5.5.6. Exchange Plans 5.5.7. Filter 5.5.8. Event Subscription 5.5.9.1. Main Features of Jobs 5.5.9.2. Background Jobs 5.5.9.3. Scheduled Jobs 5.5.9.4. Execution of Scheduled Jobs 5.5.10.1. Purpose 5.5.10.3. General Workflow 5.5.10.4. Interaction with Other Objects 5.5.10.5. Creation 5.5.10.6. Use 5.5.10.7. Use of Functional Options in 1C:Enterprise Script 5.5.11. Defined types 5.5.12. Settings Storages 5.5.12.1. General Principles of Settings Storage Operation 5.5.12.2. Creation of Metadata Object 5.5.12.3. Standard Settings Storage 5.5.12.4. How to Save Form Settings 5.5.12.5. How to Save Report Settings 5.5.12.6. Storing dynamic list settings 5.5.12.7. Settings Storage Development Procedure 5.5.12.8. Working with Settings Storage from the Script 5.5.13. Common Forms 5.5.14. Common Commands 5.5.15. Command Groups 5.5.16. Common Templates 5.5.17. Common Pictures 5.5.18. XDTO Packages 5.5.18.1. Import of XML Schemas Into XDTO Global Factory 5.5.18.2. Export of Configuration XML Data Schemas 5.5.18.3. Export of XDTO Package XML Schema 5.5.18.4. Check of XDTO Packages 5.5.18.5. XDTO Package Editing Window 5.5.19. Web-services 5.5.19.1. Addition of Web Services 5.5.19.2. Web Service Hierarchical Structure 5.5.19.3. Web Service Operations 5.5.19.4. Operation Parameters 5.5.19.5. Selection of System-Defined Types 5.5.19.6. Web Service Publication 5.5.20. WS-references 5.5.20.1. Addition of WS References 5.5.20.2. WS Reference Hierarchical Structure 5.5.21. Style Elements 5.5.22. Languages 5.6.1. General Properties 5.6.2. Metadata Object Presentation 5.6.3. Custom Presentation of Data 5.6.4. Standard Attributes 5.6.5.1. Overview 5.6.5.2. Working in a distributed infobase 5.6.5.3. Working in data separation mode 5.6.6. Input by String 5.6.6.1. Input Field Behavior 5.6.6.2. Programmatic Generation of Selection Lists 5.6.7. Forms 5.6.8. Commands 5.6.9. Attribute Fill-in Mechanism for New Objects 5.6.10. Attribute Fill Check 5.6.10.1. Default Settings 5.6.10.2. Procedure 5.6.10.3. Mark Incomplete Display Rules 5.6.11. Indexing Object Attributes 5.6.12. Rights 5.6.13. Quick Choice 5.6.14. Choice Parameter Links 5.6.15. Choice Parameters 5.6.16. Other 5.7. CONSTANTS 5.7.1. Properties of a Constant 5.8. CATALOGS 5.8.1. Catalog Properties 5.8.2. Properties of Catalog Attributes 5.8.3. Predefined Catalog Items 5.9. DOCUMENTS 5.9.1. Document Properties 5.9.2. Document Posting Mechanism 5.9.2.1. Real-Time and Regular Posting 5.9.2.2. Form Extension and Posting 5.9.2.3. Point in Time 5.9.2.4. Real-Time Timestamp 5.9.2.5. Time Zones 5.9.2.6. Retrieval of Real-Time Timestamp 5.9.3. Numerators 5.9.3.1. Management of Numerator Lists 5.9.3.2. Numerator Properties 5.9.4. Document Sequences 5.9.4.1. Management of Sequence Lists 5.9.4.2. Document Sequence Properties 5.9.4.3. Work with Document Sequences 5.9.5. Entering Documents Based on Existing Objects 5.10. DOCUMENT JOURNALS 5.10.1. Journal Creation 5.10.2. Journal Editing 5.10.3. Document Journal Columns 5.11. ENUMERATIONS 5.12. REPORTS AND DATA PROCESSORS 5.12.1. External Reports and Data Processors 5.12.1.1. Creation of an External Data Processor (Report) 5.12.1.2. Use of External Data Processors (Reports) 5.12.1.3. Editing an External Data Processor (Report) 5.12.1.4. Help Content 5.12.1.5. External Data Processors (Reports) and Configuration Objects 5.12.1.6. Comparison and Merge of External Data Processors (Reports) 5.13. CHARTS OF CHARACTERISTIC TYPES 5.14. REGISTERS 5.14.1. Information Registers 5.14.1.1. Data Register Overview 5.14.1.2. Information Register Records 5.14.1.3. Information Register Editing 5.14.1.4. Development of Information Register Structure 5.14.2. Accumulation Registers 5.14.2.1. Accumulation Register Overview 5.14.2.2. Records of Accumulation Registers 5.14.2.3. Totals of Accumulation Registers 5.14.2.4. Balance Registers and Turnover Registers 5.14.2.5. Main Properties of Accumulation Registers 5.14.2.6. Aggregates of Accumulation Turnover Registers 5.14.2.7. Development of Accumulation Register Structure CHAPTER 6. COMMAND INTERFACE 6.1.1. Sections and Subsections of Main Application Window 6.1.2. Types of Commands 6.1.2.1. Standard Commands 6.1.2.2. Independent and Parameterized Global Commands 6.1.2.3. Navigation and Action Commands 6.1.2.4. Commands Created in Configuration 6.1.3. Command Groups 6.2. CREATION OF GLOBAL COMMAND INTERFACE 6.2.1. Subsystems 6.2.2. Commands 6.2.3. Command Parameterization 6.2.4. Creation of Default Command Interface 6.2.5. Command Interface Property 6.2.6. Editing Sets of Commands 6.2.7. Role-Based Setup of Default Command Visibility 6.3.1. Links 6.3.2. User Notifications 6.3.3. Display Status of Lengthy Processes 6.3.4. Messages 6.3.5. How Keyboard Shortcuts Work 6.4. COMMAND INTERFACE DEVELOPMENT PROCEDURE CHAPTER 7. FORMS 7.1. FORM ATTRIBUTES 7.1.1. Form Data Types 7.1.2. Conversions Between Application Object Data and Form Data 7.1.3. Dynamic List 7.1.4. Attribute Properties 7.1.5. Form Conditional Appearance 7.1.6. Formatted Documents 7.2. FORM PARAMETERS 7.2.1. Standard Form Parameters 7.2.2. Form Parameters Handling: Example 7.3. FORM COMMANDS 7.4. FORM MODULE 7.5. FORM ELEMENTS 7.5.1. Common Properties of Form Elements 7.5.1.1. General Property Category 7.5.1.2. Use Property Category 7.5.1.4. Element Pictures 7.5.2. Form 7.5.3. Field 7.5.4. Decoration 7.5.5. Table 7.5.6. Button 7.5.7. Group 7.5.8. Special Command Bars 7.5.9. Form Element Behavior 7.5.10. Rules of Form Elements Placement 7.5.10.1. Groups and Form Element Consolidation 7.5.10.2. Form Element Sizes 7.5.10.3. Child Item Width 7.5.11. Form Element Boundaries Alignment 7.5.11.1. Data Area, Left Side Alignment 7.5.11.2. Form Element Right Boundaries Alignment 7.5.11.3. Form Element Lower Boundaries Alignment 7.5.12. Drag-and-Drop Mechanism 7.6. FORM COMMAND INTERFACE 7.7.1. Overview 7.7.2. Using blocking windows 7.7.3. Method mapping 7.8.1. How to Open a Form 7.8.2. Redefining an Opened Form 7.8.3. Modification of Form Elements Properties 7.8.4. Form Modification 7.8.4.1. Change of Attribute Set 7.8.4.2. Change of Command Set 7.8.4.3. Work with Form Elements 7.8.5. Working with Dynamic Lists 7.8.5.1. The Dynamic List Query Parameter 7.8.5.2. Filter 7.8.5.3. Group 7.8.5.4. Order (sorting) 7.8.5.5. Conditional Appearance CHAPTER 8. WORK WITH QUERIES 8.1. QUERY DATA SOURCES (TABLES) 8.2. QUERY LANGUAGE 8.2.1. Syntax Diagram for Query Language Constructs 8.2.2. Comments in Query Language 8.2.3. Use of Predefined Configuration Data 8.2.4. Query language keywords 8.2.5. Main Sections of Query Text 8.2.6. Query Description 8.2.6.1. Using DISTINCT Keyword 8.2.6.2. Using TOP Keyword 8.2.7. Selection Fields Description 8.2.7.1. Field Aliases in the Selection List 8.2.7.2. Nested Tables in the Selection Fields List 8.2.7.3. Empty Nested Tables in the Selection List 8.2.8. Query Sources Description 8.2.8.1. Join Specifications 8.2.8.2. Data Source Aliases 8.2.8.3. Nested Tables in the Source List 8.2.8.4. Nested Queries in the Source List 8.2.9. Query Result Filtration 8.2.10. Query Result Groups 8.2.11. Conditions for Aggregate Function Values 8.2.12. Query Union 8.2.13. Query Result Ordering 8.2.13.1. Ordering by Hierarchy 8.2.13.2. Ordering within Nested Tables 8.2.14. Autoorder Results 8.2.15. Calculation of Query Totals 8.2.15.2. Totals by Hierarchy 8.2.15.3. Date Addition 8.2.15.4. Calculation of Overalls 8.2.15.5. Using Totals and Groups Together 8.2.15.6. Totals Aliases 8.2.16. Expressions in the Query Language 8.2.16.1. Dereferencing Fields 8.2.16.2. Aggregate Functions of Query Language 8.2.16.3. Built-in Functions of Query Language 8.2.16.4. Case Operations in Query Language 8.2.16.5. Type Cast in Query Language 8.2.16.6. Constants and Parameters in Query Language 8.2.17. Conditions in Query Language 8.2.17.1. Logical Expressions in Query Language 8.2.17.2. Value Comparison Rules 8.2.17.3. Operator for Value Matching Check 8.2.17.4. Value-Within-Range Check Operator 8.2.17.5. NULL Check Operator 8.2.17.6. Reference Value Check Operator 8.2.17.7. String-Like-Template Check Operator 8.3. EXECUTION AND USE OF QUERIES IN THE 1C:ENTERPRISE SCRIPT 8.3.1. Major Techniques and Practices 8.3.1.1. Query Result Iteration Methods 8.3.1.2. Working with Selection 8.3.2. Work with Temporary Tables 8.3.2.1. Temporary Tables Manager 8.3.2.2. Creation of Temporary Tables 8.3.2.3. Use of Temporary Tables 8.3.2.4. Deletion of Temporary Table 8.3.3. Working with Batch Queries CHAPTER 9. WORK WITH DATA 9.1. OBJECT LOCKS 9.1.1. Pessimistic Lock 9.1.2. Pessimistic Lock and Transactions 9.1.3. Optimistic Lock 9.2. TRANSACTIONS 9.2.1. Explicit Calls to Transactions 9.2.2. Nested Transaction Call 9.2.3. Impact of Transactions on Program Objects 9.3.1. General Information on Locks 9.3.2. Managed Locks 9.3.3. Setting Lock Mode in Configuration 9.3.5. Automatic and Managed Mode: Features 9.3.6. Working with multiple managed locks 9.3.7. Configuration Modification When Switching to Managed Lock Mode 9.3.7.1. Identification of Code Blocks to Be Refined 9.3.7.2. Managed Lock Mode Selection 9.3.7.3. Sample Configuration Refinement 9.4. EXCLUSIVE MODE CHAPTER 10. DATA COMPOSITION SYSTEM 10.1. GENERAL INFORMATION ON DATA COMPOSITION 10.2.1. Use Property 10.2.2. Data Composition System Field 10.2.3. Data Composition System Parameters 10.3. DATA COMPOSITION SCHEMA 10.3.1. Data Composition Schema Components 10.3.1.1. Data Sources 10.3.1.2. Data Sets 10.3.1.3. Data Set Links 10.3.1.4. Calculated Fields 10.3.1.5. Resource Fields 10.3.1.6. Parameters 10.3.1.7. Nested Schemas 10.3.1.8. Templates 10.3.1.9. Field Templates 10.3.1.10. Group Templates 10.3.1.11. Group Header Templates 10.3.1.12. Default Settings 10.3.2. Working with Multiple Data Sets 10.3.3. Query Language Extension for Data Composition System 10.3.3.1. Syntax Elements of Query Language Extension for Data Composition System 10.3.3.2. Auto Fill of Available Fields 10.3.4. Data composition system expression language 10.3.4.1. Literal constants 10.3.4.2. Operations with numbers 10.3.4.3. String operations 10.3.4.4. Comparison operations 10.3.4.5. Boolean operations 10.3.4.6. Aggregate functions 10.3.4.7. Other operations 10.3.4.8. Rules for comparing two values 10.3.4.9. Working with NULL value 10.3.4.10. Operation priorities 10.3.4.11. Functions 10.3.4.12. Common module functions 10.3.5. Data Composition Schema Wizard 10.3.5.1. Editing Data Sets 10.3.5.2. Editing Data Set Fields 10.3.5.3. Editing Data Set Links 10.3.5.4. Editing Calculated Fields 10.3.5.5. Editing Resources 10.3.5.6. Editing Parameters 10.3.5.7. Editing Templates 10.3.5.8. Nested Schemas 10.3.5.9. Settings 10.3.6. Data Composition Variant Settings 10.3.6.1. Structure of Data Composition Settings Variant 10.3.6.2. Properties of Data Composition Settings 10.3.6.3. Available Objects 10.3.6.4. Available Fields 10.3.6.5. Data Composition Settings Composer 10.3.7. User Settings of Data Composition System 10.3.7.1. User Settings Object Model 10.3.7.2. Setup of User Settings Items 10.3.7.3. Editing User Settings 10.3.7.4. Quick User Settings 10.3.7.5. Settings Composer 10.3.7.6. Fillup of User Setting Values 10.3.7.7. Applying User Settings 10.4. DATA COMPOSITION TEMPLATE 10.4.1. Data Composition Template Sections 10.4.1.1. Area Template Structure 10.4.1.2. Chart Area Template Structure 10.4.2. Appearance Templates 10.4.3. Generator of Template Areas 10.4.3.1. Generation of Data Composition Template 10.5. DATA COMPOSITION PROCESSOR 10.6. FUNCTIONAL OPTIONS AND RIGHTS TO VIEW FIELDS IN REPORTS 10.7. DATA COMPOSITION RESULT 10.7.1. Composition Result Output to Spreadsheet Document 10.7.2. Composition Result Output to Value Table and Value Tree 10.8. CALCULATION OF TOTALS BY BALANCE FIELDS IN DATA COMPOSITION SYSTEM 10.8.1. Calculation of Totals by Balance Fields 10.8.2. Calculation of Totals by Accounting Balance Fields 10.8.3. Template Composition 10.9. WORKING WITH HIERARCHY IN DATA COMPOSITION SYSTEM 10.9.1. Hierarchical Groups 10.9.2. Hierarchical Detail Records 10.9.3. Output of a Single Item in Multiple Parent Records 10.9.4. IN HIERARCHY Condition 10.10. USE OF DATA COMPOSITION SYSTEM IN APPLICATION DEVELOPMENT 10.10.1. Input Parameters 10.10.2. Use of Metadata Object Properties in Reports 10.10.3. Background Report Execution 10.11. SPECIFICS OF USING OF DATA COMPOSITION SYSTEM CHAPTER 11. ACCOUNTING 11.1. OVERVIEW 11.2. CHARTS OF ACCOUNTS 11.3. ANALYTICAL ACCOUNTING 11.4. TYPES OF ACCOUNTING 11.5. ACCOUNTING REGISTER RECORDS AND RECORD SETS 11.6. CONSOLIDATED ACCOUNTING 11.7. CREATION OF CHART OF ACCOUNTS 11.7.1. Chart Of Accounts Properties 11.7.2. Setting up Various Accounting Types 11.7.3. Generation of Account List (Predefined Accounts) 11.8. ACCOUNTING REGISTERS 11.8.1. Accounting Register Properties 11.8.2. Accounting Register Records CHAPTER 12. PERIODICAL CALCULATIONS 12.1. MAJOR CONCEPTS 12.2. CHARTS OF CALCULATION TYPES 12.2.1. Calculation Property Category 12.2.2. Predefined Calculation Types 12.3.1. General Information on Calculation Registers 12.3.1.1. Displacement Mechanism 12.3.1.2. Recalculation Mechanism 12.3.2. Editing Calculation Register CHAPTER 13. BUSINESS PROCESSES AND TASKS 13.1. MAJOR CONCEPTS 13.2. GENERAL INFORMATION 13.3. ROUTING 13.4. ADDRESSING SYSTEM 13.5. STARTING BUSINESS PROCESSES 13.6. TASK PERFORMANCE 13.7. SPLITTING AND JOINING 13.8. MANUAL CONTROL 13.8.1. Business Process Completion Attribute 13.8.2. Task Performance Attribute 13.8.3. Task Removal 13.8.4. Task Addition 13.9. CONDITIONAL JUMP 13.10. SWITCH 13.11. TASK GENERATION 13.12. PERFORMANCE CHECK 13.13. NESTED PROCESS EXECUTION 13.14. BUSINESS PROCESS COMPLETION 13.15. STANDARD BUSINESS PROCESS AND TASK ATTRIBUTES 13.16. BUSINESS PROCESSES WITH SEVERAL STARTING POINTS 13.17. FEEDBACK 13.18. FLOWCHART 13.19. BUSINESS PROCESS EDITING 13.20. TASK EDITING CHAPTER 14. DATA ANALYSIS AND FORECASTING 14.1. OVERVIEW 14.1.1. Main Mechanism Objects 14.1.2. Types of Data Analysis 14.1.2.1. Summary statistics 14.1.2.2. Association rules 14.1.2.3. Sequential patterns 14.1.2.4. Cluster analysis 14.1.2.5. Decision tree 14.1.3. Forecasting Models 14.2. THE SUMMARY STATISTICS ANALYSIS TYPE 14.3. THE ASSOCIATION RULES ANALYSIS TYPE 14.3.1. Rules Prune Types 14.3.1.1. Covered rules pruning 14.3.1.2. Pruning redundant rules 14.4. THE SEQUENTIAL PATTERNS ANALYSIS TYPE 14.5. THE DECISION TREE ANALYSIS TYPE 14.6. THE CLUSTERIZATION ANALYSIS TYPE 14.6.1. Metrics used 14.6.1.1. Euclidean 14.6.1.2. Squared euclidean 14.6.1.3. City block 14.6.1.4. Maximum 14.6.2. Clusterization methods 14.6.2.1. Nearest neighbor 14.6.2.2. Furthest neighbor 14.6.2.3. Centroid 14.6.2.4. K-means 14.6.2.5. Data output to a dendrogram CHAPTER 15. DATA EXCHANGE MECHANISMS 15.1. GOALS AND OBJECTIVES 15.1.1. Universal Data Exchange Mechanisms 15.1.2. Distributed Infobases 15.2. UNIVERSAL DATA EXCHANGE MECHANISMS 15.2.1. XML Documents Read and Write Tools 15.2.2. XML Serialization 15.2.2.1. Data Presentation in XML-Serialization 15.2.2.2. Access to XML-Serialization Tools From 1C:Enterprise Script 15.2.3. Exchange Plans 15.2.3.1. Exchange Plan Nodes 15.2.3.2. Message Infrastructure 15.2.3.3. Change Registration Service 15.2.3.4. Access to Exchange Plan Mechanisms Using 1C:Enterprise Script 15.3.1. General Principles 15.3.2. Exchange Plans 15.3.2.1. Master and Slave Nodes 15.3.2.2. Collision Resolution 15.3.2.3. Initial Image of Distributed Infobase Node 15.3.2.4. Data Exchange Messages in Distributed Infobases 15.3.2.5. Exchange Plan Configuration for Work with Distributed Infobase 15.3.2.6. Exchange Plan Event Handlers 15.3.3. Working with Distributed Infobase 15.3.3.1. Working with Distributed Infobase from 1C:Enterprise Script Creation of Initial Image for Distributed Infobase Slave Node 15.3.3.2. Interactive Work with Distributed Infobase 15.3.4. Data Exchange Scenarios in Distributed Infobase 15.3.4.1. Default Behavior 15.3.4.2. Data Distribution in Slave Nodes 15.3.4.3. Non-Standard Collision Resolution 15.3.4.4. Other Scenarios CHAPTER 16. XDTO MECHANISM 16.1. XDTO FACTORY 16.1.1. XDTO Factory Retrieval from XSD Schema File 16.2. XDTO DATA TYPES 16.2.1. XDTO Value Type 16.2.2. XDTO Object Type 16.2.3. XDTO Property 16.3. XDTO DATA INSTANCES 16.3.1. XDTO Value 16.3.2. XDTO Object 16.3.3. XDTO Sequence 16.3.4. XDTO List 16.3.5. XÐath 16.4. XDTO-BASED XML SERIALIZATION 16.5. XML SCHEMA LAYOUT RECOMMENDATIONS 16.6. XDTO FACTORY CHECK RULES 16.6.1. Check Rules for XDTO Factory Proper 16.6.2. XDTO Package Check Rules 16.6.3. XDTO Value Type Check Rules 16.6.4. XDTO Object Type Check Rules 16.6.5. Facet Limitation Rules CHAPTER 17. WEB SERVICE MECHANISM 17.1. PROVISION OF FUNCTIONALITY THROUGH WEB SERVICES 17.2. EXAMPLE OF WEB SERVICE IMPLEMENTATION 17.3. USING THIRD-PARTY VENDOR WEB SERVICES 17.3.1. Example of Using Static Web Service References 17.3.2. Example of Using Dynamic WS References 17.4. EDITING WEB SERVICE PROPERTIES 17.4.1. Operation Properties 17.4.2. Parameter Properties CHAPTER 18. JOB MECHANISM 18.1. BACKGROUND JOBS 18.2. SCHEDULED JOBS 18.3.1. File Mode 18.3.2. Client/Server Mode 18.4. CREATION OF SCHEDULED JOB METADATA CHAPTER 19. FULL-TEXT DATA SEARCH MECHANISM 19.1. GENERAL INFORMATION ON FULL-TEXT INDEXING 19.2. USE OF FULL-TEXT SEARCH MECHANISMS 19.3. USE OF ADDITIONAL DICTIONARIES CHAPTER 20. TEMPORARY STORAGE MECHANISM, WORKING WITH FILES AND PICTURES 20.1. TEMPORARY STORAGE 20.2. WORKING WITH FILES AND TEMPORARY STORAGE 20.2.1.1. Single File Placement 20.2.1.2. File Set Placement 20.2.2. Data Placement in Temporary Storage 20.2.3. Data Retrieval from Temporary Storage 20.2.4. Data Deletion from Temporary Storage 20.2.5. Address Check for Temporary Storage Membership 20.2.6. Attribute Address Retrieval 20.2.7.1. Single File Retrieval 20.2.7.2. File Set Retrieval 20.2.8. Example of File Method Use 20.2.9. Enabling Bulk File Operations 20.2.10. Working with Temporary Storage in Background Job 20.2.11. Address Support in Picture Box 20.2.12. Access to standard directories 20.3. SPECIFIC FEATURES OF USING IN WEB CLIENT CHAPTER 21. THE EVENT LOG 21.1. DETAILS MANAGEMENT 21.2. WRITING EVENTS 21.3. EVENT LOGGING MANAGEMENT 21.3.1. The Access Event Parameters Configuration 21.3.2. Access Denied Event Parameters Configuration 21.4. GETTING EVENT LOG RECORDS 21.5. ADDITIONAL METHODS CHAPTER 22. THE CRYPTOGRAPHIC MECHANISM 22.1. GENERAL MECHANISM DESCRIPTION 22.2. MAIN CONCEPTS 22.3. GENERAL PRINCIPLES OF USING CRYPTOGRAPHIC MECHANISMS 22.4. WORKING WITH CRYPTOGRAPHIC MODULES 22.5. USAGE EXAMPLES CHAPTER 23. EXTERNAL DATA SOURCES 23.1.1. Overview 23.1.2. General Usage Principles 23.1.3. Editing External Data Source Structure 23.1.3.1. External Data Sources 23.1.3.2. External Data Source Tables 23.1.3.3. External Data Source Table Fields 23.1.3.4. Other Properties 23.1.3.5. Loading Table Structures from an External Data Source 23.1.4. Example of External Data Source Table Creation 23.1.5. ODBC Connection String 23.1.5.1. Full Connection String 23.1.5.2. Describing a Data Source 23.1.5.3. ODBC Data Source Administration Utility 23.2.1. Overview 23.2.2. The general principles of usage 23.2.3. Editing external data source structure 23.2.3.1. External data source 23.2.3.2. External data source cube 23.2.3.3. Dimension table 23.2.3.4. The dimension table field 23.2.3.5. Dimensions 23.2.3.6. Resources 23.2.3.7. Loading the cube structure from an external data source 23.2.4. Query Language Limitations When Using an Analytical External Data Source 23.2.5. An OLAP Server Connection String 23.3. EXTERNAL DATA SOURCE MANAGEMENT 23.4. CONNECTING TO AN EXTERNAL DATA SOURCE IN 1C:ENTERPRISE MODE 23.5.1. The Execution Location of External Data Source Queries 23.5.2. Using External Data Sources 23.5.2.1. In queries 23.5.2.2. In the Data Composition System 23.5.3. Rules for Converting Values 23.5.4. An external data source included in a separator CHAPTER 24. THE DATA SEPARATION MECHANISM 24.1. OVERVIEW 24.2.1. Using Separated Data 24.2.2. The Separator Value and Usage Flag 24.2.3. Users Separation 24.2.4. Authentication Separation 24.2.5.1. Overview 24.2.5.2. Conditional Separation Set in Common Attribute Properties 24.2.5.3. Conditional Separation Set for an object (the Content Property) 24.2.5.4. Specifics of Conditional Separation in a Distributed System 24.3. DETERMINING AN ABILITY TO PERFORM AN ACTION OR A DATASET 24.4. SETTING SEPARATOR VALUES ON STARTUP 24.4.1. The Client Application Command Line 24.4.2. The Web Client or Thin Client Connected via a Web Server 24.4.2.1. Using the Z option 24.4.2.2. Using default.vrd 24.4.3. External Connection and Connection Strings 24.5. SAFE DATA SEPARATION MODE 24.6. DATA AREA DELETION CHAPTER 25. DEVELOPING SOLUTIONS FOR THE MOBILE PLATFORM 25.1. GENERAL INFORMATION 25.2. THE APPLICATION INTERFACE 25.3.1. The Global Command Interface 25.3.2. User Messages 25.3.3. Form 25.3.4. Working With Files 25.3.5.1. Phone calls and sending SMS messages 25.3.5.2. Location tools 25.3.5.3. Working with multimedia 25.3.6. Text Input 25.3.7. Reports 25.3.8. Working With Images 25.4. INTERACTION WITH A MOBILE DEVICE DURING MOBILE APPLICATION DEVELOPMENT 25.4.1.1. For iOS 25.4.1.2. For Android 25.4.2. Publishing a Mobile Application on the Web Server 25.4.3. Starting and Restarting an Application on the Mobile Platform 25.4.4.1. Create Application 25.4.4.2. Modifying application properties 25.4.4.3. Deleting an application 25.4.5. Mobile Application Checkup Before Publishing in an Application Store 25.5. PREPARING THE MOBILE APPLICATION FOR PUBLISHING IN AN APPLICATION STORE 25.5.1. For iOS 25.5.2. For Android CHAPTER 26. DEVELOPMENT TOOLS 26.1.1. Background Information 26.1.2. Role-Based Form Setup 26.2. TEXT EDITOR 26.2.1. Editing Modules 26.2.1.1. Color Syntax Highlighting 26.2.1.2. Group 26.2.1.3. Module Formatting 26.2.1.4. Navigation of Module Procedures and Functions 26.2.1.5. Context Tips During Module Text Entry 26.2.1.6. Module Syntax Check 26.2.1.7. Configuration Module Access Restrictions 26.2.2. Editing Text Templates 26.2.2.1. Text Template Format 26.2.2.2. Service Part of an Area 26.2.2.3. Text Part of an Area 26.2.2.4. Text Template Keyword Description 26.2.2.5. Invoice Printing Example 26.2.3. Editing Template Text 26.2.4. Query Text Editor 26.3. CONFIGURATION COMMAND INTERFACE EDITOR 26.3.1. General Rules for Setting Visibility 26.3.2. Filter by Roles 26.4. START PAGE WORK AREA EDITOR 26.5. MAIN SECTION COMMAND INTERFACE EDITOR 26.6. COMMAND INTERFACE EDITOR 26.7. ALL SUBSYSTEMS EDITOR 26.7.1. Subsystem Contents Setup 26.7.2. Subsystem Command Interface Settings 26.8. QUERY WIZARD 26.9. QUERY WIZARD WITH RESULT PROCESSING 26.10. REGISTER RECORD WIZARD 26.11. PRINT WIZARD 26.12. GENERATION SETTINGS WIZARD 26.13. CONFIGURATION OBJECT FORM WIZARD 26.13.1. Constant Form Wizard Features 26.14. TEMPLATE WIZARD 26.15. FORMAT STRING WIZARD 26.16. WIZARD FOR STRINGS IN DIFFERENT LANGUAGES 26.17. SPREADSHEET DOCUMENT EDITOR 26.17.1. Spreadsheet Documents in 1C:Enterprise 26.17.2. Template 26.17.2.1. General Principles of Template Design 26.17.2.2. Template Cell Properties 26.17.3. Spreadsheet Document in Data Input Mode 26.17.3.1. Spreadsheet Document Preparation 26.17.3.2. Form Preparation for Data Input 26.17.3.3. Implementation of Response to Spreadsheet Document Cell Change 26.18. FLOWCHART EDITOR 26.18.1. Flowchart Editing 26.18.2.1. Appearance Recommendations 26.18.2.2. Items Order 26.18.2.3. Working with Connecting Lines 26.18.2.4. Flowchart Check for Correctness 26.18.3. Flowchart Items 26.18.3.1. Common Properties of Flowchart Items 26.18.3.2. Connecting Line 26.18.3.3. Activity 26.18.3.4. Splitting Point 26.18.3.5. Condition Point 26.18.3.6. End Point 26.18.3.7. Start Point 26.18.3.8. Join 26.18.3.9. SubBusinessProcess Point 26.18.3.10. Data processor Point 26.18.3.11. Switch 26.18.4. Module 26.19. PICTURE EDITOR 26.19.1. Picture Editing 26.19.2. Picture Collections 26.20. HTML DOCUMENT EDITOR 26.20.1.1. Formatting Text 26.20.1.2. Inserting and Editing Tables 26.20.1.3. Picture Insertion 26.20.1.4. Marquee 26.20.1.5. Hyperlink 26.20.1.6. Bookmark 26.20.1.7. Line 26.20.2. Editing in HTML Format 26.20.3. Viewing Results 26.21. LOCALIZATION OF CONFIGURATIONS 26.22. CENTRALIZED CONFIGURATION CHECK 26.23. USABILITY ANALYSIS FOR OPERATION OF SOLUTIONS BASED ON 1C:ENTERPRISE PLATFORM CHAPTER 27. DEBUGGING AND TESTING OF APPLICATION SOLUTIONS 27.1. DEBUGGER 27.1.1. Debugger Use 27.1.1.1. Application Setup for Debug Mode 27.1.1.2. Attach Debug Items 27.1.1.3. Additional Port Range Settings 27.1.2. Breakpoint 27.1.3. Step-by-Step Execution 27.1.4. Debugging External Data Processors (Reports) 27.1.5. Debug Management 27.1.6. Expression Window 27.1.7. Immediate Window 27.1.8. Call Stack 27.1.9. Debugging Protected Modules 27.1.10.1. 1C:Enterprise Startup in Debug Mode 27.1.10.2. Connection to Running 1C:Enterprise 27.2. PERFORMANCE METER 27.2.1. Available Options 27.2.2. Measurement Results 27.2.3. Sorting Measurement Results 27.2.4. Selective Summarization of Measurement Results 27.2.5. Performance Meter in Client/Server Base Operation 27.2.6. Saving Results 27.3. SERVER CALL DELAY IMITATION 27.4. DISPLAY OF SERVER CALLS 27.5.1. General Information 27.5.2. Running the Testing system 27.5.2.1. Running testing client 27.5.2.2. Running testing manager 27.5.2.3. Running client applications for recording the user action log 27.5.3. Description of features 27.5.4. Sample Testing Scenario 27.5.5.1. Recording user action log 27.5.5.2. Converting the user action log into an automated testing scenario CHAPTER 28. COMPARE AND MERGE CONFIGURATIONS 28.1. CONFIGURATION COMPARISON CONDITIONS 28.2. LAUNCH OF CONFIGURATION COMPARING AND MERGING MODE 28.3. COMPARE CONFIGURATIONS 28.4. COMPARE PREDEFINED DATA 28.5. COMPARE AND MERGE CONFIGURATIONS WINDOW 28.6. CONFIGURATION COMPARISON SETTING 28.7. OBJECT EDITING 28.8. DISTRIBUTED DEVELOPMENT AND SUPPORT – EDITING 28.9. OBJECT MAPPING 28.10. MERGING MODE 28.11. SETTING ORDER OF SUBORDINATE OBJECTS 28.12. VIEWING DIFFERENCES 28.13. MODULE COMPARISON 28.14. FILTERING OBJECTS AND ACTIVATING MERGING 28.15. LOADING CONFIGURATION FROM FILE CHAPTER 29. DISTRIBUTED CONFIGURATION DEVELOPMENT 29.1.1. Creation of Configuration Repository 29.1.2. Open Configuration Repository 29.1.3. Maintaining the Configuration Repository Users List 29.1.4. Configuration Repository Administration 29.1.5. Repository Backup Configuration 29.2. WORKING WITH CONFIGURATION REPOSITORY 29.2.1. Configuration Repository Filter 29.2.2. Locking Configuration Repository Objects 29.2.3. Object Placement in Configuration Repository 29.2.4. Object Retrieval from Configuration Repository 29.2.5. Release of Object Locks 29.2.6. Update of Configuration Repository Object Statuses 29.2.7. Comparison of Configuration Repository and Current Configuration 29.2.8. Comparison of Configuration Repository Objects and Current Configuration Objects 29.2.9. Save Configuration Repository as Configuration 29.2.10. Disconnection from Configuration Repository 29.2.11. Configuration Repository History 29.2.11.1. Working with Configuration Repository Version 29.2.11.2. Rollback to Previous Versions 29.2.11.3. Deletion of Old Versions 29.2.11.4. Merging Versions 29.2.11.5. Assign Version Labels 29.2.11.6. Filter 29.2.11.7. Comparison of Configuration Repository Versions 29.2.12. Object History 29.2.13. Actions with Configuration Repository without Connection 29.3. REMOTE WORK WITH CONFIGURATION REPOSITORY 29.3.1. Architecture Overview 29.3.1.1. General Flowchart for Working with Configuration Repository 29.3.1.2. TCP Interaction 29.3.1.3. HTTP Interaction 29.3.2. Configuration Repository Server Installation 29.3.3. Web Server Setup for Work with Configuration Repository 29.3.3.1. For Microsoft Internet Information Services web server 29.3.3.2. For Apache web servers 29.3.4. Launch of Configuration Repository Server 29.3.4.1. Windows OS 29.3.4.2. Linux OS 29.3.5. Connection to Configuration Repository Server 29.3.6. Creation of Configuration Repository 29.4. RECOMMENDATIONS ON HOW TO USE CONFIGURATION REPOSITORY CHAPTER 30. CONFIGURATION DISTRIBUTION AND SUPPORT 30.1.1. Distribution Set Options 30.1.2. Creation of Distribution Files 30.1.3. Preparing Distribution Kits for Standard Configurations 30.1.3.1. Distribution Kit Description 30.1.3.2. Creation of Kit 30.2. CONFIGURATION SUPPORT 30.2.1. Setting Configuration Support 30.2.2. Support Setting 30.2.2.1. Full (Automated) Support 30.2.2.2. Support with Updates 30.2.3. Configuration Update 30.2.4. Template Directory Description File CHAPTER 31. SERVICE FEATURES 31.1.1.1. Setting Window Placement Mode 31.1.1.2. Restoring Window Position 31.1.1.3. Selection of Window Mode for Object Forms 31.1.2. Window Settings Dialog Box 31.1.3. Use of New Window Mode 31.1.4. Service Windows 31.1.5. Closing Windows 31.1.6. Window Navigation History 31.2. SETTING DESIGNER PARAMETERS 31.2.1. General 31.2.2. Texts 31.2.3. Modules 31.2.3.1. Setting Editing Parameters 31.2.3.2. Setting Module Check Parameters 31.2.3.3. Setting Group Parameters 31.2.3.4. Context Tip Settings 31.2.4.1. Main Parameters 31.2.4.2. Additional Parameters 31.2.5. Help 31.5. TEXT TEMPLATES 31.5.1. Template List Maintenance 31.5.2. Editing Templates 31.5.2.1. Template Control Directives 31.5.2.2. Template Text Editor 31.6. SYNTAX ASSISTANT 31.6.1. Syntax Assistant Settings 31.6.2. Content Tab of Syntax Assistant 31.6.3. Copying 1C:Enterprise Script Items 31.6.4. Search in Syntax Assistant 31.7. FILE COMPARISON 31.7.1. Comparison of External Data Processors 31.8. BUILT-IN SYSTEM FOR HELP CONTENT RETRIEVAL CHAPTER 32. ADD-INS 32.1. WORK IN THIN AND THICK CLIENTS 32.2. WORK IN WEB CLIENT 32.3. WORK ON SERVER 32.4.1. Native API Technology 32.4.1.2. Load from File on Disk 32.4.1.3. Load Add-In from Template 32.4.1.4. Load from Infobase 32.4.1.5. Attach Add-In from ZIP Archive 32.4.2.1. Load Add-In 32.4.2.2. Attach Add-In CHAPTER 33. SPECIFICS OF CROSS-PLATFORM APPLIED SOLUTION DEVELOPMENT 33.1. FILE SYSTEM SPECIFICS 33.2. WORKING WITH EXTERNAL DEVICES 33.3. RIGHTS LIMITATIONS 33.4. FONTS 33.5. HTMLDOCUMENTFIELD 33.6. COM, OLE, AND ACTIVEDOCUMENT MECHANISMS APPENDIX 1. URL FORMATS 1.1. URL FORMAT OVERVIEW 1.2. HOST ADDRESS FORMAT 1.3. INTERNAL LINKS 1.3.1. Infobase Object Link 1.3.2. Infobase Object Attribute Link 1.3.3. Infobase Object Tabular Section Attribute Link 1.3.4. Infobase Register Record Link 1.3.5. Infobase Register Record Attribute Link 1.3.6. Report Link 1.3.7. Data Processor Link 1.3.9. Link to the Navigation Point Created by the Standard Command 1.3.10. Temporary Storage Link 1.3.11. Link to an External Data Source Table Record 1.3.12. Links to Global Command Interface Commands APPENDIX 2. RULES FOR GENERATING STANDARD COMMANDS AND AUTOMATIC FORM HEADERS APPENDIX 3. LIST OF AUTO-SAVED SETTINGS APPENDIX 4. FULL-TEXT SEARCH EXPRESSIONS APPENDIX 5. DESCRIPTION OF ACCESS RIGHTS APPENDIX 6. SYSTEM BEHAVIOR IN VARIOUS MODES 6.1. SPECIAL CHARACTERISTICS OF LOW CONNECTION SPEED MODE 6.2. SPECIAL CHARACTERISTICS OF COMPATIBILITY MODE 6.3. SPECIFIC CHARACTERISTICS OF WEB CLIENT 6.4. WEB CLIENT SPECIFICS FOR IPAD 6.5. SPECIFICS OF SYSTEM OBJECT BEHAVIOR WITH ENABLED DATA SEPARATION MODE 6.5.1. Changing Separator Values 6.5.2. Object Numeration 6.5.3. Real-Time Timestamp 6.5.4. Predefined Data 6.5.5. Access Rights 6.5.6. Users 6.5.7. Exchange Plans 6.5.8. Functional Options 6.5.9. Scheduled Jobs 6.5.10. Background Jobs 6.5.11. Web Services 6.5.12. Constants 6.5.13. Registers 6.5.13.1. Information Registers 6.5.13.2. Accumulation and Accounting Registers 6.5.13.3. Calculation Registers 6.5.14. Document Sequence 6.5.15. Infobase Options 6.5.16. Session List 6.5.17. Connection List 6.5.18.1. Visual Representation 6.5.18.2. Filter 6.5.18.3. Getting Event Log Records 6.5.18.4. Other 6.5.19. Settings and Favorites 6.5.20. History 6.5.21. Queries 6.5.22. Managed Transaction Locks 6.5.23. Exclusive mode 6.5.24. Deleting Marked Objects 6.5.25. Full-text search 6.6. RUNNING THE CLIENT APPLICATION IN LINUX 6.7. SPECIFICS OF MOBILE APPLICATION OPERATIONS APPENDIX 7. OPERATION OF VARIOUS DBMS 7.1. GENERAL FEATURES 7.2. FILE DATABASE 7.3. IBM DB2 SERVER 7.4. MICROSOFT SQL SERVER 7.5. ORACLE DATABASE SERVER 7.6. POSTGRESQL SERVER APPENDIX 8. WORK IN XBASE 8.1. FIELDS AND RECORDS 8.2. SPREADSHEET, SPREADSHEET STRUCTURE AND DATABASE FILE 8.3. INDICES, INDEX AND FILTER EXPRESSIONS AND INDEX FILE 8.4. WRITING CHANGES TO DATABASE 8.5. WORK WITH INDEX FILES 8.6. RECORD DELETION 8.7. CREATION OF DATABASE, INDEX AND INDEX FILE 8.8. LIMITATIONS APPENDIX 9. SPECIFICS OF USING SEPARATE MECHANISMS APPENDIX 10. AUTOMATIC FORM ELEMENT NAME GENERATION RULES