GPIT_770_RP_010

(SQL Table)
Index Back

Record for 770 Report

Record for 770 Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPIT_TAX_CD_1 Character(16) VARCHAR2(16) NOT NULL Tax Code
3 GPIT_FILE_NBR4 Number(4,0) SMALLINT NOT NULL File Number
4 COMP_CODE_ITA Character(30) VARCHAR2(30) NOT NULL Company Codes ITA
5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 GPIT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
9 GPIT_MM_NUM2_01 Number(2,0) SMALLINT NOT NULL Month
10 GPIT_SAL_REIMBURSE Signed Number(12,2) DECIMAL(10,2) NOT NULL Reimbursed Amount
11 GPIT_SAL_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL Deducted Amount
12 GPIT_SAL_INTEREST Signed Number(12,2) DECIMAL(10,2) NOT NULL Interests
13 GPIT_AMT_LESSLIM_1 Character(1) VARCHAR2(1) NOT NULL Flag
14 GPIT_1RA_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL First Advance Deduction
15 GPIT_1RA_INTERESTS Signed Number(12,2) DECIMAL(10,2) NOT NULL First Advance Interests
16 GPIT_1RA_AFTERCORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Amount paid after Corrections
17 GPIT_AMT_LESSLIM_2 Character(1) VARCHAR2(1) NOT NULL Flag
18 GPIT_ARD_REIMBURSE Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Payee Reimbursed
19 GPIT_ARD_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Payee Deduction
20 GPIT_ARD_INTERESTS Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Payee Interests
21 GPIT_AMT_LESSLIM_3 Character(1) VARCHAR2(1) NOT NULL Flag
22 GPIT_ARD_COUNTYCD Character(2) VARCHAR2(2) NOT NULL County Code Payee
23 GPIT_ARC_REIMBURSE Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Spouse Reimbursed
24 GPIT_ARC_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Spouse Deduction
25 GPIT_ARC_INTERESTS Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Spouse Interests
26 GPIT_AMT_LESSLIM_4 Character(1) VARCHAR2(1) NOT NULL Flag
27 GPIT_ARC_COUNTYCD Character(2) VARCHAR2(2) NOT NULL County Code Spouse
28 GPIT_ACD_REIMBURSE Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Payee Reimbursed
29 GPIT_ACD_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Payee Deduction
30 GPIT_ACD_INTERESTS Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Payee Interests
31 GPIT_AMT_LESSLIM_5 Character(1) VARCHAR2(1) NOT NULL Flag
32 GPIT_ACD_CITYCD Character(2) VARCHAR2(2) NOT NULL City Code Payee
33 GPIT_ACC_REIMBURSE Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Spouse Reimbursed
34 GPIT_ACC_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Spouse Deduction
35 GPIT_ACC_INTERESTS Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Spouse Interests
36 GPIT_AMT_LESSLIM_6 Character(1) VARCHAR2(1) NOT NULL Flag
37 GPIT_ACC_CITYCD Character(2) VARCHAR2(2) NOT NULL City Code Spouse
38 GPIT_ATS_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL Separate Taxation Deduction
39 GPIT_ATS_INTERESTS Signed Number(12,2) DECIMAL(10,2) NOT NULL Separate Taxation Interests
40 GPIT_ATS_AFTERCORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Separate Taxation Amount paid after Corrections
41 GPIT_AMT_LESSLIM_7 Character(1) VARCHAR2(1) NOT NULL Flag
42 GPIT_ADJ_TYPE Character(16) VARCHAR2(16) NOT NULL Type of Adjustment
43 GPIT_FORM_CORR Character(16) VARCHAR2(16) NOT NULL Correction Form
44 GPIT_FORM_INTEGR Character(16) VARCHAR2(16) NOT NULL Integrative Form
45 GPIT_FORM_NONPAY Character(16) VARCHAR2(16) NOT NULL Non Payable Form
46 GPIT_MM_NUM2_02 Number(2,0) SMALLINT NOT NULL Month
47 GPIT_2RA_DEDUCTION Signed Number(12,2) DECIMAL(10,2) NOT NULL Second Advance Deduction
48 GPIT_2RA_INTERESTS Signed Number(12,2) DECIMAL(10,2) NOT NULL Second Advance Interests
49 GPIT_2RA_AFTERCORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Second Advance Amount paid after Corrections
50 GPIT_2RA_RESULT Character(1) VARCHAR2(1) NOT NULL Result
51 GPIT_MM_NUM2_03 Number(2,0) SMALLINT NOT NULL Month
52 GPIT_SAL_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction Irpef Deduction
53 GPIT_1RA_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction First Advanced
54 GPIT_ARD_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction County Tax Payee
55 GPIT_ARC_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction County Tax Spouse
56 GPIT_ACD_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction City Tax Payee
57 GPIT_ACC_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction City Tax Spouse
58 GPIT_ATS_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction Separate Tax Advance
59 GPIT_MM_NUM2_04 Number(2,0) SMALLINT NOT NULL Month
60 GPIT_2RA_CORR Signed Number(12,2) DECIMAL(10,2) NOT NULL Correction Second Advance
61 GPIT_RESULT Character(1) VARCHAR2(1) NOT NULL Result
62 GPIT_SAL_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL Irpef Amount not Reimbursed
63 GPIT_SAL_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL Irpef Amount not Deducted
64 GPIT_1RA_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL First Advance Amount not Reimbursed
65 GPIT_1RA_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL First Advance Amount not Deducted
66 GPIT_ARD_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Payee Amount not Reimbursed
67 GPIT_ARD_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Payee Amount not Deducted
68 GPIT_ARC_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Spouse Amount not Reimbursed
69 GPIT_ARC_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL County Tax Spouse Amount not Deducted
70 GPIT_ACD_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Payee Amount not Reimbursed
71 GPIT_ACD_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Payee Amount not Deducted
72 GPIT_ACC_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Spouse Amount not Reimbursed
73 GPIT_ACC_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Spouse Amount not Deducted
74 GPIT_ATS_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL Separate Taxation Advance Amount not Reimbursed
75 GPIT_ATS_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL City Tax Payee Amount not Deducted
76 GPIT_2RA_NOT_REIM Signed Number(12,2) DECIMAL(10,2) NOT NULL Second Advance Amount not Reimbursed
77 GPIT_2RA_NOT_DED Signed Number(12,2) DECIMAL(10,2) NOT NULL Second Advance Amount not Deducted
78 GPIT_CAF_FISCAL_CD Character(16) VARCHAR2(16) NOT NULL CAF Fiscal Code
79 GPIT_730_CD_CAF Character(4) VARCHAR2(4) NOT NULL CAF Code
80 GPIT_730_CONSEGNA Date(10) DATE Date of delivery of 730
81 GPIT_730_CORR_DT Date(10) DATE Date of delivery of 730
82 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
83 COMPANY Character(3) VARCHAR2(3) NOT NULL Company