[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 3000 SHUFFLE < SKIP 126 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48355_1 | 435B-438A-85 | PO2233163873 | 19 | 291 | 233 | 262 | 6 | 2023-03-25 | 28.84 | 0.72 | 2023-03-13 | 1 | 29.08 | 1 | 28.84 | 1 | SO48355 | 2023-03-20 | 2.31 | 29.08 | 28.84 | |||
SO45294_7 | 2F48-482E-A9 | PO14500175708 | 100 | 282 | 351 | 650 | 1 | 2022-05-26 | 2024.99 | 50.62 | 2022-05-14 | 1 | 1898.09 | 1 | 2024.99 | 7 | SO45294 | 2022-05-21 | 162.00 | 1898.09 | 2024.99 | |||
SO65172_12 | B28D-458D-90 | PO17371161505 | 6 | 296 | 563 | 688 | 9 | 2024-06-23 | 1430.44 | 35.76 | 2024-06-11 | 1 | 1481.94 | 1 | 1430.44 | 12 | SO65172 | 2024-06-18 | 114.44 | 1481.94 | 1430.44 | |||
SO53451_2 | 5401-4E4D-93 | PO58117793 | 100 | 293 | 560 | 595 | 1 | 2023-12-24 | 1457.82 | 36.45 | 2023-12-12 | 2 | 755.15 | 1 | 1457.82 | 2 | SO53451 | 2023-12-19 | 116.63 | 1510.30 | 728.91 | |||
SO50191_26 | 1DDA-4B5A-95 | PO19546193423 | 100 | 285 | 433 | 206 | 5 | 2023-08-23 | 324.45 | 8.11 | 2023-08-11 | 1 | 300.12 | 1 | 324.45 | 26 | SO50191 | 2023-08-18 | 25.96 | 300.12 | 324.45 | |||
SO63179_29 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 558 | 535 | 7 | 2024-05-25 | 242.99 | 6.07 | 2024-05-13 | 1 | 179.82 | 1 | 242.99 | 29 | SO63179 | 2024-05-20 | 19.44 | 179.82 | 242.99 | |||
SO57105_11 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 353 | 2 | 697 | 1 | 349.85 | 2024-02-23 | 17492.72 | 428.57 | 2024-02-11 | 13 | 1265.62 | 1 | 17142.87 | 11 | SO57105 | 2024-02-18 | 1371.43 | 16453.05 | 1345.59 | 0.02 |
SO46036_2 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 332 | 558 | 2 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 2 | SO46036 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
SO48005_55 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 373 | 638 | 7 | 2023-02-23 | 9162.56 | 229.06 | 2023-02-11 | 7 | 1320.68 | 1 | 9162.56 | 55 | SO48005 | 2023-02-18 | 733.01 | 9244.79 | 1308.94 | |||
SO59008_11 | 4EE7-43A3-A6 | PO5713164207 | 98 | 288 | 586 | 52 | 10 | 2024-03-24 | 890.82 | 22.27 | 2024-03-12 | 2 | 461.44 | 1 | 890.82 | 11 | SO59008 | 2024-03-19 | 71.27 | 922.89 | 445.41 | |||
SO57179_7 | 93FD-457E-8A | PO8584112874 | 98 | 288 | 481 | 592 | 10 | 2024-02-23 | 10.79 | 0.27 | 2024-02-11 | 2 | 3.36 | 1 | 10.79 | 7 | SO57179 | 2024-02-18 | 0.86 | 6.72 | 5.39 | |||
SO49862_7 | 61B7-41AA-B2 | PO14355148051 | 98 | 288 | 323 | 286 | 10 | 2023-07-24 | 1409.38 | 35.23 | 2023-07-12 | 3 | 486.71 | 1 | 1409.38 | 7 | SO49862 | 2023-07-19 | 112.75 | 1460.12 | 469.79 | |||
SO50252_44 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 230 | 167 | 4 | 2023-08-23 | 144.20 | 3.61 | 2023-08-11 | 5 | 29.08 | 1 | 144.20 | 44 | SO50252 | 2023-08-18 | 11.54 | 145.40 | 28.84 | |||
SO51778_13 | 420A-4268-A8 | PO3161175221 | 100 | 283 | 481 | 359 | 2 | 2023-11-23 | 21.58 | 0.54 | 2023-11-11 | 4 | 3.36 | 1 | 21.58 | 13 | SO51778 | 2023-11-18 | 1.73 | 13.45 | 5.39 | |||
SO57054_28 | 8D1A-4AF0-91 | PO13456189029 | 36 | 292 | 492 | 614 | 7 | 2024-02-23 | 1204.69 | 30.12 | 2024-02-11 | 2 | 601.74 | 1 | 1204.69 | 28 | SO57054 | 2024-02-18 | 96.38 | 1203.49 | 602.35 | |||
SO63153_9 | 9812-4AF8-8C | PO15080177922 | 100 | 292 | 564 | 283 | 7 | 2024-05-25 | 1430.44 | 35.76 | 2024-05-13 | 1 | 1481.94 | 1 | 1430.44 | 9 | SO63153 | 2024-05-20 | 114.44 | 1481.94 | 1430.44 | |||
SO46941_8 | 2B71-4F52-B5 | PO18821148265 | 36 | 292 | 420 | 686 | 7 | 2022-11-23 | 141.62 | 3.54 | 2022-11-11 | 1 | 104.80 | 1 | 141.62 | 8 | SO46941 | 2022-11-18 | 11.33 | 104.80 | 141.62 | |||
SO53605_11 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 561 | 14 | 308 | 1 | 1144.35 | 2023-12-24 | 5721.77 | 114.44 | 2023-12-12 | 6 | 1481.94 | 1 | 4577.41 | 11 | SO53605 | 2023-12-19 | 366.19 | 8891.63 | 953.63 | 0.20 |
SO48751_23 | 1B86-4985-89 | PO13775132235 | 100 | 283 | 375 | 618 | 2 | 2023-04-25 | 2617.88 | 65.45 | 2023-04-13 | 2 | 1320.68 | 1 | 2617.88 | 23 | SO48751 | 2023-04-20 | 209.43 | 2641.37 | 1308.94 | |||
SO71812_17 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 552 | 293 | 1 | 2024-09-23 | 219.58 | 5.49 | 2024-09-11 | 4 | 40.62 | 1 | 219.58 | 17 | SO71812 | 2024-09-18 | 17.57 | 162.49 | 54.89 | |||
SO65168_8 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 571 | 509 | 4 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 8 | SO65168 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO50292_21 | E329-4164-85 | PO3654177485 | 100 | 281 | 470 | 435 | 4 | 2023-08-23 | 68.38 | 1.71 | 2023-08-11 | 3 | 15.67 | 1 | 68.38 | 21 | SO50292 | 2023-08-18 | 5.47 | 47.01 | 22.79 | |||
SO48077_30 | 02FD-483D-8C | PO7453110437 | 100 | 281 | 265 | 108 | 2 | 2023-02-23 | 202.33 | 5.06 | 2023-02-11 | 1 | 187.16 | 1 | 202.33 | 30 | SO48077 | 2023-02-18 | 16.19 | 187.16 | 202.33 | |||
SO47359_24 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 354 | 118 | 6 | 2022-12-24 | 3728.56 | 93.21 | 2022-12-12 | 3 | 1117.86 | 1 | 3728.56 | 24 | SO47359 | 2022-12-19 | 298.28 | 3353.57 | 1242.85 | |||
SO53471_21 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 382 | 306 | 3 | 2023-12-24 | 1344.59 | 33.61 | 2023-12-12 | 2 | 713.08 | 1 | 1344.59 | 21 | SO53471 | 2023-12-19 | 107.57 | 1426.16 | 672.29 | |||
SO46051_8 | DF61-462A-87 | PO14500186228 | 100 | 282 | 304 | 650 | 1 | 2022-08-23 | 714.70 | 17.87 | 2022-08-11 | 1 | 617.03 | 1 | 714.70 | 8 | SO46051 | 2022-08-18 | 57.18 | 617.03 | 714.70 | |||
SO50662_13 | 2ABC-4DD7-A1 | PO19604139855 | 98 | 288 | 360 | 340 | 10 | 2023-09-23 | 2458.92 | 61.47 | 2023-09-11 | 2 | 1105.81 | 1 | 2458.92 | 13 | SO50662 | 2023-09-18 | 196.71 | 2211.62 | 1229.46 | |||
SO45268_2 | 2C70-4779-BC | PO19430121252 | 19 | 284 | 322 | 318 | 6 | 2022-05-26 | 419.46 | 10.49 | 2022-05-14 | 1 | 413.15 | 1 | 419.46 | 2 | SO45268 | 2022-05-21 | 33.56 | 413.15 | 419.46 | |||
SO46055_23 | DDC5-498B-87 | PO13572168536 | 100 | 287 | 334 | 527 | 3 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 23 | SO46055 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
SO48754_15 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 421 | 442 | 6 | 2023-04-25 | 588.99 | 14.72 | 2023-04-13 | 3 | 145.28 | 1 | 588.99 | 15 | SO48754 | 2023-04-20 | 47.12 | 435.85 | 196.33 |
Generated 2024-11-10 11:43:06.166 UTC