venuasg 5/17/2010 9:11:09 AM

Inventory Master Import Error

Hi All,

I get an error while importing through eConnect for taUpdateCreateItemRcd  the error says "Cannot insert the value NULL into column 'UOFM', table TWO.dbo.IV00107; Column does not allow nulls. Insert Fails"

Following is my XML, can any one let me know am i missing something here.

<?xml version="1.0" encoding="utf-8" ?>

- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <IVItemMasterType>
  <eConnectProcessInfo xsi:nil="true" />
  <taRequesterTrxDisabler_Items xsi:nil="true" />
- <taUpdateCreateItemRcd>
  <ITEMNMBR>TEST ITEM 999</ITEMNMBR>
  <ITEMDESC>eCONNECT TEST ITEM</ITEMDESC>
  <ITMSHNAM>ITEM999</ITMSHNAM>
  <ITMGEDSC>ITEM999</ITMGEDSC>
  <ITMCLSCD>MODEMS</ITMCLSCD>
  <UOMSCHDL>EACH</UOMSCHDL>
  <USCATVLS_6>YES</USCATVLS_6>
  <UpdateIfExists>0</UpdateIfExists>
  </taUpdateCreateItemRcd>
  <taUpdateCreateItemCurrencyRcd_Items xsi:nil="true" />
  <taIVCreateItemPriceListLine_Items xsi:nil="true" />
  <taIVCreateItemPriceListHeader xsi:nil="true" />
  <taItemSite_Items xsi:nil="true" />
  <taCreateItemVendors_Items xsi:nil="true" />
  <taCreateKitItemRcd_Items xsi:nil="true" />
  </IVItemMasterType>
  </eConnect>
Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3