GVT_ECS_OFF_VW (SQL View)	Index Back
GVT ECS OFF CYCLE View Used as search and level 0 on GVT_ECS_OFF_CYCLE

GVT_ECS_OFF_VW

(SQL View)

GVT ECS OFF CYCLE View

Used as search and level 0 on GVT_ECS_OFF_CYCLE

SELECT A.COMPANY , A.GVT_SCHEDULE_NO , A.DESCR , A.GVT_ECS_TRANS_TYPE , A.GVT_ECS_NET_ONLY FROM PS_GVT_ECS_CONTROL A WHERE A.GVT_ECS_TRANS_TYPE <> '05' AND A.GVT_ECS_DOS_NAME = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Default Value: INSTALLATION.COMPANY
Prompt Table: COMPANY_TBL

2 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 GVT_ECS_TRANS_TYPE Character(2) VARCHAR2(2) NOT NULL GVT ECS Transaction Type
01=Vendor Check Payments Schedule
02=Vendor ACH Payment Schedule
03=Salary ACH Payment Schedule
04=Travel ACH Payment Schedule
05=Summary Schedule
06=SDPR Schedule
07=Misc. Check Payment Schedule
08=Misc ACH Payment Schedule
Default Value: 05

5 GVT_ECS_NET_ONLY Character(1) VARCHAR2(1) NOT NULL GVT ECS Net Pay Only Extract
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: INSTALLATION.COMPANY Prompt Table: COMPANY_TBL
2	GVT_SCHEDULE_NO	Character(14)	VARCHAR2(14) NOT NULL	Schedule Number
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	GVT_ECS_TRANS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	GVT ECS Transaction Type 01=Vendor Check Payments Schedule 02=Vendor ACH Payment Schedule 03=Salary ACH Payment Schedule 04=Travel ACH Payment Schedule 05=Summary Schedule 06=SDPR Schedule 07=Misc. Check Payment Schedule 08=Misc ACH Payment Schedule Default Value: 05
5	GVT_ECS_NET_ONLY	Character(1)	VARCHAR2(1) NOT NULL	GVT ECS Net Pay Only Extract Default Value: N