GPMX_RC_PAY001

(SQL Table)
Index Back

Run Control Payslip

Run Control Payslip

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GP_CAL_RUN

4 GPMX_FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

Prompt Table: GPMX_FORMAT_VW

5 GPMX_SORTID Character(10) VARCHAR2(10) NOT NULL SORT ID

Prompt Table: GPMX_SORTID_VW

6 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

Prompt Table: GB_GROUP_TBL

7 GPMX_MESSAGE Character(254) VARCHAR2(254) NOT NULL Message
8 GPMX_CFDI_BANK Character(3) VARCHAR2(3) NOT NULL CFDI bank MEX
001=BANAMEX
012=BBVA BANCOMER
014=SANTANDER
021=HSBC
044=SCOTIABANK
072=BANORTE
9 GPMX_FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
10 GPMX_DIGITAL Character(1) VARCHAR2(1) NOT NULL Upload digital certificate
N=No
Y=Yes

Default Value: N

11 GPMX_FILE_TP_CFDI Character(1) VARCHAR2(1) NOT NULL File Type CFDI Mexico
E=By Employee
M=Massive

Default Value: M

12 GPMX_PAYROLL_TYPE Character(1) VARCHAR2(1) NOT NULL Payroll Type
B=Bonus
F=Saving Funds
L=Layoff
M=Retirement
P=Profit Sharing
R=Regular Payroll
S=Special
T=Termination
V=Vacation Premium
X=Christmas Bonus

Default Value: R

13 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
14 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
15 GPMX_OUTPUT_DIR Character(127) VARCHAR2(127) NOT NULL Input/Output file path
16 GPMX_LBL_HEADER1 Character(1) VARCHAR2(1) NOT NULL Label Header Mexico.

Y/N Table Edit

Default Value: N

17 GPMX_PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check