{"id":146,"date":"2009-07-08T12:57:00","date_gmt":"2009-07-08T12:57:00","guid":{"rendered":"http:\/\/turtlellc.com\/index.php\/pulling-data-from-cms-into-bpc\/"},"modified":"2009-07-08T12:57:00","modified_gmt":"2009-07-08T12:57:00","slug":"pulling-data-from-cms-into-bpc","status":"publish","type":"post","link":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/","title":{"rendered":"Pulling Data From CMS into BPC"},"content":{"rendered":"<p>Several Files (tables) in CMS are used when pulling data.<\/p>\n<p>MAST &#8211; G\/L Chart of Account Header<br \/>GLMT &#8211; G\/L Chart of Account Totals for Year<\/p>\n<p>Most of the data comes from GLMT. That is, activity and opening balance comes from GLMT. Properties like account type and company are retrieved from MAST.<\/p>\n<p>Retrieving data from any system requires the same thing. Pulling Company(Entity), Account, Account Type (P&amp;L, BS), Opening Balance and Activity. In some cases, Company is broken up as well such as Payroll and Operations. In those cases that breakdown must be retrieved as well.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Several Files (tables) in CMS are used when pulling data. MAST &#8211; G\/L Chart of Account HeaderGLMT &#8211; G\/L Chart of Account Totals for Year Most of the data comes from GLMT. That is, activity and opening balance comes from GLMT. Properties like account type and company are retrieved from MAST. Retrieving data from any &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Pulling Data From CMS into BPC&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-146","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Pulling Data From CMS into BPC - Turtle Works<\/title>\n<meta name=\"description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve Pulling Data From CMS into BPC - Turtle Works\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pulling Data From CMS into BPC - Turtle Works\" \/>\n<meta property=\"og:description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve Pulling Data From CMS into BPC - Turtle Works\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/\" \/>\n<meta property=\"og:site_name\" content=\"Turtle Works\" \/>\n<meta property=\"article:published_time\" content=\"2009-07-08T12:57:00+00:00\" \/>\n<meta name=\"author\" content=\"josef.wainz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"josef.wainz\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/\"},\"author\":{\"name\":\"josef.wainz\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\"},\"headline\":\"Pulling Data From CMS into BPC\",\"datePublished\":\"2009-07-08T12:57:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/\"},\"wordCount\":106,\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/\",\"name\":\"Pulling Data From CMS into BPC - Turtle Works\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\"},\"datePublished\":\"2009-07-08T12:57:00+00:00\",\"description\":\"A knowledge base written by Turtle Works LLC to help you achieve Pulling Data From CMS into BPC - Turtle Works\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/pulling-data-from-cms-into-bpc\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pulling Data From CMS into BPC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"name\":\"Turtle Works\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\",\"name\":\"Turtle Works\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"contentUrl\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"width\":625,\"height\":250,\"caption\":\"Turtle Works\"},\"image\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\",\"name\":\"josef.wainz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"caption\":\"josef.wainz\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pulling Data From CMS into BPC - Turtle Works","description":"A knowledge base written by Turtle Works LLC to help you achieve Pulling Data From CMS into BPC - Turtle Works","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/","og_locale":"en_US","og_type":"article","og_title":"Pulling Data From CMS into BPC - Turtle Works","og_description":"A knowledge base written by Turtle Works LLC to help you achieve Pulling Data From CMS into BPC - Turtle Works","og_url":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/","og_site_name":"Turtle Works","article_published_time":"2009-07-08T12:57:00+00:00","author":"josef.wainz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"josef.wainz"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/#article","isPartOf":{"@id":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/"},"author":{"name":"josef.wainz","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b"},"headline":"Pulling Data From CMS into BPC","datePublished":"2009-07-08T12:57:00+00:00","mainEntityOfPage":{"@id":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/"},"wordCount":106,"publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/","url":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/","name":"Pulling Data From CMS into BPC - Turtle Works","isPartOf":{"@id":"https:\/\/www.turtle.works\/knowledge\/#website"},"datePublished":"2009-07-08T12:57:00+00:00","description":"A knowledge base written by Turtle Works LLC to help you achieve Pulling Data From CMS into BPC - Turtle Works","breadcrumb":{"@id":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.turtle.works\/knowledge\/pulling-data-from-cms-into-bpc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.turtle.works\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Pulling Data From CMS into BPC"}]},{"@type":"WebSite","@id":"https:\/\/www.turtle.works\/knowledge\/#website","url":"https:\/\/www.turtle.works\/knowledge\/","name":"Turtle Works","description":"","publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.turtle.works\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.turtle.works\/knowledge\/#organization","name":"Turtle Works","url":"https:\/\/www.turtle.works\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/","url":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","contentUrl":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","width":625,"height":250,"caption":"Turtle Works"},"image":{"@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b","name":"josef.wainz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","caption":"josef.wainz"}}]}},"_links":{"self":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/comments?post=146"}],"version-history":[{"count":0,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/146\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/media?parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/categories?post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/tags?post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}