USP_DATAFORMTEMPLATE_EDITLOAD_REVENUESPLIT_BUSINESSUNIT

The load procedure used by the edit dataform template "Revenue Split Business Unit Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@BUSINESSUNITS	xml	INOUT	Business units
@AMOUNT	money	INOUT	Amount
@OVERRIDEBUSINESSUNITS	bit	INOUT	Override business units
@REASON	uniqueidentifier	INOUT	Reason
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@BASECURRENCYID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUESPLIT_BUSINESSUNIT
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @BUSINESSUNITS xml = null output,
  @AMOUNT money = null output,
  @OVERRIDEBUSINESSUNITS bit = null output,
  @REASON uniqueidentifier = null output,
  @TSLONG bigint = 0 output,
  @BASECURRENCYID uniqueidentifier = null output
)
as
  set nocount on;

  -- be sure to set these, in case the select returns no rows
  set @DATALOADED = 0
  set @TSLONG = 0

  select
    @DATALOADED = 1,
    @BUSINESSUNITS = dbo.UFN_REVENUESPLITBUSINESSUNIT_CONVERTAMOUNTSINXML(dbo.UFN_REVENUESPLITBUSINESSUNIT_GETBUSINESSUNITS_TOITEMLISTXML(@ID),isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID),null),
    @AMOUNT = FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT,
    @OVERRIDEBUSINESSUNITS = REVENUESPLIT_EXT.OVERRIDEBUSINESSUNITS,
    @REASON = REVENUESPLIT_EXT.REVENUESPLITBUSINESSUNITOVERRIDECODEID,
    @BASECURRENCYID = isnull(REVENUE_EXT.NONPOSTABLEBASECURRENCYID, CURRENCYSET.BASECURRENCYID),
    @TSLONG = FINANCIALTRANSACTIONLINEITEM.TSLONG    
  from
    dbo.FINANCIALTRANSACTIONLINEITEM
  inner join
    dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
  inner join
    dbo.FINANCIALTRANSACTION on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
  inner join
    dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
  inner join 
    dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
  inner join 
    dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
  where
    FINANCIALTRANSACTIONLINEITEM.ID = @ID
    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1

  return 0;