CO_DED_SUPP_TBL (SQL Table)	Index Back
Deduction Supplier Table The table contains data on each Supplier who will receive outbound deduction data.

CO_DED_SUPP_TBL

(SQL Table)

Deduction Supplier Table

The table contains data on each Supplier who will receive outbound deduction data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SITE_NBR Character(6) VARCHAR2(6) NOT NULL This field is edused to group employee based on their paygroup and pay frequency. The value for this field is assigned by the Supplier.

3 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

4 TRANS_METHOD_OUT Character(1) VARCHAR2(1) NOT NULL This field denotes how the outbound deduction data is transmitted from the PeopleSoft Customer to the Supplier i.e. flat file or XML message.
F=Flat File Transmission
M=XML Message Transmission

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MERCHANTID	Character(30)	VARCHAR2(30) NOT NULL	Merchant ID
2	SITE_NBR	Character(6)	VARCHAR2(6) NOT NULL	This field is edused to group employee based on their paygroup and pay frequency. The value for this field is assigned by the Supplier.
3	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
4	TRANS_METHOD_OUT	Character(1)	VARCHAR2(1) NOT NULL	This field denotes how the outbound deduction data is transmitted from the PeopleSoft Customer to the Supplier i.e. flat file or XML message. F=Flat File Transmission M=XML Message Transmission