[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2312 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46093_11 | B221-4D2A-99 | PO6351171482 | 100 | 283 | 310 | 255 | 4 | 2022-07-02 | 2146.96 | 53.67 | 2022-06-20 | 1 | 2171.29 | 1 | 2146.96 | 11 | SO46093 | 2022-06-27 | 171.76 | 2171.29 | 2146.96 | |||
SO51809_43 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 593 | 309 | 4 | 2023-10-02 | 338.99 | 8.47 | 2023-09-20 | 1 | 308.22 | 1 | 338.99 | 43 | SO51809 | 2023-09-27 | 27.12 | 308.22 | 338.99 | |||
SO45811_1 | C0A1-43C4-AE | PO6409111249 | 100 | 283 | 328 | 292 | 4 | 2022-06-02 | 419.46 | 10.49 | 2022-05-21 | 1 | 413.15 | 1 | 419.46 | 1 | SO45811 | 2022-05-28 | 33.56 | 413.15 | 419.46 | |||
SO63262_8 | 3368-4317-8F | PO6351144702 | 100 | 281 | 388 | 255 | 4 | 2024-04-03 | 1344.59 | 33.61 | 2024-03-22 | 2 | 713.08 | 1 | 1344.59 | 8 | SO63262 | 2024-03-29 | 107.57 | 1426.16 | 672.29 | |||
SO45813_15 | 36A5-446C-96 | PO7859120230 | 100 | 287 | 332 | 221 | 4 | 2022-06-02 | 3355.67 | 83.89 | 2022-05-21 | 8 | 413.15 | 1 | 3355.67 | 15 | SO45813 | 2022-05-28 | 268.45 | 3305.17 | 419.46 | |||
SO47720_24 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 456 | 2 | 221 | 4 | 9.57 | 2022-12-02 | 478.44 | 11.72 | 2022-11-20 | 11 | 30.93 | 1 | 468.87 | 24 | SO47720 | 2022-11-27 | 37.51 | 340.27 | 43.49 | 0.02 |
SO48043_4 | BA6F-4F1F-B7 | PO2523167437 | 100 | 287 | 331 | 167 | 4 | 2023-01-02 | 3288.56 | 82.21 | 2022-12-21 | 7 | 486.71 | 1 | 3288.56 | 4 | SO48043 | 2022-12-28 | 263.08 | 3406.95 | 469.79 | |||
SO51121_46 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 222 | 11 | 491 | 4 | 16.53 | 2023-09-01 | 110.22 | 2.34 | 2023-08-20 | 7 | 13.09 | 1 | 93.69 | 46 | SO51121 | 2023-08-27 | 7.49 | 91.60 | 15.75 | 0.15 |
SO51090_37 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 593 | 475 | 4 | 2023-09-01 | 338.99 | 8.47 | 2023-08-20 | 1 | 308.22 | 1 | 338.99 | 37 | SO51090 | 2023-08-27 | 27.12 | 308.22 | 338.99 | |||
SO50252_17 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 286 | 167 | 4 | 2023-07-02 | 735.75 | 18.39 | 2023-06-20 | 4 | 170.14 | 1 | 735.75 | 17 | SO50252 | 2023-06-27 | 58.86 | 680.57 | 183.94 | |||
SO44783_14 | 8DE2-4684-BC | PO4640171635 | 100 | 287 | 345 | 648 | 4 | 2022-02-01 | 4079.99 | 102.00 | 2022-01-20 | 2 | 1912.15 | 1 | 4079.99 | 14 | SO44783 | 2022-01-27 | 326.40 | 3824.31 | 2039.99 | |||
SO65269_10 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 476 | 648 | 4 | 2024-05-02 | 419.94 | 10.50 | 2024-04-20 | 10 | 26.18 | 1 | 419.94 | 10 | SO65269 | 2024-04-27 | 33.60 | 261.76 | 41.99 | |||
SO48769_4 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 331 | 221 | 4 | 2023-03-04 | 1409.38 | 35.23 | 2023-02-20 | 3 | 486.71 | 1 | 1409.38 | 4 | SO48769 | 2023-02-27 | 112.75 | 1460.12 | 469.79 | |||
SO59029_5 | E358-40C0-B2 | PO4640116818 | 100 | 287 | 513 | 648 | 4 | 2024-02-01 | 218.45 | 5.46 | 2024-01-20 | 1 | 199.38 | 1 | 218.45 | 5 | SO59029 | 2024-01-27 | 17.48 | 199.38 | 218.45 | |||
SO51809_25 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 234 | 309 | 4 | 2023-10-02 | 239.95 | 6.00 | 2023-09-20 | 8 | 38.49 | 1 | 239.95 | 25 | SO51809 | 2023-09-27 | 19.20 | 307.94 | 29.99 | |||
SO44755_21 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 272 | 273 | 4 | 2022-02-01 | 183.94 | 4.60 | 2022-01-20 | 1 | 181.49 | 1 | 183.94 | 21 | SO44755 | 2022-01-27 | 14.72 | 181.49 | 183.94 | |||
SO67292_3 | 09EF-4688-BB | PO551144976 | 100 | 281 | 386 | 4 | 4 | 2024-06-02 | 2689.18 | 67.23 | 2024-05-21 | 4 | 713.08 | 1 | 2689.18 | 3 | SO67292 | 2024-05-28 | 215.13 | 2852.32 | 672.29 | |||
SO47990_21 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 389 | 328 | 4 | 2023-01-02 | 2401.05 | 60.03 | 2022-12-21 | 4 | 605.65 | 1 | 2401.05 | 21 | SO47990 | 2022-12-28 | 192.08 | 2422.60 | 600.26 | |||
SO69515_4 | D9C1-4837-A7 | PO6351170694 | 100 | 281 | 584 | 255 | 4 | 2024-07-02 | 323.99 | 8.10 | 2024-06-20 | 1 | 343.65 | 1 | 323.99 | 4 | SO69515 | 2024-06-27 | 25.92 | 343.65 | 323.99 | |||
SO47027_47 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 415 | 436 | 4 | 2022-10-02 | 990.18 | 24.75 | 2022-09-20 | 5 | 146.55 | 1 | 990.18 | 47 | SO47027 | 2022-09-27 | 79.21 | 732.73 | 198.04 | |||
SO50289_2 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 343 | 436 | 4 | 2023-07-02 | 2818.76 | 70.47 | 2023-06-20 | 6 | 486.71 | 1 | 2818.76 | 2 | SO50289 | 2023-06-27 | 225.50 | 2920.24 | 469.79 | |||
SO51827_12 | B106-4221-AD | PO4611117026 | 100 | 287 | 502 | 131 | 4 | 2023-10-02 | 200.05 | 5.00 | 2023-09-20 | 1 | 199.85 | 1 | 200.05 | 12 | SO51827 | 2023-09-27 | 16.00 | 199.85 | 200.05 | |||
SO53476_4 | BF5A-472F-98 | PO16153121709 | 100 | 282 | 555 | 186 | 4 | 2023-11-02 | 127.80 | 3.20 | 2023-10-21 | 2 | 47.29 | 1 | 127.80 | 4 | SO53476 | 2023-10-28 | 10.22 | 94.57 | 63.90 | |||
SO46648_39 | 2073-4051-9E | PO2494191557 | 100 | 283 | 362 | 184 | 4 | 2022-09-01 | 3688.38 | 92.21 | 2022-08-20 | 3 | 1105.81 | 1 | 3688.38 | 39 | SO46648 | 2022-08-27 | 295.07 | 3317.43 | 1229.46 | |||
SO71783_17 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 467 | 24 | 4 | 2024-08-02 | 132.25 | 3.31 | 2024-07-21 | 9 | 9.16 | 1 | 132.25 | 17 | SO71783 | 2024-07-28 | 10.58 | 82.43 | 14.69 | |||
SO50289_33 | 0809-4DE4-93 | PO3480117331 | 100 | 281 | 339 | 436 | 4 | 2023-07-02 | 2348.97 | 58.72 | 2023-06-20 | 5 | 486.71 | 1 | 2348.97 | 33 | SO50289 | 2023-06-27 | 187.92 | 2433.53 | 469.79 | |||
SO49152_15 | 52FC-4E8F-B0 | PO6525119586 | 100 | 272 | 393 | 345 | 4 | 2023-04-04 | 413.08 | 10.33 | 2023-03-23 | 3 | 101.89 | 1 | 413.08 | 15 | SO49152 | 2023-03-30 | 33.05 | 305.68 | 137.69 | |||
SO49884_12 | 822A-428D-94 | PO5626129805 | 100 | 281 | 286 | 166 | 4 | 2023-06-02 | 551.81 | 13.80 | 2023-05-21 | 3 | 170.14 | 1 | 551.81 | 12 | SO49884 | 2023-05-28 | 44.15 | 510.43 | 183.94 | |||
SO47355_20 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 415 | 24 | 4 | 2022-11-02 | 792.14 | 19.80 | 2022-10-21 | 4 | 146.55 | 1 | 792.14 | 20 | SO47355 | 2022-10-28 | 63.37 | 586.19 | 198.04 | |||
SO46041_1 | FC6B-46A8-B4 | PO16762121494 | 100 | 282 | 223 | 259 | 4 | 2022-07-02 | 15.56 | 0.39 | 2022-06-20 | 3 | 5.71 | 1 | 15.56 | 1 | SO46041 | 2022-06-27 | 1.24 | 17.12 | 5.19 | |||
SO47700_34 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 358 | 184 | 4 | 2022-12-02 | 6147.29 | 153.68 | 2022-11-20 | 5 | 1105.81 | 1 | 6147.29 | 34 | SO47700 | 2022-11-27 | 491.78 | 5529.05 | 1229.46 |
Generated 2024-09-19 23:36:29.797 UTC