vSample

vSample is a view comprised of sample and related data, from the CCProduct (P_*), CCQCType (Q_*), CCSample (S_*) objects.

vSample properties are as follows:

View Column

Property Type

P_ApprovedDate

dateTime

P_ApprovedUser

string

P_ChemicalName

string

P_Code

string

P_Description

string

P_DisposalSampleHandlingCode

string

P_DisposalSampleHandlingId

string

P_Document

base64Binary

P_Id

string

P_Image

base64Binary

P_IsAutoValidate

boolean

P_IsOrganisationScope

boolean

P_LaboratoryCode

string

P_LaboratoryId

string

P_LineOfBusinessCode

string

P_LineOfBusinessId

string

P_Manufacturer

string

P_Name

string

P_OrganisationCode

string

P_OrganisationId

string

P_PrimarySpecCode

string

P_PrimarySpecId

string

P_ProductCategoryCode

string

P_ProductCategoryId

string

P_ProductDocExt

string

P_ProductImageExt

string

P_ProductScriptCode

string

P_ProductScriptId

string

P_ProductText

string

P_ProductTextId

string

P_ReportDescription

string

P_ReportName

string

P_SampleTypeCode

string

P_SampleTypeId

string

P_Status

string

P_StatusChangeReason

string

P_StatusChangedByUserCode

string

P_StatusChangedByUserId

string

P_StatusChangedDate

dateTime

Q_AnalyticalType

string

Q_Code

string

Q_Description

string

Q_Id

string

Q_IsActive

boolean

Q_IsCanLinkToUnk

boolean

Q_IsOrganisationScope

boolean

Q_LaboratoryId

string

Q_LinkedQcTypeCode

string

Q_LinkedQcTypeId

string

Q_Name

string

Q_OrganisationId

string

Q_QcTypeCategoryCode

string

Q_QcTypeCategoryId

string

Q_SecondaryAnalyticalType

string

Q_UserStatusScriptCode

string

Q_UserStatusScriptId

string

S_ActivatedNow

boolean

S_ActivatedUserCode

string

S_ActivatedUserId

string

S_AgreedDate

dateTIme

S_AnalysedDate

dateTime

S_AnalysisText

string

S_AnalysisTextId

string

S_ApplicationId

string

S_ApprovedDate

dateTime

S_ApprovedUser

string

S_ArchivedUserCode

string

S_ArchivedUserId

string

S_AuthUserGroupCode

string

S_AuthUserGroupId

string

S_AuthorisationUserCode

string

S_AuthorisationUserId

string

S_AuthorisedDate

dateTIme

S_ClientCode

string

S_ClientContactCode

string

S_ClientContactId

string

S_ClientContactName

string

S_ClientGroupCode

string

S_ClientGroupId

string

S_ClientGroupName

string

S_ClientId

string

S_ClientName

string

S_ClientProjectCode

string

S_ClientProjectId

string

S_ClientProjectName

string

S_ClientSampleName

string

S_ClientSampleNameSyntax

string

S_ClientSubmissionNumber

string

S_CompletedByUserCode

string

S_CompletedByUserId

string

S_CompletedDate

dateTime

S_CompositeQcStatus

string

S_CompositeSpecStatus

string

S_ContactName

string

S_Contract

string

S_ContractSubmissionNumber

string

S_CostCentreCode

string

S_CostCentreId

string

S_DeliveredBy

string

S_DependentRelatedSamples

double

S_Description

string

S_DescriptionSyntax

string

S_DestinationJobCode

string

S_DestinationSampleCode

string

S_Discount

double

S_DupOriginalClientSampleName

string

S_DupOriginalSampleCode

string

S_DupOriginalSampleId

string

S_DupOriginalSampleName

string

S_FinalisationUserCode

string

S_FinalisationUserId

string

S_FinalisedDate

dateTime

S_FirstReportedDate

dateTime

S_FixedPrice

double

S_FixedPriceCurrencyId

string

S_IncludeBiofields

string

S_IncludeSpecifications

string

S_IncludeTests

string

S_IsArchived

boolean

S_IsAutoReceive

boolean

S_IsAutoValidate

boolean

S_IsComposite

boolean

S_IsCopyTestsFromTemplate

boolean

S_IsFixedPrice

boolean

S_IsFromAddTestsFromSamples

boolean

S_IsGenerateLabel

boolean

S_IsGeneratePaperwork

boolean

S_IsIncludeInCosts

boolean

S_IsIncludedInJobQc

boolean

S_IsInvoiceable

boolean

S_IsOrganisationScope

boolean

S_IsReportable

boolean

S_IsRequireAuthorisation

boolean

S_IsStartFromNewRack

boolean

S_IsTemplate

boolean

S_JobCode

