ActivityExtractPVO
The Sustainability Activities view object contains information about the activities that have sustainability impact. A sustainability activity record includes key parameters such as an associated legal entity, a time frame, a location, and the size of the impact.
Data Store Key : FscmTopModelAM.PrcExtractAM.SusBiccExtractAM.ActivityExtractPVO
Primary Keys : ActivityId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActivityDate | Date of the activity record. |
| ActivityId | Value that uniquely identifies the activity record. This is a primary key of the Sustainability Activities view object. |
| ActivityNumber | Value that uniquely identifies the activity number. |
| ActivityTypeCode | Code that uniquely identifies the activity type. |
| Attribute1 | Segment for the Activity descriptive flexfield. |
| Attribute10 | Segment for the Activity descriptive flexfield. |
| Attribute11 | Segment for the Activity descriptive flexfield. |
| Attribute12 | Segment for the Activity descriptive flexfield. |
| Attribute13 | Segment for the Activity descriptive flexfield. |
| Attribute14 | Segment for the Activity descriptive flexfield. |
| Attribute15 | Segment for the Activity descriptive flexfield. |
| Attribute16 | Segment for the Activity descriptive flexfield. |
| Attribute17 | Segment for the Activity descriptive flexfield. |
| Attribute18 | Segment for the Activity descriptive flexfield. |
| Attribute19 | Segment for the Activity descriptive flexfield. |
| Attribute2 | Segment for the Activity descriptive flexfield. |
| Attribute20 | Segment for the Activity descriptive flexfield. |
| Attribute3 | Segment for the Activity descriptive flexfield. |
| Attribute4 | Segment for the Activity descriptive flexfield. |
| Attribute5 | Segment for the Activity descriptive flexfield. |
| Attribute6 | Segment for the Activity descriptive flexfield. |
| Attribute7 | Segment for the Activity descriptive flexfield. |
| Attribute8 | Segment for the Activity descriptive flexfield. |
| Attribute9 | Segment for the Activity descriptive flexfield. |
| AttributeCategory | Context name for the Activity descriptive flexfield. |
| AttributeDate1 | Date segment for the Activity descriptive flexfield. |
| AttributeDate2 | Date segment for the Activity descriptive flexfield. |
| AttributeDate3 | Date segment for the Activity descriptive flexfield. |
| AttributeDate4 | Date segment for the Activity descriptive flexfield. |
| AttributeDate5 | Date segment for the Activity descriptive flexfield. |
| AttributeNumber1 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber10 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber2 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber3 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber4 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber5 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber6 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber7 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber8 | Number segment for the Activity descriptive flexfield. |
| AttributeNumber9 | Number segment for the Activity descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Activity descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Activity descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Activity descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Activity descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Activity descriptive flexfield. |
| CalculationOverrideCode | Code that uniquely identifies the calculation mode. |
| Comments | Descriptive comments for the document. |
| ConsumptionEndDate | Date when the consumption related to the activity will end. |
| ConsumptionStartDate | Date when the consumption related to the activity started. |
| CountryCode | Code used to uniquely identify a country. |
| CreatedBy | User who created the activity record. |
| CreationDate | Date and time when the activity record was created. |
| DataQualityCode | Code used to uniquely identify a data quality. |
| Description | Description of the activity record. |
| EfmAttribute1 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute10 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute11 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute12 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute13 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute14 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute15 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute16 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute17 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute18 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute19 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute2 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute20 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute3 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute4 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute5 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute6 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute7 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute8 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttribute9 | Segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeDate1 | Date segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeDate2 | Date segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeDate3 | Date segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeDate4 | Date segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeDate5 | Date segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber1 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber10 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber2 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber3 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber4 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber5 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber6 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber7 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber8 | Number segment for the Emission Factor Map descriptive flexfield. |
| EfmAttributeNumber9 | Number segment for the Emission Factor Map descriptive flexfield. |
| EntryTypeCode | Code that helps uniquely identify the type of entry. |
| EsgLedgerId | Value that uniquely identifies the sustainability ledger. |
| ExternalReferenceNumber | Reference to a record in another application. |
| InventoryItemId | Value that uniquely identifies the item on the activity. |
| InvoiceDistributionId | Value that uniquely identifies the invoice distribution on the activity. |
| InvoiceId | Value that uniquely identifies the invoice on the activity. |
| InvoiceLineNumber | Value that uniquely identifies the invoice line number on the activity. |
| LastUpdateDate | Date and time when the activity record was most recently updated. |
| LastUpdateLogin | Session login associated with the user who most recently updated the activity record. |
| LastUpdatedBy | User who most recently updated the activity row. |
| LegalEntityId | Value that uniquely identifies the legal entity. |
| ObjectVersionNumber | Indicates the version of the activity row. |
| OriginalActivityId | Value that uniquely identifies the original activity record. |
| PeriodId | Value that uniquely identifies the period. |
| PostingDate | Date and time when the activity was posted. |
| ScopeCategory | Category under which Scope 3 emissions are reported. Purchased goods and services, and waste generated in operations are examples of such categories. |
| ScopeCategoryCode | Code that identifies a Scope 3 category. |
| ScopeCode | Code that identifies a scope. |
| SourceTypeCode | Code of the source type that helps to uniquely identify the source type. |
| StatusCode | Code that helps to uniquely identify a status. |
| SupplierId | Value that uniquely identifies the supplier. |
| TotalCo2e | Total calculated CO2e for the activity record. |
| TotalCo2eUom | Unit of measure for the total CO2e. |