Tax Definition - SAP B1 SDK Help

Table Name: OVTG

Table Description: Tax Definition

Field	Description	Type	Size	Related	Default Value	Constraints
Code	Code	nVarChar	8	-
Name	Name	nVarChar	50	-
Rate	Rate %	Num	19.6	-
EffecDate	Effective from	Date	8	-
Category	Category	VarChar	1	-	O	O	Output Tax
						I	Input Tax
Account	Tax Account	nVarChar	15	OACT
Locked	Locked	VarChar	1	-	N	Y	Yes
						N	No
DataSource	Data Source	VarChar	1	-	N	N	Unknown
						I	Interface
						U	Update
						M	Import
						O	DI API
						S	Service Layer
						W	Web Client
						A	Doc. Generation Wizard
						D	Restore Wizard
						P	Partner Implementation
						T	Year Transfer
UserSign	User Signature	Int	6	OUSR
IsEC	EU	VarChar	1	-	N	Y	Yes
						N	No
Indicator	Triangular Deal	VarChar	1	OIND
AcqstnRvrs	Acquisition/Reverse	VarChar	1	-	N	Y	Yes
						N	No
NonDedct	Non Deduct. %	Num	19.6	-
AcqsTax	Acquisition Tax Account	nVarChar	15	OACT
GoddsShip	Goods Shipment	VarChar	1	OGSP
NonDedAcc	Non Deduct. Acct	nVarChar	15	OACT
DeferrAcc	Deferred Tax Account	nVarChar	15	OACT
EquVatPr	Equalization Tax %	Num	19.6	-
ReportCode	Group Description	nVarChar	100	-
FixdAssts	Fixed Assets Flag	VarChar	1	-	N	Y	Yes
						N	No
CalcMethod	Calculation Method	VarChar	1	-	R	R	Rate
						F	Fixed
TaxType	Tax Type (VAT or Stamp)	VarChar	1	-	V	V	VAT
						S	Stamp
FixedAmnt	Fixed Amount (LC)	Num	19.6	-
ExtCode	External Code	nVarChar	10	-
Correction	Correction	VarChar	1	-	N	Y	Yes
						N	No
VatCrctn	VAT Correction	nVarChar	8	OVTG
RetVatCode	Returning VAT Code	nVarChar	8	-
RepType	Report Type	Int	11	OKRT
LogInstanc	Log Instance	Int	11	-	0
UpdateDate	Date of Update	Date	8	-
TaxCtgr	Tax Type (Annual List)	nVarChar	6	-	E	E	Excluded
						T	Taxable
						X	Exempt
						N	Not Taxable
						N31	N3.1 - Not Taxable - exports
						N32	N3.2 - Not Taxable - intra-community sales
						N33	N3.3 - Not Taxable - sales to San Marino
						N34	N3.4 - Not Taxable - operations similar to export sales
						N35	N3.5 - Not Taxable - due to tax exemption letter
						N36	N3.6 - Not Taxable - other transactions
						G	Gross Profit
						R	Reverse Charge
						R61	N6.1 - Reverse Charge - disposal of scrap and other recycled materials
						R62	N6.2 - Accounting Reversal - sale of gold and pure silver
						R63	N6.3 - Reverse Charge - subcontracting in the construction sector
						R64	N6.4 - Reverse Charge - sales of buildings
						R65	N6.5 - Reverse Charge - sales of cell phones
						R66	N6.6 - Reverse Charge - sales of electronic products
						R67	N6.7 - Reverse Charge - services of the construction and related sectors
						R68	N6.8 - Reverse Charge - energy sector operations
						R69	N6.9 - Reverse Charge - other cases
						U	Tourism
						A	Taxable - Article 162
						B	Taxable - Article 173 point 5
						C	Taxable - Construction
						D	Taxable - Expected Confirmation
						F	Taxable - Gross
						I	Taxable - Import
						Y	Taxable - Import from EAEU
						L	Taxable - Late Export
						O	Taxable - Not Confirmed
						S	Taxable - Real Estate
						W	Taxable - Sale of Company
						H	Excluded Art. 15
						J	Not Subject
						J21	N2.1 - Not Subject - to VAT under articles from 7 to 7-septies of DPR 633/72
						J22	N2.2 - Not Subject - other cases
						K	Paid in other EU country
						M	Taxable - Article 151 point 1
						P	Taxable - Article 170 point 3
						V	Taxable - Fixed Assets
						Q	Taxable - Tax Free
