Name of the table: BIAlternatives
| Field names | Description |
| PK_BIAlternativeID | Internal unique reference |
| FK_BICompanyID | Internal unique reference |
| FK_BIAfterSalesID | Internal unique reference |
| 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 |
| CustomerCreationDate | 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 |
| 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) |
| 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 |
| 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 |
| DeliveryName | Name of the delivery party |
| DeliveryAddress | Delivery address |
| DeliveryZipCode | Postcode |
| DeliveryCity | City |
| DeliveryCountry | Country |
| 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) |
| AlternativeDateOrderSign | Date of sales contract signature |
| AlternativeDateOrderCnfSign | Date of sales contract confirmation signature |
| FinancingOfferName | Name of the financing offer template used for this alternative |
| FinancingOfferLoanAmount | Amount of the loan offer for the alternative |
| FinancingOfferLoanTerm | Term of the loan offer for the alternative |
| FinancingOfferNominalRate | Nominal rate of the loan offer for the alternative |
| FinancingOfferInsuranceRate | Insurance rate of the loan offer for the alternative |
| FinancingOfferAdministrativeFees | Administrative fees of the loan offer for the alternative |
| FinancingOfferExpirationDeadline | Expiration deadline of the loan offer for the alternative |
| PRI_CustomerID | Unique internal reference |
| AlternativeDateLastChange | Date of the last change for the alternative |
| ProjectVatProfileName | Name of the VAT profile applied to the project |
| AlternativeVatProfileName | Name of the VAT profile applied to the alternative |
| CustomerDateOfBirth | Customer date of birth |
Comments
0 comments
Article is closed for comments.