inventory.axp

<database><databaseName>OIM</databaseName><databaseUser></databaseUser><databasePassword></databasePassword><databaseServer>localhost</databaseServer><charEncoding>UTF-8</charEncoding><noMySQLEncoding>False</noMySQLEncoding><timeFormat>12</timeFormat><rtl>False</rtl><timeZone>America/New_York</timeZone><hideNavMenu>False</hideNavMenu><hideLogin>False</hideLogin><adminServerStatus>True</adminServerStatus><sortTablesAlphabetically>False</sortTablesAlphabetically><styleSheetFile></styleSheetFile><themeFile>cosmo.css</themeFile><theme3D>False</theme3D><themeCompact>True</themeCompact><scrollStyle>0</scrollStyle><dateFormat>3</dateFormat><dateSeparator>4</dateSeparator><version>22.12</version><lastGenDate>2022-03-03 17:34:33</lastGenDate><outputFolder>C:\xampp\htdocs\open-source-apps\oim\app</outputFolder><autoCompleteSize>0</autoCompleteSize><homePageTheme></homePageTheme><filesToKeep><![CDATA[|]]></filesToKeep><filesToOverwrite><![CDATA[|thumbnail.php|link.php|checkMemberID.php|parent-children.php|ajax_combo.php|admin\pageAssignOwners.php|admin\pageChangeMemberStatus.php|admin\pageDeleteGroup.php|admin\pageDeleteMember.php|admin\pageDeleteRecord.php|admin\pageEditMember.php|admin\pageEditMemberPermissions.php|admin\pageEditOwnership.php|admin\pageHome.php|admin\pageLogin.php|admin\pageMail.php|admin\pagePrintRecord.php|admin\pageSender.php|admin\pageSettings.php|admin\pageTransferOwnership.php|admin\pageViewGroups.php|admin\pageViewMembers.php|admin\incCommon.php|admin\index.php|admin\pageUploadCSV.php|admin\pageRebuildThumbnails.php|admin\pageRebuildFields.php|admin\getUsers.php|datalist.php|combo.class.php|date_combo.class.php|data_combo.class.php|defaultFilters.php|db.php|ci_input.php|Product_view.php|Product_dml.php|Product_autofill.php|category_view.php|category_dml.php|category_autofill.php|batches_view.php|batches_dml.php|batches_autofill.php|suppliers_view.php|suppliers_dml.php|suppliers_autofill.php|transactions_view.php|transactions_dml.php|transactions_autofill.php|header.php|footer.php|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\Product_templateTV.html|templates\Product_templateTVS.html|templates\Product_templateDV.html|templates\Product_templateDVP.html|templates\children-Product.php|templates\category_templateTV.html|templates\category_templateTVS.html|templates\category_templateDV.html|templates\category_templateDVP.html|templates\children-category.php|templates\batches_templateTV.html|templates\batches_templateTVS.html|templates\batches_templateDV.html|templates\batches_templateDVP.html|templates\children-batches.php|templates\suppliers_templateTV.html|templates\suppliers_templateTVS.html|templates\suppliers_templateDV.html|templates\suppliers_templateDVP.html|templates\children-suppliers.php|templates\transactions_templateTV.html|templates\transactions_templateTVS.html|templates\transactions_templateDV.html|templates\transactions_templateDVP.html|templates\children-transactions.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|incCommon.php|admin\pageEditGroup.php|admin\pageViewRecords.php|admin\incFunctions.php|lib.php|setup.php|settings-manager.php|updateDB.php|sections_view.php|sections_dml.php|sections_autofill.php|categories_view.php|categories_dml.php|categories_autofill.php|index.html|templates\sections_templateTV.html|templates\sections_templateTVS.html|templates\sections_templateDV.html|templates\sections_templateDVP.html|templates\children-sections.php|templates\categories_templateTV.html|templates\categories_templateTVS.html|templates\categories_templateDV.html|templates\categories_templateDVP.html|templates\children-categories.php|items_view.php|items_dml.php|items_autofill.php|templates\items_templateTV.html|templates\items_templateTVS.html|templates\items_templateDV.html|templates\items_templateDVP.html|templates\children-items.php|ajax_check_unique.php|ajax_check_login.php|ajax_admin_tools.php|admin\ajax-maintenance-mode.php|templates\transactions-ajax-cache.php|templates\batches-ajax-cache.php|templates\sections-ajax-cache.php|templates\categories-ajax-cache.php|templates\suppliers-ajax-cache.php|templates\items-ajax-cache.php|language-admin.php|templates\children-transactions-printable.php|templates\children-batches-printable.php|templates\children-sections-printable.php|templates\children-categories-printable.php|templates\children-suppliers-printable.php|templates\children-items-printable.php|hooks\README.html|admin\pageBackupRestore.php|ajax-update-calculated-fields.php|cli-update-calculated-fields.php|import-csv.php|admin\pageServerStatus.php|admin\app-documentation.php|handshake.svg|shortcuts.js|common.js|dynamic.css|admin\pageQueryLogs.php|]]></filesToOverwrite><homepageFirstTableDoubleWidth>False</homepageFirstTableDoubleWidth><homepagePanelHeight>40</homepagePanelHeight><homepageTablesPerRow>2</homepageTablesPerRow><groups><![CDATA[Operations,Setup]]></groups><showTechnicalDocumentationAdminArea>False</showTechnicalDocumentationAdminArea><technicalDocumentationApp><![CDATA[]]></technicalDocumentationApp><adminInteractiveSQL>True</adminInteractiveSQL><multipleSuperAdmins>False</multipleSuperAdmins><plugins><calendar><data>{"events":{"expired-batch":{"type":"expired-batch","color":"danger","textColor":"default","table":"batches","customWhere":"","title":"Expired {2}&lt;br&gt;batch# {4}","allDay":true,"startDateField":"expiry_date","startTimeField":"","endDateField":"","endTimeField":""},"incoming-transaction":{"type":"incoming-transaction","color":"info","textColor":"default","table":"transactions","customWhere":"`transactions`.`transaction_type`='Incoming'","title":"Incoming {3}&lt;br&gt;batch# {4} [{5}]","allDay":true,"startDateField":"transaction_date","startTimeField":"","endDateField":"","endTimeField":""}},"calendars":{"incoming-expired":{"id":"incoming-expired","title":"Incoming and expiring calendar","initial-view":"dayGridMonth","initial-date":"[today]","events":["expired-batch","incoming-transaction"],"locale":"","groups":["Admins"],"links-home":"1","links-navmenu":"1"}}}</data></calendar><calendar_dup><data>dummy</data></calendar_dup></plugins><table><plugins><spm><spm_fields>1:2:3:4:5:6:9001:</spm_fields></spm><summary_reports><report_details>[{"report_hash":"t5n1ge4zqdrj43lzjibf","title":"Outgoing items over time","table":"transactions","table_index":0,"label":"item","caption1":"Item","caption2":"Sum of Transactions","group_function":"sum","group_function_field":"quantity","group_array":[],"look_up_table":"items","look_up_value":"item","label_field_index":"3","date_field":"transaction_date","date_field_index":"2","report_header_url":"","report_footer_url":"","data_table_section":1,"barchart_section":1,"piechart_section":0,"override_permissions":0,"custom_where":"`transactions`.`transaction_type`='Outgoing'","date_separator":"\/"},{"report_hash":"bldr3hxloardfdh4b3a9","title":"Damaged items","table":"transactions","table_index":0,"label":"item","caption1":"Item","caption2":"Sum of Transactions","group_function":"sum","group_function_field":"quantity","group_array":[],"look_up_table":"items","look_up_value":"item","label_field_index":"3","date_field":"transaction_date","date_field_index":"2","report_header_url":"","report_footer_url":"","data_table_section":1,"barchart_section":1,"piechart_section":0,"override_permissions":0,"custom_where":"`transactions`.`transaction_type`='Damaged'","date_separator":"\/"},{"report_hash":"66wmh8iwzs1tddb9sro8","title":"Incoming items over time","table":"transactions","table_index":0,"label":"item","caption1":"Item","caption2":"Sum of Transactions","group_function":"sum","group_function_field":"quantity","group_array":[],"look_up_table":"items","look_up_value":"item","label_field_index":"3","date_field":"transaction_date","date_field_index":"2","report_header_url":"","report_footer_url":"","data_table_section":1,"barchart_section":1,"piechart_section":0,"override_permissions":0,"custom_where":"`transactions`.`transaction_type`='Incoming'","date_separator":"\/"}]</report_details></summary_reports></plugins><name>transactions</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[Transactions]]></caption><description><![CDATA[Displays all incoming and outgoing transactions made for each item.]]></description><detailViewLabel><![CDATA[Transaction details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>25</recordsPerPage><redirectAfterInsert><![CDATA[transactions_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks></lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>1</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[]]></parentChildrenSettings><tableIcon>book_keeping.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>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[Transaction date]]></caption><description><![CDATA[]]></description><name>transaction_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><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</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>items</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>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[Batch]]></caption><description><![CDATA[If this transaction belongs to a new batch, you should <a href="batches_view.php?addNew_x=1" target="_blank">create a new batch entry</a> first.]]></description><name>batch</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>batch_no</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>batches</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>item</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[Storage section]]></caption><description><![CDATA[]]></description><name>section</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>section</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>sections</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[Transaction type]]></caption><description><![CDATA[]]></description><name>transaction_type</name><dataType>15</dataType><length>40</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[]]></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[Incoming;;Outgoing;;Expired;;Damaged]]></CSValueList><CSValueListType>2</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[Quantity]]></caption><description><![CDATA[The quantity you provide here would update the balancce of the related batch and item automatically (according to the transaction type).]]></description><name>quantity</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[1.00]]></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>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>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></table><table><plugins><spm><spm_fields>1:2:4:5:6:9001:</spm_fields></spm></plugins><name>batches</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[Batches]]></caption><description><![CDATA[This table lists all available batches of all items, its supplier, batch number, manufacturing and expiry date and balance.]]></description><detailViewLabel><![CDATA[Batch details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[batches_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>transactions;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>1</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[transactions&col;1&col;1&col;Transactions&col;&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>box_closed.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>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</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>items</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>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[Supplier]]></caption><description><![CDATA[]]></description><name>supplier</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>supplier</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>suppliers</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>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[Batch code]]></caption><description><![CDATA[]]></description><name>batch_no</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>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[Manufacturing date]]></caption><description><![CDATA[]]></description><name>manufacturing_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><field><caption><![CDATA[Expiry date]]></caption><description><![CDATA[]]></description><name>expiry_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><field><caption><![CDATA[Balance]]></caption><description><![CDATA[This figure is updated automatically when transactions are made that involve items from this batch.]]></description><name>balance</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[0.00]]></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>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>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></table><table><plugins><spm><spm_fields>1:3:4:5:9001:</spm_fields></spm></plugins><name>suppliers</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[Suppliers]]></caption><description><![CDATA[This table lists the data of the suppliers of all items that enter the warehouse.]]></description><detailViewLabel><![CDATA[Supplier details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[suppliers_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>batches;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>1</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[batches&col;1&col;1&col;Supplied batches&col;&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>1</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>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[Supplier]]></caption><description><![CDATA[]]></description><name>supplier</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>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[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>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>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[Phone]]></caption><description><![CDATA[]]></description><name>phone</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>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[Contact person]]></caption><description><![CDATA[]]></description><name>contact_person</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>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[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;;Norway;;Oman;;Pakistan;;Palau;;Palestinian Terr.;;Panama;;Papua New Guinea;;Paraguay;;Peru;;Philippines;;Pitcairn;;Poland;;Portugal;;Puerto Rico;;Qatar;;Reunion;;Romania;;Russian Federation;;Rwanda;;Samoa;;San Marino;;Sao Tome, Principe;;Saudi Arabia;;Senegal;;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>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></table><table><plugins><spm><spm_fields>1:9001:</spm_fields></spm></plugins><name>categories</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[Categories]]></caption><description><![CDATA[To classify the category of each item.]]></description><detailViewLabel><![CDATA[Category details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[categories_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>items;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>1</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[items&col;1&col;1&col;Products&col;&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>bricks.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>1</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>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[Category]]></caption><description><![CDATA[]]></description><name>category</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[]]></CSValueList><CSValueListType>2</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></table><table><plugins><spm><spm_fields>1:2:4:3: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>True</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Items]]></caption><description><![CDATA[Listing of all items entering the warehouse, its code, balance and category.]]></description><detailViewLabel><![CDATA[Items details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[items_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>transactions;batches;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>1</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[batches&col;1&col;1&col;Batches&col;&col;&row;transactions&col;1&col;1&col;Transactions&col;&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>injection.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>1</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>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>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>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[Code]]></caption><description><![CDATA[]]></description><name>code</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>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[Balance]]></caption><description><![CDATA[This figure is updated automatically when transactions are made that involve this item.]]></description><name>balance</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>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>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>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[Category]]></caption><description><![CDATA[]]></description><name>category</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>category</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>categories</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>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></table><table><plugins><spm><spm_fields>1:9001:</spm_fields></spm></plugins><name>sections</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[Storage sections]]></caption><description><![CDATA[Lists all available storage locations.]]></description><detailViewLabel><![CDATA[Pin location details]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>10</recordsPerPage><redirectAfterInsert><![CDATA[sections_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>transactions;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>1</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[transactions&col;1&col;1&col;Transactions&col;&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>color_swatch.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>1</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>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[Section]]></caption><description><![CDATA[]]></description><name>section</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>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></table></database>