Name of the table: BIQuotationLines
| Field names | Description |
| PK_BICompanyID | Internal unique reference |
| CompanyName | Company/Store name |
| CompanyGroupCode | Shop Property |
| CompanyGroupValue | Shop Property |
| DateUpdatedBISynchCompany | Date of the last update of this record in the BI |
| DateCreatedBISynchCompany | Date of creation of this record in the BI |
| BIDeletedCompany | Data deleted from the database (or not) |
| CustomerGroupCode | Property entered in the customer file (free field) |
| CustomerGroupValue | Property entered in the customer file (free field) |
| CustomerNr | Customer number as displayed in Winner Bizz |
| CustomerLastname | Name of the customer |
| CustomerFirstname | Customer's first name (empty if customer is a professional) |
| CustomerTitle | Title (e.g. Dr...) |
| CustomerApproach | Details on the title |
| CustomerZipCode | Postcode |
| CustomerAddress | Address |
| CustomerCity | City |
| CustomerCountry | Country |
| CustomerPhone | Business phone number |
| CustomerPrivatePhone | Private telephone number |
| CustomerMobilePhone | Mobile phone number |
| CustomerFax | Customer's fax |
| CustomerEmail | Customer email |
| CustomerBudget | Budget filled in the project sheet |
| CustomerDateCreation | Date of creation of the customer record entry |
| CustomerAuthorLoginName | Who created the record (login) |
| CustomerAuthorLastname | Author's last name |
| CustomerAuthorFirstname | Author's first name |
| ProjectNr | Project number (as displayed in Winner Bizz) |
| ProjectName | Project name |
| ProjectExternalReference | External reference that can be added in the Project Properties form |
| ProjectTypeCode | Property entered in the project file (free field) |
| ProjectTypeValue | Property entered in the project file (free field) |
| ProjectDistrictCode | Property entered in the project file (free field) |
| ProjectDistrictValue | Property entered in the project file (free field) |
| ProjectDateCreation | Project creation date |
| ProjectDateLost | Date the project was marked as lost |
| ProjectCompetitorCode | Property entered in the project file (free field) |
| ProjectCompetitorValue | Property entered in the project file (free field) |
| ProjectStatusInfoCode | Property entered in the project file (free field) |
| ProjectStatusInfoValue | Property entered in the project file (free field) |
| ProjectIsRetailSale | Entered when the type of sale is retail |
| PRI_OurRefLoginName | Seller's login (our references in Winner Bizz) |
| SalespersonLastname | Seller's last name |
| SalespersonFirstname | Seller's first name |
| SalespersonExternalReference | External reference of the seller (when filled in) |
| PK_BIAlternativeID | Unique internal reference of an alternative |
| PRI_AlternativeID | Unique internal reference of an alternative |
| AlternativeContractNr | Contract number of an alternative (if used) |
| AlternativeCode | Reference of a contract as displayed in Winner Bizz |
| AlternativeName | Alternative name |
| AlternativeDateLastChange | Date of the last change for the alternative |
| AlternativeExternalReference | External reference of the alternative (if filled in) |
| AlternativeDateCreation | Date of creation of the alternative |
| AlternativeDateOffer | Date the quotation was sent |
| AlternativeDateOrder | Date of sending the customer order form |
| AlternativeDateOrderCnf | Date of sending the Customer order confirmation |
| AlternativeDateApprovedForOrder | Date of sales order approval |
| AlternativeDateCancellation | Date of cancellation of the customer order |
| AlternativeDateDelivery | Date of delivery (dd/mm/yyyy) |
| AlternativeWeekDelivery | Information if the delivery date is of type week. If the type is week, then the alternativeDateDelivery field contains the first day of the relevant week |
| AlternativeReqFrom | Date of beginning of the service "Prefered delivery from" (day) |
| AlternativeWeekReqFrom | Date of beginning of the service "Prefered delivery from" (week) |
| AlternativeDateReqTo | End date of the service "Prefered delivery to" (day) |
| AlternativeWeekReqTo | End date of the service "Prefered delivery to" (week) |
| AlternativeDateFinished | Date the file was closed |
| AlternativeCurrencyCode | Currency code used |
| AlternativeCurrencyRate | Exchange rate against the euro |
| AlternativeType | Type of alternative: 1= standard, 2= additional order PMC, 3= service order, 4= guarantee order, 5= additional order, 6= additional order FMC, building, 7= model, 8= contract |
| AlternativeSalesType | Sales type of the alternative: 1 = standard, 2 = retail, 3 = building, 4 = after sales |
| AlternativeStatus | Alternative status: 0 = Active, 1 = Pending, 2 = Completed, 3 = Lost, 4 = Abandoned, 5 = Definitely lost |
| AlternativeComment | Comment filled in at the level of the alternative |
| AlternativeAmendmentStatus | Amendment status of the alternative: 0 = No amendment requested, 1 = Amendment with price change detected, 2 = Free amendment detected, 3 = "No" amendment detected, 4 = Amendment with price change printed, 5 = Free amendment printed. |
| AlternativeControlStatus | Order control status: 0 = No control, 1 = Not good (correction by an inspector), 2 = Not good (correction by a salesman), 3 = Corrected, 4 = OK |
| ExcludeFromStatistic | Filled in if the alternative is excluded from the statistics |
| ExtraCostsExcludeFromProfitCalc | Include additional non-family costs in the calculation of profits |
| DateUpdatedBISynchAlternative | Date of the last update of this record in the BI |
| DateCreatedBISynchAlternative | Date of creation of this record in the BI |
| BIDeletedAlternative | Data deleted from the database (or not) |
| DeliveryName | Name of the delivery party |
| DeliveryAddress | Delivery address |
| DeliveryZipCode | Postcode |
| DeliveryCity | City |
| DeliveryCountry | Country |
| PK_BISalesContractVersionID | Internal unique reference |
| FK_BIAfterSalesID | Internal unique reference |
| VersionType | Version type |
| DateSalesVersion | Sales date of the version |
| DateConfirmation | Confirmation date |
| DateOrderControl | Date of order control |
| AlternativeDateOrderSign | Date of signature of the sales contract |
| AlternativeDateOrderCnfSign | Date of signature of the sales contract confirmation |
| DateSalesVersionSign | Date of signature of the sales contract if the alternative has undergone a technical adaptation with a price change, otherwise date of signature of the sales contract modification. |
| DateSalesVersionConfirmationSign | Date of signature of the sales contract if the option has undergone a technical adaptation with a price change, otherwise date of signature of the sales contract confirmation. |
| SequenceNr | Sequence number |
| AmendmentNr | Amendment number |
| DateUpdatedBISynchContract | Date of the last update of this record in the BI |
| DateCreatedBISynchContract | Date of creation of this record in the BI |
| BIDeletedContract | Data deleted from the database (or not) |
| SupplierId | Supplier ID |
| SupplierName | Supplier's name |
| ModelName | Model name |
| FrontPanel | Front panel |
| CatalogueName | Catalogue name |
| ExcludeFromProfitCalc | Exclude from margin calculation |
| FromInstallationCatalogue | If the article comes from an installation catalogue (entered in the settings of the Winner Bizz works module) |
| DesignNr | Design number |
| FinishCode | Code of the items' finish |
| DesignQuantity | Quantity of design |
| DesignQuantityDelta | Difference in the design quantity in the contract compared to the previous version. Quantity is greater than 1 for building project |
| DateDeletion | Date of deletion |
| MainSupplierId | Supplier ID of the main model |
| MainSupplierName | Supplier's name of the main model |
| MainModelName | Name of the main model |
| MilieuName | Milieu name |
| ItemCode | Item code |
| ItemSerie | Item serie |
| ItemColor | Item color |
| ItemGroupName | Name of the article family to which the article belongs |
| ItemGroupSequence | Sequence number of the article family |
| ItemDescription | Item description |
| ItemUnit | Item unit |
| ItemVolume | Item volume |
| ItemWeight | Item weight |
| ItemAttrHinges | Item attribut hinges |
| ItemMainPos | Position in the quotation |
| ItemSubPos | Secondary position in the quotation |
| ItemProductGroupNr | Product group number |
| ItemProductGroupName | Product group name |
| DiscountPerItempc | % Discount at the item level |
| DiscountPerGrouppc | % Discount at item family level |
| DiscountGlobalpc | % Overall discount at the level of the alternative |
| SalesBlockName | Name of the sales block for this item |
| RecycleCostVatpc | VAT on the eco participation tax |
| RecycleCostsCode | Eco-participation tax code |
| RecycleCostsType | Knowing if the tax corresponds to the WEEE or the eco participation/furniture |
| AlternativeConditionsPurchasePrice | Purchase price of the alternative |
| AlternativeConditionsPurchasePriceDelta | Difference from the previous version of the contract of the purchase price of the alternative |
| ItemQuantity | Quantity of the material in the contract |
| ItemQuantityDelta | Difference in the quantity of the material in the contract compared to the previous version. The first version of the contract contains the quantity of the material. If the quantity is negative it means that the quantity has been deleted from the contract. |
| PointPrice | Price in points of the item in the contract |
| PointPriceDelta | The difference in the price in points of the item in the contract compared to the previous version. |
| PriceExVat | Sales price excluding VAT in the contract |
| PriceExVatDelta | Difference in the sales price excluding VAT in the contract compared to the previous version. The value may be negative if the price of the item has been lowered or deleted |
| RoundOffExVat | Rounding of the sales price excluding VAT in the contract |
| RoundOffExVatDelta | Difference in the rounding of the sales price excluding VAT in the contract compared to the previous version. |
| BlockDiscSalesPriceExVat | Sales set discount in the contract |
| BlockDiscSalesPriceExVatDelta | Difference of the sales set discount in the contract compared to the previous version. |
| DiscountPerItem | Amount of the discounts per item |
| DiscountPerItemDelta | Amount of the difference in discounts per item |
| DiscountPerGroup | Amount of the discounts at the item family level |
| DiscountPerGroupDelta | Amount of the difference in discounts at the item family level |
| DiscountGlobal | Amount of the global discount at the alternative level |
| DiscountGlobalDelta | Amount of the difference of the global discount at the alternative level |
| AlternativeConditionsExVat | Amount before tax of the alternative conditions |
| AlternativeConditionsExVatDelta | Difference between the amount before tax of the alternative conditions and the previous version of the contract |
| AlternativeConditionsIncVat | Amount including VAT of the conditions of the alternative |
| AlternativeConditionsIncVatDelta | Difference between the amount including VAT of the conditions of the alternative compared to the previous version of the contract |
| CostPriceExVat | Purchase price of the item before tax |
| CostPriceExVatDelta | The difference in the purchase price of the item before tax compared to the previous version of the contract. |
| BlockDiscPurchasePriceExVat | Purchase set discount in the contract |
| BlockDiscPurchasePriceExVatDelta | Difference in the purchase set discount in the contract compared to the previous version. |
| RecycleCostExVat | Cost before tax of the recycling fee |
| RecycleCostExVatDelta | Difference in the cost before tax of the recycling fee compared to the previous version of the contract. |
| SuggPriceExVAT | Catalogue purchase price (excluding VAT) of the item |
| SuggPriceExVATDelta | Difference in the catalogue purchase price (excluding VAT) of the item compared to the previous version of the contract |
| VATpc | % of the item's VAT |
| ProjectVATProfileName | Name of the VAT profile applied to the project |
| AlternativeVATProfileName | Name of the VAT profile applied to the alternative |
| DateUpdatedBISynchItemline | Date of the last update of this record in the BI |
| DateCreatedBISynchItemline | Date of the creation of this record in the BI |
| BIDeletedItemline | Date of the deletion of this record in the BI |
| PRI_FK_ItemLineHistoryID | Unique internal reference |
| PRI_FK_ItemlineID | Unique internal reference |
Comments
0 comments
Article is closed for comments.