TMS to CSpace Acquisition crosswalk
| 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 |