GET api/departments?subDepartments={subDepartments}&minorDepartments={minorDepartments}&lesserDepartments={lesserDepartments}&showExternal={showExternal}
Lists all departments
Request Information
URI Parameters
Name | Description | Type | Additional information |
---|---|---|---|
subDepartments |
List sub departments of departments |
boolean |
Default value is True |
minorDepartments |
List minor departments of sub departments |
boolean |
Default value is True |
lesserDepartments |
List lesser departments of minor departments |
boolean |
Default value is True |
showExternal |
when null, lists all departments when true, Lists all eCommerce departments when false, Lists all departments except eCommerce departments |
boolean |
None. |
Body Parameters
None.
Response Information
Resource Description
Collection of DepartmentName | Description | Type | Additional information |
---|---|---|---|
ID | integer |
None. |
|
Name | string |
Required String length: inclusive between 0 and 60 |
|
Code | string |
Required String length: inclusive between 0 and 20 |
|
SortOrder | integer |
None. |
|
IsLiquor | boolean |
Deprecated. Use only IsTobacco field. |
|
IsTobacco | boolean |
None. |
|
ExcludeTalker | boolean |
None. |
|
ExternalSales | boolean |
None. |
|
SaleGLCode | string |
String length: inclusive between 0 and 50 |
|
COGSGLCode | string |
String length: inclusive between 0 and 50 |
|
AccountingCategoryID | integer |
None. |
|
MaximumMarkdownPercentage |
Maximum markdown amount for products with in this department, i.e. This percent each time |
decimal number |
None. |
AccountingOnly |
Excludes department from reporting |
boolean |
None. |
GenerateExternalID | integer |
None. |
|
UseNonReportableTaxCode |
When set to true, the MyOB accounting integration will use the non reportable tax code when exporting sales for this department. |
boolean |
None. |
MinPLU | integer |
None. |
|
MaxPLU | integer |
None. |
|
ScaleLocation |
Default Location for new Scale PLUs in this Department, can be overridden at Product level |
ScaleLocation |
Relation. This field may not always be loaded or used for updates. |
SubDepartments | Collection of SubDepartment |
Relation. This field may not always be loaded or used for updates. |
|
Stores | Collection of integer |
Relation. This field may not always be loaded or used for updates. |
|
InvestmentBuyOverride |
Store size configuration has been overridden for this department |
boolean |
Relation. This field may not always be loaded or used for updates. |
Updated | date |
None. |
|
SalesMode | SalesMode |
None. |
|
GSTPercent | integer |
None. |
|
CostGSTPercent | integer |
None. |
|
EarnLoyaltyPoints | boolean |
None. |
|
QuantityOverride | boolean |
None. |
|
QuantityRequired | boolean |
None. |
|
AllowDiscounts | boolean |
None. |
|
DiscountDiscounts | boolean |
None. |
|
ItemRecalled | boolean |
None. |
|
NoRefund | boolean |
None. |
|
Active | boolean |
None. |
|
AllowMarkdown | boolean |
None. |
|
DefaultGP | decimal number |
None. |
|
LabelShelfDefault | integer |
None. |
|
LabelTalkerDefault | integer |
None. |
|
LabelSmall | boolean |
None. |
|
Tags | string |
None. |
|
UnitMeasureKind | integer |
None. |
|
FuelItem | boolean |
None. |
|
TrackSerial | boolean |
None. |
|
WarrantyPeriod | integer |
None. |
|
CostCalcMethod | CostCalcMethod |
None. |
|
ProviderName | string |
None. |
|
OverrideHostMargin | boolean |
None. |
|
KeepDescription |
when false, changes to HostDescription should flow to receipt Name. (OverrideHostDescription) |
boolean |
None. |
MSCCommodity | string |
None. |
|
AllowAutoOrder | boolean |
None. |
|
ExcludeFromWebUpdate | boolean |
None. |
|
WebPriceBasedOn | boolean |
None. |
|
LabelFormat | string |
None. |
|
SendToScale | boolean |
None. |
|
LabelPageLayoutG_UID | Collection of byte |
None. |
|
LabelPageLayoutGuid | globally unique identifier |
None. |
|
MinimumAge |
Only a default on the Department table |
integer |
Relation. This field may not always be loaded or used for updates. |
CountryOfOrigin | string |
Relation. This field may not always be loaded or used for updates. |
|
ServiceFeeID |
Only a default on the Department table |
integer |
None. |
EftCode |
Only a default on the Department and SubDepartment table |
integer |
None. |
DefaultPrinter |
Only a default on the Department and SubDepartment table |
string |
String length: inclusive between 0 and 60 |
DefaultPrinterGroup |
Only a default on the Department and SubDepartment table |
string |
String length: inclusive between 0 and 60 |
BuyingLimit |
Buying Limit for Department. Below are possible values NULL=Dept/SubDept Limit will be used 0=Unlimited - Regardless of Dept/SubDept limits +ve integer |
integer |
None. |
BuyingLimitIndependent |
This indicates if buying limit is independent from other limits like Product/PriceGroup. If yes, limit does not count towards other limits like Product/PriceGroup limit. For example, if toilet paper has BuyingLimit=1 and Grocery Dept has BuyingLimit=2 - if true, transaction may have 1xTP and 2xGrocery - if false, 1xTP and 1xGrocery |
boolean |
None. |
BuyingLimitType |
It indicates whether limit applies to category or item |
BuyingLimitType |
None. |
IncludeInDistinctLimit |
It indicates whether this limit includes in distinct store level limit |
boolean |
None. |
DefaultsEmpty | boolean |
None. |
|
MSCCat | MSCCategory |
Relation. This field may not always be loaded or used for updates. |
|
MSCCom | MSCCommodity |
Relation. This field may not always be loaded or used for updates. |
|
MSCDep | MSCDepartment |
Relation. This field may not always be loaded or used for updates. |
|
MSCSubCom | MSCSubCommodity |
Relation. This field may not always be loaded or used for updates. |
Response Formats
application/json, text/json
[ { "$id": "1", "id": 1, "name": "sample string 2", "code": "sample string 3", "sortOrder": 4, "isLiquor": true, "isTobacco": true, "excludeTalker": true, "externalSales": true, "saleGLCode": "sample string 9", "cogsglCode": "sample string 10", "accountingCategoryID": 11, "maximumMarkdownPercentage": 12.0, "accountingOnly": true, "generateExternalID": 1, "useNonReportableTaxCode": true, "minPLU": 15, "maxPLU": 16, "scaleLocation": { "$id": "2", "id": 1, "deptNo": 1, "deptCode": "sample string 2", "name": "sample string 3", "enabled": true, "updated": "2025-06-14T07:47:41.1984282", "department": { "$ref": "1" } }, "subDepartments": [ { "$id": "3", "id": 1, "departmentID": 2, "name": "sample string 3", "code": "sample string 4", "departmentCode": "sample string 5", "externalSales": true, "minorDepartments": [ { "$id": "4", "id": 1, "subDepartmentID": 2, "departmentID": 3, "name": "sample string 4", "subDepartmentCode": "sample string 5", "departmentCode": "sample string 6", "code": "sample string 7", "lesserDepartments": [ { "$id": "5", "id": 1, "departmentID": 2, "subDepartmentID": 3, "minorDepartmentID": 4, "name": "sample string 5", "code": "sample string 6", "departmentCode": "sample string 7", "subDepartmentCode": "sample string 8", "minorDepartmentCode": "sample string 9", "updated": "2025-06-14T07:47:41.1984282", "salesMode": 1, "gstPercent": 1, "costGSTPercent": 1, "earnLoyaltyPoints": true, "quantityOverride": true, "quantityRequired": true, "allowDiscounts": true, "discountDiscounts": true, "itemRecalled": true, "noRefund": true, "active": true, "allowMarkdown": true, "defaultGP": 1.1, "labelShelfDefault": 1, "labelTalkerDefault": 1, "labelSmall": true, "tags": "sample string 11", "unitMeasureKind": 1, "fuelItem": true, "trackSerial": true, "warrantyPeriod": 1, "costCalcMethod": 1, "providerName": "sample string 12", "overrideHostMargin": true, "keepDescription": true, "mscCommodity": "sample string 15", "allowAutoOrder": true, "excludeFromWebUpdate": true, "webPriceBasedOn": true, "labelFormat": "sample string 16", "sendToScale": true, "labelPageLayoutG_UID": "32dbvn4iykmOBuOhBdzB6g==", "labelPageLayoutGuid": "be5b67df-227e-49ca-8e06-e3a105dcc1ea", "minimumAge": 17, "countryOfOrigin": "sample string 18", "serviceFeeID": 1, "eftCode": 19, "defaultPrinter": "sample string 20", "defaultPrinterGroup": "sample string 21", "buyingLimit": 1, "buyingLimitIndependent": true, "buyingLimitType": 0, "includeInDistinctLimit": true, "defaultsEmpty": false, "mscCat": { "$id": "6", "dept": 1, "category": 2, "name": "sample string 3", "active": true, "mscCommodities": [ { "$id": "7", "dept": 1, "category": 2, "commodity": 3, "name": "sample string 4", "active": true, "mscSubCommodities": [ { "$id": "8", "dept": 1, "category": 2, "commodity": 3, "subCommodity": 4, "name": "sample string 5", "active": true, "subCommodityCode": "sample string 7" }, { "$ref": "8" } ], "commodityCode": "sample string 6" }, { "$ref": "7" } ], "categoryCode": "sample string 5" }, "mscCom": { "$ref": "7" }, "mscDep": { "$id": "9", "dept": 1, "name": "sample string 2", "active": true, "mscCategories": [ { "$ref": "6" }, { "$ref": "6" } ], "deptCode": "sample string 4" }, "mscSubCom": { "$ref": "8" } }, { "$ref": "5" } ], "updated": "2025-06-14T07:47:41.1984282", "salesMode": 1, "gstPercent": 1, "costGSTPercent": 1, "earnLoyaltyPoints": true, "quantityOverride": true, "quantityRequired": true, "allowDiscounts": true, "discountDiscounts": true, "itemRecalled": true, "noRefund": true, "active": true, "allowMarkdown": true, "defaultGP": 1.1, "labelShelfDefault": 1, "labelTalkerDefault": 1, "labelSmall": true, "tags": "sample string 9", "unitMeasureKind": 1, "fuelItem": true, "trackSerial": true, "warrantyPeriod": 1, "costCalcMethod": 1, "providerName": "sample string 10", "overrideHostMargin": true, "keepDescription": true, "mscCommodity": "sample string 13", "allowAutoOrder": true, "excludeFromWebUpdate": true, "webPriceBasedOn": true, "labelFormat": "sample string 14", "sendToScale": true, "labelPageLayoutG_UID": "foKv65Nmc0Km9YW4LYVaqw==", "labelPageLayoutGuid": "ebaf827e-6693-4273-a6f5-85b82d855aab", "minimumAge": 15, "countryOfOrigin": "sample string 16", "serviceFeeID": 1, "eftCode": 17, "defaultPrinter": "sample string 18", "defaultPrinterGroup": "sample string 19", "buyingLimit": 1, "buyingLimitIndependent": true, "buyingLimitType": 0, "includeInDistinctLimit": true, "defaultsEmpty": false, "mscCat": { "$ref": "6" }, "mscCom": { "$ref": "7" }, "mscDep": { "$ref": "9" }, "mscSubCom": { "$ref": "8" } }, { "$ref": "4" } ], "investmentBuyOverride": true, "updated": "2025-06-14T07:47:41.1984282", "salesMode": 1, "gstPercent": 1, "costGSTPercent": 1, "earnLoyaltyPoints": true, "quantityOverride": true, "quantityRequired": true, "allowDiscounts": true, "discountDiscounts": true, "itemRecalled": true, "noRefund": true, "active": true, "allowMarkdown": true, "defaultGP": 1.1, "labelShelfDefault": 1, "labelTalkerDefault": 1, "labelSmall": true, "tags": "sample string 9", "unitMeasureKind": 1, "fuelItem": true, "trackSerial": true, "warrantyPeriod": 1, "costCalcMethod": 1, "providerName": "sample string 10", "overrideHostMargin": true, "keepDescription": true, "mscCommodity": "sample string 13", "allowAutoOrder": true, "excludeFromWebUpdate": true, "webPriceBasedOn": true, "labelFormat": "sample string 14", "sendToScale": true, "labelPageLayoutG_UID": "s4qeEgpKf02XtzWriaBnyQ==", "labelPageLayoutGuid": "129e8ab3-4a0a-4d7f-97b7-35ab89a067c9", "minimumAge": 15, "countryOfOrigin": "sample string 16", "serviceFeeID": 1, "eftCode": 17, "defaultPrinter": "sample string 18", "defaultPrinterGroup": "sample string 19", "buyingLimit": 1, "buyingLimitIndependent": true, "buyingLimitType": 0, "includeInDistinctLimit": true, "defaultsEmpty": false, "mscCat": { "$ref": "6" }, "mscCom": { "$ref": "7" }, "mscDep": { "$ref": "9" }, "mscSubCom": { "$ref": "8" } }, { "$ref": "3" } ], "stores": [ 1, 2 ], "investmentBuyOverride": true, "updated": "2025-06-14T07:47:41.1984282", "salesMode": 1, "gstPercent": 1, "costGSTPercent": 1, "earnLoyaltyPoints": true, "quantityOverride": true, "quantityRequired": true, "allowDiscounts": true, "discountDiscounts": true, "itemRecalled": true, "noRefund": true, "active": true, "allowMarkdown": true, "defaultGP": 1.1, "labelShelfDefault": 1, "labelTalkerDefault": 1, "labelSmall": true, "tags": "sample string 19", "unitMeasureKind": 1, "fuelItem": true, "trackSerial": true, "warrantyPeriod": 1, "costCalcMethod": 1, "providerName": "sample string 20", "overrideHostMargin": true, "keepDescription": true, "mscCommodity": "sample string 23", "allowAutoOrder": true, "excludeFromWebUpdate": true, "webPriceBasedOn": true, "labelFormat": "sample string 24", "sendToScale": true, "labelPageLayoutG_UID": "D+WIAnR5K0imFGnfL6yAKg==", "labelPageLayoutGuid": "0288e50f-7974-482b-a614-69df2fac802a", "minimumAge": 25, "countryOfOrigin": "sample string 26", "serviceFeeID": 1, "eftCode": 27, "defaultPrinter": "sample string 28", "defaultPrinterGroup": "sample string 29", "buyingLimit": 1, "buyingLimitIndependent": true, "buyingLimitType": 0, "includeInDistinctLimit": true, "defaultsEmpty": false, "mscCat": { "$ref": "6" }, "mscCom": { "$ref": "7" }, "mscDep": { "$ref": "9" }, "mscSubCom": { "$ref": "8" } }, { "$ref": "1" } ]
application/xml
Sample not available.
text/xml
Sample not available.
text/csv
Sample not available.
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
PK �=�Z&�8�� 5 xl/workbook.xml � (� ����0D�&�C���V�N\�z��bhK��|�o�vfgߎ�kֶ�;�sWPB�3�k����h�]c��0J�b�iT����M`i�������K�{:��a��!<�D��Q���vC����>��X�N&as���D��QZA J�s}tO���8�x Y��%K�c�p��W�`���PK �=�Z���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d� �d�k��<�H���V���= ��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ �1Z�$�8z�R��3 tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b ��%#H'�2}���e�B)��~j/F�t��PK �=�Z�7��' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="Rf6e9a5439ee240aa" /></Relationships>PK �=�Z (�_� �/ xl/worksheets/sheet1.xml � (� �ZmS9�+.����k �Z!����Lp������X���<+A�*��5+��G���_�{|��.�����PVb8�>��ogO���?Vw���{��ſ���t5@����bx�Z}7-o�e5�>}±���q��o�F����p~��q��)!�h1}���Q������ZI����tr�Y���K����ix�w;����ӻ�a-ߍ/`8�mЗ����y���?����oNn��b�u�G���/�ӻɏ������t��~�,�͜���r���q��n8x�����<�]��C%�� �7?���㗗�q��<���vZH��N�χ�|x�|��������y�PJ[�?�l�W��n���<� >Qkl�u��|�wB� �Í�O��龙�� ���2���፴K�"� ��Z��B�T�)���UF<?-�u� Q{�� �sRhc��RgX�Q}ڻp^Y�3Zg*D�ɖ }�K��Yp�BF�2*P6T�� � A��]D-J�J˨B�^;3 P6 4�oR"}lv�Q��Ѡ�GV� ��%� j��G��£�3�UK� ],�Ԝ�Bی�ծ�����|���-0��T- �J|��>��eZ��T�u� [�-��xYE��6A���IWY��t!wQ���m�-�9��1�#�JT��)�9�jl��RT� �.�:����A�׀�@%X���^Q� �B `�W�y�DF��} �`��L��U��D�N�@�e�u��!JL�2����@ h����}%z�$h�|^H�靼� S�% J|��n}�<A�sLF)Bx㵪�u"E�n��E4&dv��u;Z) ���aL�B��V���<��FD�BԢN.怭�jmE�bֻ`�ۍ�{m0]X���uԤ6o=��I��d��R���Q�ڥk0�!8���!jR���"jR'�tҭ��Esx���Q��Ѥ� �d�@�:Ã��4��j��݀�?(�L��I��ȃ��4�n�Zc�Q�,d[���4�&�Ĵ�BH\E�me���h���{�έ!j�$}��,&oM�BԤI�l#��.� :���4I�\�6�HI�6Q�&��Q���/.6j�&/.��xՖT�Z����7㍏��f�`�m�EL�#�<b��2W!j���*�ʾ��(E�\��]�/ɒ7�{���e�/^2��ui�m#E�*o<nb}�5S!JѶ�cD%�V�N{[&��(E�l@�L�ϴh%�I���O� �1v�&G/?�����p���-�σ�f�?��q��1�j���<{���[ĸ��)�.B���.R��]�NG]�I�]�M��"N��">t!E�2�R?2����z�@��!���f?3B�!���@�1��ߌ��������v�a���v�2�n͘PzkƆ��[sF$a�f��⚱#�kƐ@H�Ka�fL �暱%P�c�q&P�k��&P�sj�3�NMyf�)ό?5�1��<3ՔgƢ���xTS��j�3�RMyflj(όO �y����njO �y����njO �y�����ܵIx3>5��1�SCx3>�4M0>��gƧ�����R��Z�3�SKyf|j)όO-��<3>� �#p�������t6V����o�T9l?�p�;3��Qr����CN��Bvt��I�������_�Y�a}�O?O�Ӡ�҈�'��d ��_����..=������+��Z����U��u���� � Ù�b8wQ�a��fu�����N�O~+J>��_�� ~,x8�N�{H�����羇\� r^�Ʌ3]A����.�����U� ���w�V�Θ���&��z��gc�y�戣��'�i,`����{�����i���<]l�7>c�М����<��/�<���н3_h֜d*h2� ]h�b 4S��@33�f�<�8y���0���T �4S%�4S�x�sX���ϓ�4S%�4S1�i�b 4S1���L�ԟ�z�������_a]`8su2U� S`���gu�����' ��L�C}�7�����:���!N��0��r�7�y��� VP�����f��:W���n���3��f*��T��f*�B'S�]��I�N�b�w2��d��%������ �1u:���t2U��T����T��o陸���h>_M��M������ PK �=�Z����� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�q�ƭ�vÆm�,{�DMl�v���G� XE�Tb�������4����ݿ�y�Gg;(�rz�}�d�w�N2�8�>��bcCJ~CiT�2Σ���,SNCO�T'�#匭hX2�I���!:cF��N�g��0}u���(C����R��P� �Iwph��iւUm�L��M-�˄���;_�0-*f֕P�V�Uf��s ��K�ey��2m���Ԣ�W5z��/PK �=�ZЃc'2 E xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&� AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK �=�Zw[�U� xl/sharedStrings.xml � (� �W]o�6}��@؞�M�.N�:�kԎ��A�b�%�!"�.I����]R�C��qW��{H�O��{N�Ĕ�R�j�z�F��d�ŪW���ukD*b�H�z� �5���\kC`�нڃ1뷍��XJu]�� d)UJ |�UC���~`̤I��l�4R�E�D2�W;;��L��o �_�����y�\�7�Wn��)���2F��Tf�b���P�8��~��,fd�dJ��G(�&��t�;�KC�oϜ&�PF�MȌ&��8���O�0r��A���T\�1}�i���z��71e*b���+���H6Ux�S��{���V�;��b�E���9����>f�:��*#Q[|f�+��ʤ���� Wy(��v�g� ��8��u�ơi�R�*ٶ?�Y���_S%H"741��<��f ,�D�]��+�e��o$���9�*��+���p:� ���J����n#ß�t�`�b ��_�[�,1d���d��ԁ�,IB,!_ �����g)d��(�9]!۽����L1��q�78�P%t���#�1���f�"@��R�� �+�%:ۍN�&3�q�'`�r�?�~��+���G��WLG��C�j<��e c�q]/3#�dZ�� ��'��oʚ-�myO5�'���6�ƽ�{L�s�!�k �6���������k2�J �d��\brt���˸$�E�^?Y�ah��`�r���jV`2P2[W�a�x�/� E��)���^Y5߬Q�C�Z:��4D&�U_�k<3v�p7�)X��V���r �q�@�(�j�_���%�P��[�^�[�W�+�������o�?H� iz_v(໒�E��AȱE��}Zc m��R�V`9i�: ��o����k��q�x%a���_Ч�&��f�� �X�P�rʋo��rAA\x��) ����ȟ���8Bq��� ᭦]RJ6q��^�dW�w�[i��UQY�=j�ۛ!��ME�y�R��Y�8����'x<CP�x���qm�Q���yQ��b�)l��f�˛�S7^ڥn�"�Bw��� ���?���0+`� ��o�S.��N�T���˩n0���]��eqҤ�� �g<��r��h+A�����Jd�����É4��< ��b-�F.5��Y����Z �0�ۄ5��"/����>�x[�������-�we��x��t�� �꾊� x��P����a���ց��e�v���4�G�g���N��8�'����Y�l/i�m�i��z.W��,��d�K ���*D�р�(��}�Mh)P�]��I�ҍ�'J�ae�ծ"* )Y�LM�M!]��Y.)�~���C�ZY�$��]0�!���_���yw�#r?���yTA��>_���T@�U�c����~�c��A���Ca��h{�("$P�w� ��~>�U�{���Óx� � ���fg ��� �'Н�c�������/�?�=�U� ���PK- �=�Z&�8�� 5 xl/workbook.xmlPK- �=�Z���� � [Content_Types].xmlPK- �=�Z�7��' ' V _rels/.relsPK- �=�Z (�_� �/ � xl/worksheets/sheet1.xmlPK- �=�Z����� P � xl/_rels/workbook.xml.relsPK- �=�ZЃc'2 E xl/styles.xmlPK- �=�Zw[�U� � xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
PK �=�Z�Ҋ� 5 xl/workbook.xml � (� ����0��&�C��h�R8q�����H����[J ��mgv����/a�|�hB�k*ctc���!�C�v��b����0�[۽5��NEqaG�ʚ �t��� �#�A"F=.( ��f�#��� ��e2ֺ�I�b�)�a�EVĀƚ�������)�J��_�kY !� z��7g���PK �=�Z���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d� �d�k��<�H���V���= ��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ �1Z�$�8z�R��3 tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b ��%#H'�2}���e�B)��~j/F�t��PK �=�Zl�%�' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R63d2f20ef45240d7" /></Relationships>PK �=�Z (�_� �/ xl/worksheets/sheet1.xml � (� �ZmS9�+.����k �Z!����Lp������X���<+A�*��5+��G���_�{|��.�����PVb8�>��ogO���?Vw���{��ſ���t5@����bx�Z}7-o�e5�>}±���q��o�F����p~��q��)!�h1}���Q������ZI����tr�Y���K����ix�w;����ӻ�a-ߍ/`8�mЗ����y���?����oNn��b�u�G���/�ӻɏ������t��~�,�͜���r���q��n8x�����<�]��C%�� �7?���㗗�q��<���vZH��N�χ�|x�|��������y�PJ[�?�l�W��n���<� >Qkl�u��|�wB� �Í�O��龙�� ���2���፴K�"� ��Z��B�T�)���UF<?-�u� Q{�� �sRhc��RgX�Q}ڻp^Y�3Zg*D�ɖ }�K��Yp�BF�2*P6T�� � A��]D-J�J˨B�^;3 P6 4�oR"}lv�Q��Ѡ�GV� ��%� j��G��£�3�UK� ],�Ԝ�Bی�ծ�����|���-0��T- �J|��>��eZ��T�u� [�-��xYE��6A���IWY��t!wQ���m�-�9��1�#�JT��)�9�jl��RT� �.�:����A�׀�@%X���^Q� �B `�W�y�DF��} �`��L��U��D�N�@�e�u��!JL�2����@ h����}%z�$h�|^H�靼� S�% J|��n}�<A�sLF)Bx㵪�u"E�n��E4&dv��u;Z) ���aL�B��V���<��FD�BԢN.怭�jmE�bֻ`�ۍ�{m0]X���uԤ6o=��I��d��R���Q�ڥk0�!8���!jR���"jR'�tҭ��Esx���Q��Ѥ� �d�@�:Ã��4��j��݀�?(�L��I��ȃ��4�n�Zc�Q�,d[���4�&�Ĵ�BH\E�me���h���{�έ!j�$}��,&oM�BԤI�l#��.� :���4I�\�6�HI�6Q�&��Q���/.6j�&/.��xՖT�Z����7㍏��f�`�m�EL�#�<b��2W!j���*�ʾ��(E�\��]�/ɒ7�{���e�/^2��ui�m#E�*o<nb}�5S!JѶ�cD%�V�N{[&��(E�l@�L�ϴh%�I���O� �1v�&G/?�����p���-�σ�f�?��q��1�j���<{���[ĸ��)�.B���.R��]�NG]�I�]�M��"N��">t!E�2�R?2����z�@��!���f?3B�!���@�1��ߌ��������v�a���v�2�n͘PzkƆ��[sF$a�f��⚱#�kƐ@H�Ka�fL �暱%P�c�q&P�k��&P�sj�3�NMyf�)ό?5�1��<3ՔgƢ���xTS��j�3�RMyflj(όO �y����njO �y����njO �y�����ܵIx3>5��1�SCx3>�4M0>��gƧ�����R��Z�3�SKyf|j)όO-��<3>� �#p�������t6V����o�T9l?�p�;3��Qr����CN��Bvt��I�������_�Y�a}�O?O�Ӡ�҈�'��d ��_����..=������+��Z����U��u���� � Ù�b8wQ�a��fu�����N�O~+J>��_�� ~,x8�N�{H�����羇\� r^�Ʌ3]A����.�����U� ���w�V�Θ���&��z��gc�y�戣��'�i,`����{�����i���<]l�7>c�М����<��/�<���н3_h֜d*h2� ]h�b 4S��@33�f�<�8y���0���T �4S%�4S�x�sX���ϓ�4S%�4S1�i�b 4S1���L�ԟ�z�������_a]`8su2U� S`���gu�����' ��L�C}�7�����:���!N��0��r�7�y��� VP�����f��:W���n���3��f*��T��f*�B'S�]��I�N�b�w2��d��%������ �1u:���t2U��T����T��o陸���h>_M��M������ PK �=�Z[>� P xl/_rels/workbook.xml.rels � (� ��;n1@�bM���C� MZ���ُص-ېp�9R��H�"�HC5��ӓf>�?�۷idg�a�FB� `d�m�I8�����f��c���K+&H�ct+�iYG&uZ�'�)�w���/�x�~[&;\��h�vд��4��������E`�E ?���!��s#a��@X/�J� U��M-��H���;���D�Һ���e}W�=5/ѧKϝ��ZUc�/"i�DQ^���_l� PK �=�ZЃc'2 E xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&� AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK �=�Zw[�U� xl/sharedStrings.xml � (� �W]o�6}��@؞�M�.N�:�kԎ��A�b�%�!"�.I����]R�C��qW��{H�O��{N�Ĕ�R�j�z�F��d�ŪW���ukD*b�H�z� �5���\kC`�нڃ1뷍��XJu]�� d)UJ |�UC���~`̤I��l�4R�E�D2�W;;��L��o �_�����y�\�7�Wn��)���2F��Tf�b���P�8��~��,fd�dJ��G(�&��t�;�KC�oϜ&�PF�MȌ&��8���O�0r��A���T\�1}�i���z��71e*b���+���H6Ux�S��{���V�;��b�E���9����>f�:��*#Q[|f�+��ʤ���� Wy(��v�g� ��8��u�ơi�R�*ٶ?�Y���_S%H"741��<��f ,�D�]��+�e��o$���9�*��+���p:� ���J����n#ß�t�`�b ��_�[�,1d���d��ԁ�,IB,!_ �����g)d��(�9]!۽����L1��q�78�P%t���#�1���f�"@��R�� �+�%:ۍN�&3�q�'`�r�?�~��+���G��WLG��C�j<��e c�q]/3#�dZ�� ��'��oʚ-�myO5�'���6�ƽ�{L�s�!�k �6���������k2�J �d��\brt���˸$�E�^?Y�ah��`�r���jV`2P2[W�a�x�/� E��)���^Y5߬Q�C�Z:��4D&�U_�k<3v�p7�)X��V���r �q�@�(�j�_���%�P��[�^�[�W�+�������o�?H� iz_v(໒�E��AȱE��}Zc m��R�V`9i�: ��o����k��q�x%a���_Ч�&��f�� �X�P�rʋo��rAA\x��) ����ȟ���8Bq��� ᭦]RJ6q��^�dW�w�[i��UQY�=j�ۛ!��ME�y�R��Y�8����'x<CP�x���qm�Q���yQ��b�)l��f�˛�S7^ڥn�"�Bw��� ���?���0+`� ��o�S.��N�T���˩n0���]��eqҤ�� �g<��r��h+A�����Jd�����É4��< ��b-�F.5��Y����Z �0�ۄ5��"/����>�x[�������-�we��x��t�� �꾊� x��P����a���ց��e�v���4�G�g���N��8�'����Y�l/i�m�i��z.W��,��d�K ���*D�р�(��}�Mh)P�]��I�ҍ�'J�ae�ծ"* )Y�LM�M!]��Y.)�~���C�ZY�$��]0�!���_���yw�#r?���yTA��>_���T@�U�c����~�c��A���Ca��h{�("$P�w� ��~>�U�{���Óx� � ���fg ��� �'Н�c�������/�?�=�U� ���PK- �=�Z�Ҋ� 5 xl/workbook.xmlPK- �=�Z���� � � [Content_Types].xmlPK- �=�Zl�%�' ' T _rels/.relsPK- �=�Z (�_� �/ � xl/worksheets/sheet1.xmlPK- �=�Z[>� P � xl/_rels/workbook.xml.relsPK- �=�ZЃc'2 E xl/styles.xmlPK- �=�Zw[�U� � xl/sharedStrings.xmlPK � �