| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
GPMX_BALANCE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Balance Year GP Mexico
|
| 4 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
Default Value: 01
|
| 5 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 6 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 7 |
GPMX_CASH_CRE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to run the report for payees with cash salary credit
Y/N Table Edit
Default Value: N
|
| 8 |
GPMX_ENT_SAL_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Salary
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 9 |
GPMX_PIN_SAL_NUM |
Number(8,0) |
INTEGER NOT NULL |
Paid Salary Pin Num
Prompt Table:
%GP_EDIT_FLD2
|
| 10 |
GPMX_ENT_DAYS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Paid days
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 11 |
GPMX_PIN_DAYS_NUM |
Number(8,0) |
INTEGER NOT NULL |
Paid Days
Prompt Table:
%GP_EDIT_FLD1
|
| 12 |
GPMX_ENT_IMS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type IMSS Quotas
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 13 |
GPMX_PIN_IMS_NUM |
Number(8,0) |
INTEGER NOT NULL |
IMSS Quotas Pin Num
Prompt Table:
%GP_EDIT_FLD3
|
| 14 |
GPMX_ENT_NET_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Net paid
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 15 |
GPMX_PIN_NET_NUM |
Number(8,0) |
INTEGER NOT NULL |
Net Paid Pin Num
Prompt Table:
%GP_EDIT_FLD4
|
| 16 |
GPMX_ENT_TAX_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Tax
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 17 |
GPMX_PIN_TAX_NUM |
Number(8,0) |
INTEGER NOT NULL |
Tax amount Pin Num
Prompt Table:
%GP_EDIT_FLD5
|
| 18 |
GPMX_ENT_TXB_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Taxable
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 19 |
GPMX_PIN_TXB_NUM |
Number(8,0) |
INTEGER NOT NULL |
Taxable amount Pin Number
Prompt Table:
%GP_EDIT_FLD6
|
| 20 |
GPMX_ENT_SUB_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type subsidy
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 21 |
GPMX_PIN_SUB_NUM |
Number(8,0) |
INTEGER NOT NULL |
Subsidy PIN NUM
Prompt Table:
%GP_EDIT_FLD7
|
| 22 |
GPMX_ENT_CRE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Salary Credit
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 23 |
GPMX_PIN_CRE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Salary Credit Pin Num
Prompt Table:
%GP_EDIT_FLD8
|
| 24 |
GPMX_ENT_NETX_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Net Tax
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 25 |
GPMX_PIN_NETTX_NUM |
Number(8,0) |
INTEGER NOT NULL |
Net Tax Pin Num
Prompt Table:
%GP_EDIT_FLD9
|
| 26 |
GPMX_ENT_CREX_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Element Type Cash Salary Credit
Default Value: ER0
Prompt Table:
GPMX_ENT_RPT_VW
Set Control Field: ENTRY_TYPE_ID
|
| 27 |
GPMX_PIN_CREX_NUM |
Number(8,0) |
INTEGER NOT NULL |
Salary Credit Pin Num
Prompt Table:
%GP_EDIT_FLD10
|