[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 286 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46940_34 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 369 | 479 | 6 | 2022-10-03 | 4398.03 | 109.95 | 2022-09-21 | 3 | 1518.79 | 1 | 4398.03 | 34 | SO46940 | 2022-09-28 | 351.84 | 4556.36 | 1466.01 | |||
SO46611_23 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 358 | 146 | 1 | 2022-09-02 | 12294.59 | 307.36 | 2022-08-21 | 10 | 1105.81 | 1 | 12294.59 | 23 | SO46611 | 2022-08-28 | 983.57 | 11058.10 | 1229.46 | |||
SO67289_30 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 484 | 2 | 196 | 10 | 1.11 | 2024-06-03 | 55.33 | 1.36 | 2024-05-22 | 12 | 2.97 | 1 | 54.23 | 30 | SO67289 | 2024-05-29 | 4.34 | 35.68 | 4.61 | 0.02 |
SO47698_6 | 3841-4995-8C | PO2552129685 | 100 | 286 | 448 | 506 | 1 | 2022-12-03 | 47.98 | 1.20 | 2022-11-21 | 4 | 8.25 | 1 | 47.98 | 6 | SO47698 | 2022-11-28 | 3.84 | 32.98 | 11.99 | |||
SO69464_27 | 8924-465B-BE | PO2668146931 | 100 | 292 | 355 | 535 | 7 | 2024-07-03 | 2783.99 | 69.60 | 2024-06-21 | 2 | 1265.62 | 1 | 2783.99 | 27 | SO69464 | 2024-06-28 | 222.72 | 2531.24 | 1391.99 | |||
SO47007_3 | FDB2-4E3C-81 | PO1218131317 | 98 | 288 | 424 | 412 | 10 | 2022-10-03 | 214.24 | 5.36 | 2022-09-21 | 1 | 158.53 | 1 | 214.24 | 3 | SO47007 | 2022-09-28 | 17.14 | 158.53 | 214.24 | |||
SO48328_4 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 396 | 293 | 1 | 2023-02-02 | 149.68 | 3.74 | 2023-01-21 | 2 | 55.38 | 1 | 149.68 | 4 | SO48328 | 2023-01-28 | 11.97 | 110.76 | 74.84 | |||
SO61248_28 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 234 | 496 | 6 | 2024-03-04 | 59.99 | 1.50 | 2024-02-21 | 2 | 38.49 | 1 | 59.99 | 28 | SO61248 | 2024-02-28 | 4.80 | 76.98 | 29.99 | |||
SO57185_12 | 683A-464C-8C | PO8729178515 | 98 | 290 | 564 | 556 | 10 | 2024-01-03 | 2860.88 | 71.52 | 2023-12-22 | 2 | 1481.94 | 1 | 2860.88 | 12 | SO57185 | 2023-12-29 | 228.87 | 2963.88 | 1430.44 | |||
SO51122_22 | D915-4225-97 | PO551181465 | 100 | 281 | 605 | 4 | 4 | 2023-09-02 | 971.98 | 24.30 | 2023-08-21 | 3 | 343.65 | 1 | 971.98 | 22 | SO51122 | 2023-08-28 | 77.76 | 1030.95 | 323.99 | |||
SO69445_5 | C2C0-4C91-B1 | PO11281173752 | 36 | 295 | 545 | 68 | 8 | 2024-07-03 | 24.29 | 0.61 | 2024-06-21 | 1 | 17.98 | 1 | 24.29 | 5 | SO69445 | 2024-06-28 | 1.94 | 17.98 | 24.29 | |||
SO48010_1 | 81A7-4B68-B2 | PO12702168891 | 100 | 292 | 354 | 175 | 7 | 2023-01-03 | 8699.96 | 217.50 | 2022-12-22 | 7 | 1117.86 | 1 | 8699.96 | 1 | SO48010 | 2022-12-29 | 696.00 | 7824.99 | 1242.85 | |||
SO43693_6 | EC62-4BB3-9B | PO8120182325 | 100 | 281 | 215 | 485 | 5 | 2021-09-02 | 40.37 | 1.01 | 2021-08-21 | 2 | 12.03 | 1 | 40.37 | 6 | SO43693 | 2021-08-28 | 3.23 | 24.06 | 20.19 | |||
SO47681_22 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 224 | 530 | 5 | 2022-12-03 | 36.31 | 0.91 | 2022-11-21 | 7 | 5.23 | 1 | 36.31 | 22 | SO47681 | 2022-11-28 | 2.90 | 36.61 | 5.19 | |||
SO51101_19 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 382 | 618 | 2 | 2023-09-02 | 672.29 | 16.81 | 2023-08-21 | 1 | 713.08 | 1 | 672.29 | 19 | SO51101 | 2023-08-28 | 53.78 | 713.08 | 672.29 | |||
SO63173_15 | CE32-441D-BF | PO1508158507 | 98 | 290 | 388 | 430 | 10 | 2024-04-04 | 672.29 | 16.81 | 2024-03-23 | 1 | 713.08 | 1 | 672.29 | 15 | SO63173 | 2024-03-30 | 53.78 | 713.08 | 672.29 | |||
SO69422_61 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 525 | 650 | 1 | 2024-07-03 | 792.15 | 19.80 | 2024-06-21 | 5 | 144.59 | 1 | 792.15 | 61 | SO69422 | 2024-06-28 | 63.37 | 722.97 | 158.43 | |||
SO69560_22 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 398 | 100 | 6 | 2024-07-03 | 26.72 | 0.67 | 2024-06-21 | 1 | 19.78 | 1 | 26.72 | 22 | SO69560 | 2024-06-28 | 2.14 | 19.78 | 26.72 | |||
SO47658_3 | C574-484B-83 | PO551177057 | 100 | 283 | 343 | 4 | 4 | 2022-12-03 | 2348.97 | 58.72 | 2022-11-21 | 5 | 486.71 | 1 | 2348.97 | 3 | SO47658 | 2022-11-28 | 187.92 | 2433.53 | 469.79 | |||
SO58913_3 | 51C4-4C84-94 | PO17690130629 | 19 | 291 | 476 | 47 | 6 | 2024-02-02 | 83.99 | 2.10 | 2024-01-21 | 2 | 26.18 | 1 | 83.99 | 3 | SO58913 | 2024-01-28 | 6.72 | 52.35 | 41.99 | |||
SO55253_35 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 551 | 530 | 5 | 2023-12-03 | 475.29 | 11.88 | 2023-11-21 | 3 | 144.59 | 1 | 475.29 | 35 | SO55253 | 2023-11-28 | 38.02 | 433.78 | 158.43 | |||
SO49052_19 | 8769-409E-94 | PO16733182723 | 19 | 291 | 224 | 533 | 6 | 2023-04-05 | 25.93 | 0.65 | 2023-03-24 | 5 | 5.23 | 1 | 25.93 | 19 | SO49052 | 2023-03-31 | 2.07 | 26.15 | 5.19 | |||
SO47056_36 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 325 | 403 | 4 | 2022-10-03 | 2348.97 | 58.72 | 2022-09-21 | 5 | 486.71 | 1 | 2348.97 | 36 | SO47056 | 2022-09-28 | 187.92 | 2433.53 | 469.79 | |||
SO53562_21 | 9FC2-4D08-A7 | PO8468156175 | 98 | 288 | 584 | 16 | 10 | 2023-11-03 | 1619.97 | 40.50 | 2023-10-22 | 5 | 343.65 | 1 | 1619.97 | 21 | SO53562 | 2023-10-29 | 129.60 | 1718.25 | 323.99 | |||
SO46931_14 | EE3D-4B0A-B6 | PO19923131204 | 100 | 281 | 352 | 18 | 3 | 2022-10-03 | 6214.26 | 155.36 | 2022-09-21 | 5 | 1117.86 | 1 | 6214.26 | 14 | SO46931 | 2022-09-28 | 497.14 | 5589.28 | 1242.85 | |||
SO71938_10 | 7D23-4E70-B4 | PO8468183315 | 98 | 288 | 225 | 16 | 10 | 2024-08-03 | 5.39 | 0.13 | 2024-07-22 | 1 | 6.92 | 1 | 5.39 | 10 | SO71938 | 2024-07-29 | 0.43 | 6.92 | 5.39 | |||
SO45285_6 | 91C9-46BD-A9 | PO16791139915 | 100 | 281 | 315 | 36 | 2 | 2022-04-05 | 1749.59 | 43.74 | 2022-03-24 | 2 | 884.71 | 1 | 1749.59 | 6 | SO45285 | 2022-03-31 | 139.97 | 1769.42 | 874.79 | |||
SO48375_23 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 395 | 75 | 4 | 2023-02-02 | 184.12 | 4.60 | 2023-01-21 | 3 | 45.42 | 1 | 184.12 | 23 | SO48375 | 2023-01-28 | 14.73 | 136.25 | 61.37 | |||
SO61184_22 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 565 | 599 | 4 | 2024-03-04 | 2227.05 | 55.68 | 2024-02-21 | 5 | 461.44 | 1 | 2227.05 | 22 | SO61184 | 2024-02-28 | 178.16 | 2307.22 | 445.41 | |||
SO50736_4 | C13C-4FDC-8A | PO261148609 | 100 | 281 | 385 | 647 | 4 | 2023-08-03 | 600.26 | 15.01 | 2023-07-22 | 1 | 605.65 | 1 | 600.26 | 4 | SO50736 | 2023-07-29 | 48.02 | 605.65 | 600.26 | |||
SO69558_26 | 0B27-4F3C-97 | PO8642129578 | 98 | 288 | 522 | 520 | 10 | 2024-07-03 | 23.48 | 0.59 | 2024-06-21 | 1 | 17.38 | 1 | 23.48 | 26 | SO69558 | 2024-06-28 | 1.88 | 17.38 | 23.48 | |||
SO50231_6 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 458 | 512 | 5 | 2023-07-03 | 44.99 | 1.12 | 2023-06-21 | 1 | 30.93 | 1 | 44.99 | 6 | SO50231 | 2023-06-28 | 3.60 | 30.93 | 44.99 | |||
SO53480_10 | 36E1-4FCF-B4 | PO15341137525 | 100 | 281 | 222 | 327 | 3 | 2023-11-03 | 41.99 | 1.05 | 2023-10-22 | 2 | 13.09 | 1 | 41.99 | 10 | SO53480 | 2023-10-29 | 3.36 | 26.17 | 20.99 | |||
SO47444_2 | 4361-4317-91 | PO7946191257 | 100 | 282 | 343 | 438 | 1 | 2022-11-03 | 939.59 | 23.49 | 2022-10-22 | 2 | 486.71 | 1 | 939.59 | 2 | SO47444 | 2022-10-29 | 75.17 | 973.41 | 469.79 | |||
SO50206_17 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 391 | 236 | 1 | 2023-07-03 | 177.86 | 4.45 | 2023-06-21 | 2 | 65.81 | 1 | 177.86 | 17 | SO50206 | 2023-06-28 | 14.23 | 131.62 | 88.93 | |||
SO49870_43 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 224 | 660 | 3 | 2023-06-03 | 10.37 | 0.26 | 2023-05-22 | 2 | 5.23 | 1 | 10.37 | 43 | SO49870 | 2023-05-29 | 0.83 | 10.46 | 5.19 | |||
SO46957_3 | C98D-43A5-8A | PO16414179284 | 100 | 289 | 464 | 236 | 1 | 2022-10-03 | 127.16 | 3.18 | 2022-09-21 | 9 | 9.71 | 1 | 127.16 | 3 | SO46957 | 2022-09-28 | 10.17 | 87.42 | 14.13 | |||
SO61249_17 | 8FD3-4473-B2 | PO4524119518 | 36 | 295 | 388 | 482 | 8 | 2024-03-04 | 672.29 | 16.81 | 2024-02-21 | 1 | 713.08 | 1 | 672.29 | 17 | SO61249 | 2024-02-28 | 53.78 | 713.08 | 672.29 | |||
SO46651_7 | 68A1-47A8-9A | PO3016181627 | 100 | 283 | 356 | 183 | 3 | 2022-09-02 | 1242.85 | 31.07 | 2022-08-21 | 1 | 1117.86 | 1 | 1242.85 | 7 | SO46651 | 2022-08-28 | 99.43 | 1117.86 | 1242.85 | |||
SO50727_15 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 265 | 54 | 2 | 2023-08-03 | 404.66 | 10.12 | 2023-07-22 | 2 | 187.16 | 1 | 404.66 | 15 | SO50727 | 2023-07-29 | 32.37 | 374.31 | 202.33 | |||
SO49891_44 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 445 | 538 | 10 | 2023-06-03 | 107.98 | 2.70 | 2023-05-22 | 3 | 24.75 | 1 | 107.98 | 44 | SO49891 | 2023-05-29 | 8.64 | 74.24 | 35.99 | |||
SO71952_34 | 9490-4552-81 | PO9715163911 | 100 | 281 | 517 | 490 | 4 | 2024-08-03 | 126.34 | 3.16 | 2024-07-22 | 4 | 23.37 | 1 | 126.34 | 34 | SO71952 | 2024-07-29 | 10.11 | 93.49 | 31.58 | |||
SO71851_44 | AABE-4443-91 | PO18299133687 | 19 | 291 | 491 | 2 | 118 | 6 | 6.89 | 2024-08-03 | 344.46 | 8.44 | 2024-07-22 | 11 | 41.57 | 1 | 337.57 | 44 | SO71851 | 2024-07-29 | 27.01 | 457.30 | 31.31 | 0.02 |
SO50269_4 | 78AA-40D5-B3 | PO18647136011 | 100 | 282 | 468 | 583 | 4 | 2023-07-03 | 45.59 | 1.14 | 2023-06-21 | 2 | 15.67 | 1 | 45.59 | 4 | SO50269 | 2023-06-28 | 3.65 | 31.34 | 22.79 | |||
SO57044_6 | 6960-4E37-97 | PO14558116667 | 100 | 289 | 234 | 2 | 1 | 2024-01-03 | 89.98 | 2.25 | 2023-12-22 | 3 | 38.49 | 1 | 89.98 | 6 | SO57044 | 2023-12-29 | 7.20 | 115.48 | 29.99 | |||
SO49129_9 | 1D0F-41F4-9F | PO12702195272 | 100 | 292 | 469 | 175 | 7 | 2023-04-05 | 45.59 | 1.14 | 2023-03-24 | 2 | 15.67 | 1 | 45.59 | 9 | SO49129 | 2023-03-31 | 3.65 | 31.34 | 22.79 | |||
SO43855_3 | FB88-4B92-82 | PO17748116016 | 19 | 284 | 314 | 102 | 6 | 2021-10-03 | 2146.96 | 53.67 | 2021-09-21 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO43855 | 2021-09-28 | 171.76 | 2171.29 | 2146.96 | |||
SO46952_1 | 6FB1-4786-8F | PO17081124520 | 100 | 285 | 423 | 524 | 5 | 2022-10-03 | 165.23 | 4.13 | 2022-09-21 | 1 | 122.27 | 1 | 165.23 | 1 | SO46952 | 2022-09-28 | 13.22 | 122.27 | 165.23 | |||
SO61184_8 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 496 | 599 | 4 | 2024-03-04 | 1807.04 | 45.18 | 2024-02-21 | 3 | 601.74 | 1 | 1807.04 | 8 | SO61184 | 2024-02-28 | 144.56 | 1805.23 | 602.35 | |||
SO49484_15 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 427 | 118 | 6 | 2023-05-03 | 627.77 | 15.69 | 2023-04-21 | 3 | 185.82 | 1 | 627.77 | 15 | SO49484 | 2023-04-28 | 50.22 | 557.46 | 209.26 | |||
SO65174_37 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 552 | 678 | 6 | 2024-05-03 | 219.58 | 5.49 | 2024-04-21 | 4 | 40.62 | 1 | 219.58 | 37 | SO65174 | 2024-04-28 | 17.57 | 162.49 | 54.89 | |||
SO46629_3 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 329 | 670 | 3 | 2022-09-02 | 1409.38 | 35.23 | 2022-08-21 | 3 | 486.71 | 1 | 1409.38 | 3 | SO46629 | 2022-08-28 | 112.75 | 1460.12 | 469.79 | |||
SO48359_41 | BFAE-4CA5-83 | PO2813116854 | 100 | 272 | 230 | 90 | 5 | 2023-02-02 | 115.36 | 2.88 | 2023-01-21 | 4 | 29.08 | 1 | 115.36 | 41 | SO48359 | 2023-01-28 | 9.23 | 116.32 | 28.84 | |||
SO71942_5 | A5F9-49B1-92 | PO9222123146 | 100 | 285 | 482 | 171 | 5 | 2024-08-03 | 16.18 | 0.40 | 2024-07-22 | 3 | 3.36 | 1 | 16.18 | 5 | SO71942 | 2024-07-29 | 1.29 | 10.09 | 5.39 | |||
SO53513_19 | 5E21-438C-B3 | PO10875194431 | 19 | 291 | 569 | 13 | 281 | 6 | 100.22 | 2023-11-03 | 668.12 | 14.20 | 2023-10-22 | 2 | 461.44 | 1 | 567.90 | 19 | SO53513 | 2023-10-29 | 45.43 | 922.89 | 334.06 | 0.15 |
SO48080_7 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 254 | 403 | 4 | 2023-01-03 | 1103.63 | 27.59 | 2022-12-22 | 6 | 170.14 | 1 | 1103.63 | 7 | SO48080 | 2022-12-29 | 88.29 | 1020.86 | 183.94 | |||
SO47450_37 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 224 | 54 | 2 | 2022-11-03 | 31.12 | 0.78 | 2022-10-22 | 6 | 5.23 | 1 | 31.12 | 37 | SO47450 | 2022-10-29 | 2.49 | 31.38 | 5.19 | |||
SO55249_35 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 603 | 475 | 4 | 2023-12-03 | 291.58 | 7.29 | 2023-11-21 | 4 | 53.94 | 1 | 291.58 | 35 | SO55249 | 2023-11-28 | 23.33 | 215.77 | 72.89 | |||
SO49891_49 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 325 | 538 | 10 | 2023-06-03 | 2818.76 | 70.47 | 2023-05-22 | 6 | 486.71 | 1 | 2818.76 | 49 | SO49891 | 2023-05-29 | 225.50 | 2920.24 | 469.79 | |||
SO50675_10 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 427 | 327 | 3 | 2023-08-03 | 418.51 | 10.46 | 2023-07-22 | 2 | 185.82 | 1 | 418.51 | 10 | SO50675 | 2023-07-29 | 33.48 | 371.64 | 209.26 | |||
SO49093_12 | A0B1-4C01-8A | PO15370113221 | 100 | 281 | 305 | 381 | 3 | 2023-04-05 | 2208.44 | 55.21 | 2023-03-24 | 3 | 653.70 | 1 | 2208.44 | 12 | SO49093 | 2023-03-31 | 176.67 | 1961.09 | 736.15 | |||
SO71799_6 | EBC1-4D4C-8E | PO15486196616 | 100 | 292 | 398 | 121 | 7 | 2024-08-03 | 53.45 | 1.34 | 2024-07-22 | 2 | 19.78 | 1 | 53.45 | 6 | SO71799 | 2024-07-29 | 4.28 | 39.55 | 26.72 |
Generated 2024-09-20 15:49:52.147 UTC