V_QUERY_MERCHANDISEDEPARTMENTTAX
Returns all the taxes for a merchandise department.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | yes | System record ID |
| NAME | int | yes | Name |
| DESCRIPTION | int | yes | Description |
| ISACTIVE | int | yes | Active |
| TOTALTAX | int | yes | Total tax |
| MERCHANDISEDEPARTMENTID | uniqueidentifier | yes | MERCHANDISEDEPARTMENTID |
| ADDEDBY_APPLICATION | int | yes | Added by application |
| ADDEDBY_USERNAME | int | yes | Added by user name |
| CHANGEDBY_APPLICATION | int | yes | Changed by application |
| CHANGEDBY_USERNAME | int | yes | Changed by user name |
| DATEADDED | int | yes | Date added |
| DATECHANGED | int | yes | Date changed |
| TSLONG | int | yes | Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 12:58:53 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MERCHANDISEDEPARTMENTTAX AS
select
cast(cast(0 as binary) as uniqueidentifier) as ID,
null as NAME,
null as DESCRIPTION,
null as ISACTIVE,
null as TOTALTAX,
cast(cast(0 as binary) as uniqueidentifier) as [MERCHANDISEDEPARTMENTID],
null as [ADDEDBY_APPLICATION],
null as [ADDEDBY_USERNAME],
null as [CHANGEDBY_APPLICATION],
null as [CHANGEDBY_USERNAME],
null as DATEADDED,
null as DATECHANGED,
null as TSLONG
where
0 = 1