[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 7123 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59013_16 | C224-4535-BA | PO5597199820 | 100 | 281 | 558 | 75 | 4 | 2024-03-24 | 242.99 | 6.07 | 2024-03-12 | 1 | 179.82 | 1 | 242.99 | 16 | SO59013 | 2024-03-19 | 19.44 | 179.82 | 242.99 | |||
SO53533_15 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 569 | 13 | 509 | 4 | 100.22 | 2023-12-24 | 668.12 | 14.20 | 2023-12-12 | 2 | 461.44 | 1 | 567.90 | 15 | SO53533 | 2023-12-19 | 45.43 | 922.89 | 334.06 | 0.15 |
SO50226_44 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 216 | 78 | 4 | 2023-08-23 | 100.93 | 2.52 | 2023-08-11 | 5 | 13.88 | 1 | 100.93 | 44 | SO50226 | 2023-08-18 | 8.07 | 69.39 | 20.19 | |||
SO71896_24 | A37A-4B16-B0 | PO4640135042 | 100 | 287 | 544 | 648 | 4 | 2024-09-23 | 48.59 | 1.21 | 2024-09-11 | 1 | 35.96 | 1 | 48.59 | 24 | SO71896 | 2024-09-18 | 3.89 | 35.96 | 48.59 | |||
SO45332_2 | AD0B-49A0-A5 | PO6351110306 | 100 | 283 | 322 | 255 | 4 | 2022-05-26 | 838.92 | 20.97 | 2022-05-14 | 2 | 413.15 | 1 | 838.92 | 2 | SO45332 | 2022-05-21 | 67.11 | 826.29 | 419.46 | |||
SO50702_5 | 6D0A-413E-BE | PO2697119650 | 100 | 282 | 358 | 187 | 4 | 2023-09-23 | 6147.29 | 153.68 | 2023-09-11 | 5 | 1105.81 | 1 | 6147.29 | 5 | SO50702 | 2023-09-18 | 491.78 | 5529.05 | 1229.46 | |||
SO47720_48 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 213 | 221 | 4 | 2023-01-23 | 141.31 | 3.53 | 2023-01-11 | 7 | 13.88 | 1 | 141.31 | 48 | SO47720 | 2023-01-18 | 11.30 | 97.15 | 20.19 | |||
SO46642_26 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 417 | 4 | 4 | 2022-10-23 | 1946.72 | 48.67 | 2022-10-11 | 6 | 300.12 | 1 | 1946.72 | 26 | SO46642 | 2022-10-18 | 155.74 | 1800.71 | 324.45 | |||
SO46380_2 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 350 | 7 | 608 | 4 | 2953.12 | 2022-09-23 | 8437.48 | 137.11 | 2022-09-11 | 10 | 1898.09 | 1 | 5484.36 | 2 | SO46380 | 2022-09-18 | 438.75 | 18980.94 | 843.75 | 0.35 |
SO46634_2 | 8EF9-46A8-AA | PO10730130024 | 100 | 287 | 327 | 9 | 491 | 4 | 70.47 | 2022-10-23 | 234.90 | 4.11 | 2022-10-11 | 1 | 486.71 | 1 | 164.43 | 2 | SO46634 | 2022-10-18 | 13.15 | 486.71 | 234.90 | 0.30 |
SO45560_9 | B195-4977-8E | PO4640111403 | 100 | 287 | 232 | 648 | 4 | 2022-06-23 | 57.68 | 1.44 | 2022-06-11 | 2 | 31.72 | 1 | 57.68 | 9 | SO45560 | 2022-06-18 | 4.61 | 63.45 | 28.84 | |||
SO47436_9 | 4AA1-4884-91 | PO5510133089 | 100 | 287 | 271 | 5 | 4 | 2022-12-24 | 809.33 | 20.23 | 2022-12-12 | 4 | 187.16 | 1 | 809.33 | 9 | SO47436 | 2022-12-19 | 64.75 | 748.63 | 202.33 | |||
SO51844_11 | DE76-4481-AA | PO4553182082 | 100 | 282 | 477 | 313 | 4 | 2023-11-23 | 8.98 | 0.22 | 2023-11-11 | 3 | 1.87 | 1 | 8.98 | 11 | SO51844 | 2023-11-18 | 0.72 | 5.60 | 2.99 | |||
SO44520_18 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 279 | 78 | 4 | 2022-02-23 | 178.58 | 4.46 | 2022-02-11 | 1 | 176.20 | 1 | 178.58 | 18 | SO44520 | 2022-02-18 | 14.29 | 176.20 | 178.58 | |||
SO47422_27 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 453 | 130 | 4 | 2022-12-24 | 251.96 | 6.30 | 2022-12-12 | 7 | 24.75 | 1 | 251.96 | 27 | SO47422 | 2022-12-19 | 20.16 | 173.22 | 35.99 | |||
SO50208_30 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 341 | 328 | 4 | 2023-08-23 | 1879.18 | 46.98 | 2023-08-11 | 4 | 486.71 | 1 | 1879.18 | 30 | SO50208 | 2023-08-18 | 150.33 | 1946.83 | 469.79 | |||
SO45798_23 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 275 | 203 | 4 | 2022-07-24 | 713.80 | 17.84 | 2022-07-12 | 2 | 352.14 | 1 | 713.80 | 23 | SO45798 | 2022-07-19 | 57.10 | 704.28 | 356.90 | |||
SO48380_13 | 580B-4A1F-A4 | PO6757155119 | 100 | 283 | 428 | 21 | 4 | 2023-03-25 | 1255.54 | 31.39 | 2023-03-13 | 6 | 185.82 | 1 | 1255.54 | 13 | SO48380 | 2023-03-20 | 100.44 | 1114.92 | 209.26 | |||
SO50294_10 | F34B-46CA-8D | PO3799186112 | 100 | 282 | 469 | 3 | 312 | 4 | 18.81 | 2023-08-23 | 376.10 | 8.93 | 2023-08-11 | 18 | 15.67 | 1 | 357.30 | 10 | SO50294 | 2023-08-18 | 28.58 | 282.08 | 20.89 | 0.05 |
SO45784_1 | 8A7A-4D84-B4 | PO16008186765 | 100 | 282 | 310 | 511 | 4 | 2022-07-24 | 2146.96 | 53.67 | 2022-07-12 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO45784 | 2022-07-19 | 171.76 | 2171.29 | 2146.96 | |||
SO48052_3 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 365 | 435 | 4 | 2023-02-23 | 647.99 | 16.20 | 2023-02-11 | 1 | 598.44 | 1 | 647.99 | 3 | SO48052 | 2023-02-18 | 51.84 | 598.44 | 647.99 | |||
SO45798_27 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 223 | 203 | 4 | 2022-07-24 | 5.19 | 0.13 | 2022-07-12 | 1 | 5.71 | 1 | 5.19 | 27 | SO45798 | 2022-07-19 | 0.41 | 5.71 | 5.19 | |||
SO46089_15 | 5E3C-4A0D-BD | PO5684142532 | 100 | 282 | 220 | 385 | 4 | 2022-08-23 | 80.75 | 2.02 | 2022-08-11 | 4 | 12.03 | 1 | 80.75 | 15 | SO46089 | 2022-08-18 | 6.46 | 48.11 | 20.19 | |||
SO45798_3 | 3FA4-4459-BD | PO10817199969 | 100 | 287 | 264 | 203 | 4 | 2022-07-24 | 183.94 | 4.60 | 2022-07-12 | 1 | 181.49 | 1 | 183.94 | 3 | SO45798 | 2022-07-19 | 14.72 | 181.49 | 183.94 |
Generated 2024-11-11 00:02:12.544 UTC