Column Name | Description | Data Type | Length | Allow Nulls | Default |
GP_RID | RID number of the performance record set of the gear | Integer | 4 |
| 0 |
GP_GRP | Number of the performance group of the gear | Integer | 4 | ✓ | 0 |
GP_IX | Counter for the quantity of the performance records for the same type of gear | SmallInt | 2 | ✓ | 0 |
GP_DESC | Description of the performance record of the gear | VarWChar | 50 | ✓ |
|
GP_ETA | Efficiency of the gear in η (Eta) | Double | 9 | ✓ | 0 |
GP_V | Speed of the rope in m/s | Double | 9 | ✓ | 0 |
GP_PU_DIA | Diameter of the pulley | Double | 9 | ✓ | 0 |
GP_RATIO_1 | Ratio 1 of the gear | Double | 9 | ✓ | 0 |
GP_RATIO_2 | Ratio 2 of the gear | Double | 9 | ✓ | 0 |
GP_RATIO_TEXT | Ratio as a string variable for selection purposes (e.g. "35:1") | VarWChar | 50 | ✓ |
|
GP_N | Number of revolution in R.P.M. | Double | 9 | ✓ | 0 |
GP_P | Power of the motor in kW | Double | 9 | ✓ | 0 |
GP_F_UTR | Required force at the pulley in daN | Double | 9 | ✓ | 0 |
GP_L_TOTAL | Summary length of the gear | Double | 9 | ✓ | 0 |
GP_POLES | Quantity of the poles | Integer | 4 | ✓ | 0 |
GP_HZ | Frequency of the motor in Hertz | Integer | 4 | ✓ | 0 |
GP_USER_PG_50 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_51 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_52 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_53 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_54 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_55 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_56 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_57 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_58 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_59 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_60 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_61 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_62 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_63 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_64 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_65 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_66 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_67 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_68 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_69 |
| Double | 9 | ✓ | 0 |
GP_PART_NO |
| VarWChar | 50 | ✓ |
|
GP_USER_PG_70 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_71 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_72 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_73 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_74 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_75 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_76 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_77 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_78 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_79 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_80 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_81 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_82 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_83 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_84 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_85 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_86 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_87 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_88 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_89 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_90 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_91 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_92 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_93 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_94 |
| Double | 9 | ✓ | 0 |
GP_USER_PG_95 |
| Double | 9 | ✓ | 0 |
GP_USER_S0 |
| Double | 9 | ✓ | 0 |
GP_USER_S1 |
| Double | 9 | ✓ | 0 |
GP_USER_S2 |
| Double | 9 | ✓ | 0 |
GP_EXT_Z_TOP | Distance between the top of the gear and the center point of the pulley in z-direction | Double | 9 | ✓ | 0 |
GP_EXT_XL | Distance between the left side of the gear and the center point of the pulley in x-direction | Double | 9 | ✓ | 0 |
GP_EXT_XR | Distance between the right side of the gear and the center point of the pulley in x-direction | Double | 9 | ✓ | 0 |
GP_EXT_YL | Distance between the left side of the gear and the center point of the pulley in y-direction | Double | 9 | ✓ | 0 |
GP_EXT_YR | Distance between the right side of the gear and the center point of the pulley in y-direction | Double | 9 | ✓ | 0 |
L_GearPerformanceTab
Written by Julien
