DimGlTransDetailLoad
 GetGlTransDetails_fromVerify (Variable)
Home  Diagrams  Documents  Images  DimGlTransDetailLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimGlTransDetailLoad   Variables   GetGlTransDetails_fromVerify
  Properties
Property Value
Name GetGlTransDetails_fromVerify
Value Expression: "SELECT VerifyGLDetailSK ,GlDetailAK ,GlCalendarPeriod ,JournalNumber ,LineNumber ,JournalTypeCode ,JournalType ,JournalGrouping ,BudgetTypeCode ,BudgetType ,RowIsDuplicate ,RowIsSelected FROM Verify_dbo_DimGlTransDetail WHERE RowIsSelected = 'Y' AND LEFT(GlCalendarPeriod,4) = '" + @[User::YearList] + "' ORDER BY GlDetailAK"

SELECT VerifyGLDetailSK ,GlDetailAK ,GlCalendarPeriod ,JournalNumber ,LineNumber ,JournalTypeCode ,JournalType ,JournalGrouping ,BudgetTypeCode ,BudgetType ,RowIsDuplicate ,RowIsSelected FROM Verify_dbo_DimGlTransDetail WHERE RowIsSelected = 'Y' AND LEFT(GlCalendarPeriod,4) = '' ORDER BY GlDetailAK
Value Type String
Description
System Variable False
Namespace User
Qualified Name User::GetGlTransDetails_fromVerify
Evaluate As Expression True
Expression "SELECT VerifyGLDetailSK ,GlDetailAK ,GlCalendarPeriod ,JournalNumber ,LineNumber ,JournalTypeCode ,JournalType ,JournalGrouping ,BudgetTypeCode ,BudgetType ,RowIsDuplicate ,RowIsSelected FROM Verify_dbo_DimGlTransDetail WHERE RowIsSelected = 'Y' AND LEFT(GlCalendarPeriod,4) = '" + @[User::YearList] + "' ORDER BY GlDetailAK"
ID 74939bf1-8aa8-4e9b-9c6a-1b3b36da70b8
Raise Changed Event False
Powered by BI Documenter