[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 5891 > < TAKE 14 >
14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47027_35 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 216 | 436 | 4 | 2022-10-03 | 80.75 | 2.02 | 2022-09-21 | 4 | 13.88 | 1 | 80.75 | 35 | SO47027 | 2022-09-28 | 6.46 | 55.51 | 20.19 | |||
SO47027_36 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 323 | 436 | 4 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 36 | SO47027 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO47027_37 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 377 | 436 | 4 | 2022-10-03 | 2617.88 | 65.45 | 2022-09-21 | 2 | 1320.68 | 1 | 2617.88 | 37 | SO47027 | 2022-09-28 | 209.43 | 2641.37 | 1308.94 | |||
SO47027_38 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 325 | 436 | 4 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 38 | SO47027 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO47027_39 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 239 | 436 | 4 | 2022-10-03 | 6246.55 | 156.16 | 2022-09-21 | 8 | 722.26 | 1 | 6246.55 | 39 | SO47027 | 2022-09-28 | 499.72 | 5778.05 | 780.82 | |||
SO47027_40 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 381 | 436 | 4 | 2022-10-03 | 1800.79 | 45.02 | 2022-09-21 | 3 | 605.65 | 1 | 1800.79 | 40 | SO47027 | 2022-09-28 | 144.06 | 1816.95 | 600.26 | |||
SO47027_41 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 387 | 436 | 4 | 2022-10-03 | 1200.53 | 30.01 | 2022-09-21 | 2 | 605.65 | 1 | 1200.53 | 41 | SO47027 | 2022-09-28 | 96.04 | 1211.30 | 600.26 | |||
SO47027_42 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 254 | 436 | 4 | 2022-10-03 | 551.81 | 13.80 | 2022-09-21 | 3 | 170.14 | 1 | 551.81 | 42 | SO47027 | 2022-09-28 | 44.15 | 510.43 | 183.94 | |||
SO47027_43 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 339 | 436 | 4 | 2022-10-03 | 1409.38 | 35.23 | 2022-09-21 | 3 | 486.71 | 1 | 1409.38 | 43 | SO47027 | 2022-09-28 | 112.75 | 1460.12 | 469.79 | |||
SO47027_44 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 333 | 436 | 4 | 2022-10-03 | 4228.15 | 105.70 | 2022-09-21 | 9 | 486.71 | 1 | 4228.15 | 44 | SO47027 | 2022-09-28 | 338.25 | 4380.36 | 469.79 | |||
SO47027_45 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 327 | 9 | 436 | 4 | 493.28 | 2022-10-03 | 1644.28 | 28.77 | 2022-09-21 | 7 | 486.71 | 1 | 1151.00 | 45 | SO47027 | 2022-09-28 | 92.08 | 3406.95 | 234.90 | 0.30 |
SO47027_46 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 385 | 436 | 4 | 2022-10-03 | 2401.05 | 60.03 | 2022-09-21 | 4 | 605.65 | 1 | 2401.05 | 46 | SO47027 | 2022-09-28 | 192.08 | 2422.60 | 600.26 | |||
SO47027_47 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 415 | 436 | 4 | 2022-10-03 | 990.18 | 24.75 | 2022-09-21 | 5 | 146.55 | 1 | 990.18 | 47 | SO47027 | 2022-09-28 | 79.21 | 732.73 | 198.04 | |||
SO47027_48 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 407 | 436 | 4 | 2022-10-03 | 262.41 | 6.56 | 2022-09-21 | 4 | 48.55 | 1 | 262.41 | 48 | SO47027 | 2022-09-28 | 20.99 | 194.18 | 65.60 |
Generated 2024-09-20 21:37:20.881 UTC