Table "Mission WCAP"
Properties
| Name | Value |
|---|---|
| DataClassification | CustomerContent |
| Caption | Mission |
| DataPerCompany | False |
| DrillDownPageId | Page CapVision.CapCollecte.Missions."Missions WCAP" |
| LookupPageId | Page CapVision.CapCollecte.Missions."Missions WCAP" |
Fields
| Name | Type | Description |
|---|---|---|
| "No." | Code[20] | Specifies the number of the mission. |
| "Company Name" | Text[30] | Specifies the name of the company on which the record was created. |
| "Mission Type" | Enum CapVision.CapCollecte.Missions."Mission Type WCAP" | Specifies the mission type. |
| "Mission Doc. No." | Code[20] | Specifies the mission document number depending on the mission type. |
| "Mission Doc. Line No." | Integer | Specifies the line number of the document depending on the mission type. |
| "Tour No." | Code[20] | Specifies the tour. |
| "Tour Vehicle No." | Code[20] | Specifies the vehicle no. of the tour. |
| "Tour Description" | Text[100] | Specifies the description of the tour. |
| Rank | Integer | Specifies the rank in which the list is ordered by. |
| Observation | Blob | |
| "Product Item No." | Code[20] | Specifies the product item number. |
| "Service Item No." | Code[20] | Specifies the service item number. |
| "Product Item Description" | Text[100] | Specifies the product item description for the mission. |
| "Product Quantity" | Decimal | Specifies the quantity of the product for the mission. |
| "Service Item Description" | Text[100] | Specifies the service item description for the mission. |
| "Product Unit of Measure" | Code[10] | Specifies the product unit of measure code for this record. |
| "Service Unit of Measure" | Code[10] | Specifies the service unit of measure for this record. |
| "Theoretical Quantity" | Decimal | Specifies the theoretical quantity that should be picked up. The value is retrieved from the document from which the mission was created. |
| "Actual Picked Quantity" | Decimal | Specifies the Actual quantity that has been picked up. This field is only used if the material is tracked. |
| "Actual Delivered Quantity" | Decimal | Specifies the Actual quantity that has been delivered. This field is only used if the material is tracked. |
| "Customer Material Quantity" | Decimal | Specifies the customer material quantity. |
| "Real Quantity" | Decimal | Specifies the Real quantity that has been delivered or picked up. This field is used if the material is not tracked and to know what to invoice. |
| "Requested Date" | Date | Specifies the requested date of the mission. |
| "Weighing Requested" | Boolean | Specifies if the weighing is requested for the contract. |
| "Weighing No." | Integer | Specifies the first weighing no. to be inserted to make the link with a vehicle weighing entry. |
| "Vehicle Weighings Number" | Integer | Specifies the number of vehicle weighings linked to the mission. |
| Weight | Decimal | Specifies the weight that has been picked up. |
| "Vehicle Weight" | Decimal | Specifies the weight reported by the driver in the Lemoov app. |
| "Empty Run" | Boolean | Specifies if the run was empty. |
| "Empty Run Reason" | Blob | |
| Controlled | Boolean | Specifies if the line has been controlled by a user. The actual quantity should be superior to 0, or the field "Empty Run" should be checked. |
| "Controlled On" | DateTime | Specifies the date and time when the line was controlled. |
| "Controlled By" | Code[50] | Specifies the user who controlled the line. |
| "Pickup Missions To Invoice" | Integer | Specifies the number of pickup missions to invoice. |
| "Pickup on Demand" | Boolean | Specifies if the contract is picked up on demand only. |
| "Subcontracting Invoice Status" | Enum CapVision.CapCollecte.Missions."Mission Invoice Status WCAP" | Specifies the status of the subcontracting invoice. |
| "Subcontracting Invoice No." | Code[20] | Specifies the order document number. Used when invoicing the mission from a tour to a subcontractor. |
| "Subcontracting Line No." | Integer | Specifies the order document line no. Used when invoicing the mission from a tour to a subcontractor. |
| "Customer No." | Code[20] | Specifies the value of the Customer No. field. |
| "Customer Name" | Text[100] | Specifies the value of the Customer Name field. |
| "Customer Address Code" | Code[10] | Specifies the value of the Customer Address Code field. |
| "Origin Type" | Enum CapVision.CapCollecte.General."Third-party Type WCAP" | Specifies the origin type. |
| "Origin Code" | Text[30] | Specifies the origin code depending on the origin type. |
| "Origin Address Code" | Code[10] | Specifies the origin address code depending on the origin type. |
| "Origin Name" | Text[100] | Specifies the origin name. |
| "Origin Name 2" | Text[50] | Specifies an additional part of the origin name. |
| "Origin Address" | Text[100] | Specifies the origin address. |
| "Origin Address 2" | Text[50] | Specifies additional origin address information. |
| "Origin City" | Text[30] | Specifies the origin city. |
| "Origin Post Code" | Code[20] | Specifies the origin postal code. |
| "Origin Country/Region Code" | Code[10] | Specifies the origin country/region code. |
| "Origin Latitude" | Decimal | Specifies the latitude value of the origin location. The value can be accurate to within 0.111 meters. |
| "Origin Longitude" | Decimal | Specifies the longitude value of the origin location. The value can be accurate to within 0.111 meters. |
| "Destination Type" | Enum CapVision.CapCollecte.General."Third-party Type WCAP" | Specifies the destination type. |
| "Destination Code" | Text[30] | Specifies the destination code depending on the destination type. |
| "Destination Address Code" | Code[10] | Specifies the destination address code depending on the destination type. |
| "Destination Name" | Text[100] | Specifies the destination name. |
| "Destination Name 2" | Text[50] | Specifies an additional part of the destination name. |
| "Destination Address" | Text[100] | Specifies the destination address. |
| "Destination Address 2" | Text[50] | Specifies additional destination address information. |
| "Destination City" | Text[30] | Specifies the destination city. |
| "Destination Post Code" | Code[20] | Specifies the destination postal code. |
| "Destinati. Country/Region Code" | Code[10] | Specifies the destination country/region code. |
| "Destination Latitude" | Decimal | Specifies the latitude value of the destination location. The value can be accurate to within 0.111 meters. |
| "Destination Longitude" | Decimal | Specifies the longitude value of the destination location. The value can be accurate to within 0.111 meters. |
| "Material Tracked" | Boolean | |
| Signature | Blob | Specifies the signature of the customer. |
| "Bill-to Third-party Type" | Enum CapVision.CapCollecte.General."Third-party Type WCAP" | Specifies the bill-to third-party type. |
| "Bill-to Third-party No." | Code[20] | Specifies the bill-to third-party no. depending on the third-party type. |
| "Service Type" | Code[10] | Specifies the service type. |
| "Service Type Description" | Text[100] | Specifies the service type description. |
| "Service Type Direction" | Enum CapVision.CapCollecte.General."Service Type Direction WCAP" | Specifies the service type direction. |
| "Material Type WCAP" | Code[10] | Specifies the material type of the price list line. |
| "Fill Rate" | Enum CapVision.CapCollecte.Missions."25% Increment Rate WCAP" | Specifies the fill rate by 25% increment. |
| "Non-Conformity Rate" | Enum CapVision.CapCollecte.Missions."25% Increment Rate WCAP" | Specifies the non-conformity rate by 25% increment. |
| "Non-Conformity Reason" | Code[20] | Specifies the non-conformity reason. |
| "Non-Conformity Reason Desc." | Text[100] | Specifies the non-conformity reason's description. |
| "Invoicing Status" | Enum CapVision.CapCollecte.Missions."Mission Invoice Status WCAP" | Specifies the invoicing status of the mission. |
| "Invoice No." | Code[20] | Specifies Invoice No. related to the mission. |
| "Work Starting Date" | DateTime | Specifies the date and time when the work was beginned by the driver. This field is filled when the mission is started with the Lemoov app. |
| "Work Ending Date" | DateTime | Specifies the date and time when the work was completed by the driver. This field is filled when the mission is completed with the Lemoov app. |
| "Tour Date" | Date | Specifies the date of the tour. |
| "Do Not Invoice" | Boolean | Specifies if the mission should be invoiced. |
| "Driver Status" | Enum CapVision.CapCollecte.Missions."Driver Status WCAP" | Specifies the state of the driver work as reported by Lemoov app. |
| "Requested Time" | Time | Specifies the requested time of the mission. |
| "Number Of Pictures" | Integer | Specifies the number of pictures of the mission. |
| "Firmly Scheduled" | Boolean | Specifies if the missions date & time were firmly planned with the customer. |
| "Purchase Link" | Boolean | Specifies if the mission must be linked to a purchase order. If this field is checked, then you must pick a purchase line as the origin of the mission. |
| "Purchase Order No." | Code[20] | Specifies the purchase order number. |
| "Purchase Line No." | Integer | Specifies the purchase line number. |
| "Missions With Same Purch. Link" | Integer | Specifies the number of sales missions linked to this purchase mission. |
| "Different Mission Filter" | Text[50] | |
| "Contact No. Filter" | Code[20] | |
| "Weighing Net Weight WCAP" | Decimal | Specifies the sum of the net weights of the weighings for the record. |
| "Open Weighing Log Entries WCAP" | Decimal | Specifies the sum of the opened weighing log entries for the record. An opened weighing is a weighing that has no 2nd weighing. |
| "Carrier Type" | Enum CapVision.CapCollecte.General."Third-party Type WCAP" | Specifies the type of carrier (Customer, Vendor, or Company). |
| "Carrier Code" | Text[30] | Specifies the code of the carrier. |
| "Job Business Nature" | Enum CapVision.CapCollecte.Pricing."Business Nature WCAP" | Specifies the business nature of the related job. |
| "Roadside Wood Grinding DT" | DateTime | Specifies the date and time of end of wood grinding for roadside related missions. |
| "Total Tare Weight" | Decimal | Specifies the sum of the tare weights of the weighings. |
| "Total Gross Weight" | Decimal | Specifies the sum of the gross weights of the weighings. |
| "Total Net Weight" | Decimal | Specifies the sum of the net weights of the weighings. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |
Methods
UnassignMissionsFromTour
Désaffecte les missions de leur tournée.
procedure UnassignMissionsFromTour(var Mission: Record "Mission WCAP")
Parameters
| Name | Type | Description |
|---|---|---|
| Mission | Table CapVision.CapCollecte.Missions."Mission WCAP" |
UnassignMissionFromTour
Désaffecte la mission de sa tournée. Si la mission appartient à une tournée type, la mission est supprimée.
procedure UnassignMissionFromTour()
InitRank
procedure InitRank()
GetObservationText
Obtient le texte présent dans le champ Observation.
procedure GetObservationText(): Text
Returns
| Type | Description |
|---|---|
| Text |
GetObservationText
Obtient le texte présent dans le champ Observation.
procedure GetObservationText(SkipCalcField: Boolean): Text
Parameters
| Name | Type | Description |
|---|---|---|
| SkipCalcField | Boolean |
Indique si un CalcFields du BLOB doit être réalisé. |
Returns
| Type | Description |
|---|---|
| Text |
SetObservationText
Définit le texte à renseigner dans le champ Observation.
procedure SetObservationText(Value: Text)
Parameters
| Name | Type | Description |
|---|---|---|
| Value | Text |
GetEmptyRunReasonText
Obtient le texte présent dans le champ "Empty Run Reason".
procedure GetEmptyRunReasonText(): Text
Returns
| Type | Description |
|---|---|
| Text |
GetEmptyRunReasonText
Obtient le texte présent dans le champ "Empty Run Reason".
procedure GetEmptyRunReasonText(SkipCalcField: Boolean): Text
Parameters
| Name | Type | Description |
|---|---|---|
| SkipCalcField | Boolean |
Indique si un CalcFields du BLOB doit être réalisé. |
Returns
| Type | Description |
|---|---|
| Text |
SetEmptyRunReasonText
Définit le texte à renseigner dans le champ "Empty Run Reason".
procedure SetEmptyRunReasonText(Value: Text)
Parameters
| Name | Type | Description |
|---|---|---|
| Value | Text |
ShowDocument
procedure ShowDocument()
GetNumberOfVehicleWeighings
procedure GetNumberOfVehicleWeighings(): Integer
Returns
| Type | Description |
|---|---|
| Integer |
CheckIfMissionCanBeMarkedControlled
Teste si la mission peut être marquée comme contrôlée..
[TryFunction]
procedure CheckIfMissionCanBeMarkedControlled(): Boolean
Returns
| Type | Description |
|---|---|
| Boolean |
CheckIfMissionCanBeUnmarkedControlled
Teste si la mission peut être démarquée comme non contrôlée.
[TryFunction]
procedure CheckIfMissionCanBeUnmarkedControlled(): Boolean
Returns
| Type | Description |
|---|---|
| Boolean |
GetProducts
Obtient la liste des produits liés à la mission.
procedure GetProducts(var TempItem: Record Item temporary)
Parameters
| Name | Type | Description |
|---|---|---|
| TempItem | Record Item temporary |
Examples
var
Mission: Record Mission;
TempItem: Record Item temporary;
begin
Mission.FindFirst();
Mission.GetProducts(TempItem);
end;
ApplyPlanningFilter
Modifie le filtre de l'enregistrement en cours pour limiter les éléments en fonctions des paramètres de l'utilisateur connecté.
procedure ApplyPlanningFilter()
RetrieveWeightWithMission
procedure RetrieveWeightWithMission(): Decimal
Returns
| Type | Description |
|---|---|
| Decimal |
Events
OnBeforeCheckIfMissionCanBeMarkedControlled
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckIfMissionCanBeMarkedControlled(Mission: Record "Mission WCAP"; var Handled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Mission | Table CapVision.CapCollecte.Missions."Mission WCAP" | |
| Handled | Boolean |
OnAfterCheckIfMissionCanBeMarkedControlled
[IntegrationEvent(False,False)]
local procedure OnAfterCheckIfMissionCanBeMarkedControlled(Mission: Record "Mission WCAP")
Parameters
| Name | Type | Description |
|---|---|---|
| Mission | Table CapVision.CapCollecte.Missions."Mission WCAP" |
OnBeforeCheckIfMissionCanBeUnmarkedControlled
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckIfMissionCanBeUnmarkedControlled(Mission: Record "Mission WCAP"; var Handled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Mission | Table CapVision.CapCollecte.Missions."Mission WCAP" | |
| Handled | Boolean |
OnAfterCheckIfMissionCanBeUnmarkedControlled
[IntegrationEvent(False,False)]
local procedure OnAfterCheckIfMissionCanBeUnmarkedControlled(Mission: Record "Mission WCAP")
Parameters
| Name | Type | Description |
|---|---|---|
| Mission | Table CapVision.CapCollecte.Missions."Mission WCAP" |