CO_DED_FTP2_VW (SQL View)	Index Back
DEDUCTION FTP VW Table contains information used to prompt the fields on the recreate ftp page.

CO_DED_FTP2_VW

(SQL View)

DEDUCTION FTP VW

Table contains information used to prompt the fields on the recreate ftp page.

SELECT SUPP_FILE_ID , MERCHANTID , SITE_NBR , SENT_DT , FILE_IN_NAME FROM PS_CO_DED_SUPP_FLE WHERE SUPP_FILE_ID LIKE 'O%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 SENT_DT Date(10) DATE Date Supplier Data Sent

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	MERCHANTID	Character(30)	VARCHAR2(30) NOT NULL	Merchant ID
3	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.
4	SENT_DT	Date(10)	DATE	Date Supplier Data Sent
5	FILE_IN_NAME	Character(33)	VARCHAR2(33) NOT NULL	The name of the inbound deduction flat file from the Supplier.