Original System References
The source system reference view object contains the mapping between source system references and the owner tables. The source system reference is an identifier for the record that the data came from the source system and the owner table is the TCA table, which stores that data. A record with an Active status means the cross-reference mapping between TCA and source system is valid. An Inactive status means the cross-referencing mapping is no longer valid.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.OriginalSystemReferenceExtractPVO
Primary Keys : OrigSystemRefId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| Attribute1 | A segment for the Original System Reference descriptive flexfield. |
| Attribute10 | A segment for the Original System Reference descriptive flexfield. |
| Attribute11 | A segment for the Original System Reference descriptive flexfield. |
| Attribute12 | A segment for the Original System Reference descriptive flexfield. |
| Attribute13 | A segment for the Original System Reference descriptive flexfield. |
| Attribute14 | A segment for the Original System Reference descriptive flexfield. |
| Attribute15 | A segment for the Original System Reference descriptive flexfield. |
| Attribute16 | A segment for the Original System Reference descriptive flexfield. |
| Attribute17 | A segment for the Original System Reference descriptive flexfield. |
| Attribute18 | A segment for the Original System Reference descriptive flexfield. |
| Attribute19 | A segment for the Original System Reference descriptive flexfield. |
| Attribute2 | A segment for the Original System Reference descriptive flexfield. |
| Attribute20 | A segment for the Original System Reference descriptive flexfield. |
| Attribute21 | A segment for the Original System Reference descriptive flexfield. |
| Attribute22 | A segment for the Original System Reference descriptive flexfield. |
| Attribute23 | A segment for the Original System Reference descriptive flexfield. |
| Attribute24 | A segment for the Original System Reference descriptive flexfield. |
| Attribute25 | A segment for the Original System Reference descriptive flexfield. |
| Attribute26 | A segment for the Original System Reference descriptive flexfield. |
| Attribute27 | A segment for the Original System Reference descriptive flexfield. |
| Attribute28 | A segment for the Original System Reference descriptive flexfield. |
| Attribute29 | A segment for the Original System Reference descriptive flexfield. |
| Attribute3 | A segment for the Original System Reference descriptive flexfield. |
| Attribute30 | A segment for the Original System Reference descriptive flexfield. |
| Attribute4 | A segment for the Original System Reference descriptive flexfield. |
| Attribute5 | A segment for the Original System Reference descriptive flexfield. |
| Attribute6 | A segment for the Original System Reference descriptive flexfield. |
| Attribute7 | A segment for the Original System Reference descriptive flexfield. |
| Attribute8 | A segment for the Original System Reference descriptive flexfield. |
| Attribute9 | A segment for the Original System Reference descriptive flexfield. |
| AttributeCategory | The context name for the Original System Reference descriptive flexfield. |
| AttributeDate1 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate10 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate11 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate12 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate2 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate3 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate4 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate5 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate6 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate7 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate8 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeDate9 | A date segment for the Original System Reference descriptive flexfield. |
| AttributeNumber1 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber10 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber11 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber12 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber2 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber3 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber4 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber5 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber6 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber7 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber8 | A number segment for the Original System Reference descriptive flexfield. |
| AttributeNumber9 | A number segment for the Original System Reference descriptive flexfield. |
| CreatedBy | A number segment for the Original System Reference descriptive flexfield. |
| CreatedByModule | The user who created the record. |
| CreationDate | The module through which the record was created. |
| EndDateActive | The date after which the record becomes inactive. |
| LastUpdateDate | The date and time of last update of the record. |
| LastUpdateLogin | The login of the user who last updated the record. |
| LastUpdatedBy | The user who last updated the record. |
| OldOrigSystemReference | The old source system reference that's being replaced. |
| OrigSystem | The source system name. |
| OrigSystemRefId | The sequentially generated identifier. |
| OrigSystemReference | The identifier for the record from the original system. |
| OwnerTableId | The unique identifier for a record in the owner table. |
| OwnerTableName | The Trading Community Architecture tables that have source system reference column. |
| PartyId | Party identifier of the record. |
| ReasonCode | The reason for setting the record to Inactive. |
| StartDateActive | The date on which the record becomes active. |
| Status | The status of the record. The default is A for Active. |
| UserLastUpdateDate | The date and time when the Original System Reference row was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database such as a different mobile database or the server. |