by Administrator | Mar 15, 2022 | Non classé
SQL Server now uses the Transport Layer Security (TLS) to encrypt data. To do so, you need a certificate with its name matching the fully qualified domain name (FQDN) of your SQL Server and make sure it is issued for Server Authentication with a KeySpec...
by Administrator | Apr 28, 2021 | Query
Select * from [GLAccGLCaption] LEFT JOIN [ClientType] ON ([GLAccGLCaption].[TableId] = [ClientType].[Id] and [GLAccGLCaption].[DBId] = [ClientType].[DBId]) where [GLAccGLCaption].[TableName] = ‘ClientType’ and [ClientType].[Id] Is Null Select * from...
by Administrator | Apr 28, 2021 | Query
Select * from [GLAccGLCaption] LEFT JOIN [SupplierType] ON ([GLAccGLCaption].[TableId] = [SupplierType].[Id] and [GLAccGLCaption].[DBId] = [SupplierType].[DBId]) where [GLAccGLCaption].[TableName] = ‘SupplierType’ and [SupplierType].[Id] Is Null Select *...
by Administrator | Feb 11, 2021 | Interface
SUPPLIER INVOICE (header) Name Type Mandatory Description <Record Type =”24″> Long Y Type of object to import. 24 is for supplier invoice <DBId></DBId> Long Y Database ID in DeMaSy <Number></Number> Char(50) Y Number of the...
by Administrator | Feb 8, 2021 | Query
Select [GLMovement].[DBId] as [ResDBId], [GLMovement].[GLPeriodId] as [ResGLPeriodId], [GLMovement].[GLAccountId] as [ResGLAccountId], [GLMovement].[CurrencyId] as [ResCurrencyId], Round(Sum(Case When [GLMovement].[CD] = ‘D’ Then [GLMovement].[Amount] Else...