RSProduct

RSProduct reportable is a result set built directly from the CCProductDTO.

RSProduct is referenced in the vSample and vSampleSchemeAnalyte views using the P_* alias for a sample's product and its primary specification.

RSProduct properties are as follows:

RS Column

DTO Property

Property Type

ApprovedDate

approvedDate

Time Stamp

ApprovedUser

approvedUser

String

ChemicalName

chemicalName

String

Code

code

String

Description

description

String

DisposalSampleHandlingCode

disposalSampleHandlingCode

String

DisposalSampleHandlingId

disposalSampleHandlingId

String

Document

document

Blob

Image

image

Blob

IsAutoValidate

isAutoValidate

Boolean

IsOrganisationScope

isOrganisationScope

Boolean

LaboratoryCode

laboratoryCode

String

LaboratoryId

laboratoryId

String

LineOfBusinessCode

lineOfBusinessCode

String

LineOfBusinessId

lineOfBusinessId

String

Manufacturer

manufacturer

String

Name

name

String

OrganisationCode

organisationCode

String

OrganisationId

organisationId

String

PrimarySpecCode

primarySpecCode

String

PrimarySpecId

primarySpecId

String

ProductCategoryCode

productCategoryCode

String

ProductCategoryId

productCategoryId

String

ProductDocExt

productDocExt

String

ProductId

id

String

ProductImageExt

productImageExt

String

ProductScriptCode

productScriptCode

String

ProductScriptId

productScriptId

String

ProductText

productText

String

ProductTextId

productTextId

String

ReportDescription

reportDescription

String

ReportName

reportName

String

SampleTypeCode

sampleTypeCode

String

SampleTypeId

sampleTypeId

String

Status

status

String

StatusChangeReason

statusChangeReason

String

StatusChangedByUserCode

statusChangedByUserCode

String

StatusChangedByUserId

statusChangedByUserId

String

StatusChangedDate

statusChangedDate

Time Stamp