Example #1 – insert single EcENTITY record
used to transfer data of a created or updated purchased item from ERP to Vault
DECLARE @EntName nvarchar(100), @EntId bigint;
SET @EntName = 'PurchItem 987';
EXEC @EntId = EcWriteEntity @EntName
UPDATE EcENTITY SET category = 'Purchased', txt00 = 'BOLT M10 x 25mm, GOLD-COATED', comm_status = 0 WHERE id = @EntId;
SELECT @EntId;
Last updated
Was this helpful?