Table: vendor_org

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK vendor_org_key decimal(15)      
2.   customer_key decimal(15)   customer fk_vendor_org1
3.   legal_entity_key decimal(15)   customer fk_vendor_org2
4.   payment_term_key decimal(15)   payment_term fk_vendor_org3
5.   active char(1) ('Y')    
6.   account_number varchar(40)      
7.   separate_payment char(1) ('N')    
8.   payee_name varchar(255)      
9.   payment_on_hold char(1) ('N')    
10.   hold_reason varchar(255)      
11.   user01 varchar(128)      
12.   user02 varchar(128)      
13.   user03 varchar(128)      
14.   user04 varchar(128)      
15.   user05 varchar(128)      
16.   user06 varchar(128)      
17.   user07 varchar(128)      
18.   user08 varchar(128)      
19.   user09 varchar(128)      
20.   user10 varchar(128)      
Foreign Keys
Column References Foreign Key Name
Table Column
customer_key customer customer_key fk_vendor_org1
legal_entity_key customer customer_key fk_vendor_org2
payment_term_key payment_term payment_term_key fk_vendor_org3
Check Constraints
Name Definition
cc_vendor_active ([active]='N' OR [active]='Y')
cc_vendor_payment_on_hold ([payment_on_hold]='N' OR [payment_on_hold]='Y')
cc_vendor_separate_payment ([separate_payment]='N' OR [separate_payment]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_vendor_org true vendor_org_key Asc
idx_vendor_org1 false customer_key Asc
idx_vendor_org2 false legal_entity_key Asc