Table: prebilled_labor

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK prebilled_labor_key decimal(15)      
2.   project_key decimal(15)   project fk_prebilled_labor1
3.   post_history_key decimal(15)   post_history fk_prebilled_labor2
4.   invoice_key decimal(15)   invoice fk_prebilled_labor3
5.   bill_date datetime      
6.   description varchar(128)      
7.   amount decimal(18,3)      
Foreign Keys
Column References Foreign Key Name
Table Column
invoice_key invoice invoice_key fk_prebilled_labor3
post_history_key post_history post_history_key fk_prebilled_labor2
project_key project project_key fk_prebilled_labor1
Referenced from
Table Column Foreign Key Name
invcd_prebilled_labor prebilled_labor_key fk_invcd_prebilled_labor2
journal_prebilled_labor prebilled_labor_key fk_journal_prebilled_labor1
Check Constraints
Name Definition
cc_prebilled_labor_bill_date ([bill_date]>='1900-01-01' AND [bill_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_prebilled_labor true prebilled_labor_key Asc
idx_prebilled_labor1 false project_key Asc
idx_prebilled_labor2 false invoice_key Asc
idx_prebilled_labor3 false post_history_key Asc
Dependent Views
View Name
journal_view