Table: customer_org

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK customer_org_key decimal(15)      
2.   customer_key decimal(15)   customer fk_customer_org1
3.   legal_entity_key decimal(15)   customer fk_customer_org2
4.   payment_term_key decimal(15)   payment_term fk_customer_org3
5.   active char(1) ('Y')    
6.   user01 varchar(128)      
7.   user02 varchar(128)      
8.   user03 varchar(128)      
9.   user04 varchar(128)      
10.   user05 varchar(128)      
11.   user06 varchar(128)      
12.   user07 varchar(128)      
13.   user08 varchar(128)      
14.   user09 varchar(128)      
15.   user10 varchar(128)      
Foreign Keys
Column References Foreign Key Name
Table Column
customer_key customer customer_key fk_customer_org1
legal_entity_key customer customer_key fk_customer_org2
payment_term_key payment_term payment_term_key fk_customer_org3
Check Constraints
Name Definition
cc_customer_org_active ([active]='N' OR [active]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_customer_org true customer_org_key Asc
idx_customer_org1 false customer_key Asc
idx_customer_org2 false legal_entity_key Asc
idx_customer_org3 false payment_term_key Asc