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