GVT_ECS_ACCT (SQL Table)	Index Back
GVT ECS Schedule Account Info Used to track the assigning and usage of the ECS Schedule Number Account Symbol and Total Amount by count for each Schedule. Note that there are edits concerning the number entries on this table and the allowable size of the amount field based on Schedule type

GVT_ECS_ACCT

(SQL Table)

GVT ECS Schedule Account Info

Used to track the assigning and usage of the ECS Schedule Number Account Symbol and Total Amount by count for each Schedule. Note that there are edits concerning the number entries on this table and the allowable size of the amount field based on Schedule type

Parent record: GVT_ECS_CONTROL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number
Prompt Table: GVT_ECS_CONTROL

3 GVT_ECS_ACCT_LINE Number(2,0) SMALLINT NOT NULL Account Symbol/Amount Info
Default Value: 1

4 GVT_ECS_ACCT_SYM Character(16) VARCHAR2(16) NOT NULL GVT ECS Account Symbol

5 GVT_ECS_ACCT_TOT Number(13,2) DECIMAL(12,2) NOT NULL Total Symbol Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	GVT_SCHEDULE_NO	Character(14)	VARCHAR2(14) NOT NULL	Schedule Number Prompt Table: GVT_ECS_CONTROL
3	GVT_ECS_ACCT_LINE	Number(2,0)	SMALLINT NOT NULL	Account Symbol/Amount Info Default Value: 1
4	GVT_ECS_ACCT_SYM	Character(16)	VARCHAR2(16) NOT NULL	GVT ECS Account Symbol
5	GVT_ECS_ACCT_TOT	Number(13,2)	DECIMAL(12,2) NOT NULL	Total Symbol Amount