CREATE PROCEDURE Print_TransLine
	-- Add the parameters for the stored procedure here
	(@DocKey@ INT, @ObjectId@ INT)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	DECLARE @object NVARCHAR(4000)

	IF (@ObjectId@=13) SET @object = 'INV'
	ELSE IF (@ObjectId@=14) SET @object = 'RIN'
	ELSE IF (@ObjectId@=15) SET @object = 'DLN'
	ELSE IF (@ObjectId@=16) SET @object = 'RDN'
	ELSE IF (@ObjectId@=17) SET @object = 'RDR'
	ELSE IF (@ObjectId@=18) SET @object = 'PCH'
	ELSE IF (@ObjectId@=19) SET @object = 'RPC'
	ELSE IF (@ObjectId@=20) SET @object = 'PDN'
	ELSE IF (@ObjectId@=21) SET @object = 'RPD'
	ELSE IF (@ObjectId@=22) SET @object = 'POR'
	ELSE IF (@ObjectId@=23) SET @object = 'QUT'
	ELSE IF (@ObjectId@=24) SET @object = 'RCT'
	ELSE IF (@ObjectId@=25) SET @object = 'DPS'
	ELSE IF (@ObjectId@=46) SET @object = 'VPM'
	ELSE IF (@ObjectId@=58) SET @object = 'INM'
	ELSE IF (@ObjectId@=59) SET @object = 'IGN'
	ELSE IF (@ObjectId@=60) SET @object = 'IGE'
	ELSE IF (@ObjectId@=67) SET @object = 'WTR'
	ELSE IF (@ObjectId@=68) SET @object = 'WKO'
	ELSE IF (@ObjectId@=69) SET @object = 'IPF'
	ELSE IF (@ObjectId@=112) SET @object = 'DRF'
	ELSE IF (@ObjectId@=132) SET @object = 'CIN'
	ELSE IF (@ObjectId@=140) SET @object = 'PDF'
	ELSE IF (@ObjectId@=162) SET @object = 'MRV'
	ELSE IF (@ObjectId@=163) SET @object = 'CPI'
	ELSE IF (@ObjectId@=164) SET @object = 'CPV'
	ELSE IF (@ObjectId@=165) SET @object = 'CSI'
	ELSE IF (@ObjectId@=166) SET @object = 'CSV'
	ELSE IF (@ObjectId@=191) SET @object = 'SCL'
	ELSE IF (@ObjectId@=198) SET @object = 'FCT'
	ELSE IF (@ObjectId@=199) SET @object = 'MSN'
	ELSE IF (@ObjectId@=202) SET @object = 'WOR'
	ELSE IF (@ObjectId@=203) SET @object = 'DPI'
	ELSE IF (@ObjectId@=204) SET @object = 'DPO'
	ELSE IF (@ObjectId@=321) SET @object = 'ITR'
	ELSE IF (@ObjectId@=140000009) SET @object = 'OEI'
	ELSE IF (@ObjectId@=140000010) SET @object = 'IEI'
	ELSE IF (@ObjectId@=540000006) SET @object = 'PQT'


	exec ('select T0.LangCode, T1.LineNum, 	ISNULL((select MLT1.Trans from OMLT INNER JOIN MLT1 ON OMLT.TranEntry = MLT1.TranEntry where MLT1.LangCode = T0.LangCode AND OMLT.PK = T1.ItemCode AND TableName = ''OITM'' AND FieldAlias = ''ItemName''), T1.Dscription) AS Artikelname,
		ISNULL((select MLT1.Trans from OMLT INNER JOIN MLT1 ON OMLT.TranEntry = MLT1.TranEntry where MLT1.LangCode = T0.LangCode AND OMLT.PK = T1.ItemCode AND TableName = ''OITM'' AND FieldAlias = ''UserText''), T1.Text) AS Artikellangtext
		from O' + @object + ' T0 INNER JOIN ' + @object + '1 T1 ON T0.DocEntry = T1.DocEntry where T0.DocEntry = ' + @DocKey@)
END
GO