CO_DED_SUPP_FLE (SQL Table)	Index Back
Supplier Deduction File The table contains information about the Supplier inbound Flat File.

CO_DED_SUPP_FLE

(SQL Table)

Supplier Deduction File

The table contains information about the Supplier inbound Flat File.

# 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 RECEIVE_DT Date(10) DATE Date Received
Default Value: %date

4 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.

5 FILE_IN_DIR Character(64) VARCHAR2(64) NOT NULL Output Directory Name for Flat File Interfaces.

6 FILE_IN_NAME Character(33) VARCHAR2(33) NOT NULL The name of the inbound deduction flat file from the Supplier.

7 TOTAL_DED_CNT Number(6,0) INTEGER NOT NULL The field contains the total count of the number of deduction records sent by the Supplier.

8 TOTAL_DEDAMT Number(10,2) DECIMAL(9,2) NOT NULL This field contains the total deduction amount sent by the SUpplier.

9 SENT_DT Date(10) DATE Date Supplier Data Sent

10 VALIDATED_DT Date(10) DATE The date the inbound deduction data from the Supplier was validated.

#	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	RECEIVE_DT	Date(10)	DATE	Date Received Default Value: %date
4	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.
5	FILE_IN_DIR	Character(64)	VARCHAR2(64) NOT NULL	Output Directory Name for Flat File Interfaces.
6	FILE_IN_NAME	Character(33)	VARCHAR2(33) NOT NULL	The name of the inbound deduction flat file from the Supplier.
7	TOTAL_DED_CNT	Number(6,0)	INTEGER NOT NULL	The field contains the total count of the number of deduction records sent by the Supplier.
8	TOTAL_DEDAMT	Number(10,2)	DECIMAL(9,2) NOT NULL	This field contains the total deduction amount sent by the SUpplier.
9	SENT_DT	Date(10)	DATE	Date Supplier Data Sent
10	VALIDATED_DT	Date(10)	DATE	The date the inbound deduction data from the Supplier was validated.