[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 < SKIP 3635 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53483_36 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 467 | 408 | 6 | 2023-12-24 | 58.78 | 1.47 | 2023-12-12 | 4 | 9.16 | 1 | 58.78 | 36 | SO53483 | 2023-12-19 | 4.70 | 36.64 | 14.69 | |||
SO45797_12 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 320 | 679 | 6 | 2022-07-24 | 419.46 | 10.49 | 2022-07-12 | 1 | 413.15 | 1 | 419.46 | 12 | SO45797 | 2022-07-19 | 33.56 | 413.15 | 419.46 | |||
SO53483_37 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 231 | 2 | 408 | 6 | 6.96 | 2023-12-24 | 347.93 | 8.52 | 2023-12-12 | 12 | 38.49 | 1 | 340.97 | 37 | SO53483 | 2023-12-19 | 27.28 | 461.91 | 28.99 | 0.02 |
SO45797_13 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 334 | 679 | 6 | 2022-07-24 | 1677.84 | 41.95 | 2022-07-12 | 4 | 413.15 | 1 | 1677.84 | 13 | SO45797 | 2022-07-19 | 134.23 | 1652.59 | 419.46 | |||
SO53483_38 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 568 | 13 | 408 | 6 | 200.43 | 2023-12-24 | 1336.23 | 28.39 | 2023-12-12 | 4 | 461.44 | 1 | 1135.80 | 38 | SO53483 | 2023-12-19 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO45797_14 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 232 | 679 | 6 | 2022-07-24 | 28.84 | 0.72 | 2022-07-12 | 1 | 31.72 | 1 | 28.84 | 14 | SO45797 | 2022-07-19 | 2.31 | 31.72 | 28.84 | |||
SO53483_39 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 234 | 2 | 408 | 6 | 6.96 | 2023-12-24 | 347.93 | 8.52 | 2023-12-12 | 12 | 38.49 | 1 | 340.97 | 39 | SO53483 | 2023-12-19 | 27.28 | 461.91 | 28.99 | 0.02 |
SO45797_15 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 324 | 679 | 6 | 2022-07-24 | 1258.38 | 31.46 | 2022-07-12 | 3 | 413.15 | 1 | 1258.38 | 15 | SO45797 | 2022-07-19 | 100.67 | 1239.44 | 419.46 | |||
SO53483_40 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 214 | 2 | 408 | 6 | 5.68 | 2023-12-24 | 284.12 | 6.96 | 2023-12-12 | 14 | 13.09 | 1 | 278.44 | 40 | SO53483 | 2023-12-19 | 22.27 | 183.21 | 20.29 | 0.02 |
SO45797_16 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 314 | 679 | 6 | 2022-07-24 | 6440.89 | 161.02 | 2022-07-12 | 3 | 2171.29 | 1 | 6440.89 | 16 | SO45797 | 2022-07-19 | 515.27 | 6513.88 | 2146.96 | |||
SO53483_41 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 566 | 13 | 408 | 6 | 100.22 | 2023-12-24 | 668.12 | 14.20 | 2023-12-12 | 2 | 461.44 | 1 | 567.90 | 41 | SO53483 | 2023-12-19 | 45.43 | 922.89 | 334.06 | 0.15 |
SO45797_17 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 212 | 679 | 6 | 2022-07-24 | 20.19 | 0.50 | 2022-07-12 | 1 | 12.03 | 1 | 20.19 | 17 | SO45797 | 2022-07-19 | 1.61 | 12.03 | 20.19 | |||
SO53483_42 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 573 | 408 | 6 | 2023-12-24 | 11443.54 | 286.09 | 2023-12-12 | 8 | 1481.94 | 1 | 11443.54 | 42 | SO53483 | 2023-12-19 | 915.48 | 11855.50 | 1430.44 | |||
SO45797_18 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 326 | 679 | 6 | 2022-07-24 | 838.92 | 20.97 | 2022-07-12 | 2 | 413.15 | 1 | 838.92 | 18 | SO45797 | 2022-07-19 | 67.11 | 826.29 | 419.46 | |||
SO53483_43 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 472 | 408 | 6 | 2023-12-24 | 152.40 | 3.81 | 2023-12-12 | 4 | 23.75 | 1 | 152.40 | 43 | SO53483 | 2023-12-19 | 12.19 | 95.00 | 38.10 | |||
SO45797_19 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 285 | 679 | 6 | 2022-07-24 | 178.58 | 4.46 | 2022-07-12 | 1 | 176.20 | 1 | 178.58 | 19 | SO45797 | 2022-07-19 | 14.29 | 176.20 | 178.58 | |||
SO53483_44 | A0BE-40E0-81 | PO14761137153 | 19 | 284 | 487 | 2 | 408 | 6 | 7.65 | 2023-12-24 | 382.73 | 9.38 | 2023-12-12 | 12 | 20.57 | 1 | 375.08 | 44 | SO53483 | 2023-12-19 | 30.01 | 246.80 | 31.89 | 0.02 |
SO45797_20 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 313 | 679 | 6 | 2022-07-24 | 4293.92 | 107.35 | 2022-07-12 | 2 | 2171.29 | 1 | 4293.92 | 20 | SO45797 | 2022-07-19 | 343.51 | 4342.59 | 2146.96 | |||
SO53484_1 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 474 | 4 | 497 | 6 | 87.49 | 2023-12-24 | 874.88 | 19.68 | 2023-12-12 | 25 | 26.18 | 1 | 787.39 | 1 | SO53484 | 2023-12-19 | 62.99 | 654.41 | 35.00 | 0.10 |
SO45797_21 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 340 | 679 | 6 | 2022-07-24 | 419.46 | 10.49 | 2022-07-12 | 1 | 413.15 | 1 | 419.46 | 21 | SO45797 | 2022-07-19 | 33.56 | 413.15 | 419.46 | |||
SO53484_2 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 361 | 497 | 6 | 2023-12-24 | 6884.97 | 172.12 | 2023-12-12 | 5 | 1251.98 | 1 | 6884.97 | 2 | SO53484 | 2023-12-19 | 550.80 | 6259.91 | 1376.99 | |||
SO45797_22 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 319 | 679 | 6 | 2022-07-24 | 2624.38 | 65.61 | 2022-07-12 | 3 | 884.71 | 1 | 2624.38 | 22 | SO45797 | 2022-07-19 | 209.95 | 2654.12 | 874.79 | |||
SO53484_3 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 363 | 497 | 6 | 2023-12-24 | 4130.98 | 103.27 | 2023-12-12 | 3 | 1251.98 | 1 | 4130.98 | 3 | SO53484 | 2023-12-19 | 330.48 | 3755.94 | 1376.99 | |||
SO45797_23 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 235 | 679 | 6 | 2022-07-24 | 115.36 | 2.88 | 2022-07-12 | 4 | 31.72 | 1 | 115.36 | 23 | SO45797 | 2022-07-19 | 9.23 | 126.90 | 28.84 | |||
SO53484_4 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 516 | 497 | 6 | 2023-12-24 | 93.94 | 2.35 | 2023-12-12 | 4 | 17.38 | 1 | 93.94 | 4 | SO53484 | 2023-12-19 | 7.51 | 69.51 | 23.48 | |||
SO45797_24 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 328 | 679 | 6 | 2022-07-24 | 419.46 | 10.49 | 2022-07-12 | 1 | 413.15 | 1 | 419.46 | 24 | SO45797 | 2022-07-19 | 33.56 | 413.15 | 419.46 | |||
SO53484_5 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 544 | 497 | 6 | 2023-12-24 | 194.38 | 4.86 | 2023-12-12 | 4 | 35.96 | 1 | 194.38 | 5 | SO53484 | 2023-12-19 | 15.55 | 143.84 | 48.59 | |||
SO45797_25 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 229 | 679 | 6 | 2022-07-24 | 28.84 | 0.72 | 2022-07-12 | 1 | 31.72 | 1 | 28.84 | 25 | SO45797 | 2022-07-19 | 2.31 | 31.72 | 28.84 | |||
SO53484_6 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 588 | 497 | 6 | 2023-12-24 | 923.39 | 23.08 | 2023-12-12 | 2 | 419.78 | 1 | 923.39 | 6 | SO53484 | 2023-12-19 | 73.87 | 839.56 | 461.69 | |||
SO45797_26 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 264 | 679 | 6 | 2022-07-24 | 183.94 | 4.60 | 2022-07-12 | 1 | 181.49 | 1 | 183.94 | 26 | SO45797 | 2022-07-19 | 14.72 | 181.49 | 183.94 |
Generated 2024-11-10 15:03:34.085 UTC