SOCS_SETBNK_ESP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number Prompt Table: SOCS_ALL_CCC_VW
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
5	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
6	CONTACT_PHONE_ESP	Character(9)	VARCHAR2(9) NOT NULL	Contact phone number
7	CONTACT_FAX_ESP	Character(9)	VARCHAR2(9) NOT NULL	Contact fax number
8	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: SRC_BANK
9	HOLDER_NAME_ESP	Character(31)	VARCHAR2(31) NOT NULL	Holder name
10	SRC_BANK_ID_2_ESP	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID 2. Used for special accounts numbers, for instance, negative liquid accounts. Prompt Table: SRC_BANK
11	HOLDER_NAME_2_ESP	Character(31)	VARCHAR2(31) NOT NULL	Holder name for other uses. Used for Special Accounts: Negative Liquid.
12	SOCS_PAY_TYPE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Payment 0=Cash C=Direct Debit V=Electronic Payment