| # |
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:
%EDITTABLE
|
| 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
E=Extraordinary Payroll
F=Saving Funds
L=Layoff
M=Retirement
O=Ordinary Payroll
P=Profit Sharing
R=Regular Payroll
S=Special
T=Termination
V=Vacation Premium
X=Christmas Bonus
Default Value: O
|
| 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(2) |
VARCHAR2(2) NOT NULL |
Payment Method
01=Cash
02=Check
03=Electronic Funds Transfer
04=Credit Card
05=Electronic Wallet
06=Electronic Money
08=Food Coupons
28=Debit Card
29=Service Card
99=To be defined
A=Cash
C=Check
Default Value: 03
|
| 18 |
GPMX_TRM_PAY_MTHD |
Character(2) |
VARCHAR2(2) NOT NULL |
Terminations Payment Method
01=Cash
02=Check
A=Cash
C=Check
|
| 19 |
GPMX_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Details
Y/N Table Edit
Default Value: N
|
| 20 |
GPMX_QR_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
QR Code Field for GP Mex
Y/N Table Edit
Default Value: N
|
| 21 |
GPMX_CAPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Ceiling - GP Mexico
Y/N Table Edit
Default Value: Y
|
| 22 |
GP_ELN_APP_CNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Application Country
Default Value: MEX
|
| 23 |
GP_ELN_APP |
Character(15) |
VARCHAR2(15) NOT NULL |
ELN Application
Prompt Table:
GP_ELN_APP_VW
|
| 24 |
GPMX_EMP_RUN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Option
A=All
E=In Error
Default Value: A
|
| 25 |
GPMX_CAL_FINAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow process CFDI only for Calendar Finalized
|
| 26 |
GPMX_OVR_CD_REGIME |
Character(2) |
VARCHAR2(2) NOT NULL |
Override Labor Regimen Code for Severance
13=Severance
|
| 27 |
GPMX_ESTABID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Establishment option
J=Job Data
L=Location
Default Value: L
|