Dynamic 365 Finance and operation App

 -----Insert Registration Types---------- insert into TAXREGISTRATION(TaxRegistrationTypeApplicabilityRule, REGISTRATIONNUMBER,DirPartyLocation,VALIDTO) select TAXREGISTRATIONTYPE.RECID,'300187978800003',(select top 1 RECID from DIRPARTYLOCATION where LOCATION=(select top 1 RECID from LogisticsLocation  where LOCATIONID='000012001')),'2154-12-31 00:00:00.000' from   TAXREGISTRATIONTYPE where  TAXREGISTRATIONTYPE.TAXREGSTRATIONTYPE='TRN'

     public str getAttributeValue(ItemId _itemid, str _AttrName)     {         inventTable                     InventTable;         EcoResProductAttributeValue     ecoResProductAttributeValue;         EcoResAttribute                 ecoResAttribute;         EcoResValue                     ecoResValue;         select * from         InventTable         join EcoResProductAttributeValue         where ecoResProductAttributeValue.Product == InventTable.Product         &&  InventTable.itemid == _itemid         join  ecoResAttribute         where ecoResProductAttributeV...