Table "Pickup Contract Line WCAP"
Obsolete
This element will become obsolete from version V27.202602. This table is no longer used since the contracts are now based on standard Job module.
Properties
| Name | Value |
|---|---|
| DataClassification | CustomerContent |
| Caption | Contract Line |
| DataPerCompany | False |
| LookupPageId | Page CapVision.CapCollecte.Contracts."Pickup Contract Lines WCAP" |
| DrillDownPageId | Page CapVision.CapCollecte.Contracts."Pickup Contract Lines WCAP" |
| ObsoleteState | Pending |
| ObsoleteReason | This table is no longer used since the contracts are now based on standard Job module. |
| ObsoleteTag | V27.202602 |
Fields
| Name | Type | Description |
|---|---|---|
| "Pickup Contract No." | Code[20] | Specifies the number used to identify the contract. |
| "Line No." | Integer | Specifies the line number of the contract line. |
| "Company Name" | Text[30] | Specifies the name of the company on which the record was created. |
| "Customer No." | Code[20] | Specifies the customer number. |
| "Header Customer No." | Code[20] | Specifies the customer number. |
| "Customer Name" | Text[100] | Specifies the customer name. |
| "Header Customer Name" | Text[100] | Specifies the customer name. |
| "Customer Address Code" | Code[10] | Specifies the address code of the site where the pickup should take place. |
| "Header Customer Address Code" | Code[10] | Specifies the address code of the site where the pickup should take place. |
| "Customer Address Name" | Text[100] | Specifies the address name of the site where the pickup should take place. |
| "Customer Address Name 2" | Text[100] | Specifies the address name 2 of the site where the pickup should take place. |
| "Customer Address" | Text[100] | Specifies the address of the site where the pickup should take place. |
| "Customer Address Post Code" | Code[20] | Specifies the address post code of the site where the pickup should take place. |
| "Customer Address City" | Text[30] | Specifies the address city of the site where the pickup should take place. |
| "Item to Pickup No." | Code[20] | Specifies the product item no. |
| "Product Item Price Variant" | Code[10] | Specifies the product item price variant of the contract. |
| "Product Item Quantity" | Decimal | Specifies the product item quantity. |
| "Item to Pickup Description" | Text[100] | Specifies the product item description. |
| "Service Item No." | Code[20] | Specifies the service item of the contract. |
| "Service Item Price Variant" | Code[10] | Specifies the service item price variant of the contract. |
| "Service Item Description" | Text[100] | Specifies the description of the service item of the contract. |
| "Unit of Measure Code" | Code[10] | Specifies the pickup unit of measure code for this record. |
| "Theoretical Quantity" | Decimal | Specifies the theoretical quantity that should be picked up. |
| "Pickup on Demand" | Boolean | Specifies if the contract is picked up on demand only. |
| "No. of Fixed Pickup Dates" | Integer | Specifies the numbers of fixed pickup dates for this contract. Click to open the list of pickup dates. |
| "No. of Pickup Closing Periods" | Integer | Specifies the number of pickup closing periods for this contract. Click to open the list of pickup closing periods. |
| "Contract Starting Date" | Date | Specifies the starting date of the contract. |
| "Contract Ending Date" | Date | Specifies the ending date of the contract. |
| "Weighing Requested" | Boolean | Specifies if the weighing is requested for the contract. |
| "Service Unit of Measure" | Code[10] | Specifies the service item unit of measure of the contract. |
| "Material Type WCAP" | Code[10] | Specifies the material type of the contract line. |
| "Sales Price List Code" | Code[20] | Specifies the code of the price list linked to this contract. |
| "Sales Price List Line No." | Integer | Specifies the line number of the price list linked to this contract. |
| "No. of Missions" | Integer | Specifies the number of missions for this contract. |
| "Expected Duration" | Duration | Specifies the expected duration of the contract line. Used on the planning to set the tour duration. |
| "Merged in Job No." | Code[20] | |
| "Merged in Job Product Line No." | Integer | |
| Name | Text[100] | Specifies the customer's address name. |
| "Name 2" | Text[50] | Specifies an additional part of the customer's address name. |
| Address | Text[100] | Specifies the customer's address. |
| "Address 2" | Text[50] | Specifies additional customer address information. |
| City | Text[30] | Specifies the customer's city. |
| "Post Code" | Code[20] | Specifies the customer's postal code. |
| "Country/Region Code" | Code[10] | Specifies the country/region of the customer. |
| Latitude | Decimal | Specifies the latitude value of the customer's location. The value can be accurate to within 0.111 meters. |
| Longitude | Decimal | Specifies the longitude value of the customer's location. The value can be accurate to within 0.111 meters. |
| Monday | Boolean | Specifies if the contract takes place on Monday. |
| Tuesday | Boolean | Specifies if the contract takes place on Tuesday. |
| Wednesday | Boolean | Specifies if the contract takes place on Wednesday. |
| Thursday | Boolean | Specifies if the contract takes place on Thursday. |
| Friday | Boolean | Specifies if the contract takes place on Friday. |
| Saturday | Boolean | Specifies if the contract takes place on Saturday. |
| Sunday | Boolean | Specifies if the contract takes place on Sunday. |
| "Monday No. of Typical Tours" | Integer | |
| "Tuesday No. of Typical Tours" | Integer | |
| "Wednesday No. of Typical Tours" | Integer | |
| "Thursday No. of Typical Tours" | Integer | |
| "Friday No. of Typical Tours" | Integer | |
| "Saturday No. of Typical Tours" | Integer | |
| "Sunday No. of Typical Tours" | Integer | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |
Methods
CheckClosingPeriods
Obsolete
This element will become obsolete from version V27.202602. This table is no longer used since the contracts are now based on standard Job module.
procedure CheckClosingPeriods(Date: Date): BooleanParameters
| Name | Type | Description |
|---|---|---|
| Date | Date |
Returns
| Type | Description |
|---|---|
| Boolean |
CheckContractDateInRange
Obsolete
This element will become obsolete from version V27.202602. This table is no longer used since the contracts are now based on standard Job module.
procedure CheckContractDateInRange(Date: Date): BooleanParameters
| Name | Type | Description |
|---|---|---|
| Date | Date |
Returns
| Type | Description |
|---|---|
| Boolean |
CheckIfDemanded
Obsolete
This element will become obsolete from version V27.202602. This table is no longer used since the contracts are now based on standard Job module.
procedure CheckIfDemanded(Date: Date): BooleanParameters
| Name | Type | Description |
|---|---|---|
| Date | Date |
Returns
| Type | Description |
|---|---|
| Boolean |
RecreateBillableEntriesNotInvoiced
Obsolete
This element will become obsolete from version V27.202602. This table is no longer used since the contracts are now based on standard Job module.
Recrée les écritures facturables non facturées en traitant les enregistrements temporaires fournis.
procedure RecreateBillableEntriesNotInvoiced(var TempBillableEntry: Record "Billable Entry WCAP" temporary; var ProcessedCount: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| TempBillableEntry | Table CapVision.CapCollecte.Invoicing."Billable Entry WCAP" |
Un enregistrement temporaire de type "Billable Entry WCAP" contenant les écritures à traiter. |
| ProcessedCount | Integer |
Une variable entière qui contiendra le nombre d'écritures traitées après l'exécution. |
Remarks
Cette procédure traite chaque écriture facturable dans l'enregistrement temporaire fourni. Pour chaque écriture, elle récupère la mission associée, désactive temporairement le statut "Contrôlé" si activé, met à jour la mission et restaure les valeurs originales des champs "Controlled By" et "Controlled On". La procédure incrémente la variable ProcessedCount pour chaque écriture traitée avec succès