GPIT_GV93_TMP

(SQL Table)
 Index Back

GV93 Temporary record

Record for GV93 report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
4 INPDAI_CODE_ITA Character(16) VARCHAR2(16) NOT NULL INPDAI Code ITA
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 GPIT_F24_CODFIS Character(16) VARCHAR2(16) NOT NULL Company tax code Field for F24 report
7 GPIT_COMP_CODFIS Character(16) VARCHAR2(16) NOT NULL Company tax code
8 GPIT_GV93_PER_AA Character(2) VARCHAR2(2) NOT NULL Year (char) for GPItaly reports.
9 GPIT_GV93_PER_MM_B Character(2) VARCHAR2(2) NOT NULL Begin Month
10 GPIT_GV93_PER_MM_E Character(2) VARCHAR2(2) NOT NULL End Month
11 GPIT_GV93_A1_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
12 GPIT_GV93_A2_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
13 GPIT_GV93_A3_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
14 GPIT_GV93_A4_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
15 GPIT_GV93_A5_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
16 GPIT_GV93_B99_AMNT Number(4,0) SMALLINT NOT NULL Amount Field for GV93 report Number of Executives
17 GPIT_GV93_B1_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
18 GPIT_GV93_B2_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
19 GPIT_GV93_B3_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
20 GPIT_GV93_B4_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
21 GPIT_GV93_B5_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
22 GPIT_GV93_B5_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
23 GPIT_GV93_B6_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
24 GPIT_GV93_B6_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
25 GPIT_GV93_B7_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
26 GPIT_GV93_C1_AA Character(2) VARCHAR2(2) NOT NULL Year
27 GPIT_GV93_C1_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
28 GPIT_GV93_C1_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
29 GPIT_GV93_C1_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
30 GPIT_GV93_C1_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
31 GPIT_GV93_C2_AA Character(2) VARCHAR2(2) NOT NULL Year
32 GPIT_GV93_C2_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
33 GPIT_GV93_C2_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
34 GPIT_GV93_C2_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
35 GPIT_GV93_C2_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
36 GPIT_GV93_C3_AA Character(2) VARCHAR2(2) NOT NULL Year
37 GPIT_GV93_C3_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
38 GPIT_GV93_C3_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
39 GPIT_GV93_C3_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
40 GPIT_GV93_C3_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
41 GPIT_GV93_C4_AA Character(2) VARCHAR2(2) NOT NULL Year
42 GPIT_GV93_C4_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
43 GPIT_GV93_C4_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
44 GPIT_GV93_C4_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
45 GPIT_GV93_C4_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
46 GPIT_GV93_C5_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
47 GPIT_GV93_C6_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
48 GPIT_GV93_E1_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
49 GPIT_GV93_F1_AA Character(2) VARCHAR2(2) NOT NULL Year
50 GPIT_GV93_F1_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
51 GPIT_GV93_F1_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
52 GPIT_GV93_F1_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
53 GPIT_GV93_F1_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
54 GPIT_GV93_F2_AA Character(2) VARCHAR2(2) NOT NULL Year
55 GPIT_GV93_F2_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
56 GPIT_GV93_F2_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
57 GPIT_GV93_F2_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
58 GPIT_GV93_F2_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
59 GPIT_GV93_F3_AA Character(2) VARCHAR2(2) NOT NULL Year
60 GPIT_GV93_F3_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
61 GPIT_GV93_F3_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
62 GPIT_GV93_F3_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
63 GPIT_GV93_F3_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
64 GPIT_GV93_F4_AA Character(2) VARCHAR2(2) NOT NULL Year
65 GPIT_GV93_F4_MM_BG Character(2) VARCHAR2(2) NOT NULL Begin Month
66 GPIT_GV93_F4_MM_EN Character(2) VARCHAR2(2) NOT NULL End Month
67 GPIT_GV93_F4_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
68 GPIT_GV93_F4_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
69 GPIT_GV93_F5_ICOD Character(4) VARCHAR2(4) NOT NULL GV93 Identification Code Field for GV93 report
70 GPIT_GV93_F5_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report
71 GPIT_GV93_G1_SIGN Character(1) VARCHAR2(1) NOT NULL GV93 Identification Code Field for GV93 report
72 GPIT_GV93_G1_AMNT Number(12,0) DECIMAL(12) NOT NULL Amount Field for GV93 report