GPIT_SCAGL_REC3 (SQL Table)	Index Back
Scaglioni-key: ID,Date&Lowlim This table contains ID, date (as keys), lower and upper limit, applied rate and currency of the scaglioni range. It is supposed that the Scaglioni table will be used not only for IRPEF values (ID-table: IRPF) but also for other rules.

GPIT_SCAGL_REC3

(SQL Table)

Scaglioni-key: ID,Date&Lowlim

This table contains ID, date (as keys), lower and upper limit, applied rate and currency of the scaglioni range. It is supposed that the Scaglioni table will be used not only for IRPEF values (ID-table: IRPF) but also for other rules.

Parent record: GPIT_SCAGL_REC2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPIT_TAB_SCAGL_ID Character(4) VARCHAR2(4) NOT NULL Id of the Scaglioni table. The table should be useful bothb for IRTEF taxation and contribution. The ID exist in order to distinguish between tables.

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 GPIT_SCAGL_LOWLIM Number(17,6) DECIMAL(16,6) NOT NULL Lower limit of the SCAGLIONE. The scaglione is a range of money for which a mandatory percent must be applied.

4 GPIT_SCAGL_UPPLIM Number(17,6) DECIMAL(16,6) NOT NULL Upper limit of the SCAGLIONE. The scaglione is a rangeof money for which a mandatory percent must be applied.

5 GPIT_APPLIED_RATE Number(7,3) DECIMAL(6,3) NOT NULL This field is used in different table. It has 3 decimals. Depending on the context, a different lable can be chosen. For example it is used as Percent to apply for a SCAGLIONE. The scaglione is a range of money for which a mandatory percent must be applied.

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: EUR
Prompt Table: CURRENCY_CD_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIT_TAB_SCAGL_ID	Character(4)	VARCHAR2(4) NOT NULL	Id of the Scaglioni table. The table should be useful bothb for IRTEF taxation and contribution. The ID exist in order to distinguish between tables.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPIT_SCAGL_LOWLIM	Number(17,6)	DECIMAL(16,6) NOT NULL	Lower limit of the SCAGLIONE. The scaglione is a range of money for which a mandatory percent must be applied.
4	GPIT_SCAGL_UPPLIM	Number(17,6)	DECIMAL(16,6) NOT NULL	Upper limit of the SCAGLIONE. The scaglione is a rangeof money for which a mandatory percent must be applied.
5	GPIT_APPLIED_RATE	Number(7,3)	DECIMAL(6,3) NOT NULL	This field is used in different table. It has 3 decimals. Depending on the context, a different lable can be chosen. For example it is used as Percent to apply for a SCAGLIONE. The scaglione is a range of money for which a mandatory percent must be applied.
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: EUR Prompt Table: CURRENCY_CD_TBL