UFN_BATCHJOURNALENTRIES
Returns journal entries for a batch
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FINANCIALTRANSACTIONLINEITEMID | uniqueidentifier | IN | |
| @RETURNALLELEMENTS | bit | IN |
Definition
Copy
CREATE function dbo.UFN_BATCHJOURNALENTRIES
(
@FINANCIALTRANSACTIONLINEITEMID uniqueidentifier,
@RETURNALLELEMENTS bit=0
)
returns @ELEMENTS table
(
JOURNALENTRYID uniqueidentifier not null,
TRANSACTIONTYPECODE tinyint not null,
CLASSCODE tinyint not null,
JOURNALCODEID uniqueidentifier null,
SEQUENCE int not null,
AMOUNT money null,
PERCENTAGE numeric(20,4) NULL,
COMMENT nvarchar(60) null,
POSTDATE date null,
DATAELEMENT1ID uniqueidentifier null,
DATAELEMENT2ID uniqueidentifier null,
DATAELEMENT3ID uniqueidentifier null,
DATAELEMENT4ID uniqueidentifier null,
DATAELEMENT5ID uniqueidentifier null,
DATAELEMENT6ID uniqueidentifier null,
DATAELEMENT7ID uniqueidentifier null,
DATAELEMENT8ID uniqueidentifier null,
DATAELEMENT9ID uniqueidentifier null,
DATAELEMENT10ID uniqueidentifier null,
DATAELEMENT11ID uniqueidentifier null,
DATAELEMENT12ID uniqueidentifier null,
DATAELEMENT13ID uniqueidentifier null,
DATAELEMENT14ID uniqueidentifier null,
DATAELEMENT15ID uniqueidentifier null,
DATAELEMENT16ID uniqueidentifier null,
DATAELEMENT17ID uniqueidentifier null,
DATAELEMENT18ID uniqueidentifier null,
DATAELEMENT19ID uniqueidentifier null,
DATAELEMENT20ID uniqueidentifier null,
DATAELEMENT21ID uniqueidentifier null,
DATAELEMENT22ID uniqueidentifier null,
DATAELEMENT23ID uniqueidentifier null,
DATAELEMENT24ID uniqueidentifier null,
DATAELEMENT25ID uniqueidentifier null,
DATAELEMENT26ID uniqueidentifier null,
DATAELEMENT27ID uniqueidentifier null,
DATAELEMENT28ID uniqueidentifier null,
DATAELEMENT29ID uniqueidentifier null,
DATAELEMENT30ID uniqueidentifier null,
ANNOTATIONS xml null
) as
begin
insert
@ELEMENTS
select
ID,
TRANSACTIONTYPECODE,
CLASSCODE,
JOURNALCODEID,
SEQUENCE,
TRANSACTIONAMOUNT,
PERCENTAGE,
COMMENT,
POSTDATE,
DATAELEMENT1ID,
DATAELEMENT2ID,
DATAELEMENT3ID,
DATAELEMENT4ID,
DATAELEMENT5ID,
DATAELEMENT6ID,
DATAELEMENT7ID,
DATAELEMENT8ID,
DATAELEMENT9ID,
DATAELEMENT10ID,
DATAELEMENT11ID,
DATAELEMENT12ID,
DATAELEMENT13ID,
DATAELEMENT14ID,
DATAELEMENT15ID,
DATAELEMENT16ID,
DATAELEMENT17ID,
DATAELEMENT18ID,
DATAELEMENT19ID,
DATAELEMENT20ID,
DATAELEMENT21ID,
DATAELEMENT22ID,
DATAELEMENT23ID,
DATAELEMENT24ID,
DATAELEMENT25ID,
DATAELEMENT26ID,
DATAELEMENT27ID,
DATAELEMENT28ID,
DATAELEMENT29ID,
DATAELEMENT30ID,
dbo.UFN_JOURNALENTRYANNOTATIONS_TOITEMLISTXML(ID, NULL, NULL)
from
dbo.JOURNALENTRY
where
FINANCIALTRANSACTIONLINEITEMID=@FINANCIALTRANSACTIONLINEITEMID
order by
SEQUENCE
return
end