R_GVT_EFT_SORT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

2 GVT_PAYEE_ID_NO Character(9) VARCHAR2(9) NOT NULL GVT EFT Payee ID Number

3 GVT_PAYEE_NAME Character(22) VARCHAR2(22) NOT NULL GVT EFT Account Holder

4 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Account Type
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense

5 ACCOUNT_NUM Character(17) VARCHAR2(17) NOT NULL Account Number

6 GVT_LINE_CODE Character(1) VARCHAR2(1) NOT NULL EFT Line Code

7 GVT_EFT_SORT_AMT Character(10) VARCHAR2(10) NOT NULL EFT Sort Amount

8 GVT_DESCR80 Character(80) VARCHAR2(80) NOT NULL EFT Addendum Holder Descr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
2	GVT_PAYEE_ID_NO	Character(9)	VARCHAR2(9) NOT NULL	GVT EFT Payee ID Number
3	GVT_PAYEE_NAME	Character(22)	VARCHAR2(22) NOT NULL	GVT EFT Account Holder
4	ACCOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Account Type $=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense
5	ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	Account Number
6	GVT_LINE_CODE	Character(1)	VARCHAR2(1) NOT NULL	EFT Line Code
7	GVT_EFT_SORT_AMT	Character(10)	VARCHAR2(10) NOT NULL	EFT Sort Amount
8	GVT_DESCR80	Character(80)	VARCHAR2(80) NOT NULL	EFT Addendum Holder Descr