GPMX_CF_RSL_TMP

(SQL Table)
Index Back

CFDI Payroll Results MEX

CFDI Payroll Results MEX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
8 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

Prompt Table: GP_PIN_TYPE

9 GPMX_LEGAL_CD_CFDI Character(3) VARCHAR2(3) NOT NULL Elements catalog for CFDI MEX
1=Dummy
10 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 GPMX_RSLT_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Results Deductions Taxable
13 GPMX_RSLT_NO_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Results Deductions Non Taxable
14 GPMX_TOT_ERN_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Earning Taxable
15 GPMX_TOT_ERN_NOTAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Earning Non Taxable
16 GPMX_TOT_DED_TAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Deductions Taxable
17 GPMX_TOT_DED_NOTAX Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Deductions Non Taxable
18 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
19 DISABILITY_LBL Character(1) VARCHAR2(1) NOT NULL Disability
20 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
21 GPMX_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Days
22 DETAIL Character(1) VARCHAR2(1) NOT NULL This field is used store the Incident Detail

Y/N Table Edit

Default Value: N

23 GPMX_NID_RFC Character(20) VARCHAR2(20) NOT NULL National ID: RFC