UFN_FINANCIALTRANSACTION_1099DISTRIBUTION_TOITEMLISTXML
Get an xml list of the 1099 distributions for a given financial transaction.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FINANCIALTRANSACTIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_FINANCIALTRANSACTION_1099DISTRIBUTION_TOITEMLISTXML(@FINANCIALTRANSACTIONID uniqueidentifier) returns xml as begin
return (
select ID, BOXNUMBER1099ID, STATEID, [PERCENT], AMOUNT, SEQUENCE
from dbo.FINANCIALTRANSACTION1099DISTRIBUTION
where FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID
order by SEQUENCE
for xml raw('ITEM'), type, elements, root('FINANCIALTRANSACTION1099DISTRIBUTIONS'), BINARY BASE64
)
end