Previous: prebill_invc_sect_fmt | Unanet Data Model | Next: proficiency |
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) |
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 |
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 |
Name | Definition |
cc_prebilled_labor_bill_date | ([bill_date]>='1900-01-01' AND [bill_date]<='2099-12-31') |
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 |
View Name |
journal_view |