Skip to main content

L_CarFrameTypeTab

Written by Julien

Column Name

Description

Data Type

Length

Allow Nulls

Default

CFT_RID

ID-No. of the car frame
(ID-No.=RID number of the car frame)
consecutive number

Integer

4

0
​

CFT_DESC

Description of the car frame type

VarWChar

75

✓

CFT_SUB_DESC

Sub-description of the car frame. Used for more subdivision of the different car frame types.

VarWChar

75

✓

CFT_MF_RID

ID-No. of the manufacturer
​
ID-No.=RID number of the manufacturer (MF_RID)

Integer

4

✓

0
​

CFT_TYPE

ID-No. for the different kinds of car frames:

0 - Hydraulic lift - 1:1 - single hydraulic jack

1 - Hydraulic lift - 2:1 - single hydraulic jack

2 - Hydraulic lift - central - single hydraulic jack

3 - Hydraulic lift - 1:1 - double hydraulic jack

4 - Hydraulic lift - 2:1 - double hydraulic jack

5 - Hydraulic lift - central - double hydraulic jack

10 - Traction lift - 1:1

11 - Traction lift - 2:1 - 1 pulley top

12 - Traction lift - 2:1 - 2 pulleys top

13 - Traction lift - 2:1 - 2 pulleys bottom

14 - Traction lift - 4:1

Integer

4

✓

0
​

CFT_MODE

Integer

4

✓

0
​

Did this answer your question?