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.