biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Withholding Tax Deduction Hierarchy / Withholding Tax Deduction Hierarchy - Rows
DTW Business Partners / Deduction Tax Hierarchies / Withholding Tax Deduction Hierarchy - Rows
API Deduction Tax Hierarchies / Deduction Tax Hierarchies Lines
DDT1 - Withholding Tax Deduction Hierarchy - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DdtKey KEY UNIQUEHierarchy KeyInt
11ODDT
Withholding Tax Deduction Hierarchy		PRIMARYYes
LineNumRow NumberInt
11
DdctPrcntDeduction %Num
20
MaxSumMaximum TotalNum
20
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Data Doc.
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT DDT1.DdtKey AS 'Hierarchy Key', DDT1.LineNum AS 'Row Number', DDT1.DdctPrcnt AS 'Deduction %', DDT1.MaxSum AS 'Maximum Total', DDT1.DataSource AS 'Data Source', DDT1.UserSign AS 'User Signature' FROM DDT1 AS DDT1

Related information


Deduction Tax Hierarchies Lines DeductionTaxHierarchies_Lines Object· Table: DDT1
The DeductionTaxHierarchies_Lines is a child object of DeductionTaxHierarchies object. It enables to define the deduction percentage and maximum amount for each taxation level. Source table: DDT1.
   Parent: Deduction Tax Hierarchies DeductionTaxHierarchies Object· Table: ODDT
Withholding Tax Deduction Hierarchy ODDT SQL Table

Users OUSR SQL Table
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