BankAccountSignature

Bank Account Signature: Name Type Mandatory Description <Record Type =”??”> Long Y Type of object to import. ?? is for BankAccount Signature <DBId></DBId> Long Y Database Id in DeMaSy. It is displayed in Utilities...

Stock transfer payment

Stock transfer payment: RecordType;DBId;Ref;Desc;DeliveryNote;InvoiceDate; PCurrency;PCyAmount;InvoicePaymentCurrency;CurrencyRate;CyAmount; Amount;Description;BankStatmentNumber;BankAccountNumber Nr Name Type Description 1 RecordType Long Type of object to import. 15...

Select double GLAccountName numbers

Select [GLAccountName].[DBId] as [ResDBId], [GLAccountName].[Number], [GLAccountName].[LanguageId], [GLAccountName].[GLAccPlanTypeId], count(*) as [Result] From [GLAccountName] where Not [GLAccountName].[Number] = ” Group by [GLAccountName].[DBId],...

Create UserOption

Insert Into [UserOptions] ([DBId], [UserId], [Variable], [Value]) Select -1 as [ResDBId], [User].[Id] as [ResUserId], ‘BehaviourAcctEntries’ as [ResVariable], ‘2’ as [ResValue] from [User] LEFT JOIN [UserOptions] ON ([User].[Id] =...