SAPDocumentPriceTable 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 SAPDocumentPriceTable table

Database Column

Details

SAPDocumentPriceTableID

Type: integer. Key. Generated ID

The unique identifier for the SAP document price table.

SAPDocumentTypeID

Type: integer. Key

Foreign key to the SAP document type.

Multiplier

Type: decimal. Nullable

Override for multiplier(optional) value for the document type as defined by SAP Digital Access licensing rules.

UnitPrice

Type: currency

Unit price of an SAP document type.

UnitPriceRateID

Type: integer

The unit price rate of an SAP document type.

UpdatedUser

Type: text (max 256 characters)

The last user who update the SAP document price.

UpdatedDate

Type: datetime

The date and time the SAP document price was last updated.