UFN_MKTASKLADDER_GETITEMLIST
Returns a table of all of the value items associated with a given ask ladder.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASKLADDERID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTASKLADDER_GETITEMLIST]
(
@ASKLADDERID uniqueidentifier
)
returns table
as
return
(
select
[ID],
[MINIMUMENTRYAMOUNT],
[TYPECODE],
[ITEMVALUE1],
[ITEMVALUE2],
[ITEMVALUE3],
[ITEMVALUE4],
[ITEMVALUE5],
[WRITEINTEXT],
[ROUNDTOAMOUNT],
[BASECURRENCYID], -- hidden columns
[ORGANIZATIONEXCHANGERATEID],
[ORGANIZATIONMINIMUMENTRYAMOUNT],
[ORGANIZATIONITEMVALUE1],
[ORGANIZATIONITEMVALUE2],
[ORGANIZATIONITEMVALUE3],
[ORGANIZATIONITEMVALUE4],
[ORGANIZATIONITEMVALUE5]
from dbo.[MKTASKLADDERITEM]
where [ASKLADDERID] = @ASKLADDERID
)