CO_DED_MER_TAO (SQL Table)	Index Back
Deduction temp table Temp Table is used in the extract process for the Discounts and Perks integration with Payroll.

CO_DED_MER_TAO

(SQL Table)

Deduction temp table

Temp Table is used in the extract process for the Discounts and Perks integration with Payroll.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID

2 SUPP_FILE_ID Character(10) VARCHAR2(10) NOT NULL The field contains information to denote if the flat file is inbound or outbound and the value is unqiue for each inbound or outbound flat file. The field also contains the first 3 characters of the MerchantID and the last file identifier number.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MERCHANTID	Character(30)	VARCHAR2(30) NOT NULL	Merchant ID
2	SUPP_FILE_ID	Character(10)	VARCHAR2(10) NOT NULL	The field contains information to denote if the flat file is inbound or outbound and the value is unqiue for each inbound or outbound flat file. The field also contains the first 3 characters of the MerchantID and the last file identifier number.