UFN_PDACCOUNT_CUSTOMSEGEMENTTABLESUPPORTSREVENUEBATCH
Determines if the given account segment supports revenue batch validation.
Return
Return Type |
---|
bit |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PDACCOUNT_CUSTOMSEGEMENTTABLESUPPORTSREVENUEBATCH
(
@PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID uniqueidentifier
)
returns bit
with execute as caller
as begin
declare @RETVAL bit = 0;
-- For a given PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID return 1 if it is supported in batch.
-- The example below is for a segment ID that should never exist
if (@PDACCOUNTTABLESAVAILABLEFORSEGMENTTABLEID = '00000000-0000-0000-0000-000000000000')
set @RETVAL = 1;
return @RETVAL;
end