Projects
4 minute read
The table projects stores informatione about the project. If you are using production units, there can be more than one project.
| Name | Type | Size | Description |
|---|---|---|---|
| ACTIVEID | Long Integer | 4 | |
| ActiveTitle | Text | 255 | |
| Comment_1 | Text | 255 | Path + Filename of project comment 1 |
| Comment_2 | Text | 255 | Path + Filename of project comment 2 |
| Comment_3 | Text | 255 | Path + Filename of project comment 3 |
| Comment_4 | Text | 255 | Path + Filename of project comment 4 |
| Comment_5 | Text | 255 | Path + Filename of project comment 5 |
| CurtainWallGlazingCosts | Double | 8 | Calculation - Wall glazing costs |
| CurtainWallMinGlazingCosts | Double | 8 | Calculation - minimum Wall glazing costs |
| CurtainWallMinPanelingCosts | Double | 8 | Calculation - minimum Wall paneling costs |
| CurtainWallPanelingCosts | Double | 8 | Calculation - Wall paneling costs |
| DeliveryNo | Text | 255 | Delivery number |
| Dismantling | Double | 8 | Labour hours - Dismantling |
| EstimationDataName | Text | 255 | Name of estimation data |
| Fabrication1 | Double | 8 | Labour hours - Fabrication 1 |
| Fabrication10 | Double | 8 | Labour hours - Fabrication 10 |
| Fabrication11 | Double | 8 | Labour hours - Fabrication 11 |
| Fabrication12 | Double | 8 | Labour hours - Fabrication 12 |
| Fabrication13 | Double | 8 | Labour hours - Fabrication 13 |
| Fabrication14 | Double | 8 | Labour hours - Fabrication 14 |
| Fabrication15 | Double | 8 | Labour hours - Fabrication 15 |
| Fabrication2 | Double | 8 | Labour hours - Fabrication 2 |
| Fabrication3 | Double | 8 | Labour hours - Fabrication 3 |
| Fabrication4 | Double | 8 | Labour hours - Fabrication 4 |
| Fabrication5 | Double | 8 | Labour hours - Fabrication 5 |
| Fabrication6 | Double | 8 | Labour hours - Fabrication 6 |
| Fabrication7 | Double | 8 | Labour hours - Fabrication 7 |
| Fabrication8 | Double | 8 | Labour hours - Fabrication 8 |
| Fabrication9 | Double | 8 | Labour hours - Fabrication 9 |
| Installation1 | Double | 8 | Labour hours - Installation 1 |
| Installation2 | Double | 8 | Labour hours - Installation 2 |
| InvoiceNo | Text | 255 | Invoice number |
| LK_CustomerAddressID | Long Integer | 4 | LOOKUP KEY refers to Address.AddressID |
| MaxOfferDiscount1 | Double | 8 | Maximum project discount 1 in your currency |
| MaxOfferDiscount2 | Double | 8 | Maximum project discount 2 in your currency |
| MaxOfferDiscount3 | Double | 8 | Maximum project discount 3 in your currency |
| MaxOfferDiscount4 | Double | 8 | Maximum project discount 4 in your currency |
| Name | Text | 255 | Name of project |
| OfferDiscount1 | Double | 8 | Project discount 1 in % |
| OfferDiscount2 | Double | 8 | Project discount 2 in % |
| OfferDiscount3 | Double | 8 | Project discount 3 in % |
| OfferDiscount4 | Double | 8 | Project discount 4 in % |
| OfferNo | Text | 255 | Offer number |
| OrderNo | Text | 255 | Order number |
| PackagingSurcharge | Double | 8 | Calculation - Packaging surcharge |
| PersonInCharge | Text | 255 | Person in charge |
| PersonInChargeTech | Text | 255 | Technical person in charge |
| PictureFile | Text | 255 | Path and filename of project picture |
| PrcCommission | Double | 8 | Calculation - Commission costs |
| PrcExtra | Double | 8 | Calculation - Extra costs |
| PrcInterest | Double | 8 | Calculation - Interest costs |
| PrcOverheadsGlass | Double | 8 | Calculation - Overheads glass in % |
| PrcOverheadsMaterial | Double | 8 | Calculation - Overheads material in % |
| PrcOverheadsPanel | Double | 8 | Calculation - Overheads panel in % |
| PrcOverheadsWages | Double | 8 | Calculation - Overheads wages in % |
| PrcPlanningOffice | Double | 8 | Calculation - Planning office in % |
| PrcProfitElement | Double | 8 | Calculation - Profit element in % |
| PrcProfitGlass | Double | 8 | Calculation - Profit glass in % |
| PrcProfitMaterial | Double | 8 | Calculation - Profit material in % |
| PrcProfitOther | Double | 8 | Calculation - Profit other in % |
| PrcProfitPanel | Double | 8 | Calculation - Profit panel in % |
| PrcProfitWages | Double | 8 | Calculation - Profit wages in % |
| PrcProfitWastage | Double | 8 | Calculation - Profit wastage in % |
| PrcRollProfiles | Double | 8 | Calculation - Roll profiles |
| PrcSalesManagement | Double | 8 | Calculation - Sales and Mangement in % |
| PrcSealingToStructure | Double | 8 | Calculation - Sealing to structure |
| PrcSurchargeCashDiscount | Double | 8 | Calculation - Surcharge cash discount |
| PrcTaping | Double | 8 | Calculation - Taping |
| PrcTransport | Double | 8 | Calculation - Transport in % |
| ProjectID | Long Integer | 4 | PRIMARY KEY |
| ProjectPath | Text | 255 | Path of project |
| ProjectType | Long Integer | 4 | 0 = Project1 = Production unit |
| SealingCosts | Double | 8 | Calculation - Sealing costs |
| SiliconeGlazingCosts | Double | 8 | Calculation - Silicone glazing costs |
| TextBegin | Text | 255 | Project text beginn |
| TextEnd | Text | 255 | Project text end |
| WindowGlazingCosts | Double | 8 | Calculation - Glazing costs |
| WindowMinGlazingCosts | Double | 8 | Calculation - Minimum glazing costs |
| WindowMinPanelingCosts | Double | 8 | Calculation - Minimum planeling costs |
| WindowPanelingCosts | Double | 8 | Calculation - Paneling costs |
| WorkPreparation1 | Double | 8 | Labour hours - Work preparation 1 |
| WorkPreparation2 | Double | 8 | Labour hours - Work preparation 2 |
| WorkPreparation3 | Double | 8 | Labour hours - Work preparation 3 |