borrowreturnmaterial

Table info.

Title Borrow Return Material
Description Borrow Return Material

Fields

Name Type Required Index Hidden On form Title Pick list Description
BorrowReturnMaterialID 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
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Quantity smallint(6) Quantity Number of preparations returned
Remarks text Remarks Comments about the return of the loan
ReturnedDate date MUL Returned date The date the material was returned
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
BorrowMaterialID int(11) MUL
ReturnedByID int(11) MUL

Indexes

Name Fields Unique Nullable
BorrowReturnedColMemIDX CollectionMemberID
BorrowReturnedDateIDX ReturnedDate
FKA8170B8C5327F942 ModifiedByAgentID
FKA8170B8C7699B003 CreatedByAgentID
FKA8170B8C83F392D6 BorrowMaterialID
FKA8170B8CC6A93143 ReturnedByID
PRIMARY BorrowReturnMaterialID

Many-to-one relationships

Name Field Related table Related field
FKA8170B8C5327F942 ModifiedByAgentID agent AgentID
FKA8170B8C7699B003 CreatedByAgentID agent AgentID
FKA8170B8C83F392D6 BorrowMaterialID borrowmaterial BorrowMaterialID
FKA8170B8CC6A93143 ReturnedByID agent AgentID

View: BorrowReturnMaterial (Common)

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

View def.: BorrowReturnMaterial

<viewdef type="form"
      name="BorrowReturnMaterial"
      class="edu.ku.brc.specify.datamodel.BorrowReturnMaterial"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[LoanReturnPreparation viewing form.]]></desc>
    <columnDef>102px,2px,100px,5px,90px,2px,50px,0px:g,p:g</columnDef>
    <columnDef os="lnx">120px,2px,120px,5px,110px,2px,80px,0px:g,p:g</columnDef>
    <columnDef os="mac">130px,2px,120px,5px,110px,2px,80px,0px:g,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px,p,2px,p:g(2),0px</columnDef>
    <rowDef auto="true" cell="p" sep="1dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="returnedDate" uitype="formattedtext" uifieldformatter="Date" default="today"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="quantity" uitype="spinner" initialize="max=5000"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="remarks" uitype="textareabrief" colspan="6" rows="2"/>
        </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>