[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 SHUFFLE < SKIP 876 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50252_35 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 373 | 167 | 4 | 2023-07-03 | 5235.75 | 130.89 | 2023-06-21 | 4 | 1320.68 | 1 | 5235.75 | 35 | SO50252 | 2023-06-28 | 418.86 | 5282.74 | 1308.94 | |||
SO45341_9 | AA2C-4A41-AD | PO7830178569 | 100 | 283 | 346 | 40 | 4 | 2022-04-05 | 8159.98 | 204.00 | 2022-03-24 | 4 | 1912.15 | 1 | 8159.98 | 9 | SO45341 | 2022-03-31 | 652.80 | 7648.62 | 2039.99 | |||
SO46642_17 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 389 | 4 | 4 | 2022-09-02 | 3001.31 | 75.03 | 2022-08-21 | 5 | 605.65 | 1 | 3001.31 | 17 | SO46642 | 2022-08-28 | 240.11 | 3028.25 | 600.26 | |||
SO63261_6 | 47AD-4561-92 | PO2320130718 | 100 | 282 | 418 | 529 | 4 | 2024-04-04 | 356.90 | 8.92 | 2024-03-23 | 1 | 360.94 | 1 | 356.90 | 6 | SO63261 | 2024-03-30 | 28.55 | 360.94 | 356.90 | |||
SO51154_40 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 580 | 221 | 4 | 2023-09-02 | 4082.38 | 102.06 | 2023-08-21 | 4 | 1082.51 | 1 | 4082.38 | 40 | SO51154 | 2023-08-28 | 326.59 | 4330.04 | 1020.59 | |||
SO57134_22 | 040D-4B73-AD | PO6351190175 | 100 | 281 | 388 | 255 | 4 | 2024-01-03 | 1344.59 | 33.61 | 2023-12-22 | 2 | 713.08 | 1 | 1344.59 | 22 | SO57134 | 2023-12-29 | 107.57 | 1426.16 | 672.29 | |||
SO49515_5 | 52D0-4584-BC | PO9715144044 | 100 | 281 | 294 | 490 | 4 | 2023-05-03 | 2977.09 | 74.43 | 2023-04-21 | 4 | 660.91 | 1 | 2977.09 | 5 | SO49515 | 2023-04-28 | 238.17 | 2643.66 | 744.27 | |||
SO47692_4 | F786-4312-9B | PO10237186654 | 100 | 287 | 224 | 41 | 4 | 2022-12-03 | 10.37 | 0.26 | 2022-11-21 | 2 | 5.23 | 1 | 10.37 | 4 | SO47692 | 2022-11-28 | 0.83 | 10.46 | 5.19 | |||
SO47435_33 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 468 | 75 | 4 | 2022-11-03 | 45.59 | 1.14 | 2022-10-22 | 2 | 15.67 | 1 | 45.59 | 33 | SO47435 | 2022-10-29 | 3.65 | 31.34 | 22.79 | |||
SO51154_47 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 487 | 221 | 4 | 2023-09-02 | 263.95 | 6.60 | 2023-08-21 | 8 | 20.57 | 1 | 263.95 | 47 | SO51154 | 2023-08-28 | 21.12 | 164.53 | 32.99 | |||
SO51855_42 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 481 | 436 | 4 | 2023-10-03 | 48.55 | 1.21 | 2023-09-21 | 9 | 3.36 | 1 | 48.55 | 42 | SO51855 | 2023-09-28 | 3.88 | 30.26 | 5.39 | |||
SO69512_1 | 8A04-4DD5-89 | PO7279111263 | 100 | 281 | 566 | 399 | 4 | 2024-07-03 | 1336.23 | 33.41 | 2024-06-21 | 3 | 461.44 | 1 | 1336.23 | 1 | SO69512 | 2024-06-28 | 106.90 | 1384.33 | 445.41 | |||
SO47431_3 | 6368-404E-A7 | PO4582126105 | 100 | 282 | 460 | 25 | 4 | 2022-11-03 | 53.99 | 1.35 | 2022-10-22 | 1 | 37.12 | 1 | 53.99 | 3 | SO47431 | 2022-10-29 | 4.32 | 37.12 | 53.99 | |||
SO44092_2 | 6AE1-4759-B9 | PO15167143312 | 100 | 283 | 332 | 273 | 4 | 2021-11-03 | 419.46 | 10.49 | 2021-10-22 | 1 | 413.15 | 1 | 419.46 | 2 | SO44092 | 2021-10-29 | 33.56 | 413.15 | 419.46 | |||
SO51809_1 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 488 | 309 | 4 | 2023-10-03 | 194.36 | 4.86 | 2023-09-21 | 6 | 41.57 | 1 | 194.36 | 1 | SO51809 | 2023-09-28 | 15.55 | 249.43 | 32.39 | |||
SO67279_21 | 5395-4C5C-A0 | PO12528190770 | 100 | 282 | 569 | 331 | 4 | 2024-06-03 | 1781.64 | 44.54 | 2024-05-22 | 4 | 461.44 | 1 | 1781.64 | 21 | SO67279 | 2024-05-29 | 142.53 | 1845.78 | 445.41 | |||
SO48049_3 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 360 | 312 | 4 | 2023-01-03 | 6147.29 | 153.68 | 2022-12-22 | 5 | 1105.81 | 1 | 6147.29 | 3 | SO48049 | 2022-12-29 | 491.78 | 5529.05 | 1229.46 | |||
SO50749_8 | 4BD9-4D6C-83 | PO6757115716 | 100 | 281 | 360 | 21 | 4 | 2023-08-03 | 1229.46 | 30.74 | 2023-07-22 | 1 | 1105.81 | 1 | 1229.46 | 8 | SO50749 | 2023-07-29 | 98.36 | 1105.81 | 1229.46 | |||
SO53621_50 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 474 | 4 | 490 | 4 | 87.49 | 2023-11-03 | 874.88 | 19.68 | 2023-10-22 | 25 | 26.18 | 1 | 787.39 | 50 | SO53621 | 2023-10-29 | 62.99 | 654.41 | 35.00 | 0.10 |
SO46988_2 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 422 | 78 | 4 | 2022-10-03 | 202.62 | 5.07 | 2022-09-21 | 3 | 49.98 | 1 | 202.62 | 2 | SO46988 | 2022-09-28 | 16.21 | 149.94 | 67.54 | |||
SO50313_48 | B452-44E9-91 | PO7656143984 | 100 | 282 | 323 | 403 | 4 | 2023-07-03 | 939.59 | 23.49 | 2023-06-21 | 2 | 486.71 | 1 | 939.59 | 48 | SO50313 | 2023-06-28 | 75.17 | 973.41 | 469.79 | |||
SO71858_10 | 32BA-49C8-8B | PO16153112278 | 100 | 282 | 552 | 186 | 4 | 2024-08-03 | 54.89 | 1.37 | 2024-07-22 | 1 | 40.62 | 1 | 54.89 | 10 | SO71858 | 2024-07-29 | 4.39 | 40.62 | 54.89 | |||
SO47712_23 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 375 | 166 | 4 | 2022-12-03 | 5235.75 | 130.89 | 2022-11-21 | 4 | 1320.68 | 1 | 5235.75 | 23 | SO47712 | 2022-11-28 | 418.86 | 5282.74 | 1308.94 | |||
SO51106_17 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 574 | 331 | 4 | 2023-09-02 | 2860.88 | 71.52 | 2023-08-21 | 2 | 1481.94 | 1 | 2860.88 | 17 | SO51106 | 2023-08-28 | 228.87 | 2963.88 | 1430.44 | |||
SO58909_36 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 287 | 24 | 4 | 2024-02-02 | 607.00 | 15.17 | 2024-01-21 | 3 | 204.63 | 1 | 607.00 | 36 | SO58909 | 2024-01-28 | 48.56 | 613.88 | 202.33 | |||
SO57145_29 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 552 | 435 | 4 | 2024-01-03 | 164.68 | 4.12 | 2023-12-22 | 3 | 40.62 | 1 | 164.68 | 29 | SO57145 | 2023-12-29 | 13.17 | 121.86 | 54.89 | |||
SO45328_9 | 2212-4E8E-82 | PO5684113284 | 100 | 282 | 344 | 385 | 4 | 2022-04-05 | 8159.98 | 204.00 | 2022-03-24 | 4 | 1912.15 | 1 | 8159.98 | 9 | SO45328 | 2022-03-31 | 652.80 | 7648.62 | 2039.99 | |||
SO51154_12 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 484 | 3 | 221 | 4 | 3.50 | 2023-09-02 | 69.96 | 1.66 | 2023-08-21 | 16 | 2.97 | 1 | 66.46 | 12 | SO51154 | 2023-08-28 | 5.32 | 47.57 | 4.37 | 0.05 |
SO49831_37 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 308 | 475 | 4 | 2023-06-03 | 744.27 | 18.61 | 2023-05-22 | 1 | 660.91 | 1 | 744.27 | 37 | SO49831 | 2023-05-29 | 59.54 | 660.91 | 744.27 | |||
SO45060_2 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 328 | 203 | 4 | 2022-03-05 | 419.46 | 10.49 | 2022-02-21 | 1 | 413.15 | 1 | 419.46 | 2 | SO45060 | 2022-02-28 | 33.56 | 413.15 | 419.46 | |||
SO48311_33 | AAD7-4EBC-A1 | PO16472177233 | 100 | 287 | 383 | 239 | 4 | 2023-02-02 | 600.26 | 15.01 | 2023-01-21 | 1 | 605.65 | 1 | 600.26 | 33 | SO48311 | 2023-01-28 | 48.02 | 605.65 | 600.26 |
Generated 2024-09-20 13:26:35.583 UTC