SolidWorks

Visual Explanation of SQL Joins

With few more details: http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/

Si no te gusta algo, cámbialo.

Si no te gusta algo, cámbialo. Si no lo puedes cambiar, cambia tu actitud

If you do not like something, change it. If you can not change it, change your attitude

Se não gostas de algo, mudáo. Se não o podes mudár, muda a tua atitude

C2B - Provision of Services Customer Registration Normalized (XML) SEPA

The creation of the SEPA (Single Euro Payments Area - Single Area Payments in euros) allowed the strengthening of European integration and the establishment of a single retail payment market. Currently, SEPA covers, in addition to EU Member States, Iceland, Liechtenstein, Monaco, Norway, San Marino and Switzerland. In this space, economic agents can make and receive payments in euro, within countries and between countries, under the same conditions, rights and obligations.

In achieving this goal, SEPA offers pan-European payment instruments, such as credit transfers (SCT) and Direct Debits (SEPA DD), whose operation is based on standards, procedures and, as far as possible, common infrastructure to all participants .

The technical and business models are defined by the European Payments Council (EPC), in the rulebooks and the respective Implementation Guidelines (available in www.europeanpaymentscouncil.eu). These models are based on the technical specifications of the ISO20022 standard and are designed to ensure an automated processing credit transfers and collections.

It is up to banks the responsibility to implement a Customer-to-Bank channel (C2B) compatible with SEPA, following standard messages for use of EPC recommendations of XML ISO20022 standard set out in the SEPA C2B Implementation Guidelines and offer its customers the layout file to use.

In this framework, to facilitate the connection between the client and the bank, the Portuguese banking community has developed a harmonized reporting format applicable to the SEPA Credit Transfer and SEPA Direct Debits to. This document describes this pattern, for use in customer relationship - Bank by the member institutions of the national banking community.

The use of a harmonized layout has clear benefits for C2B communication (especially for businesses and public administration bodies), is proposing to: (i) remedy the multitude of formats used by customers in their relationship with banks for initiation payment instructions; and (ii) provide companies and public administration bodies efficient and advantageous communication solution in terms of cost.

Read more here

Be grateful fot what you have!

See the video and try to understand we need be gratefull for all we have in this life, good or not só good, God have a propose to us, remember.

https://www.facebook.com/brightside/videos/861895883939156/?fref=nf

How to prevent multiple logins of the same user in NAV?

How to prevent multiple logins of the same user in NAV?

How to prevent multiple logins of the same user in NAV?

After exhaust search in the web, find one piece of code to resolve this problem, but I need make modification to optimize the 

Before you work in the sql code, need add one column in the table “User Setup” with the name “Max_ Logins” of type int.

Read more here

SEPA XML CODE

SEPA XML CODE

C2B - Prestação de Serviços a Clientes Registo Normalizado (XML) SEPA

A criação da SEPA (Single Euro Payments Area - Área Única de Pagamentos em Euros) permitiu o reforço da integração europeia e o estabelecimento de um mercado único de pagamentos de retalho. Atualmente, o espaço SEPA abrange, para além dos Estados-Membros da UE, a Islândia, o Liechtenstein, o Mónaco, a Noruega, San Marino e a Suíça. Neste espaço, os agentes económicos podem efetuar e receber pagamentos em euros, dentro de cada país e entre países, sob as mesmas condições, direitos e obrigações.

Na concretização deste objetivo, a SEPA disponibiliza instrumentos de pagamento pan-europeus, como Transferências a Crédito (SCT) e Débitos Diretos (SEPA DD), cujo funcionamento assenta em standards, procedimentos e, na medida do possível, infraestruturas comuns a todos os participantes.

Continuar a leitura aqui