| Previous: po_format | Unanet Data Model | Next: po_item_line |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | po_key | decimal(15) | purchase_order | fk_po_format_options1 | |
| 2. | po_format_key | decimal(15) | po_format | fk_po_format_options2 | ||
| 3. | generate_po_form | char(1) | ('N') | |||
| 4. | bill_to_address_key | decimal(15) | customer_address | fk_po_format_options3 | ||
| 5. | ship_to_address_key | decimal(15) | customer_address | fk_po_format_options4 | ||
| 6. | remit_to_address_key | decimal(15) | customer_address | fk_po_format_options5 | ||
| 7. | bill_to_contact_key | decimal(15) | customer_contact | fk_po_format_options6 | ||
| 8. | ship_to_contact_key | decimal(15) | customer_contact | fk_po_format_options7 | ||
| 9. | remit_to_contact_key | decimal(15) | customer_contact | fk_po_format_options8 | ||
| 10. | delivery_option | char(1) | ||||
| 11. | email_template_key | decimal(15) | email_template | fk_po_format_options9 | ||
| 12. | to_email | varchar(255) | ||||
| 13. | cc_email | varchar(255) | ||||
| 14. | bcc_email | varchar(255) | ||||
| 15. | delivery_receipt_req | char(1) | ('N') | |||
| 16. | read_receipt_req | char(1) | ('N') | |||
| 17. | display_single | char(1) | ('N') | |||
| 18. | display_consol | char(1) | ('N') | |||
| 19. | display_consol_detail | char(1) | ('N') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| bill_to_address_key | customer_address | customer_address_key | fk_po_format_options3 |
| ship_to_address_key | customer_address | customer_address_key | fk_po_format_options4 |
| remit_to_address_key | customer_address | customer_address_key | fk_po_format_options5 |
| bill_to_contact_key | customer_contact | customer_contact_key | fk_po_format_options6 |
| ship_to_contact_key | customer_contact | customer_contact_key | fk_po_format_options7 |
| remit_to_contact_key | customer_contact | customer_contact_key | fk_po_format_options8 |
| email_template_key | email_template | email_template_key | fk_po_format_options9 |
| po_format_key | po_format | po_format_key | fk_po_format_options2 |
| po_key | purchase_order | po_key | fk_po_format_options1 |
| Name | Definition |
| cc_po_frmt_display_consol | ([display_consol]='N' OR [display_consol]='Y') |
| cc_po_frmt_display_consol_dtl | ([display_consol_detail]='N' OR [display_consol_detail]='Y') |
| cc_po_frmt_display_single | ([display_single]='N' OR [display_single]='Y') |
| cc_po_frmt_generate_po_form | ([generate_po_form]='N' OR [generate_po_form]='Y') |
| cc_po_frmt_opts_del_opt | ([delivery_option]='N' OR [delivery_option]='P' OR [delivery_option]='E') |
| cc_po_frmt_opts_del_rcpt_req | ([delivery_receipt_req]='N' OR [delivery_receipt_req]='Y') |
| cc_po_frmt_opts_read_rcpt_req | ([read_receipt_req]='N' OR [read_receipt_req]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_po_format_options | true | po_key | Asc |
| idx_po_format_options1 | false | po_format_key | Asc |
| idx_po_format_options2 | false | bill_to_address_key | Asc |
| idx_po_format_options3 | false | ship_to_address_key | Asc |
| idx_po_format_options4 | false | remit_to_address_key | Asc |
| idx_po_format_options5 | false | bill_to_contact_key | Asc |
| idx_po_format_options6 | false | ship_to_contact_key | Asc |
| idx_po_format_options7 | false | remit_to_contact_key | Asc |
| idx_po_format_options8 | false | email_template_key | Asc |