ODDT - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Business Partners /

Withholding Tax Deduction Hierarchy

DTW Business Partners / Deduction Tax Hierarchies

API ODDT / / Deduction Tax Hierarchies

ODDT - Withholding Tax Deduction Hierarchy Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
Numerator ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
CardCode ^KEY ^UNIQUE	BP Code	nVarChar		15	OCRD Business Partner		CARD	Yes
TrcCode	Hierarchy Code	nVarChar		10
TrcName	Hierarchy Name	nVarChar		30
DateFrom	Valid From	Date		8
DateTo	Valid Until	Date		8
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
LastUpdate	Last Update Date	Date		8
WHShaamGrp	Withholding Shaam Group	VarChar	1) Services and Asset 2) Agricultural Products 3) Insurance Commissions 4) Withholding Tax Instructions 5) Interest, Exchange Rate Differences	1		1
DdctPrcnt	Deduction %	Num		20
MaxSum	Maximum Total	Num		20

Table relationship map

SELECT statement

SELECT
   ODDT.Numerator AS 'Internal Number', 
   ODDT.CardCode AS 'BP Code', 
   ODDT.TrcCode AS 'Hierarchy Code', 
   ODDT.TrcName AS 'Hierarchy Name', 
   ODDT.DateFrom AS 'Valid From', 
   ODDT.DateTo AS 'Valid Until', 
   ODDT.DataSource AS 'Data Source', 
   ODDT.UserSign AS 'User Signature', 
   ODDT.LastUpdate AS 'Last Update Date', 
   ODDT.WHShaamGrp AS 'Withholding Shaam Group', 
   ODDT.DdctPrcnt AS 'Deduction %', 
   ODDT.MaxSum AS 'Maximum Total'
FROM ODDT AS ODDT

Related information

DeductionTaxHierarchies Object· Table: ODDT

The DeductionTaxHierarchies object enables to define taxation levels to withhold from payments to vendors. This object is part of the Business Partners module. Source table: ODDT.

ODDT SQL Table

OCRD SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
DeductionTaxHierarchies

Method

Add

GetAsXML

GetByKey

SaveToFile

SaveXML

Update

Object

DeductionTaxHierarchies_Lines DDT1

Property

AbsEntry

DTW DB

BPCode

DTW DB

Browser

DeductionPercent

DTW DB

HierarchyCode

DTW DB

HierarchyName

DTW DB

LastUpdated

Lines

MaximumTotal

DTW DB

UserFields

ValidFrom

DTW DB

ValidUntil

DTW DB

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates