Table "Job Product Line WCAP"
Properties
| Name | Value |
|---|---|
| DataClassification | CustomerContent |
| Caption | Job Product Line |
| DataPerCompany | False |
| LookupPageId | Page CapVision.CapCollecte.Job."Job Product Lines WCAP" |
| DrillDownPageId | Page CapVision.CapCollecte.Job."Job Product Line WCAP" |
Fields
| Name | Type | Description |
|---|---|---|
| "Job No." | Code[20] | Specifies the number used to identify the job. |
| "Line No." | Integer | Specifies the line no. of this record. |
| "Product Item No." | Code[20] | Specifies the product item no. |
| "Product Item Description" | Text[100] | Specifies the product item description. |
| "Product Item Unit of Measure" | Code[10] | Specifies the product item unit of measure code for this record. |
| "Product Item Price Variant" | Code[10] | Specifies the product item price variant for this record. |
| "Product Item Quantity" | Decimal | Specifies the quantity of the product item for this record. |
| "Product Item Type" | Microsoft.Inventory.Item."Item Type" | Specifies the type of the product item for this record. |
| "Is Not Billable" | Boolean | Specifies if the product is billable |
| "Pickup on Demand" | Boolean | Specifies if the job is picked up on demand only. |
| "Weighing Requested" | Boolean | Specifies if the weighing is requested for the job. |
| "Material Type" | Code[10] | Specifies the material type of the job product line. |
| "Expected Duration" | Duration | Specifies the expected duration of the job product line. Used on the planning to set the tour duration. |
| "Business Nature" | Enum CapVision.CapCollecte.Pricing."Business Nature WCAP" | Specifies the business nature of the job product line. |
| Monday | Boolean | Specifies if the job takes place on Monday. |
| Tuesday | Boolean | Specifies if the job takes place on Tuesday. |
| Wednesday | Boolean | Specifies if the job takes place on Wednesday. |
| Thursday | Boolean | Specifies if the job takes place on Thursday. |
| Friday | Boolean | Specifies if the job takes place on Friday. |
| Saturday | Boolean | Specifies if the job takes place on Saturday. |
| Sunday | Boolean | Specifies if the job takes place on Sunday. |
| "Origin Type" | Enum CapVision.CapCollecte.General."Third-party Type WCAP" | Specifies the type of origin (Customer, Vendor, or Company). |
| "Origin Code" | Text[30] | Specifies the code of the origin (Customer No., Vendor No., or Company Name). |
| "Origin Address Code" | Code[10] | Specifies the address code for the origin. |
| "Destination Type" | Enum CapVision.CapCollecte.General."Third-party Type WCAP" | Specifies the type of destination (Customer, Vendor, or Company). |
| "Destination Code" | Text[30] | Specifies the code of the destination (Customer No., Vendor No., or Company Name). |
| "Destination Address Code" | Code[10] | Specifies the address code for the destination. |
| "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. |
| "No. of Fixed Pickup Dates" | Integer | Specifies the numbers of fixed pickup dates for this job. Click to open the list of job pickup dates. |
| "No. of Pickup Closing Periods" | Integer | Specifies the number of pickup closing periods for this job. Click to open the list of job pickup closing periods. |
| "Job Starting Date" | Date | Specifies the starting date of the job. |
| "Job Ending Date" | Date | Specifies the ending date of the job. |
| "No. of Missions" | Integer | Specifies the number of missions for this job product 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. |
| "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. |
| 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 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 |