Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

<?xml version="1.0" encoding="UTF-8"?>
<Export generator="Cache" version="25">
<Class name="CREPOS.HRCHLLEVEL">
<Description>
Generated by the Link Table wizard on 2018-10-18 12:44:04. Note that you can access the data in this class only when the external database is accessible.</Description>
<ProcedureBlock>0</ProcedureBlock>
<SqlRowIdPrivate>1</SqlRowIdPrivate>
<SqlTableName>HRCHL_LEVEL</SqlTableName>
<Super>%Library.Persistent,%XML.Adaptor,CREPOS.DBCONFIG</Super>
<TimeCreated>64939,45844.179732</TimeCreated>

<Property name="CREATEDBY">
<Type>%String</Type>
<SqlColumnNumber>12</SqlColumnNumber>
<SqlFieldName>CREATED_BY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CREATED_BY"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="20"/>
</Property>

<Property name="DATECREATED">
<Type>%Date</Type>
<SqlColumnNumber>13</SqlColumnNumber>
<SqlFieldName>DATE_CREATED</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DATE_CREATED"/>
<Parameter name="EXTERNALSQLTYPE" value="91"/>
</Property>

<Property name="DATEMODIFIED">
<Type>%Date</Type>
<SqlColumnNumber>15</SqlColumnNumber>
<SqlFieldName>DATE_MODIFIED</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DATE_MODIFIED"/>
<Parameter name="EXTERNALSQLTYPE" value="91"/>
</Property>

<Property name="FILENUMBER">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>3</SqlColumnNumber>
<SqlFieldName>FILE_NUMBER</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="FILE_NUMBER"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="HL01HRCHLID">
<Type>%String</Type>
<SqlColumnNumber>8</SqlColumnNumber>
<SqlFieldName>HL01HRCHL_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="HL01HRCHL_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="12"/>
</Property>

<Property name="HL02HRCHLPRNTID">
<Type>%String</Type>
<SqlColumnNumber>9</SqlColumnNumber>
<SqlFieldName>HL02HRCHL_PRNT_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="HL02HRCHL_PRNT_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="12"/>
</Property>

<Property name="HL03HRCHLLVLCD">
<Type>%String</Type>
<SqlColumnNumber>10</SqlColumnNumber>
<SqlFieldName>HL03HRCHL_LVL_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="HL03HRCHL_LVL_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>

<Property name="HL04HRCHLCHILDCD">
<Type>%String</Type>
<SqlColumnNumber>11</SqlColumnNumber>
<SqlFieldName>HL04HRCHL_CHILD_CD</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="HL04HRCHL_CHILD_CD"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="1"/>
</Property>

<Property name="HRCHLLEVELKEY">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>2</SqlColumnNumber>
<SqlFieldName>HRCHL_LEVEL_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="HRCHL_LEVEL_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>

<Property name="LOOPID">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>7</SqlColumnNumber>
<SqlFieldName>LOOP_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="LOOP_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="12"/>
</Property>

<Property name="MODIFIEDBY">
<Type>%String</Type>
<SqlColumnNumber>14</SqlColumnNumber>
<SqlFieldName>MODIFIED_BY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="MODIFIED_BY"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="20"/>
</Property>

<Property name="NM109BILLPRVDID">
<Type>%String</Type>
<SqlColumnNumber>5</SqlColumnNumber>
<SqlFieldName>NM109BILL_PRVD_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="NM109BILL_PRVD_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="NM109SBSRID">
<Type>%String</Type>
<SqlColumnNumber>6</SqlColumnNumber>
<SqlFieldName>NM109SBSR_ID</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="NM109SBSR_ID"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="80"/>
</Property>

<Property name="ST02TXNCTLNBR">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>4</SqlColumnNumber>
<SqlFieldName>ST02TXN_CTL_NBR</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="ST02TXN_CTL_NBR"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="9"/>
</Property>

<Index name="MainIndex">
<IdKey>1</IdKey>
<PrimaryKey>1</PrimaryKey>
<Properties>HRCHLLEVELKEY</Properties>
</Index>

<Parameter name="ColumnList">
<Default>HRCHL_LEVEL_KEY, FILE_NUMBER, ST02TXN_CTL_NBR, NM109BILL_PRVD_ID, NM109SBSR_ID, LOOP_ID, HL01HRCHL_ID, HL02HRCHL_PRNT_ID, HL03HRCHL_LVL_CD, HL04HRCHL_CHILD_CD, CREATED_BY, DATE_CREATED, MODIFIED_BY, DATE_MODIFIED</Default>
</Parameter>

<Storage name="Default">
<Type>%Library.CacheStorage</Type>
<DataLocation>^CREPOS.HRCHLLEVELD</DataLocation>
<DefaultData>HRCHLLEVELDefaultData</DefaultData>
<IdLocation>^CREPOS.HRCHLLEVELD</IdLocation>
<IndexLocation>^CREPOS.HRCHLLEVELI</IndexLocation>
<StreamLocation>^CREPOS.HRCHLLEVELS</StreamLocation>
<Data name="HRCHLLEVELDefaultData">
<Value name="1">
<Value>%%CLASSNAME</Value>
</Value>
<Value name="2">
<Value>CREATEDBY</Value>
</Value>
<Value name="3">
<Value>DATECREATED</Value>
</Value>
<Value name="4">
<Value>DATEMODIFIED</Value>
</Value>
<Value name="5">
<Value>FILENUMBER</Value>
</Value>
<Value name="6">
<Value>HL01HRCHLID</Value>
</Value>
<Value name="7">
<Value>HL02HRCHLPRNTID</Value>
</Value>
<Value name="8">
<Value>HL03HRCHLLVLCD</Value>
</Value>
<Value name="9">
<Value>HL04HRCHLCHILDCD</Value>
</Value>
<Value name="10">
<Value>LOOPID</Value>
</Value>
<Value name="11">
<Value>MODIFIEDBY</Value>
</Value>
<Value name="12">
<Value>NM109BILLPRVDID</Value>
</Value>
<Value name="13">
<Value>NM109SBSRID</Value>
</Value>
<Value name="14">
<Value>ST02TXNCTLNBR</Value>
</Value>
</Data>
</Storage>
</Class>
</Export>