GPIT_DM10E_TMPC

#	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_ID	Character(6)	VARCHAR2(6) NOT NULL	Dm10 Code ID... Naming convention: X_YYYY
6	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.
7	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
8	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.
9	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.
10	GPIT_DM10_COLUMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Hold Dm10 Earning/Deduction
11	GPIT_DM10_COLUMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	DM10 earning deduction...
12	GPIT_DM10_COLUMN3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Value DM10 Square 3.
13	GPIT_DM10_COLUMN4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Value Earning/Dedductio Dm10.
14	GPIT_DM10_COLUMN5	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Value Ear/Ded DM10...
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPARTMENT_SRCH
16	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
17	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
18	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_PYGRP
19	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
20	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_TBL
21	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company