|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Specific Withholding Amounts
Table Name: OSWA
Table Description: Specific Withholding Amounts
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| PymntRsnCd | Payment Reason Code | nVarChar | 3 | OPTR | Â | Â | Â |
| CardCode | BP Code | nVarChar | 15 | OCRD | Â | Â | Â |
| FllTxInAdv | Full WTax Taxation in Advance | Num | 19.6 | - | Â | Â | Â |
| AmntsOnhld | WTax Amount on Hold | Num | 19.6 | - | Â | Â | Â |
| RTAsWth | Regional IRPEF Held as WTax | Num | 19.6 | - | Â | Â | Â |
| RTAsAdv | Regional IRPEF - In Advance | Num | 19.6 | - | Â | Â | Â |
| SspndRegTx | Regional Suspended Tax - IRPEF | Num | 19.6 | - | Â | Â | Â |
| MTAsWth | Municipal Tax as WTax - IRPEF | Num | 19.6 | - | Â | Â | Â |
| MTAsAdv | Municipal Tax Held as Advance | Num | 19.6 | - | Â | Â | Â |
| SspndMTTx | Suspended Municipal Tax | Num | 19.6 | - | Â | Â | Â |
| TxblPrYr | Taxable Amt - Previous Year | Num | 19.6 | - | Â | Â | Â |
| WTHPrYr | WTax Amount - Previous Year | Num | 19.6 | - | Â | Â | Â |
| ScrtyCntrP | Social Security Tax Payer | Num | 19.6 | - | Â | Â | Â |
| ScrtyCntrS | Social Security Supplier | Num | 19.6 | - | Â | Â | Â |
| ExpsRmbrsd | Expenses Reimbursed | Num | 19.6 | - | Â | Â | Â |
| WTHRmbrsd | WTax Reimbursed | Num | 19.6 | - | Â | Â | Â |
| DlvryIdNo | Delivery Identification No. | nVarChar | 100 | - | Â | Â | Â |
| SnglCrtfNo | Single Certification No. | nVarChar | 17 | - | Â | Â | Â |
| ErnYr | Earning Year | Int | 6 | - | Â | Â | Â |
| Advanced | Advanced | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| WTHTypCd | WTax Type Code | nVarChar | 2 | OWXT | Â | Â | Â |
| GrssAmount | Gross Amount Due to Supplier | Num | 19.6 | - | Â | Â | Â |
| NtSbjctFrg | Amount Not Subject to WT | Num | 19.6 | - | Â | Â | Â |
| TxblAmnt | Taxable Amount | Num | 19.6 | - | Â | Â | Â |
| WTHAmnt | Withholding Tax Amount | Num | 19.6 | - | Â | Â | Â |
| SSFiscalCd | Social Security Fiscal C..(29) | nVarChar | 16 | - | Â | Â | Â |
| SSIName | Social Security Institut..(30) | nVarChar | 100 | - | Â | Â | Â |
| SSICode | Social Security Institut..(31) | VarChar | 1 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | 2 | ENPAM |
| Â | Â | Â | Â | Â | Â | 4 | ENPAPI |
| CompanyCd | Company Code(32) | nVarChar | 16 | - | Â | Â | Â |
| Category | Category(33) | nVarChar | 3 | OWCT | Â | Â | Â |
| EmpeSSCntr | Employee social security..(34) | Num | 19.6 | - | Â | Â | Â |
| EmprSSCntr | Employer social security..(35) | Num | 19.6 | - | Â | Â | Â |
| OthCntrbts | Other Contributions(36) | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| VOthCntrbt | Value of Other Contribut..(37) | Num | 19.6 | - | Â | Â | Â |
| OthAmntDue | Other amounts due(38) | Num | 19.6 | - | Â | Â | Â |
| OthAmntPd | Other amounts paid(39) | Num | 19.6 | - | Â | Â | Â |
| AmntPdBfBr | Amount Paid before Bankr..(41) | Num | 19.6 | - | Â | Â | Â |
| AmntPdByTr | Amount Paid by Trustee(42) | Num | 19.6 | - | Â | Â | Â |
| FiscalCode | Fiscal Code(52) | nVarChar | 16 | - | Â | Â | Â |
| TxblAmntE | Taxable Amount(53) | Num | 19.6 | - | Â | Â | Â |
| TaxAmount | Tax Amount(54) | Num | 19.6 | - | Â | Â | Â |
| TxAmntInAd | Tax Amount in Advance(55) | Num | 19.6 | - | Â | Â | Â |
| SspndWTHTx | Suspended WTH Tax(56) | Num | 19.6 | - | Â | Â | Â |
| AdRgTxIRPH | Additional Regional tax..(57) | Num | 19.6 | - | Â | Â | Â |
| AdRgTxIRPA | Additional Regional tax..(58) | Num | 19.6 | - | Â | Â | Â |
| SspdRgnlTx | Suspended Regional Tax(59) | Num | 19.6 | - | Â | Â | Â |
| AdCtTxIRWT | Additional City tax to I..(60) | Num | 19.6 | - | Â | Â | Â |
| AdCtTxIWTA | Additional City Tax to I..(61) | Num | 19.6 | - | Â | Â | Â |
| SspndCtTx | Suspended City Tax(62) | Num | 19.6 | - | Â | Â | Â |
| FsCdTrdPty | Fiscal Code Third Party(71) | nVarChar | 16 | - | Â | Â | Â |
| FCdTrdPtyS | Fiscal Code Third Party..(72) | nVarChar | 16 | - | Â | Â | Â |
| FscCdExpr | Fiscal Code Expropriation(73) | nVarChar | 16 | - | Â | Â | Â |
| FsCdMnDbS | Fiscal Code of Main Deb..(101) | nVarChar | 16 | - | Â | Â | Â |
| AmntPdS | Amount Paid(102) | Num | 19.6 | - | Â | Â | Â |
| WHTApdS | WHT Applied(103) | Num | 19.6 | - | Â | Â | Â |
| WHTNApdS | WHT not Applied(104) | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FsCdMnDbR | Fiscal Code of Main Deb..(105) | nVarChar | 16 | - | Â | Â | Â |
| AmntPdR | Amount Paid(106) | Num | 19.6 | - | Â | Â | Â |
| WHTApdR | WHT Applied(107) | Num | 19.6 | - | Â | Â | Â |
| WHTNApdR | WHT not Applied(108) | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AmntPdA | Amount Paid(131) | Num | 19.6 | - | Â | Â | Â |
| TxAppldA | Tax Applied(132) | Num | 19.6 | - | Â | Â | Â |
| AmntPdB | Amount Paid(133) | Num | 19.6 | - | Â | Â | Â |
| TxAppldB | Tax Applied(134) | Num | 19.6 | - | Â | Â | Â |
| AmntPdC | Amount Paid(135) | Num | 19.6 | - | Â | Â | Â |
| TxAppldC | Tax Applied(136) | Num | 19.6 | - | Â | Â | Â |
| AmntPdD | Amount Paid(137) | Num | 19.6 | - | Â | Â | Â |
| TxAppldD | Tax Applied(138) | Num | 19.6 | - | Â | Â | Â |
| AmtPvdNTxS | Amounts provided and no..(104) | Num | 19.6 | - | Â | Â | Â |
| AmtPvdNTxR | Amounts provided and no..(108) | Num | 19.6 | - | Â | Â | Â |
| CUSplit | CU Split | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| SmRnNtWTx | Returned Amount After Deduction of WTax | Num | 19.6 | - | Â | Â | Â |
| WHTRelCode | Relation Type (31) | nVarChar | 3 | OWRT | Â | Â | Â |
| AmtDedUsed | Deductible amount used (40) | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | PymntRsnCd |
| Â | Â | CardCode |
| Â | Â | CUSplit |