|
|
API IGN5
IGN5 - Goods Receipt - Withholding Tax Table
Goods Receipt OIGN 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 | Numerator | Int | 11 | OIGN Goods Receipt | SECONDERY | Yes |
|---|---|---|---|---|---|---|---|---|
| WTCode | WT Code | nVarChar | 4 | OWHT Withholding Tax | ||||
| Rate | Rate | Num | 20 | |||||
| TaxbleAmnt | Taxable Amount | Num | 20 | |||||
| TxblAmntSC | Taxable Amount in SC | Num | 20 | |||||
| TxblAmntFC | Taxable Amount in FC | Num | 20 | |||||
| WTAmnt | WT Amount | Num | 20 | |||||
| WTAmntSC | WT Amount (SC) | Num | 20 | |||||
| WTAmntFC | WT Amount (FC) | Num | 20 | |||||
| ApplAmnt | Applied WT 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 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 Abs Entry | Int | 11 | -1 | ||||
| BaseLine | Base Line | Int | 11 | |||||
| BaseNum | Base Document Type | Int | -1) 0 202) Production Order | 11 | -1 | |||
| LineNum | Line 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 Abs. Entry | Int | 11 | -1 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 59 | |||
| Doc1LineNo | DOC1 Line Number | Int | 11 | -1 | ||||
| WtLineType | WT Line 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
IGN5.AbsEntry AS 'Numerator',
IGN5.WTCode AS 'WT Code',
IGN5.Rate AS 'Rate',
IGN5.TaxbleAmnt AS 'Taxable Amount',
IGN5.TxblAmntSC AS 'Taxable Amount in SC',
IGN5.TxblAmntFC AS 'Taxable Amount in FC',
IGN5.WTAmnt AS 'WT Amount',
IGN5.WTAmntSC AS 'WT Amount (SC)',
IGN5.WTAmntFC AS 'WT Amount (FC)',
IGN5.ApplAmnt AS 'Applied WT Amount',
IGN5.ApplAmntSC AS 'Applied WTax Amount (SC)',
IGN5.ApplAmntFC AS 'Applied WTax Amount (FC)',
IGN5.Category AS 'Category',
IGN5.Criteria AS 'Criteria',
IGN5.Account AS 'G/L Account',
IGN5.Type AS 'Withholding Type',
IGN5.RoundType AS 'Rounding Type',
IGN5.BaseType AS 'Base Type',
IGN5.BaseAbsEnt AS 'Base Abs Entry',
IGN5.BaseLine AS 'Base Line',
IGN5.BaseNum AS 'Base Document Type',
IGN5.LineNum AS 'Line Number',
IGN5.BaseRef AS 'Base Document Reference',
IGN5.Status AS 'Status',
IGN5.TrgType AS 'Target Document Type',
IGN5.TrgAbsEntr AS 'Target Abs. Entry',
IGN5.LogInstanc AS 'Log Instance',
IGN5.ObjType AS 'Object Type',
IGN5.Doc1LineNo AS 'DOC1 Line Number',
IGN5.WtLineType AS 'WT Line Type',
IGN5.TxblCurr AS 'Taxable Currency from Doc Line',
IGN5.DtblCurr AS 'Deductible Currency',
IGN5.DtblRate AS 'Rate for Deductible Amount',
IGN5.txblRate AS 'Rate for Taxable Amount',
IGN5.DtblAmount AS 'Deductible Amount',
IGN5.TdsAcc AS 'TDS Account',
IGN5.SurAcc AS 'Surcharge Account',
IGN5.CessAcc AS 'Cess Account',
IGN5.HscAcc AS 'HSC Account',
IGN5.TdsRate AS 'TDS Rate',
IGN5.SurRate AS 'Surcharge Rate',
IGN5.CessRate AS 'Cess Rate',
IGN5.HscRate AS 'HSC Rate',
IGN5.TdsBAmt AS 'TDS Base Amount',
IGN5.TdsBAmtSC AS 'TDS Base Amount (SC)',
IGN5.TdsBAmtFC AS 'TDS Base Amount (FC)',
IGN5.SurBAmt AS 'Surcharge Base Amount',
IGN5.SurBAmtSC AS 'Surcharge Base Amount (SC)',
IGN5.SurBAmtFC AS 'Surcharge Base Amount (FC)',
IGN5.CessBAmt AS 'Cess Base Amount',
IGN5.CessBAmtSC AS 'Cess Base Amount (SC)',
IGN5.CessBAmtFC AS 'Cess Base Amount (FC)',
IGN5.HscBAmt AS 'HSC Base Amount',
IGN5.HscBAmtSC AS 'HSC Base Amount (SC)',
IGN5.HscBAmtFC AS 'HSC Base Amount (FC)',
IGN5.TdsAmnt AS 'TDS Tax Amount',
IGN5.TdsAmntSC AS 'TDS Tax Amount (SC)',
IGN5.TdsAmntFC AS 'TDS Tax Amount (FC)',
IGN5.SurAmnt AS 'Surcharge Tax Amount',
IGN5.SurAmntSC AS 'Surcharge Tax Amount (SC)',
IGN5.SurAmntFC AS 'Surcharge Tax Amount (FC)',
IGN5.CessAmnt AS 'Cess Tax Amount',
IGN5.CessAmntSC AS 'Cess Tax Amount (SC)',
IGN5.CessAmntFC AS 'Cess Tax Amount (FC)',
IGN5.HscAmnt AS 'HSC Tax Amount',
IGN5.HscAmntSC AS 'HSC Tax Amount (SC)',
IGN5.HscAmntFC AS 'HSC Tax Amount (FC)',
IGN5.TdsAppl AS 'Applied TDS Amount',
IGN5.TdsApplSC AS 'Applied TDS Amount (SC)',
IGN5.TdsApplFC AS 'Applied TDS Amount (FC)',
IGN5.SurAppl AS 'Applied Surcharge Amount',
IGN5.SurApplSC AS 'Applied Surcharge Amount (SC)',
IGN5.SurApplFC AS 'Applied Surcharge Amount (FC)',
IGN5.CessAppl AS 'Applied Cess Amount',
IGN5.CessApplSC AS 'Applied Cess Amount (SC)',
IGN5.CessApplFC AS 'Applied Cess Amount (FC)',
IGN5.HscAppl AS 'Applied HSC Amount',
IGN5.HscApplSC AS 'Applied HSC Amount (SC)',
IGN5.HscApplFC AS 'Applied HSC Amount (FC)',
IGN5.BatchNum AS 'Journal Voucher No.',
IGN5.InCSTCode AS 'CST Code Incoming',
IGN5.OutCSTCode AS 'CST Code Outgoing',
IGN5.DpmWTApl AS 'DPM WT Applied Amount',
IGN5.DpmWTAplSC AS 'DPM WT Applied Amount (SC)',
IGN5.DpmWTAplFC AS 'DPM WT Applied Amount (FC)'
FROM IGN5 AS IGN5
Related information
Goods Receipt OIGN 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
