USP_DATAFORMTEMPLATE_VIEW_JOURNALENTRY_ELEMENTMETADATA
The load procedure used by the view dataform template "Account Structure Element View For Journal Entry"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @ELEMENTMETADATA | xml | INOUT | Account element meta data |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_JOURNALENTRY_ELEMENTMETADATA
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@ELEMENTMETADATA xml = null output
)
as
set nocount on;
-- be sure to set this, in case the select returns no rows
set @DATALOADED = 0;
-- populate the output parameters, which correspond to fields on the form. Note that
-- we set @DATALOADED = 1 to indicate that the load was successful. Otherwise, the system
-- will display a "no data loaded" message.
select @DATALOADED = 1,
@ELEMENTMETADATA = (
select
E.ID as ID
,E.DESCRIPTION as COLUMNHEADER
,case when E.ELEMENTTYPECODE = 1 then 1 else 0 end as ISACCOUNTSEGMENT
,CLOSINGELEMENT as ISCLOSINGELEMENT
,E.SEGMENTSEQUENCE
,E.ELEMENTDEFINITIONCODE
,E.SEQUENCE
,E.LENGTH as FIELDLENGTH
,E.SEGMENTCOLUMN
from
dbo.PDACCOUNTSTRUCTURE E
inner join dbo.FINANCIALTRANSACTION FT on E.PDACCOUNTSYSTEMID = FT.PDACCOUNTSYSTEMID and FT.ID = @ID
order by
E.SEQUENCE
for xml raw('ITEM'),type,elements,root('ELEMENTMETADATA'),binary base64
)
return 0;