GPMX_CFDI2_DTL(SQL Table) |
Index Back |
---|---|
CFDI Report - Overtime DetailCFDI Report - Overtime Detail |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(3) | VARCHAR2(3) NOT NULL | Company | |
2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
3 | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Default Value: ER0 Prompt Table: GPMX_ENT_ED_VW |
|
4 | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %EDITTABLE3 |
|
5 | GPMX_INXS_HRS | Character(4) | VARCHAR2(4) NOT NULL |
In Excess Hrs. per Day
0010=Double 0020=Triple 0030=Simple |