vJob

vJob is a view comprised of job and related data.

Example of A_* and AR_* addresses. Given the following address configuration:

Client Code CLI1

  • Address CLI1_ADDR_DEF

  • Address CLI1_ADDR_OTH

  • Contact CLI1_CNCT1, use client's address

    • Address CLI1_CNCT1_ADDR_DEF

    • Address CLI1_CNCT1_ADDR_OTH

  • Contact CLI1_CNCT2, do not use client's address

    • Address CLI1_CNCT2_ADDR_DEF

    • Address CLI1_CNCT2_ADDR_OTH

Client Code CLI2

  • Address CLI2_ADDR_DEF

  • Address CLI2_ADDR_OTH

  • Contact CLI2_CNCT1, do not use client's address

    • Address CLI2_CNCT1_ADDR_DEF

    • Address CLI2_CNCT1_ADDR_OTH

  • Contact CLI2_CNCT2, use client's address

    • Address CLI2_CNCT2_ADDR_DEF

    • Address CLI2_CNCT2_ADDR_OTH

Then the following results are populated into the A_* and A_* result set.

Case 1: Where job has no contact

Job's Client CLI1 CLI1 CLI1 CLI1 CLI1 CLI1 CLI1
Job's Contact <empty> <empty> <empty> <empty> <empty> <empty> <empty>
RR's Client <empty> CLI1 CLI1 CLI1 CLI2 CLI2 CLI2
RR's Contact <empty> <empty> CLI1_CNCT1 CLI_CNCT2 <empty> CLI1_CNCT1 CLI_CNCT2
A_* CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF
AR_* <empty> CLI1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_ADDR_DEF CLI2_ADDR_DEF CLI2_CNCT1_ADDR_DEF CLI2_ADDR_DEF

Case 2: Where job has the client's default contact

Job's Client CLI1 CLI1 CLI1 CLI1 CLI1 CLI1 CLI1
Job's Contact CLI1_CNCT1 CLI1_CNCT1 CLI1_CNCT1 CLI1_CNCT1 CLI1_CNCT1 CLI1_CNCT1 CLI1_CNCT1
RR's Client <empty> CLI1 CLI1 CLI1 CLI2 CLI2 CLI2
RR's Contact <empty> <empty> CLI1_CNCT1 CLI_CNCT2 <empty> CLI1_CNCT1 CLI_CNCT2
A_* CLI1_CNCT1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_CNCT1_ADDR_DEF
AR_* <empty> CLI1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_ADDR_DEF CLI2_ADDR_DEF CLI2_CNCT1_ADDR_DEF CLI2_ADDR_DEF

Case 3: Where job has the client's non-default contact

Job's Client CLI1 CLI1 CLI1 CLI1 CLI1 CLI1 CLI1
Job's Contact CLI1_CNCT2 CLI1_CNCT2 CLI1_CNCT2 CLI1_CNCT2 CLI1_CNCT2 CLI1_CNCT2 CLI1_CNCT2
RR's Client <empty> CLI1 CLI1 CLI1 CLI2 CLI2 CLI2
RR's Contact <empty> <empty> CLI1_CNCT1 CLI_CNCT2 <empty> CLI1_CNCT1 CLI_CNCT2
A_* CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF CLI1_ADDR_DEF
AR_* <empty> CLI1_ADDR_DEF CLI1_CNCT1_ADDR_DEF CLI1_ADDR_DEF CLI2_ADDR_DEF CLI2_CNCT1_ADDR_DEF CLI2_ADDR_DEF

vJob properties are as follows:

View Column

Property Type

If the job has a contact defined and the contact indicates to Use Client Address, then the RSAddress object associated with the job client's default address is used to populate A_* columns.

If the job has a contact defined and the contact indicates not to Use Client Address, then the RSAddress object associated with the job contact's default address is used to populate A_* columns.

If the job does not have a contact defined, then the RSAddress object associated with the job client's default address is used to populate A_* columns.

A_AddressCategoryCode

String

A_AddressCategoryId

String

A_AddressId

String

A_AddressLine1

String

A_AddressLine2

String

A_AddressLine3

String

A_AddressLine4

String

A_City

String

A_CountryCode

String

A_CountryName

String

A_County

String

A_ErpAddressLine1

String

A_ErpAddressLine2

String

A_ErpAddressLine3

String

A_ErpAddressLine4

String

A_IsActive

Boolean

A_IsDefault

Boolean

A_IsOrganisationScope

Boolean

A_LaboratoryId

String

A_OrganisationId

String

A_OwnerCode

String

A_OwnerId

String

A_OwnerName

String

A_OwnerType

