| Value |
 Expression: "DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "' /* Date and Time to validate against RowUpdatedOn in Source Tables */
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
SELECT
CASE
WHEN Monthly.cnxarraycolumn = 1 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '07' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 2 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '08' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 3 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '09' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 4 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '10' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 5 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '11' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 6 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '12' + '
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
CASE
WHEN Monthly.cnxarraycolumn = 1 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '07' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 2 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '08' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 3 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '09' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 4 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '10' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 5 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '11' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 6 THEN CAST(CAST((CAST(Ledger.FISCAL_YEAR as Int) - 1) as varchar(4)) + '12' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 7 THEN CAST(Ledger.FISCAL_YEAR + '01' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 8 THEN CAST(Ledger.FISCAL_YEAR + '02' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 9 THEN CAST(Ledger.FISCAL_YEAR + '03' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 10 THEN CAST(Ledger.FISCAL_YEAR + '04' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 11 THEN CAST(Ledger.FISCAL_YEAR + '05' + '01' AS int)
WHEN Monthly.cnxarraycolumn = 12 THEN CAST(Ledger.FISCAL_YEAR + '06' + '01' AS int)
ELSE '19000101'
END 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.AMOUNT IS NOT NULL
and cnxarraycolumn > 0
)
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
)
)
|
Properties
