VIXCSKTAXRET_P

Property Tax Return SK - Items - Sections II,III,IV | #transactional | Component: Real Estate Slovakia

🔑 Keys (9)
💰 Amounts (1)
∑ Quantities
📅 Dates (5)
☰ Categorical (23)
Other (108)
🔗 Relations (3)

Column Name	Description
MANDT	Client
BUKRS FK	Leading Company Code
GJAHR	Fiscal Year
SPRAVCE	Tax Administrator
RETNR	Number of Declarations Created
TYPDANP	Type of Declaration	Show values
INTRENO	Internal Key of Real Estate Object
EFEFROM	Valid From
EFETO	Valid To

Column Name	Description
💲 Currency Key (WAERS):
TAXTOTAL	Total Tax Amount

Column Name	Description

Column Name	Description
EFEFROM	Valid From
EFETO	Valid To
HX_DATVYDRAZ	Auction Date
DATVYPOCTU	Calculation Date
CASVYPOCTU	Calculation Time

Column Name	Description
TYPDANP	Type of Declaration	Show values
TYPNEM	Real Estate Object Type	Show values
ODDIL	Section in Declaration	Show values
XAGR	Allow Aggregation	Show values
H_PRAVZTAH	Legal Relationship	Show values
H_SPOLVLAST	Form of Co-Ownership	Show values
H_NBYT	Non-Living or Commercial Area	Show values
HX_AUCTION	Property Acquired/Sold in Auction	Show values
P_PRICEBYEXP	Land Price Determined by Expert	Show values
P_ROCSAZ	Annual Tax Rate	Show values
BA_ROCSAZ	Annual Tax Rate	Show values
BB_ROCSAZ_A	Annual Tax Rate	Show values
BB_ROCSAZ_B	Annual Tax Rate	Show values
BB_ROCSAZ_C	Annual Tax Rate	Show values
BB_ROCSAZ_D	Annual Tax Rate	Show values
BB_ROCSAZ_E	Annual Tax Rate	Show values
BB_ROCSAZ_F	Annual Tax Rate	Show values
BB_ROCSAZ_G	Annual Tax Rate	Show values
BB_ROCSAZ_H	Annual Tax Rate	Show values
BB_ROCSAZ_I	Annual Tax Rate	Show values
F_ROCSAZ_B	Annual Tax Rate	Show values
F_ROCSAZ_NB	Annual Tax Rate	Show values
XTSVS	Transformer Station or Vending Stand	Show values

