SAPDigitalAccess Table

This table stores digital access data imported from SAP reader.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SAPDigitalAccess table

Database Column

Details

SAPDigitalAccessID

Type: integer. Key. Generated ID

The unique identifier for the SAP digital access.

SAPSystemID

Type: integer. Key

Foreign key to the SAP system that the digital access belongs to.

SAPDocumentTypeID

Type: integer. Key

Foreign key to the SAP document type that is created by this digital access data.

Unit

Type: integer. Key

A UnitID for this digital access data.

Count

Type: integer

Document creation count for this digital access data.

StartDate

Type: datetime. Key

The start date configured in the SAP tools. The count information for this digital access data is valid from this start date period.

EndDate

Type: datetime. Key

The end date configured in the SAP tools. The count information for this digital access data is valid up to this end date period.

LastImportDate

Type: datetime

The date when the import from the SAPSystem last occured.