[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 266 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51142_2 | F4E4-4739-B4 | PO6380128564 | 100 | 281 | 499 | 597 | 4 | 2023-09-03 | 602.35 | 15.06 | 2023-08-22 | 1 | 601.74 | 1 | 602.35 | 2 | SO51142 | 2023-08-29 | 48.19 | 601.74 | 602.35 | |||
SO51139_5 | 892A-4EAD-98 | PO7743143396 | 100 | 287 | 522 | 275 | 4 | 2023-09-03 | 46.97 | 1.17 | 2023-08-22 | 2 | 17.38 | 1 | 46.97 | 5 | SO51139 | 2023-08-29 | 3.76 | 34.76 | 23.48 | |||
SO71845_31 | 4781-4673-85 | PO2697119362 | 100 | 282 | 559 | 187 | 4 | 2024-08-04 | 36.43 | 0.91 | 2024-07-23 | 3 | 8.99 | 1 | 36.43 | 31 | SO71845 | 2024-07-30 | 2.91 | 26.96 | 12.14 | |||
SO55264_18 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 546 | 491 | 4 | 2023-12-04 | 74.51 | 1.86 | 2023-11-22 | 2 | 27.57 | 1 | 74.51 | 18 | SO55264 | 2023-11-29 | 5.96 | 55.14 | 37.25 | |||
SO71782_43 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 214 | 582 | 4 | 2024-08-04 | 62.98 | 1.57 | 2024-07-23 | 3 | 13.09 | 1 | 62.98 | 43 | SO71782 | 2024-07-30 | 5.04 | 39.26 | 20.99 | |||
SO46660_10 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 335 | 166 | 4 | 2022-09-03 | 2818.76 | 70.47 | 2022-08-22 | 6 | 486.71 | 1 | 2818.76 | 10 | SO46660 | 2022-08-29 | 225.50 | 2920.24 | 469.79 | |||
SO53533_24 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 570 | 13 | 509 | 4 | 50.11 | 2023-11-04 | 334.06 | 7.10 | 2023-10-23 | 1 | 461.44 | 1 | 283.95 | 24 | SO53533 | 2023-10-30 | 22.72 | 461.44 | 334.06 | 0.15 |
SO49498_14 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 447 | 239 | 4 | 2023-05-04 | 45.00 | 1.13 | 2023-04-22 | 3 | 10.31 | 1 | 45.00 | 14 | SO49498 | 2023-04-29 | 3.60 | 30.94 | 15.00 | |||
SO48341_24 | A747-471B-97 | PO10701176180 | 100 | 282 | 224 | 3 | 133 | 4 | 5.47 | 2023-02-03 | 109.35 | 2.60 | 2023-01-22 | 23 | 5.23 | 1 | 103.88 | 24 | SO48341 | 2023-01-29 | 8.31 | 120.28 | 4.75 | 0.05 |
SO53606_39 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 476 | 2 | 61 | 4 | 11.37 | 2023-11-04 | 568.32 | 13.92 | 2023-10-23 | 14 | 26.18 | 1 | 556.95 | 39 | SO53606 | 2023-10-30 | 44.56 | 366.47 | 40.59 | 0.02 |
SO50720_15 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 409 | 490 | 4 | 2023-08-04 | 418.51 | 10.46 | 2023-07-23 | 2 | 185.82 | 1 | 418.51 | 15 | SO50720 | 2023-07-30 | 33.48 | 371.64 | 209.26 | |||
SO45299_5 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 270 | 240 | 4 | 2022-04-06 | 183.94 | 4.60 | 2022-03-25 | 1 | 181.49 | 1 | 183.94 | 5 | SO45299 | 2022-04-01 | 14.72 | 181.49 | 183.94 | |||
SO46988_7 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 462 | 78 | 4 | 2022-10-04 | 42.39 | 1.06 | 2022-09-22 | 3 | 9.71 | 1 | 42.39 | 7 | SO46988 | 2022-09-29 | 3.39 | 29.14 | 14.13 | |||
SO47045_31 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 411 | 309 | 4 | 2022-10-04 | 250.83 | 6.27 | 2022-09-22 | 2 | 92.81 | 1 | 250.83 | 31 | SO47045 | 2022-09-29 | 20.07 | 185.61 | 125.42 | |||
SO48375_27 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 224 | 75 | 4 | 2023-02-03 | 51.87 | 1.30 | 2023-01-22 | 10 | 5.23 | 1 | 51.87 | 27 | SO48375 | 2023-01-29 | 4.15 | 52.30 | 5.19 | |||
SO50214_2 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 385 | 258 | 4 | 2023-07-04 | 2401.05 | 60.03 | 2023-06-22 | 4 | 605.65 | 1 | 2401.05 | 2 | SO50214 | 2023-06-29 | 192.08 | 2422.60 | 600.26 | |||
SO46374_11 | 67B2-494E-90 | PO5597118034 | 100 | 283 | 220 | 75 | 4 | 2022-08-04 | 121.12 | 3.03 | 2022-07-23 | 6 | 12.03 | 1 | 121.12 | 11 | SO46374 | 2022-07-30 | 9.69 | 72.17 | 20.19 | |||
SO44521_7 | E46D-4692-AC | PO12557171689 | 100 | 282 | 223 | 240 | 4 | 2022-01-04 | 5.19 | 0.13 | 2021-12-23 | 1 | 5.71 | 1 | 5.19 | 7 | SO44521 | 2021-12-30 | 0.41 | 5.71 | 5.19 | |||
SO49490_1 | 0396-4322-83 | PO19343175441 | 100 | 282 | 333 | 24 | 4 | 2023-05-04 | 1879.18 | 46.98 | 2023-04-22 | 4 | 486.71 | 1 | 1879.18 | 1 | SO49490 | 2023-04-29 | 150.33 | 1946.83 | 469.79 | |||
SO55322_25 | D600-436A-B7 | PO7859118281 | 100 | 287 | 255 | 221 | 4 | 2023-12-04 | 404.66 | 10.12 | 2023-11-22 | 2 | 204.63 | 1 | 404.66 | 25 | SO55322 | 2023-11-29 | 32.37 | 409.25 | 202.33 | |||
SO47990_2 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 377 | 328 | 4 | 2023-01-04 | 5235.75 | 130.89 | 2022-12-23 | 4 | 1320.68 | 1 | 5235.75 | 2 | SO47990 | 2022-12-30 | 418.86 | 5282.74 | 1308.94 | |||
SO49832_13 | 3280-41FF-A3 | PO13659150841 | 100 | 287 | 409 | 437 | 4 | 2023-06-04 | 209.26 | 5.23 | 2023-05-23 | 1 | 185.82 | 1 | 209.26 | 13 | SO49832 | 2023-05-30 | 16.74 | 185.82 | 209.26 | |||
SO51154_23 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 217 | 11 | 221 | 4 | 23.62 | 2023-09-03 | 157.46 | 3.35 | 2023-08-22 | 10 | 13.09 | 1 | 133.84 | 23 | SO51154 | 2023-08-29 | 10.71 | 130.86 | 15.75 | 0.15 |
SO49890_36 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 271 | 221 | 4 | 2023-06-04 | 202.33 | 5.06 | 2023-05-23 | 1 | 187.16 | 1 | 202.33 | 36 | SO49890 | 2023-05-30 | 16.19 | 187.16 | 202.33 | |||
SO48049_24 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 428 | 312 | 4 | 2023-01-04 | 1046.28 | 26.16 | 2022-12-23 | 5 | 185.82 | 1 | 1046.28 | 24 | SO48049 | 2022-12-30 | 83.70 | 929.10 | 209.26 | |||
SO49132_7 | 3562-4169-86 | PO3799126007 | 100 | 282 | 420 | 312 | 4 | 2023-04-06 | 283.23 | 7.08 | 2023-03-25 | 2 | 104.80 | 1 | 283.23 | 7 | SO49132 | 2023-04-01 | 22.66 | 209.59 | 141.62 | |||
SO49127_34 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 321 | 436 | 4 | 2023-04-06 | 1879.18 | 46.98 | 2023-03-25 | 4 | 486.71 | 1 | 1879.18 | 34 | SO49127 | 2023-04-01 | 150.33 | 1946.83 | 469.79 | |||
SO61264_14 | 5396-4F0C-B0 | PO5626112601 | 100 | 281 | 545 | 166 | 4 | 2024-03-05 | 97.18 | 2.43 | 2024-02-22 | 4 | 17.98 | 1 | 97.18 | 14 | SO61264 | 2024-02-29 | 7.77 | 71.91 | 24.29 |
Generated 2024-09-21 03:15:02.926 UTC