CREATE TABLE [dbo].[VS4TShipInstruct] (
	[TSHINo] [nvarchar] (30) COLLATE Thai_CI_AS NOT NULL ,
	[TSHIDate] [datetime] NULL ,
	[TPKLRefNo] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHIConsignee] [nvarchar] (255) COLLATE Thai_CI_AS NULL ,
	[TPKLRefDate] [datetime] NULL ,
	[TSHINotifyParty] [nvarchar] (255) COLLATE Thai_CI_AS NULL ,
	[TPKLRefNo2] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHIAttention] [nvarchar] (255) COLLATE Thai_CI_AS NULL ,
	[TSHIShippingName] [nvarchar] (255) COLLATE Thai_CI_AS NULL ,
	[TSHIShipBy] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHIBookingNo] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHITPrjCode] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHITBraCode] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TPKLDeliveryTerm] [real] NULL ,
	[TSHITARNCode] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TPKLContainerNo] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHITShpCode] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHIDeliveryCond] [smallint] NULL ,
	[TPKLTotalQuantity] [float] NULL ,
	[TSHILoadingPort] [nvarchar] (100) COLLATE Thai_CI_AS NULL ,
	[TPKLTotalCarton] [float] NULL ,
	[TSHIContainerNo] [nvarchar] (255) COLLATE Thai_CI_AS NULL ,
	[TPKLTotalNW] [float] NULL ,
	[TSHIIncoTerms] [nvarchar] (100) COLLATE Thai_CI_AS NULL ,
	[TPKLTotalGW] [float] NULL ,
	[TSHIETDDate] [datetime] NULL ,
	[TPKLTotalVolumeM] [float] NULL ,
	[TSHIETADate] [datetime] NULL ,
	[TPKLGrandTotal] [money] NULL ,
	[TSHIVessel] [nvarchar] (255) COLLATE Thai_CI_AS NULL ,
	[TPKLGrandTotalReal] [money] NULL ,
	[TSHIDescription] [nvarchar] (255) COLLATE Thai_CI_AS NULL ,
	[TSHICreateCode] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHICreateBy] [nvarchar] (140) COLLATE Thai_CI_AS NULL ,
	[TSHICreateDate] [datetime] NULL ,
	[TSHIEditCode] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHIEditBy] [nvarchar] (140) COLLATE Thai_CI_AS NULL ,
	[TSHIEditDate] [datetime] NULL ,
	[TSHIConfirmStatus] [smallint] NULL ,
	[TSHIConfirmBy] [nvarchar] (140) COLLATE Thai_CI_AS NULL ,
	[TSHIConfirmDate] [datetime] NULL ,
	[TSHIApproveStatus] [smallint] NULL ,
	[TSHIApproveBy] [nvarchar] (140) COLLATE Thai_CI_AS NULL ,
	[TSHIApproveDate] [datetime] NULL ,
	[TSHIApproveNote] [nvarchar] (80) COLLATE Thai_CI_AS NULL ,
	[TSHIConfidential] [smallint] NULL ,
	[TSHICancelStatus] [smallint] NULL ,
	[TSHICancelNo] [nvarchar] (30) COLLATE Thai_CI_AS NULL ,
	[TSHICancelBy] [nvarchar] (140) COLLATE Thai_CI_AS NULL ,
	[TSHICancelDate] [datetime] NULL ,
	[TSHICancelNote] [nvarchar] (80) COLLATE Thai_CI_AS NULL ,
	[TSHIFlag1] [smallint] NULL ,
	[TSHIFlag2] [smallint] NULL ,
	[TSHIFlag3] [smallint] NULL 
) ON [PRIMARY]
GO