EquAccount	Equalization Tax Account	nVarChar	15	OACT
UserSign2	Updating User	Int	6	OUSR
IsIGIC	IGIC	VarChar	1	-	N	Y	Yes
						N	No
ServSupply	Service Supply	VarChar	1	OSSP
Inactive	Inactive	VarChar	1	-	N	Y	Yes
						N	No
TaxCtgrBL	Tax Type (Black List)	VarChar	1	-	E	E	Excluded
						T	Taxable
						X	Exempt
						N	Not Taxable
						S	Non-Subject
R349Code	Report 349 Code	Int	11	-	0	0
						1	E
						2	A
						3	T
						4	S
						5	I
						6	M
						7	H
						8	R
						9	D
VatRevAcc	VAT in Revenue Account	nVarChar	15	OACT
CashDisAcc	Cash Discount Account	nVarChar	15	OACT
DpmTaxOAcc	Down Paymnt Tax Offset Account	nVarChar	15	OACT
VatDedAcc	VAT Deductible Account	nVarChar	15	OACT
CstmExpAcc	Customs VAT Expense Account	nVarChar	15	-
CstmAlcAcc	Customs VAT Allocation Account	nVarChar	15	-
TaxRegion	Tax Country Region	nVarChar	5	-	PT	PT	Continental Portugal
						PT-AC	Azores Islands
						PT-MA	Madeira Islands
ExemReason	Tax Exemption Reason	nVarChar	3	TXRE
Agent	Agent	VarChar	1	-	N	Y	Yes
						N	No
OpCode	Tax Operation Code	nVarChar	7	-
Export	Export	VarChar	1	-	N	Y	Yes
						N	No
Section	VAT Section	nVarChar	3	-
SplitPaymt	Split Payment	VarChar	1	-	N	Y	Yes
						N	No
SplitPayAc	Split Payment Account	nVarChar	15	OACT
TaxAgent	Tax Agent (Section 3)	VarChar	1	-	N	Y	Yes
						N	No
SectionLim	VAT Section (under limit)	nVarChar	3	-
VatSubjCod	VAT Subject Code	nVarChar	10	-
VatType	Type of VAT	Int	11	OBNI	-1
VatCategor	VAT Category	Int	11	OBNI	-1
Parag44	Paragraph 44	VarChar	1	-	N	Y	Yes
						N	No
ProrataDed	Pro-rata deductible	VarChar	1	-	N	Y	Yes
						N	No
ExcFrmTaxS	Exclude from Tax Summary Report Total A/R or A/P Net Amounts	VarChar	1	-	N	Y	Yes
						N	No
CstmActing	Customer Accounting	VarChar	1	-	N	Y	Yes
						N	No
CstmActOut	Customer Accounting Corresponding Tax Code	nVarChar	8	-
StdTaxCode	Standard Tax Code	nVarChar	35	-
AcqRevTax	Acquisition/Reverse Corresponding Tax Code	nVarChar	8	-
ExReasonHU	Tax Exemption Reason	nVarChar	30	-
ExRemarkHU	Tax Exemption Remark	nVarChar	50	-
EBVatCateg	VAT Category	Int	11	-
SAFTTaxCod	SAF-T Tax Code	nVarChar	10	-	NOR	RED	Reduced Tax
						INT	Middle Tax
						NOR	Normal Tax
						ISE	Exempt
						OUT	Others
EBVatExCau	VAT Exemption Cause	Int	11	OVEC
VatClasTyp	VAT Expense Class. Type	Int	11	OECP
VatClasCat	VAT Expense Class. Category	Int	11	OECC
SAFTTxCdEx	SAF-T Tax Code	nVarChar	10	OSTX	NOR
VATEX	VAT Exemption Reason	nVarChar	32	-

Key	Unique	Field
PRIMARY	Yes	Code
GROUP_NAME	No	Name