[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 725 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43888_7 | 7AED-4154-93 | PO2088113013 | 19 | 288 | 314 | 136 | 6 | 2021-10-03 | 2146.96 | 53.67 | 2021-09-21 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO43888 | 2021-09-28 | 171.76 | 2171.29 | 2146.96 | |||
SO48296_19 | FC37-4F3E-BB | PO19401157526 | 19 | 291 | 286 | 173 | 6 | 2023-02-02 | 919.69 | 22.99 | 2023-01-21 | 5 | 170.14 | 1 | 919.69 | 19 | SO48296 | 2023-01-28 | 73.58 | 850.71 | 183.94 | |||
SO45800_6 | 5B67-4FE2-B9 | PO10527156525 | 19 | 284 | 319 | 480 | 6 | 2022-06-03 | 1749.59 | 43.74 | 2022-05-22 | 2 | 884.71 | 1 | 1749.59 | 6 | SO45800 | 2022-05-29 | 139.97 | 1769.42 | 874.79 | |||
SO58957_16 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 593 | 685 | 6 | 2024-02-02 | 338.99 | 8.47 | 2024-01-21 | 1 | 308.22 | 1 | 338.99 | 16 | SO58957 | 2024-01-28 | 27.12 | 308.22 | 338.99 | |||
SO50265_13 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 375 | 479 | 6 | 2023-07-03 | 1308.94 | 32.72 | 2023-06-21 | 1 | 1320.68 | 1 | 1308.94 | 13 | SO50265 | 2023-06-28 | 104.72 | 1320.68 | 1308.94 | |||
SO58972_40 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 542 | 10 | 6 | 2024-02-02 | 48.59 | 1.21 | 2024-01-21 | 2 | 17.98 | 1 | 48.59 | 40 | SO58972 | 2024-01-28 | 3.89 | 35.96 | 24.29 | |||
SO58918_10 | C811-4D40-80 | PO17574131484 | 19 | 291 | 357 | 678 | 6 | 2024-02-02 | 4175.98 | 104.40 | 2024-01-21 | 3 | 1265.62 | 1 | 4175.98 | 10 | SO58918 | 2024-01-28 | 334.08 | 3796.86 | 1391.99 | |||
SO44085_17 | D35C-4208-A3 | PO17545192039 | 19 | 288 | 319 | 155 | 6 | 2021-11-03 | 874.79 | 21.87 | 2021-10-22 | 1 | 884.71 | 1 | 874.79 | 17 | SO44085 | 2021-10-29 | 69.98 | 884.71 | 874.79 | |||
SO46616_35 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 466 | 514 | 6 | 2022-09-02 | 70.64 | 1.77 | 2022-08-21 | 5 | 9.71 | 1 | 70.64 | 35 | SO46616 | 2022-08-28 | 5.65 | 48.57 | 14.13 | |||
SO46035_4 | F6D4-48D1-A2 | PO18270199753 | 19 | 288 | 346 | 11 | 6 | 2022-07-03 | 2039.99 | 51.00 | 2022-06-21 | 1 | 1912.15 | 1 | 2039.99 | 4 | SO46035 | 2022-06-28 | 163.20 | 1912.15 | 2039.99 | |||
SO61248_4 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 552 | 496 | 6 | 2024-03-04 | 329.36 | 8.23 | 2024-02-21 | 6 | 40.62 | 1 | 329.36 | 4 | SO61248 | 2024-02-28 | 26.35 | 243.73 | 54.89 | |||
SO55283_19 | 8D6B-460A-83 | PO18473174493 | 19 | 291 | 514 | 442 | 6 | 2023-12-03 | 127.80 | 3.20 | 2023-11-21 | 2 | 47.29 | 1 | 127.80 | 19 | SO55283 | 2023-11-28 | 10.22 | 94.57 | 63.90 | |||
SO48033_13 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 236 | 426 | 6 | 2023-01-03 | 86.52 | 2.16 | 2022-12-22 | 3 | 29.08 | 1 | 86.52 | 13 | SO48033 | 2022-12-29 | 6.92 | 87.24 | 28.84 | |||
SO51832_33 | 475C-432F-B2 | PO4466177904 | 19 | 291 | 543 | 352 | 6 | 2023-10-03 | 74.51 | 1.86 | 2023-09-21 | 2 | 27.57 | 1 | 74.51 | 33 | SO51832 | 2023-09-28 | 5.96 | 55.14 | 37.25 | |||
SO46616_46 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 415 | 514 | 6 | 2022-09-02 | 792.14 | 19.80 | 2022-08-21 | 4 | 146.55 | 1 | 792.14 | 46 | SO46616 | 2022-08-28 | 63.37 | 586.19 | 198.04 | |||
SO48059_4 | E21D-4968-B0 | PO4901134783 | 19 | 284 | 375 | 84 | 6 | 2023-01-03 | 3926.81 | 98.17 | 2022-12-22 | 3 | 1320.68 | 1 | 3926.81 | 4 | SO48059 | 2022-12-29 | 314.15 | 3962.05 | 1308.94 | |||
SO71808_30 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 222 | 2 | 408 | 6 | 4.87 | 2024-08-03 | 243.53 | 5.97 | 2024-07-22 | 12 | 13.09 | 1 | 238.66 | 30 | SO71808 | 2024-07-29 | 19.09 | 157.04 | 20.29 | 0.02 |
SO57082_5 | F79A-40C3-B7 | PO1595152621 | 19 | 284 | 583 | 426 | 6 | 2024-01-03 | 3061.78 | 76.54 | 2023-12-22 | 3 | 1082.51 | 1 | 3061.78 | 5 | SO57082 | 2023-12-29 | 244.94 | 3247.53 | 1020.59 | |||
SO61222_17 | 9C3C-4330-8A | PO13862196260 | 19 | 291 | 524 | 119 | 6 | 2024-03-04 | 158.43 | 3.96 | 2024-02-21 | 1 | 144.59 | 1 | 158.43 | 17 | SO61222 | 2024-02-28 | 12.67 | 144.59 | 158.43 | |||
SO47662_45 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 391 | 442 | 6 | 2022-12-03 | 266.80 | 6.67 | 2022-11-21 | 3 | 65.81 | 1 | 266.80 | 45 | SO47662 | 2022-11-28 | 21.34 | 197.43 | 88.93 | |||
SO51786_27 | CB32-4179-97 | PO18357130739 | 19 | 272 | 552 | 138 | 6 | 2023-10-03 | 109.79 | 2.74 | 2023-09-21 | 2 | 40.62 | 1 | 109.79 | 27 | SO51786 | 2023-09-28 | 8.78 | 81.24 | 54.89 | |||
SO49052_16 | 8769-409E-94 | PO16733182723 | 19 | 291 | 369 | 533 | 6 | 2023-04-05 | 8796.06 | 219.90 | 2023-03-24 | 6 | 1518.79 | 1 | 8796.06 | 16 | SO49052 | 2023-03-31 | 703.68 | 9112.72 | 1466.01 | |||
SO55243_11 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 472 | 299 | 6 | 2023-12-03 | 266.70 | 6.67 | 2023-11-21 | 7 | 23.75 | 1 | 266.70 | 11 | SO55243 | 2023-11-28 | 21.34 | 166.24 | 38.10 | |||
SO46930_15 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 456 | 65 | 6 | 2022-10-03 | 269.96 | 6.75 | 2022-09-21 | 6 | 30.93 | 1 | 269.96 | 15 | SO46930 | 2022-09-28 | 21.60 | 185.60 | 44.99 | |||
SO55263_9 | 10F0-498D-AE | PO11136189942 | 19 | 284 | 555 | 120 | 6 | 2023-12-03 | 191.70 | 4.79 | 2023-11-21 | 3 | 47.29 | 1 | 191.70 | 9 | SO55263 | 2023-11-28 | 15.34 | 141.86 | 63.90 | |||
SO44288_6 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 322 | 514 | 6 | 2021-12-03 | 2516.75 | 62.92 | 2021-11-21 | 6 | 413.15 | 1 | 2516.75 | 6 | SO44288 | 2021-11-28 | 201.34 | 2478.88 | 419.46 | |||
SO48340_15 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 360 | 685 | 6 | 2023-02-02 | 4917.84 | 122.95 | 2023-01-21 | 4 | 1105.81 | 1 | 4917.84 | 15 | SO48340 | 2023-01-28 | 393.43 | 4423.24 | 1229.46 | |||
SO50694_46 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 460 | 155 | 6 | 2023-08-03 | 377.96 | 9.45 | 2023-07-22 | 7 | 37.12 | 1 | 377.96 | 46 | SO50694 | 2023-07-29 | 30.24 | 259.85 | 53.99 |
Generated 2024-09-20 17:42:26.346 UTC