String

A_Postcode

String

A_Province

String

A_State

String

If the report request has a contact defined and the contact indicates to Use Client Address, then the RSAddress object associated with the report request client's default address is used to populate AR_* columns.

If the report request has a contact defined and the contact indicates not to Use Client Address, then the RSAddress object associated with the report request contact's default address is used to populate AR_* columns.

If the report request does not have a contact defined, then the RSAddress object associated with the report request client's default address is used to populate AR*_ columns.

AR_AddressCategoryCode

String

AR_AddressCategoryId

String

AR_AddressId

String

AR_AddressLine1

String

AR_AddressLine2

String

AR_AddressLine3

String

AR_AddressLine4

String

AR_City

String

AR_CountryCode

String

AR_CountryName

String

AR_County

String

AR_ErpAddressLine1

String

AR_ErpAddressLine2

String

AR_ErpAddressLine3

String

AR_ErpAddressLine4

String

AR_IsActive

Boolean

AR_IsDefault

Boolean

AR_IsOrganisationScope

Boolean

AR_LaboratoryId

String

AR_OrganisationId

String

AR_OwnerCode

String

AR_OwnerId

String

AR_OwnerName

String

AR_OwnerType

String

AR_Postcode

String

AR_Province

String

AR_State

String

The CCClient object associated with the job's client is used to populate C_* columns.

C_AccountManagerUserCode

String

C_AccountManagerUserId

String

C_AlternateName

String

C_BusinessHours

String

C_CanSubmitSamples

Boolean

C_ClientCategoryCode

String

C_ClientCategoryId

String

C_ClientDocumentFileName

String

C_ClientLogoFileName

String

C_Code

String

C_CostCentreCode

String

C_CostCentreId

String

C_DefaultCurrency

String

C_Description

String

C_Discount

BigDecimal

C_Document

Blob

C_ERPAccRecCreditAccount

String

C_ERPAccRecDebitAccount

String

C_ERPAffiliatedCostCentre

String

C_ERPChartOfAccounts

String

C_ERPClientName

String

C_ERPClientNumber

String

C_ERPLanguageCode

String

C_ERPSiteName

String

C_ERPSiteNumber

String

C_ERPTranslatedName

String

C_ERPVatNo

String

C_Id

String

C_InvoiceIncompleteJobs

Boolean

C_InvoicePaymentTerms

String

C_InvoiceToClientCode

String

C_InvoiceToClientLabCode

String

C_InvoiceToClientName

String

C_IsActive

Boolean

C_IsAutoInvoice

Boolean

C_IsInvoiceSampleDetails

Boolean

C_IsOrganisationScope

Boolean

C_JobText

String

C_JobTextId

String

C_LabelShortName

String

C_LaboratoryCode

String

C_LaboratoryId

String

C_LastContactedDate

Date

C_LastSubmissionDate

Timestamp

C_LastVisitedDate

Date

C_LegalEntityCode

String

C_LegalEntityName

String

C_LegalEntityNumber

String

C_Locale

String

C_Logo

Blob

C_Name

String

C_NumberOfDaysOfPromptPayment

BigDecimal

C_OrganisationCode

String

C_OrganisationId

String

C_ParentClientCode

String

C_ParentClientId

String

C_PriceCatalogGroup

String

C_PrimaryContactCode

String

C_PrimaryContactId

String

C_PrimaryProjectCode

String

C_Priority

String

C_PromptPaymentDiscount

BigDecimal

C_ReportTemplateLabCode

String

C_ReportTemplateCode

String

C_SourceCode

String

C_SourceIsOrganisationScope

Boolean

C_TargetCode

String

C_TargetIsOrganisationScope

Boolean

The CCClientProject object associated with the job's project is used to populate CP_* columns.

CP_AccountManagerUserCode

String

CP_AccountManagerUserId

String

CP_AlternateName

String

CP_CanSubmitSamples

Boolean

CP_ClientCode

String

CP_ClientId

String

CP_ClientLaboratoryCode

String

CP_ClientOrganisationCode

String

CP_ClientProjectDocExt

String

CP_ClientProjectLogoExt

String

CP_CloseDate

Date

CP_Code

String

CP_CostCentreCode

String

CP_CostCentreId

String

CP_Description

String

CP_Discount

BigDecimal

CP_Document

Blob

CP_ERPAccRecCreditAccount

String

CP_ERPAccRecDeditAccount

String

CP_ERPAffiliatedCostCentre

String

CP_ERPChartOfAccounts

String

CP_ERPProjectName

String

CP_ERPProjectNumber

String

CP_Id

String

CP_InvoiceIncompleteJobs

