WA_TAXRPT
个税申报表返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ADDRVARCHAR2600    联系地址
2C_1VARCHAR2128     
3C_10VARCHAR2128     
4C_11VARCHAR2128     
5C_12VARCHAR2128     
6C_13VARCHAR2128     
7C_14VARCHAR2128     
8C_15VARCHAR2128     
9C_16VARCHAR2128     
10C_17VARCHAR2128     
11C_18VARCHAR2128     
12C_19VARCHAR2128     
13C_2VARCHAR2128     
14C_20VARCHAR2128     
15C_21VARCHAR2128     
16C_22VARCHAR2128     
17C_23VARCHAR2128     
18C_24VARCHAR2128     
19C_25VARCHAR2128     
20C_26VARCHAR2128     
21C_27VARCHAR2128     
22C_28VARCHAR2128     
23C_29VARCHAR2128     
24C_3VARCHAR2128     
25C_30VARCHAR2128     
26C_31VARCHAR2128     
27C_32VARCHAR2128     
28C_33VARCHAR2128     
29C_34VARCHAR2128     
30C_35VARCHAR2128     
31C_36VARCHAR2128     
32C_37VARCHAR2128     
33C_38VARCHAR2128     
34C_39VARCHAR2128     
35C_4VARCHAR2128     
36C_40VARCHAR2128     
37C_5VARCHAR2128     
38C_6VARCHAR2128     
39C_7VARCHAR2128     
40C_8VARCHAR2128     
41C_9VARCHAR2128     
42COMINDSTRYVARCHAR2200    单位所属行业
43COMINDSTRY2VARCHAR2200    单位所属行业2
44COMINDSTRY3VARCHAR2200    单位所属行业3
45COMINDSTRY4VARCHAR2200    单位所属行业4
46COMINDSTRY5VARCHAR2200    单位所属行业5
47COMINDSTRY6VARCHAR2200    单位所属行业6
48COUNTRYNAMEVARCHAR2200    国籍
49COUNTRYNAME2VARCHAR2200    国籍2
50COUNTRYNAME3VARCHAR2200    国籍3
51COUNTRYNAME4VARCHAR2200    国籍4
52COUNTRYNAME5VARCHAR2200    国籍5
53COUNTRYNAME6VARCHAR2200    国籍6
54CYEARCHAR4     薪资年
55D_1CHAR10     
56D_10CHAR10     
57D_11CHAR10     
58D_12CHAR10     
59D_13CHAR10     
60D_14CHAR10     
61D_15CHAR10     
62D_16CHAR10     
63D_17CHAR10     
64D_18CHAR10     
65D_19CHAR10     
66D_2CHAR10     
67D_20CHAR10     
68D_21CHAR10     
69D_22CHAR10     
70D_23CHAR10     
71D_24CHAR10     
72D_25CHAR10     
73D_26CHAR10     
74D_27CHAR10     
75D_28CHAR10     
76D_29CHAR10     
77D_3CHAR10     
78D_30CHAR10     
79D_31CHAR10     
80D_32CHAR10     
81D_33CHAR10     
82D_34CHAR10     
83D_35CHAR10     
84D_36CHAR10     
85D_37CHAR10     
86D_38CHAR10     
87D_39CHAR10     
88D_4CHAR10     
89D_40CHAR10     
90D_5CHAR10     
91D_6CHAR10     
92D_7CHAR10     
93D_8CHAR10     
94D_9CHAR10     
95DRNUMBER100  0 
96DUTYNAMEVARCHAR2200    职务
97DUTYNAME2VARCHAR2200    职务2
98DUTYNAME3VARCHAR2200    职务3
99DUTYNAME4VARCHAR2200    职务4
100DUTYNAME5VARCHAR2200    职务5
101DUTYNAME6VARCHAR2200    职务6
102F_1NUMBER318  0 
103F_10NUMBER318  0 
104F_100NUMBER318  0 
105F_11NUMBER318  0 
106F_12NUMBER318  0 
107F_13NUMBER318  0 
108F_14NUMBER318  0 
109F_15NUMBER318  0 
110F_16NUMBER318  0 
111F_17NUMBER318  0 
112F_18NUMBER318  0 
113F_19NUMBER318  0 
114F_2NUMBER318  0 
115F_20NUMBER318  0 
116F_21NUMBER318  0 
117F_22NUMBER318  0 
118F_23NUMBER318  0 
119F_24NUMBER318  0 
120F_25NUMBER318  0 
121F_26NUMBER318  0 
122F_27NUMBER318  0 
123F_28NUMBER318  0 
124F_29NUMBER318  0 
125F_3NUMBER318  0 
126F_30NUMBER318  0 
127F_31NUMBER318  0 
128F_32NUMBER318  0 
129F_33NUMBER318  0 
130F_34NUMBER318  0 
131F_35NUMBER318  0 
132F_36NUMBER318  0 
133F_37NUMBER318  0 
134F_38NUMBER318  0 
135F_39NUMBER318  0 
136F_4NUMBER318  0 
137F_40NUMBER318  0 
138F_41NUMBER318  0 
139F_42NUMBER318  0 
140F_43NUMBER318  0 
141F_44NUMBER318  0 
142F_45NUMBER318  0 
143F_46NUMBER318  0 
144F_47NUMBER318  0 
145F_48NUMBER318  0 
146F_49NUMBER318  0 
147F_5NUMBER318  0 
148F_50NUMBER318  0 
149F_51NUMBER318  0 
150F_52NUMBER318  0 
151F_53NUMBER318  0 
152F_54NUMBER318  0 
153F_55NUMBER318  0 
154F_56NUMBER318  0 
155F_57NUMBER318  0 
156F_58NUMBER318  0 
157F_59NUMBER318  0 
158F_6NUMBER318  0 
159F_60NUMBER318  0 
160F_61NUMBER318  0 
161F_62NUMBER318  0 
162F_63NUMBER318  0 
163F_64NUMBER318  0 
164F_65NUMBER318  0 
165F_66NUMBER318  0 
166F_67NUMBER318  0 
167F_68NUMBER318  0 
168F_69NUMBER318  0 
169F_7NUMBER318  0 
170F_70NUMBER318  0 
171F_71NUMBER318  0 
172F_72NUMBER318  0 
173F_73NUMBER318  0 
174F_74NUMBER318  0 
175F_75NUMBER318  0 
176F_76NUMBER318  0 
177F_77NUMBER318  0 
178F_78NUMBER318  0 
179F_79NUMBER318  0 
180F_8NUMBER318  0 
181F_80NUMBER318  0 
182F_81NUMBER318  0 
183F_82NUMBER318  0 
184F_83NUMBER318  0 
185F_84NUMBER318  0 
186F_85NUMBER318  0 
187F_86NUMBER318  0 
188F_87NUMBER318  0 
189F_88NUMBER318  0 
190F_89NUMBER318  0 
191F_9NUMBER318  0 
192F_90NUMBER318  0 
193F_91NUMBER318  0 
194F_92NUMBER318  0 
195F_93NUMBER318  0 
196F_94NUMBER318  0 
197F_95NUMBER318  0 
198F_96NUMBER318  0 
199F_97NUMBER318  0 
200F_98NUMBER318  0 
201F_99NUMBER318  0 
202IDVARCHAR225    身份证照号码
203IDTYPECHAR20    身份证照类型
204INCNDAYSNUMBER380   在华天数
205INCOMENNUMBER318   年所得额(境内)
206INCOMETAXNUMBER318   应纳税所得额
207INCOMETOTALNUMBER318   年所得额(合计)
208INCOMEWNUMBER318   年所得额(境外)
209MEMOVARCHAR2200    备注
210MOBILEVARCHAR230    联系电话
211PK_COUNTRYVARCHAR220    国家区域
212PK_DEPTCHAR20    部门
213PK_GROUPCHAR20    所属集团
214PK_ORGCHAR20     所属组织
215PK_PSNDOCCHAR20     人员
216PK_WA_TAXRPTCHAR20    主键
217POSTALCODECHAR20    联系地址邮编
218PSNNAMEVARCHAR2200    纳税人姓名
219PSNNAME2VARCHAR2200    纳税人姓名2
220PSNNAME3VARCHAR2200    纳税人姓名3
221PSNNAME4VARCHAR2200    纳税人姓名4
222PSNNAME5VARCHAR2200    纳税人姓名5
223PSNNAME6VARCHAR2200    纳税人姓名6
224TAXAPPENDNUMBER318   应补税额
225TAXEDQUTNUMBER318   已缴(扣)税额
226TAXFREENUMBER318   减免税额
227TAXHANDBACKNUMBER318   应退税额
228TAXKILLNUMBER318   抵扣税额
229TAXNOVARCHAR2100    单位税务代码
230TAXQUTNUMBER318   应纳税额
231TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
232VOCATIONVARCHAR2200    职业
233VOCATION2VARCHAR2200    职业2
234VOCATION3VARCHAR2200    职业3
235VOCATION4VARCHAR2200    职业4
236VOCATION5VARCHAR2200    职业5
237VOCATION6VARCHAR2200    职业6
238WORKCORPVARCHAR2200    任职受雇单位
239WORKCORP2VARCHAR2200    任职受雇单位2
240WORKCORP3VARCHAR2200    任职受雇单位3
241WORKCORP4VARCHAR2200    任职受雇单位4
242WORKCORP5VARCHAR2200    任职受雇单位5
243WORKCORP6VARCHAR2200    任职受雇单位6