Purchase Orders

Column	Format	Unique value	Contents
Status	Varchar(10)		Order status 0 = No rows Kirjattu = 1 = Registered (new order) 2 = Backorder Toimitettu = 3 = Delivered 4 = Transferred to purchase ledger
OrderId	Varchar(13)	Unique combination OrderId + VendorId	Order number.
VendorId	Smallint	Unique combination OrderId + VendorId	Vendor number.
StoreId	Smallint		Store number.
LocationId	Smallint		Warehouse ID (if different than Store ID).
EstimatedDeliveryDate	Varchar(10) yyyy-mm-dd		Day when vendor is going to deliver the product. End date.
OrderDate	Varchar(10) yyyy-mm-dd		Ordered date.

Example Data

SQL

SELECT TOP 10 *
  FROM dbo.PurchaseOrders

^Status	^OrderId	^VendorId	^StoreId	^LocationId	^{EstimatedDeliveryDate}	^OrderDate
^Toimitettu	^1022022	¹	¹	¹	^2022-02-01	^2022-02-01
^Toimitettu	^01022022/1	¹	¹	¹	^2022-02-01	^2022-02-01
^Toimitettu	^01022022/2	¹	¹	¹	^2022-02-01	^2022-02-01
^Toimitettu	⁴³⁸⁴	¹	¹	¹	^2010-03-03	^2010-03-03
^Toimitettu	⁸⁴	¹	¹	¹	^2010-04-27	^2010-04-27
^Kirjattu	¹	¹	¹	¹	^2012-12-31	^2012-10-02
^Kirjattu	¹	¹⁸	¹	¹	^2009-11-17	^2009-11-17
^Kirjattu	¹	⁸⁹	¹	¹	^2008-06-16	^2008-06-16
^Kirjattu	³⁷²⁵⁷	¹	¹	¹	^2009-08-11	^2009-08-11
^Toimitettu	¹⁰	¹	¹	¹	^2009-12-31	^2009-10-28