[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 504 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59029_1 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 517 | 648 | 4 | 2024-02-02 | 94.75 | 2.37 | 2024-01-21 | 3 | 23.37 | 1 | 94.75 | 1 | SO59029 | 2024-01-28 | 7.58 | 70.12 | 31.58 | |||
SO46970_3 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 371 | 258 | 4 | 2022-10-03 | 6544.69 | 163.62 | 2022-09-21 | 5 | 1320.68 | 1 | 6544.69 | 3 | SO46970 | 2022-09-28 | 523.58 | 6603.42 | 1308.94 | |||
SO49104_9 | 7F8C-4702-BB | PO11745119484 | 100 | 282 | 335 | 97 | 4 | 2023-04-05 | 1409.38 | 35.23 | 2023-03-24 | 3 | 486.71 | 1 | 1409.38 | 9 | SO49104 | 2023-03-31 | 112.75 | 1460.12 | 469.79 | |||
SO47027_48 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 407 | 436 | 4 | 2022-10-03 | 262.41 | 6.56 | 2022-09-21 | 4 | 48.55 | 1 | 262.41 | 48 | SO47027 | 2022-09-28 | 20.99 | 194.18 | 65.60 | |||
SO48378_1 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 216 | 3 | 4 | 2023-02-02 | 161.49 | 4.04 | 2023-01-21 | 8 | 13.88 | 1 | 161.49 | 1 | SO48378 | 2023-01-28 | 12.92 | 111.03 | 20.19 | |||
SO51714_40 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 488 | 328 | 4 | 2023-10-03 | 259.15 | 6.48 | 2023-09-21 | 8 | 41.57 | 1 | 259.15 | 40 | SO51714 | 2023-09-28 | 20.73 | 332.58 | 32.39 | |||
SO45046_2 | C2BD-43A4-90 | PO14413152179 | 100 | 287 | 326 | 383 | 4 | 2022-03-05 | 419.46 | 10.49 | 2022-02-21 | 1 | 413.15 | 1 | 419.46 | 2 | SO45046 | 2022-02-28 | 33.56 | 413.15 | 419.46 | |||
SO47355_14 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 257 | 24 | 4 | 2022-11-03 | 919.69 | 22.99 | 2022-10-22 | 5 | 170.14 | 1 | 919.69 | 14 | SO47355 | 2022-10-29 | 73.58 | 850.71 | 183.94 | |||
SO49127_15 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 387 | 436 | 4 | 2023-04-05 | 4802.10 | 120.05 | 2023-03-24 | 8 | 605.65 | 1 | 4802.10 | 15 | SO49127 | 2023-03-31 | 384.17 | 4845.19 | 600.26 | |||
SO61184_40 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 493 | 599 | 4 | 2024-03-04 | 400.10 | 10.00 | 2024-02-21 | 2 | 199.85 | 1 | 400.10 | 40 | SO61184 | 2024-02-28 | 32.01 | 399.70 | 200.05 | |||
SO45070_14 | B035-4728-8C | PO5626126979 | 100 | 283 | 319 | 166 | 4 | 2022-03-05 | 3499.18 | 87.48 | 2022-02-21 | 4 | 884.71 | 1 | 3499.18 | 14 | SO45070 | 2022-02-28 | 279.93 | 3538.83 | 874.79 | |||
SO44557_14 | 2D19-4C49-B1 | PO6351122593 | 100 | 283 | 340 | 255 | 4 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 14 | SO44557 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO49160_19 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 373 | 403 | 4 | 2023-04-05 | 2617.88 | 65.45 | 2023-03-24 | 2 | 1320.68 | 1 | 2617.88 | 19 | SO49160 | 2023-03-31 | 209.43 | 2641.37 | 1308.94 | |||
SO51153_31 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 580 | 2 | 166 | 4 | 276.24 | 2023-09-02 | 13812.04 | 338.40 | 2023-08-21 | 14 | 1082.51 | 1 | 13535.80 | 31 | SO51153 | 2023-08-28 | 1082.86 | 15155.14 | 986.57 | 0.02 |
SO58909_22 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 472 | 24 | 4 | 2024-02-02 | 152.40 | 3.81 | 2024-01-21 | 4 | 23.75 | 1 | 152.40 | 22 | SO58909 | 2024-01-28 | 12.19 | 95.00 | 38.10 | |||
SO49841_11 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 379 | 203 | 4 | 2023-06-03 | 6544.69 | 163.62 | 2023-05-22 | 5 | 1320.68 | 1 | 6544.69 | 11 | SO49841 | 2023-05-29 | 523.58 | 6603.42 | 1308.94 | |||
SO50753_23 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 395 | 608 | 4 | 2023-08-03 | 368.24 | 9.21 | 2023-07-22 | 6 | 45.42 | 1 | 368.24 | 23 | SO50753 | 2023-07-29 | 29.46 | 272.50 | 61.37 | |||
SO45784_2 | 8A7A-4D84-B4 | PO16008186765 | 100 | 282 | 324 | 511 | 4 | 2022-06-03 | 419.46 | 10.49 | 2022-05-22 | 1 | 413.15 | 1 | 419.46 | 2 | SO45784 | 2022-05-29 | 33.56 | 413.15 | 419.46 | |||
SO49151_6 | D25B-462C-8C | PO6438151235 | 100 | 281 | 453 | 309 | 4 | 2023-04-05 | 107.98 | 2.70 | 2023-03-24 | 3 | 24.75 | 1 | 107.98 | 6 | SO49151 | 2023-03-31 | 8.64 | 74.24 | 35.99 | |||
SO47024_13 | F254-4053-A3 | PO3654136382 | 100 | 283 | 468 | 435 | 4 | 2022-10-03 | 22.79 | 0.57 | 2022-09-21 | 1 | 15.67 | 1 | 22.79 | 13 | SO47024 | 2022-09-28 | 1.82 | 15.67 | 22.79 | |||
SO53580_7 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 594 | 648 | 4 | 2023-11-03 | 1016.98 | 25.42 | 2023-10-22 | 3 | 308.22 | 1 | 1016.98 | 7 | SO53580 | 2023-10-29 | 81.36 | 924.65 | 338.99 | |||
SO44314_3 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 332 | 166 | 4 | 2021-12-03 | 1677.84 | 41.95 | 2021-11-21 | 4 | 413.15 | 1 | 1677.84 | 3 | SO44314 | 2021-11-28 | 134.23 | 1652.59 | 419.46 | |||
SO48769_14 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 230 | 221 | 4 | 2023-03-05 | 115.36 | 2.88 | 2023-02-21 | 4 | 29.08 | 1 | 115.36 | 14 | SO48769 | 2023-02-28 | 9.23 | 116.32 | 28.84 | |||
SO47049_11 | 3D73-4468-AE | PO6525111066 | 100 | 283 | 470 | 345 | 4 | 2022-10-03 | 159.56 | 3.99 | 2022-09-21 | 7 | 15.67 | 1 | 159.56 | 11 | SO47049 | 2022-09-28 | 12.76 | 109.70 | 22.79 | |||
SO57035_13 | CD56-4460-9B | PO15921199440 | 100 | 287 | 471 | 77 | 4 | 2024-01-03 | 152.40 | 3.81 | 2023-12-22 | 4 | 23.75 | 1 | 152.40 | 13 | SO57035 | 2023-12-29 | 12.19 | 95.00 | 38.10 | |||
SO47018_51 | E622-43B1-98 | PO2523197473 | 100 | 287 | 414 | 167 | 4 | 2022-10-03 | 894.19 | 22.35 | 2022-09-21 | 6 | 110.28 | 1 | 894.19 | 51 | SO47018 | 2022-09-28 | 71.53 | 661.70 | 149.03 | |||
SO48012_15 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 377 | 78 | 4 | 2023-01-03 | 5235.75 | 130.89 | 2022-12-22 | 4 | 1320.68 | 1 | 5235.75 | 15 | SO48012 | 2022-12-29 | 418.86 | 5282.74 | 1308.94 | |||
SO53583_10 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 524 | 75 | 4 | 2023-11-03 | 633.72 | 15.84 | 2023-10-22 | 4 | 144.59 | 1 | 633.72 | 10 | SO53583 | 2023-10-29 | 50.70 | 578.38 | 158.43 | |||
SO48384_8 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 360 | 608 | 4 | 2023-02-02 | 7376.75 | 184.42 | 2023-01-21 | 6 | 1105.81 | 1 | 7376.75 | 8 | SO48384 | 2023-01-28 | 590.14 | 6634.86 | 1229.46 | |||
SO44768_8 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 322 | 647 | 4 | 2022-02-02 | 1258.38 | 31.46 | 2022-01-21 | 3 | 413.15 | 1 | 1258.38 | 8 | SO44768 | 2022-01-28 | 100.67 | 1239.44 | 419.46 | |||
SO47712_30 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 389 | 166 | 4 | 2022-12-03 | 6002.63 | 150.07 | 2022-11-21 | 10 | 605.65 | 1 | 6002.63 | 30 | SO47712 | 2022-11-28 | 480.21 | 6056.49 | 600.26 |
Generated 2024-09-20 13:30:06.893 UTC