|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | arch_Gl_Budget |
| Schema | dbo |
| Quoted Identifier Status | True |
| Ansi Nulls Status | True |
| Returns View Metadata | False |
| Create Date | 9/30/2015 11:39 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Fulltext Indexed |
Identity |
Description / Computed Formula |
varchar(4) |
True |
False |
False |
||
varchar(25) |
True |
False |
False |
||
numeric(38, 2) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
Parent Dependencies (objects that dbo.arch_Gl_Budget depends on)
| Name | Type |
Table |
Child Dependencies (objects that depend on dbo.arch_Gl_Budget)
| Name | Type |
TABLE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: View [dbo].[arch_Gl_Budget] Script Date: 03/09/2017 16:47:08 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE VIEW [dbo].[arch_Gl_Budget] AS SELECT SUBSTRING(PERIOD_FISCAL, 1, 4) AS FiscalYear ,GL_ACCT_NO, SUM(AMOUNT) AS GLTransAmount FROM dbo.GL_TRANS_FILE WHERE (JOURNAL_TYPE = 'BT' ) GROUP BY SUBSTRING(PERIOD_FISCAL, 1, 4), GL_ACCT_NO |
| Powered by BI Documenter |
