GPMX_RC_EFT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPERATOR_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GPMX_BANKCAL2_S
4	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GPMX_CAL_PAY_S
5	GPMX_FILE_NAME	Character(250)	VARCHAR2(250) NOT NULL	Name of a file, with full path, according to the process scheduler server.
6	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
7	GPMX_ACCOUNT_NBR	Character(17)	VARCHAR2(17) NOT NULL	Account Number
8	GPMX_BANK_CUST_ID	Number(12,0)	DECIMAL(12) NOT NULL	Bank Customer ID
9	REFERENCE_NUM	Character(15)	VARCHAR2(15) NOT NULL	Reference Number
10	GPMX_REF_NUM_A	Character(10)	VARCHAR2(10) NOT NULL	Reference Number A
11	GPMX_REF_NUM_C	Number(10,0)	DECIMAL(10) NOT NULL	Reference Number C
12	GPMX_REF_NUM_D	Number(16,0)	DECIMAL(16) NOT NULL	Reference Number D
13	GPMX_REF_NUM_E	Number(7,0)	INTEGER NOT NULL	Reference Number E
14	PAY_END_DT_ALT	Date(10)	DATE	Pay Period End Date
15	GPMX_BANAMEX_VER	Character(2)	VARCHAR2(2) NOT NULL	Version Windows/DOS 10=DOS 20=Windows Default Value: 10
16	GPMX_FORMAT_BANK	Character(2)	VARCHAR2(2) NOT NULL	Format Bank 10=Bancomer 30=Banamex 35=Banamex Interb 40=Banorte 50=HSBC 60=Scotiabank 70=BBVA Cash 80=Santander
17	GPMX_SECOND_REF	Character(14)	VARCHAR2(14) NOT NULL	Secondary Reference
18	GPMX_BANAMEX_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Banamex Format 10=Pagomatico 20=Third Party
19	GPMX_MESSAGE	Character(254)	VARCHAR2(254) NOT NULL	Message
20	GPMX_TRANS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Transfer Type 01 - Payroll Transfer 02 - Interbank Transfer 01=Payroll 02=Interbank Default Value: 01
21	GPMX_PLAZO	Character(2)	VARCHAR2(2) NOT NULL	00 - Same Day 24 - 24 Hrs 00=Same Day 24=24 Hours Default Value: 00