[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2298 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59011_8 | CAAD-4857-B7 | PO6786194654 | 100 | 281 | 547 | 3 | 4 | 2024-02-02 | 48.59 | 1.21 | 2024-01-21 | 1 | 35.96 | 1 | 48.59 | 8 | SO59011 | 2024-01-28 | 3.89 | 35.96 | 48.59 | |||
SO48345_3 | 1E07-4139-96 | PO261145056 | 100 | 283 | 280 | 647 | 4 | 2023-02-02 | 183.94 | 4.60 | 2023-01-21 | 1 | 170.14 | 1 | 183.94 | 3 | SO48345 | 2023-01-28 | 14.72 | 170.14 | 183.94 | |||
SO57137_10 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 587 | 309 | 4 | 2024-01-03 | 461.69 | 11.54 | 2023-12-22 | 1 | 419.78 | 1 | 461.69 | 10 | SO57137 | 2023-12-29 | 36.94 | 419.78 | 461.69 | |||
SO50747_19 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 356 | 75 | 4 | 2023-08-03 | 3728.56 | 93.21 | 2023-07-22 | 3 | 1117.86 | 1 | 3728.56 | 19 | SO50747 | 2023-07-29 | 298.28 | 3353.57 | 1242.85 | |||
SO58975_8 | 1BCF-4E62-A9 | PO2697145020 | 100 | 282 | 551 | 187 | 4 | 2024-02-02 | 475.29 | 11.88 | 2024-01-21 | 3 | 144.59 | 1 | 475.29 | 8 | SO58975 | 2024-01-28 | 38.02 | 433.78 | 158.43 | |||
SO51844_4 | DE76-4481-AA | PO4553182082 | 100 | 282 | 214 | 313 | 4 | 2023-10-03 | 188.95 | 4.72 | 2023-09-21 | 9 | 13.09 | 1 | 188.95 | 4 | SO51844 | 2023-09-28 | 15.12 | 117.78 | 20.99 | |||
SO48056_5 | 5868-43E3-AD | PO4843164827 | 100 | 287 | 368 | 257 | 4 | 2023-01-03 | 8796.06 | 219.90 | 2022-12-22 | 6 | 1518.79 | 1 | 8796.06 | 5 | SO48056 | 2022-12-29 | 703.68 | 9112.72 | 1466.01 | |||
SO46362_11 | 0291-45A5-B2 | PO2697124986 | 100 | 282 | 345 | 7 | 187 | 4 | 1190.00 | 2022-08-03 | 3399.99 | 55.25 | 2022-07-22 | 4 | 1912.15 | 1 | 2209.99 | 11 | SO46362 | 2022-07-29 | 176.80 | 7648.62 | 850.00 | 0.35 |
SO51833_16 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 533 | 385 | 4 | 2023-10-03 | 449.62 | 11.24 | 2023-09-21 | 3 | 136.79 | 1 | 449.62 | 16 | SO51833 | 2023-09-28 | 35.97 | 410.36 | 149.87 | |||
SO50272_1 | E0A6-4CFA-90 | PO11745174916 | 100 | 282 | 335 | 97 | 4 | 2023-07-03 | 469.79 | 11.74 | 2023-06-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO50272 | 2023-06-28 | 37.58 | 486.71 | 469.79 | |||
SO45555_11 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 350 | 366 | 4 | 2022-05-03 | 4049.99 | 101.25 | 2022-04-21 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO45555 | 2022-04-28 | 324.00 | 3796.19 | 2024.99 | |||
SO45291_20 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 317 | 328 | 4 | 2022-04-05 | 3499.18 | 87.48 | 2022-03-24 | 4 | 884.71 | 1 | 3499.18 | 20 | SO45291 | 2022-03-31 | 279.93 | 3538.83 | 874.79 | |||
SO47039_13 | B548-493E-AE | PO5684166879 | 100 | 282 | 419 | 385 | 4 | 2022-10-03 | 105.29 | 2.63 | 2022-09-21 | 2 | 38.96 | 1 | 105.29 | 13 | SO47039 | 2022-09-28 | 8.42 | 77.92 | 52.65 | |||
SO49125_6 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 356 | 435 | 4 | 2023-04-05 | 2485.70 | 62.14 | 2023-03-24 | 2 | 1117.86 | 1 | 2485.70 | 6 | SO49125 | 2023-03-31 | 198.86 | 2235.71 | 1242.85 | |||
SO47417_17 | 1CE8-4651-A9 | PO2697165938 | 100 | 282 | 428 | 187 | 4 | 2022-11-03 | 418.51 | 10.46 | 2022-10-22 | 2 | 185.82 | 1 | 418.51 | 17 | SO47417 | 2022-10-29 | 33.48 | 371.64 | 209.26 | |||
SO48384_20 | C99C-4AEC-9E | PO7569115185 | 100 | 287 | 354 | 608 | 4 | 2023-02-02 | 7457.11 | 186.43 | 2023-01-21 | 6 | 1117.86 | 1 | 7457.11 | 20 | SO48384 | 2023-01-28 | 596.57 | 6707.14 | 1242.85 | |||
SO51867_2 | 101F-4E15-BF | PO7279141150 | 100 | 281 | 575 | 399 | 4 | 2023-10-03 | 4291.33 | 107.28 | 2023-09-21 | 3 | 1481.94 | 1 | 4291.33 | 2 | SO51867 | 2023-09-28 | 343.31 | 4445.81 | 1430.44 | |||
SO45332_2 | AD0B-49A0-A5 | PO6351110306 | 100 | 283 | 322 | 255 | 4 | 2022-04-05 | 838.92 | 20.97 | 2022-03-24 | 2 | 413.15 | 1 | 838.92 | 2 | SO45332 | 2022-03-31 | 67.11 | 826.29 | 419.46 | |||
SO44093_18 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 229 | 93 | 4 | 2021-11-03 | 86.52 | 2.16 | 2021-10-22 | 3 | 31.72 | 1 | 86.52 | 18 | SO44093 | 2021-10-29 | 6.92 | 95.17 | 28.84 | |||
SO53546_28 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 243 | 624 | 4 | 2023-11-03 | 858.90 | 21.47 | 2023-10-22 | 1 | 868.63 | 1 | 858.90 | 28 | SO53546 | 2023-10-29 | 68.71 | 868.63 | 858.90 | |||
SO53546_21 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 386 | 624 | 4 | 2023-11-03 | 672.29 | 16.81 | 2023-10-22 | 1 | 713.08 | 1 | 672.29 | 21 | SO53546 | 2023-10-29 | 53.78 | 713.08 | 672.29 | |||
SO51121_36 | 9E4C-40B6-B1 | PO10730114575 | 100 | 287 | 418 | 491 | 4 | 2023-09-02 | 1070.69 | 26.77 | 2023-08-21 | 3 | 360.94 | 1 | 1070.69 | 36 | SO51121 | 2023-08-28 | 85.66 | 1082.83 | 356.90 | |||
SO69409_5 | 09C5-4089-8B | PO16762188016 | 100 | 282 | 547 | 259 | 4 | 2024-07-03 | 97.19 | 2.43 | 2024-06-21 | 2 | 35.96 | 1 | 97.19 | 5 | SO69409 | 2024-06-28 | 7.78 | 71.92 | 48.59 | |||
SO47027_26 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 286 | 436 | 4 | 2022-10-03 | 551.81 | 13.80 | 2022-09-21 | 3 | 170.14 | 1 | 551.81 | 26 | SO47027 | 2022-09-28 | 44.15 | 510.43 | 183.94 | |||
SO49533_7 | 5895-4BD4-A3 | PO5597155395 | 100 | 281 | 216 | 75 | 4 | 2023-05-03 | 161.49 | 4.04 | 2023-04-21 | 8 | 13.88 | 1 | 161.49 | 7 | SO49533 | 2023-04-28 | 12.92 | 111.03 | 20.19 | |||
SO67298_23 | F9FB-4B4C-92 | PO2755196827 | 100 | 282 | 561 | 205 | 4 | 2024-06-03 | 10013.09 | 250.33 | 2024-05-22 | 7 | 1481.94 | 1 | 10013.09 | 23 | SO67298 | 2024-05-29 | 801.05 | 10373.57 | 1430.44 | |||
SO71787_14 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 492 | 509 | 4 | 2024-08-03 | 602.35 | 15.06 | 2024-07-22 | 1 | 601.74 | 1 | 602.35 | 14 | SO71787 | 2024-07-29 | 48.19 | 601.74 | 602.35 | |||
SO44509_6 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 332 | 328 | 4 | 2022-01-03 | 838.92 | 20.97 | 2021-12-22 | 2 | 413.15 | 1 | 838.92 | 6 | SO44509 | 2021-12-29 | 67.11 | 826.29 | 419.46 | |||
SO71783_15 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 386 | 24 | 4 | 2024-08-03 | 672.29 | 16.81 | 2024-07-22 | 1 | 713.08 | 1 | 672.29 | 15 | SO71783 | 2024-07-29 | 53.78 | 713.08 | 672.29 | |||
SO44521_11 | E46D-4692-AC | PO12557171689 | 100 | 282 | 275 | 240 | 4 | 2022-01-03 | 356.90 | 8.92 | 2021-12-22 | 1 | 352.14 | 1 | 356.90 | 11 | SO44521 | 2021-12-29 | 28.55 | 352.14 | 356.90 |
Generated 2024-09-20 09:26:48.086 UTC