{"id":147,"date":"2009-07-08T13:22:00","date_gmt":"2009-07-08T13:22:00","guid":{"rendered":"http:\/\/turtlellc.com\/index.php\/bpc-drillthrough-for-cms-actuals\/"},"modified":"2009-07-08T13:22:00","modified_gmt":"2009-07-08T13:22:00","slug":"bpc-drillthrough-for-cms-actuals","status":"publish","type":"post","link":"https:\/\/www.turtle.works\/knowledge\/bpc-drillthrough-for-cms-actuals\/","title":{"rendered":"BPC Drillthrough for CMS Actuals"},"content":{"rendered":"

Actuals Activity<\/span><\/span><\/p>\n

Current year Actuals data is pulled from 1 table:<\/p>\n

GTRAN – G\/L Transactions<\/p>\n

For previous year Actuals, data is pulled from:<\/p>\n

GTLYN – Last Year G\/L Transactions<\/p>\n

Opening Balances<\/span><\/span><\/p>\n

Retrieved from GLMT

FinanceDrillThrough Table<\/span><\/span><\/p>\n

For Activity and Opening Balances, data is written to the FinanceDrillThrough table which looks like this:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Column_name<\/td>\nType<\/td>\nLength<\/td>\n Nullable<\/td>\n<\/tr>\n
Entity<\/td>\nnvarchar<\/td>\n64<\/td>\nno<\/td>\n<\/tr>\n
Account<\/td>\nnumeric<\/td>\n9<\/td>\nno<\/td>\n<\/tr>\n
Period<\/td>\nnumeric<\/td>\n5<\/td>\nno<\/td>\n<\/tr>\n
JournalType<\/td>\nnvarchar<\/td>\n2<\/td>\nyes<\/td>\n<\/tr>\n
TranDate<\/td>\ndatetime<\/td>\n8<\/td>\nyes<\/td>\n<\/tr>\n
TranSource<\/td>\nnvarchar<\/td>\n4<\/td>\nno<\/td>\n<\/tr>\n
Amount<\/td>\nnumeric<\/td>\n9<\/td>\nno<\/td>\n<\/tr>\n
RefNum<\/td>\nnvarchar<\/td>\n20<\/td>\nyes<\/td>\n<\/tr>\n
RefDesc<\/td>\nnvarchar<\/td>\n60<\/td>\nno<\/td>\n<\/tr>\n
RevEntry<\/td>\nnvarchar<\/td>\n2<\/td>\nyes<\/td>\n<\/tr>\n
Century<\/td>\nnumeric<\/td>\n5<\/td>\nyes<\/td>\n<\/tr>\n
Year<\/td>\nnumeric<\/td>\n5<\/td>\nyes<\/td>\n<\/tr>\n
PostDate<\/td>\ndatetime<\/td>\n8<\/td>\nyes<\/td>\n<\/tr>\n
Batch<\/td>\nnumeric<\/td>\n5<\/td>\nyes<\/td>\n<\/tr>\n
MinorSalesCode<\/td>\nnvarchar<\/td>\n6<\/td>\nyes<\/td>\n<\/tr>\n
MajorSalesCode<\/td>\nnvarchar<\/td>\n6<\/td>\nyes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Rollups<\/span><\/span><\/p>\n

The GetFinanceDrillThrough stored procedure calls functions that explode rollups into base level members.<\/p>\n","protected":false},"excerpt":{"rendered":"

Actuals Activity Current year Actuals data is pulled from 1 table: GTRAN – G\/L Transactions For previous year Actuals, data is pulled from: GTLYN – Last Year G\/L Transactions Opening Balances Retrieved from GLMTFinanceDrillThrough Table For Activity and Opening Balances, data is written to the FinanceDrillThrough table which looks like this: Column_name Type Length Nullable … <\/p>\n

Continue reading “BPC Drillthrough for CMS Actuals”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-147","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/comments?post=147"}],"version-history":[{"count":0,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/147\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/media?parent=147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/categories?post=147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/tags?post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}