biuan SAP® BUSINESS ONE SDK
API AWD3
AWD3 - WTax Codes Details for BP Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OWHT
Withholding Tax
PRIMARYYes
LineIdRow NumberInt
11
WTCodeWTax CodenVarChar
4
KeyPart1BP Key Part 1nVarChar
15
KeyPart2BP Key Part 2nVarChar
15
DateFromEffective Date FromDate
8
DateToEffective Date ToDate
8
RateCurrency RateNum
20
DetailTypeType of Detailed InformationnVarChar
A) Allowed
S) Special Rate
E) Exemption
2
DataSourceData SourceVarChar
N) Unknown
M) Import
O) DI API
P) Partner Implementation
1
N
UpdateDateDate of UpdateDate
8
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT AWD3.AbsEntry AS 'Internal Number', AWD3.LineId AS 'Row Number', AWD3.WTCode AS 'WTax Code', AWD3.KeyPart1 AS 'BP Key Part 1', AWD3.KeyPart2 AS 'BP Key Part 2', AWD3.DateFrom AS 'Effective Date From', AWD3.DateTo AS 'Effective Date To', AWD3.Rate AS 'Currency Rate', AWD3.DetailType AS 'Type of Detailed Information', AWD3.DataSource AS 'Data Source', AWD3.UpdateDate AS 'Date of Update', AWD3.LogInstanc AS 'Log Instance' FROM AWD3 AS AWD3

Related information


Withholding Tax OWHT 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