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 | --?-- | no | no | 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 | --?-- | ------------ | ------------ | ------------ | Only if useful for versioning context. | |
ValuationNotes | ||||||
ObjDeaccession | ApprovalDate1 | |||||
ApprovalDate2 | ||||||
DispositionMethod | ||||||
EnteredDate | --?-- | ------------ | no | --?-- | Only if useful for versioning context. | |
EstimateHigh | ||||||
EstimateLow | ||||||
LoginID | --?-- | no | no | 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. | |
LotNumber | ||||||
NetSaleAmount | ||||||
OldDepartmentID | ||||||
RecipientConID | ||||||
Remarks | ||||||
SaleNumber | ||||||
SysTimeStamp | --?-- | ------------ | ------------ | ------------ | Only if useful for versioning context. | |
Terms | ||||||
ObjIncoming | CratingActual | |||||
CratingEstimate | ||||||
EnteredDate | --?-- | ------------ | no | --?-- | Only if useful for versioning context. | |
InInsurActual | ||||||
InInsurEstimate | ||||||
InInsurValue | ||||||
InPurposeID | ||||||
LoginID | --?-- | no | no | 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. | |
ShippingActual | ||||||
ShippingEstimate | ||||||
ShippingMethodID | ||||||
SysTimeStamp | --?-- | ------------ | ------------ | ------------ | Only if useful for versioning context. | |
WHERE TextTypeID=31 | Ledger Redline Data | |||||
WHERE TextTypeID=55 | Verbatim Ledger | |||||
WHERE TextTypeID=56 | Accession Envelope | |||||
WHERE TextTypeID=63 | Deaccession Comments |
Manage space
Manage content
Integrations