Table: pay_code_mapping

Previous: pay_code_account

Unanet Data Model

Next: pay_code_rate

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	pay_code_mapping_key	decimal(15)
2.		pay_code_key	decimal(15)		pay_code	fk_pay_code_mapping1
3.		external_code	varchar(15)
4.		filter	decimal(1)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
pay_code_key	pay_code	pay_code_key	fk_pay_code_mapping1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_pay_code_mapping	true	pay_code_mapping_key	Asc