ADP_SETUP |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| adp_setup_key | decimal (15,0) | |||
| adp_type | varchar (32) | |||
| project_key | decimal (15,0) | YES | PROJECT | fk_adp_setup1 |
| task_key | decimal (15,0) | YES | TASK | fk_adp_setup2 |
| pay_code_key | decimal (15,0) | YES | PAY_CODE | fk_adp_setup3 |
| adp_code | varchar (32) | YES | ||
| sign_field | varchar (1) | YES | ||
Check Constraints for ADP_SETUP |
|
| Check Constraint Name | Definition |
|---|---|
| cc_adp_setup_sign_field | (sign_field = 'N' or (sign_field = 'P')) |
Indexes on ADP_SETUP |
|
| Index Name | Column(s) |
|---|---|
| pk_adp_setup | adp_setup_key |