|
|
SQL Finance / Tax Definition
API AVTG
AVTG - Tax Definition Table
G/L Accounts OACT SQL Table
Goods Shipment OGSP SQL Table
Triangular Deal OIND SQL Table
Tax Report Type OKRT SQL Table
Service Supply OSSP SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY | Name | nVarChar | 50 | GROUP_NAME | No | |||
| Rate | Rate % | Num | 20 | |||||
| EffecDate | Effective from | Date | 8 | |||||
| Category | Category | VarChar | O) Output Tax I) Input Tax | 1 | O | |||
| Account | Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| IsEC | EU | VarChar | Y) Yes N) No | 1 | N | |||
| Indicator | Triangular Deal | VarChar | 1 | OIND Triangular Deal | ||||
| AcqstnRvrs | Acquisition/Reverse | VarChar | Y) Yes N) No | 1 | N | |||
| NonDedct | Non-Deductible % | Num | 20 | |||||
| AcqsTax | Acquisition Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| GoddsShip | Goods Shipment | VarChar | 1 | OGSP Goods Shipment | ||||
| NonDedAcc | Non-Deductible Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DeferrAcc | Deferred Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| EquVatPr | Equalization Tax % | Num | 20 | |||||
| ReportCode | Group Description | nVarChar | 100 | |||||
| FixdAssts | Fixed Assets Flag | VarChar | Y) Yes N) No | 1 | N | |||
| CalcMethod | Calculation Method | VarChar | R) Rate F) Fixed | 1 | R | |||
| TaxType | Tax Type (VAT or Stamp) | VarChar | V) VAT S) Stamp | 1 | V | |||
| FixedAmnt | Fixed Amount (LC) | Num | 20 | |||||
| ExtCode | External Code | nVarChar | 10 | |||||
| Correction | Correction | VarChar | Y) Yes N) No | 1 | N | |||
| VatCrctn | VAT Correction | nVarChar | 8 | OVTG Tax Definition | ||||
| RetVatCode | Returning VAT Code | nVarChar | 8 | |||||
| RepType | Report Type | Int | 11 | OKRT Tax Report Type | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| TaxCtgr | Tax Type (Annual List) | VarChar | E) Excluded T) Taxable X) Exempt N) Not Taxable G) Gross Profit R) Reverse Charge 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 BY L) Taxable - Late Export O) Taxable - Not Confirmed S) Taxable - Real Estate W) Taxable - Sale of Company | 1 | E | |||
| EquAccount | Equalization Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| IsIGIC | IGIC | VarChar | Y) Yes N) No | 1 | N | |||
| ServSupply | Service Supply | VarChar | 1 | OSSP Service Supply | ||||
| Inactive | Inactive | VarChar | Y) Yes N) No | 1 | N | |||
| TaxCtgrBL | Tax Type (Black List) | VarChar | E) Excluded T) Taxable X) Exempt N) Not Taxable S) Non-Subject | 1 | E | |||
| R349Code | Report 349 Code | Int | 0 1) E 2) A 3) T 4) S 5) I 6) M 7) H | 11 | 0 | |||
| VatRevAcc | VAT in Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CashDisAcc | Cash Discount Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DpmTaxOAcc | Down Paymnt Tax Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| VatDedAcc | VAT Deductible Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CstmExpAcc | Customs VAT Expense Account | nVarChar | 15 | |||||
| CstmAlcAcc | Customs VAT Allocation Account | nVarChar | 15 | |||||
| TaxRegion | Tax Country Region | nVarChar | PT) Continental Portugal PT-AC) Azores Islands PT-MA) Madeira Islands | 5 | PT | |||
| ExemReason | Tax Exemption Reason | nVarChar | M01) Article 16th No. 6 of CIVA M02) Article 6th Law 198/90 June 19th M03) Cash Liabilities M04) Exempt Article 13th of CIVA M05) Exempt Article 14th of CIVA M06) Exempt Article 15th of CIVA M07) Exempt Article 9th of CIVA M08) VAT - Self-Liquidation M09) VAT - Non-Deductible M10) VAT - Exempted Company M11) VAT - Exempted (Tobacco) M12) VAT - Exempted (Travel Agencies) M13) VAT - Exempt (Second Hand Goods) M14) VAT - Exempted (Objects of Art) M15) VAT - Exempted (Collectibles and Antiques) M16) VAT - Exempted (Article 14th of RITI) M99) Not Subject to VAT | 3 | ||||
| Agent | Agent | VarChar | Y) Yes N) No | 1 | N | |||
| OpCode | Tax Operation Code | nVarChar | 7 | |||||
| Export | Export | VarChar | Y) Yes N) No | 1 | N | |||
| Section | VAT Section | nVarChar | 2 | |||||
| SplitPaymt | Split Payment | VarChar | Y) Yes N) No | 1 | N | |||
| SplitPayAc | Split Payment Account | nVarChar | 15 |
Table relationship map
SELECT statement
SELECT
AVTG.Code AS 'Code',
AVTG.Name AS 'Name',
AVTG.Rate AS 'Rate %',
AVTG.EffecDate AS 'Effective from',
AVTG.Category AS 'Category',
AVTG.Account AS 'Tax Account',
AVTG.Locked AS 'Locked',
AVTG.DataSource AS 'Data Source',
AVTG.UserSign AS 'User Signature',
AVTG.IsEC AS 'EU',
AVTG.Indicator AS 'Triangular Deal',
AVTG.AcqstnRvrs AS 'Acquisition/Reverse',
AVTG.NonDedct AS 'Non-Deductible %',
AVTG.AcqsTax AS 'Acquisition Tax Account',
AVTG.GoddsShip AS 'Goods Shipment',
AVTG.NonDedAcc AS 'Non-Deductible Acct',
AVTG.DeferrAcc AS 'Deferred Tax Account',
AVTG.EquVatPr AS 'Equalization Tax %',
AVTG.ReportCode AS 'Group Description',
AVTG.FixdAssts AS 'Fixed Assets Flag',
AVTG.CalcMethod AS 'Calculation Method',
AVTG.TaxType AS 'Tax Type (VAT or Stamp)',
AVTG.FixedAmnt AS 'Fixed Amount (LC)',
AVTG.ExtCode AS 'External Code',
AVTG.Correction AS 'Correction',
AVTG.VatCrctn AS 'VAT Correction',
AVTG.RetVatCode AS 'Returning VAT Code',
AVTG.RepType AS 'Report Type',
AVTG.LogInstanc AS 'Log Instance',
AVTG.UpdateDate AS 'Date of Update',
AVTG.TaxCtgr AS 'Tax Type (Annual List)',
AVTG.EquAccount AS 'Equalization Tax Account',
AVTG.UserSign2 AS 'Updating User',
AVTG.IsIGIC AS 'IGIC',
AVTG.ServSupply AS 'Service Supply',
AVTG.Inactive AS 'Inactive',
AVTG.TaxCtgrBL AS 'Tax Type (Black List)',
AVTG.R349Code AS 'Report 349 Code',
AVTG.VatRevAcc AS 'VAT in Revenue Account',
AVTG.CashDisAcc AS 'Cash Discount Account',
AVTG.DpmTaxOAcc AS 'Down Paymnt Tax Offset Account',
AVTG.VatDedAcc AS 'VAT Deductible Account',
AVTG.CstmExpAcc AS 'Customs VAT Expense Account',
AVTG.CstmAlcAcc AS 'Customs VAT Allocation Account',
AVTG.TaxRegion AS 'Tax Country Region',
AVTG.ExemReason AS 'Tax Exemption Reason',
AVTG.Agent AS 'Agent',
AVTG.OpCode AS 'Tax Operation Code',
AVTG.Export AS 'Export',
AVTG.Section AS 'VAT Section',
AVTG.SplitPaymt AS 'Split Payment',
AVTG.SplitPayAc AS 'Split Payment Account'
FROM AVTG AS AVTG
Related information
G/L Accounts OACT SQL Table
Goods Shipment OGSP SQL Table
Triangular Deal OIND SQL Table
Tax Report Type OKRT SQL Table
Service Supply OSSP SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
