FactGlRollOverBalancesLoad
 Get_GlRollOverBalances (Variable)
Home  Diagrams  Documents  Images  FactGlRollOverBalancesLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  FactGlRollOverBalancesLoad   Variables   Get_GlRollOverBalances
  Properties
Property Value
Name Get_GlRollOverBalances
Value Expression: "DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */ DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "' SELECT CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '07' + '01' AS int) AS DateSK ,SUBSTRING(Ledger.GL_ACCT_NO,1,16) AS OrgUnitAK ,SUBSTRING(Ledger.GL_ACCT_NO,17,9) AS GlCodeAK ,CAST(Ledger.FISCAL_YEAR + Ledger.GL_ACCT_NO AS varchar(29)) AS YearGlAccountNumberAK ,ISNULL(Monthly.AMOUNT, 0) AS Amount FROM GENERAL_LEDGER_FILE Ledger INNER JOIN GENERAL_LEDGER_FILE_MONTHLY_ACCUMS Monthly ON ( Ledger.ISN_GENERAL_LEDGER_FILE = Monthly.ISN_GENERAL_LEDGER_FILE AND Monthly.cnxarraycolumn = 0 AND Monthly.AMOUNT IS NOT NULL ) WHERE (Ledger.ISN_GENERAL_LEDGER_FILE) IN ( SELECT GENERAL_LEDGER_FILE.ISN_GENERAL_LEDGER_FILE FROM GENERAL_LEDGER_FILE WHERE ( GENERAL_LEDGER_FILE.RowUpdatedOn >= @IncrementalBegi

DECLARE @IncrementalBeginDtTm datetime = 'Jan 1 1900 12:00AM' /* Date and Time to validate against RowUpdatedOn in Source Tables */ DECLARE @IncrementalEndDtTm datetime = 'Mar 4 2016 10:33AM' SELECT CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '07' + '01' AS int) AS DateSK ,SUBSTRING(Ledger.GL_ACCT_NO,1,16) AS OrgUnitAK ,SUBSTRING(Ledger.GL_ACCT_NO,17,9) AS GlCodeAK ,CAST(Ledger.FISCAL_YEAR + Ledger.GL_ACCT_NO AS varchar(29)) AS YearGlAccountNumberAK ,ISNULL(Monthly.AMOUNT, 0) AS Amount FROM GENERAL_LEDGER_FILE Ledger INNER JOIN GENERAL_LEDGER_FILE_MONTHLY_ACCUMS Monthly ON ( Ledger.ISN_GENERAL_LEDGER_FILE = Monthly.ISN_GENERAL_LEDGER_FILE AND Monthly.cnxarraycolumn = 0 AND Monthly.AMOUNT IS NOT NULL ) WHERE (Ledger.ISN_GENERAL_LEDGER_FILE) IN ( SELECT GENERAL_LEDGER_FILE.ISN_GENERAL_LEDGER_FILE FROM GENERAL_LEDGER_FILE WHERE ( GENERAL_LEDGER_FILE.RowUpdatedOn >= @IncrementalBeginDtTm AND GENERAL_LEDGER_FILE.RowUpdatedOn <= @IncrementalEndDtTm ) )
Value Type String
Description This is the SQL statement to retrieve the RollOverBalances from the GENERAL_LEDGER_FILE on the Source System.
System Variable False
Namespace User
Qualified Name User::Get_GlRollOverBalances
Evaluate As Expression True
Expression "DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */ DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "' SELECT CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '07' + '01' AS int) AS DateSK ,SUBSTRING(Ledger.GL_ACCT_NO,1,16) AS OrgUnitAK ,SUBSTRING(Ledger.GL_ACCT_NO,17,9) AS GlCodeAK ,CAST(Ledger.FISCAL_YEAR + Ledger.GL_ACCT_NO AS varchar(29)) AS YearGlAccountNumberAK ,ISNULL(Monthly.AMOUNT, 0) AS Amount FROM GENERAL_LEDGER_FILE Ledger INNER JOIN GENERAL_LEDGER_FILE_MONTHLY_ACCUMS Monthly ON ( Ledger.ISN_GENERAL_LEDGER_FILE = Monthly.ISN_GENERAL_LEDGER_FILE AND Monthly.cnxarraycolumn = 0 AND Monthly.AMOUNT IS NOT NULL ) WHERE (Ledger.ISN_GENERAL_LEDGER_FILE) IN ( SELECT GENERAL_LEDGER_FILE.ISN_GENERAL_LEDGER_FILE FROM GENERAL_LEDGER_FILE WHERE ( GENERAL_LEDGER_FILE.RowUpdatedOn >= @IncrementalBegi
ID 8bef57cc-0f37-42d3-a6ca-4518f1343969
Raise Changed Event False
Powered by BI Documenter