BATCHREVENUECONSTITUENT

Stores data for constituents added to revenue batch.

For the full definition of the BATCHREVENUECONSTITUENT table, see BATCHREVENUECONSTITUENT.

Fields

Field	Change	Field Type	Null	Notes	Description
NAME	Changed	nvarchar(154) (Computed)	yes	CASE ISORGANIZATION WHEN 1 THEN CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' + KEYNAME END ELSE CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + KEYNAME END	Returns the constituent name (First + Middle Initial + Last (individuals), Prefix + Org name (orgs)).Expression changed from CASE ISORGANIZATION WHEN 1 THEN CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' + KEYNAME END ELSE CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + KEYNAME END to CASE ISORGANIZATION WHEN 1 THEN CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' + KEYNAME END ELSE CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + KEYNAME END