USP_DATAFORMTEMPLATE_ADDLOAD_GIFTINKINDAPPRAISAL
The load procedure used by the edit dataform template "Gift-in-Kind Appraisal Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @GIFTINKINDPAYMENTMETHODDETAILID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @TRANSACTIONCURRENCYID | uniqueidentifier | INOUT | Transaction currency |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_GIFTINKINDAPPRAISAL (
@GIFTINKINDPAYMENTMETHODDETAILID uniqueidentifier,
@TRANSACTIONCURRENCYID uniqueidentifier = null output
)
as
set nocount on;
select
@TRANSACTIONCURRENCYID = GIFTINKINDPAYMENTMETHODDETAIL.TRANSACTIONCURRENCYID
from
dbo.GIFTINKINDPAYMENTMETHODDETAIL
where
GIFTINKINDPAYMENTMETHODDETAIL.ID = @GIFTINKINDPAYMENTMETHODDETAILID;
if @TRANSACTIONCURRENCYID is null
set @TRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
return 0;