USP_DATAFORMTEMPLATE_ADD_CONTROLACCOUNT_PRELOAD

The load procedure used by the edit dataform template "Subsidiary Ledger Account Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SUBSIDIARYID	uniqueidentifier	INOUT
@SUBSIDIARYNAME	nvarchar(10)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CONTROLACCOUNT_PRELOAD
(
    @CONTEXTID uniqueidentifier,
  @SUBSIDIARYID uniqueidentifier = null output,
    @SUBSIDIARYNAME nvarchar(10) = null output
)
as
    set nocount on;

  select
    @SUBSIDIARYID = ID,
    @SUBSIDIARYNAME = FINANCIALSYSTEM.NAME
  from
    dbo.FINANCIALSYSTEM
  where
    ID = @CONTEXTID

    return 0;