[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 4783 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45781_11 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 262 | 227 | 6 | 2022-06-03 | 551.81 | 13.80 | 2022-05-22 | 3 | 181.49 | 1 | 551.81 | 11 | SO45781 | 2022-05-29 | 44.15 | 544.46 | 183.94 | |||
SO45781_12 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 326 | 227 | 6 | 2022-06-03 | 3775.13 | 94.38 | 2022-05-22 | 9 | 413.15 | 1 | 3775.13 | 12 | SO45781 | 2022-05-29 | 302.01 | 3718.32 | 419.46 | |||
SO45781_13 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 275 | 227 | 6 | 2022-06-03 | 1070.69 | 26.77 | 2022-05-22 | 3 | 352.14 | 1 | 1070.69 | 13 | SO45781 | 2022-05-29 | 85.66 | 1056.42 | 356.90 | |||
SO45781_14 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 241 | 227 | 6 | 2022-06-03 | 2274.23 | 56.86 | 2022-05-22 | 3 | 747.97 | 1 | 2274.23 | 14 | SO45781 | 2022-05-29 | 181.94 | 2243.90 | 758.08 | |||
SO45781_15 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 270 | 227 | 6 | 2022-06-03 | 183.94 | 4.60 | 2022-05-22 | 1 | 181.49 | 1 | 183.94 | 15 | SO45781 | 2022-05-29 | 14.72 | 181.49 | 183.94 | |||
SO45781_16 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 272 | 227 | 6 | 2022-06-03 | 367.88 | 9.20 | 2022-05-22 | 2 | 181.49 | 1 | 367.88 | 16 | SO45781 | 2022-05-29 | 29.43 | 362.97 | 183.94 | |||
SO45781_17 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 342 | 227 | 6 | 2022-06-03 | 2097.29 | 52.43 | 2022-05-22 | 5 | 413.15 | 1 | 2097.29 | 17 | SO45781 | 2022-05-29 | 167.78 | 2065.73 | 419.46 | |||
SO45781_18 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 285 | 227 | 6 | 2022-06-03 | 357.16 | 8.93 | 2022-05-22 | 2 | 176.20 | 1 | 357.16 | 18 | SO45781 | 2022-05-29 | 28.57 | 352.40 | 178.58 | |||
SO45781_19 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 322 | 227 | 6 | 2022-06-03 | 1677.84 | 41.95 | 2022-05-22 | 4 | 413.15 | 1 | 1677.84 | 19 | SO45781 | 2022-05-29 | 134.23 | 1652.59 | 419.46 | |||
SO45781_20 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 317 | 227 | 6 | 2022-06-03 | 5248.76 | 131.22 | 2022-05-22 | 6 | 884.71 | 1 | 5248.76 | 20 | SO45781 | 2022-05-29 | 419.90 | 5308.25 | 874.79 | |||
SO45781_21 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 253 | 227 | 6 | 2022-06-03 | 714.32 | 17.86 | 2022-05-22 | 4 | 176.20 | 1 | 714.32 | 21 | SO45781 | 2022-05-29 | 57.15 | 704.80 | 178.58 | |||
SO45781_22 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 264 | 227 | 6 | 2022-06-03 | 183.94 | 4.60 | 2022-05-22 | 1 | 181.49 | 1 | 183.94 | 22 | SO45781 | 2022-05-29 | 14.72 | 181.49 | 183.94 | |||
SO45781_23 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 238 | 227 | 6 | 2022-06-03 | 3032.30 | 75.81 | 2022-05-22 | 4 | 747.97 | 1 | 3032.30 | 23 | SO45781 | 2022-05-29 | 242.58 | 2991.87 | 758.08 | |||
SO45781_24 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 276 | 227 | 6 | 2022-06-03 | 713.80 | 17.84 | 2022-05-22 | 2 | 352.14 | 1 | 713.80 | 24 | SO45781 | 2022-05-29 | 57.10 | 704.28 | 356.90 | |||
SO45781_25 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 266 | 227 | 6 | 2022-06-03 | 183.94 | 4.60 | 2022-05-22 | 1 | 181.49 | 1 | 183.94 | 25 | SO45781 | 2022-05-29 | 14.72 | 181.49 | 183.94 | |||
SO45781_26 | EB85-4E0C-A3 | PO18444138991 | 19 | 288 | 279 | 227 | 6 | 2022-06-03 | 178.58 | 4.46 | 2022-05-22 | 1 | 176.20 | 1 | 178.58 | 26 | SO45781 | 2022-05-29 | 14.29 | 176.20 | 178.58 | |||
SO45786_1 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 315 | 514 | 6 | 2022-06-03 | 7873.15 | 196.83 | 2022-05-22 | 9 | 884.71 | 1 | 7873.15 | 1 | SO45786 | 2022-05-29 | 629.85 | 7962.37 | 874.79 | |||
SO65171_1 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 476 | 47 | 6 | 2024-05-03 | 83.99 | 2.10 | 2024-04-21 | 2 | 26.18 | 1 | 83.99 | 1 | SO65171 | 2024-04-28 | 6.72 | 52.35 | 41.99 | |||
SO65171_2 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 359 | 47 | 6 | 2024-05-03 | 4130.98 | 103.27 | 2024-04-21 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO65171 | 2024-04-28 | 330.48 | 3755.94 | 1376.99 | |||
SO65171_3 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 475 | 47 | 6 | 2024-05-03 | 83.99 | 2.10 | 2024-04-21 | 2 | 26.18 | 1 | 83.99 | 3 | SO65171 | 2024-04-28 | 6.72 | 52.35 | 41.99 | |||
SO65171_4 | 9B7E-4D7A-B3 | PO17690122097 | 19 | 291 | 474 | 47 | 6 | 2024-05-03 | 419.94 | 10.50 | 2024-04-21 | 10 | 26.18 | 1 | 419.94 | 4 | SO65171 | 2024-04-28 | 33.60 | 261.76 | 41.99 | |||
SO65173_1 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 376 | 155 | 6 | 2024-05-03 | 4398.03 | 109.95 | 2024-04-21 | 3 | 1554.95 | 1 | 4398.03 | 1 | SO65173 | 2024-04-28 | 351.84 | 4664.84 | 1466.01 | |||
SO65173_2 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 582 | 155 | 6 | 2024-05-03 | 5102.97 | 127.57 | 2024-04-21 | 5 | 1082.51 | 1 | 5102.97 | 2 | SO65173 | 2024-04-28 | 408.24 | 5412.55 | 1020.59 | |||
SO65173_3 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 372 | 155 | 6 | 2024-05-03 | 2932.02 | 73.30 | 2024-04-21 | 2 | 1554.95 | 1 | 2932.02 | 3 | SO65173 | 2024-04-28 | 234.56 | 3109.90 | 1466.01 | |||
SO65173_4 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 214 | 155 | 6 | 2024-05-03 | 62.98 | 1.57 | 2024-04-21 | 3 | 13.09 | 1 | 62.98 | 4 | SO65173 | 2024-04-28 | 5.04 | 39.26 | 20.99 | |||
SO65173_5 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 390 | 155 | 6 | 2024-05-03 | 2689.18 | 67.23 | 2024-04-21 | 4 | 713.08 | 1 | 2689.18 | 5 | SO65173 | 2024-04-28 | 215.13 | 2852.32 | 672.29 | |||
SO65173_6 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 547 | 155 | 6 | 2024-05-03 | 97.19 | 2.43 | 2024-04-21 | 2 | 35.96 | 1 | 97.19 | 6 | SO65173 | 2024-04-28 | 7.78 | 71.92 | 48.59 | |||
SO65173_7 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 482 | 2 | 155 | 6 | 1.25 | 2024-05-03 | 62.57 | 1.53 | 2024-04-21 | 12 | 3.36 | 1 | 61.32 | 7 | SO65173 | 2024-04-28 | 4.91 | 40.35 | 5.21 | 0.02 |
SO65173_8 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 378 | 155 | 6 | 2024-05-03 | 11728.08 | 293.20 | 2024-04-21 | 8 | 1554.95 | 1 | 11728.08 | 8 | SO65173 | 2024-04-28 | 938.25 | 12439.58 | 1466.01 | |||
SO65173_9 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 580 | 155 | 6 | 2024-05-03 | 6123.56 | 153.09 | 2024-04-21 | 6 | 1082.51 | 1 | 6123.56 | 9 | SO65173 | 2024-04-28 | 489.89 | 6495.06 | 1020.59 | |||
SO65173_10 | 5315-45D4-AA | PO17545119578 | 19 | 291 | 584 | 155 | 6 | 2024-05-03 | 971.98 | 24.30 | 2024-04-21 | 3 | 343.65 | 1 | 971.98 | 10 | SO65173 | 2024-04-28 | 77.76 | 1030.95 | 323.99 |
Generated 2024-09-20 14:46:08.792 UTC