Name of the table: BIAfterSales
| Field names | Description |
| PK_BIAfterSalesID | Internal unique reference |
| FK_BIAlternativeID | Internal unique reference |
| DateCreation | Date of creation of the after sales |
| AfterSalesCause | Property of an After Sales Service (free field) |
| AfterSalesProblemType | Property of an After Sales Service (free field) |
| ComplaintNr | After-sales service number |
| ComplaintStatus | After Sales Service status: 1 = not processed; 2 = accepted - not resolved; 3 = accepted - resolved; 4 = not accepted |
| AfterSalesType | Type of after-sales service: 1 = household appliances; 2 = furniture and sanitary facilities |
| AfterSalesCategory | Service category: 1 = After sales service, 2 = Guarantee, 3 = Extra |
| DateSolved | Resolution date |
| FinancialAgreement | Status of the financial agreement |
| DateFinancialAgreement | Date of processing of the financial agreement |
| DateConfirmation | Confirmation of processing date |
| DateRefusal | Date of refusal of treatment |
| AuthorLoginName | Which user created the after-sales service (login) |
| AuthorLastname | Last name of the user who created the after-sales service |
| AuthorFirstname | First name of the user who created the after-sales service |
| DateUpdatedBISynchAfterSales | Date of the last update of this record in the BI |
| DateCreatedBISynchAfterSales | Date of creation of this record in the BI |
| BIDeletedAfterSales | Data deleted from the database (or not) |
Comments
0 comments
Article is closed for comments.