biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Deduction Tax Hierarchies
API ODDT / / Deduction Tax Hierarchies
ODDT - Withholding Tax Deduction Hierarchy Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Numerator KEY UNIQUEInternal NumberInt
11
PRIMARYYes
CardCode KEY UNIQUEBP CodenVarChar
15OCRD
Business Partner
CARDYes
TrcCodeHierarchy CodenVarChar
10
TrcNameHierarchy NamenVarChar
30
DateFromValid FromDate
8
DateToValid UntilDate
8
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
LastUpdateLast Update DateDate
8
WHShaamGrpWithholding Shaam GroupVarChar
1) Services and Asset
2) Agricultural Products
3) Insurance Commissions
4) Withholding Tax Instructions
5) Interest, Exchange Rate Differences
1
1
DdctPrcntDeduction %Num
20
MaxSumMaximum TotalNum
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


Deduction Tax Hierarchies 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

Business Partner OCRD 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates