USP_DATAELEMENT_RECORDOPERATION_PROMPTDATA
Retrieves the prompt data for accounting element record operations.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @ELEMENTNAME | nvarchar(100) | INOUT | |
| @SHORTID | nvarchar(100) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAELEMENT_RECORDOPERATION_PROMPTDATA
(
@ID uniqueidentifier,
@ELEMENTNAME nvarchar(100) = null output,
@SHORTID nvarchar(100) = null output
)
as begin
set nocount on;
select
@ELEMENTNAME = PDACCOUNTSTRUCTURE.DESCRIPTION,
@SHORTID = SHORTDESCRIPTION
from
dbo.PDACCOUNTSEGMENTVALUE
inner join
dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID = PDACCOUNTSTRUCTURE.ID
where
PDACCOUNTSEGMENTVALUE.ID = @ID;
return 0;
end