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