Step 4 (On Premises): Create the SQL Server Table
As part of the business scenario, the message X12 sales order message sent by Contoso to Northwind must finally be inserted in a SalesOrder table, if the quantity ordered is greater than 100. This topic provides instructions on how to create the SalesOrder table within a SQL Server database instance that is housed on-premises.
To create the SalesOrder table
Open SQL Server Management Studio and run the following query against the database where you want to create the table.
Run the following query to create the SalesOrder table:
CREATE TABLE [dbo].[SalesOrder] ( [SalesOrderID] int IDENTITY(1,1) NOT NULL, [PartNum] int NOT NULL, [DateRequested] datetime NULL, [CompanyCode] varchar(3) NOT NULL, [Qty] int NOT NULL, [UnitAskPrice] float NULL, [ShipDate] datetime NOT NULL, [SellToAddress] varchar(255) NULL, [BillToAddress] varchar(255) NOT NULL, [PartnerContact] varchar(128) NULL, [CustomerComments] varchar(500) NULL, [RFQStatuesId] smallint NULL ); GO
Verify that the table is created in the target database.