V_QUERY_BATCH
Provides the ability to query Batch.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| BATCHNUMBER | nvarchar(100) | Batch number | |
| DESCRIPTION | nvarchar(1000) | Description | |
| BATCHTEMPLATEID | uniqueidentifier | Batch design | |
| PROJECTEDNUMBEROFRECORDS | int | Projected number of records | |
| PROJECTEDTOTALAMOUNT | money | Projected total | |
| STATUS | nvarchar(11) | yes | Status |
| DATECOMMITTED | datetime | yes | Date committed |
| COMMENTS | nvarchar(2000) | Comments | |
| EFTFILECREATED | bit | EFT file created | |
| ORIGINATINGBATCHID | nvarchar(100) | yes | Originating batch |
| BATCHWORKFLOWSTATEID | uniqueidentifier | batch workflow state | |
| APPUSER | nvarchar(128) | yes | Owner |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| ALLOWNEWROWS | bit | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:37:32 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BATCH AS
select
BATCH.ID,
BATCH.BATCHNUMBER,
BATCH.DESCRIPTION,
BATCH.BATCHTEMPLATEID,
BATCH.PROJECTEDNUMBEROFRECORDS,
BATCH.PROJECTEDTOTALAMOUNT,
BATCH.STATUS,
BATCH.DATECOMMITTED,
BATCH.COMMENTS,
BATCH.EFTFILECREATED,
([ORIGINALBATCH].BATCHNUMBER) ORIGINATINGBATCHID,
BATCH.BATCHWORKFLOWSTATEID,
(select APPUSER.USERNAME from dbo.APPUSER where ID = BATCH.APPUSERID) APPUSER,
BATCH.DATEADDED,
BATCH.DATECHANGED,
BATCH.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
cast(case when BATCH.DISABLEADDNEWROW = 1 or BATCHTYPECATALOG.SPECXML.value('declare namespace tns="bb_appfx_batchtype"; (tns:BatchTypeSpec/@DisableAddNewRow)[1]', 'bit')=1 then 0 else 1 end as bit) ALLOWNEWROWS
from dbo.BATCH
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = BATCH.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = BATCH.CHANGEDBYID
left join dbo.BATCH [ORIGINALBATCH] on [ORIGINALBATCH].ID = BATCH.ORIGINATINGBATCHID
left join dbo.BATCHTEMPLATE on BATCH.BATCHTEMPLATEID=BATCHTEMPLATE.ID
left join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID=BATCHTYPECATALOG.ID