IF exists(SELECT * FROM sysobjects WHERE name = 'LD0P0E55')
                        DROP TABLE LD0P0E55
;


CREATE TABLE LD0P0E55
(
	FSUPPGIFTNR DECIMAL (9) NOT NULL,
	FSUNDERATTELSENR DECIMAL (9) NOT NULL,
	DATUM VARCHAR (8) NOT NULL,
	AEVERKNR DECIMAL (9) NOT NULL,
	BESLUTNR DECIMAL (9) NOT NULL,
	HAND VARCHAR (10) NOT NULL,
	HANDLNAMN VARCHAR (60) NOT NULL,
	HANDLTEL VARCHAR (20) NOT NULL,
	HANDLEPOST VARCHAR (60) NOT NULL,
	HANDLINGSTYP DECIMAL (1) NOT NULL,
	MODERPNR VARCHAR (12) NOT NULL,
	MODERFODDAT VARCHAR (12) NOT NULL,
	MODERFORNAMN VARCHAR (80) NOT NULL,
	MODERMELLANNAMN VARCHAR (40) NOT NULL,
	MODEREFTERNAMN VARCHAR (60) NOT NULL,
	FADFOREPNR VARCHAR (12) NOT NULL,
	FADFORFODDAT VARCHAR (12) NOT NULL,
	FADFORSAMORDNINGSNR VARCHAR (12) NOT NULL,
	FADFORFORNAMN VARCHAR (80) NOT NULL,
	FADFORMELLANNAMN VARCHAR (40) NOT NULL,
	FADFOREFTERNAMN VARCHAR (60) NOT NULL,
	FADFORSAMMANBOENDE DECIMAL (1) NOT NULL,
	FADFORCAREOF VARCHAR (35) NOT NULL,
	FADFORUTDELNINGSADRESS1 VARCHAR (35) NOT NULL,
	FADFORUTDELNINGSADRESS2 VARCHAR (35) NOT NULL,
	FADFORPOSTNUMMER VARCHAR (5) NOT NULL,
	FADFORPOSTORT VARCHAR (27) NOT NULL,
	FADFORLAND DECIMAL (9) NOT NULL,
	FADFORMEDBORGARSKAP DECIMAL (9) NOT NULL,
	FADFORGEMENSAMVARDNAD DECIMAL (1) NOT NULL,
	MAKEPNR VARCHAR (12) NOT NULL,
	MAKEFODDAT VARCHAR (12) NOT NULL,
	MAKESAMORDNINGSNR VARCHAR (12) NOT NULL,
	MAKEFORNAMN VARCHAR (80) NOT NULL,
	MAKEMELLANNAMN VARCHAR (40) NOT NULL,
	MAKEEFTERNAMN VARCHAR (60) NOT NULL,
	BARNPNR VARCHAR(12) NOT NULL,
	BARNFODELSEDATUM VARCHAR(12) NOT NULL,
	UPDDAT VARCHAR (8) NOT NULL,
	UPDSIGN VARCHAR (10) NOT NULL
)
;