| Previous: project_fee | Unanet Data Model | Next: project_invoice_addl_fmt |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | project_key | decimal(15) | project | fk_project_invoice1 | |
| 2. | invoice_option | char(1) | ('S') | |||
| 3. | invoice_format_key | decimal(15) | invoice_format | fk_project_invoice2 | ||
| 4. | payment_term_key | decimal(15) | payment_term | fk_project_invoice3 | ||
| 5. | generate_invoice | char(1) | ('N') | |||
| 6. | invoice_number_key | decimal(15) | invoice_number | fk_project_invoice4 | ||
| 7. | company_logo | decimal(15) | image_setup | fk_project_invoice5 | ||
| 8. | contract_number | varchar(25) | ||||
| 9. | order_number | varchar(25) | ||||
| 10. | description | varchar(2000) | ||||
| 11. | memo | varchar(2000) | ||||
| 12. | show_proj_org_code | char(1) | ('N') | |||
| 13. | show_proj_code | char(1) | ('N') | |||
| 14. | show_proj_title | char(1) | ('N') | |||
| 15. | show_proj_funded_value | char(1) | ('N') | |||
| 16. | show_company_logo | char(1) | ('N') | |||
| 17. | show_contract_number | char(1) | ('N') | |||
| 18. | show_order_number | char(1) | ('N') | |||
| 19. | bill_to_address_key | decimal(15) | customer_address | fk_project_invoice6 | ||
| 20. | bill_to_contact_key | decimal(15) | customer_contact | fk_project_invoice7 | ||
| 21. | remit_to_address_key | decimal(15) | customer_address | fk_project_invoice8 | ||
| 22. | remit_to_contact_key | decimal(15) | customer_contact | fk_project_invoice9 | ||
| 23. | ship_to_address_key | decimal(15) | customer_address | fk_project_invoice10 | ||
| 24. | ship_to_contact_key | decimal(15) | customer_contact | fk_project_invoice11 | ||
| 25. | delivery_option | char(1) | ||||
| 26. | email_template_key | decimal(15) | email_template | fk_project_invoice12 | ||
| 27. | to_email | varchar(255) | ||||
| 28. | cc_email | varchar(255) | ||||
| 29. | bcc_email | varchar(255) | ||||
| 30. | delivery_receipt_req | char(1) | ('N') | |||
| 31. | read_receipt_req | char(1) | ('N') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| bill_to_address_key | customer_address | customer_address_key | fk_project_invoice6 |
| remit_to_address_key | customer_address | customer_address_key | fk_project_invoice8 |
| ship_to_address_key | customer_address | customer_address_key | fk_project_invoice10 |
| ship_to_contact_key | customer_contact | customer_contact_key | fk_project_invoice11 |
| remit_to_contact_key | customer_contact | customer_contact_key | fk_project_invoice9 |
| bill_to_contact_key | customer_contact | customer_contact_key | fk_project_invoice7 |
| email_template_key | email_template | email_template_key | fk_project_invoice12 |
| company_logo | image_setup | image_setup_key | fk_project_invoice5 |
| invoice_format_key | invoice_format | invoice_format_key | fk_project_invoice2 |
| invoice_number_key | invoice_number | invoice_number_key | fk_project_invoice4 |
| payment_term_key | payment_term | payment_term_key | fk_project_invoice3 |
| project_key | project | project_key | fk_project_invoice1 |
| Name | Definition |
| cc_pi_delivery_receipt_req | ([delivery_receipt_req]='N' OR [delivery_receipt_req]='Y') |
| cc_pi_generate_invoice | ([generate_invoice]='N' OR [generate_invoice]='Y') |
| cc_pi_invoice_option | ([invoice_option]='C' OR [invoice_option]='L' OR [invoice_option]='S') |
| cc_pi_read_receipt_req | ([read_receipt_req]='N' OR [read_receipt_req]='Y') |
| cc_pi_show_company_logo | ([show_company_logo]='N' OR [show_company_logo]='Y') |
| cc_pi_show_contract_number | ([show_contract_number]='N' OR [show_contract_number]='Y') |
| cc_pi_show_order_number | ([show_order_number]='N' OR [show_order_number]='Y') |
| cc_pi_show_proj_code | ([show_proj_code]='N' OR [show_proj_code]='Y') |
| cc_pi_show_proj_funded_value | ([show_proj_funded_value]='N' OR [show_proj_funded_value]='Y') |
| cc_pi_show_proj_org_code | ([show_proj_org_code]='N' OR [show_proj_org_code]='Y') |
| cc_pi_show_proj_title | ([show_proj_title]='N' OR [show_proj_title]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_project_invoice | true | project_key | Asc |