<?xml version="1.0" standalone="no"?>
<dsView name="Cycle Counts by ABC" xmlns="ds:view">
	<attributes xmlns="">
		<attribute name="DEFAULT_STORE">QUERY: view="User Preferences";field=Value;where="Variable = 'DS_STORE' and User = ${DS_USER}"</attribute>
		<attribute name="DS_DISPLAY_CLASS">vertical</attribute>
		<attribute name="DS_VIEW_CLASS">Inventory</attribute>
		<attribute name="OFFLINE_STORE">QUERY: view="User Preferences";field=Value;where="Variable = 'DS_STORE' and User = ${DS_USER}"</attribute>
	</attributes>
	<connectionProfile xmlns="">SCM</connectionProfile>
	<sqlStatement xmlns="">select
BINNUM, ITEMNUM, DESCRIPTION, '' Count, ISSUEUNIT, 
PHYSCNTDATE, LOCATION, ABCTYPE, DUE_DATE
FROM DS_PHYSCNTBYABC_VW</sqlStatement>
	<permissions xmlns="">select update</permissions>
	<flags xmlns="">openSnapshot</flags>
	<maxOfflineRecords xmlns="">0</maxOfflineRecords>
	<fields xmlns="">
		<dsViewField fieldName="BINNUM" xmlns="">
			<displayName>Bin</displayName>
			<dataType>8</dataType>
			<flags>readonly primaryKey sortable searchable conflictCheck</flags>
			<displayWidth>56</displayWidth>
		</dsViewField>
		<dsViewField fieldName="ITEMNUM" xmlns="">
			<displayName>Item</displayName>
			<dataType>8</dataType>
			<flags>readonly primaryKey sortable searchable conflictCheck</flags>
			<displayWidth>70</displayWidth>
		</dsViewField>
		<dsViewField fieldName="DESCRIPTION" xmlns="">
			<displayName>Desc</displayName>
			<dataType>8</dataType>
			<flags>readonly sortable searchable conflictCheck</flags>
			<displayWidth>144</displayWidth>
		</dsViewField>
		<dsViewField fieldName="Count" xmlns="">
			<displayName>Count *</displayName>
			<dataType>8</dataType>
			<flags>sortable searchable conflictCheck</flags>
			<format>%.2f</format>
			<displayWidth>52</displayWidth>
		</dsViewField>
		<dsViewField fieldName="ISSUEUNIT" xmlns="">
			<displayName>UOM</displayName>
			<dataType>8</dataType>
			<flags>readonly sortable searchable conflictCheck</flags>
			<displayWidth>51</displayWidth>
		</dsViewField>
		<dsViewField fieldName="PHYSCNTDATE" xmlns="">
			<displayName>Last Counted</displayName>
			<dataType>7</dataType>
			<flags>readonly sortable searchable conflictCheck</flags>
			<displayWidth>70</displayWidth>
		</dsViewField>
		<dsViewField fieldName="LOCATION" xmlns="">
			<displayName>Storeroom</displayName>
			<dataType>8</dataType>
			<flags>readonly primaryKey sortable searchable conflictCheck</flags>
			<displayWidth>66</displayWidth>
			<fieldValidation xmlns="">
				<viewValidator displayType="dropdown" restrictToList="true" xmlns="">
					<relationship xmlns="">
						<childViewName>Storeroom List</childViewName>
						<flags/>
						<filter>
							<filterGroup>
								<filterItem fieldName="n.username">
									<test>=</test>
									<value>${DS_USER}</value>
								</filterItem>
							</filterGroup>
						</filter>
					</relationship>
					<valueField>Storeroom</valueField>
					<visibleField>Storeroom</visibleField>
				</viewValidator>
			</fieldValidation>
		</dsViewField>
		<dsViewField fieldName="ABCTYPE" xmlns="">
			<displayName>ABC Type</displayName>
			<dataType>8</dataType>
			<flags>readonly sortable searchable conflictCheck</flags>
			<displayWidth>52</displayWidth>
			<fieldValidation xmlns="">
				<listValidator restrictToList="true" xmlns="">
					<listItem>A</listItem>
					<listItem>B</listItem>
					<listItem>C</listItem>
					<listItem>D</listItem>
					<listItem>E</listItem>
				</listValidator>
			</fieldValidation>
		</dsViewField>
		<dsViewField fieldName="DUE_DATE" xmlns="">
			<displayName>Date Due</displayName>
			<dataType>7</dataType>
			<flags>readonly sortable searchable conflictCheck</flags>
			<format>%m/%d/%Y</format>
			<displayWidth>95</displayWidth>
		</dsViewField>
	</fields>
	<criteria xmlns="">
		<viewCriteria xmlns="">
			<name>Offline Criteria</name>
			<type>offline</type>
			<maxRecords>0</maxRecords>
			<filter>
				<filterGroup>
					<filterItem fieldName="LOCATION">
						<test>=</test>
						<value>${DEFAULT_STORE}</value>
					</filterItem>
					<filterItem fieldName="BINNUM">
						<test>=</test>
						<value>YARD</value>
					</filterItem>
				</filterGroup>
			</filter>
			<sortInfo xmlns=""/>
		</viewCriteria>
		<viewCriteria xmlns="">
			<name>Default Criteria</name>
			<type>default</type>
			<maxRecords>0</maxRecords>
			<filter>
				<filterGroup>
					<filterItem fieldName="LOCATION">
						<test>=</test>
						<value>${DEFAULT_STORE}</value>
					</filterItem>
					<filterItem fieldName="ABCTYPE">
						<test>=</test>
						<value>A</value>
					</filterItem>
					<filterItem fieldName="DUE_DATE">
						<test>&lt;=</test>
						<value>${DS_CURRENT_TIME}</value>
					</filterItem>
				</filterGroup>
			</filter>
			<sortInfo xmlns="">
				<sortItem>
					<displayName>Bin</displayName>
					<direction>ascending</direction>
				</sortItem>
			</sortInfo>
		</viewCriteria>
	</criteria>
	<events xmlns="">
		<event sqlEvent="update" xmlns="">
			<eventAction action="insteadOf">
				<dbProcedureAction procedureName="pkg_dsinv.proc_locauth_check" xmlns="">
					<continueOnFail>false</continueOnFail>
					<parameter name="P_STOREROOM">
						<value>${Storeroom}</value>
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>8</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_USER">
						<value>${DS_USER}</value>
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>18</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
				</dbProcedureAction>
			</eventAction>
			<eventAction action="insteadOf">
				<dbProcedureAction procedureName="pkg_dsinv.proc_dsphyscnt_update" xmlns="">
					<continueOnFail>false</continueOnFail>
					<parameter name="P_ITEM">
						<value>${Item}</value>
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>30</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_LOCATION">
						<value>${Storeroom}</value>
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>8</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_LOT">
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>8</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_BIN">
						<value>${Bin}</value>
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>8</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_CURBAL">
						<sqlType>3</sqlType>
						<columnType>2</columnType>
						<columnSize>15</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_QTY">
						<value>${Count *}</value>
						<sqlType>3</sqlType>
						<columnType>1</columnType>
						<columnSize>15</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_CNTDATE">
						<value>${DS_EDIT_TIME}</value>
						<sqlType>11</sqlType>
						<columnType>1</columnType>
						<columnSize>19</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_GLSHRINK">
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>20</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_GLCONTROL">
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>20</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_RECONCILE">
						<value>N</value>
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>4000</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_MEMO">
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>254</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_MAXQTY">
						<value>0</value>
						<sqlType>3</sqlType>
						<columnType>1</columnType>
						<columnSize>38</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_MAXCOST">
						<value>0</value>
						<sqlType>3</sqlType>
						<columnType>1</columnType>
						<columnSize>38</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_DAYSALLOWED">
						<value>1</value>
						<sqlType>3</sqlType>
						<columnType>2</columnType>
						<columnSize>38</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
					<parameter name="P_USER">
						<value>${DS_USER}</value>
						<sqlType>12</sqlType>
						<columnType>1</columnType>
						<columnSize>4000</columnSize>
						<decimalDigits>0</decimalDigits>
						<nullable>true</nullable>
					</parameter>
				</dbProcedureAction>
			</eventAction>
		</event>
	</events>
	<viewPermissions xmlns="">
		<viewPermission xmlns="">
			<userName>DataSplice::JLHERNANDEZ</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::DMANCHEGO</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::GLOGAN</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::CSEFFROOD</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::MBLOMGREN</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::AJACOBSEN</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::JSIBERT</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::RPOLLETTE</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::NATENCIO</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::DBURTON</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::MZAPPITELLI</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::KSALISBURY</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::JNARANJO</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::JPHELPS</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::VVASQUEZ</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::DDREW</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::RWHEELER</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::BBARLETT</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::BPATTERSON</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::dborders</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::DGULLEDGE</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::rcrump</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::THARVEY</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::dshenoy</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::GGRABCZYK</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<userName>DataSplice::SGONZALES</userName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>MAXIMO::DEFLT</groupName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>SCM::SCM_SYSADM</groupName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>DataSplice::SCM MATERIALS</groupName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>SCM::SCM_INVENTSPECL03</groupName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>DataSplice::TOOL ROOM</groupName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>DataSplice::Administrators</groupName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>SCM::SCM_MATERIALS01</groupName>
		</viewPermission>
		<viewPermission xmlns="">
			<groupName>SCM::SCM_MATERIALS02</groupName>
		</viewPermission>
	</viewPermissions>
</dsView>
