Table: customer

Previous: currency Unanet Data Model Next: customer_account
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK customer_key decimal(15)      
2.   customer_code varchar(25)      
3.   customer_name varchar(128)      
4.   customer_type_key decimal(15)   customer_type fk_customer1
5.   customer_size int      
6.   account_number varchar(25)      
7.   sic_code varchar(10)      
8.   classification varchar(25)      
9.   industry varchar(64)      
10.   sector varchar(64)      
11.   stock_symbol varchar(10)      
12.   url varchar(128)      
13.   active char(1) ('Y')    
14.   financial_org char(1) ('N')    
15.   legal_entity char(1) ('N')    
16.   legal_entity_key decimal(15)   customer fk_customer2
17.   default_gl_post_org_key decimal(15)   customer fk_customer3
18.   entry_allowed char(1) ('N')    
19.   begin_date datetime      
20.   end_date datetime      
21.   user01 varchar(128)      
22.   user02 varchar(128)      
23.   user03 varchar(128)      
24.   user04 varchar(128)      
25.   user05 varchar(128)      
26.   user06 varchar(128)      
27.   user07 varchar(128)      
28.   user08 varchar(128)      
29.   user09 varchar(128)      
30.   user10 varchar(128)      
31.   recipient_name_1099 varchar(128)      
32.   vendor_1099 char(1) ('N')    
33.   federal_tax_id char(9)      
34.   federal_tax_id_type tinyint      
35.   email_1099 varchar(255)      
36.   last_project_code_seq decimal(15) ((0))    
37.   start_with_project_code_seq decimal(15) ((1))    
38.   user11 varchar(128)      
39.   user12 varchar(128)      
40.   user13 varchar(128)      
41.   user14 varchar(128)      
42.   user15 varchar(128)      
43.   user16 varchar(128)      
44.   user17 varchar(128)      
45.   user18 varchar(128)      
46.   user19 varchar(128)      
47.   user20 varchar(128)      
Foreign Keys
Column References Foreign Key Name
Table Column
legal_entity_key customer customer_key fk_customer2
default_gl_post_org_key customer customer_key fk_customer3
customer_type_key customer_type customer_type_key fk_customer1
Referenced from
Table Column Foreign Key Name
acct_org_access_hierarchy customer_key fk_acct_org_access_hierarchy2
acct_org_access_parent customer_key fk_acct_org_access_parent2
adp_organization organization_key fk_adp_organization
bank_account customer_key fk_bank_account2
bank_reconciliation legal_entity_key fk_bank_rec1
budget legal_entity_key fk_budget2
budget_organization customer_key fk_budget_organization2
cost_pool_basis customer_key fk_cost_pool_basis3
cost_pool_basis post_customer_key fk_cost_pool_basis5
cost_pool_basis_calc customer_key fk_cost_pool_basis_calc3
cost_pool_basis_calc post_customer_key fk_cost_pool_basis_calc5
cost_pool_group legal_entity_key fk_cost_pool_group1
cost_pool_source customer_key fk_cost_pool_source3
cost_pool_source post_customer_key fk_cost_pool_source5
cost_pool_source_calc customer_key fk_cost_pool_source_calc3
cost_pool_source_calc post_customer_key fk_cost_pool_source_calc5
customer default_gl_post_org_key fk_customer3
customer legal_entity_key fk_customer2
customer_account customer_key fk_customer_account1
customer_address customer_key fk_customer_address1
customer_assignment customer_key fk_customer_assignment1
customer_attachment customer_key fk_customer_attachment1
customer_contact customer_key fk_customer_contact1
customer_org customer_key fk_customer_org1
customer_org legal_entity_key fk_customer_org2
customer_payment customer_org_key fk_customer_payment2
customer_payment organization_key fk_customer_payment9
customer_payment_unapplied organization_key fk_customer_payment_unapplied2
deposit organization_key fk_deposit4
fin_document legal_entity_key fk_fin_document1
fin_document_detail customer_key fk_fin_document_detail6
fin_document_detail organization_key fk_fin_document_detail3
fin_document_detail_expense gl_customer_key fk_fin_doc_detail_expense5
fin_document_detail_item gl_customer_key fk_fin_doc_detail_item6
fin_document_detail_labor gl_customer_key fk_fin_doc_detail_labor5
fiscal_month_org_feature_close customer_key fk_fm_org_feature_close2
fiscal_year_org_close customer_key fk_fiscal_year_org_close2
general_ledger customer_key fk_general_ledger6
general_ledger organization_key fk_general_ledger3
invoice billed_organization_key fk_invoice10
invoice customer_key fk_invoice9
journal_cost_plus_detail organization_key fk_journal_cost_plus_detail6
journal_document_expense organization_key fk_journal_document_expense6
journal_document_item organization_key fk_journal_document_item6
journal_document_labor organization_key fk_journal_document_labor6
journal_expense organization_key fk_journal_expense6
journal_fee_cap_adjustment organization_key fk_journal_fee_cap_adjust6
journal_fixed_price organization_key fk_journal_fixed_price6
journal_funding_cap_adjustment organization_key fk_journal_funding_cap_adj6
journal_onetime_charge organization_key fk_journal_onetime_charge4
journal_prebilled_labor organization_key fk_journal_prebilled_labor6
journal_time organization_key fk_journal_time6
org_access_hierarchy customer_key fk_org_access_hierarchy2
org_access_legal_entity customer_key fk_org_access_legal_entity2
org_access_parent customer_key fk_org_access_parent2
org_cost_pool_tree node_key fk_org_cost_pool_tree1
org_cost_pool_tree parent_key fk_org_cost_pool_tree2
org_fin_tree node_key fk_org_fin_tree1
org_fin_tree parent_key fk_org_fin_tree2
org_tree node_key fk_org_tree1
org_tree parent_key fk_org_tree2
person customer_key fk_person3
person expense_vendor_key fk_person16
person time_vendor_key fk_person15
person_time_data bill_customer fk_person_time_data6
person_time_data cost_customer fk_person_time_data7
po_expense_line_descriptor organization_key fk_po_expense_line_descr5
po_item_line_descriptor organization_key fk_po_item_line_descr5
po_labor_line_descriptor organization_key fk_po_labor_line_descr5
pr_expense_line_descriptor organization_key fk_pr_expense_line_descr4
pr_item_line_descriptor organization_key fk_pr_item_line_descr4
pr_labor_line_descriptor organization_key fk_pr_labor_line_descr4
project customer_key fk_project1
project owning_customer_key fk_project6
project_assignment bill_customer fk_project_assignment3
project_assignment cost_customer fk_project_assignment4
purchase_order legal_entity_key fk_purchase_order1
purchase_order owning_org_key fk_purchase_order4
purchase_order vendor_org_key fk_purchase_order5
purchase_requisition legal_entity_key fk_purchase_request1
purchase_requisition owning_org_key fk_purchase_request10
purchase_requisition vendor_org_key fk_purchase_request6
shared_document customer_key fk_shared_document6
shared_document document_org_key fk_shared_document2
shared_document legal_entity_key fk_shared_document1
shared_document organization_key fk_shared_document8
shared_document vendor_key fk_shared_document7
task owning_customer_key fk_task5
task_assignment bill_customer fk_task_assignment3
task_assignment cost_customer fk_task_assignment4
vendor_invoice organization_key fk_vendor_invoice5
vendor_invoice vendor_org_key fk_vendor_invoice2
vendor_org customer_key fk_vendor_org1
vendor_org legal_entity_key fk_vendor_org2
vendor_payment organization_key fk_vendor_payment8
vendor_payment vendor_org_key fk_vendor_payment1
vendor_payment_unapplied organization_key fk_vendor_payment_unapplied2
vi_funding_cap_adjustment organization_key fk_vi_funding_cap_adjustment7
vi_included_expense organization_key fk_vi_included_expense4
vi_included_time organization_key fk_vi_included_time4
Check Constraints
Name Definition
cc_customer_active ([active]='N' OR [active]='Y')
cc_customer_begin_date ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_customer_end_date ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
cc_customer_entry_allowed ([entry_allowed]='N' OR [entry_allowed]='Y')
cc_customer_fed_tax_id_type ([federal_tax_id_type]='3' OR [federal_tax_id_type]='2' OR [federal_tax_id_type]='1')
cc_customer_financial_org ([financial_org]='N' OR [financial_org]='Y')
cc_customer_legal_entity ([legal_entity]='N' OR [legal_entity]='Y')
cc_customer_vendor_1099 ([vendor_1099]='N' OR [vendor_1099]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_customer true customer_key Asc
idx_customer1 true customer_code Asc
idx_customer2 false legal_entity_key Asc
idx_customer3 false customer_type_key Asc
idx_customer4 false default_gl_post_org_key Asc
Dependent Views
View Name
access_customer_view
assignment_view
expense_budget_view
journal_view
vendor_payment_1099_view