[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE SKIP 0 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51096_10 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 243 | 514 | 6 | 2023-09-18 | 858.90 | 21.47 | 2023-09-06 | 1 | 868.63 | 1 | 858.90 | 10 | SO51096 | 2023-09-13 | 68.71 | 868.63 | 858.90 | |||
SO50213_10 | E565-4331-83 | PO15370194449 | 100 | 281 | 410 | 381 | 3 | 2023-07-19 | 109.34 | 2.73 | 2023-07-07 | 3 | 26.97 | 1 | 109.34 | 10 | SO50213 | 2023-07-14 | 8.75 | 80.91 | 36.45 | |||
SO49873_1 | A549-4EA5-9F | PO10179180935 | 100 | 285 | 358 | 27 | 5 | 2023-06-19 | 1229.46 | 30.74 | 2023-06-07 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO49873 | 2023-06-14 | 98.36 | 1105.81 | 1229.46 | |||
SO51770_13 | 9F77-4259-BE | PO1769187686 | 100 | 283 | 545 | 540 | 2 | 2023-10-19 | 97.18 | 2.43 | 2023-10-07 | 4 | 17.98 | 1 | 97.18 | 13 | SO51770 | 2023-10-14 | 7.77 | 71.91 | 24.29 | |||
SO61177_6 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 516 | 442 | 6 | 2024-03-20 | 46.97 | 1.17 | 2024-03-08 | 2 | 17.38 | 1 | 46.97 | 6 | SO61177 | 2024-03-15 | 3.76 | 34.76 | 23.48 | |||
SO63180_9 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 372 | 167 | 4 | 2024-04-20 | 2932.02 | 73.30 | 2024-04-08 | 2 | 1554.95 | 1 | 2932.02 | 9 | SO63180 | 2024-04-15 | 234.56 | 3109.90 | 1466.01 | |||
SO45076_1 | 4F79-4FD4-98 | PO9657156121 | 100 | 285 | 345 | 315 | 5 | 2022-03-21 | 4079.99 | 102.00 | 2022-03-09 | 2 | 1912.15 | 1 | 4079.99 | 1 | SO45076 | 2022-03-16 | 326.40 | 3824.31 | 2039.99 | |||
SO71798_6 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 481 | 306 | 3 | 2024-08-19 | 43.15 | 1.08 | 2024-08-07 | 8 | 3.36 | 1 | 43.15 | 6 | SO71798 | 2024-08-14 | 3.45 | 26.90 | 5.39 | |||
SO47001_28 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 257 | 684 | 2 | 2022-10-19 | 919.69 | 22.99 | 2022-10-07 | 5 | 170.14 | 1 | 919.69 | 28 | SO47001 | 2022-10-14 | 73.58 | 850.71 | 183.94 | |||
SO48004_29 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 368 | 527 | 3 | 2023-01-19 | 2932.02 | 73.30 | 2023-01-07 | 2 | 1518.79 | 1 | 2932.02 | 29 | SO48004 | 2023-01-14 | 234.56 | 3037.57 | 1466.01 | |||
SO58951_28 | 96F8-470F-9B | PO11397163065 | 36 | 295 | 544 | 176 | 8 | 2024-02-18 | 194.38 | 4.86 | 2024-02-06 | 4 | 35.96 | 1 | 194.38 | 28 | SO58951 | 2024-02-13 | 15.55 | 143.84 | 48.59 | |||
SO46355_18 | D579-4B15-AB | PO261195016 | 100 | 283 | 232 | 647 | 4 | 2022-08-19 | 144.20 | 3.61 | 2022-08-07 | 5 | 31.72 | 1 | 144.20 | 18 | SO46355 | 2022-08-14 | 11.54 | 158.62 | 28.84 | |||
SO44527_1 | 68F6-4911-A4 | PO10469169045 | 19 | 288 | 218 | 335 | 6 | 2022-01-19 | 17.10 | 0.43 | 2022-01-07 | 3 | 3.40 | 1 | 17.10 | 1 | SO44527 | 2022-01-14 | 1.37 | 10.19 | 5.70 | |||
SO57046_40 | 52CC-460F-B3 | PO14500161818 | 100 | 282 | 514 | 650 | 1 | 2024-01-19 | 127.80 | 3.20 | 2024-01-07 | 2 | 47.29 | 1 | 127.80 | 40 | SO57046 | 2024-01-14 | 10.22 | 94.57 | 63.90 | |||
SO46638_17 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 335 | 203 | 4 | 2022-09-18 | 469.79 | 11.74 | 2022-09-06 | 1 | 486.71 | 1 | 469.79 | 17 | SO46638 | 2022-09-13 | 37.58 | 486.71 | 469.79 | |||
SO48750_21 | 9A71-449E-B6 | PO14732147398 | 19 | 291 | 333 | 514 | 6 | 2023-03-21 | 2818.76 | 70.47 | 2023-03-09 | 6 | 486.71 | 1 | 2818.76 | 21 | SO48750 | 2023-03-16 | 225.50 | 2920.24 | 469.79 | |||
SO65322_6 | 841D-45EE-9F | PO8903163985 | 100 | 293 | 583 | 235 | 1 | 2024-05-19 | 2041.19 | 51.03 | 2024-05-07 | 2 | 1082.51 | 1 | 2041.19 | 6 | SO65322 | 2024-05-14 | 163.30 | 2165.02 | 1020.59 | |||
SO47996_19 | B6EA-4582-9E | PO15370152849 | 100 | 283 | 360 | 381 | 3 | 2023-01-19 | 6147.29 | 153.68 | 2023-01-07 | 5 | 1105.81 | 1 | 6147.29 | 19 | SO47996 | 2023-01-14 | 491.78 | 5529.05 | 1229.46 | |||
SO47410_14 | E1AD-4918-86 | PO1450182394 | 100 | 292 | 470 | 571 | 7 | 2022-11-19 | 182.35 | 4.56 | 2022-11-07 | 8 | 15.67 | 1 | 182.35 | 14 | SO47410 | 2022-11-14 | 14.59 | 125.37 | 22.79 | |||
SO47008_29 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 369 | 426 | 6 | 2022-10-19 | 4398.03 | 109.95 | 2022-10-07 | 3 | 1518.79 | 1 | 4398.03 | 29 | SO47008 | 2022-10-14 | 351.84 | 4556.36 | 1466.01 | |||
SO50756_27 | C414-447C-84 | PO9570119689 | 100 | 285 | 401 | 585 | 5 | 2023-08-19 | 131.20 | 3.28 | 2023-08-07 | 2 | 48.55 | 1 | 131.20 | 27 | SO50756 | 2023-08-14 | 10.50 | 97.09 | 65.60 | |||
SO46988_55 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 245 | 78 | 4 | 2022-10-19 | 1561.64 | 39.04 | 2022-10-07 | 2 | 722.26 | 1 | 1561.64 | 55 | SO46988 | 2022-10-14 | 124.93 | 1444.51 | 780.82 | |||
SO50192_12 | A5BA-4696-96 | PO19227162823 | 19 | 284 | 333 | 210 | 6 | 2023-07-19 | 469.79 | 11.74 | 2023-07-07 | 1 | 486.71 | 1 | 469.79 | 12 | SO50192 | 2023-07-14 | 37.58 | 486.71 | 469.79 | |||
SO49100_5 | BD42-4470-A8 | PO17603154869 | 19 | 284 | 456 | 12 | 6 | 2023-04-21 | 134.98 | 3.37 | 2023-04-09 | 3 | 30.93 | 1 | 134.98 | 5 | SO49100 | 2023-04-16 | 10.80 | 92.80 | 44.99 | |||
SO46629_23 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 373 | 670 | 3 | 2022-09-18 | 5235.75 | 130.89 | 2022-09-06 | 4 | 1320.68 | 1 | 5235.75 | 23 | SO46629 | 2022-09-13 | 418.86 | 5282.74 | 1308.94 | |||
SO59018_15 | F605-4DA0-8F | PO8033148787 | 6 | 296 | 400 | 15 | 9 | 2024-02-18 | 185.76 | 4.64 | 2024-02-06 | 5 | 27.49 | 1 | 185.76 | 15 | SO59018 | 2024-02-13 | 14.86 | 137.46 | 37.15 | |||
SO69536_6 | 9646-48B3-9E | PO3654177498 | 100 | 281 | 306 | 435 | 4 | 2024-07-19 | 1619.52 | 40.49 | 2024-07-07 | 2 | 739.04 | 1 | 1619.52 | 6 | SO69536 | 2024-07-14 | 129.56 | 1478.08 | 809.76 | |||
SO49521_26 | 48A5-48F5-80 | PO8671117542 | 98 | 288 | 428 | 502 | 10 | 2023-05-19 | 837.02 | 20.93 | 2023-05-07 | 4 | 185.82 | 1 | 837.02 | 26 | SO49521 | 2023-05-14 | 66.96 | 743.28 | 209.26 | |||
SO47435_40 | B7A7-4F07-94 | PO5597154214 | 100 | 283 | 399 | 75 | 4 | 2022-11-19 | 202.65 | 5.07 | 2022-11-07 | 6 | 24.99 | 1 | 202.65 | 40 | SO47435 | 2022-11-14 | 16.21 | 149.96 | 33.77 | |||
SO47997_7 | 2B6D-4DAC-9A | PO14558139554 | 100 | 289 | 470 | 2 | 2 | 1 | 5.29 | 2023-01-19 | 264.41 | 6.48 | 2023-01-07 | 12 | 15.67 | 1 | 259.12 | 7 | SO47997 | 2023-01-14 | 20.73 | 188.05 | 22.03 | 0.02 |
SO65157_9 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 575 | 582 | 4 | 2024-05-19 | 2860.88 | 71.52 | 2024-05-07 | 2 | 1481.94 | 1 | 2860.88 | 9 | SO65157 | 2024-05-14 | 228.87 | 2963.88 | 1430.44 | |||
SO47395_37 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 213 | 72 | 2 | 2022-11-19 | 80.75 | 2.02 | 2022-11-07 | 4 | 13.88 | 1 | 80.75 | 37 | SO47395 | 2022-11-14 | 6.46 | 55.51 | 20.19 | |||
SO65180_1 | B9CA-46FC-B0 | PO16182138917 | 100 | 287 | 474 | 23 | 4 | 2024-05-19 | 251.96 | 6.30 | 2024-05-07 | 6 | 26.18 | 1 | 251.96 | 1 | SO65180 | 2024-05-14 | 20.16 | 157.06 | 41.99 | |||
SO46358_13 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 264 | 579 | 3 | 2022-08-19 | 367.88 | 9.20 | 2022-08-07 | 2 | 181.49 | 1 | 367.88 | 13 | SO46358 | 2022-08-14 | 29.43 | 362.97 | 183.94 | |||
SO50314_23 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 323 | 433 | 1 | 2023-07-19 | 1879.18 | 46.98 | 2023-07-07 | 4 | 486.71 | 1 | 1879.18 | 23 | SO50314 | 2023-07-14 | 150.33 | 1946.83 | 469.79 | |||
SO47413_12 | E274-4280-9B | PO1885161774 | 19 | 284 | 419 | 588 | 6 | 2022-11-19 | 52.65 | 1.32 | 2022-11-07 | 1 | 38.96 | 1 | 52.65 | 12 | SO47413 | 2022-11-14 | 4.21 | 38.96 | 52.65 | |||
SO51771_30 | F78B-4D68-8E | PO1508157846 | 98 | 288 | 382 | 430 | 10 | 2023-10-19 | 1344.59 | 33.61 | 2023-10-07 | 2 | 713.08 | 1 | 1344.59 | 30 | SO51771 | 2023-10-14 | 107.57 | 1426.16 | 672.29 | |||
SO55264_1 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 477 | 491 | 4 | 2023-12-19 | 11.98 | 0.30 | 2023-12-07 | 4 | 1.87 | 1 | 11.98 | 1 | SO55264 | 2023-12-14 | 0.96 | 7.47 | 2.99 | |||
SO48745_12 | CDB4-4FFB-87 | PO2494111050 | 100 | 281 | 233 | 184 | 4 | 2023-03-21 | 173.04 | 4.33 | 2023-03-09 | 6 | 29.08 | 1 | 173.04 | 12 | SO48745 | 2023-03-16 | 13.84 | 174.48 | 28.84 | |||
SO51800_1 | A082-4BC8-96 | PO14181145795 | 100 | 293 | 400 | 307 | 1 | 2023-10-19 | 37.15 | 0.93 | 2023-10-07 | 1 | 27.49 | 1 | 37.15 | 1 | SO51800 | 2023-10-14 | 2.97 | 27.49 | 37.15 | |||
SO49523_26 | 852E-47A8-A9 | PO3915144057 | 100 | 281 | 373 | 130 | 4 | 2023-05-19 | 1308.94 | 32.72 | 2023-05-07 | 1 | 1320.68 | 1 | 1308.94 | 26 | SO49523 | 2023-05-14 | 104.72 | 1320.68 | 1308.94 | |||
SO50214_31 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 369 | 258 | 4 | 2023-07-19 | 5864.04 | 146.60 | 2023-07-07 | 4 | 1518.79 | 1 | 5864.04 | 31 | SO50214 | 2023-07-14 | 469.12 | 6075.15 | 1466.01 | |||
SO50252_27 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 233 | 167 | 4 | 2023-07-19 | 86.52 | 2.16 | 2023-07-07 | 3 | 29.08 | 1 | 86.52 | 27 | SO50252 | 2023-07-14 | 6.92 | 87.24 | 28.84 | |||
SO44113_4 | B9C7-4334-81 | PO2697181021 | 100 | 282 | 347 | 187 | 4 | 2021-11-19 | 4079.99 | 102.00 | 2021-11-07 | 2 | 1912.15 | 1 | 4079.99 | 4 | SO44113 | 2021-11-14 | 326.40 | 3824.31 | 2039.99 | |||
SO58906_11 | 6BB0-48C1-BE | PO19633186598 | 100 | 287 | 599 | 149 | 3 | 2024-02-18 | 647.99 | 16.20 | 2024-02-06 | 2 | 294.58 | 1 | 647.99 | 11 | SO58906 | 2024-02-13 | 51.84 | 589.16 | 323.99 | |||
SO44096_2 | EE5D-4193-96 | PO13920114195 | 100 | 281 | 344 | 180 | 3 | 2021-11-19 | 4079.99 | 102.00 | 2021-11-07 | 2 | 1912.15 | 1 | 4079.99 | 2 | SO44096 | 2021-11-14 | 326.40 | 3824.31 | 2039.99 | |||
SO51789_36 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 496 | 2 | 605 | 1 | 151.39 | 2023-10-19 | 7569.48 | 185.45 | 2023-10-07 | 13 | 601.74 | 1 | 7418.09 | 36 | SO51789 | 2023-10-14 | 593.45 | 7822.67 | 582.27 | 0.02 |
SO71801_20 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 584 | 481 | 7 | 2024-08-19 | 647.99 | 16.20 | 2024-08-07 | 2 | 343.65 | 1 | 647.99 | 20 | SO71801 | 2024-08-14 | 51.84 | 687.30 | 323.99 | |||
SO51132_19 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 580 | 3 | 227 | 6 | 1029.10 | 2023-09-18 | 20581.98 | 488.82 | 2023-09-06 | 22 | 1082.51 | 1 | 19552.88 | 19 | SO51132 | 2023-09-13 | 1564.23 | 23815.22 | 935.54 | 0.05 |
SO69545_32 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 546 | 436 | 4 | 2024-07-19 | 149.02 | 3.73 | 2024-07-07 | 4 | 27.57 | 1 | 149.02 | 32 | SO69545 | 2024-07-14 | 11.92 | 110.27 | 37.25 | |||
SO48018_18 | 5D69-492B-A1 | PO11571175810 | 100 | 285 | 271 | 512 | 5 | 2023-01-19 | 404.66 | 10.12 | 2023-01-07 | 2 | 187.16 | 1 | 404.66 | 18 | SO48018 | 2023-01-14 | 32.37 | 374.31 | 202.33 | |||
SO47033_1 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 403 | 343 | 1 | 2022-10-19 | 72.88 | 1.82 | 2022-10-07 | 3 | 17.98 | 1 | 72.88 | 1 | SO47033 | 2022-10-14 | 5.83 | 53.93 | 24.29 | |||
SO48053_23 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 401 | 352 | 6 | 2023-01-19 | 65.60 | 1.64 | 2023-01-07 | 1 | 48.55 | 1 | 65.60 | 23 | SO48053 | 2023-01-14 | 5.25 | 48.55 | 65.60 | |||
SO48042_6 | 9307-4164-8B | PO2668178323 | 100 | 292 | 420 | 535 | 7 | 2023-01-19 | 283.23 | 7.08 | 2023-01-07 | 2 | 104.80 | 1 | 283.23 | 6 | SO48042 | 2023-01-14 | 22.66 | 209.59 | 141.62 | |||
SO71854_14 | AF3C-4FDF-A6 | PO16385143469 | 6 | 296 | 471 | 249 | 9 | 2024-08-19 | 152.40 | 3.81 | 2024-08-07 | 4 | 23.75 | 1 | 152.40 | 14 | SO71854 | 2024-08-14 | 12.19 | 95.00 | 38.10 | |||
SO65206_28 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 591 | 10 | 6 | 2024-05-19 | 1355.98 | 33.90 | 2024-05-07 | 4 | 308.22 | 1 | 1355.98 | 28 | SO65206 | 2024-05-14 | 108.48 | 1232.87 | 338.99 | |||
SO51106_22 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 499 | 331 | 4 | 2023-09-18 | 1204.69 | 30.12 | 2023-09-06 | 2 | 601.74 | 1 | 1204.69 | 22 | SO51106 | 2023-09-13 | 96.38 | 1203.49 | 602.35 | |||
SO51761_23 | 056F-4C15-93 | PO580111702 | 36 | 295 | 492 | 230 | 8 | 2023-10-19 | 4818.77 | 120.47 | 2023-10-07 | 8 | 601.74 | 1 | 4818.77 | 23 | SO51761 | 2023-10-14 | 385.50 | 4813.95 | 602.35 | |||
SO50746_2 | 1B61-4F3B-85 | PO5510129653 | 100 | 287 | 422 | 5 | 4 | 2023-08-19 | 135.08 | 3.38 | 2023-08-07 | 2 | 49.98 | 1 | 135.08 | 2 | SO50746 | 2023-08-14 | 10.81 | 99.96 | 67.54 | |||
SO43907_16 | 9CB1-46F4-8A | PO6641115253 | 100 | 281 | 285 | 342 | 2 | 2021-10-19 | 178.58 | 4.46 | 2021-10-07 | 1 | 176.20 | 1 | 178.58 | 16 | SO43907 | 2021-10-14 | 14.29 | 176.20 | 178.58 | |||
SO69460_10 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 255 | 426 | 6 | 2024-07-19 | 202.33 | 5.06 | 2024-07-07 | 1 | 204.63 | 1 | 202.33 | 10 | SO69460 | 2024-07-14 | 16.19 | 204.63 | 202.33 | |||
SO53497_28 | 1F74-43F0-9F | PO12673113349 | 100 | 292 | 430 | 499 | 7 | 2023-11-19 | 713.80 | 17.84 | 2023-11-07 | 2 | 360.94 | 1 | 713.80 | 28 | SO53497 | 2023-11-14 | 57.10 | 721.89 | 356.90 |
Generated 2024-10-06 15:01:10.083 UTC