SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Personnel Management :: Personnel Administration :: Italy
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5ITT72611Data settlement according to 730Italy
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, MO730, ENDDA, BEGDA, WTNPA, WTRIR, WTRCS, WTRAD, WTRAC, WTRCD, WTRCC, INTER, INTRE, RATA1, WT1RT, WT1DF, WT1IN, WT1II, RATA2, WT2RT, WT2IN, MFRA1, MFRA2, WTTIR, WTIDF, WTIIN, WTIII, WTTCS, WTCDF, WTICS, WTTRC, WTCRC, WTIRC, WTDRC, WTTRD, WTCRD, WTIRD, WTDRD, WTTAC, WTADF, WTIAC, WTDAC, WTTAD, WTADD, WTIAD, WTDDD, WTTCC, WTCCC, WTICC, WTDCC, WTTCD, WTCCD, WTICD, WTDCD, WT1RD, WT1RC, WT2RD, WT2RC, W1DFD, W1DFC, W1IID, W1IIC, W1IND, W1INC, W2IND, W2INC, WTNP2, W2DFD, W2DFC, WSRIR, WSRAD, WSRCD, WSRAC, WSRCC, WS1RD, WSIND, WSIID, WS1RC, WSINC, WSIIC, WS2RD, WS2ND, WS2RC, WS2NC, WSTIR, WSII1, WSIII, WSTRD, WSXRD, WSDRD, WSTRC, WSXRC, WSDRC, WSTCD, WSXCD, WSDCD, WSXCC, WSTCC, WSDCC, WSTAD, WSXAD, WSDDD, WSTAC, WSIAC, WSDAC, WSRXC, WSRXD, WSRXE, WSRXF, WSRXG, WSRXH, WSRXI, WSRXJ, WSRXK, WSRXL, WSRXM, WSRXN, WSRXO, WSRXP, WSRXQ, MEINT, LC005, WTRID, WTRIC, WTTID, WTTIC, WTIDD, WTIDC, WTIND, WTINC, WTACD, WTACC, WTACT, WSACD, WSACC, WSACT, WSAXD, WSAXC, WSAXT, WSDDA, WSDCA, WSDTA, WTAID, WTAIC, WTAIT, WTTDD, WTTDC, WTTDT, WTDDA, WTDCA, WTDTA, WSTID, WSTIC, WSID1, WSIC1, WSRDX, WSRCX, WSRDD, WSRDC, WSRID, WSRIC, WTIDI, WTICI, WTDII, WTCII, WTCLR, WTCLT, WTLSD, WTLSC, WILSD, WILSC, WIISD, WIISC, WINSD, WINSC, WSISD, WSISC, WSNSD, WSNSC, WRLSD, WRLSC, WRTAD, WRTAC, WSLSC, WSLSD, WISLD, WISLC, WIILD, WIILC, WSILD, WSILC, WRILD, WRILC, WINLD, WINLC, WSSLD, WSSLC, WSLID, WSLIC, WRLID, WRLIC, WTII1RCC, WTII1RCD, WTI2RCC, WTII2RCD, WTIICD, WTIICC, WTIIRICD, WTIIRICC, WTIR1RC, WTIR1RD, WTIRCD, WTIRCC, WTS1RCC, WTS2RCC, WTS1RCD, WTS2RCD, WTSCD, WTSCC, WTSRCD, WTSRCC, WTSII1RCC, WTSII1RCD, WTSIICD, WTSIIC, WTSIR1CC, WTSIR1CD, WTSIRCD, WTSIRCC, WTCSD, WTCSC, WTISRCSD, WTISRCSC, WTSCSD, WTSCSC, WTSIRCSD, WTSIRCSC, WTICSD, WTICSC, WTISICSD, WTISICSC, WTSIICSD, WTSIICSC, WTRCSD, WTRCSC, WTIRICC, WT1RCC, WT1RCD, WT2RCC, WT2RCD, WTCC, WTCD, WTRICC, WTRICD, WTI1RCC, WTI1RCD, WTI2RCD, WTIRICD, WTICCD, WTICCC, WTII2RCC FROM T5ITT7
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2MO730Grouping for Form 730nvarchar40CHAR(N' ')NoP15_MO730 Allow NULL? 
3ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
4BEGDAStart Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
5WTNPAWage type for net paynvarchar40CHAR(N' ')YesT512WP15_WTNPA Allow NULL? 
6WTRIRWT IRPEF amount to be refundednvarchar40CHAR(N' ')YesT512WP15_WTRIR Allow NULL? 
7WTRCSWT Amount to be refunded C.S.S.N.nvarchar40CHAR(N' ')YesT512WP15_WTRCS Allow NULL? 
8WTRADWT Employee regional surcharge - Amount to be refundednvarchar40CHAR(N' ')NoT512WP15_WTRAD Allow NULL? 
9WTRACWT Husband/wife regional surcharge. Amount to be refundednvarchar40CHAR(N' ')NoT512WP15_WTRAC Allow NULL? 
10WTRCDWT Employee municipal addit. charge - Amount to be refundednvarchar40CHAR(N' ')NoT512WP15_WTRCD Allow NULL? 
11WTRCCWT H/W municipal additional charge - Amount to be refundednvarchar40CHAR(N' ')NoT512WP15_WTRCC Allow NULL? 
12INTERInterest ratedecimal52DEC((0))YesP15_INTER
13INTREPercentage rate for deferred paymentdecimal52DEC((0))YesP15_INTRE
14RATA1Settlement month of first down payment instalmentnvarchar20NUMC(N'00')YesP15_RATA1 Allow NULL? 
15WT1RTWT first down payment instalment - settlement yearnvarchar40CHAR(N' ')YesT512WP15_WT1RT Allow NULL? 
16WT1DFWT 1st instalment: deficit differencenvarchar40CHAR(N' ')YesT512WP15_WT1DF Allow NULL? 
17WT1INWT 1st instalment - interestnvarchar40CHAR(N' ')YesT512WP15_WT1IN Allow NULL? 
18WT1IIWt 1st instalment: deficit interestnvarchar40CHAR(N' ')NoT512WP15_WT1II Allow NULL? 
19RATA2Settlement month for 2nd down payment instalmentnvarchar20NUMC(N'00')YesP15_RATA2 Allow NULL? 
20WT2RTWT 2nd or single down payment instalment - settlement yearnvarchar40CHAR(N' ')YesT512WP15_WT2RT Allow NULL? 
21WT2INWT 2nd instalment - interestnvarchar40CHAR(N' ')YesT512WP15_WT2IN Allow NULL? 
22MFRA1Final payment month for I/II advance payment instalmentnvarchar20NUMC(N'00')YesP15_MFRAT Allow NULL? 
23MFRA2Final payment month for I/II advance payment instalmentnvarchar20NUMC(N'00')YesP15_MFRAT Allow NULL? 
24WTTIRWT Personal Income Tax payroll instalmentnvarchar40CHAR(N' ')YesT512WP15_WTTIR Allow NULL? 
25WTIDFWT IRPEF instalment for deficit differencenvarchar40CHAR(N' ')YesT512WP15_WTIDF Allow NULL? 
26WTIINWT IRPEF instalment interestnvarchar40CHAR(N' ')YesT512WP15_WTII1 Allow NULL? 
27WTIIIWt 1st instalment: deficit interestnvarchar40CHAR(N' ')NoT512WP15_WTIII Allow NULL? 
28WTTCSWT CSSN payroll instalmentnvarchar40CHAR(N' ')YesT512WP15_WTTCS Allow NULL? 
29WTCDFWT CSSN instalment deficit differencenvarchar40CHAR(N' ')YesT512WP15_WTCDF Allow NULL? 
30WTICSWT CSSN interest instalmentnvarchar40CHAR(N' ')YesT512WP15_WTICS Allow NULL? 
31WTTRCWT Regional withholding - Husband/Wifenvarchar40CHAR(N' ')NoT512WP15_WTTRC Allow NULL? 
32WTCRCWT regional surcharge deficit for husband/wifenvarchar40CHAR(N' ')NoT512WP15_WTCRC Allow NULL? 
33WTIRCWT Regional surcharge interest for husband/wifenvarchar40CHAR(N' ')NoT512WP15_WTXRC Allow NULL? 
34WTDRCWt deficit interestnvarchar40CHAR(N' ')NoT512WP15_WTDRC Allow NULL? 
35WTTRDWT Regional withholding - Employeenvarchar40CHAR(N' ')NoT512WP15_WTTRD Allow NULL? 
36WTCRDWT employee regional surcharge deficitnvarchar40CHAR(N' ')NoT512WP15_WTCRD Allow NULL? 
37WTIRDWT Regional surcharge interest for employeenvarchar40CHAR(N' ')NoT512WP15_WTXRD Allow NULL? 
38WTDRDWt deficit interestnvarchar40CHAR(N' ')NoT512WP15_WTDRD Allow NULL? 
39WTTACWT Payroll instalment for separate taxation down paymentnvarchar40CHAR(N' ')YesT512WP15_WTTAC Allow NULL? 
40WTADFWT d.p. instalment for deficit difference separate taxationnvarchar40CHAR(N' ')YesT512WP15_WTADF Allow NULL? 
41WTIACWT interest instalment for separate taxation down paymentnvarchar40CHAR(N' ')YesT512WP15_WTIAC Allow NULL? 
42WTDACWt deficit interestnvarchar40CHAR(N' ')NoT512WP15_WTDAC Allow NULL? 
43WTTADWT Payroll amount of employee separate taxation down paymentnvarchar40CHAR(N' ')NoT512WP15_WTTAD Allow NULL? 
44WTADDWt dwn pmnt instalm.separ.taxation employee deficit differ.nvarchar40CHAR(N' ')NoT512WP15_WTADD Allow NULL? 
45WTIADWT down payment instalment for EE interest separate taxationnvarchar40CHAR(N' ')NoT512WP15_WTXAD Allow NULL? 
46WTDDDWt deficit interestnvarchar40CHAR(N' ')NoT512WP15_WTDDD Allow NULL? 
47WTTCCWT municipal withholding - Husband/Wifenvarchar40CHAR(N' ')NoT512WP15_WTTCC Allow NULL? 
48WTCCCWT Husband/Wife municipal additional charge deficitnvarchar40CHAR(N' ')NoT512WP15_WTCCC Allow NULL? 
49WTICCWT Municipal add. charge interest for husband/wifenvarchar40CHAR(N' ')NoT512WP15_WTXCC Allow NULL? 
50WTDCCWt deficit interestnvarchar40CHAR(N' ')NoT512WP15_WTDCC Allow NULL? 
51WTTCDWT municipal withholding for employeenvarchar40CHAR(N' ')NoT512WP15_WTTCD Allow NULL? 
52WTCCDWT Employee Municipal Additional Charge deficitnvarchar40CHAR(N' ')NoT512WP15_WTCXD Allow NULL? 
53WTICDWT Municipal additional charge interest for employeenvarchar40CHAR(N' ')NoT512WP15_WTXCD Allow NULL? 
54WTDCDWt deficit interestnvarchar40CHAR(N' ')NoT512WP15_WTDCD Allow NULL? 
55WT1RDWT 1st down pymnt instalment f. severance pay year-Tax Payernvarchar40CHAR(N' ')YesT512WP15_WT1RD Allow NULL? 
56WT1RCWT first down payment instalment for severance pay year-H/Wnvarchar40CHAR(N' ')YesT512WP15_WT1RC Allow NULL? 
57WT2RDWT 2nd or single DP instalment for severance pay year-TPnvarchar40CHAR(N' ')YesT512WP15_WT2RD Allow NULL? 
58WT2RCWT 2nd or single DP instalment for severance pay year-H/Wnvarchar40CHAR(N' ')YesT512WP15_WT2RC Allow NULL? 
59W1DFDWT first difference instalment for deficit - Tax payernvarchar40CHAR(N' ')YesT512WP15_W1DFD Allow NULL? 
60W1DFCWT first difference instalment for deficit - Husband/Wifenvarchar40CHAR(N' ')YesT512WP15_W1DFC Allow NULL? 
61W1IIDWT first interest instalment for deficit - Tax Payernvarchar40CHAR(N' ')NoT512WP15_W1IID Allow NULL? 
62W1IICWT first interest instalment for deficit - Husband/Wifenvarchar40CHAR(N' ')NoT512WP15_W1IIC Allow NULL? 
63W1INDWT first interest instalment - tax payernvarchar40CHAR(N' ')YesT512WP15_W1IND Allow NULL? 
64W1INCWT first interest instalment - Husband/Wifenvarchar40CHAR(N' ')YesT512WP15_W1INC Allow NULL? 
65W2INDWT second interest instalment - Tax Payernvarchar40CHAR(N' ')YesT512WP15_W2IND Allow NULL? 
66W2INCWT second interest instalment - Husband/Wifenvarchar40CHAR(N' ')YesT512WP15_W2INC Allow NULL? 
67WTNP2Wage-type net pay 2nvarchar40CHAR(N' ')YesT512WP15_WTNP2 Allow NULL? 
68W2DFDWT 2nd instalment of deficit difference - taxpayernvarchar40CHAR(N' ')YesT512WP15_W2DFD Allow NULL? 
69W2DFCWT 2nd instalment of deficit difference - husband/wifenvarchar40CHAR(N' ')YesT512WP15_W2DFC Allow NULL? 
70WSRIRWT reversal PIT refundable amountnvarchar40CHAR(N' ')YesT512WP15_WSRIR Allow NULL? 
71WSRADWT reversal Regional Surcharge refundable amount - EEnvarchar40CHAR(N' ')YesT512WP15_WSRAD Allow NULL? 
72WSRCDWT reversal Municipal Surcharge refundable amount EEnvarchar40CHAR(N' ')YesT512WP15_WSRCD Allow NULL? 
73WSRACWT reversal Regional Surcharge refundable amount - H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRAC Allow NULL? 
74WSRCCWT reversal Municipal Surcharge refundable amount - H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRCC Allow NULL? 
75WS1RDWT reversal 1st down payment installment - tax payernvarchar40CHAR(N' ')YesT512WP15_WS1RD Allow NULL? 
76WSINDWT reversal 1st interest installment - tax payernvarchar40CHAR(N' ')YesT512WP15_WSIND Allow NULL? 
77WSIIDWT reversal 1st deficit interest install. - tax payernvarchar40CHAR(N' ')YesT512WP15_WSIID Allow NULL? 
78WS1RCWT reversal 1st payment installment - settlement year - H/Wnvarchar40CHAR(N' ')YesT512WP15_WS1RC Allow NULL? 
79WSINCWT reversal interest installment - H/Wnvarchar40CHAR(N' ')YesT512WP15_WSINC Allow NULL? 
80WSIICWt reversal 1st deficit interest installment - h/wnvarchar40CHAR(N' ')YesT512WP15_WSIIC Allow NULL? 
81WS2RDWT reversal 2nd or single down payment install. - tax payernvarchar40CHAR(N' ')YesT512WP15_WS2RD Allow NULL? 
82WS2NDWT reversal 2nd interest installment - tax payernvarchar40CHAR(N' ')YesT512WP15_WS2ND Allow NULL? 
83WS2RCWT reversal 2nd or single down payment install. - H/Wnvarchar40CHAR(N' ')YesT512WP15_WS2RC Allow NULL? 
84WS2NCWT reversal 2nd interest installment - H/Wnvarchar40CHAR(N' ')YesT512WP15_WS2NC Allow NULL? 
85WSTIRWT reversal PIT installmentnvarchar40CHAR(N' ')YesT512WP15_WSTIR Allow NULL? 
86WSII1WT reversal personal income tax installment - interestnvarchar40CHAR(N' ')YesT512WP15_WSII1 Allow NULL? 
87WSIIIWT revrsal 1st deficit interest installmentnvarchar40CHAR(N' ')YesT512WP15_WSIII Allow NULL? 
88WSTRDWT reversal Regional Withholding EEnvarchar40CHAR(N' ')YesT512WP15_WSTRD Allow NULL? 
89WSXRDReversal of WT Employee Regional Surcharge Interestnvarchar40CHAR(N' ')YesT512WP15_WSXRD Allow NULL? 
90WSDRDWT reversal interest deficitnvarchar40CHAR(N' ')YesT512WP15_WSDRD Allow NULL? 
91WSTRCWT reversal Regional Withholding H/Wnvarchar40CHAR(N' ')YesT512WP15_WSTRC Allow NULL? 
92WSXRCReversal of WT Wife/Husband Regional Surcharge Interestnvarchar40CHAR(N' ')YesT512WP15_WSXRC Allow NULL? 
93WSDRCWT reversal interest deficitnvarchar40CHAR(N' ')YesT512WP15_WSDRC Allow NULL? 
94WSTCDWT reversal Municipal Withholding EEnvarchar40CHAR(N' ')YesT512WP15_WSTCD Allow NULL? 
95WSXCDReversal of WT Employee Municipal Surcharge Interestnvarchar40CHAR(N' ')YesT512WP15_WSXCD Allow NULL? 
96WSDCDWT reversal interest deficitnvarchar40CHAR(N' ')YesT512WP15_WSDCD Allow NULL? 
97WSXCCReversal of WT Wife/Husband Municipal Surcharge Interestnvarchar40CHAR(N' ')YesT512WP15_WSXCC Allow NULL? 
98WSTCCWT reversal Municipal Withholding H/Wnvarchar40CHAR(N' ')YesT512WP15_WSTCC Allow NULL? 
99WSDCCWT reversal interest deficitnvarchar40CHAR(N' ')YesT512WP15_WSDCC Allow NULL? 
100WSTADWT reversal separate taxation down payment installment-EEnvarchar40CHAR(N' ')YesT512WP15_WSTAD Allow NULL? 
101WSXADReversal of WT EE interest separate taxation instalmentnvarchar40CHAR(N' ')YesT512WP15_WSXAD Allow NULL? 
102WSDDDWT reversal interest deficitnvarchar40CHAR(N' ')YesT512WP15_WSDDD Allow NULL? 
103WSTACWT reversal separate taxation down payment installmentnvarchar40CHAR(N' ')YesT512WP15_WSTAC Allow NULL? 
104WSIACWT rev.separate taxation down payment installment-interestnvarchar40CHAR(N' ')YesT512WP15_WSIAC Allow NULL? 
105WSDACWT reversal interest deficitnvarchar40CHAR(N' ')YesT512WP15_WSDAC Allow NULL? 
106WSRXCWT deficit - PIT refund reversalnvarchar40CHAR(N' ')YesT512WP15_WSRXC Allow NULL? 
107WSRXDWT interest deficit PIT refund reversalnvarchar40CHAR(N' ')YesT512WP15_WSRXD Allow NULL? 
108WSRXEWT deficit Regional Surcharge refund reversal - EEnvarchar40CHAR(N' ')YesT512WP15_WSRXE Allow NULL? 
109WSRXFWT interest deficit Regional Surcharge refund reversal - EEnvarchar40CHAR(N' ')YesT512WP15_WSRXF Allow NULL? 
110WSRXGWT deficit Municipal Surcharge refund reversal EEnvarchar40CHAR(N' ')YesT512WP15_WSRXG Allow NULL? 
111WSRXHWT interest deficit Municipal Surcharge refund reversal EEnvarchar40CHAR(N' ')YesT512WP15_WSRXH Allow NULL? 
112WSRXIWT deficit Regional Surcharge refund reversal H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRXI Allow NULL? 
113WSRXJWT interest deficit Regional Surcharge refund reversal H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRXJ Allow NULL? 
114WSRXKWT deficit Municipal Surcharge refund reversal H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRXK Allow NULL? 
115WSRXLWt interest deficit Municipal Surcharge refund reversal H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRXL Allow NULL? 
116WSRXMWT interest PIT refund reversalnvarchar40CHAR(N' ')YesT512WP15_WSRXM Allow NULL? 
117WSRXNWT interest Regional Surcharge refund reversal EEnvarchar40CHAR(N' ')YesT512WP15_WSRXN Allow NULL? 
118WSRXOWT interest Municipal Surcharge refund reversal EEnvarchar40CHAR(N' ')YesT512WP15_WSRXO Allow NULL? 
119WSRXPWT interest Regional Surcharge refund reversal H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRXP Allow NULL? 
120WSRXQWT interest Municipal Surcharge refund reversal H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRXQ Allow NULL? 
121MEINTIntegration monthnvarchar20NUMC(N'00')YesP15_MFINT Allow NULL? 
122LC005Accrual from delayed adjust./stlmnt mnth (Legal Change 2005)char10CHAR(N' ')YesP15_LC005 Allow NULL? 
123WTRIDIRPEF amount to be refunded WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WTRIRD Allow NULL? 
124WTRICIRPEF amount to be refunded WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTRIRC Allow NULL? 
125WTTIDInstallment WT in IRPEF coupon for declarantnvarchar40CHAR(N' ')YesT512WP15_IMTID Allow NULL? 
126WTTICIRPEF coupon intstallment WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTTIC Allow NULL? 
127WTIDDPIT installment WT difference for deficit for declarantnvarchar40CHAR(N' ')YesT512WP15_WTIDD Allow NULL? 
128WTIDCPIT installment WT difference for deficit for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTIDC Allow NULL? 
129WTINDInterest PIT installment WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WTIID Allow NULL? 
130WTINCInterest PIT installment WT for spousenvarchar40CHAR(N' ')YesT512WP15_WTINC Allow NULL? 
131WTACDMunicipal surcharge down payment WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WTACD Allow NULL? 
132WTACCMunicipal surcharge down payment WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTACC Allow NULL? 
133WTACTTotal municipal surcharge down payment WTnvarchar40CHAR(N' ')YesT512WP15_WTACT Allow NULL? 
134WSACDPIT municipal surcharge down payment reversal for declarantnvarchar40CHAR(N' ')YesT512WP15_WSACD Allow NULL? 
135WSACCPIT municipal surcharge down payment reversal for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSACC Allow NULL? 
136WSACTTotal PIT municipal surcharge down payment reversalnvarchar40CHAR(N' ')YesT512WP15_WSACT Allow NULL? 
137WSAXDPIT municipal surcharge int. reversal for declarantnvarchar40CHAR(N' ')YesT512WP15_WSAXD Allow NULL? 
138WSAXCPIT municipal surcharge int. reversal for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSAXC Allow NULL? 
139WSAXTTotal PIT municipal surcharge int. reversalnvarchar40CHAR(N' ')YesT512WP15_WSAXT Allow NULL? 
140WSDDAPIT municipal surcharge int. deficit reversal for declarantnvarchar40CHAR(N' ')YesT512WP15_WSDAD Allow NULL? 
141WSDCAPIT municipal surcharge int. deficit reversal for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSDCA Allow NULL? 
142WSDTATotal PIT municipal surcharge int. deficit reversalnvarchar40CHAR(N' ')YesT512WP15_WSDTA Allow NULL? 
143WTAIDPIT municipal surcharge down payment interest for declarantnvarchar40CHAR(N' ')YesT512WP15_WTAID Allow NULL? 
144WTAICPIT municipal surcharge down payment interest for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTAIC Allow NULL? 
145WTAITTotal PIT municipal surcharge down payment interestnvarchar40CHAR(N' ')YesT512WP15_WTAIT Allow NULL? 
146WTTDDPIT municipal surcharge down payment deficit for declarantnvarchar40CHAR(N' ')YesT512WP15_WTTDD Allow NULL? 
147WTTDCPIT municipal surcharge down payment deficit for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTTDC Allow NULL? 
148WTTDTTotal PIT municipal surcharge down payment deficitnvarchar40CHAR(N' ')YesT512WP15_WTTDT Allow NULL? 
149WTDDAPIT municipal surcharge DP deficit interest for declarantnvarchar40CHAR(N' ')YesT512WP15_WTDDA Allow NULL? 
150WTDCAPIT municipal surcharge down payment deficit interest f. H/Wnvarchar40CHAR(N' ')YesT512WP15_WTDCA Allow NULL? 
151WTDTATotal PIT municipal surcharge DP deficit interestnvarchar40CHAR(N' ')YesT512WP15_WTDTA Allow NULL? 
152WSTIDPIT reversal installment WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WSTID Allow NULL? 
153WSTICPIT reversal installment WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSTIC Allow NULL? 
154WSID1Interest PIT installment WT reversal for declarantnvarchar40CHAR(N' ')YesT512WP15_WSID1 Allow NULL? 
155WSIC1Interest PIT installment WT reversal for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSIC1 Allow NULL? 
156WSRDXPIT refund reversal deficit WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WSRDX Allow NULL? 
157WSRCXPIT refund reversal deficit WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRCX Allow NULL? 
158WSRDDPIT refund reversal deficit interest WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WSRDD Allow NULL? 
159WSRDCPIT refund reversal deficit interest WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRDC Allow NULL? 
160WSRIDPIT amount to be refunded reversal WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WSRID Allow NULL? 
161WSRICPIT amount to be refunded reversal WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WSRIC Allow NULL? 
162WTIDIDeficit interest PIT WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WTIDI Allow NULL? 
163WTICIDeficit interest PIT WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTICC Allow NULL? 
164WTDIIPersonal Income Tax Deficit Interest Status WT for declarantnvarchar40CHAR(N' ')YesT512WP15_WTDII Allow NULL? 
165WTCIIPersonal Income Tax Deficit Interest Status WT for H/Wnvarchar40CHAR(N' ')YesT512WP15_WTCII Allow NULL? 
166WTCLRWT Tax Declaration in July to be repaidnvarchar40CHAR(N' ')YesT512WP15_WTCLR Allow NULL? 
167WTCLTWT Tax Declaration in July to be withdrawnnvarchar40CHAR(N' ')YesT512WP15_WTCLT Allow NULL? 
168WTLSDSubstitute Tax Withholding for Extra Work (Declarant)nvarchar40CHAR(N' ')YesT512WP15_WTLSD Allow NULL? 
169WTLSCSubstitute Tax Withholding for Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WTLSC Allow NULL? 
170WILSDSubstitute Tax Deficit for Extra Work (Declarant)nvarchar40CHAR(N' ')YesT512WP15_WILSD Allow NULL? 
171WILSCSubstitute Tax Deficit for Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WILSC Allow NULL? 
172WIISDDeficit Interest of Substitute Tax on Extra Work (Declarant)nvarchar40CHAR(N' ')YesT512WP15_WIISD Allow NULL? 
173WIISCDeficit Interest of Substitute Tax on Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WIISC Allow NULL? 
174WINSDInterest on Substitute Tax for Extra Work (Declarant)nvarchar40CHAR(N' ')YesT512WP15_WINSD Allow NULL? 
175WINSCInterest on Substitute Tax for Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WINSC Allow NULL? 
176WSISDSubst.Deficit Reversal for Extra Work (Declarant)nvarchar40CHAR(N' ')YesT512WP15_WSISD Allow NULL? 
177WSISCSubst.Deficit Reversal for Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WSISC Allow NULL? 
178WSNSDSubst. Interest Reversal for Extra Work (Employee)nvarchar40CHAR(N' ')YesT512WP15_WSNSD Allow NULL? 
179WSNSCSubst. Interest Reversal for Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WSNSC Allow NULL? 
180WRLSDSubstitute Refund for Extra Work (Declarant)nvarchar40CHAR(N' ')YesT512WP15_WRLSD Allow NULL? 
181WRLSCSubstitute Refund for Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WRLSC Allow NULL? 
182WRTADRefund on Separate Taxation (Employee)nvarchar40CHAR(N' ')YesT512WP15_WRTAD Allow NULL? 
183WRTACRefund on Separate Taxation (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WRTAC Allow NULL? 
184WSLSCSubstitute Tax Reversal for Extra Work (Spouse)nvarchar40CHAR(N' ')YesT512WP15_WSLSC Allow NULL? 
185WSLSDSubstitute Tax Reversal for Extra Work (Declarant)nvarchar40CHAR(N' ')YesT512WP15_WSLSD Allow NULL? 
186WISLDDeclarant rent substitute taxnvarchar40CHAR(N' ')YesT512WP15_WISLD Allow NULL? 
187WISLCSpouse rent substitute taxnvarchar40CHAR(N' ')YesT512WP15_WISLC Allow NULL? 
188WIILDDeclarant rent tax int.nvarchar40CHAR(N' ')YesT512WP15_WIILD Allow NULL? 
189WIILCSpouse rent tax int.nvarchar40CHAR(N' ')YesT512WP15_WIILC Allow NULL? 
190WSILDDeclarant Rent Tax reversalnvarchar40CHAR(N' ')YesT512WP15_WSILD Allow NULL? 
191WSILCSpouse Rent Tax reversalnvarchar40CHAR(N' ')YesT512WP15_WSILC Allow NULL? 
192WRILDDeclarant int. rentals reversalnvarchar40CHAR(N' ')YesT512WP15_WRILD Allow NULL? 
193WRILCSpouse int. rentals reversalnvarchar40CHAR(N' ')YesT512WP15_WRILC Allow NULL? 
194WINLDDeclarant rent tax incap.nvarchar40CHAR(N' ')YesT512WP15_WINLD Allow NULL? 
195WINLCSpouse rent tax incap.nvarchar40CHAR(N' ')YesT512WP15_WINLC Allow NULL? 
196WSSLDDeclarant rent tax incap. interestnvarchar40CHAR(N' ')YesT512WP15_WSSLD Allow NULL? 
197WSSLCSpouse Rental incap. interestnvarchar40CHAR(N' ')YesT512WP15_WSSLC Allow NULL? 
198WSLIDDeclarant Rental incap. reversalnvarchar40CHAR(N' ')YesT512WP15_WSLID Allow NULL? 
199WSLICSpouse Rental incap. reversalnvarchar40CHAR(N' ')YesT512WP15_WSLIC Allow NULL? 
200WRLIDDeclarant rental reimbursementnvarchar40CHAR(N' ')YesT512WP15_WRLID Allow NULL? 
201WRLICSpouse rental reimbursementnvarchar40CHAR(N' ')YesT512WP15_WRLIC Allow NULL? 
202WTII1RCCWT inter. def. 1st down payment inst. FlatTax RentInc Spousenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTII1RCC Allow NULL? 
203WTII1RCDWT inter. def. 1st down payment inst. FlatTax RentInc Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTII1RCD Allow NULL? 
204WTI2RCCWT Deficit 2nd installment Flat Tax on rental income Spousenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTI2RCC Allow NULL? 
205WTII2RCDWT inter. def. 2nd down paym. install. Decl FlatTaxRentalIncnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTII2RCD Allow NULL? 
206WTIICDWT inter. def. of Declarant Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIICD Allow NULL? 
207WTIICCWT inter. def. of Spouse Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIICC Allow NULL? 
208WTIIRICDWT Inter. reversal def. of Declarant Flat Tax on rental inc.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIIRICD Allow NULL? 
209WTIIRICCWT Inter. reversal def. of Spouse Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIIRICC Allow NULL? 
210WTIR1RCWT Interests on installments 1st inst. Spouse FlatTaxRentIncnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIR1RC Allow NULL? 
211WTIR1RDWT Interests on installments 1st inst. Decl. FlatTaxRentIncnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIR1RD Allow NULL? 
212WTIRCDWT Interests on installments of Decl. Flat Tax on rent.inc.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIRCD Allow NULL? 
213WTIRCCWT Interests on installments of spouse Flat Tax on rent.inc.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIRCC Allow NULL? 
214WTS1RCCWT Reversal 1st down paym. inst. Flat Tax on rent.income Sp.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTS1RCC Allow NULL? 
215WTS2RCCWT Reversal 2nd down paym. inst. Flat Tax on rent. inc. Sp.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTS2RCC Allow NULL? 
216WTS1RCDWT Reversal 1st down paym. inst. Flat Tax on rent.inc. Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTS1RCD Allow NULL? 
217WTS2RCDWT Reversal 2nd down payment inst. Flat Tax rental inc.Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTS2RCD Allow NULL? 
218WTSCDWT Reversal of Flat Tax on rental income Declarantnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSCD Allow NULL? 
219WTSCCWT Reversal of Flat Tax on rental income Spousenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSCC Allow NULL? 
220WTSRCDWT Refund of declarant flat tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSRCD Allow NULL? 
221WTSRCCWT Refund of Spouse Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSRCC Allow NULL? 
222WTSII1RCCWT Inter. rev. def. 1st down paym. inst. FlatTax RentInc Sp.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSII1RCC Allow NULL? 
223WTSII1RCDWT Rev. inter. def. 1st down paym.inst. FlatTaxRentInc Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSII1RCD Allow NULL? 
224WTSIICDWT Reversal inter. def. Flat Tax on rental income Declarantnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIICD Allow NULL? 
225WTSIICWT Reversal int. def. FlatTax RentInc Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIIC Allow NULL? 
226WTSIR1CCWT Rev. inter. on installments 1st DP inst. FlatTaxRentIncSpnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIR1CC Allow NULL? 
227WTSIR1CDWT Rev. int. inst. 1st DP inst. FlatTaxRentInc Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIR1CD Allow NULL? 
228WTSIRCDWT Reversal int. installments Flat Tax on rent.inc. Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIRCD Allow NULL? 
229WTSIRCCWT Reversal int. installm. Flat Tax RentInc Sp.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIRCC Allow NULL? 
230WTCSDWT for Declarant Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTCSD Allow NULL? 
231WTCSCWage type for Spouse Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTCSC Allow NULL? 
232WTISRCSDWT Int. installments of Declarant Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTISRCSD Allow NULL? 
233WTISRCSCWT Int. on installments of Spouse Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTISRCSC Allow NULL? 
234WTSCSDWage type Reversal of Declarant Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSCSD Allow NULL? 
235WTSCSCWage type Reversal of Spouse Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSCSC Allow NULL? 
236WTSIRCSDWage type Reversal int. inst. Decl. Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIRCSD Allow NULL? 
237WTSIRCSCWage type Reversal int. inst. Spouse Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIRCSC Allow NULL? 
238WTICSDWage type Deficit of Declarant Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTICSD Allow NULL? 
239WTICSCWage type deficit of Spouse Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTICSC Allow NULL? 
240WTISICSDWage type interests def. Declarant Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTISICSD Allow NULL? 
241WTISICSCWage type interests def. Spouse Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTISICSC Allow NULL? 
242WTSIICSDWage type rev. interests def. Decl. Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIICSD Allow NULL? 
243WTSIICSCWage type Reversal interests def. Spouse Solidarity Contrib.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTSIICSC Allow NULL? 
244WTRCSDWage type Refund of Declarant Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTRCSD Allow NULL? 
245WTRCSCWage type Refund of Spouse Solidarity Contributionnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTRCSC Allow NULL? 
246WTIRICCWT Refund reversal deficit of Flat Tax on rental inc. Spousenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIRICC Allow NULL? 
247WT1RCCWT 1st down payment install. of flat tax on rent.inc. Spousenvarchar40CHAR(N' ')YesT512WHRPAYIT_WT1RCC Allow NULL? 
248WT1RCDWT 1st down payment install. of flat tax on rent.inc. Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WT1RCD Allow NULL? 
249WT2RCCWT 2nd down payment install. of flat tax on rent.inc. Spousenvarchar40CHAR(N' ')YesT512WHRPAYIT_WT2RCC Allow NULL? 
250WT2RCDWT 2nd down payment installment of decl. flat tax on RentIncnvarchar40CHAR(N' ')YesT512WHRPAYIT_WT2RCD Allow NULL? 
251WTCCWT Spouse Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTCC Allow NULL? 
252WTCDWT Declarant Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTCD Allow NULL? 
253WTRICCWT Refund of Spouse Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTRICC Allow NULL? 
254WTRICDWT Refund of Flat Tax on rental income Declarantnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTRICD Allow NULL? 
255WTI1RCCWT 1st installment deficit of Spouse Flat Tax on rent.incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTI1RCC Allow NULL? 
256WTI1RCDWT Deficit 1st installment Flat Tax on rental income Decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTI1RCD Allow NULL? 
257WTI2RCDWT Deficit 2nd down paym. inst. Flat Tax on rent.inc. decl.nvarchar40CHAR(N' ')YesT512WHRPAYIT_WTI2RCD Allow NULL? 
258WTIRICDWT Reversal refund def. Flat Tax on rental income Declarantnvarchar40CHAR(N' ')YesT512WHRPAYIT_WTIRICD Allow NULL? 
259WTICCDWT deficit of Declarant Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTICD Allow NULL? 
260WTICCCWT Deficit of Spouse Flat Tax on rental incomenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTICC Allow NULL? 
261WTII2RCCWT inter. def. 2nd down payment inst. FlatTax RentInc spousenvarchar40CHAR(N' ')YesT512WHRPAYIT_WTII2RCC Allow NULL? 
NamePrimaryUniqueTypeColumns
T5ITT7~0YesYesCLUSTEREDENDDA, MO730, MANDT