biuan SAP® BUSINESS ONE SDK
API OSWA
OSWA - Specific Withholding Amounts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PymntRsnCd KEY UNIQUEPayment Reason CodenVarChar
A) A
B) B
C) C
D) D
E) E
G) G
H) H
I) I
L) L
L1) L1
M) M
M1) M1
N) N
O) O
O1) O1
P) P
Q) Q
R) R
S) S
T) T
U) U
V) V
W) W
X) X
Y) Y
Z) Z
2
PRIMARYYes
CardCodeBP CodenVarChar
15OCRD
Business Partner
FllTxInAdvFull WTax Taxation in AdvanceNum
20
AmntsOnhldWTax Amount on HoldNum
20
RTAsWthRegional IRPEF Held as WTaxNum
20
RTAsAdvRegional IRPEF - In AdvanceNum
20
SspndRegTxRegional Suspend Tax - IRPEFNum
20
MTAsWthMunicipal Tax as WTax - IRPEFNum
20
MTAsAdvMunicipal Tax Held as AdvanceNum
20
SspndMTTxSuspended Municipal TaxNum
20
TxblPrYrTaxable Amt - Previous YearNum
20
WTHPrYrWTax Amount - Previous YearNum
20
ScrtyCntrPSocial Security Tax PayerNum
20
ScrtyCntrSSocial Security SupplierNum
20
ExpsRmbrsdExpenses ReimbursedNum
20
WTHRmbrsdWTax ReimbursedNum
20
DlvryIdNoDelivery Identification No.nVarChar
100
SnglCrtfNoSingle Certification No.nVarChar
17
ErnYrEarning YearInt
6
AdvancedAdvancedVarChar
Y) Yes
N) No
1
N
WTHTypCdWTax Type CodeVarChar
1
GrssAmountGross Amount Due to SupplierNum
20
NtSbjctFrgAmount Not Subject to WTNum
20
TxblAmntTaxable AmountNum
20
WTHAmntWithholding Tax AmountNum
20

Table relationship map

SELECT statement

SELECT OSWA.PymntRsnCd AS 'Payment Reason Code', OSWA.CardCode AS 'BP Code', OSWA.FllTxInAdv AS 'Full WTax Taxation in Advance', OSWA.AmntsOnhld AS 'WTax Amount on Hold', OSWA.RTAsWth AS 'Regional IRPEF Held as WTax', OSWA.RTAsAdv AS 'Regional IRPEF - In Advance', OSWA.SspndRegTx AS 'Regional Suspend Tax - IRPEF', OSWA.MTAsWth AS 'Municipal Tax as WTax - IRPEF', OSWA.MTAsAdv AS 'Municipal Tax Held as Advance', OSWA.SspndMTTx AS 'Suspended Municipal Tax', OSWA.TxblPrYr AS 'Taxable Amt - Previous Year', OSWA.WTHPrYr AS 'WTax Amount - Previous Year', OSWA.ScrtyCntrP AS 'Social Security Tax Payer', OSWA.ScrtyCntrS AS 'Social Security Supplier', OSWA.ExpsRmbrsd AS 'Expenses Reimbursed', OSWA.WTHRmbrsd AS 'WTax Reimbursed', OSWA.DlvryIdNo AS 'Delivery Identification No.', OSWA.SnglCrtfNo AS 'Single Certification No.', OSWA.ErnYr AS 'Earning Year', OSWA.Advanced AS 'Advanced', OSWA.WTHTypCd AS 'WTax Type Code', OSWA.GrssAmount AS 'Gross Amount Due to Supplier', OSWA.NtSbjctFrg AS 'Amount Not Subject to WT', OSWA.TxblAmnt AS 'Taxable Amount', OSWA.WTHAmnt AS 'Withholding Tax Amount' FROM OSWA AS OSWA

Related information


OSWA SQL Table

Business Partner OCRD 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