[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 159 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63252_26 | 4233-41A9-B7 | PO6438150148 | 100 | 281 | 400 | 309 | 4 | 2024-05-25 | 37.15 | 0.93 | 2024-05-13 | 1 | 27.49 | 1 | 37.15 | 26 | SO63252 | 2024-05-20 | 2.97 | 27.49 | 37.15 | |||
SO65157_20 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 491 | 582 | 4 | 2024-06-23 | 226.76 | 5.67 | 2024-06-11 | 7 | 41.57 | 1 | 226.76 | 20 | SO65157 | 2024-06-18 | 18.14 | 291.01 | 32.39 | |||
SO47018_19 | E622-43B1-98 | PO2523197473 | 100 | 287 | 341 | 167 | 4 | 2022-11-23 | 4228.15 | 105.70 | 2022-11-11 | 9 | 486.71 | 1 | 4228.15 | 19 | SO47018 | 2022-11-18 | 338.25 | 4380.36 | 469.79 | |||
SO47712_26 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 414 | 166 | 4 | 2023-01-23 | 298.06 | 7.45 | 2023-01-11 | 2 | 110.28 | 1 | 298.06 | 26 | SO47712 | 2023-01-18 | 23.85 | 220.57 | 149.03 | |||
SO46988_3 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 439 | 78 | 4 | 2022-11-23 | 780.82 | 19.52 | 2022-11-11 | 1 | 722.26 | 1 | 780.82 | 3 | SO46988 | 2022-11-18 | 62.47 | 722.26 | 780.82 | |||
SO47687_40 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 230 | 203 | 4 | 2023-01-23 | 28.84 | 0.72 | 2023-01-11 | 1 | 29.08 | 1 | 28.84 | 40 | SO47687 | 2023-01-18 | 2.31 | 29.08 | 28.84 | |||
SO51126_21 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 570 | 13 | 205 | 4 | 300.65 | 2023-10-23 | 2004.35 | 42.59 | 2023-10-11 | 6 | 461.44 | 1 | 1703.69 | 21 | SO51126 | 2023-10-18 | 136.30 | 2768.67 | 334.06 | 0.15 |
SO44095_8 | 97A5-4FCA-88 | PO14964184959 | 100 | 287 | 307 | 581 | 4 | 2021-12-24 | 722.59 | 18.06 | 2021-12-12 | 1 | 623.84 | 1 | 722.59 | 8 | SO44095 | 2021-12-19 | 57.81 | 623.84 | 722.59 | |||
SO67273_36 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 555 | 475 | 4 | 2024-07-24 | 191.70 | 4.79 | 2024-07-12 | 3 | 47.29 | 1 | 191.70 | 36 | SO67273 | 2024-07-19 | 15.34 | 141.86 | 63.90 | |||
SO47990_21 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 389 | 328 | 4 | 2023-02-23 | 2401.05 | 60.03 | 2023-02-11 | 4 | 605.65 | 1 | 2401.05 | 21 | SO47990 | 2023-02-18 | 192.08 | 2422.60 | 600.26 | |||
SO51722_23 | 735D-4C32-A1 | PO15196144426 | 100 | 282 | 408 | 258 | 4 | 2023-11-23 | 72.16 | 1.80 | 2023-11-11 | 1 | 53.40 | 1 | 72.16 | 23 | SO51722 | 2023-11-18 | 5.77 | 53.40 | 72.16 | |||
SO71782_5 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 484 | 582 | 4 | 2024-09-23 | 47.70 | 1.19 | 2024-09-11 | 10 | 2.97 | 1 | 47.70 | 5 | SO71782 | 2024-09-18 | 3.82 | 29.73 | 4.77 | |||
SO45060_5 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 338 | 203 | 4 | 2022-04-25 | 419.46 | 10.49 | 2022-04-13 | 1 | 413.15 | 1 | 419.46 | 5 | SO45060 | 2022-04-20 | 33.56 | 413.15 | 419.46 | |||
SO50282_12 | 9C0C-42E0-B6 | PO6525160235 | 100 | 281 | 469 | 345 | 4 | 2023-08-23 | 45.59 | 1.14 | 2023-08-11 | 2 | 15.67 | 1 | 45.59 | 12 | SO50282 | 2023-08-18 | 3.65 | 31.34 | 22.79 | |||
SO46988_2 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 422 | 78 | 4 | 2022-11-23 | 202.62 | 5.07 | 2022-11-11 | 3 | 49.98 | 1 | 202.62 | 2 | SO46988 | 2022-11-18 | 16.21 | 149.94 | 67.54 | |||
SO47439_41 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 224 | 3 | 4 | 2022-12-24 | 20.75 | 0.52 | 2022-12-12 | 4 | 5.23 | 1 | 20.75 | 41 | SO47439 | 2022-12-19 | 1.66 | 20.92 | 5.19 | |||
SO45060_10 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 223 | 203 | 4 | 2022-04-25 | 15.56 | 0.39 | 2022-04-13 | 3 | 5.71 | 1 | 15.56 | 10 | SO45060 | 2022-04-20 | 1.24 | 17.12 | 5.19 | |||
SO45332_6 | AD0B-49A0-A5 | PO6351110306 | 100 | 283 | 340 | 255 | 4 | 2022-05-26 | 838.92 | 20.97 | 2022-05-14 | 2 | 413.15 | 1 | 838.92 | 6 | SO45332 | 2022-05-21 | 67.11 | 826.29 | 419.46 | |||
SO47438_7 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 365 | 21 | 4 | 2022-12-24 | 1295.99 | 32.40 | 2022-12-12 | 2 | 598.44 | 1 | 1295.99 | 7 | SO47438 | 2022-12-19 | 103.68 | 1196.87 | 647.99 | |||
SO61178_1 | 7FDF-4C47-A4 | PO18009130007 | 100 | 282 | 382 | 510 | 4 | 2024-04-24 | 672.29 | 16.81 | 2024-04-12 | 1 | 713.08 | 1 | 672.29 | 1 | SO61178 | 2024-04-19 | 53.78 | 713.08 | 672.29 | |||
SO59023_2 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 476 | 61 | 4 | 2024-03-24 | 293.96 | 7.35 | 2024-03-12 | 7 | 26.18 | 1 | 293.96 | 2 | SO59023 | 2024-03-19 | 23.52 | 183.23 | 41.99 | |||
SO61227_8 | 9006-4208-8F | PO10730172247 | 100 | 287 | 388 | 491 | 4 | 2024-04-24 | 1344.59 | 33.61 | 2024-04-12 | 2 | 713.08 | 1 | 1344.59 | 8 | SO61227 | 2024-04-19 | 107.57 | 1426.16 | 672.29 | |||
SO50214_10 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 321 | 258 | 4 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 10 | SO50214 | 2023-08-18 | 37.58 | 486.71 | 469.79 | |||
SO55265_13 | D45F-41FE-9B | PO10237157039 | 100 | 287 | 605 | 41 | 4 | 2024-01-23 | 1295.98 | 32.40 | 2024-01-11 | 4 | 343.65 | 1 | 1295.98 | 13 | SO55265 | 2024-01-18 | 103.68 | 1374.60 | 323.99 | |||
SO50208_37 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 329 | 328 | 4 | 2023-08-23 | 2348.97 | 58.72 | 2023-08-11 | 5 | 486.71 | 1 | 2348.97 | 37 | SO50208 | 2023-08-18 | 187.92 | 2433.53 | 469.79 | |||
SO49086_12 | DC81-474D-82 | PO15196160156 | 100 | 282 | 339 | 258 | 4 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 12 | SO49086 | 2023-05-21 | 37.58 | 486.71 | 469.79 | |||
SO49821_25 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 286 | 4 | 4 | 2023-07-24 | 1103.63 | 27.59 | 2023-07-12 | 6 | 170.14 | 1 | 1103.63 | 25 | SO49821 | 2023-07-19 | 88.29 | 1020.86 | 183.94 | |||
SO65269_14 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 593 | 648 | 4 | 2024-06-23 | 338.99 | 8.47 | 2024-06-11 | 1 | 308.22 | 1 | 338.99 | 14 | SO65269 | 2024-06-18 | 27.12 | 308.22 | 338.99 | |||
SO48758_39 | 709A-4AE0-B1 | PO13688180139 | 100 | 282 | 410 | 475 | 4 | 2023-04-25 | 36.45 | 0.91 | 2023-04-13 | 1 | 26.97 | 1 | 36.45 | 39 | SO48758 | 2023-04-20 | 2.92 | 26.97 | 36.45 | |||
SO50313_39 | B452-44E9-91 | PO7656143984 | 100 | 282 | 230 | 403 | 4 | 2023-08-23 | 86.52 | 2.16 | 2023-08-11 | 3 | 29.08 | 1 | 86.52 | 39 | SO50313 | 2023-08-18 | 6.92 | 87.24 | 28.84 |
Generated 2024-11-10 09:08:14.994 UTC