Boolean

CP_InvoicePaymentTerms

String

CP_IsActive

Boolean

CP_IsAllowRegOutsideDates

Boolean

CP_IsAutoInvoice

Boolean

CP_IsOrganisationScope

Boolean

CP_JobText

String

CP_JobTextId

String

CP_LabelShortName

String

CP_LastSubmissionDate

Timestamp

CP_Logo

Blob

CP_Name

String

CP_NumberOfDaysOfPromptPayment

BigDecimal

CP_OpenDate

Date

CP_PrimaryClientContactCode

String

CP_PrimaryClientContactId

String

CP_Priority

String

CP_ProjectCategoryCode

String

CP_ProjectCategoryId

String

CP_PromptPaymentDiscount

BigDecimal

The CCClient object associated with the report request's client is used to populate CR_* columns.

CR_AccountManagerUserCode

String

CR_AccountManagerUserId

String

CR_AlternateName

String

CR_BusinessHours

String

CR_CanSubmitSamples

Boolean

CR_ClientCategoryCode

String

CR_ClientCategoryId

String

CR_ClientDocumentFileName

String

CR_ClientLogoFileName

String

CR_Code

String

CR_CostCentreCode

String

CR_CostCentreId

String

CR_DefaultCurrency

String

CR_Description

String

CR_Discount

BigDecimal

CR_Document

Blob

CR_ERPAccRecCreditAccount

String

CR_ERPAccRecDebitAccount

String

CR_ERPAffiliatedCostCentre

String

CR_ERPChartOfAccounts

String

CR_ERPClientName

String

CR_ERPClientNumber

String

CR_ERPLanguageCode

String

CR_ERPSiteName

String

CR_ERPSiteNumber

String

CR_ERPTranslatedName

String

CR_ERPVatNo

String

CR_Id

String

CR_InvoiceIncompleteJobs

Boolean

CR_InvoicePaymentTerms

String

CR_InvoiceToClientCode

String

CR_InvoiceToClientLabCode

String

CR_InvoiceToClientName

String

CR_IsActive

Boolean

CR_IsAutoInvoice

Boolean

CR_IsInvoiceSampleDetails

Boolean

CR_IsOrganisationScope

Boolean

CR_JobText

String

CR_JobTextId

String

CR_LabelShortName

String

CR_LaboratoryCode

String

CR_LaboratoryId

String

CR_LastContactedDate

Date

CR_LastSubmissionDate

Timestamp

CR_LastVisitedDate

Date

CR_LegalEntityCode

String

CR_LegalEntityName

String

CR_LegalEntityNumber

String

CR_Locale

String

CR_Logo

Blob

CR_Name

String

CR_NumberOfDaysOfPromptPay

BigDecimal

CR_OrganisationCode

String

CR_OrganisationId

String

CR_ParentClientCode

String

CR_ParentClientId

String

CR_PriceCatalogGroup

String

CR_PrimaryContactCode

String

CR_PrimaryContactId

String

CR_PrimaryProjectCode

String

CR_Priority

String

CR_PromptPaymentDiscount

BigDecimal

CR_ReportTemplateLabCode

String

CR_ReportsTemplateCode

String

CR_SourceCode

String

CR_SourceIsOrganisationScope

Boolean

CR_TargetCode

String

CR_TargetIsOrganisationScope

Boolean

The CCContact object associated with the job's contact is used to populate CT_* columns.

CT_ClientCode

String

CT_ClientContactDocExt

String

CT_ClientContactImageExt

String

CT_ClientId

String

CT_Code

String

CT_ContactCategoryCode

String

CT_ContactCategoryId

String

CT_ContactText

String

CT_ContactTextId

String

CT_Department

String

CT_Description

String

CT_Document

Blob

CT_ERPContactNumber

String

CT_Email

String

CT_Fax

String

CT_FirstName

String

CT_FullName

String

CT_IM

String

CT_Id

String

CT_Image

Blob

CT_IsActive

Boolean

CT_IsClientOrganisationScope

Boolean

CT_IsEmailUseDefault

Boolean

CT_IsFaxUseDefault

Boolean

CT_IsOrganisationScope

Boolean

CT_JobTitle

String

CT_LaboratoryCode

String

CT_LaboratoryId

String

CT_LastName

String

CT_LastSubmissionDate

Timestamp

CT_MiddleName

String

CT_Mobile

String

CT_Name

String

CT_OrganisationCode

String

CT_OrganisationId

String

CT_OwnerType

String

CT_Pager

String

CT_ReportPrinterCode

String

CT_ReportPrinterId

String

CT_ReportPrinterNetworkAddress

