online-invoicing-system.axp

<database><databaseName>online_inovicing_system</databaseName><databaseUser></databaseUser><databasePassword></databasePassword><databaseServer>localhost</databaseServer><charEncoding>UTF-8</charEncoding><noMySQLEncoding>False</noMySQLEncoding><timeFormat>12</timeFormat><rtl>False</rtl><timeZone>Europe/London</timeZone><hideNavMenu>False</hideNavMenu><hideLogin>False</hideLogin><adminServerStatus>True</adminServerStatus><sortTablesAlphabetically>False</sortTablesAlphabetically><styleSheetFile></styleSheetFile><themeFile>bootstrap.css</themeFile><theme3D>False</theme3D><themeCompact>True</themeCompact><scrollStyle>0</scrollStyle><dateFormat>2</dateFormat><dateSeparator>4</dateSeparator><version>22.12</version><lastGenDate>2022-03-03 17:45:45</lastGenDate><outputFolder>C:\xampp\htdocs\open-source-apps\online-invoicing-system\app</outputFolder><autoCompleteSize>0</autoCompleteSize><homePageTheme></homePageTheme><filesToKeep><![CDATA[|]]></filesToKeep><filesToOverwrite><![CDATA[|thumbnail.php|link.php|checkMemberID.php|incCommon.php|parent-children.php|ajax_combo.php|admin\pageAssignOwners.php|admin\pageChangeMemberStatus.php|admin\pageDeleteGroup.php|admin\pageDeleteMember.php|admin\pageDeleteRecord.php|admin\pageEditGroup.php|admin\pageEditMember.php|admin\pageEditMemberPermissions.php|admin\pageEditOwnership.php|admin\pageHome.php|admin\pageMail.php|admin\pagePrintRecord.php|admin\pageSender.php|admin\pageSettings.php|admin\pageTransferOwnership.php|admin\pageViewGroups.php|admin\pageViewMembers.php|admin\pageViewRecords.php|admin\incCommon.php|admin\incFunctions.php|admin\index.php|admin\pageUploadCSV.php|admin\pageRebuildThumbnails.php|datalist.php|combo.class.php|date_combo.class.php|data_combo.class.php|defaultFilters.php|lib.php|setup.php|settings-manager.php|updateDB.php|ci_input.php|clients_view.php|clients_dml.php|clients_autofill.php|invoices_view.php|invoices_dml.php|invoices_autofill.php|invoice_items_view.php|invoice_items_dml.php|invoice_items_autofill.php|header.php|footer.php|index.html|language.php|defaultLang.php|index.php|home.php|login.php|membership_signup.php|membership_thankyou.php|membership_passwordReset.php|membership_profile.php|admin\incFooter.php|admin\incHeader.php|templates\clients_templateTV.html|templates\clients_templateTVS.html|templates\clients_templateDV.html|templates\clients_templateDVP.html|templates\children-clients.php|templates\invoices_templateTV.html|templates\invoices_templateTVS.html|templates\invoices_templateDV.html|templates\invoices_templateDVP.html|templates\children-invoices.php|templates\invoice_items_templateTV.html|templates\invoice_items_templateTVS.html|templates\invoice_items_templateDV.html|templates\invoice_items_templateDVP.html|templates\children-invoice_items.php|admin\adminStyles.css|admin\toolTipData.js|admin\toolTips.js|common.js.php|dynamic.css.php|blank.gif|table.gif|update.gif|Exit.gif|images\blank.gif|checked.gif|checkednot.gif|loading.gif|nicEdit.js|nicEditorIcons.gif|photo.gif|handshake.jpg|new.png|spinner.gif|admin\images\add_icon.gif|admin\images\approve_icon.gif|admin\images\data_icon.gif|admin\images\delete_icon.gif|admin\images\edit_icon.gif|admin\images\helpBg.gif|admin\images\mail_icon.gif|admin\images\member_icon.gif|admin\images\members_icon.gif|admin\images\stop_icon.gif|admin\images\view_icon.gif|admin\images\home.gif|logo.png|ajax_check_unique.php|ajax_check_login.php|ajax_admin_tools.php|admin\pageRebuildFields.php|admin\getUsers.php|admin\ajax-maintenance-mode.php|db.php|templates\clients-ajax-cache.php|templates\invoices-ajax-cache.php|templates\invoice_items-ajax-cache.php|items_view.php|items_dml.php|items_autofill.php|templates\items-ajax-cache.php|language-admin.php|templates\children-clients-printable.php|templates\children-invoices-printable.php|templates\children-invoice_items-printable.php|templates\items_templateTV.html|templates\items_templateTVS.html|templates\items_templateDV.html|templates\items_templateDVP.html|templates\children-items.php|templates\children-items-printable.php|hooks\README.html|admin\pageBackupRestore.php|item_prices_view.php|item_prices_dml.php|item_prices_autofill.php|templates\item_prices-ajax-cache.php|templates\item_prices_templateTV.html|templates\item_prices_templateTVS.html|templates\item_prices_templateDV.html|templates\item_prices_templateDVP.html|templates\children-item_prices.php|templates\children-item_prices-printable.php|ajax-update-calculated-fields.php|admin\pageServerStatus.php|admin\app-documentation.php|cli-update-calculated-fields.php|import-csv.php|handshake.svg|shortcuts.js|dynamic.css|common.js|admin\pageQueryLogs.php|admin\pageSQL.php|admin\pageSQL.js|admin\ajax-sql.php|admin\ajax-saved-sql.php|]]></filesToOverwrite><homepageFirstTableDoubleWidth>False</homepageFirstTableDoubleWidth><homepagePanelHeight>100</homepagePanelHeight><homepageTablesPerRow>4</homepageTablesPerRow><groups><![CDATA[None]]></groups><showTechnicalDocumentationAdminArea>False</showTechnicalDocumentationAdminArea><technicalDocumentationApp><![CDATA[]]></technicalDocumentationApp><adminInteractiveSQL>True</adminInteractiveSQL><multipleSuperAdmins>False</multipleSuperAdmins><plugins><calendar><data>{"events":{"unpaid-invoice":{"type":"unpaid-invoice","color":"danger","textColor":"danger","table":"invoices","customWhere":"`invoices`.`status` = 'Unpaid'","title":"{5}&lt;br&gt;Invoice# {2}&lt;br&gt;{3}","allDay":true,"startDateField":"date_due","startTimeField":"","endDateField":"","endTimeField":""}},"calendars":{"unpaid-invoices":{"id":"unpaid-invoices","title":"Unpaid invoices","initial-view":"dayGridMonth","initial-date":"[last-month]","events":["unpaid-invoice"],"locale":"","groups":["Admins"],"links-home":"1","links-navmenu":"1"}}}</data></calendar></plugins><table><plugins><spm><spm_fields>3:4:2:12:14:9001:</spm_fields></spm><summary_reports><report_details>[{"report_hash":"pprh7b8b2dazav20cln9","title":"Client sales over time","table":"invoices","table_index":0,"label":"client","caption1":"Client","caption2":"Sum of Invoices","group_function":"sum","group_function_field":"total","group_array":[],"look_up_table":"clients","look_up_value":"name","label_field_index":"5","date_field":"date_due","date_field_index":"4","report_header_url":"","report_footer_url":"","data_table_section":1,"barchart_section":0,"piechart_section":0,"override_permissions":0,"custom_where":"","date_separator":"\/"}]</report_details></summary_reports><mass_update><command_details>[{"label":"Mark as paid","icon":"ok","field":"status","value":"fixedValue","fixedValue":"Paid","confirmation":1,"groups":[],"hash":"1nvkk0q0ckqc7b8migay"},{"label":"Mark as cancelled","icon":"remove","field":"status","value":"fixedValue","fixedValue":"Cancelled","confirmation":1,"groups":[],"hash":"xe0xlisfn56ps9sp3p76"}]</command_details></mass_update></plugins><name>invoices</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>True</allowMassDelete><homepageShowCount>True</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>True</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Invoices]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Invoice data]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>50</recordsPerPage><redirectAfterInsert><![CDATA[invoices_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>invoice_items;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>2</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[invoice_items&col;1&col;1&col;Invoice items&col;1&col;1&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;]]></parentChildrenSettings><tableIcon>attributes_display.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>True</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><autofocusField>-1</autofocusField><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Code]]></caption><description><![CDATA[]]></description><name>code</name><dataType>15</dataType><length>20</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>True</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>60</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>10</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Status]]></caption><description><![CDATA[]]></description><name>status</name><dataType>15</dataType><length>20</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>True</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[Unpaid]]></default><columnWidth>70</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[Unpaid;;Paid;;Cancelled]]></CSValueList><CSValueListType>2</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>12</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Date due]]></caption><description><![CDATA[]]></description><name>date_due</name><dataType>9</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[1]]></default><columnWidth>100</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client]]></caption><description><![CDATA[]]></description><name>client</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>250</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>name</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`name` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>True</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>2</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client contact]]></caption><description><![CDATA[]]></description><name>client_contact</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>200</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>contact</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`contact` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>3</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client address]]></caption><description><![CDATA[]]></description><name>client_address</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>address</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`address` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>4</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client phone]]></caption><description><![CDATA[]]></description><name>client_phone</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>100</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>phone</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`phone` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>5</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client email]]></caption><description><![CDATA[]]></description><name>client_email</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>50</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>email</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`email` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>6</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client website]]></caption><description><![CDATA[]]></description><name>client_website</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>website</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`website` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>8</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client comments]]></caption><description><![CDATA[]]></description><name>client_comments</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>comments</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`comments` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>7</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[9]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Subtotal]]></caption><description><![CDATA[Automatically calculated from invoice items.]]></description><name>subtotal</name><dataType>8</dataType><length>9</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>14</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT IFNULL(ROUND(SUM(`invoice_items`.`unit_price` * `invoice_items`.`qty`), 2), 0.00) FROM `invoices` 
LEFT JOIN `invoice_items` ON `invoice_items`.`invoice`=`invoices`.`id` 
WHERE `invoices`.`id`='%ID%']]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Discount %]]></caption><description><![CDATA[Enter discount percentage here. Example: enter "10" (without the quotes) to apply a 10% discount off the invoice subtotal.]]></description><name>discount</name><dataType>8</dataType><length>4</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[0]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>13</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Tax %]]></caption><description><![CDATA[Enter tax percentage here. Example: enter "10" (without the quotes) to apply a 10% tax to the invoice.]]></description><name>tax</name><dataType>8</dataType><length>9</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[0]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>15</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[9]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Total]]></caption><description><![CDATA[Automatically calculated: (Subtotal - Discount%) + Tax%]]></description><name>total</name><dataType>8</dataType><length>9</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>True</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>70</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>9</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT ROUND(`invoices`.`subtotal` * (1 - `invoices`.`discount` / 100) * (1 + `invoices`.`tax` / 100), 2)
FROM `invoices`
WHERE `invoices`.`id`='%ID%']]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Comments]]></caption><description><![CDATA[]]></description><name>comments</name><dataType>18</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>11</index><textarea>False</textarea><htmlarea>True</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Invoice template]]></caption><description><![CDATA[Choose the template to use when printing this invoice]]></description><name>invoice_template</name><dataType>15</dataType><length>100</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[one;;two]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>16</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Created]]></caption><description><![CDATA[]]></description><name>created</name><dataType>15</dataType><length>200</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[<%%creationDate%%> <%%creationTime%%> by <%%creatorUsername%%>]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>17</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Last updated]]></caption><description><![CDATA[]]></description><name>last_updated</name><dataType>15</dataType><length>200</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[<%%editingDate%%> <%%editingTime%%> by <%%editorUsername%%>]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>18</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field></table><table><plugins><spm><spm_fields>8:7:6:11:12:13:9001:</spm_fields></spm><summary_reports><report_details>[{"report_hash":"vchppqcoj9ns6e83rtr5","title":"Customers count by country","table":"clients","table_index":1,"label":"country","caption1":"Country","caption2":"Count of Clients","group_function":"count","group_function_field":null,"group_array":[],"look_up_table":"","look_up_value":"","label_field_index":"7","report_header_url":"","report_footer_url":"","data_table_section":1,"barchart_section":1,"piechart_section":0,"override_permissions":0,"custom_where":"","date_separator":"\/"},{"report_hash":"tswrolny4uc1wehbmqun","title":"All-time sales by country","table":"clients","table_index":1,"label":"country","caption1":"Country","caption2":"Sum of Clients","group_function":"sum","group_function_field":"total_sales","group_array":[],"look_up_table":"","look_up_value":"","label_field_index":"7","report_header_url":"","report_footer_url":"","data_table_section":1,"barchart_section":1,"piechart_section":1,"override_permissions":0,"custom_where":"","date_separator":"\/"}]</report_details></summary_reports></plugins><name>clients</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>True</allowMassDelete><homepageShowCount>True</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>True</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>True</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Clients]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Client data]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[clients_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>invoices;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>2</defaultSortField><defaultSortDirection>asc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[invoices&col;1&col;1&col;Invoices&col;1&col;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;]]></parentChildrenSettings><tableIcon>administrator.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>True</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><autofocusField></autofocusField><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Name]]></caption><description><![CDATA[]]></description><name>name</name><dataType>15</dataType><length>200</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>True</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>250</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Contact]]></caption><description><![CDATA[]]></description><name>contact</name><dataType>15</dataType><length>255</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>200</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>2</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Title]]></caption><description><![CDATA[]]></description><name>title</name><dataType>15</dataType><length>40</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>7</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Address]]></caption><description><![CDATA[]]></description><name>address</name><dataType>18</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>3</index><textarea>True</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[City]]></caption><description><![CDATA[]]></description><name>city</name><dataType>15</dataType><length>40</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>8</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Country]]></caption><description><![CDATA[]]></description><name>country</name><dataType>15</dataType><length>40</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[Afghanistan;;Albania;;Algeria;;American Samoa;;Andorra;;Angola;;Anguilla;;Antarctica;;Antigua, Barbuda;;Argentina;;Armenia;;Aruba;;Australia;;Austria;;Azerbaijan;;Bahamas;;Bahrain;;Bangladesh;;Barbados;;Belarus;;Belgium;;Belize;;Benin;;Bermuda;;Bhutan;;Bolivia;;Bosnia, Herzegovina;;Botswana;;Bouvet Is.;;Brazil;;Brunei Darussalam;;Bulgaria;;Burkina Faso;;Burundi;;Cambodia;;Cameroon;;Canada;;Canary Is.;;Cape Verde;;Cayman Is.;;Central African Rep.;;Chad;;Channel Islands;;Chile;;China;;Christmas Is.;;Cocos Is.;;Colombia;;Comoros;;Congo, D.R. Of;;Congo;;Cook Is.;;Costa Rica;;Croatia;;Cuba;;Cyprus;;Czech Republic;;Denmark;;Djibouti;;Dominica;;Dominican Republic;;Ecuador;;Egypt;;El Salvador;;Equatorial Guinea;;Eritrea;;Estonia;;Ethiopia;;Falkland Is.;;Faroe Is.;;Fiji;;Finland;;France;;French Guiana;;French Polynesia;;French Territories;;Gabon;;Gambia;;Georgia;;Germany;;Ghana;;Gibraltar;;Greece;;Greenland;;Grenada;;Guadeloupe;;Guam;;Guatemala;;Guernsey;;Guinea-bissau;;Guinea;;Guyana;;Haiti;;Heard, Mcdonald Is.;;Honduras;;Hong Kong;;Hungary;;Iceland;;India;;Indonesia;;Iran;;Iraq;;Ireland;;Israel;;Italy;;Ivory Coast;;Jamaica;;Japan;;Jersey;;Jordan;;Kazakhstan;;Kenya;;Kiribati;;Korea, D.P.R Of;;Korea, Rep. Of;;Kuwait;;Kyrgyzstan;;Lao Peoples D.R.;;Latvia;;Lebanon;;Lesotho;;Liberia;;Libyan Arab Jamahiriya;;Liechtenstein;;Lithuania;;Luxembourg;;Macao;;Macedonia, F.Y.R Of;;Madagascar;;Malawi;;Malaysia;;Maldives;;Mali;;Malta;;Mariana Islands;;Marshall Islands;;Martinique;;Mauritania;;Mauritius;;Mayotte;;Mexico;;Micronesia;;Moldova;;Monaco;;Mongolia;;Montserrat;;Morocco;;Mozambique;;Myanmar;;Namibia;;Nauru;;Nepal;;Netherlands Antilles;;Netherlands;;New Caledonia;;New Zealand;;Nicaragua;;Niger;;Nigeria;;Niue;;Norfolk Island;;North Korea;;Norway;;Oman;;Pakistan;;Palau;;Palestinian Terr.;;Panama;;Papua New Guinea;;Paraguay;;Peru;;Philippines;;Pitcairn;;Poland;;Portugal;;Puerto Rico;;Qatar;;Reunion;;Romania;;Russia;;Russian Federation;;Rwanda;;Samoa;;San Marino;;Sao Tome, Principe;;Saudi Arabia;;Senegal;;Serbia;;Seychelles;;Sierra Leone;;Singapore;;Slovakia;;Slovenia;;Solomon Is.;;Somalia;;South Africa;;South Georgia;;South Sandwich Is.;;Spain;;Sri Lanka;;St. Helena;;St. Kitts, Nevis;;St. Lucia;;St. Pierre, Miquelon;;St. Vincent, Grenadines;;Sudan;;Suriname;;Svalbard, Jan Mayen;;Swaziland;;Sweden;;Switzerland;;Syrian Arab Republic;;Taiwan;;Tajikistan;;Tanzania;;Thailand;;Timor-leste;;Togo;;Tokelau;;Tonga;;Trinidad, Tobago;;Tunisia;;Turkey;;Turkmenistan;;Turks, Caicoss;;Tuvalu;;Uganda;;Ukraine;;United Arab Emirates;;United Kingdom;;United States;;Uruguay;;Uzbekistan;;Vanuatu;;Vatican City;;Venezuela;;Viet Nam;;Virgin Is. British;;Virgin Is. U.S.;;Wallis, Futuna;;Western Sahara;;Yemen;;Yugoslavia;;Zambia;;Zimbabwe]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>9</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Phone]]></caption><description><![CDATA[]]></description><name>phone</name><dataType>15</dataType><length>100</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>4</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[11]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Email]]></caption><description><![CDATA[]]></description><name>email</name><dataType>15</dataType><length>80</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>50</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>3</linkBehavior><linkDisplay>1</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Website]]></caption><description><![CDATA[]]></description><name>website</name><dataType>15</dataType><length>200</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>50</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>5</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>2</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Comments]]></caption><description><![CDATA[]]></description><name>comments</name><dataType>18</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>6</index><textarea>False</textarea><htmlarea>True</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Unpaid sales]]></caption><description><![CDATA[Automatically calculated field by summing this client's unpaid invoices' total.]]></description><name>unpaid_sales</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>True</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>10</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT IFNULL(SUM(`invoices`.`total`), 0.00) FROM `clients` 
LEFT JOIN `invoices` ON `invoices`.`client`=`clients`.`id` 
WHERE `clients`.`id`='21' AND `invoices`.`status`='Unpaid']]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Paid sales]]></caption><description><![CDATA[Automatically calculated field by summing this client's paid invoices' total.]]></description><name>paid_sales</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>True</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>10</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT IFNULL(SUM(`invoices`.`total`), 0.00) FROM `clients` 
LEFT JOIN `invoices` ON `invoices`.`client`=`clients`.`id` 
WHERE `clients`.`id`='%ID%' AND `invoices`.`status`='Paid']]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Total sales]]></caption><description><![CDATA[Automatically calculated field by summing this client's non-cancelled invoices' total.]]></description><name>total_sales</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>True</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>10</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT IFNULL(SUM(`invoices`.`total`), 0.00) FROM `clients` 
LEFT JOIN `invoices` ON `invoices`.`client`=`clients`.`id` 
WHERE `clients`.`id`='%ID%' AND `invoices`.`status`!='Cancelled']]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field></table><table><plugins><spm><spm_fields>1:3:9001:</spm_fields></spm></plugins><name>item_prices</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>False</allowMassDelete><homepageShowCount>False</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>False</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>True</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Prices History]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Item price details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[item_prices_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks></lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>4</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[]]></parentChildrenSettings><tableIcon>card_money.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>False</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><autofocusField></autofocusField><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Item]]></caption><description><![CDATA[]]></description><name>item</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>item_description</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>items</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>True</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Price]]></caption><description><![CDATA[]]></description><name>price</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[0.00]]></default><columnWidth>80</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Date]]></caption><description><![CDATA[]]></description><name>date</name><dataType>9</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[1]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field></table><table><plugins><spm><spm_fields>1:2:6:9001:</spm_fields></spm><summary_reports><report_details>[{"report_hash":"nn6yylp9a5r60qatx9m9","title":"Item sales","table":"invoice_items","table_index":3,"label":"item","caption1":"Item","caption2":"Sum of Invoice items","group_function":"sum","group_function_field":"price","group_array":[],"look_up_table":"items","look_up_value":"item_description","label_field_index":"3","report_header_url":"","report_footer_url":"","data_table_section":1,"barchart_section":1,"piechart_section":1,"override_permissions":0,"custom_where":"","date_separator":"\/"}]</report_details></summary_reports></plugins><name>invoice_items</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>True</allowMassDelete><homepageShowCount>False</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>True</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Invoice items]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Invoice item details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[invoice_items_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks></lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>True</hideLinkHomepage><hideLinkNavMenu>True</hideLinkNavMenu><defaultSortField>1</defaultSortField><defaultSortDirection>asc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[]]></parentChildrenSettings><tableIcon>barcode.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>False</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><autofocusField></autofocusField><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Invoice]]></caption><description><![CDATA[]]></description><name>invoice</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>code</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>invoices</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `invoices`.`id`, `invoices`.`code` FROM `invoices` LEFT JOIN `clients` as clients1 ON `clients1`.`id`=`invoices`.`client` ORDER BY 2]]></customDVSQL><inheritPermissions>True</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Item]]></caption><description><![CDATA[]]></description><name>item</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>350</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>item_description</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>items</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `items`.`id`, `items`.`item_description` FROM `items` ORDER BY 2]]></customDVSQL><inheritPermissions>True</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>2</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Current price]]></caption><description><![CDATA[This is the current catalog price of the selected item.]]></description><name>current_price</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>80</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>unit_price</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>items</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Catalog price at order date]]></caption><description><![CDATA[]]></description><name>catalog_price</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>80</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT `item_prices`.`price` FROM `invoice_items` 
LEFT JOIN `items` ON `items`.`id`=`invoice_items`.`item`
LEFT JOIN `invoices` ON `invoices`.`id`=`invoice_items`.`invoice` 
LEFT JOIN `item_prices` ON `invoice_items`.`item`=`item_prices`.`item` 
WHERE `invoice_items`.`id` = '%ID%' AND `item_prices`.`date` <= `invoices`.`date_due`
ORDER BY `item_prices`.`date` DESC LIMIT 1]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Unit price]]></caption><description><![CDATA[You can either use the catalog price or change to a different price.]]></description><name>unit_price</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>True</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>80</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>4</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>1</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[9]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Qty]]></caption><description><![CDATA[]]></description><name>qty</name><dataType>8</dataType><length>9</length><precision>3</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[1]]></default><columnWidth>60</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>3</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>1</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[10]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Price]]></caption><description><![CDATA[Will be automatically calculated from unit price and quantity, excluding taxes.]]></description><name>price</name><dataType>8</dataType><length>9</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>True</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>80</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>5</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>1</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT ROUND(`invoice_items`.`unit_price` * `invoice_items`.`qty`, 2) FROM `invoice_items` 
WHERE `invoice_items`.`id`='%ID%']]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field></table><table><plugins><spm><spm_fields>2:1:9001:</spm_fields></spm></plugins><name>items</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>True</allowMassDelete><homepageShowCount>True</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>False</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Items]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Item details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[items_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>item_prices;invoice_items;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>2</defaultSortField><defaultSortDirection>asc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[invoice_items&col;1&col;1&col;Invoice items&col;1&col;&row;item_prices&col;1&col;1&col;Price history&col;1&col;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;]]></parentChildrenSettings><tableIcon>installer_box.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>True</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><autofocusField>-1</autofocusField><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Item Description]]></caption><description><![CDATA[]]></description><name>item_description</name><dataType>18</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Unit price]]></caption><description><![CDATA[This is the most recent unit price as obtained from "Item prices" table.]]></description><name>unit_price</name><dataType>8</dataType><length>10</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>80</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT IFNULL(`price`, 0.00) FROM `item_prices` 
WHERE `item` = '%ID%' AND `date` <= NOW()
ORDER BY `date` DESC LIMIT 1]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field></table></database>