exchangeout

Table info.

Title Exchange Out
Description Exchange Out

Fields

Name Type Required Index Hidden On form Title Pick list Description
ExchangeOutID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created.
TimestampModified datetime Last edited The timestamp the record was last modified.
Version int(11) Version version
DescriptionOfMaterial varchar(120) MUL Description Description of the material being sent as exchange
ExchangeDate date MUL Exchange date The date exchange material is ready to be sent
Number1 float(20,10) Number1 User definable.
Number2 float(20,10) Number2 User definable.
QuantityExchanged smallint(6) Quantity exchanged The number of specimens in the exchange shipment
Remarks text Remarks Remarks about the exchange transaction
SrcGeography varchar(32) Source Geography srcGeography
SrcTaxonomy varchar(32) Source Taxonomy srcTaxonomy
Text1 text Text1 User definable.
Text2 text Text2 User definable.
YesNo1 bit(1) Yes No1 User definable.
YesNo2 bit(1) Yes No2 User definable.
SentToOrganizationID int(11) MUL
AddressOfRecordID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
DivisionID int(11) MUL
CatalogedByID int(11) MUL
Contents text Contents contents
ExchangeOutNumber varchar(50) Exchange Out # exchangeOutNumber

Indexes

Name Fields Unique Nullable
DescriptionOfMaterialIDX2 DescriptionOfMaterial
ExchangeOutdateIDX ExchangeDate
FK97654A4B3824C16C CatalogedByID
FK97654A4B5327F942 ModifiedByAgentID
FK97654A4B7699B003 CreatedByAgentID
FK97654A4B97C961D8 DivisionID
FK97654A4BA21647A3 SentToOrganizationID
FK97654A4BDC8B4810 AddressOfRecordID
PRIMARY ExchangeOutID

One-to-many relationships

Name Field Related table Related field
FK7405CEF8A542314E ExchangeOutID exchangeoutprep ExchangeOutID
FKE139719AA542314E ExchangeOutID shipment ExchangeOutID

Many-to-one relationships

Name Field Related table Related field
FK97654A4B3824C16C CatalogedByID agent AgentID
FK97654A4B5327F942 ModifiedByAgentID agent AgentID
FK97654A4B7699B003 CreatedByAgentID agent AgentID
FK97654A4B97C961D8 DivisionID division UserGroupScopeId
FK97654A4BA21647A3 SentToOrganizationID agent AgentID
FK97654A4BDC8B4810 AddressOfRecordID addressofrecord AddressOfRecordID

View: ExchangeOut (Common)

<view name="ExchangeOut"
      class="edu.ku.brc.specify.datamodel.ExchangeOut">
    <desc><![CDATA[Exchange Out display form]]></desc>
    <altviews>
        <altview name="ExchangeOut View" viewdef="ExchangeOut" mode="view" default="true"/>
        <altview name="ExchangeOut Edit" viewdef="ExchangeOut" mode="edit"/>
    </altviews>
</view>

View def.: ExchangeOut

<viewdef type="form"
      name="ExchangeOut"
      class="edu.ku.brc.specify.datamodel.ExchangeOut"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[ExchangeOut viewing form.]]></desc>
 
    <columnDef>105px,2px,120px,5px,105px,2px,195px,5px,96px,2px,195px,0px,15px,p,p:g</columnDef>
    <columnDef os="lnx">115px,2px,135px,5px,130px,2px,210px,5px,101px,2px,210px,0px,15px,p,p:g</columnDef>
    <columnDef os="mac">130px,2px,170px,5px,150px,2px,220px,5px,126px,2px,220px,0px,15px,p,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="1dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="exchangeDate" uitype="formattedtext" uifieldformatter="Date" default="Today"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="agentCatalogedBy" uitype="querycbx" initialize="name=Agent"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="agentSentTo" uitype="querycbx" initialize="name=Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="descriptionOfMaterial" uitype="text" colspan="5"/>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="quantityExchanged" uitype="text"/>
        </row>                
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="remarks" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
            <cell type="subview" id="6" name="addressOfRecord" viewname="AddressOfRecord" colspan="13"/>
        </row>
        <row>
            <cell type="subview" id="8" name="shipments" viewname="Shipment" colspan="13"/>
        </row>
        <!-- <row>
             <cell type="subview" viewname="ExchangeOutPrep" id="10" name="exchangeOutPreps" defaulttype="table" colspan="13" rows="4"/>
        </row>
        <row>
            <cell type="label" labelfor="dom"/>
            <cell type="field" id="dom" name="descriptionOfMaterial" uitype="text" colspan="10"/>
        </row>
        <row>
			              <cell type="label" labelfor="18"/>
			              <cell type="field" id="18" name="srcGeography" uitype="text"/>
			              <cell type="label" labelfor="19"/>
			              <cell type="field" id="19" name="srcTaxonomy" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="n1"/>
            <cell type="field" id="n1" name="number1" uitype="text"/>
            <cell type="label" labelfor="n2"/>
            <cell type="field" id="n2" name="number2" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t1"/>
            <cell type="field" id="t1" name="text1" uitype="text"/>
            <cell type="label" labelfor="t2"/>
            <cell type="field" id="t2" name="text2" uitype="text"/>
        </row>
        <row>
            <cell type="field" id="20" name="yesNo1" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="20" name="yesNo2" uitype="checkbox" initialize="editable=true"/>
        </row>
        <row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true" uifieldformatter="Agent"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true" uifieldformatter="Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>-->
    </rows>
</viewdef>