CREATE TABLE [dbo].[Resource_Mat](

[Plant] [varchar](4) NOT NULL,

[Material_number] [varchar](18) NOT NULL,

[Production_Version] [varchar](4) NOT NULL,

[Resource_Code] [varchar](8) NOT NULL,

[Std_Batch_Size] [varchar](18) NULL,

[UOM] [varchar](3) NULL,

[Std_Run_Time] [varchar](14) NULL,

[Time_UOM] [varchar](3) NULL,

[Batch_Min] [varchar](17) NULL,

[Batch_Max] [varchar](17) NULL,

[Stocking_Strategy] [varchar](2) NULL,

[Trans_Type] [varchar](2) NULL,

[Recipe_Status] [varchar](4) NULL,

[Short_Description] [varchar](40) NULL,

[Rounding_Value] [varchar](17) NULL,

[Distribution_Key] [varchar](4) NULL,

CONSTRAINT [PK_Resource_Mat] PRIMARY KEY CLUSTERED

(

[Plant] ASC,

[Material_number] ASC,

[Production_Version] ASC,

[Resource_Code] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO