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)
21.		user11	varchar(128)
22.		user12	varchar(128)
23.		user13	varchar(128)
24.		user14	varchar(128)
25.		user15	varchar(128)
26.		user16	varchar(128)
27.		user17	varchar(128)
28.		user18	varchar(128)
29.		user19	varchar(128)
30.		user20	varchar(128)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
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