Table: invcd_time
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
invoice_key |
decimal(15) |
|
invoice |
fk_invcd_time1 |
| 2. |
PK |
time_data_key |
decimal(15) |
|
person_time_data |
fk_invcd_time2 |
| 3. |
|
writeoff_amount |
decimal(18,2) |
|
|
|
| 4. |
|
writeoff_quantity |
decimal(15,2) |
|
|
|
| 5. |
|
writeoff_bill_rate |
decimal(15,5) |
|
|
|
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| invoice_key |
invoice |
invoice_key |
fk_invcd_time1 |
| time_data_key |
person_time_data |
time_data_key |
fk_invcd_time2 |
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_invcd_time |
true |
invoice_key |
Asc |
| |
|
time_data_key |
|
| idx_invcd_time1 |
false |
time_data_key |
Asc |