Hello,
I am experimenting with using eConnect XML to insert / update inventory items. So far my tests have lead me to construct the following message.
<?xml version="1.0" encoding="utf-8"?>
<eConnect>
<IVItemMasterType>
<taUpdateCreateItemRcd>
<ITEMNMBR>ITEMXVII</ITEMNMBR>
<ITEMDESC>Test SKU</ITEMDESC>
<ITEMTYPE>1</ITEMTYPE>
<ITMGEDSC>411</ITMGEDSC>
<ITMCLSCD>411</ITMCLSCD>
<UOMSCHDL>SEATS</UOMSCHDL>
<PRCHSUOM/>
<USCATVLS_1>VAV</USCATVLS_1>
<USCATVLS_2>411</USCATVLS_2>
<USCATVLS_3>DC020502</USCATVLS_3>
<USCATVLS_4>NEW</USCATVLS_4>
<USCATVLS_5>BUSINESS</USCATVLS_5>
<USCATVLS_6>12</USCATVLS_6>
<PriceGroup>STD</PriceGroup>
<PRICMTHD>1</PRICMTHD>
<Purchase_Tax_Options>3</Purchase_Tax_Options>
<INACTIVE>0</INACTIVE>
<LOCNCODE>TTS</LOCNCODE>
<UseItemClass>0</UseItemClass>
<UpdateIfExists>1</UpdateIfExists>
</taUpdateCreateItemRcd>
</IVItemMasterType>
</eConnect>
However this message fails with the following cryptic error:
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IVSCRVIX', table 'TTS.dbo.IV00101'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Is this un-documented column mapped to an XML element?What does it normally hold?
Am I missing any elements or structure in the above XML message?
Thanks
Stephen