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 |
