USP_DATALIST_ADDRESSVALIDATIONPROCESSINPUT

Provides a list of the addresses being submitted for validation.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



CREATE procedure USP_DATALIST_ADDRESSVALIDATIONPROCESSINPUT
(
    @BATCHID uniqueidentifier = null
)
as

    select 
        ADDRESSID,
        COUNTRYID,
        ADDRESSBLOCK,
        CITY,
        STATEID,
        POSTCODE,
        CERTIFICATIONDATA
        from dbo.BATCHADDRESSVALIDATION BATCH
        where BATCH.BATCHID = @BATCHID;

        return 0;