USP_DATAFORMTEMPLATE_ADD_REVENUEBATCHINDIVIDUAL_PRELOAD

The load procedure used by the edit dataform template "Revenue Batch Individual Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ISORGANIZATION	bit	INOUT
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@BUSINESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REVENUEBATCHINDIVIDUAL_PRELOAD(
    @ISORGANIZATION bit = null output,
    @ADDRESS_COUNTRYID uniqueidentifier = null output,
    @BUSINESS_COUNTRYID uniqueidentifier = null output,
    @ZIPLOOKUPCOUNTRIES xml = null output,
    @VALIDATIONCOUNTRIES xml = null output,
    @CONSTITUENTTYPE int = null output
) as
    set nocount on;
    exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;
    set @BUSINESS_COUNTRYID = @ADDRESS_COUNTRYID;

    select @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
    select @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();

    set @ISORGANIZATION = 0;
    set @CONSTITUENTTYPE = 0;

return 0;