"ex_plan.json" - Views: 122 · Hits: 122 - Type: Public

{
	"stages" : [
		{
			"$cursor" : {
				"query" : {
					"$and" : [
						{
							"$and" : [
								{
									"$and" : [
										{
											"$and" : [
												{
													"$or" : [
														{
															"Status" : 4
														},
														{
															"TransactionID" : {
																"$in" : [
																	16,
																	116
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : null
												}
											]
										},
										{
											"TransactionID" : {
												"$nin" : [
													18,
													181
												]
											}
										}
									]
								},
								{
									"NowDate" : {
										"$gte" : "970701"
									}
								}
							]
						},
						{
							"NowDate" : {
								"$lte" : "970708"
							}
						}
					]
				},
				"fields" : {
					"PurchaseOrderLines" : 1,
					"WarehouseID" : 1,
					"WarehouseTypeID" : 1,
					"_id" : 0
				},
				"queryPlanner" : {
					"plannerVersion" : 1,
					"namespace" : "OKESTest.PurchaseOrder",
					"indexFilterSet" : false,
					"parsedQuery" : {
						"$and" : [
							{
								"$or" : [
									{
										"Status" : {
											"$eq" : 4
										}
									},
									{
										"TransactionID" : {
											"$in" : [
												16,
												116
											]
										}
									}
								]
							},
							{
								"PurchaseOrderLines.LedgerPostingStatus" : {
									"$eq" : null
								}
							},
							{
								"NowDate" : {
									"$lte" : "970708"
								}
							},
							{
								"NowDate" : {
									"$gte" : "970701"
								}
							},
							{
								"$nor" : [
									{
										"TransactionID" : {
											"$in" : [
												18,
												181
											]
										}
									}
								]
							}
						]
					},
					"winningPlan" : {
						"stage" : "OR",
						"inputStages" : [
							{
								"stage" : "FETCH",
								"filter" : {
									"$and" : [
										{
											"$nor" : [
												{
													"TransactionID" : {
														"$in" : [
															18,
															181
														]
													}
												}
											]
										},
										{
											"PurchaseOrderLines.LedgerPostingStatus" : {
												"$eq" : null
											}
										}
									]
								},
								"inputStage" : {
									"stage" : "IXSCAN",
									"keyPattern" : {
										"TransactionID" : 1,
										"PurchaseOrderLines.LedgerPostingStatus" : 1,
										"Status" : 1,
										"NowDate" : 1
									},
									"indexName" : "IX_Inventory_Where",
									"isMultiKey" : true,
									"multiKeyPaths" : {
										"TransactionID" : [ ],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"PurchaseOrderLines"
										],
										"Status" : [ ],
										"NowDate" : [ ]
									},
									"isUnique" : false,
									"isSparse" : false,
									"isPartial" : false,
									"indexVersion" : 2,
									"direction" : "forward",
									"indexBounds" : {
										"TransactionID" : [
											"[MinKey, 18)",
											"(18, 181)",
											"(181, MaxKey]"
										],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"[null, null]"
										],
										"Status" : [
											"[4, 4]"
										],
										"NowDate" : [
											"[\"970701\", \"970708\"]"
										]
									}
								}
							},
							{
								"stage" : "FETCH",
								"filter" : {
									"$and" : [
										{
											"$nor" : [
												{
													"TransactionID" : {
														"$in" : [
															18,
															181
														]
													}
												}
											]
										},
										{
											"PurchaseOrderLines.LedgerPostingStatus" : {
												"$eq" : null
											}
										}
									]
								},
								"inputStage" : {
									"stage" : "IXSCAN",
									"keyPattern" : {
										"TransactionID" : 1,
										"PurchaseOrderLines.LedgerPostingStatus" : 1,
										"Status" : 1,
										"NowDate" : 1
									},
									"indexName" : "IX_Inventory_Where",
									"isMultiKey" : true,
									"multiKeyPaths" : {
										"TransactionID" : [ ],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"PurchaseOrderLines"
										],
										"Status" : [ ],
										"NowDate" : [ ]
									},
									"isUnique" : false,
									"isSparse" : false,
									"isPartial" : false,
									"indexVersion" : 2,
									"direction" : "forward",
									"indexBounds" : {
										"TransactionID" : [
											"[16, 16]",
											"[116, 116]"
										],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"[null, null]"
										],
										"Status" : [
											"[MinKey, MaxKey]"
										],
										"NowDate" : [
											"[\"970701\", \"970708\"]"
										]
									}
								}
							}
						]
					},
					"rejectedPlans" : [
						{
							"stage" : "OR",
							"inputStages" : [
								{
									"stage" : "FETCH",
									"filter" : {
										"$and" : [
											{
												"$nor" : [
													{
														"TransactionID" : {
															"$in" : [
																18,
																181
															]
														}
													}
												]
											},
											{
												"PurchaseOrderLines.LedgerPostingStatus" : {
													"$eq" : null
												}
											}
										]
									},
									"inputStage" : {
										"stage" : "IXSCAN",
										"keyPattern" : {
											"TransactionID" : 1,
											"PurchaseOrderLines.LedgerPostingStatus" : 1,
											"Status" : 1,
											"NowDate" : 1,
											"PurchaseOrderLines.ProductID" : 1,
											"WarehouseID" : 1
										},
										"indexName" : "IX_Inventory",
										"isMultiKey" : true,
										"multiKeyPaths" : {
											"TransactionID" : [ ],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"PurchaseOrderLines"
											],
											"Status" : [ ],
											"NowDate" : [ ],
											"PurchaseOrderLines.ProductID" : [
												"PurchaseOrderLines"
											],
											"WarehouseID" : [ ]
										},
										"isUnique" : false,
										"isSparse" : false,
										"isPartial" : false,
										"indexVersion" : 2,
										"direction" : "forward",
										"indexBounds" : {
											"TransactionID" : [
												"[MinKey, 18)",
												"(18, 181)",
												"(181, MaxKey]"
											],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"[null, null]"
											],
											"Status" : [
												"[4, 4]"
											],
											"NowDate" : [
												"[\"970701\", \"970708\"]"
											],
											"PurchaseOrderLines.ProductID" : [
												"[MinKey, MaxKey]"
											],
											"WarehouseID" : [
												"[MinKey, MaxKey]"
											]
										}
									}
								},
								{
									"stage" : "FETCH",
									"filter" : {
										"$and" : [
											{
												"$nor" : [
													{
														"TransactionID" : {
															"$in" : [
																18,
																181
															]
														}
													}
												]
											},
											{
												"PurchaseOrderLines.LedgerPostingStatus" : {
													"$eq" : null
												}
											}
										]
									},
									"inputStage" : {
										"stage" : "IXSCAN",
										"keyPattern" : {
											"TransactionID" : 1,
											"PurchaseOrderLines.LedgerPostingStatus" : 1,
											"Status" : 1,
											"NowDate" : 1
										},
										"indexName" : "IX_Inventory_Where",
										"isMultiKey" : true,
										"multiKeyPaths" : {
											"TransactionID" : [ ],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"PurchaseOrderLines"
											],
											"Status" : [ ],
											"NowDate" : [ ]
										},
										"isUnique" : false,
										"isSparse" : false,
										"isPartial" : false,
										"indexVersion" : 2,
										"direction" : "forward",
										"indexBounds" : {
											"TransactionID" : [
												"[16, 16]",
												"[116, 116]"
											],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"[null, null]"
											],
											"Status" : [
												"[MinKey, MaxKey]"
											],
											"NowDate" : [
												"[\"970701\", \"970708\"]"
											]
										}
									}
								}
							]
						},
						{
							"stage" : "OR",
							"inputStages" : [
								{
									"stage" : "FETCH",
									"filter" : {
										"$and" : [
											{
												"$nor" : [
													{
														"TransactionID" : {
															"$in" : [
																18,
																181
															]
														}
													}
												]
											},
											{
												"PurchaseOrderLines.LedgerPostingStatus" : {
													"$eq" : null
												}
											}
										]
									},
									"inputStage" : {
										"stage" : "IXSCAN",
										"keyPattern" : {
											"TransactionID" : 1,
											"PurchaseOrderLines.LedgerPostingStatus" : 1,
											"Status" : 1,
											"NowDate" : 1,
											"PurchaseOrderLines.ProductID" : 1,
											"WarehouseID" : 1
										},
										"indexName" : "IX_Inventory",
										"isMultiKey" : true,
										"multiKeyPaths" : {
											"TransactionID" : [ ],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"PurchaseOrderLines"
											],
											"Status" : [ ],
											"NowDate" : [ ],
											"PurchaseOrderLines.ProductID" : [
												"PurchaseOrderLines"
											],
											"WarehouseID" : [ ]
										},
										"isUnique" : false,
										"isSparse" : false,
										"isPartial" : false,
										"indexVersion" : 2,
										"direction" : "forward",
										"indexBounds" : {
											"TransactionID" : [
												"[16, 16]",
												"[116, 116]"
											],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"[null, null]"
											],
											"Status" : [
												"[MinKey, MaxKey]"
											],
											"NowDate" : [
												"[\"970701\", \"970708\"]"
											],
											"PurchaseOrderLines.ProductID" : [
												"[MinKey, MaxKey]"
											],
											"WarehouseID" : [
												"[MinKey, MaxKey]"
											]
										}
									}
								},
								{
									"stage" : "FETCH",
									"filter" : {
										"$and" : [
											{
												"$nor" : [
													{
														"TransactionID" : {
															"$in" : [
																18,
																181
															]
														}
													}
												]
											},
											{
												"PurchaseOrderLines.LedgerPostingStatus" : {
													"$eq" : null
												}
											}
										]
									},
									"inputStage" : {
										"stage" : "IXSCAN",
										"keyPattern" : {
											"TransactionID" : 1,
											"PurchaseOrderLines.LedgerPostingStatus" : 1,
											"Status" : 1,
											"NowDate" : 1
										},
										"indexName" : "IX_Inventory_Where",
										"isMultiKey" : true,
										"multiKeyPaths" : {
											"TransactionID" : [ ],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"PurchaseOrderLines"
											],
											"Status" : [ ],
											"NowDate" : [ ]
										},
										"isUnique" : false,
										"isSparse" : false,
										"isPartial" : false,
										"indexVersion" : 2,
										"direction" : "forward",
										"indexBounds" : {
											"TransactionID" : [
												"[MinKey, 18)",
												"(18, 181)",
												"(181, MaxKey]"
											],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"[null, null]"
											],
											"Status" : [
												"[4, 4]"
											],
											"NowDate" : [
												"[\"970701\", \"970708\"]"
											]
										}
									}
								}
							]
						},
						{
							"stage" : "OR",
							"inputStages" : [
								{
									"stage" : "FETCH",
									"filter" : {
										"$and" : [
											{
												"$nor" : [
													{
														"TransactionID" : {
															"$in" : [
																18,
																181
															]
														}
													}
												]
											},
											{
												"PurchaseOrderLines.LedgerPostingStatus" : {
													"$eq" : null
												}
											}
										]
									},
									"inputStage" : {
										"stage" : "IXSCAN",
										"keyPattern" : {
											"TransactionID" : 1,
											"PurchaseOrderLines.LedgerPostingStatus" : 1,
											"Status" : 1,
											"NowDate" : 1,
											"PurchaseOrderLines.ProductID" : 1,
											"WarehouseID" : 1
										},
										"indexName" : "IX_Inventory",
										"isMultiKey" : true,
										"multiKeyPaths" : {
											"TransactionID" : [ ],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"PurchaseOrderLines"
											],
											"Status" : [ ],
											"NowDate" : [ ],
											"PurchaseOrderLines.ProductID" : [
												"PurchaseOrderLines"
											],
											"WarehouseID" : [ ]
										},
										"isUnique" : false,
										"isSparse" : false,
										"isPartial" : false,
										"indexVersion" : 2,
										"direction" : "forward",
										"indexBounds" : {
											"TransactionID" : [
												"[MinKey, 18)",
												"(18, 181)",
												"(181, MaxKey]"
											],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"[null, null]"
											],
											"Status" : [
												"[4, 4]"
											],
											"NowDate" : [
												"[\"970701\", \"970708\"]"
											],
											"PurchaseOrderLines.ProductID" : [
												"[MinKey, MaxKey]"
											],
											"WarehouseID" : [
												"[MinKey, MaxKey]"
											]
										}
									}
								},
								{
									"stage" : "FETCH",
									"filter" : {
										"$and" : [
											{
												"$nor" : [
													{
														"TransactionID" : {
															"$in" : [
																18,
																181
															]
														}
													}
												]
											},
											{
												"PurchaseOrderLines.LedgerPostingStatus" : {
													"$eq" : null
												}
											}
										]
									},
									"inputStage" : {
										"stage" : "IXSCAN",
										"keyPattern" : {
											"TransactionID" : 1,
											"PurchaseOrderLines.LedgerPostingStatus" : 1,
											"Status" : 1,
											"NowDate" : 1,
											"PurchaseOrderLines.ProductID" : 1,
											"WarehouseID" : 1
										},
										"indexName" : "IX_Inventory",
										"isMultiKey" : true,
										"multiKeyPaths" : {
											"TransactionID" : [ ],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"PurchaseOrderLines"
											],
											"Status" : [ ],
											"NowDate" : [ ],
											"PurchaseOrderLines.ProductID" : [
												"PurchaseOrderLines"
											],
											"WarehouseID" : [ ]
										},
										"isUnique" : false,
										"isSparse" : false,
										"isPartial" : false,
										"indexVersion" : 2,
										"direction" : "forward",
										"indexBounds" : {
											"TransactionID" : [
												"[16, 16]",
												"[116, 116]"
											],
											"PurchaseOrderLines.LedgerPostingStatus" : [
												"[null, null]"
											],
											"Status" : [
												"[MinKey, MaxKey]"
											],
											"NowDate" : [
												"[\"970701\", \"970708\"]"
											],
											"PurchaseOrderLines.ProductID" : [
												"[MinKey, MaxKey]"
											],
											"WarehouseID" : [
												"[MinKey, MaxKey]"
											]
										}
									}
								}
							]
						},
						{
							"stage" : "FETCH",
							"filter" : {
								"$and" : [
									{
										"$nor" : [
											{
												"TransactionID" : {
													"$in" : [
														18,
														181
													]
												}
											}
										]
									},
									{
										"PurchaseOrderLines.LedgerPostingStatus" : {
											"$eq" : null
										}
									},
									{
										"$or" : [
											{
												"Status" : {
													"$eq" : 4
												}
											},
											{
												"TransactionID" : {
													"$in" : [
														16,
														116
													]
												}
											}
										]
									}
								]
							},
							"inputStage" : {
								"stage" : "IXSCAN",
								"keyPattern" : {
									"TransactionID" : 1,
									"PurchaseOrderLines.LedgerPostingStatus" : 1,
									"Status" : 1,
									"NowDate" : 1
								},
								"indexName" : "IX_Inventory_Where",
								"isMultiKey" : true,
								"multiKeyPaths" : {
									"TransactionID" : [ ],
									"PurchaseOrderLines.LedgerPostingStatus" : [
										"PurchaseOrderLines"
									],
									"Status" : [ ],
									"NowDate" : [ ]
								},
								"isUnique" : false,
								"isSparse" : false,
								"isPartial" : false,
								"indexVersion" : 2,
								"direction" : "forward",
								"indexBounds" : {
									"TransactionID" : [
										"[MinKey, 18)",
										"(18, 181)",
										"(181, MaxKey]"
									],
									"PurchaseOrderLines.LedgerPostingStatus" : [
										"[null, null]"
									],
									"Status" : [
										"[MinKey, MaxKey]"
									],
									"NowDate" : [
										"[\"970701\", \"970708\"]"
									]
								}
							}
						},
						{
							"stage" : "FETCH",
							"filter" : {
								"$and" : [
									{
										"$nor" : [
											{
												"TransactionID" : {
													"$in" : [
														18,
														181
													]
												}
											}
										]
									},
									{
										"PurchaseOrderLines.LedgerPostingStatus" : {
											"$eq" : null
										}
									},
									{
										"$or" : [
											{
												"Status" : {
													"$eq" : 4
												}
											},
											{
												"TransactionID" : {
													"$in" : [
														16,
														116
													]
												}
											}
										]
									}
								]
							},
							"inputStage" : {
								"stage" : "IXSCAN",
								"keyPattern" : {
									"TransactionID" : 1,
									"PurchaseOrderLines.LedgerPostingStatus" : 1,
									"Status" : 1,
									"NowDate" : 1,
									"PurchaseOrderLines.ProductID" : 1,
									"WarehouseID" : 1
								},
								"indexName" : "IX_Inventory",
								"isMultiKey" : true,
								"multiKeyPaths" : {
									"TransactionID" : [ ],
									"PurchaseOrderLines.LedgerPostingStatus" : [
										"PurchaseOrderLines"
									],
									"Status" : [ ],
									"NowDate" : [ ],
									"PurchaseOrderLines.ProductID" : [
										"PurchaseOrderLines"
									],
									"WarehouseID" : [ ]
								},
								"isUnique" : false,
								"isSparse" : false,
								"isPartial" : false,
								"indexVersion" : 2,
								"direction" : "forward",
								"indexBounds" : {
									"TransactionID" : [
										"[MinKey, 18)",
										"(18, 181)",
										"(181, MaxKey]"
									],
									"PurchaseOrderLines.LedgerPostingStatus" : [
										"[null, null]"
									],
									"Status" : [
										"[MinKey, MaxKey]"
									],
									"NowDate" : [
										"[\"970701\", \"970708\"]"
									],
									"PurchaseOrderLines.ProductID" : [
										"[MinKey, MaxKey]"
									],
									"WarehouseID" : [
										"[MinKey, MaxKey]"
									]
								}
							}
						}
					]
				},
				"executionStats" : {
					"executionSuccess" : true,
					"nReturned" : 165728,
					"executionTimeMillis" : 45165,
					"totalKeysExamined" : 182875,
					"totalDocsExamined" : 182820,
					"executionStages" : {
						"stage" : "OR",
						"nReturned" : 165728,
						"executionTimeMillisEstimate" : 10715,
						"works" : 182876,
						"advanced" : 165728,
						"needTime" : 17147,
						"needYield" : 0,
						"saveState" : 4570,
						"restoreState" : 4570,
						"isEOF" : 1,
						"invalidates" : 0,
						"dupsTested" : 182820,
						"dupsDropped" : 17092,
						"recordIdsForgotten" : 0,
						"inputStages" : [
							{
								"stage" : "FETCH",
								"filter" : {
									"$and" : [
										{
											"$nor" : [
												{
													"TransactionID" : {
														"$in" : [
															18,
															181
														]
													}
												}
											]
										},
										{
											"PurchaseOrderLines.LedgerPostingStatus" : {
												"$eq" : null
											}
										}
									]
								},
								"nReturned" : 165727,
								"executionTimeMillisEstimate" : 10383,
								"works" : 165775,
								"advanced" : 165727,
								"needTime" : 47,
								"needYield" : 0,
								"saveState" : 4570,
								"restoreState" : 4570,
								"isEOF" : 1,
								"invalidates" : 0,
								"docsExamined" : 165727,
								"alreadyHasObj" : 0,
								"inputStage" : {
									"stage" : "IXSCAN",
									"nReturned" : 165727,
									"executionTimeMillisEstimate" : 1157,
									"works" : 165775,
									"advanced" : 165727,
									"needTime" : 47,
									"needYield" : 0,
									"saveState" : 4570,
									"restoreState" : 4570,
									"isEOF" : 1,
									"invalidates" : 0,
									"keyPattern" : {
										"TransactionID" : 1,
										"PurchaseOrderLines.LedgerPostingStatus" : 1,
										"Status" : 1,
										"NowDate" : 1
									},
									"indexName" : "IX_Inventory_Where",
									"isMultiKey" : true,
									"multiKeyPaths" : {
										"TransactionID" : [ ],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"PurchaseOrderLines"
										],
										"Status" : [ ],
										"NowDate" : [ ]
									},
									"isUnique" : false,
									"isSparse" : false,
									"isPartial" : false,
									"indexVersion" : 2,
									"direction" : "forward",
									"indexBounds" : {
										"TransactionID" : [
											"[MinKey, 18)",
											"(18, 181)",
											"(181, MaxKey]"
										],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"[null, null]"
										],
										"Status" : [
											"[4, 4]"
										],
										"NowDate" : [
											"[\"970701\", \"970708\"]"
										]
									},
									"keysExamined" : 165774,
									"seeks" : 48,
									"dupsTested" : 165727,
									"dupsDropped" : 0,
									"seenInvalidated" : 0
								}
							},
							{
								"stage" : "FETCH",
								"filter" : {
									"$and" : [
										{
											"$nor" : [
												{
													"TransactionID" : {
														"$in" : [
															18,
															181
														]
													}
												}
											]
										},
										{
											"PurchaseOrderLines.LedgerPostingStatus" : {
												"$eq" : null
											}
										}
									]
								},
								"nReturned" : 17093,
								"executionTimeMillisEstimate" : 158,
								"works" : 17101,
								"advanced" : 17093,
								"needTime" : 7,
								"needYield" : 0,
								"saveState" : 4570,
								"restoreState" : 4570,
								"isEOF" : 1,
								"invalidates" : 0,
								"docsExamined" : 17093,
								"alreadyHasObj" : 0,
								"inputStage" : {
									"stage" : "IXSCAN",
									"nReturned" : 17093,
									"executionTimeMillisEstimate" : 72,
									"works" : 17101,
									"advanced" : 17093,
									"needTime" : 7,
									"needYield" : 0,
									"saveState" : 4570,
									"restoreState" : 4570,
									"isEOF" : 1,
									"invalidates" : 0,
									"keyPattern" : {
										"TransactionID" : 1,
										"PurchaseOrderLines.LedgerPostingStatus" : 1,
										"Status" : 1,
										"NowDate" : 1
									},
									"indexName" : "IX_Inventory_Where",
									"isMultiKey" : true,
									"multiKeyPaths" : {
										"TransactionID" : [ ],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"PurchaseOrderLines"
										],
										"Status" : [ ],
										"NowDate" : [ ]
									},
									"isUnique" : false,
									"isSparse" : false,
									"isPartial" : false,
									"indexVersion" : 2,
									"direction" : "forward",
									"indexBounds" : {
										"TransactionID" : [
											"[16, 16]",
											"[116, 116]"
										],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"[null, null]"
										],
										"Status" : [
											"[MinKey, MaxKey]"
										],
										"NowDate" : [
											"[\"970701\", \"970708\"]"
										]
									},
									"keysExamined" : 17101,
									"seeks" : 8,
									"dupsTested" : 17093,
									"dupsDropped" : 0,
									"seenInvalidated" : 0
								}
							}
						]
					},
					"allPlansExecution" : [
						{
							"nReturned" : 101,
							"executionTimeMillisEstimate" : 65,
							"totalKeysExamined" : 102,
							"totalDocsExamined" : 101,
							"executionStages" : {
								"stage" : "OR",
								"nReturned" : 101,
								"executionTimeMillisEstimate" : 65,
								"works" : 102,
								"advanced" : 101,
								"needTime" : 1,
								"needYield" : 0,
								"saveState" : 13,
								"restoreState" : 12,
								"isEOF" : 0,
								"invalidates" : 0,
								"dupsTested" : 101,
								"dupsDropped" : 0,
								"recordIdsForgotten" : 0,
								"inputStages" : [
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 101,
										"executionTimeMillisEstimate" : 65,
										"works" : 102,
										"advanced" : 101,
										"needTime" : 1,
										"needYield" : 0,
										"saveState" : 13,
										"restoreState" : 12,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 101,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 101,
											"executionTimeMillisEstimate" : 0,
											"works" : 102,
											"advanced" : 101,
											"needTime" : 1,
											"needYield" : 0,
											"saveState" : 13,
											"restoreState" : 12,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1
											},
											"indexName" : "IX_Inventory_Where",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[MinKey, 18)",
													"(18, 181)",
													"(181, MaxKey]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[4, 4]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												]
											},
											"keysExamined" : 102,
											"seeks" : 2,
											"dupsTested" : 101,
											"dupsDropped" : 0,
											"seenInvalidated" : 0
										}
									},
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 0,
										"executionTimeMillisEstimate" : 0,
										"works" : 0,
										"advanced" : 0,
										"needTime" : 0,
										"needYield" : 0,
										"saveState" : 13,
										"restoreState" : 12,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 0,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 0,
											"executionTimeMillisEstimate" : 0,
											"works" : 0,
											"advanced" : 0,
											"needTime" : 0,
											"needYield" : 0,
											"saveState" : 13,
											"restoreState" : 12,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1
											},
											"indexName" : "IX_Inventory_Where",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[16, 16]",
													"[116, 116]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[MinKey, MaxKey]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												]
											},
											"keysExamined" : 0,
											"seeks" : 0,
											"dupsTested" : 0,
											"dupsDropped" : 0,
											"seenInvalidated" : 0
										}
									}
								]
							}
						},
						{
							"nReturned" : 64,
							"executionTimeMillisEstimate" : 64,
							"totalKeysExamined" : 102,
							"totalDocsExamined" : 64,
							"executionStages" : {
								"stage" : "OR",
								"nReturned" : 64,
								"executionTimeMillisEstimate" : 64,
								"works" : 102,
								"advanced" : 64,
								"needTime" : 38,
								"needYield" : 0,
								"saveState" : 4570,
								"restoreState" : 4570,
								"isEOF" : 0,
								"invalidates" : 0,
								"dupsTested" : 64,
								"dupsDropped" : 0,
								"recordIdsForgotten" : 0,
								"inputStages" : [
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 64,
										"executionTimeMillisEstimate" : 64,
										"works" : 102,
										"advanced" : 64,
										"needTime" : 38,
										"needYield" : 0,
										"saveState" : 4570,
										"restoreState" : 4570,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 64,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 64,
											"executionTimeMillisEstimate" : 32,
											"works" : 102,
											"advanced" : 64,
											"needTime" : 38,
											"needYield" : 0,
											"saveState" : 4570,
											"restoreState" : 4570,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1,
												"PurchaseOrderLines.ProductID" : 1,
												"WarehouseID" : 1
											},
											"indexName" : "IX_Inventory",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ],
												"PurchaseOrderLines.ProductID" : [
													"PurchaseOrderLines"
												],
												"WarehouseID" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[MinKey, 18)",
													"(18, 181)",
													"(181, MaxKey]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[4, 4]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												],
												"PurchaseOrderLines.ProductID" : [
													"[MinKey, MaxKey]"
												],
												"WarehouseID" : [
													"[MinKey, MaxKey]"
												]
											},
											"keysExamined" : 102,
											"seeks" : 2,
											"dupsTested" : 101,
											"dupsDropped" : 37,
											"seenInvalidated" : 0
										}
									},
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 0,
										"executionTimeMillisEstimate" : 0,
										"works" : 0,
										"advanced" : 0,
										"needTime" : 0,
										"needYield" : 0,
										"saveState" : 4570,
										"restoreState" : 4570,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 0,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 0,
											"executionTimeMillisEstimate" : 0,
											"works" : 0,
											"advanced" : 0,
											"needTime" : 0,
											"needYield" : 0,
											"saveState" : 4570,
											"restoreState" : 4570,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1
											},
											"indexName" : "IX_Inventory_Where",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[16, 16]",
													"[116, 116]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[MinKey, MaxKey]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												]
											},
											"keysExamined" : 0,
											"seeks" : 0,
											"dupsTested" : 0,
											"dupsDropped" : 0,
											"seenInvalidated" : 0
										}
									}
								]
							}
						},
						{
							"nReturned" : 101,
							"executionTimeMillisEstimate" : 10,
							"totalKeysExamined" : 102,
							"totalDocsExamined" : 101,
							"executionStages" : {
								"stage" : "OR",
								"nReturned" : 101,
								"executionTimeMillisEstimate" : 10,
								"works" : 102,
								"advanced" : 101,
								"needTime" : 1,
								"needYield" : 0,
								"saveState" : 4570,
								"restoreState" : 4570,
								"isEOF" : 0,
								"invalidates" : 0,
								"dupsTested" : 101,
								"dupsDropped" : 0,
								"recordIdsForgotten" : 0,
								"inputStages" : [
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 101,
										"executionTimeMillisEstimate" : 10,
										"works" : 102,
										"advanced" : 101,
										"needTime" : 1,
										"needYield" : 0,
										"saveState" : 4570,
										"restoreState" : 4570,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 101,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 101,
											"executionTimeMillisEstimate" : 10,
											"works" : 102,
											"advanced" : 101,
											"needTime" : 1,
											"needYield" : 0,
											"saveState" : 4570,
											"restoreState" : 4570,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1,
												"PurchaseOrderLines.ProductID" : 1,
												"WarehouseID" : 1
											},
											"indexName" : "IX_Inventory",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ],
												"PurchaseOrderLines.ProductID" : [
													"PurchaseOrderLines"
												],
												"WarehouseID" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[16, 16]",
													"[116, 116]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[MinKey, MaxKey]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												],
												"PurchaseOrderLines.ProductID" : [
													"[MinKey, MaxKey]"
												],
												"WarehouseID" : [
													"[MinKey, MaxKey]"
												]
											},
											"keysExamined" : 102,
											"seeks" : 2,
											"dupsTested" : 101,
											"dupsDropped" : 0,
											"seenInvalidated" : 0
										}
									},
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 0,
										"executionTimeMillisEstimate" : 0,
										"works" : 0,
										"advanced" : 0,
										"needTime" : 0,
										"needYield" : 0,
										"saveState" : 4570,
										"restoreState" : 4570,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 0,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 0,
											"executionTimeMillisEstimate" : 0,
											"works" : 0,
											"advanced" : 0,
											"needTime" : 0,
											"needYield" : 0,
											"saveState" : 4570,
											"restoreState" : 4570,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1
											},
											"indexName" : "IX_Inventory_Where",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[MinKey, 18)",
													"(18, 181)",
													"(181, MaxKey]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[4, 4]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												]
											},
											"keysExamined" : 0,
											"seeks" : 0,
											"dupsTested" : 0,
											"dupsDropped" : 0,
											"seenInvalidated" : 0
										}
									}
								]
							}
						},
						{
							"nReturned" : 64,
							"executionTimeMillisEstimate" : 11,
							"totalKeysExamined" : 102,
							"totalDocsExamined" : 64,
							"executionStages" : {
								"stage" : "OR",
								"nReturned" : 64,
								"executionTimeMillisEstimate" : 11,
								"works" : 102,
								"advanced" : 64,
								"needTime" : 38,
								"needYield" : 0,
								"saveState" : 4570,
								"restoreState" : 4570,
								"isEOF" : 0,
								"invalidates" : 0,
								"dupsTested" : 64,
								"dupsDropped" : 0,
								"recordIdsForgotten" : 0,
								"inputStages" : [
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 64,
										"executionTimeMillisEstimate" : 11,
										"works" : 102,
										"advanced" : 64,
										"needTime" : 38,
										"needYield" : 0,
										"saveState" : 4570,
										"restoreState" : 4570,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 64,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 64,
											"executionTimeMillisEstimate" : 11,
											"works" : 102,
											"advanced" : 64,
											"needTime" : 38,
											"needYield" : 0,
											"saveState" : 4570,
											"restoreState" : 4570,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1,
												"PurchaseOrderLines.ProductID" : 1,
												"WarehouseID" : 1
											},
											"indexName" : "IX_Inventory",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ],
												"PurchaseOrderLines.ProductID" : [
													"PurchaseOrderLines"
												],
												"WarehouseID" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[MinKey, 18)",
													"(18, 181)",
													"(181, MaxKey]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[4, 4]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												],
												"PurchaseOrderLines.ProductID" : [
													"[MinKey, MaxKey]"
												],
												"WarehouseID" : [
													"[MinKey, MaxKey]"
												]
											},
											"keysExamined" : 102,
											"seeks" : 2,
											"dupsTested" : 101,
											"dupsDropped" : 37,
											"seenInvalidated" : 0
										}
									},
									{
										"stage" : "FETCH",
										"filter" : {
											"$and" : [
												{
													"$nor" : [
														{
															"TransactionID" : {
																"$in" : [
																	18,
																	181
																]
															}
														}
													]
												},
												{
													"PurchaseOrderLines.LedgerPostingStatus" : {
														"$eq" : null
													}
												}
											]
										},
										"nReturned" : 0,
										"executionTimeMillisEstimate" : 0,
										"works" : 0,
										"advanced" : 0,
										"needTime" : 0,
										"needYield" : 0,
										"saveState" : 4570,
										"restoreState" : 4570,
										"isEOF" : 0,
										"invalidates" : 0,
										"docsExamined" : 0,
										"alreadyHasObj" : 0,
										"inputStage" : {
											"stage" : "IXSCAN",
											"nReturned" : 0,
											"executionTimeMillisEstimate" : 0,
											"works" : 0,
											"advanced" : 0,
											"needTime" : 0,
											"needYield" : 0,
											"saveState" : 4570,
											"restoreState" : 4570,
											"isEOF" : 0,
											"invalidates" : 0,
											"keyPattern" : {
												"TransactionID" : 1,
												"PurchaseOrderLines.LedgerPostingStatus" : 1,
												"Status" : 1,
												"NowDate" : 1,
												"PurchaseOrderLines.ProductID" : 1,
												"WarehouseID" : 1
											},
											"indexName" : "IX_Inventory",
											"isMultiKey" : true,
											"multiKeyPaths" : {
												"TransactionID" : [ ],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"PurchaseOrderLines"
												],
												"Status" : [ ],
												"NowDate" : [ ],
												"PurchaseOrderLines.ProductID" : [
													"PurchaseOrderLines"
												],
												"WarehouseID" : [ ]
											},
											"isUnique" : false,
											"isSparse" : false,
											"isPartial" : false,
											"indexVersion" : 2,
											"direction" : "forward",
											"indexBounds" : {
												"TransactionID" : [
													"[16, 16]",
													"[116, 116]"
												],
												"PurchaseOrderLines.LedgerPostingStatus" : [
													"[null, null]"
												],
												"Status" : [
													"[MinKey, MaxKey]"
												],
												"NowDate" : [
													"[\"970701\", \"970708\"]"
												],
												"PurchaseOrderLines.ProductID" : [
													"[MinKey, MaxKey]"
												],
												"WarehouseID" : [
													"[MinKey, MaxKey]"
												]
											},
											"keysExamined" : 0,
											"seeks" : 0,
											"dupsTested" : 0,
											"dupsDropped" : 0,
											"seenInvalidated" : 0
										}
									}
								]
							}
						},
						{
							"nReturned" : 99,
							"executionTimeMillisEstimate" : 11,
							"totalKeysExamined" : 102,
							"totalDocsExamined" : 99,
							"executionStages" : {
								"stage" : "FETCH",
								"filter" : {
									"$and" : [
										{
											"$nor" : [
												{
													"TransactionID" : {
														"$in" : [
															18,
															181
														]
													}
												}
											]
										},
										{
											"PurchaseOrderLines.LedgerPostingStatus" : {
												"$eq" : null
											}
										},
										{
											"$or" : [
												{
													"Status" : {
														"$eq" : 4
													}
												},
												{
													"TransactionID" : {
														"$in" : [
															16,
															116
														]
													}
												}
											]
										}
									]
								},
								"nReturned" : 99,
								"executionTimeMillisEstimate" : 11,
								"works" : 102,
								"advanced" : 99,
								"needTime" : 3,
								"needYield" : 0,
								"saveState" : 4570,
								"restoreState" : 4570,
								"isEOF" : 0,
								"invalidates" : 0,
								"docsExamined" : 99,
								"alreadyHasObj" : 0,
								"inputStage" : {
									"stage" : "IXSCAN",
									"nReturned" : 99,
									"executionTimeMillisEstimate" : 0,
									"works" : 102,
									"advanced" : 99,
									"needTime" : 3,
									"needYield" : 0,
									"saveState" : 4570,
									"restoreState" : 4570,
									"isEOF" : 0,
									"invalidates" : 0,
									"keyPattern" : {
										"TransactionID" : 1,
										"PurchaseOrderLines.LedgerPostingStatus" : 1,
										"Status" : 1,
										"NowDate" : 1
									},
									"indexName" : "IX_Inventory_Where",
									"isMultiKey" : true,
									"multiKeyPaths" : {
										"TransactionID" : [ ],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"PurchaseOrderLines"
										],
										"Status" : [ ],
										"NowDate" : [ ]
									},
									"isUnique" : false,
									"isSparse" : false,
									"isPartial" : false,
									"indexVersion" : 2,
									"direction" : "forward",
									"indexBounds" : {
										"TransactionID" : [
											"[MinKey, 18)",
											"(18, 181)",
											"(181, MaxKey]"
										],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"[null, null]"
										],
										"Status" : [
											"[MinKey, MaxKey]"
										],
										"NowDate" : [
											"[\"970701\", \"970708\"]"
										]
									},
									"keysExamined" : 102,
									"seeks" : 4,
									"dupsTested" : 99,
									"dupsDropped" : 0,
									"seenInvalidated" : 0
								}
							}
						},
						{
							"nReturned" : 64,
							"executionTimeMillisEstimate" : 0,
							"totalKeysExamined" : 102,
							"totalDocsExamined" : 64,
							"executionStages" : {
								"stage" : "FETCH",
								"filter" : {
									"$and" : [
										{
											"$nor" : [
												{
													"TransactionID" : {
														"$in" : [
															18,
															181
														]
													}
												}
											]
										},
										{
											"PurchaseOrderLines.LedgerPostingStatus" : {
												"$eq" : null
											}
										},
										{
											"$or" : [
												{
													"Status" : {
														"$eq" : 4
													}
												},
												{
													"TransactionID" : {
														"$in" : [
															16,
															116
														]
													}
												}
											]
										}
									]
								},
								"nReturned" : 64,
								"executionTimeMillisEstimate" : 0,
								"works" : 102,
								"advanced" : 64,
								"needTime" : 38,
								"needYield" : 0,
								"saveState" : 4570,
								"restoreState" : 4570,
								"isEOF" : 0,
								"invalidates" : 0,
								"docsExamined" : 64,
								"alreadyHasObj" : 0,
								"inputStage" : {
									"stage" : "IXSCAN",
									"nReturned" : 64,
									"executionTimeMillisEstimate" : 0,
									"works" : 102,
									"advanced" : 64,
									"needTime" : 38,
									"needYield" : 0,
									"saveState" : 4570,
									"restoreState" : 4570,
									"isEOF" : 0,
									"invalidates" : 0,
									"keyPattern" : {
										"TransactionID" : 1,
										"PurchaseOrderLines.LedgerPostingStatus" : 1,
										"Status" : 1,
										"NowDate" : 1,
										"PurchaseOrderLines.ProductID" : 1,
										"WarehouseID" : 1
									},
									"indexName" : "IX_Inventory",
									"isMultiKey" : true,
									"multiKeyPaths" : {
										"TransactionID" : [ ],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"PurchaseOrderLines"
										],
										"Status" : [ ],
										"NowDate" : [ ],
										"PurchaseOrderLines.ProductID" : [
											"PurchaseOrderLines"
										],
										"WarehouseID" : [ ]
									},
									"isUnique" : false,
									"isSparse" : false,
									"isPartial" : false,
									"indexVersion" : 2,
									"direction" : "forward",
									"indexBounds" : {
										"TransactionID" : [
											"[MinKey, 18)",
											"(18, 181)",
											"(181, MaxKey]"
										],
										"PurchaseOrderLines.LedgerPostingStatus" : [
											"[null, null]"
										],
										"Status" : [
											"[MinKey, MaxKey]"
										],
										"NowDate" : [
											"[\"970701\", \"970708\"]"
										],
										"PurchaseOrderLines.ProductID" : [
											"[MinKey, MaxKey]"
										],
										"WarehouseID" : [
											"[MinKey, MaxKey]"
										]
									},
									"keysExamined" : 102,
									"seeks" : 4,
									"dupsTested" : 99,
									"dupsDropped" : 35,
									"seenInvalidated" : 0
								}
							}
						}
					]
				}
			}
		},
		{
			"$unwind" : {
				"path" : "$PurchaseOrderLines",
				"preserveNullAndEmptyArrays" : true
			}
		},
		{
			"$group" : {
				"_id" : {
					"WarehouseID" : "$WarehouseID",
					"PurchaseOrderLines_ProductID" : "$PurchaseOrderLines.ProductID",
					"WarehouseTypeID" : "$WarehouseTypeID"
				},
				"TotalReceivingQty" : {
					"$sum" : "$PurchaseOrderLines.ReceivingQty"
				},
				"TotalSendingQty" : {
					"$sum" : "$PurchaseOrderLines.SendingQty"
				}
			}
		},
		{
			"$addFields" : {
				"TotalQty" : {
					"$subtract" : [
						"$TotalReceivingQty",
						"$TotalSendingQty"
					]
				}
			}
		},
		{
			"$project" : {
				"_id" : true,
				"PurchaseOrderLines_ProductID" : "$_id.PurchaseOrderLines_ProductID",
				"TotalQty" : "$TotalQty",
				"WarehouseTypeID" : "$_id.WarehouseTypeID"
			}
		}
	],
	"ok" : 1
}