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