|
|
DTW A/R Invoice - Withholding Tax
API Document Lines / Withholding Tax Lines
INV5 - A/R Invoice - Withholding Tax Table
Withholding Tax Lines WithholdingTaxLines Object· Table: INV5
Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
A/R Invoice OINV SQL Table
G/L Accounts OACT SQL Table
Object Settings - History ADP1 SQL Table
Withholding Tax OWHT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OINV A/R Invoice | SECONDERY | Yes |
|---|---|---|---|---|---|---|---|---|
| WTCode | WTax Code | nVarChar | 4 | OWHT Withholding Tax | ||||
| Rate | Rate | Num | 20 | |||||
| TaxbleAmnt | Taxable Amount | Num | 20 | |||||
| TxblAmntSC | Taxable Amount (SC) | Num | 20 | |||||
| TxblAmntFC | Taxable Amount (FC) | Num | 20 | |||||
| WTAmnt | WTax Amount | Num | 20 | |||||
| WTAmntSC | WTax Amount (SC) | Num | 20 | |||||
| WTAmntFC | WTax Amount (FC) | Num | 20 | |||||
| ApplAmnt | Applied WTax Amount | Num | 20 | |||||
| ApplAmntSC | Applied WTax Amount (SC) | Num | 20 | |||||
| ApplAmntFC | Applied WTax Amount (FC) | Num | 20 | |||||
| Category | Category | VarChar | P) Payment I) Invoice | 1 | ||||
| Criteria | Criteria | VarChar | Y) Accrual N) Cash | 1 | ||||
| Account | G/L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Type | Withholding Tax Type | VarChar | V) VAT Withholding I) Income Tax Withholding | 1 | ||||
| RoundType | Rounding Type | VarChar | T) Truncated C) Commercial Values N) No Rounding | 1 | ||||
| BaseType | Base Type | VarChar | G) Gross N) Net V) VAT | 1 | ||||
| BaseAbsEnt | Base Document Internal No. | Int | 11 | -1 | ||||
| BaseLine | Base Row | Int | 11 | |||||
| BaseNum | Base Document Type | Int | -1) 0 23) Sales Quotation 17) Sales Order 15) Delivery | 11 | -1 | |||
| LineNum | Row Number | Int | 11 | |||||
| BaseRef | Base Document Reference | Int | 11 | |||||
| Status | Status | VarChar | O) Open C) Closed | 1 | O | |||
| TrgType | Target Document Type | Int | 11 | |||||
| TrgAbsEntr | Target Doc. Internal No. | Int | 11 | -1 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 13 | |||
| Doc1LineNo | DOC1 Line Number | Int | 11 | -1 | ||||
| WtLineType | WTax Row Type | VarChar | D) Document Level WTax L) Row Level WTax | 1 | D | |||
| TxblCurr | Taxable Currency from Doc Line | nVarChar | 3 | |||||
| DtblCurr | Deductible Currency | nVarChar | 3 | |||||
| DtblRate | Rate for Deductible Amount | Num | 20 | |||||
| txblRate | Rate for Taxable Amount | Num | 20 | |||||
| DtblAmount | Deductible Amount | Num | 20 | |||||
| TdsAcc | TDS Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SurAcc | Surcharge Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CessAcc | Cess Account | nVarChar | 15 | OACT G/L Accounts | ||||
| HscAcc | HSC Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TdsRate | TDS Rate | Num | 20 | |||||
| SurRate | Surcharge Rate | Num | 20 | |||||
| CessRate | Cess Rate | Num | 20 | |||||
| HscRate | HSC Rate | Num | 20 | |||||
| TdsBAmt | TDS Base Amount | Num | 20 | |||||
| TdsBAmtSC | TDS Base Amount (SC) | Num | 20 | |||||
| TdsBAmtFC | TDS Base Amount (FC) | Num | 20 | |||||
| SurBAmt | Surcharge Base Amount | Num | 20 | |||||
| SurBAmtSC | Surcharge Base Amount (SC) | Num | 20 | |||||
| SurBAmtFC | Surcharge Base Amount (FC) | Num | 20 | |||||
| CessBAmt | Cess Base Amount | Num | 20 | |||||
| CessBAmtSC | Cess Base Amount (SC) | Num | 20 | |||||
| CessBAmtFC | Cess Base Amount (FC) | Num | 20 | |||||
| HscBAmt | HSC Base Amount | Num | 20 | |||||
| HscBAmtSC | HSC Base Amount (SC) | Num | 20 | |||||
| HscBAmtFC | HSC Base Amount (FC) | Num | 20 | |||||
| TdsAmnt | TDS Tax Amount | Num | 20 | |||||
| TdsAmntSC | TDS Tax Amount (SC) | Num | 20 | |||||
| TdsAmntFC | TDS Tax Amount (FC) | Num | 20 | |||||
| SurAmnt | Surcharge Tax Amount | Num | 20 | |||||
| SurAmntSC | Surcharge Tax Amount (SC) | Num | 20 | |||||
| SurAmntFC | Surcharge Tax Amount (FC) | Num | 20 | |||||
| CessAmnt | Cess Tax Amount | Num | 20 | |||||
| CessAmntSC | Cess Tax Amount (SC) | Num | 20 | |||||
| CessAmntFC | Cess Tax Amount (FC) | Num | 20 | |||||
| HscAmnt | HSC Tax Amount | Num | 20 | |||||
| HscAmntSC | HSC Tax Amount (SC) | Num | 20 | |||||
| HscAmntFC | HSC Tax Amount (FC) | Num | 20 | |||||
| TdsAppl | Applied TDS Amount | Num | 20 | |||||
| TdsApplSC | Applied TDS Amount (SC) | Num | 20 | |||||
| TdsApplFC | Applied TDS Amount (FC) | Num | 20 | |||||
| SurAppl | Applied Surcharge Amount | Num | 20 | |||||
| SurApplSC | Applied Surcharge Amount (SC) | Num | 20 | |||||
| SurApplFC | Applied Surcharge Amount (FC) | Num | 20 | |||||
| CessAppl | Applied Cess Amount | Num | 20 | |||||
| CessApplSC | Applied Cess Amount (SC) | Num | 20 | |||||
| CessApplFC | Applied Cess Amount (FC) | Num | 20 | |||||
| HscAppl | Applied HSC Amount | Num | 20 | |||||
| HscApplSC | Applied HSC Amount (SC) | Num | 20 | |||||
| HscApplFC | Applied HSC Amount (FC) | Num | 20 | |||||
| BatchNum | Journal Voucher No. | Int | 11 | |||||
| InCSTCode | CST Code Incoming | nVarChar | 2 | |||||
| OutCSTCode | CST Code Outgoing | nVarChar | 2 | |||||
| DpmWTApl | DPM WT Applied Amount | Num | 20 | |||||
| DpmWTAplSC | DPM WT Applied Amount (SC) | Num | 20 | |||||
| DpmWTAplFC | DPM WT Applied Amount (FC) | Num | 20 |
Table relationship map
SELECT statement
SELECT
INV5.AbsEntry AS 'Internal Number',
INV5.WTCode AS 'WTax Code',
INV5.Rate AS 'Rate',
INV5.TaxbleAmnt AS 'Taxable Amount',
INV5.TxblAmntSC AS 'Taxable Amount (SC)',
INV5.TxblAmntFC AS 'Taxable Amount (FC)',
INV5.WTAmnt AS 'WTax Amount',
INV5.WTAmntSC AS 'WTax Amount (SC)',
INV5.WTAmntFC AS 'WTax Amount (FC)',
INV5.ApplAmnt AS 'Applied WTax Amount',
INV5.ApplAmntSC AS 'Applied WTax Amount (SC)',
INV5.ApplAmntFC AS 'Applied WTax Amount (FC)',
INV5.Category AS 'Category',
INV5.Criteria AS 'Criteria',
INV5.Account AS 'G/L Account',
INV5.Type AS 'Withholding Tax Type',
INV5.RoundType AS 'Rounding Type',
INV5.BaseType AS 'Base Type',
INV5.BaseAbsEnt AS 'Base Document Internal No.',
INV5.BaseLine AS 'Base Row',
INV5.BaseNum AS 'Base Document Type',
INV5.LineNum AS 'Row Number',
INV5.BaseRef AS 'Base Document Reference',
INV5.Status AS 'Status',
INV5.TrgType AS 'Target Document Type',
INV5.TrgAbsEntr AS 'Target Doc. Internal No.',
INV5.LogInstanc AS 'Log Instance',
INV5.ObjType AS 'Object Type',
INV5.Doc1LineNo AS 'DOC1 Line Number',
INV5.WtLineType AS 'WTax Row Type',
INV5.TxblCurr AS 'Taxable Currency from Doc Line',
INV5.DtblCurr AS 'Deductible Currency',
INV5.DtblRate AS 'Rate for Deductible Amount',
INV5.txblRate AS 'Rate for Taxable Amount',
INV5.DtblAmount AS 'Deductible Amount',
INV5.TdsAcc AS 'TDS Account',
INV5.SurAcc AS 'Surcharge Account',
INV5.CessAcc AS 'Cess Account',
INV5.HscAcc AS 'HSC Account',
INV5.TdsRate AS 'TDS Rate',
INV5.SurRate AS 'Surcharge Rate',
INV5.CessRate AS 'Cess Rate',
INV5.HscRate AS 'HSC Rate',
INV5.TdsBAmt AS 'TDS Base Amount',
INV5.TdsBAmtSC AS 'TDS Base Amount (SC)',
INV5.TdsBAmtFC AS 'TDS Base Amount (FC)',
INV5.SurBAmt AS 'Surcharge Base Amount',
INV5.SurBAmtSC AS 'Surcharge Base Amount (SC)',
INV5.SurBAmtFC AS 'Surcharge Base Amount (FC)',
INV5.CessBAmt AS 'Cess Base Amount',
INV5.CessBAmtSC AS 'Cess Base Amount (SC)',
INV5.CessBAmtFC AS 'Cess Base Amount (FC)',
INV5.HscBAmt AS 'HSC Base Amount',
INV5.HscBAmtSC AS 'HSC Base Amount (SC)',
INV5.HscBAmtFC AS 'HSC Base Amount (FC)',
INV5.TdsAmnt AS 'TDS Tax Amount',
INV5.TdsAmntSC AS 'TDS Tax Amount (SC)',
INV5.TdsAmntFC AS 'TDS Tax Amount (FC)',
INV5.SurAmnt AS 'Surcharge Tax Amount',
INV5.SurAmntSC AS 'Surcharge Tax Amount (SC)',
INV5.SurAmntFC AS 'Surcharge Tax Amount (FC)',
INV5.CessAmnt AS 'Cess Tax Amount',
INV5.CessAmntSC AS 'Cess Tax Amount (SC)',
INV5.CessAmntFC AS 'Cess Tax Amount (FC)',
INV5.HscAmnt AS 'HSC Tax Amount',
INV5.HscAmntSC AS 'HSC Tax Amount (SC)',
INV5.HscAmntFC AS 'HSC Tax Amount (FC)',
INV5.TdsAppl AS 'Applied TDS Amount',
INV5.TdsApplSC AS 'Applied TDS Amount (SC)',
INV5.TdsApplFC AS 'Applied TDS Amount (FC)',
INV5.SurAppl AS 'Applied Surcharge Amount',
INV5.SurApplSC AS 'Applied Surcharge Amount (SC)',
INV5.SurApplFC AS 'Applied Surcharge Amount (FC)',
INV5.CessAppl AS 'Applied Cess Amount',
INV5.CessApplSC AS 'Applied Cess Amount (SC)',
INV5.CessApplFC AS 'Applied Cess Amount (FC)',
INV5.HscAppl AS 'Applied HSC Amount',
INV5.HscApplSC AS 'Applied HSC Amount (SC)',
INV5.HscApplFC AS 'Applied HSC Amount (FC)',
INV5.BatchNum AS 'Journal Voucher No.',
INV5.InCSTCode AS 'CST Code Incoming',
INV5.OutCSTCode AS 'CST Code Outgoing',
INV5.DpmWTApl AS 'DPM WT Applied Amount',
INV5.DpmWTAplSC AS 'DPM WT Applied Amount (SC)',
INV5.DpmWTAplFC AS 'DPM WT Applied Amount (FC)'
FROM INV5 AS INV5
Related information
Withholding Tax Lines WithholdingTaxLines Object· Table: INV5
WithholdingTaxLines is a child object of Document_Lines object and supports Withholding Tax in a line level (as opposed to WithholdingTaxData object, which supports Withholding Tax in a document level).
The WithholdingTaxLines object is...
Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1 A/R Invoice OINV SQL Table
G/L Accounts OACT SQL Table
Object Settings - History ADP1 SQL Table
Withholding Tax OWHT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
