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.CNTCINFO">
<Description>
Generated by the Link Table wizard on 2018-10-18 12:38:22. 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>CNTC_INFO</SqlTableName>
<Super>%Library.Persistent,%XML.Adaptor,CREPOS.DBCONFIG</Super>
<TimeCreated>64939,45501.918999</TimeCreated>
<Property name="CLAIMKEY">
<Type>%String</Type>
<SqlColumnNumber>7</SqlColumnNumber>
<SqlFieldName>CLAIM_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLAIM_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="CLAIMPYMTINFOKEY">
<Type>%String</Type>
<SqlColumnNumber>9</SqlColumnNumber>
<SqlFieldName>CLAIM_PYMT_INFO_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CLAIM_PYMT_INFO_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="CONTACTINFOKEY">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>2</SqlColumnNumber>
<SqlFieldName>CONTACT_INFO_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="CONTACT_INFO_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="CREATEDBY">
<Type>%String</Type>
<SqlColumnNumber>21</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>22</SqlColumnNumber>
<SqlFieldName>DATE_CREATED</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="DATE_CREATED"/>
<Parameter name="EXTERNALSQLTYPE" value="91"/>
</Property>
<Property name="DATEMODIFIED">
<Type>%Date</Type>
<SqlColumnNumber>24</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="HRCHLLEVELKEY">
<Type>%String</Type>
<SqlColumnNumber>26</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>11</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>23</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="PER01CNTCFCTN">
<Type>%String</Type>
<SqlColumnNumber>13</SqlColumnNumber>
<SqlFieldName>PER01CNTC_FCTN</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER01CNTC_FCTN"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>
<Property name="PER02CNTCNM">
<Type>%String</Type>
<SqlColumnNumber>14</SqlColumnNumber>
<SqlFieldName>PER02CNTC_NM</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER02CNTC_NM"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="60"/>
</Property>
<Property name="PER03COMMQUAL1">
<Type>%String</Type>
<SqlColumnNumber>15</SqlColumnNumber>
<SqlFieldName>PER03COMM_QUAL1</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER03COMM_QUAL1"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>
<Property name="PER04COMMNBR1">
<Type>%String</Type>
<SqlColumnNumber>16</SqlColumnNumber>
<SqlFieldName>PER04COMM_NBR1</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER04COMM_NBR1"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="256"/>
</Property>
<Property name="PER05COMMQUAL2">
<Type>%String</Type>
<SqlColumnNumber>17</SqlColumnNumber>
<SqlFieldName>PER05COMM_QUAL2</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER05COMM_QUAL2"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>
<Property name="PER06COMMNBR2">
<Type>%String</Type>
<SqlColumnNumber>18</SqlColumnNumber>
<SqlFieldName>PER06COMM_NBR2</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER06COMM_NBR2"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="256"/>
</Property>
<Property name="PER07COMMQUAL3">
<Type>%String</Type>
<SqlColumnNumber>19</SqlColumnNumber>
<SqlFieldName>PER07COMM_QUAL3</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER07COMM_QUAL3"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="2"/>
</Property>
<Property name="PER08COMMNBR3">
<Type>%String</Type>
<SqlColumnNumber>20</SqlColumnNumber>
<SqlFieldName>PER08COMM_NBR3</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER08COMM_NBR3"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="256"/>
</Property>
<Property name="PER09CNTCINQREF">
<Type>%String</Type>
<SqlColumnNumber>25</SqlColumnNumber>
<SqlFieldName>PER09CNTC_INQ_REF</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PER09CNTC_INQ_REF"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="20"/>
</Property>
<Property name="PRFSNSERVICEKEY">
<Type>%String</Type>
<SqlColumnNumber>8</SqlColumnNumber>
<SqlFieldName>PRFSN_SERVICE_KEY</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="PRFSN_SERVICE_KEY"/>
<Parameter name="EXTERNALSQLTYPE" value="1"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Property name="SEQNBR">
<Type>%Numeric</Type>
<Required>1</Required>
<SqlColumnNumber>12</SqlColumnNumber>
<SqlFieldName>SEQ_NBR</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="SEQ_NBR"/>
<Parameter name="EXTERNALSQLTYPE" value="3"/>
<Parameter name="MAXVAL" value="9223372036854775807"/>
<Parameter name="MINVAL" value="-9223372036854775808"/>
<Parameter name="SCALE" value="0"/>
</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>
<Property name="TXTYPE">
<Type>%String</Type>
<Required>1</Required>
<SqlColumnNumber>10</SqlColumnNumber>
<SqlFieldName>TX_TYPE</SqlFieldName>
<Parameter name="EXTERNALSQLNAME" value="TX_TYPE"/>
<Parameter name="EXTERNALSQLTYPE" value="12"/>
<Parameter name="MAXLEN" value="36"/>
</Property>
<Index name="MainIndex">
<IdKey>1</IdKey>
<PrimaryKey>1</PrimaryKey>
<Properties>CONTACTINFOKEY</Properties>
</Index>
<Storage name="Default">
<Type>%Library.CacheStorage</Type>
<DataLocation>^CREPOS.CNTCINFOD</DataLocation>
<DefaultData>CNTCINFODefaultData</DefaultData>
<IdLocation>^CREPOS.CNTCINFOD</IdLocation>
<IndexLocation>^CREPOS.CNTCINFOI</IndexLocation>
<StreamLocation>^CREPOS.CNTCINFOS</StreamLocation>
<Data name="CNTCINFODefaultData">
<Value name="1">
<Value>%%CLASSNAME</Value>
</Value>
<Value name="2">
<Value>CLAIMKEY</Value>
</Value>
<Value name="3">
<Value>CLAIMPYMTINFOKEY</Value>
</Value>
<Value name="4">
<Value>CREATEDBY</Value>
</Value>
<Value name="5">
<Value>DATECREATED</Value>
</Value>
<Value name="6">
<Value>DATEMODIFIED</Value>
</Value>
<Value name="7">
<Value>FILENUMBER</Value>
</Value>
<Value name="8">
<Value>HRCHLLEVELKEY</Value>
</Value>
<Value name="9">
<Value>LOOPID</Value>
</Value>
<Value name="10">
<Value>MODIFIEDBY</Value>
</Value>
<Value name="11">
<Value>NM109BILLPRVDID</Value>
</Value>
<Value name="12">
<Value>NM109SBSRID</Value>
</Value>
<Value name="13">
<Value>PER01CNTCFCTN</Value>
</Value>
<Value name="14">
<Value>PER02CNTCNM</Value>
</Value>
<Value name="15">
<Value>PER03COMMQUAL1</Value>
</Value>
<Value name="16">
<Value>PER04COMMNBR1</Value>
</Value>
<Value name="17">
<Value>PER05COMMQUAL2</Value>
</Value>
<Value name="18">
<Value>PER06COMMNBR2</Value>
</Value>
<Value name="19">
<Value>PER07COMMQUAL3</Value>
</Value>
<Value name="20">
<Value>PER08COMMNBR3</Value>
</Value>
<Value name="21">
<Value>PER09CNTCINQREF</Value>
</Value>
<Value name="22">
<Value>PRFSNSERVICEKEY</Value>
</Value>
<Value name="23">
<Value>SEQNBR</Value>
</Value>
<Value name="24">
<Value>ST02TXNCTLNBR</Value>
</Value>
<Value name="25">
<Value>TXTYPE</Value>
</Value>
</Data>
</Storage>
</Class>
</Export>