create table dbo.EXCHANGETABLE
(
	PEX_ID uniqueidentifier PRIMARY KEY,
	PEX_TYPE smallint,
	PEX_NO nvarchar(100),
	PEX_NAME nvarchar(500),
	PEX_KEYNO nvarchar(50),
	PEX_PARENTKEYNO nvarchar(50),
	PEX_DESCRIPTION nvarchar(max),
	PEX_COMMISSION nvarchar(200),
	PEX_EXTERNALNO nvarchar(100),
	PEX_EXTERNALBARCODE nvarchar(100),
	PEX_AMOUNT money,
	PEX_UNIT nvarchar(10),
	PEX_ARTICLENO nvarchar(100),
	PEX_PRICE money,
	PEX_IMPORTPRICE bit,
	PEX_PARTTYPE smallint,
	PEX_LEN money,
	PEX_WID money,
	PEX_THK money,
	PEX_ORIGIN_X money,
	PEX_ORIGIN_Y money,
	PEX_ORIGIN_Z money,
	PEX_BULGE money,
	PEX_UCS_XX money,
	PEX_UCS_XY money,
	PEX_UCS_XZ money,
	PEX_UCS_YX money,
	PEX_UCS_YY money,
	PEX_UCS_YZ money,
	PEX_UCS_ZX money,
	PEX_UCS_ZY money,
	PEX_UCS_ZZ money,
	PEX_ROTATION money,
	PEX_ISTRADE bit,
	PEX_EDGEMODE smallint,
	PEX_EDGECORNER smallint,
	PEX_WITHOUTOUTCONTOUR bit,
	PEX_LOCKAUTOMATISMUS bit,
	PEX_VALUE nvarchar(100),
	PEX_ISUSERFIELD bit,
	PEX_DIAMETER money,
	PEX_ANGLE money,
	PEX_EXTERNALID varchar(200),
	PEX_STATUS smallint
)