[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 1031 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48775_1 | E56E-4C8C-AA | PO10817145980 | 100 | 287 | 224 | 203 | 4 | 2023-04-25 | 15.56 | 0.39 | 2023-04-13 | 3 | 5.23 | 1 | 15.56 | 1 | SO48775 | 2023-04-20 | 1.24 | 15.69 | 5.19 | |||
SO61218_22 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 234 | 475 | 4 | 2024-04-24 | 299.94 | 7.50 | 2024-04-12 | 10 | 38.49 | 1 | 299.94 | 22 | SO61218 | 2024-04-19 | 24.00 | 384.92 | 29.99 | |||
SO47456_27 | 840E-4252-B7 | PO9715175233 | 100 | 283 | 365 | 490 | 4 | 2022-12-24 | 2591.98 | 64.80 | 2022-12-12 | 4 | 598.44 | 1 | 2591.98 | 27 | SO47456 | 2022-12-19 | 207.36 | 2393.74 | 647.99 | |||
SO46041_8 | FC6B-46A8-B4 | PO16762121494 | 100 | 282 | 324 | 259 | 4 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 8 | SO46041 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
SO44777_11 | CCD0-4777-A4 | PO3248124126 | 100 | 282 | 347 | 366 | 4 | 2022-03-25 | 8159.98 | 204.00 | 2022-03-13 | 4 | 1912.15 | 1 | 8159.98 | 11 | SO44777 | 2022-03-20 | 652.80 | 7648.62 | 2039.99 | |||
SO44281_1 | 13EE-4DFE-93 | PO18009181739 | 100 | 282 | 342 | 510 | 4 | 2022-01-23 | 419.46 | 10.49 | 2022-01-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO44281 | 2022-01-18 | 33.56 | 413.15 | 419.46 | |||
SO57168_32 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 477 | 436 | 4 | 2024-02-23 | 17.96 | 0.45 | 2024-02-11 | 6 | 1.87 | 1 | 17.96 | 32 | SO57168 | 2024-02-18 | 1.44 | 11.20 | 2.99 | |||
SO51845_27 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 533 | 312 | 4 | 2023-11-23 | 149.87 | 3.75 | 2023-11-11 | 1 | 136.79 | 1 | 149.87 | 27 | SO51845 | 2023-11-18 | 11.99 | 136.79 | 149.87 | |||
SO47676_3 | 5DD7-4A1E-9B | PO13659142296 | 100 | 272 | 399 | 437 | 4 | 2023-01-23 | 67.55 | 1.69 | 2023-01-11 | 2 | 24.99 | 1 | 67.55 | 3 | SO47676 | 2023-01-18 | 5.40 | 49.99 | 33.77 | |||
SO48313_1 | 5D5B-4BBC-AB | PO16182116781 | 100 | 287 | 233 | 23 | 4 | 2023-03-25 | 173.04 | 4.33 | 2023-03-13 | 6 | 29.08 | 1 | 173.04 | 1 | SO48313 | 2023-03-20 | 13.84 | 174.48 | 28.84 | |||
SO49541_6 | B736-4142-A1 | PO7569133326 | 100 | 287 | 470 | 608 | 4 | 2023-06-23 | 136.76 | 3.42 | 2023-06-11 | 6 | 15.67 | 1 | 136.76 | 6 | SO49541 | 2023-06-18 | 10.94 | 94.03 | 22.79 | |||
SO47400_24 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 454 | 133 | 4 | 2022-12-24 | 323.95 | 8.10 | 2022-12-12 | 9 | 24.75 | 1 | 323.95 | 24 | SO47400 | 2022-12-19 | 25.92 | 222.71 | 35.99 | |||
SO45531_1 | A56B-4056-BC | PO15950134053 | 100 | 282 | 315 | 114 | 4 | 2022-06-23 | 874.79 | 21.87 | 2022-06-11 | 1 | 884.71 | 1 | 874.79 | 1 | SO45531 | 2022-06-18 | 69.98 | 884.71 | 874.79 | |||
SO44776_2 | 289E-464B-BE | PO2697147596 | 100 | 282 | 349 | 187 | 4 | 2022-03-25 | 4049.99 | 101.25 | 2022-03-13 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO44776 | 2022-03-20 | 324.00 | 3796.19 | 2024.99 | |||
SO71902_14 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 587 | 61 | 4 | 2024-09-23 | 1385.08 | 34.63 | 2024-09-11 | 3 | 419.78 | 1 | 1385.08 | 14 | SO71902 | 2024-09-18 | 110.81 | 1259.34 | 461.69 | |||
SO55303_18 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 481 | 166 | 4 | 2024-01-23 | 16.18 | 0.40 | 2024-01-11 | 3 | 3.36 | 1 | 16.18 | 18 | SO55303 | 2024-01-18 | 1.29 | 10.09 | 5.39 | |||
SO50738_40 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 331 | 130 | 4 | 2023-09-23 | 939.59 | 23.49 | 2023-09-11 | 2 | 486.71 | 1 | 939.59 | 40 | SO50738 | 2023-09-18 | 75.17 | 973.41 | 469.79 | |||
SO53614_37 | A1C5-4C4D-9C | PO6757196330 | 100 | 281 | 511 | 21 | 4 | 2023-12-24 | 1310.72 | 32.77 | 2023-12-12 | 6 | 199.38 | 1 | 1310.72 | 37 | SO53614 | 2023-12-19 | 104.86 | 1196.25 | 218.45 | |||
SO47355_39 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 456 | 4 | 24 | 4 | 104.99 | 2022-12-24 | 1049.86 | 23.62 | 2022-12-12 | 28 | 30.93 | 1 | 944.87 | 39 | SO47355 | 2022-12-19 | 75.59 | 866.14 | 37.50 | 0.10 |
SO55322_12 | D600-436A-B7 | PO7859118281 | 100 | 287 | 487 | 221 | 4 | 2024-01-23 | 329.94 | 8.25 | 2024-01-11 | 10 | 20.57 | 1 | 329.94 | 12 | SO55322 | 2024-01-18 | 26.40 | 205.66 | 32.99 | |||
SO48295_6 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 447 | 24 | 4 | 2023-03-25 | 120.00 | 3.00 | 2023-03-13 | 8 | 10.31 | 1 | 120.00 | 6 | SO48295 | 2023-03-20 | 9.60 | 82.50 | 15.00 | |||
SO46648_18 | 2073-4051-9E | PO2494191557 | 100 | 283 | 394 | 184 | 4 | 2022-10-23 | 61.56 | 1.54 | 2022-10-11 | 3 | 15.18 | 1 | 61.56 | 18 | SO46648 | 2022-10-18 | 4.92 | 45.55 | 20.52 | |||
SO59049_3 | 7571-4CB5-B6 | PO174156394 | 100 | 282 | 545 | 277 | 4 | 2024-03-24 | 121.47 | 3.04 | 2024-03-12 | 5 | 17.98 | 1 | 121.47 | 3 | SO59049 | 2024-03-19 | 9.72 | 89.89 | 24.29 | |||
SO46341_13 | 7717-4086-86 | PO15138183971 | 100 | 283 | 317 | 93 | 4 | 2022-09-23 | 874.79 | 21.87 | 2022-09-11 | 1 | 884.71 | 1 | 874.79 | 13 | SO46341 | 2022-09-18 | 69.98 | 884.71 | 874.79 | |||
SO50313_25 | B452-44E9-91 | PO7656143984 | 100 | 282 | 377 | 403 | 4 | 2023-08-23 | 6544.69 | 163.62 | 2023-08-11 | 5 | 1320.68 | 1 | 6544.69 | 25 | SO50313 | 2023-08-18 | 523.58 | 6603.42 | 1308.94 | |||
SO59029_6 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 353 | 648 | 4 | 2024-03-24 | 2783.99 | 69.60 | 2024-03-12 | 2 | 1265.62 | 1 | 2783.99 | 6 | SO59029 | 2024-03-19 | 222.72 | 2531.24 | 1391.99 | |||
SO58907_40 | F365-4683-97 | PO19372175613 | 100 | 282 | 222 | 582 | 4 | 2024-03-24 | 20.99 | 0.52 | 2024-03-12 | 1 | 13.09 | 1 | 20.99 | 40 | SO58907 | 2024-03-19 | 1.68 | 13.09 | 20.99 | |||
SO59027_32 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 533 | 21 | 4 | 2024-03-24 | 749.37 | 18.73 | 2024-03-12 | 5 | 136.79 | 1 | 749.37 | 32 | SO59027 | 2024-03-19 | 59.95 | 683.93 | 149.87 | |||
SO46057_25 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 316 | 78 | 4 | 2022-08-23 | 5248.76 | 131.22 | 2022-08-11 | 6 | 884.71 | 1 | 5248.76 | 25 | SO46057 | 2022-08-18 | 419.90 | 5308.25 | 874.79 | |||
SO50672_19 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 271 | 239 | 4 | 2023-09-23 | 607.00 | 15.17 | 2023-09-11 | 3 | 187.16 | 1 | 607.00 | 19 | SO50672 | 2023-09-18 | 48.56 | 561.47 | 202.33 |
Generated 2024-11-11 02:15:09.230 UTC