String

CT_Salutation

String

CT_Telephone

String

CT_UseClientAddress

Boolean

The CCContact object associated with the report request's contact is used to populate CTR_* columns.

CTR_ClientCode

String

CTR_ClientContactDocExt

String

CTR_ClientContactImageExt

String

CTR_ClientId

String

CTR_Code

String

CTR_ContactCategoryCode

String

CTR_ContactCategoryId

String

CTR_ContactText

String

CTR_ContactTextId

String

CTR_Department

String

CTR_Description

String

CTR_Document

Blob

CTR_ERPContactNumber

String

CTR_Email

String

CTR_Fax

String

CTR_FirstName

String

CTR_FullName

String

CTR_Im

String

CTR_Id

String

CTR_Image

Blob

CTR_IsActive

Boolean

CTR_IsClientOrganisationScope

Boolean

CTR_IsEmailUseDefault

Boolean

CTR_IsFaxUseDefault

Boolean

CTR_IsOrganisationScope

Boolean

CTR_JobTitle

String

CTR_LaboratoryCode

String

CTR_LaboratoryId

String

CTR_LastName

String

CTR_LastSubmissionDate

Timestamp

CTR_MiddleName

String

CTR_Mobile

String

CTR_Name

String

CTR_OrganisationCode

String

CTR_OrganisationId

String

CTR_OwnerType

String

CTR_Pager

String

CTR_ReportPrinterCode

String

CTR_ReportPrinterId

String

CTR_ReportPrinterNetworkAddress

String

CTR_Salutation

String

CTR_Telephone

String

CTR_UseClientAddress

Boolean

The CCJob object associated with the job is used to populate J_* columns.

J_ActivatedUserCode

String

J_ActivatedUserId

String

J_AgreedDate

Timestamp

J_AnalysedDate

Timestamp

J_AnalysisText

String

J_AnalysisTextId

String

J_ApplicationId

String

J_ArchivedUserCode

String

J_ArchivedUserId

String

J_AuthUserGroupCode

String

J_AuthUserGroupId

String

J_AuthorisationUserCode

String

J_AuthorisationUserId

String

J_AuthorisedDate

Timestamp

J_CheckedInBy

String

J_CheckedInOn

Timestamp

J_ClientCode

String

J_ClientCodeForUpdate

String

J_ClientContactCode

String

J_ClientContactCodeForUpdate

String

J_ClientContactId

String

J_ClientContactIdForUpdate

String

J_ClientContactName

String

J_ClientId

String

J_ClientIdForUpdate

String

J_ClientLaboratoryCode

String

J_ClientName

String

J_ClientProjectCode

String

J_ClientProjectCodeForUpdate

String

J_ClientProjectId

String

J_ClientProjectIdForUpdate

String

J_ClientProjectName

String

J_ClientSubmissionNumber

String

J_Code

String

J_CompletedByUserCode

String

J_CompletedByUserId

String

J_CompletedDate

Timestamp

J_CompositeQcStatus

String

J_CompositeSpecStatus

String

J_ContainerName

String

J_ContainerTypeCode

String

J_ContainerTypeLabCode

String

J_Contract

String

J_ContractSubmissionNumber

String

J_CostCentreCode

String

J_CostCentreId

String

J_CostCentreLaboratoryCode

String

J_Description

String

J_Discount

BigDecimal

J_ErsCode

String

J_ErsCodeForUpdate

String

J_ErsItemCode

String

J_ErsItemCodeForUpdate

String

J_FinalisationUserCode

String

J_FinalisationUserId

String

J_FinalisedDate

Timestamp

J_FirstInvoicedDate

Timestamp

J_FirstInvoicedUser

String

J_FirstReportedDate

Timestamp

J_FixedPrice

BigDecimal

J_FixedPriceCurrencyId

String

J_HashCpl

BigDecimal

J_HashSch

BigDecimal

J_HashSta

BigDecimal

J_HideActivateJobFllow

Boolean

J_IsActiveForAutoRegistration

Boolean

J_IsActiveForManualRegistration

Boolean

J_IsArchived

Boolean

J_IsAutoReceive

Boolean

J_IsAutoValidate

Boolean

J_IsCostWIPESTOutdated

Boolean

J_IsFixedPrice

Boolean

J_IsInitiatedByCcvaln

Boolean

J_IsOrganisationScope

Boolean

J_IsRequireAuthorisation

Boolean

J_JobCategoryCode

String

J_JobCategoryId

String

J_JobId

String

J.JobNameScheduleOffset

String

J_JobNameSyntaxCode

String

J_JobNameSyntaxId

String

J_JobTemplateCode

