|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | smc_Gl_Budget |
| Schema | dbo |
| Quoted Identifier Status | True |
| Ansi Nulls Status | True |
| Returns View Metadata | False |
| Create Date | 10/12/2015 11:43 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Fulltext Indexed |
Identity |
Description / Computed Formula |
varchar(8) |
True |
False |
False |
||
varchar(8) |
True |
False |
False |
||
varchar(9) |
True |
False |
False |
||
varchar(4) |
True |
False |
False |
||
varchar(8) |
True |
False |
False |
||
varchar(6) |
True |
False |
False |
||
varchar(4) |
True |
False |
False |
||
varchar(3) |
True |
False |
False |
||
numeric(38, 2) |
True |
False |
False |
||
varchar(4) |
True |
False |
False |
||
varchar(8) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
Parent Dependencies (objects that dbo.smc_Gl_Budget depends on)
| Name | Type |
Table |
|
Table |
Child Dependencies (objects that depend on dbo.smc_Gl_Budget)
| Name | Type |
TABLE |
|
TABLE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: View [dbo].[smc_Gl_Budget] Script Date: 03/09/2017 16:47:09 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE VIEW [dbo].[smc_Gl_Budget] AS SELECT SUBSTRING(PERIOD_FISCAL, 1, 4) AS FiscalYear ,AM.FundCode AS Fund ,AM.ChartField1 AS ChartField1 ,SUBSTRING(Ledger.GL_ACCT_NO,17,5) + '000' AS Account ,AM.DeptId AS DeptId ,AM.ClassField AS ClassField ,AM.OperatingUnit AS OperatingUnit , BudgetRef, Project, Course ,SUM(AMOUNT) AS GLTransAmount FROM dbo.GL_TRANS_FILE Ledger INNER JOIN SMC_AccountMapping AM ON ( SUBSTRING(Ledger.GL_ACCT_NO, 9, 6) = AM.Qual1 ) WHERE (JOURNAL_TYPE = 'BT' ) GROUP BY SUBSTRING(PERIOD_FISCAL, 1, 4) -- , GL_ACCT_NO ,AM.FundCode ,AM.ChartField1 ,SUBSTRING(Ledger.GL_ACCT_NO,17,5) + '000' ,AM.DeptId ,AM.ClassField ,AM.OperatingUnit ,AM.BudgetRef ,AM.Project ,AM.Course |
| Powered by BI Documenter |
