Principle |
  
|
Principle |
|
Here is an example of data hosted in QDV7 databases. Prices / Rebates are considered generic. They don't take the context into account.
Description |
Reference |
Family |
Unit |
Cost per unit |
Currency |
Kind ID |
Rebate |
Interpact Ins80 Yellow |
01109 |
0d |
u |
85,07 |
EUR |
LVSWITCH |
62,00 |
Command Std Black Ns80 |
01225 |
0d |
u |
53,96 |
EUR |
LVSWITCH |
62,00 |
Circuit Breaker C60n Tri 1 A |
03204 |
0b |
u |
83,93 |
EUR |
LVSWITCH |
62,00 |
C60n Bi 1 A C |
03220 |
0b2042 |
u |
51,84 |
EUR |
LVSWITCH |
62,00 |
Distribloc 125 A |
03243 |
0q |
u |
48,05 |
EUR |
LVSWITCH |
62,00 |
Dpn Vigi Uni + N 10 A 30 Ma |
03401 |
0b3022 |
u |
117,79 |
EUR |
LVSWITCH |
62,00 |
The context is represented by the global variables of the estimate:
The Custom_Articles function reads a contextual database and return to the article passed to the function a contextual Cost per unit, a Rebate and a Currency according to values of global variables GLV_Business and GLV_Country.
For this purpose the program has a function which is called by QDV7. This function passes data from the calling-database-row and estimate context which are global-variables and their values.
From within the function, you can write to any field of the image of the database row.
The function is called each time the database is involved. Whether you want to insert an article from it to an estimate or to update an article from it being already used in an estimate. This means you can change context variables and update your estimate so that data match the new context.