USP_DATAFORMTEMPLATE_COPY_BALANCINGENTRY_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@COPYID	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_COPY_BALANCINGENTRY_PRELOAD
(
    @COPYID 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;

    set @DESCRIPTION = '' 

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

    return 0;