May 2017
Intermediate to advanced
442 pages
11h 55m
English
In this section, we will create a main table, similar to the customer table. The steps are similar to the vehicle group, and we will abbreviate some of the steps we have already done. The pattern described in this recipe can be applied to any main table using your own data types.
The table in this example will be to store vehicle details. The table design will be as follows:
|
Field |
Type |
Size |
EDT (: indicates extends) |
|
VehicleId |
String |
20 |
ConWHSVehicleId : Num |
|
VehicleGroupId |
String |
10 |
ConWHSVehicleGroupId |
|
RegNum |
String |
10 |
ConWHSVehRegNum |
|
AcquiredDate |
Date |
ConWHSAcquiredDate : TransDate |
Read now
Unlock full access