[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 2588 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53465_45 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 231 | 2 | 678 | 6 | 8.12 | 2023-12-28 | 405.92 | 9.95 | 2023-12-16 | 14 | 38.49 | 1 | 397.80 | 45 | SO53465 | 2023-12-23 | 31.82 | 538.89 | 28.99 | 0.02 |
SO51704_33 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 502 | 264 | 6 | 2023-11-27 | 200.05 | 5.00 | 2023-11-15 | 1 | 199.85 | 1 | 200.05 | 33 | SO51704 | 2023-11-22 | 16.00 | 199.85 | 200.05 | |||
SO65171_2 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 359 | 47 | 6 | 2024-06-27 | 4130.98 | 103.27 | 2024-06-15 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO65171 | 2024-06-22 | 330.48 | 3755.94 | 1376.99 | |||
SO58918_34 | C811-4D40-80 | PO17574131484 | 19 | 291 | 542 | 678 | 6 | 2024-03-28 | 48.59 | 1.21 | 2024-03-16 | 2 | 17.98 | 1 | 48.59 | 34 | SO58918 | 2024-03-23 | 3.89 | 35.96 | 24.29 | |||
SO57070_5 | A915-448D-82 | PO11020121552 | 19 | 284 | 436 | 336 | 6 | 2024-02-27 | 356.90 | 8.92 | 2024-02-15 | 1 | 360.94 | 1 | 356.90 | 5 | SO57070 | 2024-02-22 | 28.55 | 360.94 | 356.90 | |||
SO50716_19 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 469 | 118 | 6 | 2023-09-27 | 22.79 | 0.57 | 2023-09-15 | 1 | 15.67 | 1 | 22.79 | 19 | SO50716 | 2023-09-22 | 1.82 | 15.67 | 22.79 | |||
SO46333_35 | B042-408B-A8 | PO17545158984 | 19 | 288 | 253 | 155 | 6 | 2022-09-27 | 357.16 | 8.93 | 2022-09-15 | 2 | 176.20 | 1 | 357.16 | 35 | SO46333 | 2022-09-22 | 28.57 | 352.40 | 178.58 | |||
SO45305_11 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 326 | 569 | 6 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 11 | SO45305 | 2022-05-25 | 67.11 | 826.29 | 419.46 | |||
SO48030_7 | 647F-4A33-8D | PO638143874 | 19 | 291 | 470 | 280 | 6 | 2023-02-27 | 136.76 | 3.42 | 2023-02-15 | 6 | 15.67 | 1 | 136.76 | 7 | SO48030 | 2023-02-22 | 10.94 | 94.03 | 22.79 | |||
SO67288_6 | C763-4CCD-AB | PO10527192676 | 19 | 284 | 545 | 480 | 6 | 2024-07-28 | 72.88 | 1.82 | 2024-07-16 | 3 | 17.98 | 1 | 72.88 | 6 | SO67288 | 2024-07-23 | 5.83 | 53.93 | 24.29 | |||
SO46607_16 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 422 | 227 | 6 | 2022-10-27 | 270.16 | 6.75 | 2022-10-15 | 4 | 49.98 | 1 | 270.16 | 16 | SO46607 | 2022-10-22 | 21.61 | 199.92 | 67.54 | |||
SO53456_22 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 436 | 173 | 6 | 2023-12-28 | 713.80 | 17.84 | 2023-12-16 | 2 | 360.94 | 1 | 713.80 | 22 | SO53456 | 2023-12-23 | 57.10 | 721.89 | 356.90 | |||
SO46657_12 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 297 | 496 | 6 | 2022-10-27 | 2944.58 | 73.61 | 2022-10-15 | 4 | 653.70 | 1 | 2944.58 | 12 | SO46657 | 2022-10-22 | 235.57 | 2614.79 | 736.15 | |||
SO47973_44 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 331 | 479 | 6 | 2023-02-27 | 469.79 | 11.74 | 2023-02-15 | 1 | 486.71 | 1 | 469.79 | 44 | SO47973 | 2023-02-22 | 37.58 | 486.71 | 469.79 | |||
SO48768_9 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 428 | 119 | 6 | 2023-04-29 | 418.51 | 10.46 | 2023-04-17 | 2 | 185.82 | 1 | 418.51 | 9 | SO48768 | 2023-04-24 | 33.48 | 371.64 | 209.26 | |||
SO51781_4 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 544 | 65 | 6 | 2023-11-27 | 97.19 | 2.43 | 2023-11-15 | 2 | 35.96 | 1 | 97.19 | 4 | SO51781 | 2023-11-22 | 7.78 | 71.92 | 48.59 | |||
SO48307_50 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 224 | 155 | 6 | 2023-03-29 | 20.75 | 0.52 | 2023-03-17 | 4 | 5.23 | 1 | 20.75 | 50 | SO48307 | 2023-03-24 | 1.66 | 20.92 | 5.19 | |||
SO58978_4 | 3AD0-4CD8-97 | PO18531185017 | 19 | 284 | 477 | 613 | 6 | 2024-03-28 | 2.99 | 0.07 | 2024-03-16 | 1 | 1.87 | 1 | 2.99 | 4 | SO58978 | 2024-03-23 | 0.24 | 1.87 | 2.99 | |||
SO53456_3 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 388 | 173 | 6 | 2023-12-28 | 672.29 | 16.81 | 2023-12-16 | 1 | 713.08 | 1 | 672.29 | 3 | SO53456 | 2023-12-23 | 53.78 | 713.08 | 672.29 | |||
SO51704_18 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 523 | 264 | 6 | 2023-11-27 | 63.17 | 1.58 | 2023-11-15 | 2 | 23.37 | 1 | 63.17 | 18 | SO51704 | 2023-11-22 | 5.05 | 46.74 | 31.58 | |||
SO51130_30 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 524 | 442 | 6 | 2023-10-27 | 158.43 | 3.96 | 2023-10-15 | 1 | 144.59 | 1 | 158.43 | 30 | SO51130 | 2023-10-22 | 12.67 | 144.59 | 158.43 | |||
SO46333_31 | B042-408B-A8 | PO17545158984 | 19 | 288 | 317 | 155 | 6 | 2022-09-27 | 3499.18 | 87.48 | 2022-09-15 | 4 | 884.71 | 1 | 3499.18 | 31 | SO46333 | 2022-09-22 | 279.93 | 3538.83 | 874.79 | |||
SO53484_7 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 527 | 497 | 6 | 2023-12-28 | 316.86 | 7.92 | 2023-12-16 | 2 | 144.59 | 1 | 316.86 | 7 | SO53484 | 2023-12-23 | 25.35 | 289.19 | 158.43 | |||
SO51116_9 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 483 | 480 | 6 | 2023-10-27 | 144.00 | 3.60 | 2023-10-15 | 2 | 44.88 | 1 | 144.00 | 9 | SO51116 | 2023-10-22 | 11.52 | 89.76 | 72.00 | |||
SO49860_17 | DB5C-4441-BE | PO13862128354 | 19 | 291 | 469 | 119 | 6 | 2023-07-28 | 113.97 | 2.85 | 2023-07-16 | 5 | 15.67 | 1 | 113.97 | 17 | SO49860 | 2023-07-23 | 9.12 | 78.35 | 22.79 | |||
SO44295_7 | DEAE-4D52-B8 | PO12760122918 | 19 | 288 | 319 | 83 | 6 | 2022-01-27 | 1749.59 | 43.74 | 2022-01-15 | 2 | 884.71 | 1 | 1749.59 | 7 | SO44295 | 2022-01-22 | 139.97 | 1769.42 | 874.79 | |||
SO51096_2 | 2D8A-4DAD-96 | PO14732111307 | 19 | 291 | 436 | 514 | 6 | 2023-10-27 | 2141.39 | 53.53 | 2023-10-15 | 6 | 360.94 | 1 | 2141.39 | 2 | SO51096 | 2023-10-22 | 171.31 | 2165.66 | 356.90 | |||
SO44288_21 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 212 | 514 | 6 | 2022-01-27 | 60.56 | 1.51 | 2022-01-15 | 3 | 12.03 | 1 | 60.56 | 21 | SO44288 | 2022-01-22 | 4.84 | 36.08 | 20.19 | |||
SO45781_3 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 324 | 227 | 6 | 2022-07-28 | 2516.75 | 62.92 | 2022-07-16 | 6 | 413.15 | 1 | 2516.75 | 3 | SO45781 | 2022-07-23 | 201.34 | 2478.88 | 419.46 | |||
SO46333_10 | B042-408B-A8 | PO17545158984 | 19 | 288 | 220 | 155 | 6 | 2022-09-27 | 100.93 | 2.52 | 2022-09-15 | 5 | 12.03 | 1 | 100.93 | 10 | SO46333 | 2022-09-22 | 8.07 | 60.14 | 20.19 |
Generated 2024-11-14 05:25:52.834 UTC