Table: po_format

Previous: po_expense_line_descriptor Unanet Data Model Next: po_format_options
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK po_format_key decimal(15)      
2.   name varchar(50)      
3.   description varchar(128)      
4.   active char(1)      
5.   image_setup_key decimal(15)   image_setup fk_po_fmt_fk_img
6.   signer_key decimal(15)   person fk_po_fmt_signer_key
7.   po_header_description varchar(128)      
8.   summary_proj_show_org_code char(1) ('N')    
9.   summary_proj_show_code char(1) ('N')    
10.   summary_proj_show_title char(1) ('N')    
11.   summary_task_show_number char(1) ('N')    
12.   summary_task_show_name char(1) ('N')    
13.   detail_proj_show_org_code char(1) ('N')    
14.   detail_proj_show_code char(1) ('N')    
15.   detail_proj_show_title char(1) ('N')    
16.   detail_task_show_number char(1) ('N')    
17.   detail_task_show_name char(1) ('N')    
18.   show_external_comments char(1) ('N')    
19.   show_user01 char(1) ('N')    
20.   show_user02 char(1) ('N')    
21.   show_user03 char(1) ('N')    
22.   show_user04 char(1) ('N')    
23.   show_user05 char(1) ('N')    
24.   show_user06 char(1) ('N')    
25.   show_user07 char(1) ('N')    
26.   show_user08 char(1) ('N')    
27.   show_user09 char(1) ('N')    
28.   show_user10 char(1) ('N')    
29.   show_user11 char(1) ('N')    
30.   show_user12 char(1) ('N')    
31.   show_user13 char(1) ('N')    
32.   show_user14 char(1) ('N')    
33.   show_user15 char(1) ('N')    
34.   show_user16 char(1) ('N')    
35.   show_user17 char(1) ('N')    
36.   show_user18 char(1) ('N')    
37.   show_user19 char(1) ('N')    
38.   show_user20 char(1) ('N')    
Foreign Keys
Column References Foreign Key Name
Table Column
image_setup_key image_setup image_setup_key fk_po_fmt_fk_img
signer_key person person_key fk_po_fmt_signer_key
Referenced from
Table Column Foreign Key Name
po_format_options po_format_key fk_po_format_options2
Check Constraints
Name Definition
cc_po_fmt_active ([active]='N' OR [active]='Y')
cc_po_fmt_d_proj_code ([detail_proj_show_code]='N' OR [detail_proj_show_code]='Y')
cc_po_fmt_d_proj_org_code ([detail_proj_show_org_code]='N' OR [detail_proj_show_org_code]='Y')
cc_po_fmt_d_proj_title ([detail_proj_show_title]='N' OR [detail_proj_show_title]='Y')
cc_po_fmt_d_task_name ([detail_task_show_name]='N' OR [detail_task_show_name]='Y')
cc_po_fmt_d_task_number ([detail_task_show_number]='N' OR [detail_task_show_number]='Y')
cc_po_fmt_external_comments ([show_external_comments]='N' OR [show_external_comments]='Y')
cc_po_fmt_s_proj_code ([summary_proj_show_code]='N' OR [summary_proj_show_code]='Y')
cc_po_fmt_s_proj_org_code ([summary_proj_show_org_code]='N' OR [summary_proj_show_org_code]='Y')
cc_po_fmt_s_proj_title ([summary_proj_show_title]='N' OR [summary_proj_show_title]='Y')
cc_po_fmt_s_task_name ([summary_task_show_name]='N' OR [summary_task_show_name]='Y')
cc_po_fmt_s_task_number ([summary_task_show_number]='N' OR [summary_task_show_number]='Y')
cc_po_fmt_s_user01 ([show_user01]='N' OR [show_user01]='Y')
cc_po_fmt_s_user02 ([show_user02]='N' OR [show_user02]='Y')
cc_po_fmt_s_user03 ([show_user03]='N' OR [show_user03]='Y')
cc_po_fmt_s_user04 ([show_user04]='N' OR [show_user04]='Y')
cc_po_fmt_s_user05 ([show_user05]='N' OR [show_user05]='Y')
cc_po_fmt_s_user06 ([show_user06]='N' OR [show_user06]='Y')
cc_po_fmt_s_user07 ([show_user07]='N' OR [show_user07]='Y')
cc_po_fmt_s_user08 ([show_user08]='N' OR [show_user08]='Y')
cc_po_fmt_s_user09 ([show_user09]='N' OR [show_user09]='Y')
cc_po_fmt_s_user10 ([show_user10]='N' OR [show_user10]='Y')
cc_po_fmt_s_user11 ([show_user11]='N' OR [show_user11]='Y')
cc_po_fmt_s_user12 ([show_user12]='N' OR [show_user12]='Y')
cc_po_fmt_s_user13 ([show_user13]='N' OR [show_user13]='Y')
cc_po_fmt_s_user14 ([show_user14]='N' OR [show_user14]='Y')
cc_po_fmt_s_user15 ([show_user15]='N' OR [show_user15]='Y')
cc_po_fmt_s_user16 ([show_user16]='N' OR [show_user16]='Y')
cc_po_fmt_s_user17 ([show_user17]='N' OR [show_user17]='Y')
cc_po_fmt_s_user18 ([show_user18]='N' OR [show_user18]='Y')
cc_po_fmt_s_user19 ([show_user19]='N' OR [show_user19]='Y')
cc_po_fmt_s_user20 ([show_user20]='N' OR [show_user20]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_po_format true po_format_key Asc
idx_po_format1 true name Asc