Standard ACE DBnb` Ugr@?~1y0̝cßFNW`7ߜ(-`{6$߱oC43y[C.|*|gVDf_Љ$g'DeFx -bT4.0),>I 8"@(4 YՖ:z@S  Y  :z Y Y  Y Y  Y  Y  Y   Y :z Y  Y @ Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortType :z@1:@YYIdParentIdName        OY/S  Y Y Y  Y 2ACMFInheritableObjectIdSID YObjectId YYS  Y  Y }Y Y  Y  Y %Y  Y ,AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order,jf,j ,fjY"ObjectIdAttribute   -YS  Y Y Y  Y  Y V Y  Y  Y (ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationshipM' MDede ( (YYYszObject$szReferencedObjectszRelationship J{6 g " S   Q @mdfmQbLYUUQkmdiOQik*OYbqQbmdivdbdiOQiaPMokmd`Qi^YkmMokmd`QidiOQikkoLSdi`Q`f^dvQQOQmJY^kQ`f^dvQQ^YkmQ`f^dvQQdiOQikkoLSdi` Wd`Q!YbqQbmdiv^Ykm"YbqQbmdivmdiQdiOQikoLSdi`SdiWd`Q#^dUYbOYJ^dU$diOQiOQmJY^k%diOQi^Ykm&diOQikoLSdi`SdidiOQiOQmJY^k'fidOoMmMJmQUdivkJ^QkLv`dbmW(fidOoMmOQmJY^k)fidOoMmkJ^QkLvMJmQUdivMWJim)fidOoMmkJ^QkLvmdmJ^iQqQboQMWJim)fidOoMmkJ^QkhmvLvQ`f^dvQQMWJim)fidOoMmmiJbkJMmYdbkkoLSdi`SdifidOoMmOQmJY^k)foiMWJkQdiOQiOQmJY^k)foiMWJkQdiOQi^Ykm)foiMWJkQkkoLSdi`SdifoiMWJkQdiOQiOQmJY^k)iQMQYqYbUkoLSdi`SdifoiMWJkQdiOQiOQmJY^k)kJ^QkJbJ^vkYkSdi`)kJ^QkJbJ^vkYkkoLSdi`SdiWd`QMWJim) kJ^QkiQfdimkOYJ^dU) kWYffQiOQmJY^k) kWYffQi^Ykm) kmJimofkMiQQb) koff^YQiOQmJY^k)koff^YQi^Ykm)koff^YQifidOoMmkkoLSdi`)koff^YQifoiMWJkQkkoLSdi`)Mokmd`QidiOQik)Od`JYbSobMmYdbsiJffQik)QiidiWJbO^YbU)YbqQbmdiv)fiYqY^QUQk)foiMWJkQdiOQik)iQMdiOkQmsiJffQi)omY^YmYQk)Mokmd`QiJOOiQkkLdd\)Mokmd`QifWdbQLdd\)Q`f^dvQQJOOiQkkLdd\)Q`f^dvQQfWdbQLdd\)YbqdYMQ)`dbmW^vkJ^QkiQfdim)fidOoMmMJmQUdivkJ^QkLv`dbmW) fidOoMmkJ^QkLvMJmQUdiv)!fidOoMmkJ^QkLvmdmJ^iQqQboQ)"fidOoMmkJ^QkhoJbmYmvLvQ`f^dvQQ)#hoJimQi^vkJ^QkiQfdim)$koff^YQiJOOiQkkLdd\*koff^YQifWdbQLdd\*mdfmQbLYUUQkmdiOQik*vQJi^vkJ^QkiQfdim*JomdQuQM*OQ^QmQJ^^OJmJ*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MdiOQiOQmJY^k+kh+MMokmd`QiYO*+kh+MdiOQiOQmJY^k+kh+MQ`f^dvQQYO*+kh+MdiOQiOQmJY^k+kh+MkWYffQiYO*+kh+MdiOQikoLSdi`SdidiOQiOQmJY^k+kh+MfidOoMmYO* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+MJffidqQOLv* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+MMiQJmQOLv* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+MkoL`YmmQOLv* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+Mkoff^YQiYO* +kh+MfoiMWJkQkkoLSdi`SdifoiMWJkQdiOQiOQmJY^k+kh+MfidOoMmYO*+kh+MkJ^QkiQfdimkOYJ^dU+kh+M^kmkJ^QkiQfdimk*+kh+SYbqQbmdiv^Ykm*+kh+SdiOQiOQmJY^k*+kh+SdiOQikoLSdi`SdidiOQiOQmJY^k*+kh+SfoiMWJkQdiOQiOQmJY^k*+kh+SiQMQYqYbUkoLSdi`SdifoiMWJkQdiOQiOQmJY^k*+kh+i`dbmW^vkJ^QkiQfdim*+kh+ihoJimQi^vkJ^QkiQfdim*+kh+ivQJi^vkJ^QkiQfdim*Mokmd`Qik*Mokmd`QikQumQbOQO*Q`f^dvQQfiYqY^QUQk*Q`f^dvQQk*Q`f^dvQQkQumQbOQO*`kvkJMQk`kvkMd`f^QuMd^o`bk`kvkMd`f^QumvfQ+JmmJMW`Qbm`kvkMd`f^QumvfQ+OQMY`J^`kvkMd`f^QumvfQ+UoYO`kvkMd`f^QumvfQ+YQQQOdoL^Q `kvkMd`f^QumvfQ+YQQQkYbU^Q `kvkMd`f^QumvfQ+^dbU `kvkMd`f^QumvfQ+kWdim `kvkMd`f^QumvfQ+mQum`kvkMd`f^QumvfQ+obkYUbQOLvmQ `kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfk`kvkOLko``JivYbSdokQiOQSYbQO @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @      !"#$%&'())))))))) )!) ") #) $) %) &)')()))*)+),)-).)/)0)1)2)3)4)5)6)7)8) 9)!:)";)#<)$=*>*?*@*A*B*F* K*M*N*O*P*Q*R*S*T*U*V*WaXaYaZa[a\a ]a^a_a`aaabacada ea!fa"ga#hijklm n opqrstuvwxyz{;|;};~;;;;;;; * *!*%*&*(  !;     !#%'.*:*@*M*T*Y*_adaianaua ya a a kamaqavaaaaaaaaa$   v `@*@& J%    $%&'( ) * + , - . / 0 1 2 3 4 5 6 789:;<=>?@ABCDEFGHIJKLMNOP        ! !!!""#"$"%#&#'#($)$*$+%,%-%.&/&0&1'2'3'4(5(6(7)8)9):*;*<*=+>+?+@,A,B,C-D-E-F.G.H.I/J//00011122 2 3 3 3 444555666777888999: :!:";#;$;%<&<'<(=)=*=+>,>->.?/?0?1@2@3@4A5A6A7B8B9B:C;C<C=D>D?D@EAEBECFDFEFFGGGHGIHJHHIIIJJJKK K L L L MMMNNNOOOPPPQQQRRRS S!S"T#T$T%U)U*U+V2V3V4WJWWXXXYYYZZ Z [ [ [ \\\]]]^^^___```a)a*a+b,b-b.c/c0c1d2d3d4e5e6e7f8f9f:g;g<g=hAhBhCiDiEiF   !:;<456123./0+,-!(!)!*#%#&#'%7%8%9'"'#'$.&.'.(:,:-:.@/@0@1M5M6M7T8T9T:Y;Y<Y=_>_?_@dAdBdCiDiEiFnGnHnIuuuyyyk=k>k?m@mAmBqCqDqEvFvGvHI    !"#$%&'(>?@  !"#B @I( @ U-\s9g-n+D+D+D+ D+ D + D+E+ E+E+E+E +E+ F+F+F+F+F+F +F+G+G+G+G+G +G+H+H+!H+"H+#H +$H+ I+%I+'I+(I+)I +*I+&J++J+-J+.J+/J +0J+,K+1K+3K+4K+5K +6K +7K+2L+8L+:L+;L+M+@M+AM+?N+BN+DN+EN+FN+GN+HN+IN+JN+KN +LN+CO+MO+OO+PO+NP+QP-P-P-P-P-P-Q-Q-Q- Q-R- R- R- R- S-S-S-S-T-T-T-T-U-U-U-U-U-U-U-U-U -U - U -!U-V-"V-$V-%V-&V-'V-(V-)V-*V -+V -,V --V-#W-.W-0W-1W-2W-3W-4W-5W-6W-7W-8W-9W-:W-;W-W-?W-@W -AW -BW -CW -DW -EW-FW-GW-HWsWsWsWsW sW-/XsXsXsXs Xs Xs Xs Xs X sXsYsYsYsYsYsYsYsYsY sYsZsZsZsZsZsZsZs Zs!Z s"Zs[s#[s%[s&[s'[s([s)[s*[s+[ s,[s$\s-\s/\s0\s1\s2\s3\s4\s5\s6\s7\s8\s.sv1@887 @ @ @bQs+Mokmd`QidbdiOQik:bQs+Q`f^dvQQfiYqY^YUQkSdiQ`f^dvQQk:bQs+Q`f^dvQQfiYqY^YUQk^dd\of:bQs+Q`f^dvQQkdbdiOQik:bQs+Q`f^dvQQkdbfoiMWJkQdiOQi:bQs+YbqQbmdivmiJbkJMmYdbkdbfoiMWJkQdiOQik:bQs+diOQiOQmJY^k:bQs+diOQiYbqdYMQ:bQs+diOQikdbYbqQbmdivmiJbkJMmYdbk:bQs+diOQikmJmok: bQs+diOQikmJmok^dd\of: bQs+fidOoMmdbYbqQbmdivmiJbkJMmYdb: bQs+fidOoMmdbfoiMWJkQdiOQiOQmJY^k: bQs+fidOoMmkdbdiOQik: bQs+foMWJkQdiOQikdbYbqQbmdivmiJbkJMmYdbk:bQs+foiMWJkQdiOQiOQJmY^kdbfoiMWJkQdiOQi:bQs+foiMWJkQdiOQikmJmok^dd\of:bQs+kWYffQidbdiOQi:bQs+koff^YQikdbfoiMWJkQdiOQi:bQs+mJukmJmokdbdiOQik:bQs+miJbkJMmYdbmvfQkdbYbqQbmdivmiJbkJMmYdkb:S @ @ Q`f^dvQQfiYqY^QUQk:Q`f^dvQQfiYqY^QUQk:YbqQbmdivmiJbkJMmYdbk:YbqQbmdivmiJbkJMmYdbk: YbqQbmdivmiJbkJMmYdbk:YbqQbmdivmiJbkJMmYdbk:YbqdYMQk:diOQiOQmJY^k:diOQiOQmJY^k: diOQiOQmJY^k: diOQik:diOQik:diOQik: diOQik:diOQik:foiMWJkQdiOQiOQmJY^k:foiMWJkQdiOQiOQmJY^k: foiMWJkQdiOQiOQmJY^k:foiMWJkQdiOQik:foiMWJkQdiOQik:foiMWJkQdiOQik:  @  Mokmd`Qik:Q`f^dvQQk:Q`f^dvQQk:Q`f^dvQQk:YbqQbmdivmiJbkJMmYdbmvfQk:YbqQbmdivmiJbkJMmYdbk:diOQiOQmJY^kkmJmok: diOQik:diOQik:diOQik:diOQikkmJmok: diOQikmJukmJmok:fiYqY^QUQk:fidOoMmk: fidOoMmk: fidOoMmk: foiMWJkQdiOQikmJmok:foiMWJkQdiOQik:foiMWJkQdiOQik:kWYffQik:koff^YQik:*d _ Z  G q  0 =XlhED_[CB(Ac%:z@%:z@Product Details98MR2GUID$ ?-Lw"醙@@@@@@@> @DN$:z@DN$:z@Order Subform for Order Details9@lll```````^ @+:z@+:z@Order List98MR2GUID$ qXi)JSRYzzz66666664 @:z@:z@Order Details9 @HHH<<<<<<<: @ :z@ :z@Login Dialog9>@8FFF:::::::8 @@:z@@:z@Inventory List9@JJJ>>>>>>>< @:z@:z@Employee Orders Subform98MR2GUID$ g~0EH0DPPPPPPPN @ o":z@o":z@Employee Details98MR2GUID$ -:6=-bGg:lkBBBBBBB@ @ ,:z@,:z@Customer Orders Subform98MR2GUID$ xN,KPPPPPPPN @ .:z@.:z@Customer Details98MR2GUID$ bGDAÆBBBBBBB@ @~ :z@~ :z@Active Orders Subform for Home9@ Zjjj^^^^^^^\ @ @ :z@@ :z@UserDefined9@DDD88888886 @ @ :z@@ :z@SummaryInfo9@DDD88888886 @/8 :z@/8 :z@SysRel9.........., /8 :z@/8 :z@Scripts90000000000. 1 :z@1 :z@Reports90000000000. /8 :z@/8 :z@Modules90000000000. 1 :z@1 :z@Forms9,,,,,,,,,,* e> :z@e> :z@DataAccessPages9@@@@@@@@@@> '}:z@}:z@MSysComplexType_AttachmentTTTTTTTTTTT %}:z@~:z@MSysComplexType_TextHHHHHHHHHHH #}:z@~:z@MSysComplexType_DecimalNNNNNNNNNNN !Ֆ:z@}:z@MSysComplexType_GUIDHHHHHHHHHHH Ֆ:z@֖:z@MSysComplexType_IEEEDoubleTTTTTTTTTTT Ֆ:z@֖:z@MSysComplexType_IEEESingleTTTTTTTTTTT Ֆ:z@֖:z@MSysComplexType_LongHHHHHHHHHHH Ֆ:z@֖:z@MSysComplexType_ShortJJJJJJJJJJJ Ֆ:z@֖:z@MSysComplexType_UnsignedByteXXXXXXXXXXX Ֆ:z@Ֆ:z@MSysComplexColumnsDDDDDDDDDDD Ֆ:z@Ֆ:z@MSysRelationships;DDDDDDDDDDB Ֆ:z@Ֆ:z@MSysQueries;88888888886 Ֆ:z@Ֆ:z@MSysACEs;22222222220 Ֆ:z@Ֆ:z@MSysObjects;88888888886 Ֆ:z@,;z@MSysDb9\@ :::......., @Ֆ:z@Ֆ:z@Relationships;<<<<<<<<<<: Ֆ:z@Ֆ:z@Databases;44444444442 Ֆ:z@Ֆ:z@Tables;.........., D Y''N Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableID,,,,,,,,,YYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@     @  @.@  @MTY_dinfYT^NY  ValuedvfYT^NY  ValuedvfYT^NY  ValuedvfYT^NY  ValuedvfYT^N  Y  ValuedvfYT^N""Y  ValuedvfYT^N$$Y^ ValuedvfYT^N&& Y ^ ValuedvaY''N(( Y  Y  Y Y  Y @ Y FileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1b%?;Or M ? K J IJ FIH2noieDCEB@<_:z@_:z@Quarterly Sales ReportLLLLLLLLLLL ;p:z@p:z@Product Sa;p:z@p:z@Product Sales Quantity by Employee98MR2GUID$ <}'5IH&@:gfffffffd @:l:z@l:z@Product Sales by Total Revenue98MR2GUID$ &s[I&~}آ^^^^^^^\ @8:z@:z@Product Category Sales by Month98MR2GUID$ 84H~ZBp```````^ @7:z@:z@Monthly Sales Report96@VVVJJJJJJJH @5:z@:z@Employee Phone Book98MR2GUID$ #HIP^uHHHHHHHF @3%:z@%:z@Customer Phone Book98MR2GUID$ S7{MrcHHHHHHHF @2J :z@J :z@Customer Address Book98MR2GUID$ RȰFJyZLLLLLLLJ @1":z@":z@Utilities944444444442 0#:z@#:z@RecordsetWrapper9BBBBBBBBBB@ /1:z@1:z@PurchaseOrders9>>>>>>>>>>< .:z@:z@Privileges966666666664 -\x:z@\x:z@Inventory944444444442 ,!*:z@!*:z@ErrorHandling9<<<<<<<<<<: +WC:z@WC:z@DomainFunctionWrappers9NNNNNNNNNNL *.:z@.:z@CustomerOrders9>>>>>>>>>>< (:z@:z@Supplier Products Subform98MR2GUID$ b#!rRN1Am TTTTTTTR @&~:z@~:z@Supplier Details98MR2GUID$ 9MOwBBBBBBB@ @$:z@:z@Shipper List98MR2GUID$ rO nO)z~~~:::::::8 @"6:z@6:z@Sales Reports Dialog90@VVVJJJJJJJH @!M:z@M:z@Sales Analysis Subform for Home Chart9V@sxxxlllllllj @:z@:z@Receiving Subform for Purchase Order Details92@zzzzzzzx @ͮ,:z@ͮ,:z@Purchases Subform for Purchase Order Details9@@zzzzzzzx @D6.:z@D6.:z@Purchase Order List98MR2GUID$ ?Io9ÌHHHHHHHF @I:z@I:z@Product Transactions Subform for Product Details98MR2GUID$ 5mg;AL @.|:z@.|:z@Product Sales Qty by Employee Chart98MR2GUID$ KHqHC$~Ӭhhhhhhhf @4>:z@4>:z@Product Sales by Category Chart98MR2GUID$ evjsEV```````^ @)SOO/ ̓̓M̀ |L K ? ;J zvHGVf߂!!Aծ;z@T;z@~sq_cHome~sq_ccboCurrentEmployee94MR2KeepLocal Tbbbbbbb` ~;z@~;z@~sq_fSales Analysis Subform for Home Chart9Di 4MR2KeepLocal Tvvvvvvt `;z@=;z@~sq_fInventory to reorder Subform for Home9\k+ 4MR2KeepLocal Tvvvvvvt `Yg<$:z@y[$:z@Inventory on Order9; @rU@o|@ j^^RFFFFFFD `Z:z@@:z@Inventory Purchased9 @pe@o|@ l``THHHHHHF `AR;z@k;z@~sq_fActive Orders Subform for Home9c* 4MR2KeepLocal Tthhhhhhf `E;z@ L;z@~sq_cActive Orders Subform for Home~sq_cStatus ID9@Z4MR2KeepLocal T `Y:z@vi:z@ f_56F5485F75A1464EA836D1F62C88EEEC_Supplier IDs9@~ @Tc:z@:z@ f_4414D1A034CA4B6AB17EF530981DF532_Attachments9t@~~~~~~~| @Ml:z@k:z@ f_06145473A6CA4FC18D051ED55F61D8D6_Attachments9t@~~~~~~~| @ ;@K:z@$:z@Employees9P߲ @@@44444442 @:.l/:z@$:z@Employee Privileges9( @TTTHHHHHHHF @ .A:z@:z@Customers9P߲ @@@44444442 @Tv:z@v:z@~sq_rYearly Sales Report94MR2KeepLocal TRRRRRRRP @SZ:z@Z:z@~sq_rQuarterly Sales Report94MR2KeepLocal TXXXXXXXV @QZ:z@Z:z@~sq_fReceiving Subform for Purchase Order Details94MR2KeepLocal T @P:z@:z@~sq_fPurchase Order Details94MR2KeepLocal TXXXXXXXV @N:z@:z@~sq_fOrder Details94MR2KeepLocal TFFFFFFFD @K+-:z@J1-:z@~sq_cPurchases Subform for Purchase Order Details~sq_cProduct ID94MR2KeepLocal T @BG:z@G:z@Delete All Data9@@@@@@@@@@> Aж:z@ж:z@AutoExec922222222220 @A:z@A:z@Yearly Sales Report9@TTTHHHHHHHF @?ƹ:z@ƹ:z@Top Ten Biggest Orders98MR2GUID$ [ma\K?%NNNNNNNL @=b%:z@b%:z@Supplier Address Book98MR2GUID$ Ie*TJCۗLLLLLLLJ @~R΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅΅gI y [ [[[[[[=   S  t J d F ( f .  u5WwGPPP2eG)`2T*   G@ 'Order Subtotals/// Orders Employees### EmployeesOrdersB@ ;/# OrdersOrder Subtotals\@ G; Sale Amount[Order Subtotals].SubtotalO'' oOrders.[Order ID]0 gOrders.[Shipped Date]4 gEmployees.[First Name]5 gEmployees.[Last Name]4 gEmployees.[Country/Region]9 g  G^@  'Inventory###  Inventory.** g  G Ex G ExdOrders.[Order Date]4 / Ex ((Not (Orders.[Status ID])=3))= ' ExOrder Price Totals555  ExOrders  ExCustomers### ExCustomersOrdersB@ ;/# ExOrdersOrder Price Totals\@ MA ExOrders.[Status ID]1 gExCustomers.Company0 gExD@ gExOrders.Taxes+ gExOrders.[Order Date]2 gExOrders.[Customer ID]3 gExOrders.[Employee ID]3 gExOrders.[Order ID]0 g Ex Ex G ExOrders Status+++  Ex G Ex Ex GP GOOrder Details Extended=== O  GO O GN  GNCustomers ExtendedOrdersX@,MA5 NOrders StatusOrders\@,C7+ NJ@, gN[Orders Status].[Status Name]< gN Orders.*' gNOrders NOrders Status+++ NCustomers Extended555 N N GMInventory### M  GM M GK S GK S[Product Name]- 'KS[Product Name]- gKSId! gKSProducts!!! KS KS GF Inventory.[Product Name]7 'FInventory.[Qty Available]8 gFInventory.[Product Name]7 gFInventory.[Product ID]5 gFInventory### F F GLVALZ^ >  x(VHP((([Inventory Transactions].[Transaction Type])=3))Sum([Inventory Transactions].Quantity)[Inventory Transactions].[Product ID]Products.ID=[Products On Back Order].[Product ID]Products.ID=[Inventory On Order].[Product ID]Products.ID=[Inventory On Hold].[Product ID]Products.ID=[Inventory Purchased].[Product ID]Products.ID=[Inventory Sold].[Product ID]IIf([Qty Below Target Level]>0,IIf([Qty Below Target Level]<[Minimum ReOrder Quantity],[Minimum Reorder Quantity],[Qty Below Target Level]),0)[Qty Available]+[Qty On Order]-[Qty On Back Order][Qty Purchased]-[Qty Sold]-[Qty On Hold]IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))[Purchase Order Status].[Status ID]=[Purchase Orders].[Status ID][Customers Extended].ID=Orders.[Customer ID][Orders Status].[Status ID]=Orders.[Status ID][Customers Extended].[E-mail Address]YI^cE'  } _ %  s U 7 g 7 \ 2  ~ N  qG) e+eJ?BOOW2ProductsInventory SoldR@,I=! W2Qty To Reorder@,9-- oW2Current Leveld@ ,7++ oW2 Qty Below Target Level [Target Level]-[Current Level]i== oW2 Products.[Target Level]6 gW2 Products.[Reorder Level]7 gW2 Qty On Back Order Nz([Quantity On Back Order],0)_33 oW2 Qty On OrderNz([Quantity On Order],0)P)) oW2Qty AvailableP@ ,7++ oW2Qty On Hand[Qty Purchased]-[Qty Sold]O'' oW2Qty On HoldNz([Quantity On Hold],0)M'' oW2Qty SoldNz([Quantity Sold],0)D!! oW2Qty PurchasedNz([Quantity Purchased],0)S++ oW2Products.[Product Code]6 gW2Products.[Product Name]6 gW2Product ID Products.ID>%% oW2Products On Back Order=== W2Inventory On Order555 W2Inventory On Hold333 W2Inventory Purchased777 W2Inventory Sold--- W2Products!!! W2 W2 GW2 GW2 W2 GV  GV  @ , 'V "@ , 'V Employees.** gVEmployee Name @ ,7++ oVFile As"@,+ oV Employees### V  V GV GV  V GU  GU  @, 'U "@, 'U Customers.** gUContact Name @,5)) oUFile As"@,+ oUCustomers### U U GU GU U GT.Sales Analysis--- T . GT. T. GS.Sales Analysis--- S . GS. S. GRSales Analysis--- R  GR R GQPurchase Details ExtendedCCC Q  GQ Q GPPurchase Order StatusPurchase Orders@,eY; P [Purchase Order Status].Status= gP[Purchase Orders].*2 gPPurchase Orders/// PPurchase Order Status;;; P gY$xN //Ye Y d Y &/d Y ud Y Ad Y QDd Y 2 Y f2 Y 2 Y x2 Y  Y $d Y d Y  Y d Y  Y YIDCompanyLast NameFirst NameE-mail AddressJob TitleBusiness PhoneHome PhoneMobile PhoneFax NumberAddressCityState/ProvinceZIP/Postal CodeCountry/RegionWeb Page NotesAttachments/2  /3 /4 /5P /6ct Eee /7BMA//8CM@ $/9Y YYYYYYYY.rIXAttachments_506D6C6BA6584BD1B63604DEA6AC3C18CityCompanyFirst NameLast NamePostal CodePrimaryKeyState/Province ////// v1b N  : @ Y.+>9 D ] T  ro{Company PGoldschmidtDanielPurchasing Representative(123)555-0100(123)555-0101456 16th StreetSan FranciscoCA99999USAp>>2 o~Company OKupkovaHelenaPurchasing Manager(123)555-0100(123)555-0101456 15th StreetHonoluluHI99999USAtttZ66* o~Company NGriloCarlosPurchasing Representative(123)555-0100(123)555-0101456 14th StreetDenverCO99999USA~~~d22& o~ Company MLudickAndrePurchasing Representative(123)555-0100(123)555-0101456 13th StreetMemphisTN99999USA~~~d22( o~ Company LEdwardsJohnPurchasing Manager(123)555-0100(123)555-0101123 12th StreetLas VegasNV99999USApppV22* o~ Company KKrschnePeterPurchasing Manager(123)555-0100(123)555-0101123 11th StreetMiamiFL99999USArrrX44* o~ Company JWackerRolandPurchasing Manager(123)555-0100(123)555-0101123 10th StreetChicagoIL99999USArrrX44( o~ Company IMortensenSvenPurchasing Manager(123)555-0100(123)555-0101123 9th StreetSalt Lake CityUT99999USAtttZ66. o~Company HAndersenElizabethPurchasing Representative(123)555-0100(123)555-0101123 8th StreetPortlandOR99999USAp>>, o~Company GXieMing-YangOwner(123)555-0100(123)555-0101123 7th StreetBoiseID99999USArXXX>44" o~Company FPrez-OlaetaFranciscoPurchasing Manager(123)555-0100(123)555-0101123 6th StreetMilwaukeeWI99999USAjFF4 o~Company EO DonnellMartinOwner(123)555-0100(123)555-0101123 5th StreetMinneapolisMN99999USAx^^^D::. o~Company DLeeChristinaPurchasing Manager(123)555-0100(123)555-0101123 4th StreetNew YorkNY99999USArrrX44" o~Company CAxenThomasPurchasing Representative(123)555-0100(123)555-0101123 3rd StreetLos AngelasCA99999USA|||b00$ o~Company BGratacos SolsonaAntonioOwner(123)555-0100(123)555-0101123 2nd StreetBostonMA99999USAnnnTJJ< o~Company ABedecsAnnaOwner(123)555-0100(123)555-0101123 1st StreetSeattleWA99999USAnTTT:00( o~V.     $ 6F^lp~Company CCLeeSoo JungPurchasing Manager(123)555-0100(123)555-0101789 29th StreetDenverCO99999USArrrX44$ o~Company BBRaghavAmritanshPurchasing Manager(123)555-0100(123)555-0101789 28th StreetMemphisTN99999USAzzz`<<* o~Company AATohKarenPurchasing Manager(123)555-0100(123)555-0101789 27th StreetLas VegasNV99999USAlllR..$ o~Company ZLiuRunAccounting Assistant(123)555-0100(123)555-0101789 26th StreetMiamiFL99999USAjjjP((" o~Company YRodmanJohnPurchasing Manager(123)555-0100(123)555-0101789 25th StreetChicagoIL99999USAnnnT00( o~Company XHasselbergJonasOwner(123)555-0100(123)555-0101789 24th StreetSalt Lake CityUT99999USAx^^^D::0 o~Company WEntinMichaelPurchasing Manager(123)555-0100(123)555-0101789 23th StreetPortlandOR99999USArrrX44& o~Company VRamosLucianaPurchasing Assistant(123)555-0100(123)555-0101789 22th StreetMilwaukeeWI99999USAvvv\44& o~Company UThamBernardAccounting Manager(123)555-0100(123)555-0101789 21th StreetMinneapolisMN99999USApppV22$ o~Company TLiGeorgePurchasing Manager(123)555-0100(123)555-0101789 20th StreetNew YorkNY99999USAjjjP,,  o~Company SEggererAlexanderAccounting Assistant(123)555-0100(123)555-0101789 19th StreetLos AngelasCA99999USA~~~d<<* o~Company RAutier MiconiCatherinePurchasing Representative(123)555-0100(123)555-0101456 18th StreetBostonMA99999USAzHH6 o~Company QBagelJean PhilippeOwner(123)555-0100(123)555-0101456 17th StreetSeattleWA99999USA~dddJ@@& o~ . @ @ @ 00000000 0 0  0  0  0 0 001111111111 1 1 1 c .@  @   LdYkQ0Ldkmdb0Ldkmdb1MWYMJUd0 MWYMJUd1OQbqQi0 OQbqQi1 Wdbd^o^o0^JkqQUJk0 ^JkqQUJk1 ^dkJbUQ^Jk0^dkJbUQ^Jk1`Q`fWYk0 `Q`fWYk1 `YJ`Y0 `YJ`Y1 `Y^sJo\QQ0`Y^sJo\QQ1`YbbQJfd^Yk0`YbbQJfd^Yk1bQsvdi\0bQsvdi\1fdim^JbO0fdim^JbO1kJ^m^J\QMYmv0kJ^m^J\QMYmv1kJbSiJbMYkMd0kQJmm^Q0kQJmm^Q1M .Md`fJbvJ0Md`fJbvJJ1 Md`fJbvL0Md`fJbvLL1 Md`fJbvM0Md`fJbvMM1 Md`fJbvO0Md`fJbvQ0Md`fJbvS0Md`fJbvU0Md`fJbvW0Md`fJbvY0Md`fJbv[0 Md`fJbv\0 Md`fJbv^0 Md`fJbv`0 Md`fJbvb0 Md`fJbvd0Md`fJbvf0Md`fJbvh1Md`fJbvi1Md`fJbvk1Md`fJbvm1Md`fJbvo1Md`fJbvq1Md`fJbvs1Md`fJbvu1Md`fJbvv1Md`fJbvx1  .  @  J^QuJbOQi1J`iYmJbkW1 JbOiQ0 JbbJ0JbmdbYd0LQibJiO1MJi^dk0 MJmWQiYbQ1MWiYkmYbJ0OJbYQ^0Q^YxJLQmW0SiJbMYkMd0UQdiUQ1WQ^QbJ0[QJbfWY^YffQ1[dWb0 [dWb1[dbJk1\JiQb1 ^oMYJbJ1`JimYb0`YMWJQ^1`YbUvJbU0fQmQi0 id^JbO0 iob1 kdd[obU1 kqQb0mWd`Jk0 .@   @ @@JbOQikQb0JomYQi`YMdbY1JuQb0LJUQ^1LQOQMk0QOsJiOk0 QUUQiQi1QbmYb1Ud^OkMW`YOm0UiJmJMdkkd^kdbJ0UiY^d0 WJkkQ^LQiU1\ikMWbQ0 \of\dqJ0^QQ0^QQ1 ^Y1^Yo1 ^oOYM\0 `dimQbkQb0d+8OdbbQ^^0fQiQxd^JQmJ0iJUWJq1 iJ`dk1idO`Jb1mWJ`1mdW1 sJM\Qi0 uYQ0 .HHHHH0HHHHH0HHHHH0HHHHH0HHHHH0HHHHH0HHHHH0HHHHH0HHHHH0HHHHH0 HHHHH0 HHHHH0 HHHHH0 HHHHH0 HHHHH0HHHHH0HHHHH1HHHHH1HHHHH1HHHHH1HHHHH1HHHHH1HHHHH1HHHHH1HHHHH1HHHHH1 HHHHH1 HHHHH1 HHHHH1  . @ @ @ 00000000 0 0  0  0  0 0 001111111111 1 1 1  . @ @ @ MJ0MJ0MJ1Md0 Md1 S^0 S^1 WY0YO0Y^0 Y^1`J0`J1`b0`b1bq0 bq1 bv0bv1di0di1mb0 mb1 om0om1sJ0sJ1sY0sY1 -YN;;YYEmployee IDPrivilege ID !4,;=z,,z,z,;>z,z,z,;?z,YYY@YYY<EmployeePriviligesforEmployees0EmployeePriviligesLookupDNew_EmployeePriviligesforEmployees8New_EmployeePriviligesLookupPrimaryKeyPrivilege IDv1@ : :<:<:@<Y  Ֆ:z@N AA    Y Y d Y d Y d Y d Y d Y 2 Y 2 Y 2 Y  2 Y  Y  d Y  d Y   Y d Y  Y YIDCompanyLast NameFirst NameE-mail AddressJob TitleBusiness PhoneHome PhoneMobile PhoneFax NumberAddressCityState/ProvinceZIP/Postal CodeCountry/RegionWeb Page NotesAttachmentsrieh AEPo dSpot AFegpnF x AGaypPda AHseaSt AIus  AJAK ALY:Y Y YYYYYYYY.rI.rJ.rKXAttachments_5A2C0BB07DC4482AAD2902D0FB62905FCityCompanyFirst NameLast NamePostal CodePrimaryKeyState/Province AAAAAA v1b N  : @ @ | ; e Northwind TradersHellung-LarsenAnneanne@northwindtraders.comSales Representative(123)555-0100(123)555-0102(123)555-0103123 9th AvenueSeattleWA99999USAr@DFluent in French and German.lB60&"PH, Northwind TradersGiussaniLauralaura@northwindtraders.comSales Coordinator(123)555-0100(123)555-0102(123)555-0103123 8th AvenueRedmondWA99999USAr@DReads and writes French.Z4("zF<, Northwind TradersZareRobertrobert@northwindtraders.comSales Representative(123)555-0100(123)555-0102(123)555-0103123 7th AvenueSeattleWA99999USAr@D66*$v@4, Northwind TradersNeipperMichaelmichael@northwindtraders.comSales Representative(123)555-0100(123)555-0102(123)555-0103123 6th AvenueRedmondWA99999USAr@D@CL@4.$ H:, Northwind TradersThorpeStevensteven@northwindtraders.comSales Manager(123)555-0100(123)555-0102(123)555-0103123 5th AvenueSeattleWA99999USAr@D@C8,  zD8, Northwind TradersSergienkoMariyamariya@northwindtraders.comSales Representative(123)555-0100(123)555-0102(123)555-0103123 4th AvenueKirklandWA99999USAr@DBB60&"J>, Northwind TradersKotasJanjan@northwindtraders.comSales Representative(123)555-0100(123)555-0102(123)555-0103123 3rd AvenueRedmondWA99999USAr@D@C8,  l<6, Northwind TradersCenciniAndrewandrew@northwindtraders.comVice President, Sales(123)555-0100(123)555-0102(123)555-0103123 2nd AvenueBellevueWA99999USAr@D@CL@4.$ |F:, Northwind TradersFreehaferNancynancy@northwindtraders.comSales Representative(123)555-0100(123)555-0102(123)555-0103123 1st AvenueSeattleWA99999USA#http://northwindtraders.com#[[0* |H>,  LVAL * Fluent in Japanese and can read and write French, Portuguese, and Spanish.Joined the company as a sales representative and was promoted to sales manager. Fluent in French.Was hired as a sales associate and was promoted to sales representative.Joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales.R LVAL8 T p http://northwindtraders.com#http://northwindtraders.com/#http://northwindtraders.com#http://northwindtraders.com/#http://northwindtraders.com#http://northwindtraders.com/#http://northwindtraders.com#http://northwindtraders.com/#http://northwindtraders.com#http://northwindtraders.com/#http://northwindtraders.com#http://northwindtraders.com/#http://northwindtraders.com#http://northwindtraders.com/#http://northwindtraders.com#http://northwindtraders.com/# @ @BBBBBBBB B @@@LQ^^QqoQB\Yi\^JbOBiQO`dbOBiQO`dbOBiQO`dbOBkQJmm^QBkQJmm^QBkQJmm^QBkQJmm^QBH @bdimWsYbOmiJOQikBbdimWsYbOmiJOQikBbdimWsYbOmiJOQikBbdimWsYbOmiJOQikBbdimWsYbOmiJOQikBbdimWsYbOmiJOQikBbdimWsYbOmiJOQikBbdimWsYbOmiJOQikBbdimWsYbOmiJOQikB @ @ JbOiQsBJbbQB[JbB^JoiJB`JiYvJB`YMWJQ^BbJbMvBidLQimBkmQqQbB @@@ MQbMYbYBSiQQWJSQiBUYokkJbYBWQ^^obU^JikQb#B\dmJkBbQYffQiBkQiUYQb\dBmWdifQBxJiQB @HHHHHBHHHHHBHHHHHBHHHHHBHHHHHBHHHHHBHHHHHBHHHHHBHHHHHB @ @BBBBBBBB B @ @sJBsJBsJBsJBsJBsJBsJBsJBsJB SYNNNYY Y Y  Y Y  Y  Y  _Attachments*Customers_AttachmentsFileDataFileFlagsFileNameFileTimeStampFileTypeFileURLDNQanmFsNNR-msJ tNSsiYYY_Attachments$IdxFKPrimaryScalar$MSysComplexPKIndexNNNNs v1b  P @ @ @@ JMmYqQdiOQikkoLSdi`SdiWd`QMokmd`QiOQmJY^kMokmd`Qi^YkmMokmd`QidiOQikkoLSdi`Q`f^dvQQOQmJY^kQ`f^dvQQ^YkmQ`f^dvQQdiOQikkoLSdi` Wd`Q!YbqQbmdiv^Ykm"YbqQbmdivmdiQdiOQikoLSdi`SdiWd`Q#^dUYbOYJ^dU$diOQiOQmJY^k%diOQi^Ykm&diOQikoLSdi`SdidiOQiOQmJY^k'fidOoMmMJmQUdivkJ^QkLv`dbmW(fidOoMmOQmJY^k)fidOoMmkJ^QkLvMJmQUdivMWJim)fidOoMmkJ^QkLvmdmJ^iQqQboQMWJim)fidOoMmkJ^QkhmvLvQ`f^dvQQMWJim)fidOoMmmiJbkJMmYdbkkoLSdi`SdifidOoMmOQmJY^k)foiMWJkQdiOQiOQmJY^k)foiMWJkQdiOQi^Ykm)foiMWJkQkkoLSdi`SdifoiMWJkQdiOQiOQmJY^k)iQMQYqYbUkoLSdi`SdifoiMWJkQdiOQiOQmJY^k)kJ^QkJbJ^vkYkSdi`)kJ^QkJbJ^vkYkkoLSdi`SdiWd`QMWJim) kJ^QkiQfdimkOYJ^dU) kWYffQiOQmJY^k) kWYffQi^Ykm) kmJimofkMiQQb) koff^YQiOQmJY^k)koff^YQi^Ykm)koff^YQifidOoMmkkoLSdi`)koff^YQifoiMWJkQkkoLSdi`)Mokmd`QidiOQik)Od`JYbSobMmYdbsiJffQik)QiidiWJbO^YbU)YbqQbmdiv)fiYqY^QUQk)foiMWJkQdiOQik)iQMdiOkQmsiJffQi)omY^YmYQk)Mokmd`QiJOOiQkkLdd\)Mokmd`QifWdbQLdd\)Q`f^dvQQJOOiQkkLdd\)Q`f^dvQQfWdbQLdd\)YbqdYMQ)`dbmW^vkJ^QkiQfdim)fidOoMmMJmQUdivkJ^QkLv`dbmW) fidOoMmkJ^QkLvMJmQUdiv)!fidOoMmkJ^QkLvmdmJ^iQqQboQ)"fidOoMmkJ^QkhoJbmYmvLvQ`f^dvQQ)#hoJimQi^vkJ^QkiQfdim)$koff^YQiJOOiQkkLdd\*koff^YQifWdbQLdd\*mdfmQbLYUUQkmdiOQik*vQJi^vkJ^QkiQfdim*JomdQuQM*OQ^QmQJ^^OJmJ*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MdiOQiOQmJY^k+kh+MMokmd`QiYO*+kh+MdiOQiOQmJY^k+kh+MQ`f^dvQQYO*+kh+MdiOQiOQmJY^k+kh+MkWYffQiYO*+kh+MdiOQikoLSdi`SdidiOQiOQmJY^k+kh+MfidOoMmYO* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+MJffidqQOLv* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+MMiQJmQOLv* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+MkoL`YmmQOLv* +kh+MfoiMWJkQdiOQiOQmJY^k+kh+Mkoff^YQiYO* +kh+MfoiMWJkQkkoLSdi`SdifoiMWJkQdiOQiOQmJY^k+kh+MfidOoMmYO*+kh+MkJ^QkiQfdimkOYJ^dU+kh+M^kmkJ^QkiQfdimk*+kh+SYbqQbmdiv^Ykm*+kh+SdiOQiOQmJY^k*+kh+SdiOQikoLSdi`SdidiOQiOQmJY^k*+kh+SfoiMWJkQdiOQiOQmJY^k*+kh+SiQMQYqYbUkoLSdi`SdifoiMWJkQdiOQiOQmJY^k*+kh+i`dbmW^vkJ^QkiQfdim*+kh+ihoJimQi^vkJ^QkiQfdim*+kh+ivQJi^vkJ^QkiQfdim*Mokmd`Qik*Mokmd`QikQumQbOQO*Q`f^dvQQfiYqY^QUQk*Q`f^dvQQk*Q`f^dvQQkQumQbOQO*`kvkJMQk`kvkMd`f^QuMd^o`bk`kvkMd`f^QumvfQ+JmmJMW`Qbm`kvkMd`f^QumvfQ+OQMY`J^`kvkMd`f^QumvfQ+UoYO`kvkMd`f^QumvfQ+YQQQOdoL^Q `kvkMd`f^QumvfQ+YQQQkYbU^Q `kvkMd`f^QumvfQ+^dbU `kvkMd`f^QumvfQ+kWdim `kvkMd`f^QumvfQ+mQum`kvkMd`f^QumvfQ+obkYUbQOLvmQ `kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfk`kvkOLko``JivYbSdokQiOQSYbQOO@@ @ @@@ @  vQJi^vkJ^QkiQfdim*JomdQuQM*OQ^QmQJ^^OJmJ*OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MJMmYqQdiOQikkoLSdi`SdiWd`Q+kh+MkmJmokYO* +kh+MWd`Q+kh+MMLdMoiiQbmQ`f^dvQQ*(+kh+MWd`Q+kh+MkLSJMmYqQdiOQik!+kh+MWd`Q+kh+MkLSYbqQbmdivmdiQdiOQi +kh+MWd`Q+kh+MkLSkJ^QkfYqdm +kh+M^dUYbOYJ^dU+kh+MMLdMoiiQbmQ`f^dvQQ; +kh+MdiOQikoLSdi`SdidiOQiOQmJY^k+kh+MfidOoMmYO* +kh+MfoiMWJkQkkoLSdi`SdifoiMWJkQdiOQiOQmJY^k+kh+MfidOoMmYO*+kh+SJMmYqQdiOQikkoLSdi`SdiWd`Q*!+kh+SWd`Q;+kh+SYbqQbmdiv^Ykm*+kh+SYbqQbmdivmdiQdiOQikoLSdi`SdiWd`Q*%+kh+SdiOQiOQmJY^k*+kh+SdiOQikoLSdi`SdidiOQiOQmJY^k*+kh+SfoiMWJkQdiOQiOQmJY^k*+kh+SiQMQYqYbUkoLSdi`SdifoiMWJkQdiOQiOQmJY^k*+kh+SkJ^QkJbJ^vkYkkoLSdi`SdiWd`QMWJim*&+kh+i`dbmW^vkJ^QkiQfdim*+kh+ihoJimQi^vkJ^QkiQfdim*+kh+ivQJi^vkJ^QkiQfdim*Mokmd`Qik*Mokmd`QikQumQbOQO*Q`f^dvQQfiYqY^QUQk*Q`f^dvQQk*Q`f^dvQQkQumQbOQO*S+6B8>@>DSM8FO6@8QO@@SB8OFOB+JmmJMW`Qbmk*S+>>8>O8J6<>MJ>LBJL8DQS@<6HF8OS@<:+JmmJMW`Qbmk*S+@BS@>F@SD@J8>B>QJF6J8>:>:LL>6J6B>D:D<886B+qQikYdbWYkmdiv+S@SFH8FS6JJJL::<>LO:F>>@DJJ<:SB:JO@BH8>S>S+JmmJMW`QbmkaS+J:S6D86>:D<>>JMQJQJ@6>MLMSJLQ6HJ+JmmJMW`QbmkaYbqQbmdivaYbqQbmdivdbWd^OaYbqQbmdivdbdiOQiaYbqQbmdivdbWd^OaYbqQbmdivdbdiOQiaaYbqQbmdivdbdiOQiaYMQOJmJa YbqdYMQka `kvkJMMQkkkmdiJUQa `kvkJMQk`kvkMd`f^QuMd^o`bk`kvkMd`f^QumvfQ+JmmJMW`Qbm`kvkMd`f^QumvfQ+OQMY`J^`kvkMd`f^QumvfQ+UoYO`kvkMd`f^QumvfQ+YQQQOdoL^Q `kvkMd`f^QumvfQ+YQQQkYbU^Q `kvkMd`f^QumvfQ+^dbU `kvkMd`f^QumvfQ+kWdim `kvkMd`f^QumvfQ+mQum`kvkMd`f^QumvfQ+obkYUbQOLvmQ `kvkMd`f^QumvfQqW+DL@O@>BD:LFF>MFJ>>S6DB6LQa`kvkbJqfJbQUidofMJmQUdiYQka`kvkbJqfJbQUidofka`kvkbJqfJbQUidofmddL[QMmka`kvkbJqfJbQdL[QMmYOka`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkdiOQiOQmJY^kadiOQiOQmJY^kQumQbOQOadiOQiOQmJY^kkmJmokadiOQifiYMQmdmJ^kadiOQikoLmdmJ^kadiOQiko``JivadiOQikadiOQikkmJmokadiOQikmJukmJmokafiYqY^QUQkafidOoMmMJmQUdivkJ^QkLvOJmQafidOoMmdiOQikafidOoMmfoiMWJkQkafidOoMmkJ^QkLvMJmQUdiva fidOoMmkJ^QkhmvLvQ`f^dvQQJbOOJmQa!fidOoMmkJ^QkmdmJ^LvOJmQa"fidOoMmmiJbkJMmYdbka#fidOoMmka$fidOoMmkdbLJM\diOQifoiMWJkQOQmJY^kQumQbOQOfoiMWJkQdiOQiOQmJY^kfoiMWJkQdiOQikmJmokfoiMWJkQdiOQikfoiMWJkQfiYMQmdmJ^kfoiMWJkQko``JivkJ^QkJbJ^vkYkkJ^QkiQfdimkkWYffQik kWYffQikQumQbOQO kmiYbUk koff^YQik koff^YQikQumQbOQO `kvkOLko``JivYbSdokQiOQSYbQO M M M SYNUUYY Y Y  Y Y  Y  Y  _Attachments*Employees_AttachmentsFileDataFileFlagsFileNameFileTimeStampFileTypeFileURLDUVanmFsNUW-msJ tUXsiYYY_Attachments$IdxFKPrimaryScalar$MSysComplexPKIndexUUUUs v1b @ T T T \Y22NZZ2-2222YYY _Supplier IDs*Products_Supplier IDs Valuej,j,Z\,jj,j,Z],jj,j,Z^,jYYY_Supplier IDs$IdxFKPrimaryScalar$MSysComplexPKIndexv1@  Y2v_H1ybK4 | e N 7  h Q : # -2 ,1 +0 */ ). (- ', &+ %* $) #( "' !&  % $  # " !                                               ^ Y @ @ @ @ @ @[[[[[[[[[[  [  [  [  [  [ [[[[[[[[[[[[[[[[[[ [!["[# [$![%"[&#['$[(%[)&[*'[+([,)[-*[.+[/,[0-[1d Y@@@@@@@@@@@@@[ [ [ [[[[[[[  [  [  [  [  [ [[[[[ [[[[[[[[[[ [[[ [! ["[# [$![%"[&#['$[(%[)&[*'[+([,)[-*[.+[/,[0-[1^ Y @ @ @ @ @ @[[[[[[[[ [ [  [  [  [ [ [[[[[[[[[[[[[[[[[ [![ "[!#["$[#%[$&[%'[&([')[(*[)+[*,[+-[,.[-/[.0[/1[02[1 ?YN``YY Y Y@h_VersionHistory_F5F8918F-0A3F-4DA9-AE71-184EE5012880ZModified_F9B5E312-4155-4c59-9AAE-391C1B295827 NotestOrders_VersionHistory_F5F8918F-0A3F-4DA9-AE71-184EE5012880,j,j,`bj,,j,j,`cj,YYh_VersionHistory_F5F8918F-0A3F-4DA9-AE71-184EE5012880$MSysComplexPKIndex``Hv1ba%A L R NLJL J Jt  p +_]YFg>:D4B:z@6:z@Products9!߲ >>>22222220 @g:z@6:z@Products9!߲ >>>22222220 @g_:z@99:z@Product Transactions9L@ VVVJJJJJJJH @f:z@%:z@Product Sales Total by Date9@ @pddXXXXXXXV @e?:z@C@:z@Product Sales Qty by Employee and Date99@@zznnnnnnnl @c[:z@9:z@Product Purchases9@@\PPDDDDDDDB @b,:z@O<:z@Product Orders9@@VJJ>>>>>>>< @aj+:z@FC<:z@Product Category Sales by Date9 @@vjj^^^^^^^\ @ Z9?:z@ C:z@Orders Tax Status9@PPPDDDDDDDB @p:z@|0:z@Orders Status9@HHH<<<<<<<: @1:z@C:z@Orders9))߲ :::......., @`:z@_:z@Order Summary93 @@THH<<<<<<<: @_:z@ :z@Order Subtotals94 @@d|@dXXL@@@@@@> ` 6#:z@|0:z@Order Details Status9@VVVJJJJJJJH @]÷:z@:z@Order Details Extended9D*) @@rffZNNNNNNL `T:z@6:z@Order Details9߲ HHH<<<<<<<: @v1:z@v1:z@ MSysNavPaneObjectIDs9JJJJJJJJJJH v Q :z@ Q :z@ MSysNavPaneGroupToObjects9TTTTTTTTTTR qJ :z@J :z@ MSysNavPaneGroups9DDDDDDDDDDB mD :z@J :z@ MSysNavPaneGroupCategories9VVVVVVVVVVT k;:z@;:z@MSysComplexTypeVH_7B539F7EB4D54672B884C8A44F0760BE9 X:z@:z@ MSysAccessStorage9DDDDDDDDDDB ,:z@E*:z@Invoices9 @>>>22222220 @ yo:z@C:z@Inventory Transactions9 ߲ ZZZNNNNNNNL @u^0:z@ C:z@Inventory Transaction Types9@ dddXXXXXXXV @[N:z@m:z@Inventory Sold9 @nQ@m|@ bVVJ>>>>>>< `#*$*Xj:z@:z@Inventory on Hold9 @q]@o|@h\\PDDDDDDB `W;:z@i:z@Inventory9Qy+ w+ @XLL@4444442 `nHU:z@:z@ f_A2F0710427344ACEAEA504CBCFABE09A_Attachments9t@~~~~~~~| @ix:z@u:z@ f_9D292CF8F323457AA32F62AD56914F4F_Attachments9t@~~~~~~~| @d*:z@r:z@ f_8BAFB4AAB2234BD28443612CEF5D2182_Attachments9t@~~~~~~~| @_;:z@;:z@ f_87A118BD40A14242BB40A06472731106_VersionHistory_F5F8918F-0A3F-9  _ _ QYNeeY Y Y  Y Y  Y  Y Y _AttachmentsFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL(Shippers_Attachmentsefaeg-ehsYYY_Attachments$IdxFKPrimaryScalar$MSysComplexPKIndexeeees v1b @ d d d QYNjjY Y Y  Y Y  Y  Y Y _AttachmentsFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL(Products_Attachmentsjkajl-jmsYYY_Attachments$IdxFKPrimaryScalar$MSysComplexPKIndexjjjjs v1b  i i i SYNooY Y Y  Y Y  Y  Y Y _AttachmentsFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL*Suppliers_Attachmentsjopajoq-jorsYYY_Attachments$IdxFKPrimaryScalar$MSysComplexPKIndexoooos v1b  n n n4KDbD& X  ~ ` B $ P & f  z P 2  pFrT6Nm,]~Az4t \[Order Details].[Product ID]; g\Shipper NameShippers.CompanyG)) o\Orders.[Shipped Date]4 g\Orders.[Order Date]2 g\SalespersonH@ t3'' o\Customers.[Country/Region]9 g\ Customers.[ZIP/Postal Code]: g\ Customers.[State/Province]9 g\ Customers.City- g\ Customers.Address0 g\ Customer NameCustomers.CompanyJ++ o\Orders.[Customer ID]3 g\Orders.[Ship Country/Region]; g\Orders.[Ship ZIP/Postal Code]< g\Orders.[Ship State/Province]; g\Orders.[Ship City]1 g\Orders.[Ship Address]4 g\Orders.[Ship Name]1 g\Orders.[Order ID]0 g\sProducts!!! \sOrder Details+++ \sEmployees Extended555 \sOrders \sCustomers### \sShippers!!! \s \ G\ G\s \ G[ J@ t g[f@ t '[Quantity SoldL@ t7++ o[J@ t g[Inventory Transactions=== [ [ G[ G[ [ GZ J@t gZf@t 'ZQuantity PurchasedL@tA55 oZJ@t gZInventory Transactions=== Z Z GZ GZ Z GY J@t gYt@t 'YQuantity On OrderL@t?33 oYProduct IDJ@t1%% oYPurchase Order Details=== Y Y GY GY Y GX J@t gXf@, 'XQuantity On HoldL@,=11 oXJ@, gXInventory Transactions=== X X GX GX X GW 2 GW2ProductsProducts On Back Orderb@,YM! W2ProductsInventory On OrderZ@,QE! W2ProductsInventory On HoldX@,OC! W2ProductsInventory Purchased\@,SG! LVAL,l b f   0 8 vb~"z"6jj^[Purchase Orders].[Creation Date]((([Purchase Order Details].[Posted To Inventory])=True))Suppliers.ID=[Purchase Orders].[Supplier ID][Purchase Orders].[Purchase Order ID]=[Purchase Order Details].[Purchase Order ID][Purchase Order Details].[Posted To Inventory][Purchase Order Details].[Unit Cost][Purchase Order Details].Quantity[Purchase Orders].[Creation Date][Purchase Orders].[Purchase Order ID][Purchase Order Details].[Product ID]Orders.[Order ID]=[Order Details].[Order ID][Customers Extended].ID=Orders.[Customer ID]Products.ID=[Order Details].[Product ID]Orders.[Order ID]=[Order Details].[Order ID][Orders Status].[Status ID]=Orders.[Status ID]Orders.[Order ID]=[Order Price Totals].OrderID[Sub Total]+[Shipping Fee]+[Taxes][Order Price Totals].[Price Total]Sum(CCur([Unit Price]*[Quantity]*(1-[Discount])/100)*100)[Order Details Extended].[Order ID]Sum([Order Details Extended].[Extended Price])[Order Details Extended].[Order ID][Order Details].[Status ID]=[Order Details Status].[Status ID][Order Details Status].[Status Name]CCur([Quantity]*[Unit Price]*(1-[Discount]))Orders.[Order ID]=[Order Details].[Order ID][Order Details].[Product ID]=Products.IDCustomers.ID=Orders.[Customer ID]Orders.[Employee ID]=[Employees Extended].IDCCur(Nz([Unit Price]*[Quantity]*(1-[Discount]),0)/100)*100[Employees Extended].[Employee Name][Inventory Transactions].[Product ID]((([Inventory Transactions].[Transaction Type])=2))Sum([Inventory Transactions].Quantity)[Inventory Transactions].[Product ID][Inventory Transactions].[Product ID]((([Inventory Transactions].[Transaction Type])=1))Sum([Inventory Transactions].Quantity)[Inventory Transactions].[Product ID][Purchase Order Details].[Product ID]((([Purchase Order Details].[Posted To Inventory])=False))Sum([Purchase Order Details].Quantity)[Purchase Order Details].[Product ID][Inventory Transactions].[Product ID]#Y l NvvY Y  dIDType NamevxY yY.rBPrimaryKeyv1uWaste On HoldSold Purchasedu@wwwwBYf$xN  zzffffffYeYYrYnYnYrYoY Y  Transaction ID Transaction Type0Transaction Created Date2Transaction Modified DateProduct IDQuantity"Purchase Order ID"Customer Order IDCommentsFsNe-z} AJ tsz~s o obzPh mrdezit/onPztaYYY Y Y Y uYYYYYYY.rI"Customer Order IDBNew_OrdersOnInventoryTransactionsBNew_ProductOnInventoryTransactionPNew_PuchaseOrdersonInventoryTransactionsVNew_TransactionTypesOnInventoryTransactiosn:OrdersOnInventoryTransactionsPrimaryKeyProduct ID:ProductOnInventoryTransactionHPuchaseOrdersonInventoryTransactions"Purchase Order IDNTransactionTypesOnInventoryTransactiosnv1b@ yBa,X# O  { F  r =  i 4 ` + W"pA Z+W"NzE dbɯn@bɯn@9d? cJrR@333sR@0 ? b2T6@2T6@"? aV40@V40@" ? `>^@>^@" ? _@Wn@(? ^e|@Wn@)? ]t@@Wn@? \= @n@? ['@h$n@(2? ZY@Y@Q? YBp@Bp@+? X@@? WnQ@nQ@Q2? VKs@Ks@P? U@=o@ ? T}'@=o@ ? Soi@@"dFill Back Ordered product, Order #30g? RW@W@"d? Qڋ@G;@Fill Back Ordered product, Order #33g? Pe@e@? Oq2@@)Fill Back Ordered product, Order #36g? N@@)? Mϊ@@P@+,Fill Back Ordered product, Order #38g? LA@A@+,? K \@m@0dFill Back Ordered product, Order #39g? J@@0d? IA@)\B@QFill Back Ordered product, Order #40g? HlA@lA@Q? GTY@a3@? Fw8@|ݨ@0 ? E$@Ũ@? DBʎ@?Ȑ@+? C@?Ȑ@? BCZ@Bp@P ? A=@Bp@3 ? @g[@Bp@ ? ?`w@@P? >Hw@Hw@Q}? =wwww@wwww@+d? <jv@jv@"<? ;G;v@G;v@(? :t@t@BP? 92>t@2>t@A(? 8ks@ks@(? 7r@r@(? 6qr@qr@d? 5[p@[p@M<? 4o@o@J? 34o@4o@3(? 24o@4o@0d? 1^cn@^cn@)(? 0;L]n@;L]n@(x? /5m@5m@? .cm@cm@(? -:m@:m@? ,l@l@(? +LGl@LGl@(? *k@k@(? )<6j@<6j@(? (M1j@M1j@d? '_7g@_7g@9P? &t@g@t@g@8x? %}f@}f@4d? $ Ce@ Ce@H(? #R]c@R]c@PK?y$Ng 8  Q " p ;  g 2 ^)U L s@m@8n? Qßo@" o@4(? 8&o@" o@(? i$o@o@? ;6o@o@2? $o@؂-o@H(? Ao@V?ӑo@J? nto@@o@P? )Fo@o@? ͫo@CpHo@((? ~!Ceo@ އo@+? }go@o@) ? |o@"-o@0(? {lo@-́o@0(? z1u}o@F~o@? y*{o@MG{o@Z? x9xo@0uyo@(? wjvo@vo@? vvo@vo@3? un@}n@"W? tL]nn@h$n@)2Fill Back Ordered product, Order #45g? sVn@Vn@)2? rn@?n@H2Fill Back Ordered product, Order #46g? q#߼n@#߼n@H2? p*0n@=n@Fill Back Ordered product, Order #48g? oZn@Zn@ ? nGn@=o@ Fill Back Ordered product, Order #42g? mvn@vn@? lطn@Sn@",Fill Back Ordered product, Order #47g? k n@ n@",? j%ڵn@=n@Fill Back Ordered product, Order #48g? in@n@? hݳn@ݳn@+,Fill Back Ordered product, Order #41g? gn@n@+? f֮n@֮n@"2? en@?n@9dFill Back Ordered product, Order #46g?" y B!B!B!B!B!B!B!B!B!B!B!B!B{{{{{{{{{{ { { { { {{{{{{{{{{{{{{{{{{{ {!{"{#{${%{&{'{({){*{+{,{-{.{/{0{1{2{3{4{5{6{7{8{9{:{;{<{={>{?{@{A|||||||||| | | | | ||||||||||||||||||| |!|"|# y @ @ @ @ @ @ @ @ @ @ @ @ @#{${%{&{'{({){*{+{,{ -{ .{ /{ 0{ 1{2{3{4{5{6{7{8{9{:{;{<{={>{?{@{A{B{C{ D{!E{"F{#G{$H{%I{&J{'K{(L{)M{*N{+O{,P{-Q{.R{/S{0T{1U{2V{3W{4X{5Y{6Z{7[{8\{9]{:^{;_{<`{=a{>b{?c{@d{Ae|f|g|h|i|j|k|l|m|n| o| p| q| r| s|t|u|v|w|x|y|z|{|||}|~|||||||| |!|"|# y @ @ @ @ @ @ @ @ @ @ @ @ @{{ {5{|{{2|{{:{{1|{{|{{$|||| {{ |{ {"{-{.|| | | { |!{ {9"{"{/"{0"{="{>"{?"|"|"|"|({ ({8({<(|){){+){,){;)|)|)|+{+{!+{)+{*+{6+|+|+|0{0{#0{'0{(0{@0|0|3{3{3|4{4|"8{8|#9{9{A9|A{B{H{H| H| H|J{J|M{P{P{P{P{3P|Q{Q{%Q{&Q{4Q{7