| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPIT_F24_CODICE |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax element code
Field for F24 report
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
GPIT_F24_CODTRIB |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax code
Field for F24 report
|
| 6 |
GPIT_F24_QUADRO |
Character(1) |
VARCHAR2(1) NOT NULL |
F24 Square
Field for F24 report
Prompt Table:
GPIT_F24_QUADRO
|
| 7 |
GPIT_F24_POSIZ |
Number(3,0) |
SMALLINT NOT NULL |
Position in Square
Field for F24 report
|
| 8 |
GPIT_F24_ADDIZ |
Character(1) |
VARCHAR2(1) NOT NULL |
Local tax type
field for F24 report
C=City
R=County
|
| 9 |
GPIT_730_TIPO_ADD |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Local Tax
C=Spouse
D=Employee
|
| 10 |
GPIT_F24_RATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Installments
Field for F24 report
00T0=County Table
00T1=City Taxes Table
NNRR=Installment number
|
| 11 |
GPIT_F24_ANNORIF |
Character(4) |
VARCHAR2(4) NOT NULL |
Reference year
Field for F24 report
AAAA=Current Year
AAAP=Previous Year
|
| 12 |
GPIT_F24_COMPENS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag recoverable Tax
field for F24 report
Y/N Table Edit
Default Value: N
|
| 13 |
GPIT_F24_IMPMIN |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Minimum amount
Field for F24 report
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
GPIT_F24_GRUPPO |
Character(6) |
VARCHAR2(6) NOT NULL |
F24 element group
Field for F24 report
Prompt Table:
GPIT_F24_GRUPPO
|
| 16 |
GPIT_F24_ZONGFR |
Character(2) |
VARCHAR2(2) NOT NULL |
Geographical zone from
Field for F24 report
01=Other Establishments
02=Est. Outside SIC, SAR, VAO
03=Sicily Establishments
04=Sardinia Establishments
05=Aosta Valley Establishments
C1=Contractors 10%
CX=Contractors 14%
|
| 17 |
GPIT_F24_ZONGTO |
Character(2) |
VARCHAR2(2) NOT NULL |
Geographical zone to
Field for F24 report
01=Other Establishments
02=Est. Outside SIC, SAR, VAO
03=Sicily Establishments
04=Sardinia Establishments
05=Aosta Valley Establishments
C1=Contractors 10%
CX=Contractors 14%
|