string
S_JobClientCode string
S_JobClientContactCode string
S_JobClientContactName string
S_JobClientName string
  • S_JobClientProjectCode
    		•  string
    S_JobClientProjectName string

    S_JobDescription

    string

    S_JobId

    string

    S_JobName

    string

    S_JobTemplateCode

    string

    S_JobType

    string

    S_LaboratoryCode

    string

    S_LaboratoryId

    string

    S_LastActivatedDate

    dateTime

    S_LastArchivedDate

    dateTime

    S_LastInvoiceNo

    string

    S_LastInvoicedDate

    dateTime

    S_LastInvoicedUserCode

    string

    S_LastReportId

    string

    S_LastReportedDate

    dateTime

    S_LoggingApplicationName

    string

    S_NumberOfContainers

    double

    S_NumberOfHours

    double

    S_NumberOfSchemes

    double

    S_NumberOfSchemesCompleted

    double

    S_NumberOfSchemesStarted

    double

    S_OrderCode

    string

    S_OrderId

    string

    S_OrganisationCode

    string

    S_OrganisationId

    string

    S_OriginalJobCode

    string

    S_OriginalSampleCode

    string

    S_OwnerChangedDate

    dateTIme

    S_OwnerUserCode

    string

    S_OwnerUserId

    string

    S_ParentClientSampleName

    string

    S_ParentSampleId

    string

    S_ParentSampleName

    string

    S_PortionLastSeqNumber

    double

    S_PossibleDate

    dateTime

    S_PriceBookCode

    string

    S_PriceBookId

    string

    S_PrimaryAnalyticalType

    string

    S_PrimaryProductSpecCode

    string

    S_PrimaryProductSpecId

    string

    S_Priority

    string

    S_ProductCode

    string

    S_ProductId

    string

    S_ProductSpecResultText

    string

    S_ProductSpecResultTextId

    string

    S_QcMaskCode

    string

    S_QcMaskId

    string

    S_QcTypeCode

    string

    S_QcTypeId

    string

    S_QuoteCode

    string

    S_QuoteId

    string

    S_ReceivedDate

    dateTime

    S_ReceptionUserCode

    string

    S_ReceptionUserId

    string

    S_RegisteredDate

    dateTime

    S_RegistrationSequence

    double

    S_RegistrationText

    string

    S_RegistrationTextId

    string

    S_RegistrationUserCode

    string

    S_RegistrationUserId

    string

    S_ReleasedByUserCode

    string

    S_ReleasedByUserId

    string

    S_ReleasedDate

    double

    S_RepReqId

    string

    S_Report

    base64Binary

    S_ReportText

    string

    S_ReportTextId

    string

    S_RequiredDate

    dateTime

    S_SampleCode

    string

    S_SampleCodeSyntaxCode

    string

    S_SampleCodeSyntaxId

    string

    S_SampleDescSyntaxCode

    string

    S_SampleDescSyntaxId

    string

    S_SampleId

    string

    S_SampleName

    string

    S_SampleNameSyntaxCode

    string

    S_SampleNameSyntaxId

    string

    S_SamplePointCode

    string

    S_SamplePointId

    string

    S_SampleRecordType

    string

    S_SampleStatus

    string

    S_SampleSyntax

    string

    S_SampleTemplateCode

    string

    S_SampleTemplateId

    string

    S_SampleTypeCode

    string

    S_SampleTypeId

    string

    S_SampledBy

    string

    S_SampledDate

    dateTime

    S_SamplesOnly

    boolean

    S_SaveAsOptionCopyAllSampleTests

    boolean

    S_SaveAsOptionCopyEntireSampleStructure

    boolean

    S_SaveAsOptionCopySampleHeader

    boolean

    S_SaveAsOptionCopySampleSpecifications

    boolean

    S_SaveAsOptionCopySingleSchemeCode

    string

    S_SaveAsOptionCopySingleSchemeId

    string

    S_SecondaryAnalyticalType

    string

    S_SecondaryQcTypeCode

    string

    S_SecondaryQcTypeId

    string

    S_Source

    string

    S_SourceJobCode

    string

    S_SourceSampleCode

    string

    S_SpikeOriginalSampleCode

    string

    S_SpikeOriginalSampleId

    string

    S_SplitOriginalSampleCode

    string

    S_SplitOriginalSampleId

    string

    S_StandardCode

    string

    S_StandardId

    string

    S_StandardLotCode

    string

    S_StandardLotId

    string

    S_StartedDate

    dateTime

    S_StatusChangeReason

    string

    S_TemplatePriceCode

    string

    S_TemplatePriceCodeLabCode

    string

    S_ValidatedDate

    dateTime

    S_ValidationUserCode

    string

    S_ValidationUserId

    string

    S_WorkflowStatus

    string

    Note: There is no connection to PrimarySpecification properties (apart from Code).