changes.mady.by.user Michael T. Black
Saved on Mar 17, 2011
Table
Columns
CSpace destination
Cleaned?
Migrated?
Mapping
Notes
ObjAccession
AccessionISODate
AccessionMethodID
AccessionValue
AcqJustification
AcquisitionLot
AcquisitionNumber
AcquisitionTerms
AuthDate
Authorizer
Budget
CurrencyAmount
CurrencyID
CurrencyRate
EnteredDate
--?--
------------
no
Only if useful for versioning context.
Initiator
LocalAmount
LoginID
use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info
Only if useful for attribution content.
Source
SysTimeStamp
ValuationNotes
ObjDeaccession
ApprovalDate1
ApprovalDate2
DispositionMethod
EstimateHigh
EstimateLow
LotNumber
NetSaleAmount
OldDepartmentID
RecipientConID
Remarks
SaleNumber
Terms
ObjIncoming
CratingActual
CratingEstimate
InInsurActual
InInsurEstimate
InInsurValue
InPurposeID
ShippingActual
ShippingEstimate
ShippingMethodID
WHERE TextTypeID=31
Ledger Redline Data
WHERE TextTypeID=55
Verbatim Ledger
WHERE TextTypeID=56
Accession Envelope
WHERE TextTypeID=63
Deaccession Comments