Column Name	Description	Domain name
SWENR	Business Entity Number	REBDBENO
KEYNUM	Real Estate Object Number	REXCSKKEYNUM
SHEETSUBNR	Sequential Number of Row in the Attachement
SHEET	Attachment Number	REXCSKSHEET
H_ICO	Company Identification Number (ICO)
H_DIC	VAT Registration Number
HX_KODOBCE	Municipality or City District Code	REXCSKKODOBCE
HX_KODCOBCE	Subdistrict Code	REXCSKKODCOBCE
HX_KODKU	Cadastral District Code	REXCSKKODKU
H_NAZOBCE	Name of Municipality or City District	REXCSKNAZOBCE
H_NAZKU	Cadastral District Name	REXCSKNAZKU
H_PARCELA	Parcel	REXCSKPARCELA
H_POPIS	Name of Real Estate Object	REXCSKPOPIS80
H_POCSPOL	Number of Owners	REXCSKPOCSPOL
H_SPOLDOH	Co-Owner by Agreement	REXCSKSPOLDOH
H_USAGE	Usage of Land, Apartment, Commercial Area	REXCSKUSAGE
HX_KOSVOB	Tax Exemption Code	REXCSKKODOSVOB
HX_OSVOD	Valid From	GJAHR
HX_OSVDO	Valid To	GJAHR
HX_KODREDU	Tax Reduction Code	REXCSKKODOSVOB
HX_REDOD	Valid From	GJAHR
HX_REDDO	Valid To	GJAHR
H_DUVOSVOB	Description	REXCSKDUVOSVOB
H_ULICE	Street	TEXT60
H_CISLOP	Registration Number	REXCSKCISLOP
H_CIZIPOZ	Building on Third-Party Plot
H_CISBYT	Number of Apartment
H_CISNBYT	Commercial or Non-Living Area Number
P_VYMERA	Land Area	REXCSKPLOCHA
P_VYMERAOSV	Exempted Land Area	REXCSKPLOCHA
P_VYMERADAN	Taxable Land Area	REXCSKPLOCHA
P_TRANSFSTAT	Area Built in by Transformer Station or Vending Stand	REXCSKPLOCHA
P_HODNPUDY	Land Price	REXCSKCENAP
P_ZAKLAD	Tax Base Amount of Land	REXCSKZAKLADL
P_ZAKLAD_Z	Tax Base Amount	REXCSKZAKLAD
BA_VYMERAZAS	Built-In Area	REXCSKPLOCHA
BA_VYMERAPODL	Taxable Floor Area	REXCSKPLOCHA
BA_VYMERAOSV	Floor Area Exempted From Tax (Building)	REXCSKPLOCHA
BA_KOEFOSL	Factor	REXCSKKOEFOSL
BA_ZAKLADM2	Tax Base Amount of Buildings	REXCSKPLOCHA
BA_POCPATER	Number of Floors Above the First Floor
BA_PRIPLPOD	Increment for Additional Floors	REXCSKPRIPLPOD
BB_VYMERAZAS	Built-In Area	REXCSKPLOCHA
BB_VYMERAPODL	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAOSV	Floor Area Exempted From Tax (Building)	REXCSKPLOCHA
BB_VYMERAPODL_A	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_B	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_C	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_D	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_E	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_F	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_G	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_H	Taxable Floor Area	REXCSKPLOCHA
BB_VYMERAPODL_I	Taxable Floor Area	REXCSKPLOCHA
BB_POCPATER	Number of Floors Above the First Floor
BB_KOEFOSL	Factor	REXCSKKOEFOSL
BB_ZAKLADM2	Tax Base Amount of Buildings	REXCSKPLOCHA
BB_POMCAST_A	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_B	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_C	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_D	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_E	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_F	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_G	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_H	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_POMCAST_I	Tax Base Amount (Floor Areas Used for Diff.Purposes)	REXCSZAKLPOM
BB_PRIPLPOD_A	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_B	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_C	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_D	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_E	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_F	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_G	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_H	Increment for Additional Floors	REXCSKPRIPLPOD
BB_PRIPLPOD_I	Increment for Additional Floors	REXCSKPRIPLPOD
BB_DANPOM_A	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_B	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_C	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_D	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_E	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_F	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_G	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_H	Tax Amount (Buildings)	REXCSKDANB
BB_DANPOM_I	Tax Amount (Buildings)	REXCSKDANB
F_VYMERAPODL_B	Floor Area	REXCSKVYMPP
F_VYMERAPODL_NB	Floor Area	REXCSKVYMPP
F_VYMERAOSV_B	Floor Area Exempted From Tax	REXCSKVYMPP
F_VYMERAOSV_NB	Floor Area Exempted From Tax	REXCSKVYMPP
F_PODPLBNONLIV	Apartment Area Not Used for Living	REXCSKVYMPP
F_VYMERADAN_B	Taxable Floor Area	REXCSKVYMPP
F_VYMERADAN_NB	Taxable Floor Area	REXCSKVYMPP
F_ZAKLADM2_B	Taxable Floor Area	REXCSKVYMPP
F_ZAKLADM2_NB	Taxable Floor Area	REXCSKVYMPP
F_DAN_B	Tax Amount (Apartments and Common Areas)	REXCSKDANF
F_DAN_NB	Tax Amount (Apartments and Common Areas)	REXCSKDANF
F_DANPOMV_B	Tax Amount (Apartments and Common Areas)	REXCSKDANF
F_DANPOMV_NB	Tax Amount (Apartments and Common Areas)	REXCSKDANF
F_DANSNIZ_B	Tax Amount (Apartments and Common Areas)	REXCSKDANF
F_DANSNIZ_NB	Tax Amount (Apartments and Common Areas)	REXCSKDANF
POZNAMKA	Remark	REXCSKPOZN
DAN	Total Tax Amount	REXCSKDAN
DANPOMV	Tax Amount (for Part of the Year)	REXCSKDAN
DANSNIZ	Tax Reduction Amount	REXCSKDAN
DANUHR	Simulation of Tax Settlement Amount	REXCSKDAN
DANROZ	Tax Difference Amount	REXCSKDAN
STAVYPOCTU	Calculation Status
USERVYPOCTU	Calculation Executed By	USERNAME
LOG_HNDL	Application Log: Log Handle	SYSUUID_22

Master Data Relations \| to Other Relations ↓	Join Conditions
Property Type Real Estate Object Type Property Type	`VIXCSKTAXRET_P.MANDT == TIVXCSKDRNEM.MANDT` `VIXCSKTAXRET_P.TYPNEM == TIVXCSKDRNEM.TYPNEM` `VIXCSKTAXRET_P.H_DRNEM == TIVXCSKDRNEM.DRNEM`

Other Relations	Join Conditions
Leading Company Code Leading Company Code Client	`VIXCSKTAXRET_P.BUKRS == TIVXCSKHLAVPR.BUKRS` `VIXCSKTAXRET_P.MANDT == TIVXCSKHLAVPR.MANDT`
Subordinate Company Code Subordinate Company Code Client Leading Company Code	`VIXCSKTAXRET_P.BUKRS_MD == TIVXCSKHLAVPRI.BUKRS_MD` `VIXCSKTAXRET_P.MANDT == TIVXCSKHLAVPRI.MANDT` `VIXCSKTAXRET_P.BUKRS == TIVXCSKHLAVPRI.BUKRS`