CREATE TABLE [dbo].[TMBTDocDTTmpAdj](
	[FTBchCode] [varchar](5) NOT NULL,
	[FTXthDocSeq] [varchar](20) NOT NULL,
	[FNXtdSeqNo] [bigint] NOT NULL,
	[FTXthDocKey] [varchar](20) NULL,
	[FTXthDocType] [varchar](1) NULL,
	[FTXtdBarCode] [varchar](25) NULL,
	[FCXtdQtyAll] [numeric](18, 4) NULL,
	[FTXtdBchRef] [varchar](5) NULL,
	[FDAjdDateTimeC1] [datetime] NULL,
	[FCAjdUnitQtyC1] [numeric](18, 4) NULL,
	[FTAjdPlcCode] [varchar](50) NULL,
	[FDLastUpdOn] [datetime] NULL,
	[FDCreateOn] [datetime] NULL,
	[FTLastUpdBy] [varchar](20) NULL,
	[FTCreateBy] [varchar](20) NULL,
	[FTTmpStatus] [varchar](1) NULL,
	[FTAgnCode] [varchar](20) NOT NULL,
	[FTTmpRemark] [varchar](max) NULL,
 CONSTRAINT [PK_TMBTDocDTTmpAdj] PRIMARY KEY CLUSTERED 
(
	[FTBchCode] ASC,
	[FTXthDocSeq] ASC,
	[FNXtdSeqNo] ASC,
	[FTAgnCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]






CREATE TABLE [dbo].[TMBTDocDTTmp](
	[FTBchCode] [varchar](5) NOT NULL,
	[FTXthDocSeq] [varchar](20) NOT NULL,
	[FTXthDocNo] [varchar](50) NULL,
	[FNXtdSeqNo] [bigint] NOT NULL,
	[FTPORef] [varchar](20) NULL,
	[FTXthDocKey] [nvarchar](20) NULL,
	[FTXthDocType] [nvarchar](1) NULL,
	[FTXtdBarCode] [varchar](25) NULL,
	[FCXtdQty] [numeric](18, 4) NULL,
	[FCXtdQtyAll] [numeric](18, 4) NULL,
	[FCXtdCostIn] [numeric](18, 4) NULL,
	[FDLastUpdOn] [datetime] NULL,
	[FDCreateOn] [datetime] NULL,
	[FTLastUpdBy] [nvarchar](20) NULL,
	[FTCreateBy] [nvarchar](20) NULL,
	[FTAgnCode] [varchar](20) NOT NULL,
	[FTTmpStatus] [nvarchar](1) NULL,
	[FTTmpRemark] [varchar](max) NULL,
 CONSTRAINT [PK_TMBTDocDTTmp] PRIMARY KEY CLUSTERED 
(
	[FTBchCode] ASC,
	[FTXthDocSeq] ASC,
	[FNXtdSeqNo] ASC,
	[FTAgnCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]