GPIT_DM10_CODES(SQL Table) |
Index Back |
---|---|
Main Record: Row Codes DM10Main Record for the report DM10; Global Payroll Italy. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(6) | VARCHAR2(6) NOT NULL | Dm10 Code ID... Naming convention: X_YYYY | |
2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | GPIT_DM10_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Dm10 Code Description |
5 | GPIT_DM10_TABLE | Character(1) | VARCHAR2(1) NOT NULL |
The square name on the report.
There are 2 values possibilities:
B/C or D.
A=Square A on the DM10 Report B=Square B on the DM10 report D=Square D on the DM10 report Default Value: B |
6 | GPIT_DM10_POSITION | Character(5) | VARCHAR2(5) NOT NULL | DM10 square position... This is the position on the appropriate Square on the DM10 report. Where the row data should be written... This field can be left blank in this case the there is no pre-printed data on the report. So this is a not required field. |
7 | GPIT_DM10_CODICE | Character(4) | VARCHAR2(4) NOT NULL | This DM10 Code corresponding to the Code line on the report. It's one-to-one relationship between this code and the Italian law predefined codes.... There is a strong relationship with the position on the DM10 report. When position firled is blank this field should reflect the code value on the report. |
8 | GPIT_DM10_COD_DESC | Character(30) | VARCHAR2(30) NOT NULL | DM10 Code Description. |
9 | GPIT_DM10_GROUP | Character(4) | VARCHAR2(4) NOT NULL |
DM10 Group Code.
Prompt Table: GPIT_DM10_GROUP |
10 | GPIT_DM10_EE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Payee Counter Flag.
'Y'es: payee counted for the DM10.
'N'o: Payee not counted for the DM10.
Y/N Table Edit Default Value: N |
11 | GPIT_DM10_CAT_FROM | Character(1) | VARCHAR2(1) NOT NULL | Inps Category From value. |
12 | GPIT_DM10_CAT_TO | Character(1) | VARCHAR2(1) NOT NULL | Inps Category To: Illigibilty Value.... |
13 | GPIT_DM10_TIM_FROM | Number(8,4) | DECIMAL(7,4) NOT NULL | DM10 % Part time |
14 | GPIT_DM10_TIME_TO | Number(8,4) | DECIMAL(7,4) NOT NULL | DM10 % Part time To |
15 | GPIT_DM10_COD_FROM | Character(2) | VARCHAR2(2) NOT NULL | Contributive Codice From.... |
16 | GPIT_DM10_CODCE_TO | Character(2) | VARCHAR2(2) NOT NULL | DM10 Codice To Value |
17 | GPIT_DM10_EE_FROM | Character(1) | VARCHAR2(1) NOT NULL | Pay Reduction by Employee |
18 | GPIT_DM10_PAYEE_TO | Character(1) | VARCHAR2(1) NOT NULL | Pay reduction By EE |
19 | GPIT_DM10_KY5_FROM | Character(2) | VARCHAR2(2) NOT NULL | Argument 5 DM10: Value From |
20 | GPIT_DM10_KEY5_TO | Character(2) | VARCHAR2(2) NOT NULL | DM10 Key5: Value To |
21 | GPIT_DM10_COMMENTS | Long Character | CLOB | DM10 Row Comments |