String

J_JobTemplateId

String

J_JobType

String

J_LaboratoryCode

String

J_LaboratoryId

String

J_LastActivatedDate

Timestamp

J_LastArchivedDate

Timestamp

J_LastInvoiceId

String

J_LastInvoicedDate

Timestamp

J_LastInvoicedUser

String

J_LastReportId

String

J_LastReportedDate

Timestamp

J_LocationCode

String

J_LocationLabCode

String

J_Name

String

J_NumberOfSamples

BigDecimal

J_NumberOfUnknownSamples

BigDecimal

J_OrderCode

String

J_OrderId

String

J_OrganisationCode

String

J_OrganisationId

String

J_OwnerChangedDate

Timestamp

J_OwnerUserCode

String

J_OwnerUserId

String

J_PossibleDate

Timestamp

J_PrepMiscSchemeWorkflowStatus

String

J_PreparationText

String

J_PreparationTextId

String

J_PriceBookId

String

J_Priority

String

J_ProductionJobDescriptionSyntaxCode

String

J_ProductionJobDescriptionSyntaxLabCode

String

J_ProductionJobName

String

J_ProductionJobNameSyntaxCode

String

J_ProductionJobNameSyntaxLabCode

String

J_QuoteCode

String

J_QuoteId

String

J_ReceivedDate

Timestamp

J_ReceptionUserCode

String

J_ReceptionUserId

String

J_RegisteredDate

TImestamp

J_RegistrationMode

String

J_RegistrationText

String

J_RegistrationTextId

String

J_RegistrationUserCode

String

J_RegistrationUserId

String

J_ReleasedDate

Timestamp

J_RepReqId

String

J_ReportText

String

J_ReportTextId

String

J_RequiredDate

Timestamp

J_SampleHandlingCode

String

J_SampleHandlingDueOn

Timestamp

J_SampleHandlingLabCode

String

J_SampleHandlingStartedBy

String

J_SampleHandlingStartedOn

Timestamp

J_SampledOn

Timestamp

J_SaveAsSourceIsOrganisationScope

Boolean

J_SaveAsSourceName

String

J_Schedule

String

J_ScheduleExpiresOnDate

Timestamp

J_ScheduleLastExecutionDate

Timestamp

J_ScheduleStatus

String

J_SignUserGroupCode

String

J_SignUserGroupId

String

J_StartedDate

Timestamp

J_StatusChangeReason

String

J_SubcontractLabCode

String

J_SubcontractLabOrgCode

String

J_UseSamplesFromTemplate

Boolean

J_UseTestsFromTemplate

Boolean

J_ValidatedDate

Timestamp

J_ValidationUserCode

String

J_ValidationUserId

String

J_WorkflowStatus

String

The CCLocation object associated with the job's location (applicable where job-level tracking is in place) is used to populate LC_* columns.

LC_AccessCategoryCode

String

LC_AccessCategoryId

String

LC_Code

String

LC_ConditionCategoryCode

String

LC_ConditionCategoryId

String

LC_Description

String

LC_Id

String

LC_IsActive

Boolean

LC_LaboratoryCode

String

LC_LaboratoryId

String

LC_LocationCategoryCode

String

LC_LocationCategoryId

String

LC_LocationCategoryName

String

LC_Name

String

LC_OrganisationCode

String

LC_ParentLocationCode

String

LC_ParentLocationId

String

LC_ParentLocationIsActive

Boolean

LC_ParentLocationName

String

LC_SampleHandlingCode

String

LC_SampleHandlingId

String

LC_SamplePrepAction

String

The CCSampleHandling object associated with the job's sample handling (applicable where job-level tracking is in place) is used to populate SH_* columns.

SH_Code

String

SH_Description

String

SH_Document

Blob

SH_DocumentExt

String

SH_Duration

BigDecimal

SH_HandlingMethodCategoryCode

String

SH_HandlingMethodCategoryId

String

SH_Id

String

SH_Image

Blob

SH_ImageExt

String

SH_IsActive

Boolean

SH_IsOrganisationScope

Boolean

SH_Label

String

SH_LabelTextId

String

SH_LaboratoryCode

String

SH_LaboratoryId

String

SH_Name

String

SH_OrganisationCode

String

SH_OrganisationId

String

SH_SampleHandlingCategoryCode

String

SH_SampleHandlingCategoryId

String

SH_SetPortionIsActive

String

SH_SpecialInstructions

String

SH_SpecialInstructionsTextId

String

Note: There is no connection to the ContainerType properties (apart for ContainerType.Code) for job storage tracking, but there is the inclusion of the Location and Sample Handling properties of the job.