API integration

am integrating sage 200 with point of sale using api when i post a transaction in pos its giving an error.

the pos is executing the command bellow via API but same query via sql its going through 

INSERT INTO [dbo].[PostGL]
([TxDate],[Id],[AccountLink],[TrCodeID],[Debit],[Credit],[iCurrencyID],[fExchangeRate],[fForeignDebit],[fForeignCredit],[Description],[TaxTypeID],[Reference],[Order_No],[ExtOrderNum],
[cAuditNumber],[Tax_Amount],[fForeignTax],[Project],[Period],[DrCrAccount],[JobCodeLink],[CRCCheck],[DTStamp],[UserName], [iTaxPeriodID], [cPayeeName], [bPrintCheque], [cReference2], [RepID], [fJCRepCost], [iMFPID], [bIsJCDocLine], [bIsSTGLDocLine], [iInvLineID], [iTxBranchID], [cBankRef], [bPBTPaid], [iGLTaxAccountID], [bReconciled], [xAttribute], [PostGL_iBranchID], [PostGL_dCreatedDate], [PostGL_dModifiedDate], [PostGL_iCreatedBranchID], [PostGL_iModifiedBranchID], [PostGL_iCreatedAgentID], [PostGL_iModifiedAgentID], [PostGL_iChangeSetID], [PostGL_Checksum] ,[iMajorIndustryCodeID], [iImportDeclarationID])
VALUES
('2020-05-05','','21','31','40.00','0',
'0','1','40.00','0',
'Sales Order','0','1002000000121','','','0','0','0','0','0','0','0',NULL,'2020-05-05','', NULL, '' ,'0', '' ,'0', '0', '0','0','0', '0', '0', '', '0', '0', '0', '', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0');

the error

INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. (severity 16) in <b>/home/codewgmf/public_html/posapi1/createsale.php