USP_DATAFORMTEMPLATE_REVERSE_BALANCINGENTRY_PRELOAD

The load procedure used by the edit dataform template "Reverse Balancing Entry Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@REVERSEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DESCRIPTION	nvarchar(60)	INOUT	Description
@BALANCINGENTRYDEBITFROM	xml	INOUT
@BALANCINGENTRYCREDITFROM	xml	INOUT
@BALANCINGENTRYDEBITTO	xml	INOUT
@BALANCINGENTRYCREDITTO	xml	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_REVERSE_BALANCINGENTRY_PRELOAD
(
    @REVERSEID uniqueidentifier,
    @DESCRIPTION nvarchar(60) = null output,
  @BALANCINGENTRYDEBITFROM xml = null output,
  @BALANCINGENTRYCREDITFROM xml = null output,
  @BALANCINGENTRYDEBITTO xml = null output,
  @BALANCINGENTRYCREDITTO xml = null output
)
as
    set nocount on;

    select @DESCRIPTION = '' 
    from dbo.BALANCINGENTRY
    where ID = @REVERSEID

  set @BALANCINGENTRYDEBITFROM = [dbo].[UFN_BALANCINGENTRY_GETELEMENTSCREDITFROM_TOITEMLISTXML](@REVERSEID, 2)
  set @BALANCINGENTRYCREDITFROM = [dbo].[UFN_BALANCINGENTRY_GETELEMENTSDEBITFROM_TOITEMLISTXML](@REVERSEID, 1)
  set @BALANCINGENTRYDEBITTO = [dbo].[UFN_BALANCINGENTRY_GETELEMENTSCREDITTO_TOITEMLISTXML](@REVERSEID, 4)
  set @BALANCINGENTRYCREDITTO = [dbo].[UFN_BALANCINGENTRY_GETELEMENTSDEBITTO_TOITEMLISTXML](@REVERSEID, 3)

    return 0;