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