[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2488 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48295_51 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 286 | 24 | 4 | 2023-02-02 | 551.81 | 13.80 | 2023-01-21 | 3 | 170.14 | 1 | 551.81 | 51 | SO48295 | 2023-01-28 | 44.15 | 510.43 | 183.94 | |||
SO48295_52 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 216 | 24 | 4 | 2023-02-02 | 161.49 | 4.04 | 2023-01-21 | 8 | 13.88 | 1 | 161.49 | 52 | SO48295 | 2023-01-28 | 12.92 | 111.03 | 20.19 | |||
SO48295_53 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 271 | 24 | 4 | 2023-02-02 | 1618.66 | 40.47 | 2023-01-21 | 8 | 187.16 | 1 | 1618.66 | 53 | SO48295 | 2023-01-28 | 129.49 | 1497.26 | 202.33 | |||
SO48295_54 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 254 | 24 | 4 | 2023-02-02 | 551.81 | 13.80 | 2023-01-21 | 3 | 170.14 | 1 | 551.81 | 54 | SO48295 | 2023-01-28 | 44.15 | 510.43 | 183.94 | |||
SO48295_55 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 462 | 24 | 4 | 2023-02-02 | 98.90 | 2.47 | 2023-01-21 | 7 | 9.71 | 1 | 98.90 | 55 | SO48295 | 2023-01-28 | 7.91 | 68.00 | 14.13 | |||
SO48295_56 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 224 | 3 | 24 | 4 | 4.04 | 2023-02-02 | 80.82 | 1.92 | 2023-01-21 | 17 | 5.23 | 1 | 76.78 | 56 | SO48295 | 2023-01-28 | 6.14 | 88.90 | 4.75 | 0.05 |
SO48302_1 | ECF7-4DC7-8D | PO18125158314 | 100 | 287 | 433 | 311 | 4 | 2023-02-02 | 324.45 | 8.11 | 2023-01-21 | 1 | 300.12 | 1 | 324.45 | 1 | SO48302 | 2023-01-28 | 25.96 | 300.12 | 324.45 | |||
SO48309_1 | 2F58-4438-98 | PO17226184242 | 100 | 283 | 325 | 561 | 4 | 2023-02-02 | 469.79 | 11.74 | 2023-01-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO48309 | 2023-01-28 | 37.58 | 486.71 | 469.79 | |||
SO45568_13 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 235 | 3 | 4 | 2022-05-03 | 28.84 | 0.72 | 2022-04-21 | 1 | 31.72 | 1 | 28.84 | 13 | SO45568 | 2022-04-28 | 2.31 | 31.72 | 28.84 | |||
SO45568_14 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 315 | 3 | 4 | 2022-05-03 | 4373.97 | 109.35 | 2022-04-21 | 5 | 884.71 | 1 | 4373.97 | 14 | SO45568 | 2022-04-28 | 349.92 | 4423.54 | 874.79 | |||
SO45568_15 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 317 | 3 | 4 | 2022-05-03 | 1749.59 | 43.74 | 2022-04-21 | 2 | 884.71 | 1 | 1749.59 | 15 | SO45568 | 2022-04-28 | 139.97 | 1769.42 | 874.79 | |||
SO45568_16 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 330 | 3 | 4 | 2022-05-03 | 419.46 | 10.49 | 2022-04-21 | 1 | 413.15 | 1 | 419.46 | 16 | SO45568 | 2022-04-28 | 33.56 | 413.15 | 419.46 | |||
SO45568_17 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 334 | 3 | 4 | 2022-05-03 | 419.46 | 10.49 | 2022-04-21 | 1 | 413.15 | 1 | 419.46 | 17 | SO45568 | 2022-04-28 | 33.56 | 413.15 | 419.46 | |||
SO45568_18 | 32F9-4A87-9D | PO6786144925 | 100 | 283 | 314 | 3 | 4 | 2022-05-03 | 4293.92 | 107.35 | 2022-04-21 | 2 | 2171.29 | 1 | 4293.92 | 18 | SO45568 | 2022-04-28 | 343.51 | 4342.59 | 2146.96 | |||
SO45571_1 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 344 | 608 | 4 | 2022-05-03 | 10199.97 | 255.00 | 2022-04-21 | 5 | 1912.15 | 1 | 10199.97 | 1 | SO45571 | 2022-04-28 | 816.00 | 9560.77 | 2039.99 | |||
SO45571_2 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 220 | 608 | 4 | 2022-05-03 | 80.75 | 2.02 | 2022-04-21 | 4 | 12.03 | 1 | 80.75 | 2 | SO45571 | 2022-04-28 | 6.46 | 48.11 | 20.19 | |||
SO45571_3 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 304 | 608 | 4 | 2022-05-03 | 2144.11 | 53.60 | 2022-04-21 | 3 | 617.03 | 1 | 2144.11 | 3 | SO45571 | 2022-04-28 | 171.53 | 1851.08 | 714.70 | |||
SO45571_4 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 292 | 608 | 4 | 2022-05-03 | 2456.10 | 61.40 | 2022-04-21 | 3 | 706.81 | 1 | 2456.10 | 4 | SO45571 | 2022-04-28 | 196.49 | 2120.43 | 818.70 | |||
SO45571_5 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 223 | 608 | 4 | 2022-05-03 | 15.56 | 0.39 | 2022-04-21 | 3 | 5.71 | 1 | 15.56 | 5 | SO45571 | 2022-04-28 | 1.24 | 17.12 | 5.19 | |||
SO45571_6 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 351 | 608 | 4 | 2022-05-03 | 4049.99 | 101.25 | 2022-04-21 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO45571 | 2022-04-28 | 324.00 | 3796.19 | 2024.99 | |||
SO45571_7 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 235 | 608 | 4 | 2022-05-03 | 28.84 | 0.72 | 2022-04-21 | 1 | 31.72 | 1 | 28.84 | 7 | SO45571 | 2022-04-28 | 2.31 | 31.72 | 28.84 | |||
SO45571_8 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 349 | 608 | 4 | 2022-05-03 | 10124.97 | 253.12 | 2022-04-21 | 5 | 1898.09 | 1 | 10124.97 | 8 | SO45571 | 2022-04-28 | 810.00 | 9490.47 | 2024.99 | |||
SO45571_9 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 293 | 608 | 4 | 2022-05-03 | 1445.19 | 36.13 | 2022-04-21 | 2 | 623.84 | 1 | 1445.19 | 9 | SO45571 | 2022-04-28 | 115.62 | 1247.68 | 722.59 | |||
SO45571_10 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 296 | 608 | 4 | 2022-05-03 | 2144.11 | 53.60 | 2022-04-21 | 3 | 617.03 | 1 | 2144.11 | 10 | SO45571 | 2022-04-28 | 171.53 | 1851.08 | 714.70 | |||
SO45571_11 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 232 | 608 | 4 | 2022-05-03 | 28.84 | 0.72 | 2022-04-21 | 1 | 31.72 | 1 | 28.84 | 11 | SO45571 | 2022-04-28 | 2.31 | 31.72 | 28.84 | |||
SO45571_12 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 348 | 608 | 4 | 2022-05-03 | 8099.98 | 202.50 | 2022-04-21 | 4 | 1898.09 | 1 | 8099.98 | 12 | SO45571 | 2022-04-28 | 648.00 | 7592.38 | 2024.99 | |||
SO45571_13 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 300 | 608 | 4 | 2022-05-03 | 2429.28 | 60.73 | 2022-04-21 | 3 | 699.09 | 1 | 2429.28 | 13 | SO45571 | 2022-04-28 | 194.34 | 2097.28 | 809.76 | |||
SO45571_14 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 215 | 608 | 4 | 2022-05-03 | 60.56 | 1.51 | 2022-04-21 | 3 | 12.03 | 1 | 60.56 | 14 | SO45571 | 2022-04-28 | 4.84 | 36.08 | 20.19 |
Generated 2024-09-20 11:28:43.160 UTC