CAR_IDDefault Value: 0
EFFDTDefault Value: %date
Default Value: %date
CAR_DATA_NLD(SQL Table) |
Index Back |
|---|---|
Car Data NLDContains the attributes about a company car specific to the Netherlands. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAR_ID |
Character(7) | VARCHAR2(7) NOT NULL |
Car Identification Number used in Administer Company Cars module.
Default Value: 0 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | CONTRACT_BEGIN_DT | Date(10) | DATE |
Contract Begin Date
Default Value: %date |
| 4 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 5 | FISCAL_AMT_NLD | Number(11,2) | DECIMAL(10,2) NOT NULL | Track the fiscal value for a company car in the Netherlands. |