# Documentação do BI

Documentação exclusiva do BI.

# Calculo de faturamento

Aqui, abordaremos a estrutura que montamos para realizar o calculo mensal de faturamento de maneira automatizada (sem interações humanas). O mapeamento da estrutura está no seguinte link: [ACESSAR MAPEAMENTO](https://viewer.diagrams.net/?tags=%7B%7D&lightbox=1&highlight=0000ff&layers=1&nav=1&title=%5BOYSTR%5D%20Estrutura%20Calculo%20Excedentes.drawio&dark=auto#R%3Cmxfile%3E%3Cdiagram%20name%3D%22Fluxo%20di%C3%A1rio%22%20id%3D%220rl3rReDeU_2gvTwFvsa%22%3E7V1rd9o41%2F01WW%2FygVn4Cnxs0vaZTjttep3pfGEZ2xC3YBPbpEl%2F%2FSvJF4x0sA0YSRDNmtWAkW1Z3luXc7bOuTBuFo%2F%2Fi53l3d%2BR588v9L73eGG8vNB13TJM9AcfecqOaLY%2Byo7M4sDLj60PfA5%2B%2B%2FnBfn50FXh%2BslEwjaJ5Giw3D7pRGPpuunHMiePo12axaTTfvOvSmfnMgc%2BuM2eP%2FhN46V12dKgP1sf%2F9IPZXXFnzc6fb%2BEUhfMnSe4cL%2FpVOWS8ujBu4ihKs0%2BLxxt%2FjluvaJfsvNdbfi0rFvth2uaE2%2F7Xux%2B%2FP7x%2BZX78a%2FHvf3%2Fd%2FPqh9fKrPDjzVf7A10EaB495ldOnoh2SX8Fi7oTo2%2FWvuyD1Py8dF%2F%2F0C713dOwuXczRNw19ZOtV3MSPU%2F%2Bxciiv5%2F%2F8aOGn8RMqkv%2Fa0%2Fp5oz2tD%2BRHfq3fAmrs%2FOBd5RXo%2FVF%2B1Mnf%2Fay8wbp50Ie8hXZpLZ1prglprrEbL8YTJ%2FHr2m0ahenn%2FJc%2B%2Bu7eBXPvnfMUrXDNk9Rxfxbfru%2BiOPiNyjtFq6Kf4zSnh9HfKPEZn5lfM%2FYTVOa2aHyNOvS387hR8J2TpEVtovncWSbBhNQPn7hw4lkQXkdpGi3yQg2vfhrM5zfRPIrJsxue4w%2BnLql8HP30K7%2FY7tCfTEGw1MK0NYLMTfyU36voMQHwaHoNdvK7fUL9jBPOUDttux1wtxFwM4O6lzNP%2FTh0Uv86WoVewsC1fMxWCH74fvc0ffjzwbt5%2B%2FPF6NXbwcd3ac8YMggOvDFq%2FCB9YrCL2jpl3l4YZWCuvOr8kDMPZiH6Oven%2BDT8sgLUkb7IDy8Cz8NXvk4QfoJw9o4Ue2muj3zKmwYfitDp0znpL%2B%2FQiT66wvUyCsKUtJV1jf5HrXfT%2F8O6sFBdb9B3bf0d%2FY%2BLx%2BlNFKLqOwFBl4%2FQ%2FsvHiL%2BOo9RJnUnJxZ37tPr%2BoRmnT5sQaMIlDZXuujQDAoQbLZZOqBAhABE2R0SAXYRpQohA48UStRwZHhQquKNiJBwVdTOfZRx5KzdNxp7vzBM1B5JyDjSAehZwAq2d9xzIUlOgTrq22n7ioBkQhMqj9Ww2A4e8Oxuj0xQeeOOhbS91vJGOXeTfrxzVPYiBAzTx4QsHdoFEPhaTHoUJ7pgojTQ8QPHd8NJe8FL%2F7%2FHnfy9evfn25d7%2BCYwZG5gYT%2BJVGilk8EeGJRoZAwYZXpC4aC6bjrNjChTcQTEUPYbU%2Bw1c1EjzaFZ2HnE0idhhRS2iZVhEazow9uh9AEx1TqjWi2gDmA1LsooGDMdq3dRdL9eJKwEE5vF6OdhwDPZmCg9HxwPQdfDFgzGqHfVQ80WAM0GNczKMcyY0kYYcDp0Mc%2FLaiouaKWPxMTq1soeQ0l8OA4JVTCFAOC5Z4ilE8EeEeH8560%2FKh7lV4sfKGyrJAFcu3IqVXFuX%2BrmPcKwtE3VoGLqqNzvYVGW1Rqk04xtrwAydhTJbCsCC%2BJFt6wIuCmeovWdqbKuMYNPpVHfBsc2zJ7ZlH3Xxtq%2Fcebjn4NZ8P0mGt2IdCy%2Fg%2Bpev0CfP8fwr1cMd3MOd3mrOYh0zbjLOBrz%2B5c1nhQoBqBA%2B7g1YQ7a7nI7dcPlD4YE%2FHoRrny1QMaoU8UJRAYqA%2BMICNAWqrTPiINHWaXE8SBjMe%2Fe9mV%2Bsg1Ab3kWzKHTmr9ZHUfOhya%2Fv5Y23LvMuipZ5k%2F3w0%2FQpXw85WFq20aD%2BY5D%2BW%2Fn8HV8Kvbvs28tiEUS%2BPBVfQvS8%2F1a%2FVM7CX9enkW%2FFeZ6T3JG6agyYPX%2FqrOZpBbwuOteP6%2BCLV4mvnUUwx9f%2F058%2F%2BLhcsXzMHljT8u%2FsjebOxJ9fowXhjDQiW8APvRd4FziuzNxJksDdeRmWRKvY9WteerGnEq1ZZ34dogt4YkjU4jn2504aPFQL1SzR0AM6T5UCObPXV77FByqWUHr1NrSqwG8sXywat5U3hoeVp%2BqDPmRP2O260BTBVMWerQbHZvboUrDHGFBotevZQ5c3tD4HdNtCxqFnPKbsMwZ3zSSzLZMsKZhEjyuGuds4ZNIBTxrGlV3LGwMe49BA5IyxvwNaO2H3%2FpCvjV7QDHlNEshTY0ET4jcBbDQAeHRg%2BT4PwLMRSC50m3Ssd9oGEez7FY6NlHtmeinG9gtUor98JEgqfkefZvlfchncrYMXwj%2F0EsIJfB3N3HIh2smVXRY9bXblzbuhw7jemweXe9dp28O9uF8FeGWu9xfYDbaIEMr6q4WDWzLwf2EMLv3QwUfdaIH%2BJQXceYCHS%2FzRi9A%2F01UYkABd2L79oXi%2B%2FiVWbPeNwVV2B0RPfN1l7ONPceXI6pF8Jdcmau%2BUfPSc%2B5VPHET5DbPruA7ifho7HikU4gpk0aX%2BQJ9u4tXv%2FDGyCpO64xhKSVHBr8nq4sa4eKHFASmHj90Q80pAChW18mdOTK50QwicLH0XUdhZkJqQZn0fEYs%2BaYObz3mpKEyyyz%2BQoGWXRK5zld%2BHlHx%2F%2Bxd5OnxsgZojwZ8uC1vwFX6MD7HnL4oKu%2BSZ0G0jclvbWWDTRzhJlpuA2YIjBjXdw6iH25gOWYXff9WcidugrH1x%2F41v%2FU2FE7kA%2FnwlxUMWF0oQUsALTcrZXc%2FNpnf4ekEYpAF2Qe%2FUbrm9r%2Frk2X2PVpcaYFF3rnmDO2Fza%2BW3vZH%2B7k%2B1IQ0vOd72SblVc4dXvgl22BxcmZNBVlPIcLs5%2BdttQtVeUmBTcw%2FIxW%2FuLCk4zC3H2tth0ChRioyCS6Otw%2BbMBZcDVnOg3EbduY0G7YEqiwplwG6lVHoDcXgQrz%2Bx9rAJJXdoAYh%2BzQMhYxAoz%2BKJ%2B0YGbc1bhWJJMt%2BIMdrRN2JyMEAN2A0PmwYftTVVbnVz672p%2BuDMZ5LsXg2lbT7SLMJujVppZpWsoV1pm0WjQvzckt3To9Ya4vAgXNtcWOuUtlkiVIjXNg%2BVtlkySAjXNg%2FB1CEq8oU4SEBxDblCYsT2EjkexmrTuBhQlMH7xYGCnVE4LrE5KTjwh0PbneDHGzZYd5fceq%2B1%2Be80dF%2BUNiuNMrkV%2BYfM2cjT%2FF%2BmAaNEYfc4IHEfQxYLoQwsegJEW6VqDH%2FJVWNY%2B7Sum7sWc0XZbUsrVC7uwjXDJnX8IdNKFa3cz9Vinp9gfRV1uZrTUyfTnuFKPaEqb4jXENwCjzRIUsi53qDm79%2Bsb5s%2FtUauFsc%2BjthNtF%2FkDKe4SfHgG9K2kLpr9WLYwO78IYUSqiJbiqpqv%2Fz1tBd6bURs3LyCBI95fMEX2ydII%2FLq%2Bs6X605DidouDlOLRbiHKNZIssrZ8urtJmfbQmUedS7uNYmBKkpd8%2FWAuYw8f5EP0bgnnaKZbDlY3ZVDSZ5PDR1eZMNqudzG6mw%2FdNHcNfpjp8eH5%2BAno0OEnH%2BgDlGvy%2BR62Ix2n03e8skzyh17Sp6xpzyjgGKzPCN31AqWZ1jWJpeaNn7T5c0RB3nGcJ%2BN2YpdZ8guvS27hnKwy95kS9PmPrq8pfNg13lICxW7DmVXoRhsZtdIDnbVSwUby1sWD3btE3bhOOxSTOlsHLJaMqVwx4lmCh3GoCFACV3e4hF%2BZ7hP2AM1Dp0hu7S27JIjgoNVHzOhsbyt8WDXSBp2qc0gnYX3ac0UOdZDdLgean3TWN7ueDPIjx8f3k7%2B%2Bvbj22Aa%2F9LvLGfk9MroYzIxZU2O7xvcUExpyZQRsLYB374uydqGDrBYUGErVegIizufUAxLW4ctOlsOdcJxxq3ixTVuzSpy5arN%2FpLu0Rq0zT5p1rlpzmCP1giMHa72aB1BHVf2HqeTMnfE7kVVe7REo0J44twRu69T7dEShwdgjxZnPIA7L9QeLaGogPZocYYFu5VT7dESCglAm8QXElpxN7VJSxZMAJu0eGNC7dKSDRXQLi3eqNABVKhtWoLwABgwjoaH74aX9oKX%2Bn%2BPP%2F978erNty%2F39s8eO8XMTWxjHBtaIYI7IgaiEcHOLu9XTm63Unjgb6oSjQeNnVqSj4UtXqFCACp4WjBhVLCTyw1UjCcxdnUqbPDHBk87JowNdorpBUm28siOKVjwhwVPcyYMC%2Bn2TxUCPxXelq8GvW3qv5EcCcuYhGJN4W2p8sOO8yvB7JJu%2F5Rilxh2tU1LWzihRbOL3rHRoBekyw8NHuySbv%2BUYpcYdo3askuOvb8GvdvQamAXVX5o82CXPPunFLtEsquYODWzSw6tu0HtlLcadtbT5Ycd76yH2SWP1l2xSyi72u4kKRQmotlFqX3thp31dPlRxzvrYXYNZWOX2tEohl1t112lWEcwvWyNolfD1nq6%2FKjjrfUwveTZ0qgGL6Gbu9oOXqXuSfToZVD0GjSMXlT5Ucf78UF6FWJWRa%2FnTq%2B2K69SQCaaXtROxUHDhny6POomePBLk41fKqWjEH7ZLL3q9HiiyaXV2tgby2v9jjfxw%2BTSFbkUuXCIDL0luzq3axwkiNClE0Qo%2FIrBL5Dvt1aLKTrEy6jWjN1YXtN4KCJ06RQRil7HphcIhLZzL00OwwEdtGXUFECJDvKi8VBE6NIpIhS7hLALEPPVqoJFs2tQa8VuLK9pPBQROhsg5DSyZ1UiNJ1%2BGi3yLCn5mCWfckjWqTwjFEmFRV6kH%2BDDJHvHCFc3WBAYL%2Bd5do8yCxVJKJVfFVNhsb7oPAjvspxTeQKvdcqPS9yL4GpnqKleIa99fo1KUhdcuTdJgsuE5IrOjxXOi5VnGMEtMl2lq9hZ%2BJvJrbIEWqTcYJ0dLMuEhV7xarH%2BWmmGefbwuIZeQG6LLzhZJW4lPdjN%2B9u%2F8FNXW%2BS2fBSScuzDIvC35POKsm8R%2FkyeFtU8Ib965avAXQdddZJapfLo2cmJP1sF5Mn70yhGgMA4kiClFZu5a1v%2BrR0yeBWcHJO8Mvtm8aJGe%2BkzyFDTIig0GZhBpjY0WdsFf%2Fz22%2FA2ePvxpfPp37s3r72b1TIon6F1mLtxHE0iFe1Olmh3tPRYK5MNVTfVGACmyo3%2Fpx%2FuDkS2ziBbRbs7eOdXbR9yULA7CKJd7PsCa8wG91RRzYShAdocyhUN7MJGBa8SiAdoVyhXPLAxD1XgKoF4AMPbcQUEEG9ChaQRiQgouh1fRICxlMnSSOGBPx6gyHZ88bCP5F6OlCbsSznIcVxs%2Bq4a32spxF%2F5AFeHDTJ1Yubt0jJzGlZuZ%2FUYzANsR63YVkGbN3oubCm9NpOsrBfgcMPEePrywQ%2BSwlK7tkHfrwqLbm4RviCmYtSFpdGKWGbL6mVGaspcnvpxtcYTh1hsC8t2vPpNKomWCMVdSjP0ZXZrZ%2BmHDr4AuuXvi4px%2BVPxLMQcfktMx0luS9%2FaOOHadLyMfTdI8vYkHgDUVORO5J8gzEzHpcH52vJJycq1G70k%2BJYJOdm4yA3roe%2F6SZLZq%2BOgYuYnFvuoaBVsuY%2FKlslbBT%2FoB7oEfmYe1u%2Bucqmj9xgmRSd5TR6u%2FG2OB5ie58Q%2FL%2BPZ5LKftWDx5yr7i3%2FRsWMPf6l%2BuLoCCbTd6l55U%2F3L9Tx0N%2Fu7i8bteTQrY2ORvmPzamecyZ1JWgMsMeBU7nVG07bjD5gAaB%2FhnRy5OTueQBQRdhonEHI4721KxD9sEP3T5TW9Y%2Bc9nFxsD3SpbLAXsqhcasN5NBLFlIMo1GayYYPKhS6v6R1HJgCJIo%2BETBGlM6IAAXLqHAGiiULHDGiIMUCX14yOgwyARJEnPo4iSme2myIMQCNT5IgkZVOxa0ZN4QIsmikdxwsAmSJPrBvFlK4UxkBgjVrPkWiiUCHUtH7D7knmBKPjrf%2B1SXB3UKMlq3g5Xyk5miRyNDr5qmZD6WVAiaNVY1k5LTkabN9hfchKj3aw%2F7C%2BGzlIkAaBtAv%2FIYwOVoersq%2BKRgUkTOOLCp1FhdIpCsMDJEzjiwcDGkNU9lWhqADlaXxhwcqZlYBVKCQgfRpfSID6NKVhFQcJSKLGFxKszF3lXhULCjD3Kl9QsFp3lXpVGByg1Kt84aByr0oGCSj3Kl9IqOSrMgECTL7KFRDFzVTyVYlQIdyAaarkq7JiQ7gZs4iFqZKvygQL4dZMk12QuqskjRZj7Bh7dH0v27mhsMEbG6Zwk6bJWrq3b15gIPKcnf%2Be4w%2BnoPPfdof%2BZAripivnf3ZGre8fyu88qoFRa9c%2FNM5J4vs3WQO9WlZ318GVncVB%2Fv5jJR6Hq8za59XYJwU0oNkyX2jIk71NRaTdQy9ay%2FeqYLR2Usx%2FVzz4fOzKLQuHuX3CtTNvd55m9DSL2kNnA2sZrUx5X2WtXTfVOKilWMt5hFpqnPjxQ%2BD642z3ufvcAydun5R23B%2FoW%2FuDbfPllozXd4WrRklii%2F2eG2AF9xqbx8Iqa9IPEUC9sZvGasqxfaF1IO4ocrfE27A13rbPbUF4dTGBgcdE1kGQw2seKHidOryA%2BTFneAFSaQKvJFC%2Bp5OHFzSTOxa8wD2QgK9i%2FBDMxkEYuAGabCmEnTjCIL3u0SD2ffLu3Zdf1%2F98Gtx%2F%2BvBGf%2FnVv3%2FdY23bGcSmQagAdgYAA9S%2FfAHGmptD7Ggdp1E6XvjsElRB7NQgBqiJ%2BUKMtV8nqKGBjbgKWyeGLUiUzBdbrC4ANqWNUXMvlEHtuRnUmOSC0IRuAABWq9tifhBiWRU9XpBieKr%2BUFx%2FWNu5HGRPg9B1tO6Q9Swoa%2B3ZoAsyp3FF1zZfAB5tFbxOHV6QOY0rvABnAMmYiNeiythx%2BgBrPfk6HsJYa0d1uaDWB899fWBAC1oIol1oQ2CIstYSNchK2weWHcrpLBE0YCvF2PMTN0btpXZdnT7ChC8TdHYeV2eUG2dqZj9Ww%2B%2BWCIyiht8yOOSxhl82bjugqLYA7Fpd5NaAwctKRpQJRdbOsexpDtrNAQHseJ0j69FXkqTzwRe0JYQvvtjpnRIlnRfGoN3YfDHGGoKVKumcENZ6HnY83RskDFe6pLMCGRT5km8%2FxrpLlTLpXNAFBdHkiy6l9DhjfIHxOPniS3kKzhthUIjPYyFs%2Fut6cP0%2BtD7oi97L3q3%2F9b0%2BhmxhyiF%2FVhCDQoby7cRYj7zyRp0TxMAgpHwhprMQi7xgFuFNxtijMo6gOBUKaicHNZ7GfXDABHzrsfPbicZJpGyv54ExngZ%2BGGPAsjJc%2Fhi7y6nC1%2Bnji6dxH8YXaxSbzKP7le%2FE46mTrmJngR5aTc1OH2tg6Fa%2BWGMdSUGIQ5UpeJ0BvHja92H7BetEyuz7xcxfoez0UcbTzg93YgyKmmNwHh5v8zFI%2F618rkTbRN%2FWwTbxFzDWJvtC6iR91aCVdWHiqjEr6zYoCs5xXgKEkv1vS3FOl9dG3WY4h3uvPXB1nNiuOdb6O2BNxYPlTq2CJYK5NdqNWlRxraF4GSd%2B3%2FI2B%2BZu2WWmdO5qm1k%2BaQFce%2BAeDb0LnTuIUSCovDKKyzQ%2Fru1ZpNxuBtaYtVYqi%2Fg5AYznbjOwxsB2RmUOPxNw8QxJAdaYtU8qW%2Fg5Ao1raAqwyqzXRVnCzwVcUJBXruACIusoofuZgAsK78oXXPsYwI9qqNzFKK4MlZ0ZKotepmqprLM9yOYEMHdzAphDDqZETXkBnh256mIvNnoBNEnIZW%2BSRdetenJR5Q2LB7kM2cilRq5jk6tuQGp2seldk%2BswfYt0g4PCr5DBYdAWvwMpBgeLllPY9YMDXd4wecgvTNnIpWZeYpY1Wlt2GVKwiw5pOqhf1tAZEvoNgor%2BgeW5SKcsxd3nxt26DH3N1O08lfZe1B1QFoYGblHFR%2FWlrdFBxakV3JGIayviPjfi1uU9bCbuSAriUtYL02gaFDeKDxuYODyouM7DlFKsLBRxnzlxzZbELdxRopeiFHHtBm5tFm%2BYWluDg4rrPBwMRQw0RdxnTtzWNlA5tvCYFHEbZrNU8Saa2wcVNzQexB3JRlxl%2FJXaM6h37hk8yHlRTAAUfp85flvLRiTZ4GYZteurxvJmn8PoYChRlmJXNd1T8%2FBgysEunZpLDRvYpdOmFx7sUo73Z8euut1tjUOX1rl%2F4bC5lxI%2BKfxWNs8147dz4chh%2BJVOm6HwKwS%2FwNq3NqidLPiVTp%2Bg8CsEv8O2%2BO3czXkYfqVz0yv8CsFve9tN5%2B6%2BwwDMhqW40G3SbHfaBrDt%2B1WED2dxbnopxuULVKK%2FfCTNWfyOPs3yv%2BX%2BP%2FBC%2BIdeQl4vvo5mbrlQ25S52e1QK2R33KwFOoyfZ%2FPgkj6QLJ2wVV23PfSL%2B1WAN2TqfTcOnEWEqtVfLRzcwIH%2FC%2F2Z%2BTEO9tH3IvTPBxJZ5ibDoUNeFUJjMEXoj7Nz71dOgP8mFzfGxQsDn0SOZ82Qks9kczT%2BcFnJn9n3yXPgra1X2S28rSfe1NwItXKYFPUtTib3KjP4kFutE65c5Ue2Vj0Lq0MqvBkBhZyWx6z4cfUH%2BnKbN0uSRFk1p85vP2sZUp949bsIPNDHXRS%2BgElYiLoEJ380D18i8dGbIYEu%2B9MoRm8Ev8cSGtl7ZxDD4KN7wMDgxm1TJtvFDYqKOwu8L7e4O%2FQtnCTLzQeAnmtrlSdlF9pzsz4U1xxVKEyKbvKaNN8hT5bRtqsqb6tLv%2BWzVH6b4w3CPc%2BJf17Gs8llP8NO8SfnEP6FWLnxl%2BqHqyuwDTZeorRo2%2FZOCgwWrK4HYb968YQ5%2BzxfsMRvtdKHzIO2r68YTvMeng6Dpt7jMd9jcaFJLFW1KnOaKEz82SrIRuDl6tHBQHHmMzTFIZOFMBtb8YA%2FwP9eW352HK0A%2FCRxyLgvycjbQz9%2BzOco1VkRegQHz2pcJ3TRJMKrzJBCMgsiMysfhwxBc%2FRkiVZw%2BfyLpATDDyjHe9v2gJUJWRjlM0fPuV%2F5c%2FxkC%2FLrC3yUPBz5%2BhJNSaNiHlmd3FUmcyfWLHi%2BSZ5tlE8m3335Vs5z86DoEtX4m4PWE2tiZa%2BPvIq%2FP306sN6UASOPfFOxLUABYqAYNZtGjN1W2O1jiGp9eicVELOqiGGxEfnF6iKIKPgQBrOK%2FvCUpDHTtpX4tg1Rd9jW03ZuKK2vbTRUzwZydWr6YMQ21XB4rKZiYwK3I8qvvHaYKoN%2BH54J4UYfO66LgJgmW0mw%2FaWcf9DhbRF%2FtwcjbsljY1d4wkrUDWhCJC7Z3jky2UjAgVeAaVsvqeKDtcVHJxF7IUB0Ec8LrDEbUDUHwzh0FiokNH9EtO0iukAEuIuWHeYdl9joFRZ4YwGKiHssLMRvvw1vg7cfXzqf%2Fr1789q7WS0DKCd01xMZ%2F9F3V2mAXsTYWQZqOnNK0xko3S88n%2Blipg0jVGcQqiY0e3VZ9R2AlDMauMrsAIYQEUeTSOFBAB54zmfgKrOLcYwH%2F36FG0ohgjsixM9qWD3INAgDrPcZOypKtgBIgBH5%2BWKCDcnvEzuvQgN%2FNEAh9PmigTWTFSsTaRRj28zAApVhX4gkCZX4Qfw3uKX8xyBJicMmdzAS%2FROuIvFLLbK3lx3KPsSB45FPIXb33Nxe5Oom4mz444ScPjuvrvRC%2BLt96mQezVoM84BNiXPc9f84jfDiXFkBGq0A0%2BlUd0ErgGdPbMs%2BJk6NTZzq2uAPi4GqXjjmNqBqHQuqxVigDAHHGcVHrVGy3RAAQuJog7jBGi%2BVIUAcHoDRjDMeWFNhPtr0iwEn2Huatm1KdHnz4ev7L%2BOv7998%2FPrqcm14uGqesQVNExmF1uOhFTBScEYra7bynNRH%2BMHNd1zM5ivfG3IX66mH%2FlngfzyFWrlRC9lROMNWbXY9782CRTCJymbBWsdcdbNg7cRdcCgabbi5qKHSTjSW122DIs9hoWjgtlJbcRW7qk7OZnbJEUZNG1HsGjSwiyqvj3iwS7qw1opdYtgFxLWuXVLy3%2BgOV0e68M4KwGIADIQaqV1lik4gSXk%2BzIYcYXR5w%2BIxPHB3hiQr1%2FUTtcfjtNwhpqZ34g7Jb%2FgJdcpOOCMbF3e7o97CZe7MUXcYOql%2FjXurhBmCOuCNqTwzx7QSGTtbiYR7ZkzlmZEJD8I9MybrmVkPfWAQFeWoUeC9kMNRY7J6c6GOGuWnkR%2B04v00pnRBdQt7gDIVyOmnMeXw0%2BjUyr%2FBTUMVb8ocRXt1di5vDSlqHsEQYUrnY1XcldsLZMrhBaKzfTQ4gajiVkOCZNpntGt5c8iDu9J5cHfhruLg%2Fr6iYpErmIMU5vv1FKQYpfFgiPLCKmbt5MQqVuCiR7cDnViWyYFdg0OSAc2D8GcnxCpJsubF9w1awCQ5UV5scLtjkphtSTKQY%2FixiwoXoG%2FIb29QCyyq%2FJGGIHYz8JE9vTjq7GqxxAeUt1dqb69lbAIYioFT0oZPDByTFSYoB2t35t2yNzjIwQpB4mjWXQt0uSsHqyA8QA5WvnhgHe751jcFBt5ggByWfMHAOixLb7uCA284gK5Avnhg1RcbDmyFCe6YAALgcMaEdO5hZYQTYoQrENZshOs8aeVe9gWLMqrptl4lQ2N5yp98HPuCJY8DVzGlM6ZoLZliySGksPr0FrsGplDlKe%2FtkZgij7tUMaUzpuhtmSKHbMGkN6%2Fq9Uyhy1NO1iMx5aT3%2FimWbNULNLNEDvcnPT5QYoHG8qbBgyXb9%2FDJFdizlX9I4iTQ62CfZQK62E8QexyvzOoWrdAinCReXpE%2F%2BEySqa8uMiTJwVe3W%2FLqokw1jVstmgceSeGYJ3dGzUgqsJH52Q8fgiwLIqoEPvPF7ZsLkh6UFHaWy6LOyzhKI5yps0gHiPM%2BzmI2HyTqXUgA1PJ6JNnzutk8P3jM2w0X8JwU%2FyExT0mCSZLvmWrBiLRivq0g%2B42UD0KcxzGISebGR2zZuMiz5d3c7hYx9WjpW7e%2FUXIizrOZP03xnklz4004QRIwrZu9MEeahIu123erT4jG29BJdnnU7D3HPhqdQydL24ku7ON04Ts%2BPGzIkzYc7oCedgGeVjge7tE8rYNDzGLdq2d2W4mc6LTqmOoZu611q3v1zEE4tFn%2F7hEFKtn4Ejjz0iWgFCqnk6TJLubZVWeCxrXbtMH93kqg0pGDqewNDhKoQJA4mn%2FJZn2OSqAiDg%2BQQIUvHlhNghKoCAIDJFDhCwY29LESqAiDAyhQ4YsHNhuPEqiIxQQkUOGLCTZx9RFXQEqefzLyfGrLom0Bqx%2B%2B8nybTTeoVj8d9l52a4zIIs%2B32f1FavUjDg%2FC5fk265VUqx9BYBAuzx%2Bwtl21%2BhEGB%2FHy%2FAFrPFWrH7GY4CnP%2F%2FHjw9vJX99%2BfBtM41%2F6neWMnF5PY157sxtS3K793P85nfuPuXuvaz9e4Z5r9OMVL1u0onBArVJyV%2FdWRSFdXq%2FfNW%2FTPqDN8kcKLcHa9DeX5JvahAkqSry8F9U1OrsY%2F%2Fr%2BzYf3lVX3BBA51K7EUdWDZeI3dxhOsvRdjJ5p8IiJ0t7f3ejZpr2Dlj%2F0TGiBPNQnhn3MBbJhNi%2BQh4Alp4vlMdiXbUeNtIq8k1Pj9S%2FrtHi43CrMlEdGeSQ%2Fs1mOSGRwDul98%2FTfjQoCUKOXVZuW6ZFeIsDSFKKfS5JgkT8pKuTPVkF2mnvnz4jML4yox8P3npeXKq6Mr4BqgstGE6K2MvMnyY7merzLylTr6qyTj9NqK6hfOJ7a6rpv3%2F3z5r%2B38Z%2Bv7179%2FDS%2BfZqOBM1yRO037HhKVGR2aZaP611Pidq%2B9Ifvd0%2FThz8fvJu3P1%2BMXr0dfHyX9vJdSBLtY9gruKl2ABJOVKjHAlhjsQpi2mahCmNDjv1AWn%2B4Ob3umU3p7JgzDL3b3Q5wex0S7E1xSXYuge8cCAkMY0OOXahaf0RzqSnxKnOGPuqWS%2BAyhXXZvMHIQYtGnyFZxffb5Dg9Mri24qj9xFDT%2Bv0iu1ThQNNYAxiaPxalNjNcjTqYHn6fvHv35df1P58G958%2BvNFffvXvX5%2BWEaxhqlcHuSrlwXIjlvJgue5DNBy08GedXu4qSdHF4%2FEyjryVm2Yu0c3V5naqKZlFG5lFbee2g8ac6hIgH6oBrBbLTTy7Zbyj7Jkme7cReLPNe3Wb7A62zIOR91DrByluvstX6JPneP4Vg2TluNnuuKntPw7SfcAYPVKPp7GuPHc5Hbvh8oeCA3c4tO%2ByjgUH1vSN%2Bgo3Wiyd8EkBgjsgIOkHX0CwwvdiJoTOU4DgDQhQ%2FMEXEey%2BGKUdFYkISPrBFxGs8F1pR8XhYSgcD6y6XGlHxYBBB8xinMHAWimVdlQYHAArBWc4qI1zkkFiIBoS%2BvbUNrLIrdpYgU9CdJUrnLA13UW1BqOQXZTyJmyYx8GdXIfIr6qypMvEmfi5Pup%2BRdRMGzHBSEOl60sHXlREYCOFSSSw97d%2FMXeslMH39HPj5EUekurm09%2F46LqQv1jGflIGKpsEaRw8ksBmr5Kk8uSJH5MKYkRNiIeslHs5c3c1h8Vem0otsFXyJ8V3%2FEAafvXbWaByEXVTUpjIw7JrkJBq5H0KCBaGmqDw0PXcrA%2FFv6N%2BKkyKPuaatET52xx3BT3PiX9exrPJZT97VcWfq%2Bwv%2FkXHsaTxl%2BqHqysQsKCOcbla1G5r7Ygs6K%2BzwL1sOEnwn8vqMvaG9FoZz7E0sCy8eSp4oa4rLsvLyrg1jsIZGgVn40wm6Rd9YpI1VnKuT98eLnLEN1yPBWU%2Fl0Tr6H3hWluLeiISw88P0StF7UqiTuITEzRtCqbY%2B5%2BdRW4YrYpesuwOK9daRqSbRmyeB7%2FJ8OKgM4nfbD18kPdVXmc9VFSug%2BZIJAal%2F4C6%2F0V%2BH9zjJqSCF1kkzPwKa2sDQkGM4xJeFTdYh6QEq4unYkUHnZ1ae7PqK8%2FGG89fjw%2FX5dgjoya3Gy%2BrobVws4Ki3DJ3ducTSCDZHDNhUw77C%2Bkd9iaUtxBaipRrljP12MO58pTH%2FgjrZXPnBbNwlz2QOU%2B57MXhQbjPHkiWpnz2IhEh3GkPpFNULlqRiBDvtbeUjkMySAh321us276I%2Fl8sVYO9LenbrBKXn7%2F%2BfUluc3XVbDMPmtbJCqFHRKhwIYHFCglK3zFscj0SYPO7KszKjlnxegeL9WZuOLj7nSGTwfzld%2FRf7%2B%2B%2Fr2A0bgGuAil3kPJUYYD71NgVo%2FQe95P1tddm%2FLqo%2BiWW%2FhwfePOy%2BGntGfHWvm0ScwRfKg5mxA%2FtZRFOSvc7uWkLwcJNXtYLpj7CeJblaeNKxHlCipXPmkSL%2FFk3spV9%2BfDlxbuLzDH%2F%2BevNzavPn%2FNvzixeLfNTmAe83XzA6%2BIBn5P%2FBLJ6Hy%2BqyfzX9eD6fWh90Be9l71b%2F%2Bt7fdwz2DGrBNAC0WF%2B9zTOfnvWrpPtLpKOt%2B7rF9t2V2%2Fz3hwLroyPZgBNsCwArUPzWGi1WAmh8o4cPLep7xgO8o5A8OhiagOjg7VqKO%2BIODxA3hG%2BeABD3SvviDBEQN4RvogAQ90r74gwRIDeEb6QYBVEyjsiFBKQd4QrJIB8pso7ohBa7x3hi1BWB6S8Iwqzu3pH%2BGKWtTxveEe24vYQjNa7RRQMucMQ8n9whaHBzvdCtCZE68I0Vog4LDRkjfGSshAfD2DQnlauADPZ2aNLAJYEaol5%2BgAzoJ0KfAEGpGAaPwSzcRAGOKuBAtnpg0y4Ld0EZmsEZPm2aAWxU4eYcPO8yUrVQ%2BxrHqdROl74KkjMGYBMuMXfZMXvCWrqlULX6aPLFO48MFk9Ap7po9ZdKHydPr6EeyJMVtGQGSsSP35QCDt9hAn3JJisRgJ9jOKxCtt4HhCzhBv%2BTUBiOvb8xI1Rg0UKYqcPMeFGfSgMTOQFs2icS%2BzH0SJgJcwKaicHNeHmfSBAS%2Bz8dqJxEinj61lgzBZu4YfCvITLH2N3OVX4On18CTfuA2FjJvPofuU78XjqpKu4iGKqsHbqWBNu5YcC0oQ4n5%2BC1xnAS7h9Hwhuk9n3x%2BXmWoWyE0fZgKed35j8%2FPjq7ex3%2BvPL44vJf%2F88Pn171WNBdr9y8l2HCl68RYQDnnZ5EA%2BA24dsmh7j3aiPru%2BpnkcQNHga1EFosB6bij1dgeOMhqWhcMu6bTAwak46ntw5S%2FyrG4Wh76a49TpIRP4YpP%2Fmp%2BPPJAl5lpMcfVtnIcdfiiTk6%2BTlF9XU5etM5m2Sl2%2FyZY2CjsMyHJD03g%2B9F3FMyOXOnSQJdg%2Fa0JhzvUBdNel6bQCF7pKuk1PRAzpPlQJ557G%2B8i0%2BcLEOhZLXt3CD5jqK1%2B2KDyyLok52%2FzWRdgvEDXPLUtxS3KrE3G7mlt01tw4bHGwFYAXgSpDwZgAPpBgctM3e3urXDw5U8aHGY3AYyMYtbR9uaYpbh3LLaMutoRTcKncvFeQymmZeFLtMHuwaKnYpdlUi1zezayQHu%2Bihy25gFz12DXiwa6TYpdhVSQLQyK7ChyyaXTrFrlEDu6jyoz4HdhX6NMWu586uQVt2aXKwizKy2XoDu6jyI4MHuzTFLsWuSqqFZnbpcrCLSkBpWw3sosqPbA7sGrIbNaTNDUDFJpctKwBOBE%2Fi3jv4H5wVAP8l%2BZHXOQDKzPYLP0yceZHs%2FjJLXPyQRfjHBT8sAv9qI6FzgJ3IJD9z69z1p5Wlnm7c3rYAYVtqtfWG7VKKbwPwwc%2BB96GQ3ZuB64%2BznNs4fzreMZyMC3TjF3q5Vnzj977e9tlxSvrjtF%2B%2FbXvUJ%2FtArVAG8CboLyOzXrV6sgOA2fFzdobfroHWbS36LZut8tscCyV6nhP%2FvIxnk8t%2B9qaLP3m3h3%2FR8ZiJv1Q%2FXF1t4%2BtRW1uW56zrJXj2l50%2FaGtiddgVnmwbZNmBxlE4Q7PI2ThLO%2BQXXWoyTlbxcr7aGhv2%2FEixddAQMZWRpVmOPgTJ8qCKDnV0AJTKarB4RoNF64nh8yDHsefh6wnaeTYgNPE8mVXZa2d%2BRyw0mcllGXl%2BZk5xnSXeBhtf5AkQj2wF6fixNGzrucnMPvhpwsKIlL2s7GGzrI8G%2FomEK6uYjy5j%2FyFIyNMnuCiW8RdWItfxHKzyz0xLURz7KbEm4XLkEBlo6PyW4TrH484rd3ijhLxpHgsxdk3aPHOdCrK6UaDc2NR5amJNOqe%2FEoPu6zgpfGAVH0n89tvwNnj78aXz6d%2B7N6%2B9m9Uy6AGyTxgbcrj3y3xxRST3BvEMXb5InLqt%2FMg8sHzHwlLwXRSSBcXT58NTQOQG81QOoYBOjW96gwyHLm92LCGFeSSPUEBxYg9OANI0mBNyuPd1aqwwGsQzdHmzY%2BEnzAl5dosqTuzBiWKe1kwKUw5SUPpLY9hAClrf2bFeEyaFPNs8lTpsn4Fi1JYUkmxuGw42Ua7lmxy2bm%2BjT6Bkz0eihTybRxUt9qDFoPVYIce%2BNG04pGgxbKIFdQKlVz4SLeTZ96losQ8tgL38MC3kiJOhDUfUYltrogV1gs0jVsZAl4YWe8jynw0lvk%2Fevfvy6%2FqfT4P7Tx%2Fe6C%2B%2F%2BvevS0tJo5K%2BSJwqmBI9m9p4MmyQ0jMnDIx6w29P0w48QTO4bDWTZz1%2FyGYYZQPYha1t4w2Ycjh1eja1qB82GAGYEwYNbpqedugJmsFl65p5ymx95qxru1PalMNF07OpAWmkNbGOHvKsJhIxMdl2PEEzeGxpG8hj3lNjJC%2B2AibB2hzHwtlKBdkZNYRDZE4Y2E3kozVJu56gGR1bHWG2ymN1VGzlxFYDsFTWposWzVaLsrCMBg1spU8YDJrIZx94gmZ2bAyF2SqPMVSxldfY2jbuQpF3Wzhb6WlnvyGcJHuGycWEeh4x7xSZdiFT2xBBphzeiJ5l0mRqCB%2FJnmEOeZBJOrW7ItPRyWS1JVPnYbr3JBO9xOo3CN7ZMywesY4LP7si01mSCXznrZ2Cphyqqp5Fr4D6Dap09gyLR2jjoTy6dEUmXiNT2yjGphxarJ5FSxS1Bjk7e4bFI5Lx8KRlJ4pMe5FJb0smSeQqFi1s1Jr0KswZNg81yVCpSc6ZTOA719r6tYuFh3AyjWgyNclJmDNsHmKP4UmLPRSZ9iJTW2tekVBMNJloL7KmN6pE6DNsLmGJlYbj%2BZGprZ%2BpSG4mnEy0BFhvFHHQZ9g8JBZDJbF4fmRqK4iyJJFY0BpgTW%2FSWDBnDHgoIIZKAfHsyKS31StZkigg6O0v9OaUFmd0nXDZmPz8%2BOrt7Hf688vji8l%2F%2Fzw%2BfXtVhKvaiUtybKNsBSZ49zowzYH3I8rhtNSAaU4tlpgT9IbdGZrZP%2FAEq%2BM1CQjWfYxlYkNyCQI4sCiGAS7H1ENjtdgN%2BKbh2rBXUDPoHb27nmB1bMAC8b2PGk2OsEDTYD4vJgEXujEdur7rMhMV9MtkaJlW%2F7C5AOAmB5tTjt67N6J770YvOXNG1wmAwebaR751ulPoVvgDO00TsN%2BDDdq5frBtMFqwNgWm1PtteL8GsHAHW1SOpcaQktSMGmQDdHltcJg4FH2NIxwIe108dpZ3f0eej0v8Pw%3D%3D%3C%2Fdiagram%3E%3C%2Fmxfile%3E "Mapeamento de estrutura do calculo de faturamento."). Lá, encontraremos quais bases são acionadas e quais views foram criadas para suportar o cálculo automatizado.

Além disso, abaixo, seguem pontos que sempre precisamos validar, para garantir que o cálculo estará correto:

**Validação Omie :**

1. Garantir que todo cliente que está no Omie e está ativo também está no Bitrix24; 
    - Precisamos identificar no Omie: 
        - Quais são os clientes ativos?
        - Quais são os clientes suspensos?
    - Com os dados acima, precisamos cruzar a base do Omie com a base do Bitrix24 para validar se o que está no Omie também está no Bitrix24. Lembrando que a fonte de dados sobre clientes (ou seja, o que define se o cliente está no Bitrix) é o funil de Ongoing no Bitrix24 (ou seja, se o cliente está no Omie como ativo ou suspenso e, também, está no funil do Ongoing, ai garantirmos que o cliente está ok); 
        - Quais campos usamos no cruzamento? 
            - A chave principal, do lado do **Bitrix24**, que utilizaremos é **cpf\_cnpj**;
            - A chave principal, do lado do **Omie**, que utilizaremos é **cnpj\_cpf**;
        - Como faremos esse cruzamento? 
            - Usaremos a view **bitrix\_ongoing** para puxar todos os deals de Ongoing;
            - Usaremos a view **omie\_active\_customers** para puxar todos os clientes que estão no Omie;
            - O cruzamento partirá da view **omie\_active\_customers** (que é a base mais confiável de clientes);
            - Abaixo, segue print do controle criado: [![image.png](https://wiki.oystr.com.br/uploads/images/gallery/2025-03/scaled-1680-/DnFimage.png)](https://wiki.oystr.com.br/uploads/images/gallery/2025-03/DnFimage.png)
2. Garantir que o que está no Bitrix24 e bate com o que está no Omie (sim, double check para não termos nenhum deal no funil do Ongoing de clientes que já cancelaram); 
    - Usaremos a mesma estrutura do ponto 1, a diferença é que a origem será a view **bitrix\_ongoing** para a view **omie\_active\_customers**. Usaremos as mesmas chaves para o cruzamento;
    - Abaixo, segue print da tabela criada em nossa dashboard:
3. Os produtos do cliente do Omie estão no Bitrix? 
    - Aqui, aproveitaremos a view que criamos do omie, que puxa somente os clientes ativos: **omie\_active\_customers**. Vamos cruzar essa view com a **bitrix\_ongoing\_console\_products**, que puxa todos os deals do funil de ongoint, juntamente com todos os produtos que estão relacionados no deal. Aqui, a ideia é simplesmente validar se todos os produtos/serviços que estão relacionados ao cliente no Omie também estão no Bitrix. 
        - Como faremos o cruzamento? 
            - Na view **omie\_active\_customers** usaremos os campos cnpj\_cpf (cnpj/cpf do cliente) e c\_cod\_serv (campo que armazena o código do produto correspondente no Bitrix, ou seja, que aquele serviço corresponte ao produto X do Bitrix);
            - Na view **bitrix\_ongoing\_console\_products** usaremos os campos cpf\_cnpj (cnpj/cpf do cliente, cadastrado no bitrix) e product\_id (ID do produto cadastrado no deal de Ongoing, no Bitrix24);
            - Por via das dúvidas, nessa view, puxaremos todos os campos disponíveis em ambas as views. O cruzamento partirá da view **omie\_active\_customers**, pois queremos saber o que não está cadastrado no Bitrix24;
            - O resultado desse cruzamento será todos os clientes que não estão cancelados no Omie e que há inconsistência: 
                - Ou não tem deal no funil de Ongoing no Bitrix24;
                - Ou no CNPJ/CPF cadastrado no deal de Ongoing no Bitrix24 está errado;
                - Ou os produtos cadastrados no deal de Ongoing no Bitrix24 estão incorretos;
4. Os produtos do cliente no Bitrix, bate com o que ele tem contratado? 
    - Aqui, utilizaremos a mesma estrutura que montamos para o ponto 3, a diferença é que o cruzamento será a partir da view **bitrix\_ongoing\_console\_products** para a view **omie\_active\_customers**, pois a ideia é validarmos o que está no bitrix que não está no Omie;
5. Os produtos estão com franquia corretamente cadastrada? 
    - Aqui, utilizaremos a view bitrix\_ongoing\_console\_products para consultarmos a franquia. Para isso, precisamos lembrar que há produtos que terão franquia baixa ou não terão franquia cadastrada. Segue lista: 
        - Desenvolvimento de novo robô;
        - Setups;
        - Execuções únicas;
        - Entre outros; 
            - Todos os casos que a franquia for igual ou menor que 12, precisamos ajustar. Porque igual ou menor que 12? Porque, anteriormente, o time comercial preenchia o campo "quantity" (Quantidade, no Bitrix24) com o número 12, para demonstrar que era um contrato anual. Mudamos isso em 2024, para que o campo "quantity" (Quantidade) seja a franquia contratada ao invés do tempo de contrato (anual). Segue print da dashboard:
            - [![image.png](https://wiki.oystr.com.br/uploads/images/gallery/2025-04/scaled-1680-/lHPimage.png)](https://wiki.oystr.com.br/uploads/images/gallery/2025-04/lHPimage.png)
6. Os produtos estão com o ID do Excedente cadastrado?
7. O ID do Excedente está no Omie?

**Validação Consumo:**

1. Tem Deal de Ongoing que não tem ID Console relacionado? 
    - Aqui, para confirmarmos isso, utilizaremos a view **bitrix\_ongoing\_console**, filtrando, apenas, por: 
        - Todos os casos que o campo id\_account for nulo (que significa que não encontrou a relação id\_entity e id\_account na tabela **bitrix\_crm\_console**);
        - Todos os casos que o campo active for 0 (que significa que o id\_account relacionado não está mais ativo no painel da Oystr);
2. Id\_robo esta em relacionando com algum produto?
3. Há Id\_account não relacionado a deals do Ongoing? 
    - Aqui, precisamos identificar se há ID\_ACCOUNTS, que estão em uso (com consumo) e que não estão relacionados em nenhum deal do Ongoing. Isso para confirmar se: 
        - Há consumo de não clientes;
        - Há contas de clientes não monitoradas pelo Ongoing;
    - Para isso, vamos utilizar duas views: 
        - **bitrix\_ongoing\_console**: para puxarmos todos os id\_accounts que já estão relacionados a deals;
        - **oystr\_executions\_consumption**: para puxarmos o consumo nos últimos 60 dias; 
            - Usando as duas views acima, faremos o cruzamento partindo da view **oystr\_executions\_consumption**, usando o campo id\_account como chave de cruzamento com a view **bitrix\_ongoing\_console**;
            - Aqui, pediremos que a query traga, do bitrix\_ongoing\_console, apenas o id\_entity (que é o suficiente para confirmarmos se há id\_account's não relacionados a Deals). Segue query abaixo: ```postgresql
                select oec.*, boc.id_entity
                from oystr_executions_consumption as oec
                left join bitrix_ongoing_console as boc on boc.id_account = oec.id_account
                where (oec.date_report > CURRENT_DATE - INTERVAL '60 day')
                ```
            - Aqui, basta filtrar, na dashboard, pelos casos que o id\_entity é nulo;
4. Cliente pode usar aquele robô?
5. Cliente pode ter contrato execução única?

Validação do produto:

O id\_produto esta correto ou esta com id da equivalência?  
O produto tem valores em estoque? (sem estoque sem contagem dos itens)  
Id\_robo esta cadastrado no produto correto?