|
|
API OSWA
OSWA - Specific Withholding Amounts Table
OSWA SQL Table
Business Partner OCRD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | PymntRsnCd KEY UNIQUE | Payment Reason Code | nVarChar | 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 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| FllTxInAdv | Full WTax Taxation in Advance | Num | 20 | |||||
| AmntsOnhld | WTax Amount on Hold | Num | 20 | |||||
| RTAsWth | Regional IRPEF Held as WTax | Num | 20 | |||||
| RTAsAdv | Regional IRPEF - In Advance | Num | 20 | |||||
| SspndRegTx | Regional Suspend Tax - IRPEF | Num | 20 | |||||
| MTAsWth | Municipal Tax as WTax - IRPEF | Num | 20 | |||||
| MTAsAdv | Municipal Tax Held as Advance | Num | 20 | |||||
| SspndMTTx | Suspended Municipal Tax | Num | 20 | |||||
| TxblPrYr | Taxable Amt - Previous Year | Num | 20 | |||||
| WTHPrYr | WTax Amount - Previous Year | Num | 20 | |||||
| ScrtyCntrP | Social Security Tax Payer | Num | 20 | |||||
| ScrtyCntrS | Social Security Supplier | Num | 20 | |||||
| ExpsRmbrsd | Expenses Reimbursed | Num | 20 | |||||
| WTHRmbrsd | WTax Reimbursed | Num | 20 | |||||
| DlvryIdNo | Delivery Identification No. | nVarChar | 100 | |||||
| SnglCrtfNo | Single Certification No. | nVarChar | 17 | |||||
| ErnYr | Earning Year | Int | 6 | |||||
| Advanced | Advanced | VarChar | Y) Yes N) No | 1 | N | |||
| WTHTypCd | WTax Type Code | VarChar | 1 | |||||
| GrssAmount | Gross Amount Due to Supplier | Num | 20 | |||||
| NtSbjctFrg | Amount Not Subject to WT | Num | 20 | |||||
| TxblAmnt | Taxable Amount | Num | 20 | |||||
| WTHAmnt | Withholding Tax Amount | Num | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
