Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name (UI)

Procedure

Field Name (Schema)

Table Name

Identification Number

 Cataloging

 

 

Other Number (all repeated fields separated by “;”)

 Cataloging

 

 

Controlled Object Name(primary radio dial selected)

Cataloging

 

 

Record Status

Cataloging

 

 

Comment (primary radio dial selected)

Cataloging

 

 

 

Report:  Loan In ReportList with Image

Run from: Cataloging; Loan In; Valuation;

Parameters: All objects related to an incoming loanloanLoan

Output: DOC

Example: Loan In Report.pdf

...

Field Name (UI)

Procedure

Note

Loan In Number

Loan In

Header

Lender

Loan In

Header

Lender's contact

Loan in

Header

Lender's address line 1

Person/Organization authority

Header

Lender's address line 2

Person/Organization authority

Header

Lenders's municipality

Person/Organization authority

Header

Lender's state/province

Person/Organization authority

Header

Lender's postal code

Person/Organization authority

Header

Lender's telephone number

Person/Organization authority

Header

Lender’s email

Person/Organization authority

Header

Loan Status (primary radio dial selected)

Loan In

Header

Loan In Date

Loan In

Header

Loan Return Date

Loan In

Header

Loan Status Date

Loan In

Header

Loan Purpose

Loan In

Header

Identification Number

Cataloging

 

Other Number (all repeated fields)

Cataloging

 

Controlled Object Name

Cataloging

 

Other Name

Cataloging

 

Valuation Amount (

Valuation)

Valuation

 Value from related Valuation report with most recent Valuation date

 

Report:  Loan Out ReportList with Image

Run from: Cataloging; Loan Out; Valuation;

Parameters: All objects related to an outgoing loan

...

 

         

Field Name (UI)

Procedure

Field Name (Schema)

Table Name

Note

Loan Out Number

Loan Out

 

Header

Borrower

Loan Out 

Header

 

Borrower's contact

Loan Out

 

Header

Borrower's address line 1

Person/Organization authority

 

Header

Borrower's address line 2

Person/Organization authority 

Header

 

Borrower's municipality

Person/Organization authority

 

Header

Borrower's state/province

Person/Organization authority

 

Header

Borrower's postal code

Person/Organization authority 

Header

 

Borrower's telephone number

Person/Organization authority

 

Header

Loan Status (primary radio dial selected)

Loan Out 

Header

 

Loan Out Date

Loan Out 

Header

 

Loan Return Date

Loan Out

 

Header

Loan Status Date

Loan Out

 

Header

Loan Purpose

Loan Out

 

Header

Identification Number

Cataloging

 

 

Other Number

Cataloging 

 

Controlled Object Name

Cataloging 

 

Other Name

Cataloging

 

 Valuation amount

Amount (Valuation)

Valuation

 

 

 

Report: Checklist

 Run from: Acquisition; Exhibition; Group; Loan In; Loan Out

Parameters: All objects related to Acquisition (etc.) record

Output: DOC

Example: Check List Report.pdf

Fields:

 

Field Name (UI)

Procedure

Field Name (Schema)

Table Name

Identification number

Cataloging

 

 

Controlled Object Name (primary radio dial selected)

Cataloging

 

 

Dimensions summary

Cataloging

 

 

Image - related media record with checkbox "Is Primary"

Media Handling

 

 

 

Report: Current Location

Run from: Storage location authority term record

Parameters: All objects for which storage location is the computed current location

Output: DOC

Example: Current Location Report.pdf

Fields:

 

Media Handling

Field Name (UI)

Procedure

Field Name (Schema)

Table Name

Identification number

Cataloging

 

 

Other Number (all repeated fields)

Cataloging

 

 

Controlled Name (primary radio dial selected

Cataloging

 

 

Image - related media record with checkbox "Is Primary"

amount from related Valuation record with most recent Valuation date