SAP Table FTPS_CAR_RULE
Car Rental Rate Rule
FTPS_CAR_RULE (Car Rental Rate Rule) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FTPS_CAR_RULE to other SAP tables.
FTPS_CAR_RULE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| PROVIDER | Car Rental Provider | CAR_PROVIDER | CHAR | 3 | 0 | |||
| LOCATION | IATA location | IATA_LOCATION | CHAR | 3 | 0 | |||
| RATE_CATEGORY | CHAR | 20 | 0 | |||||
| RATE_PLAN | CHAR | 20 | 0 | |||||
| CAR_TYPE | CHAR | 4 | 0 | |||||
| OP_TIME_IN | CHAR | 40 | 0 | |||||
| OP_TIME_OUT | CHAR | 40 | 0 | |||||
| BASE_FARE | FTPS_CAR_FARE | STRU | 0 | 0 | ||||
| BASE_RATE | Car Rental Price Per Day/Week/Etc. | CAR_PRICE | CURR | 10 | 2 | |||
| EXTRA_MILES | Surcharge for Exceeding Miles/Kms Limit for Rental Car | CAR_EXTRA_MILAGE | CURR | 10 | 2 | |||
| FREE_MILES | Distance Restriction (miles/kilometers) | CAR_FREE_MILES | CHAR | 5 | 0 | |||
| CURRENCY | Currency | CAR_CURRENCY | CUKY | 5 | 0 | |||
| RATE_CODE | Rental Car Rate Key (Provider-Dependent) | CAR_RATECODE | CHAR | 12 | 0 | |||
| EXTRA_DAY_FARE | FTPS_CAR_FARE | STRU | 0 | 0 | ||||
| BASE_RATE | Car Rental Price Per Day/Week/Etc. | CAR_PRICE | CURR | 10 | 2 | |||
| EXTRA_MILES | Surcharge for Exceeding Miles/Kms Limit for Rental Car | CAR_EXTRA_MILAGE | CURR | 10 | 2 | |||
| FREE_MILES | Distance Restriction (miles/kilometers) | CAR_FREE_MILES | CHAR | 5 | 0 | |||
| CURRENCY | Currency | CAR_CURRENCY | CUKY | 5 | 0 | |||
| RATE_CODE | Rental Car Rate Key (Provider-Dependent) | CAR_RATECODE | CHAR | 12 | 0 | |||
| EXTRA_HOUR_FARE | FTPS_CAR_FARE | STRU | 0 | 0 | ||||
| BASE_RATE | Car Rental Price Per Day/Week/Etc. | CAR_PRICE | CURR | 10 | 2 | |||
| EXTRA_MILES | Surcharge for Exceeding Miles/Kms Limit for Rental Car | CAR_EXTRA_MILAGE | CURR | 10 | 2 | |||
| FREE_MILES | Distance Restriction (miles/kilometers) | CAR_FREE_MILES | CHAR | 5 | 0 | |||
| CURRENCY | Currency | CAR_CURRENCY | CUKY | 5 | 0 | |||
| RATE_CODE | Rental Car Rate Key (Provider-Dependent) | CAR_RATECODE | CHAR | 12 | 0 | |||
