GPIT_DM10E_TMPE(SQL Table) |
Index Back |
---|---|
Electronic DM10 temp table.Temporary table for the Electronic DM10 report. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | INPS_CODE_ITA | Character(12) | VARCHAR2(12) NOT NULL | INPS Code ITA |
5 | 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. |
6 | 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 |
7 | 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. |
8 | 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. |
9 | GPIT_DM10E_COL1 | Number(12,0) | DECIMAL(12) NOT NULL | Electronic DM10 Field. |
10 | GPIT_DM10E_COL2 | Number(12,0) | DECIMAL(12) NOT NULL | Electronic DM10 Field. |
11 | GPIT_DM10E_COL3 | Number(12,0) | DECIMAL(12) NOT NULL | Electronic DM10 Field. |
12 | GPIT_DM10E_COL4 | Number(12,0) | DECIMAL(12) NOT NULL | Electronic DM10 Field. |
13 | GPIT_DM10E_COL5 | Number(12,0) | DECIMAL(12) NOT NULL | Electronic DM10 Field. |
14 | GPIT_TMP_NBR12_X1 | Number(12,0) | DECIMAL(12) NOT NULL | Temporary number field. |
15 | GPIT_TMP_NBR12_02 | Number(12,0) | DECIMAL(12) NOT NULL | Temporary number field. |
16 | GPIT_TMP_NBR12_03 | Number(12,0) | DECIMAL(12) NOT NULL | Temporary number field. |
17 | GPIT_TMP_NBR12_04 | Number(12,0) | DECIMAL(12) NOT NULL | Temporary number field. |
18 | GPIT_TMP_NBR12_05 | Number(12,0) | DECIMAL(12) NOT NULL | Temporary number field. |
19 | GPIT_TMP_NBR12_01 | Number(12,0) | DECIMAL(12) NOT NULL | Temporary number field. |