biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Tax / Withholding Tax Definition
API WTD4
WTD4 - WTax Codes Details for Item Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OWHT
Withholding Tax
PRIMARYYes
LineIdRow NumberInt
11
WTCode KEY UNIQUEWTax CodenVarChar
4
ITEMYes
ItemCodeItem No.nVarChar
20OITM
Items
DateFromEffective Date FromDate
8
DateToEffective Date ToDate
8
DataSourceData SourceVarChar
N) Unknown
M) Import
O) DI API
P) Partner Implementation
1
N
UpdateDateDate of UpdateDate
8
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT WTD4.AbsEntry AS 'Internal Number', WTD4.LineId AS 'Row Number', WTD4.WTCode AS 'WTax Code', WTD4.ItemCode AS 'Item No.', WTD4.DateFrom AS 'Effective Date From', WTD4.DateTo AS 'Effective Date To', WTD4.DataSource AS 'Data Source', WTD4.UpdateDate AS 'Date of Update', WTD4.LogInstanc AS 'Log Instance' FROM WTD4 AS WTD4

Related information


Withholding Tax OWHT SQL Table

Items OITM 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