Possible regression in DataSource.getFIelds() starting in Sept 1 nightly

[jay.l.fisher]

I have code that has been working fine for quite some time but started getting a null pointer error after upgrading to the latest nightly. I worked my way backwards and discovered that it works OK in the 8/31 SmartGWT EE build but is broken starting 9/1.

The code iterates over the fields in a data source ...

for (DataSourceField field : itemSummaryDS.getFields()) {
  if (field.getName().startsWith("IATT")) {
    // Do some things with the field
  }
}

The NPE happens on the field.getName().startWith("IATT") call. Presumably field.getName() is null.

[Isomorphic]

Can you show a DataSource definition where you can get this to occur?

[jay.l.fisher]

It's too long to include in one post. Here is everything except the <field> tags. I'll post those next.

<DataSource ID="ItemSummary" dataFormat="iscServer" dbName="iptsfill" serverConstructor="com.islandpacific.gui.server.customDataSource.IpDataSource" serverType="sql" sparseUpdates="true" tableName="IPITHDR">
	<!-- Provides a summarized view of item master information.  -->
	<fields> 
See next post.
        </fields>
	<operationBindings>
		<operationBinding operationType="fetch">
			<selectClause>
			<![CDATA[
				max(CASE WHEN IPITHDR.IPPK='Y' THEN 'Y' ELSE 'N' END) as IPPK,
				min(IDIV) as IDIV,
				min(IDPT) as IDPT,
				min(ISBD) as ISBD,
				min(ICLS) as ICLS,
				min(IVEN) as IVEN,
				min(ISTY) as ISTY,
				min(ICLR) as ICLR,
				min(ISIZ) as ISIZ,
				min(IDES) as IDES,
				min(ISDS) as ISDS,								
				min(ICGP) as ICGP,				
				min(ISBN) as ISBN,				
				min(IGTIN) as IGTIN,								
				min(ISKU) as ISKU,
				avg(IACC) as IACC,
				max(ILOCC) as ILOCC,
				max(ILOCF) as ILOCF,
				min(ILVC) as ILVC,
				max(INVC) as INVC,
				max(IVNC) as IVNC,	
				max(IALT) as IALT,
				max(IORT) as IORT,
				max(IPLU) as IPLU,
				min(IRET) as minIRET,
				max(IRET) as IRET,
				max(ISPQ) as ISPQ,
				max(ISPR) as ISPR,
				max(ISUG) as ISUG,
				max(ITMP) as ITMP,		
				min(IPRI01) as IPRI01,
				min(IPRI02) as IPRI02,
				min(IPRI03) as IPRI03,
				min(IPRI04) as IPRI04,
				min(IPRI05) as IPRI05,
				min(IPRI06) as IPRI06,
				min(IPRI07) as IPRI07,
				min(IPRI08) as IPRI08,
				min(IPRI09) as IPRI09,
				min(IPRI10) as IPRI10,
				max(IPRC01) as IPRC01,
				max(IPRC02) as IPRC02,
				max(IPRC03) as IPRC03,
				max(IPRC04) as IPRC04,
				max(IPRC05) as IPRC05,
				max(IPRC06) as IPRC06,
				max(IPRC07) as IPRC07,
				max(IPRC08) as IPRC08,
				max(IPRC09) as IPRC09,
				max(IPRC10) as IPRC10,
				max(IPRN01) as IPRN01,
				max(IPRN02) as IPRN02,
				max(IPRN03) as IPRN03,
				max(IPRN04) as IPRN04,
				max(IPRN05) as IPRN05,
				max(IPRN06) as IPRN06,
				max(IPRN07) as IPRN07,
				max(IPRN08) as IPRN08,
				max(IPRN09) as IPRN09,
				max(IPRN10) as IPRN10,
				sum(IPRQ01) as IPRQ01,
				sum(IPRQ02) as IPRQ02,
				sum(IPRQ03) as IPRQ03,
				sum(IPRQ04) as IPRQ04,
				sum(IPRQ05) as IPRQ05,
				sum(IPRQ06) as IPRQ06,
				sum(IPRQ07) as IPRQ07,
				sum(IPRQ08) as IPRQ08,
				sum(IPRQ09) as IPRQ09,
				sum(IPRQ10) as IPRQ10,
				sum(IBGR1) as IBGR1,
				sum(IBGR2) as IBGR2,
				sum(IBGR3) as IBGR3,
				sum(IBGR4) as IBGR4,
				sum(IPUR1) as IPUR1,
				sum(IPUR2) as IPUR2,
				sum(IPUR3) as IPUR3,
				sum(IPUR4) as IPUR4,
				sum(IVRR1) as IVRR1,
				sum(IVRR2) as IVRR2,
				sum(IVRR3) as IVRR3,
				sum(IVRR4) as IVRR4,
				sum(ISLR1) as ISLR1,
				sum(ISLR2) as ISLR2,
				sum(ISLR3) as ISLR3,
				sum(ISLR4) as ISLR4,
				sum(IRTR1) as IRTR1,
				sum(IRTR2) as IRTR2,
				sum(IRTR3) as IRTR3,
				sum(IRTR4) as IRTR4,
				sum(IAPR1) as IAPR1,
				sum(IAPR2) as IAPR2,
				sum(IAPR3) as IAPR3,
				sum(IAPR4) as IAPR4,
				sum(IUPR1) as IUPR1,
				sum(IUPR2) as IUPR2,
				sum(IUPR3) as IUPR3,
				sum(IUPR4) as IUPR4,
				sum(IGMR1) as IGMR1,
				sum(IGMR2) as IGMR2,
				sum(IGMR3) as IGMR3,
				sum(IGMR4) as IGMR4,
				sum(IUAR1) as IUAR1,
				sum(IUAR2) as IUAR2,
				sum(IUAR3) as IUAR3,
				sum(IUAR4) as IUAR4,
				sum(IPAR1) as IPAR1,
				sum(IPAR2) as IPAR2,
				sum(IPAR3) as IPAR3,
				sum(IPAR4) as IPAR4,
				sum(ICRV1) as ICRV1,
				sum(ICRV2) as ICRV2,
				sum(ICRV3) as ICRV3,
				sum(ICRV4) as ICRV4,
				sum(IBGC1) as IBGC1,
				sum(IBGC2) as IBGC2,
				sum(IBGC3) as IBGC3,
				sum(IBGC4) as IBGC4,
				sum(IPUC1) as IPUC1,
				sum(IPUC2) as IPUC2,
				sum(IPUC3) as IPUC3,
				sum(IPUC4) as IPUC4,
				sum(IVPC1) as IVPC1,
				sum(IVPC2) as IVPC2,
				sum(IVPC3) as IVPC3,
				sum(IVPC4) as IVPC4,
				sum(IVRC1) as IVRC1,
				sum(IVRC2) as IVRC2,
				sum(IVRC3) as IVRC3,
				sum(IVRC4) as IVRC4,
				sum(ISLC1) as ISLC1,
				sum(ISLC2) as ISLC2,
				sum(ISLC3) as ISLC3,
				sum(ISLC4) as ISLC4,
				sum(IRTC1) as IRTC1,
				sum(IRTC2) as IRTC2,
				sum(IRTC3) as IRTC3,
				sum(IRTC4) as IRTC4,
				sum(IALC1) as IALC1,
				sum(IALC2) as IALC2,
				sum(IALC3) as IALC3,
				sum(IALC4) as IALC4,
				sum(IFDC1) as IFDC1,
				sum(IFDC2) as IFDC2,
				sum(IFDC3) as IFDC3,
				sum(IFDC4) as IFDC4,
				sum(IPMC1) as IPMC1,
				sum(IPMC2) as IPMC2,
				sum(IPMC3) as IPMC3,
				sum(IPMC4) as IPMC4,	
				sum(IGMC1) as IGMC1,
				sum(IGMC2) as IGMC2,
				sum(IGMC3) as IGMC3,
				sum(IGMC4) as IGMC4,
				sum(IUAC1) as IUAC1,
				sum(IUAC2) as IUAC2,
				sum(IUAC3) as IUAC3,
				sum(IUAC4) as IUAC4,															
				sum(IPAC1) as IPAC1,
				sum(IPAC2) as IPAC2,
				sum(IPAC3) as IPAC3,
				sum(IPAC4) as IPAC4,
				sum(IBGU1) as IBGU1,
				sum(IBGU2) as IBGU2,
				sum(IBGU3) as IBGU3,
				sum(IBGU4) as IBGU4,
				sum(IPUU1) as IPUU1,
				sum(IPUU2) as IPUU2,
				sum(IPUU3) as IPUU3,
				sum(IPUU4) as IPUU4,
				sum(IVRU1) as IVRU1,
				sum(IVRU2) as IVRU2,
				sum(IVRU3) as IVRU3,
				sum(IVRU4) as IVRU4,
				sum(ISLU1) as ISLU1,
				sum(ISLU2) as ISLU2,
				sum(ISLU3) as ISLU3,
				sum(ISLU4) as ISLU4,
				sum(IRTU1) as IRTU1,
				sum(IRTU2) as IRTU2,
				sum(IRTU3) as IRTU3,
				sum(IRTU4) as IRTU4,	
				sum(IAPU1) as IAPU1,
				sum(IAPU2) as IAPU2,
				sum(IAPU3) as IAPU3,
				sum(IAPU4) as IAPU4,
				sum(IUPU1) as IUPU1,
				sum(IUPU2) as IUPU2,
				sum(IUPU3) as IUPU3,
				sum(IUPU4) as IUPU4,
				sum(IUAU1) as IUAU1,
				sum(IUAU2) as IUAU2,
				sum(IUAU3) as IUAU3,
				sum(IUAU4) as IUAU4,
				sum(ITIR) as ITIR,
				sum(IVIR) as IVIR,				
				sum(ITIU) as ITIU,
				sum(ITIC) as ITIC,				
				sum((ISLR1-IVRR1)*CSRK) as ShrinkageReserveWeek,
				sum((ISLR2-IVRR2)*CSRK) as ShrinkageReserveMonth,
				sum((ISLR3-IVRR3)*CSRK) as ShrinkageReserveSeason,
				sum((ISLR4-IVRR4)*CSRK) as ShrinkageReserveYear,
				sum((ISLC1-IVRC1)*CSRK) as ShrinkageReserveCostWeek,
				sum((ISLC2-IVRC2)*CSRK) as ShrinkageReserveCostMonth,
				sum((ISLC3-IVRC3)*CSRK) as ShrinkageReserveCostSeason,
				sum((ISLC4-IVRC4)*CSRK) as ShrinkageReserveCostYear,	
				count(distinct(idiv)) as CountIDIV,			
				count(distinct(idpt)) as CountIDPT,	
				count(distinct(isbd)) as CountISBD,
				count(distinct(icls)) as CountICLS, 
				count(distinct(iven)) as CountIVEN,							
				count(distinct(ivst)) as CountIVST,
				count(distinct(iclr)) as CountICLR,
				count(distinct(isiz)) as CountISIZ, 		
				count(distinct(isku)) as CountISKU, 
				count(distinct(icls||iven||isty)) as CountICLSIVENISTY,
				count(distinct(ICGP)) as CountICGP,
				count(distinct(IDES)) as CountIDES,
				count(distinct(csri)) as CountCSRI,		
				min(CSRI) as CSRI,
				sum(IPPS1) as IPPS1,
				sum(IPPS2) as IPPS2,
				sum(IPPS3) as IPPS3,
				sum(IPPS4) as IPPS4,
				sum(IPPS5) as IPPS5,
				sum(IPPR1) as IPPR1,
				sum(IPPR2) as IPPR2,
				sum(IPPR3) as IPPR3,
				sum(IPPR4) as IPPR4,
				sum(IPPR5) as IPPR5,
				sum(IPPI1) as IPPI1,
				sum(IPPI2) as IPPI2,
				sum(IPPI3) as IPPI3,
				sum(IPPI4) as IPPI4,
				sum(IPPI5) as IPPI5,
				sum(IVSR1) as IVSR1,
				sum(IVSR2) as IVSR2,
				sum(IVSR3) as IVSR3,
				sum(IVSR4) as IVSR4,
				sum(IVMR1) as IVMR1,
				sum(IVMR2) as IVMR2,
				sum(IVMR3) as IVMR3,
				sum(IVMR4) as IVMR4,
				max(IORT) as IORT,
				max(ITMP) as ITMP,								
				max(ITFI) as ITFI,								
				max(ITTI) as ITTI,
				max(ISPQ) as ISPQ,
				max(ISPR) as ISPR,
				min(INCI) as INCI,
				avg(IVLC) as IVLC,
				min(ILVC) as ILVC,
				max(IVST) as IVST,				
				avg(IVCH) as IVCH,				
				avg(IVCW) as IVCW,				
				avg(IVCL) as IVCL,				
				avg(IVCT) as IVCT,				
				avg(IVCU) as IVCU,
				max(IQCT) as IQCT,	
				max(IRCL) as IRCL,
				max(IRVN) as IRVN,
				max(IRST) as IRST,
				max(IRCR) as IRCR,
				max(IRSZ) as IRSZ,	
				max(IHPI1) as IHPI1,						
				max(IHPI2) as IHPI2,						
				max(IHPI3) as IHPI3,										
				avg(IHPR1) as IHPR1,						
				avg(IHPR2) as IHPR2,						
				avg(IHPR3) as IHPR3,										
				min(DIGITS(IRCL)||'-'||DIGITS(IRVN)||'-'||DIGITS(IRST)||'-'||DIGITS(IRCR)||'-'||DIGITS(IRSZ)) AS ReclassedToItemNumber,											
				min(DIGITS(IDIV) || ' ' || IPDIVSN.DNAM) as DIVNAM,	
				min(DIGITS(IDPT) || ' ' || IPDEPTS.DNAM) as DPTNAM,
				min(DIGITS(ISBD) || ' ' || IPSBDPT.SNAM) as SBDNAM,
				min(DIGITS(ICLS) || ' ' || IPCLASS.CLNM) as CLSNAM,	
				min(DIGITS(IVEN) || ' ' || IPMRVEN.VNAM) as VENNAM,	
				min(DIGITS(ICLR) || ' ' || IPCOLOR.CLRN) as CLRNAM,	
				min(DIGITS(ISIZ) || ' ' || IPSIZES.SNAM) as SIZNAM,	
				max(ICGP || ' ' || IPCORGP.CDES) as CGPNAM,
				max(ISTS) as ISTS,
				max(IHLD) as IHLD,
				max(IVAT) as IVAT,				
				max(IXDI) as IXDI,								
				max(ILPI) as ILPI,												
				max(IRTN) as IRTN,
				max(ILET) as ILET,
				max(IITR) as IITR,
				max(IUCD) as IUCD,				
				max(IWT2) as IWT2,	
				max(IMIN) as IMIN,
				max(IMKD) as IMKD,				
				max(IMLT) as IMLT,	
				max(ISUQ) as ISUQ,			
				max(ISUD) as ISUD,
				max(IBAS) as IBAS,
				max(IBSS) as IBSS,				
				max(IGSK) as IGSK,								
				max(IS#T) as IS#T,												
				max(IMMH) as IMMH,												
				max(IWKH) as IWKH,																
				max(IBIN) as IBIN,																
				max(ISAL) as ISAL,																				
				max(IMUC) as IMUC,																								
				max(IPKT) as IPKT,																												
				max(IZPR) as IZPR,
				max(ITKT) as ITKT,
				max(ICYC) as ICYC,
				max(ICOR) as ICOR,	
				max(ICOM) as ICOM,
				max(ICOD) as ICOD,	
				max(ICCD) as ICCD,
				max(IPPC) as IPPC,
				sum(IDQT) as IDQT,
				sum(ISQF) as ISQF,	
				max(IDDC) as IDDC,			
				min(IATT01) as IATT01,
				min(IATT02) as IATT02,
				min(IATT03) as IATT03,
				min(IATT04) as IATT04,
				min(IATT05) as IATT05,
				min(IATT06) as IATT06,
				min(IATT07) as IATT07,
				min(IATT08) as IATT08,
				min(IATT09) as IATT09,
				min(IATT10) as IATT10,
				min(IATT11) as IATT11,
				min(IATT12) as IATT12,
				min(IATT13) as IATT13,
				min(IATT14) as IATT14,
				min(IATT15) as IATT15,
				min(IATT16) as IATT16,
				min(IATT17) as IATT17,
				min(IATT18) as IATT18,
				min(IATT19) as IATT19,
				min(IATT20) as IATT20,
				min(IATT21) as IATT21,
				min(IATT22) as IATT22,
				min(IATT23) as IATT23,
				min(IATT24) as IATT24,
				min(IATT25) as IATT25,
				min(IATT26) as IATT26,
				min(IATT27) as IATT27,
				min(IATT28) as IATT28,
				min(IATT29) as IATT29,
				min(IATT30) as IATT30,
				min(IATT31) as IATT31,
				min(IATT32) as IATT32,
				min(IATT33) as IATT33,
				min(IATT34) as IATT34,
				min(IATT35) as IATT35,
				min(IATT36) as IATT36,
				min(IATT37) as IATT37,
				min(IATT38) as IATT38,
				min(IATT39) as IATT39,
				min(IATT40) as IATT40,
				min(IATT41) as IATT41,
				min(IATT42) as IATT42,
				min(IATT43) as IATT43,
				min(IATT44) as IATT44,
				min(IATT45) as IATT45,
				min(IATT46) as IATT46,
				min(IATT47) as IATT47,
				min(IATT48) as IATT48,
				min(IATT49) as IATT49,
				min(IATT50) as IATT50,
				SUM(COALESCE((SELECT SUM(CASE WHEN IERR='C' OR ITQR>IQTY THEN 0 ELSE IQTY-ITQR END) 
	 				FROM ippoitm
			 		WHERE ipithdr.ICLS=ippoitm.ICLS and ipithdr.IVEN=ippoitm.IVEN 
						and ipithdr.ISTY=ippoitm.ISTY and ipithdr.ICLR=ippoitm.ICLR and ipithdr.ISIZ=ippoitm.ISIZ
						and ippoitm.IPPK<>'Y' 
				),0)) as OnOrderInEaches,
				SUM(COALESCE((SELECT SUM(CASE WHEN IERR='C' OR ITQR>IQTY THEN 0 ELSE IQTY-ITQR END * COMPQTY) 
					 FROM ippkdef 
					 JOIN ippoitm on PKCLS=ippoitm.ICLS and PKVEN=ippoitm.IVEN 
					 	and PKSTY=ippoitm.ISTY and PKCLR=ippoitm.ICLR and PKSIZ=ippoitm.ISIZ
					 WHERE ipithdr.ICLS=PKCLSC and ipithdr.IVEN=PKVENC and ipithdr.ISTY=PKSTYC and ipithdr.ICLR=PKCLRC and ipithdr.ISIZ=PKSIZC
				),0)) as OnOrderInPacks,
				SUM(COALESCE((SELECT SUM(CASE WHEN IERR='C' OR ITQR>IQTY THEN 0 ELSE IQTY-ITQR END * ippoitm.IRET) 
	 				FROM ippoitm
			 		WHERE ipithdr.ICLS=ippoitm.ICLS and ipithdr.IVEN=ippoitm.IVEN 
						and ipithdr.ISTY=ippoitm.ISTY and ipithdr.ICLR=ippoitm.ICLR and ipithdr.ISIZ=ippoitm.ISIZ
						and ippoitm.IPPK<>'Y' 
				),0)) +
				SUM(COALESCE((SELECT SUM(CASE WHEN IERR='C' OR ITQR>IQTY THEN 0 ELSE IQTY-ITQR END * COMPQTY * ippoitm.IRET) 
					 FROM ippkdef 
					 JOIN ippoitm on PKCLS=ippoitm.ICLS and PKVEN=ippoitm.IVEN 
					 	and PKSTY=ippoitm.ISTY and PKCLR=ippoitm.ICLR and PKSIZ=ippoitm.ISIZ
					 WHERE ipithdr.ICLS=PKCLSC and ipithdr.IVEN=PKVENC and ipithdr.ISTY=PKSTYC and ipithdr.ICLR=PKCLRC and ipithdr.ISIZ=PKSIZC
				),0)) as OnOrderRetail,
				SUM(COALESCE((SELECT SUM(CASE WHEN IERR='C' OR ITQR>IQTY THEN 0 ELSE IQTY-ITQR END * ippoitm.ILNC) 
	 				FROM ippoitm
			 		WHERE ipithdr.ICLS=ippoitm.ICLS and ipithdr.IVEN=ippoitm.IVEN 
						and ipithdr.ISTY=ippoitm.ISTY and ipithdr.ICLR=ippoitm.ICLR and ipithdr.ISIZ=ippoitm.ISIZ
						and ippoitm.IPPK<>'Y' 
				),0)) +
				SUM(COALESCE((SELECT SUM(CASE WHEN IERR='C' OR ITQR>IQTY THEN 0 ELSE IQTY-ITQR END * COMPQTY * ippoitm.ILNC) 
					 FROM ippkdef 
					 JOIN ippoitm on PKCLS=ippoitm.ICLS and PKVEN=ippoitm.IVEN 
					 	and PKSTY=ippoitm.ISTY and PKCLR=ippoitm.ICLR and PKSIZ=ippoitm.ISIZ
					 WHERE ipithdr.ICLS=PKCLSC and ipithdr.IVEN=PKVENC and ipithdr.ISTY=PKSTYC and ipithdr.ICLR=PKCLRC and ipithdr.ISIZ=PKSIZC
				),0)) as OnOrderCost
			]]>
			</selectClause>
			<tableClause>
				IPITHDR  
				LEFT JOIN IPDIVSN ON IDIV=IPDIVSN.DDIV 
				LEFT JOIN IPDEPTS ON IDPT=IPDEPTS.DDPT
				LEFT JOIN IPSBDPT ON ISBD=IPSBDPT.SSBD 
				LEFT JOIN IPCLASS ON ICLS=IPCLASS.CCLS
				LEFT JOIN IPMRVEN ON IVEN=IPMRVEN.VVEN 
				LEFT JOIN IPCOLOR ON ICLR=IPCOLOR.CCLR 
				LEFT JOIN IPSIZES ON ISIZ=IPSIZES.SSIZ 
				LEFT JOIN IPCORGP ON ICGP=IPCORGP.CCDE
			</tableClause>			
		</operationBinding>
	</operationBindings>
</DataSource>

[jay.l.fisher]

And here are the fields ...

 		<field name="DIVNAM" title="Division" type="text"/>
 		<field name="DPTNAM" title="Department" type="text"/>
 		<field name="SBDNAM" title="Sub-department" type="text"/>
 		<field name="CLSNAM" title="Class" type="text"/>
 		<field name="VENNAM" title="Vendor" type="text"/>
 		<field name="CLRNAM" title="Color" type="text"/>
 		<field name="SIZNAM" title="Size" type="text"/>
 		<field name="CGPNAM" title="Coordinate" type="text"/>
		<field canEdit="false" detail="true" name="CSRI" title="Last Season Reset Date" type="date"/>
 		
		 <field name="CountIDIV" title="DIV Count" type="integer"/>		 
		 <field name="CountIDPT" title="DEPT Count" type="integer"/>	
		 <field name="CountISBD" title="SUBDEPT Count" type="integer"/>	 
		 <field name="CountICLS" title="Class Count" type="integer"/>
		 <field name="CountIVEN" title="Vendor Count" type="integer"/>
		 <field name="CountIVST" title="Style Count" type="integer"/>
		 <field name="CountICLR" title="Color Count" type="integer"/>
		 <field name="CountISIZ" title="Size Count" type="integer"/>
		 <field name="CountISKU" title="SKU Count" type="integer"/>
		 <field name="CountICLSIVENISTY" title="Class Vendor Style Count" type="integer"/>
		 <field name="CountCSRI" title="Count Season Reset Date" type="integer"/>
		 <field name="CountICGP" title="Coordinate Count" type="integer"/>
		 <field name="CountIDES" title="IDES Count" type="integer"/>
		 
		 <field length="1" name="IBAS" title="Basic Item" type="text" width="23"/>
		 <field length="1" name="IZPR" title="Store Pricing" type="text" width="23"/>
 		 <field detail="true" labelAsTitle="true" name="IMKD" sqlStorageStrategy="singleCharYN" title="Permanent Markdown" type="boolean"/>
		 
		 <field length="3" name="IDIV" title="Division" type="integer" width="39"/>
		 <field length="3" name="IDPT" title="Department" type="integer" width="39"/>
		 <field length="4" name="IDPT" title="Sub-department" type="integer" width="47"/>
		 <field length="4" name="ICLS" title="Class" type="integer" width="47"/>
		 <field length="5" name="IVEN" title="Vendor" type="integer" width="55"/>
		 <field length="4" name="ISTY" title="Style" type="integer" width="47"/>
		 <field length="3" name="ICLR" title="Color" type="integer" width="39"/>
		 <field length="4" name="ISIZ" title="Size" type="integer" width="47"/>
		 <field length="10" name="ISKU" title="SKU Number" type="integer" width="95"/>
		 <field name="IDES" title="Item Description" type="text"/>
		 <field length="15" name="IVST" title="Vendor Style" type="text" width="135"/>
		 
		 <field length="9" name="ISDS" title="Short Description" type="text" width="87"/> 
		 <field length="4" name="ICGP" title="Coordinate Group" type="text" width="47"/>
		 <field length="10" name="ISBN" title="ISBN Number" type="text" width="95"/>
		 <field length="14" name="IGTIN" title="GTIN" type="text" width="127"/>
		 <field name="IORT" title="Original Retail" type="currency" width="80"/> 
		 <field name="ITMP" title="Promotional Retail" type="currency" width="80"/>
		 <field name="ITFI" title="Promotional From Date" type="date"/>
		 <field name="ITTI" title="Promotional To Date" type="date"/>
		 <field name="ISPR" title="Split Price Retail" type="currency" width="80"/>
		 <field length="3" name="ISPQ" title="Split Price Quantity" type="integer" width="39"/>
		 
		 
		 <field name="IACC" title="Actual Cost" type="currency" width="80"/>
		 <field length="3" name="ILOCC" title="Last PO Currency" type="text" width="39"/>
		 <field name="ILOCF" title="Last PO Cost Foreign" type="currency" width="80"/>
		 <field name="ILVC" title="Lowest Vendor Cost" type="currency" width="80"/>
		 <field name="INVC" title="Next Vendor Cost" type="currency" width="80"/>
		 <field name="IVNC" title="Last Vendor Cost" type="currency" width="80"/>
		 <field name="ILVC" title="Lowest Vendor Cost" type="currency" width="80"/>
		 <field name="IVLC" title="Valued Cost" type="currency" width="80"/> 

		 <field name="IALT" title="Alt PLU Retail" type="currency" width="80"/>
		 <field name="IORT" title="Original Retail" type="currency" width="80"/>
		 <field name="IPLU" title="PLU Retail" type="currency" width="80"/>
		 <field name="IRET" title="Book Retail" type="currency" width="80"/>
		 <field name="minIRET" title="Minimum Retail" type="currency" width="80"/>
		 <field length="3" name="ISPQ" title="Split Price Quantity" type="integer" width="39"/>
		 <field name="ISPR" title="Split Price Retail" type="currency" width="80"/>
		 <field name="ISUG" title="Suggested Retail" type="currency" width="80"/>
		 <field name="INCI" title="Next Cost Effective" type="date"/> 

		 <field name="IPRI01" title="Prior Receipt Iso Date" type="date"/>
		 <field name="IPRI02" title="" type="date"/>
		 <field name="IPRI03" title="" type="date"/>
		 <field name="IPRI04" title="" type="date"/>
		 <field name="IPRI05" title="" type="date"/>
		 <field name="IPRI06" title="" type="date"/>
		 <field name="IPRI07" title="" type="date"/>
		 <field name="IPRI08" title="" type="date"/>
		 <field name="IPRI09" title="" type="date"/>
		 <field name="IPRI10" title="" type="date"/>
		 <field name="IPRC01" title="Last Receipt Cost" type="currency" width="80"/>
		 <field name="IPRC02" title="" type="currency" width="80"/>
		 <field name="IPRC03" title="" type="currency" width="80"/>
		 <field name="IPRC04" title="" type="currency" width="80"/>
		 <field name="IPRC05" title="" type="currency" width="80"/>
		 <field name="IPRC06" title="" type="currency" width="80"/>
		 <field name="IPRC07" title="" type="currency" width="80"/>
		 <field name="IPRC08" title="" type="currency" width="80"/>
		 <field name="IPRC09" title="" type="currency" width="80"/>
		 <field name="IPRC10" title="" type="currency" width="80"/>
		 <field length="10" name="IPRN01" title="Prior Receipt Number" type="integer" width="95"/>
		 <field length="10" name="IPRN02" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN03" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN04" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN05" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN06" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN07" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN08" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN09" title="" type="integer" width="95"/>
		 <field length="10" name="IPRN10" title="" type="integer" width="95"/>
		 <field length="9" name="IPRQ01" title="Prior Receipt Qty" type="integer" width="87"/>
		 <field length="9" name="IPRQ02" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ03" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ04" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ05" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ06" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ07" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ08" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ09" title="" type="integer" width="87"/>
		 <field length="9" name="IPRQ10" title="" type="integer" width="87"/>
		 
		 <field name="IBGR1" title="Beg Inventory At Retail" type="float"/>
		 <field name="IBGR2" title="" type="float"/>
		 <field name="IBGR3" title="" type="float"/>
		 <field name="IBGR4" title="" type="float"/>
		 <field name="IPUR1" title="Purchases At Retail" type="float"/>
		 <field name="IPUR2" title="" type="float"/>
		 <field name="IPUR3" title="" type="float"/>
		 <field name="IPUR4" title="" type="float"/>
		 <field name="IVRR1" title="Vendor Returns At Retail" type="float"/>
		 <field name="IVRR2" title="" type="float"/>
		 <field name="IVRR3" title="" type="float"/>
		 <field name="IVRR4" title="" type="float"/> 		 
		 <field name="ISLR1" title="Sales At Retail" type="float"/>
		 <field name="ISLR2" title="" type="float"/>
		 <field name="ISLR3" title="" type="float"/>
		 <field name="ISLR4" title="" type="float"/>
		 <field name="IRTR1" title="Returns At Retail" type="float"/>
		 <field name="IRTR2" title="" type="float"/>
		 <field name="IRTR3" title="" type="float"/>
		 <field name="IRTR4" title="" type="float"/>
		 <field name="IAPR1" title="Auth Pos Mkd Retail" type="float"/>
		 <field name="IAPR2" title="" type="float"/>
		 <field name="IAPR3" title="" type="float"/>
		 <field name="IAPR4" title="" type="float"/>
		 <field name="IUPR1" title="Unauth Po Mdk Retail" type="float"/>
		 <field name="IUPR2" title="" type="float"/>
		 <field name="IUPR3" title="" type="float"/>
		 <field name="IUPR4" title="" type="float"/>	
		 <field name="IGMR1" title="Gen Mkdn At Retail" type="float"/>
		 <field name="IGMR2" title="" type="float"/>
		 <field name="IGMR3" title="" type="float"/>
		 <field name="IGMR4" title="" type="float"/>
		 <field name="IUAR1" title="Unit Adj At Retail" type="float"/>
		 <field name="IUAR2" title="" type="float"/>
		 <field name="IUAR3" title="" type="float"/>
		 <field name="IUAR4" title="" type="float"/>		 
		 <field name="IPAR1" title="Price Adj At Retail" type="float"/>
		 <field name="IPAR2" title="" type="float"/>
		 <field name="IPAR3" title="" type="float"/>
		 <field name="IPAR4" title="" type="float"/>
		 <field name="ICRV1" title="Currency Revaluation" type="float"/>
		 <field name="ICRV2" title="" type="float"/>
		 <field name="ICRV3" title="" type="float"/>
		 <field name="ICRV4" title="" type="float"/>
		 
		 <field name="IBGC1" title="Beg Inventory At Cost" type="float"/>
		 <field name="IBGC2" title="" type="float"/>
		 <field name="IBGC3" title="" type="float"/>
		 <field name="IBGC4" title="" type="float"/>
		 <field name="IPUC1" title="Purchases At Cost" type="float"/>
		 <field name="IPUC2" title="" type="float"/>
		 <field name="IPUC3" title="" type="float"/>
		 <field name="IPUC4" title="" type="float"/>
		 <field name="IVRC1" title="Vendor Returns At Cost" type="float"/>
		 <field name="IVRC2" title="" type="float"/>
		 <field name="IVRC3" title="" type="float"/>
		 <field name="IVRC4" title="" type="float"/>
		 <field name="ISLC1" title="Sales At Cost" type="float"/>
		 <field name="ISLC2" title="" type="float"/>
		 <field name="ISLC3" title="" type="float"/>
		 <field name="ISLC4" title="" type="float"/>
		 <field name="IRTC1" title="Returns At Cost" type="float"/>
		 <field name="IRTC2" title="" type="float"/>
		 <field name="IRTC3" title="" type="float"/>
		 <field name="IRTC4" title="" type="float"/>
		 <field name="IALC1" title="Allowances At Cost" type="float"/>
		 <field name="IALC2" title="" type="float"/>
		 <field name="IALC3" title="" type="float"/>
		 <field name="IALC4" title="" type="float"/>
		 <field name="IFDC1" title="Freight And Duty At Cost" type="float"/>
		 <field name="IFDC2" title="" type="float"/>
		 <field name="IFDC3" title="" type="float"/>
		 <field name="IFDC4" title="" type="float"/>
		 <field name="IPMC1" title="Pos Markdowns At Cost" type="float"/>
		 <field name="IPMC2" title="" type="float"/>
		 <field name="IPMC3" title="" type="float"/>
		 <field name="IPMC4" title="" type="float"/>
		 <field name="IGMC1" title="Gen Mkdn At Cost" type="float"/>
		 <field name="IGMC2" title="" type="float"/>
		 <field name="IGMC3" title="" type="float"/>
		 <field name="IGMC4" title="" type="float"/>
		 <field name="IUAC1" title="Unit Adj At Cost" type="float"/>
		 <field name="IUAC2" title="" type="float"/>
		 <field name="IUAC3" title="" type="float"/>
		 <field name="IUAC4" title="" type="float"/>
		 <field name="IPAC1" title="Price Adj At Cost" type="float"/>
		 <field name="IPAC2" title="" type="float"/>
		 <field name="IPAC3" title="" type="float"/>
		 <field name="IPAC4" title="" type="float"/>
		 		 		 		 		 		 		
		 <field length="11" name="IBGU1" title="Beg Inv In Units" type="integer" width="103"/>
		 <field length="11" name="IBGU2" title="" type="integer" width="103"/>
		 <field length="11" name="IBGU3" title="" type="integer" width="103"/>
		 <field length="11" name="IBGU4" title="" type="integer" width="103"/>
		 <field length="11" name="IPUU1" title="Purchases In Units" type="integer" width="103"/>
		 <field length="11" name="IPUU2" title="" type="integer" width="103"/>
		 <field length="11" name="IPUU3" title="" type="integer" width="103"/>
		 <field length="11" name="IPUU4" title="" type="integer" width="103"/>
		 <field length="11" name="IVRU1" title="Vendor Returns In Units" type="integer" width="103"/>
		 <field length="11" name="IVRU2" title="" type="integer" width="103"/>
		 <field length="11" name="IVRU3" title="" type="integer" width="103"/>
		 <field length="11" name="IVRU4" title="" type="integer" width="103"/>
		 <field length="11" name="ISLU1" title="Sales In Units" type="integer" width="103"/>
		 <field length="11" name="ISLU2" title="" type="integer" width="103"/>
		 <field length="11" name="ISLU3" title="" type="integer" width="103"/>
		 <field length="11" name="ISLU4" title="" type="integer" width="103"/>
		 <field length="11" name="IRTU1" title="Returns In Units" type="integer" width="103"/>
		 <field length="11" name="IRTU2" title="" type="integer" width="103"/>
		 <field length="11" name="IRTU3" title="" type="integer" width="103"/>
		 <field length="11" name="IRTU4" title="" type="integer" width="103"/>
		 <field length="11" name="IAPU1" title="Auth Pos Mdk Units" type="integer" width="103"/>
		 <field length="11" name="IAPU2" title="" type="integer" width="103"/>
		 <field length="11" name="IAPU3" title="" type="integer" width="103"/>
		 <field length="11" name="IAPU4" title="" type="integer" width="103"/>
		 <field length="11" name="IUPU1" title="Unauth Pos Mkd Units" type="integer" width="103"/>
		 <field length="11" name="IUPU2" title="" type="integer" width="103"/>
		 <field length="11" name="IUPU3" title="" type="integer" width="103"/>
		 <field length="11" name="IUPU4" title="" type="integer" width="103"/>
		 <field length="11" name="IUAU1" title="Unit Adj In Units" type="integer" width="103"/>
		 <field length="11" name="IUAU2" title="" type="integer" width="103"/>
		 <field length="11" name="IUAU3" title="" type="integer" width="103"/>
		 <field length="11" name="IUAU4" title="" type="integer" width="103"/>
		 <field name="ITIR" title="Inventory at Retail" type="currency" width="80"/>
		 <field length="11" name="ITIU" title="Inventory in Units" type="integer" width="103"/>
		 <field name="ITIC" title="Inventory at Cost" type="currency" width="80"/>
 		 
		 <field name="ShrinkageReserveWeek" title="" type="float"/>		 
		 <field name="ShrinkageReserveMonth" title="" type="float"/>		 
		 <field name="ShrinkageReserveSeason" title="" type="float"/>		 
		 <field name="ShrinkageReserveYear" title="" type="float"/>		 

		 <field name="ShrinkageReserveCostWeek" title="" type="float"/>		 
		 <field name="ShrinkageReserveCostMonth" title="" type="float"/>		 
		 <field name="ShrinkageReserveCostSeason" title="" type="float"/>		 
		 <field name="ShrinkageReserveCostYear" title="" type="float"/>		 
		 	 		 	 		 		 		 		 		 				 		 		 		 		 
		 <field length="11" name="IPPS1" title="Prior Five Weeks Sales" type="integer" width="103"/>
		 <field length="11" name="IPPS2" title="" type="integer" width="103"/>
		 <field length="11" name="IPPS3" title="" type="integer" width="103"/>
		 <field length="11" name="IPPS4" title="" type="integer" width="103"/>
		 <field length="11" name="IPPS5" title="" type="integer" width="103"/>
		 <field length="11" name="IPPR1" title="Prior Five Weeks Returns" type="integer" width="103"/>
		 <field length="11" name="IPPR2" title="" type="integer" width="103"/>
		 <field length="11" name="IPPR3" title="" type="integer" width="103"/>
		 <field length="11" name="IPPR4" title="" type="integer" width="103"/>
		 <field length="11" name="IPPR5" title="" type="integer" width="103"/>
		 <field length="11" name="IPPI1" title="Prior Five Weeks End Inv" type="integer" width="103"/>
		 <field length="11" name="IPPI2" title="" type="integer" width="103"/>
		 <field length="11" name="IPPI3" title="" type="integer" width="103"/>
		 <field length="11" name="IPPI4" title="" type="integer" width="103"/>
		 <field length="11" name="IPPI5" title="" type="integer" width="103"/>
		 		 
		 <field name="IVSR1" title="Vat On Sales At Retail" type="float"/>
		 <field name="IVSR2" title="" type="float"/>
		 <field name="IVSR3" title="" type="float"/>
		 <field name="IVSR4" title="" type="float"/> 		 	 		 
		 
		 <field name="IVMR1" title="Vat On Mkd At Retail" type="float"/>
		 <field name="IVMR2" title="" type="float"/>
		 <field name="IVMR3" title="" type="float"/>
		 <field name="IVMR4" title="" type="float"/>
		 
		 <field name="IVIR" title="Vat On Inventory At Retail" type="float"/>
		 
		 <field name="IVPC1" title="Vat On Purchases At Cost" type="float"/>
 		 <field name="IVPC2" title="" type="float"/>
 		 <field name="IVPC3" title="" type="float"/>
 		 <field name="IVPC4" title="" type="float"/>

		 <field name="OnOrderInEaches" title="On Order In Eaches" type="integer"/>
		 <field name="OnOrderInPacks" title="On Order In Packs" type="integer"/>
		 <field name="OnOrderRetail" title="On Order Retail" type="currency" width="80"/>
		 <field name="OnOrderCost" title="On Order Cost" type="currency" width="80"/>
		 
		 <field length="1" name="ISTS" title="User Defined Status" type="text" width="23"/>
		 <field length="1" name="IHLD" title="Item Hold Indicator" type="text" width="23"/>
 		 <field length="1" name="IVAT" title="Vat Code" type="text" width="23"/>	
		 <field name="IXDI" title="Creation Date" type="date"/>
		 <field name="ILPI" title="Last Physical Inventory" type="date"/>
		 <field length="4" name="IRTN" title="Vendor's Return Policy Code" type="text" width="47"/>
		 <field length="3" name="ILET" title="Lead Time" type="integer" width="39"/>
		 <field length="3" name="IITR" title="In Transit Time" type="integer" width="39"/>  
		 <field length="2" name="IUCD" title="Purchase Unit Code" type="text" width="31"/>
		 <field name="IWT2" title="Weight Per Unit" type="float"/>
		 <field length="5" name="IMIN" title="Vendor Minimum Pack" type="integer" width="55"/>
		 <field length="5" name="IMLT" title="Minimum Distribution Lot" type="integer" width="55"/>
		 <field length="5" name="ISUQ" title="Sales Per Stocking Unit" type="integer" width="55"/>
		 <field length="10" name="ISUD" title="Stocking Unit Desc." type="text" width="95"/>
		 <field length="1" name="ITKT" title="Ticket Format" type="text" width="23"/>
		 <field length="2" name="ICYC" title="Cycle Count Code" type="text" width="31"/>
		 <field length="3" name="ICOR" title="Country Of Origin" type="text" width="39"/>
		 <field length="3" name="ICOM" title="Country Of Manufacture" type="text" width="39"/>
		 <field length="3" name="ICOD" title="Country Of Delivery" type="text" width="39"/>
		 <field length="14" name="ICCD" title="Commodity Code" type="text" width="127"/>
		 <field length="1" name="IPPC" title="Promo Price Code" type="text" width="23"/> 
		 <field length="7" name="IDQT" title="Display Quantity" type="integer" width="71"/>
		 <field name="ISQF" title="Square Footage" type="float"/>		 
		 <field length="5" name="IDDC" title="Default Dc" type="integer" width="55"/>
		 <field length="3" name="IVCH" title="VCP Height" type="integer" width="39"/>
		 <field length="3" name="IVCW" title="VCP Width" type="integer" width="39"/>
		 <field length="3" name="IVCL" title="VCP Length" type="integer" width="39"/>
		 <field name="IVCT" title="VCP Weight" type="float"/>
		 <field length="7" name="IVCU" title="VCP Quantity" type="integer" width="71"/>
		 <field length="10" name="IQCT" title="Quality Control Type" type="text" width="95"/>
		 <field length="4" name="IRCL" title="Reclassed To Class" type="integer" width="47"/>
		 <field length="5" name="IRVN" title="Reclassed To Vendor" type="integer" width="55"/>
		 <field length="4" name="IRST" title="Reclassed To Style" type="integer" width="47"/>
		 <field length="3" name="IRCR" title="Reclassed To Color" type="integer" width="39"/>
		 <field length="4" name="IRSZ" title="Reclassed To Size" type="integer" width="47"/>
		 <field name="ReclassedToItemNumber" title="Reclassed to" type="text"/>		
		 
		 <field name="IHPR1" title="Prior Retail Price 1" type="currency" width="80"/>
		 <field name="IHPR2" title="Prior Retail Price 2" type="currency" width="80"/>
		 <field name="IHPR3" title="Prior Retail Price 3" type="currency" width="80"/>
		 <field name="IHPI1" title="Prior Retail Date 1" type="date"/>
		 <field name="IHPI2" title="Prior Retail Date 2" type="date"/>
		 <field name="IHPI3" title="Prior Retail Date 3" type="date"/>		  
		 
		 <field length="1" name="IBSS" title="Basic Stock Substitute" type="text" width="23"/>
		 <field detail="true" labelAsTitle="true" name="IGSK" sqlStorageStrategy="singleCharYN" title="Generic SKU" type="boolean"/>
		 <field detail="true" labelAsTitle="true" name="IS#T" sqlStorageStrategy="singleCharYN" title="Serial Number Tracking" type="boolean"/>
		 <field detail="true" labelAsTitle="true" name="IMMH" sqlStorageStrategy="singleCharYN" title="Maintain Monthly History" type="boolean"/>
		 <field length="1" name="IWKH" title="Weekly History I,s,b,n" type="text" width="23"/>
		 <field length="5" name="IBIN" title="Bin Location" type="text" width="55"/>
		 <field detail="true" labelAsTitle="true" name="ISAL" sqlStorageStrategy="singleCharYN" title="Temporarily On Sale" type="boolean"/>
		 <field length="1" name="IMUC" title="Multiple Upcs? Y/n" type="text" width="23"/>
		 <field length="10" name="IPKT" title="Package Type" type="text" width="95"/> 
		  		 
		<field canEdit="false" customSelectExpression="CASE WHEN IPITHDR.IPPK='Y' THEN 'Y' ELSE 'N' END" length="4" name="IPPK" tableName="IPITHDR" title="Type" type="text">
		 	<valueMap>
		 		<value id="Y">Pack</value>
		 		<value id="N">Item</value>
		 	</valueMap>
	 	</field>
	 		  		 		   			 		 		 		 		 		 		 	 		 	 		 		 		 		 		 				 		 		 		 		 		 		 		 	 
	<field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Season    Mer ID      001" name="IATT01" tableName="IPITHDR" title="Season    Mer ID      001" type="enum"><valueMap><value ID="1">Spring                 SP</value><value ID="2">Summer                 SU</value><value ID="3">Autumn                 AU</value><value ID="4">Winter                 WT</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Story - LKB" name="IATT02" tableName="IPITHDR" title="Story - LKB" type="enum"><valueMap><value ID="1">Story 1</value><value ID="2">Story 2</value><value ID="3">Story 3</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;v test 1  mer id        3" name="IATT03" tableName="IPITHDR" title="v test 1  mer id        3" type="enum"><valueMap><value ID="1">Belts</value><value ID="2">Galoshes</value><value ID="3">Hobnail Boots</value><value ID="4">Dungarees</value><value ID="5">Boiler Suits</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;u test 2                4" name="IATT04" tableName="IPITHDR" title="u test 2                4" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;t test 3                5" name="IATT05" tableName="IPITHDR" title="t test 3                5" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;s test 4                6" name="IATT06" tableName="IPITHDR" title="s test 4                6" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;r test 5                7" name="IATT07" tableName="IPITHDR" title="r test 5                7" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;q test 6                8" name="IATT08" tableName="IPITHDR" title="q test 6                8" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;p test 7                9" name="IATT09" tableName="IPITHDR" title="p test 7                9" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;o test 8               10" name="IATT10" tableName="IPITHDR" title="o test 8               10" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;n test 9               11" name="IATT11" tableName="IPITHDR" title="n test 9               11" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;m test 10              12" name="IATT12" tableName="IPITHDR" title="m test 10              12" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;l test 11              13" name="IATT13" tableName="IPITHDR" title="l test 11              13" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;g test 12              14" name="IATT14" tableName="IPITHDR" title="g test 12              14" type="enum"><valueMap><value ID="1">A &amp; B</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;f test 13              15" name="IATT15" tableName="IPITHDR" title="f test 13              15" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;d test 15" name="IATT17" tableName="IPITHDR" title="d test 15" type="enum"><valueMap><value ID="1">skdjfslkd</value><value ID="2">t2</value><value ID="3">t3</value><value ID="4">xdddd-</value><value ID="5">test 123</value><value ID="6">test 456</value><value ID="9">ego- x</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;e test 14" name="IATT16" tableName="IPITHDR" title="e test 14" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;End Use/Occasion - LKB" name="IATT19" tableName="IPITHDR" title="End Use/Occasion - LKB" type="enum"><valueMap><value ID="1">occasion 1</value><value ID="2">occasion 2</value><value ID="3">occasion 3</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;1 test 16" name="IATT18" tableName="IPITHDR" title="1 test 16" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Web Item Attribute" name="IATT21" tableName="IPITHDR" title="Web Item Attribute" type="enum"><valueMap><value ID="1">Web Enabled</value><value ID="2">Web Not Enabled</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Campaign - LKB" name="IATT20" tableName="IPITHDR" title="Campaign - LKB" type="enum"><valueMap><value ID="1">Campaign 2</value><value ID="2">Campaign 3</value><value ID="4">Campaign 1</value><value ID="5">Campaign 4</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Season - LKB" name="IATT23" tableName="IPITHDR" title="Season - LKB" type="enum"><valueMap><value ID="1">Winter</value><value ID="2">Fall</value><value ID="3">Spring</value><value ID="4">Summer</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;SKR FAROUK TEST" name="IATT22" tableName="IPITHDR" title="SKR FAROUK TEST" type="enum"><valueMap><value ID="1">ATTR1</value><value ID="2">ATTR2</value><value ID="3">ATTR3</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;color season" name="IATT25" tableName="IPITHDR" title="color season" type="enum"><valueMap><value ID="1">color seaon1</value><value ID="2">Duplicate test</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Fabric - LKB" name="IATT24" tableName="IPITHDR" title="Fabric - LKB" type="enum"><valueMap><value ID="1">Patent</value><value ID="3">Leather</value><value ID="4">Canvas</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Style Type" name="IATT27" tableName="IPITHDR" title="Style Type" type="enum"><valueMap><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Fabric" name="IATT26" tableName="IPITHDR" title="Fabric" type="enum"><valueMap><value ID="1">fabric1</value><value ID="2">fabric2</value><value ID="3">Rubber                  Z</value><value ID="4">Satinsilkcottonragsrichma</value><value ID="5">Cardboard gun metal    xx</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Internet Store" name="IATT29" tableName="IPITHDR" title="Internet Store" type="enum"><valueMap><value ID="1">Internet sku</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;Product Category" name="IATT28" tableName="IPITHDR" title="Product Category" type="enum"><valueMap><value ID="1">pc1</value><value ID="2">pc2</value><value ID="3">pc3</value><value ID="4">pc4</value><value ID="5">pc5</value><value ID="6">pc6</value><value ID="7">pc7</value><value ID="8">pc8</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;John Lewis" name="IATT31" tableName="IPITHDR" title="John Lewis" type="enum"><valueMap><value ID="1">YES</value><value ID="2">No</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;House of Fraser" name="IATT30" tableName="IPITHDR" title="House of Fraser" type="enum"><valueMap><value ID="1">Yes</value><value ID="2">no</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;HANDLING TYPE" name="IATT34" tableName="IPITHDR" title="HANDLING TYPE" type="enum"><valueMap><value ID="1">Hanging</value><value ID="2">Flat</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;SEASON" name="IATT35" tableName="IPITHDR" title="SEASON" type="enum"><valueMap><value ID="1">spring</value><value ID="2">summer</value><value ID="3">fall</value><value ID="4">winter</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;LKB - Description" name="IATT32" tableName="IPITHDR" title="LKB - Description" type="enum"><valueMap><value ID="1">Closed Court</value><value ID="2">Open Court</value><value ID="3">Hobnail Boot</value><value ID="4">Steel Toe Cap</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" detail="true" length="15" menuItem="Attributes&gt;LKB - Material" name="IATT33" tableName="IPITHDR" title="LKB - Material" type="enum"><valueMap><value ID="1">Leather</value><value ID="2">Gossamer</value><value ID="3">Crimpolene</value><value ID="4">Rubber</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field><field align="left" canEdit="true" length="15" menuItem="Attributes&gt;Category" name="IATT36" required="true" tableName="IPITHDR" title="Category" type="enum"><valueMap><value ID="1">lyrical</value><value ID="2">elegiac</value><value ID="3">atonal</value><value ID="4">serial</value><value ID="999">UNKNOWN</value><value ID="0"> </value></valueMap></field>

[Isomorphic]

Is that Java code client-side or server-side?

[jay.l.fisher]

Client side