|
|
SQL 
Finance / 
TDS Adjustment - Rows
API JST1
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY | Internal Number | Int | 11 | OJST TDS Adjustment | WT_CODE | No |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | 0 | ||||
| WTCode | WTax Code | nVarChar | 4 | OWHT Withholding Tax | ||||
| BaseNum | Base Document Type | Int | -1) 18) A/P Invoice 204) A/P Down Payment | 11 | -1 | |||
| BaseAbsId | Base Document Internal ID | Int | 11 | |||||
| BaseLine | Base Row | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| Rate | Rate | Num | 20 | |||||
| TdsRate | TDS Rate | Num | 20 | |||||
| SurRate | Surcharge Rate | Num | 20 | |||||
| CessRate | Cess Rate | Num | 20 | |||||
| HscRate | HSC Rate | Num | 20 | |||||
| TaxbleAmnt | Taxable Amount | Num | 20 | |||||
| TxblAmntSC | Taxable Amount (SC) | Num | 20 | |||||
| TxblAmntFC | Taxable Amount (FC) | Num | 20 | |||||
| Category | Category | VarChar | P) Payment I) Invoice | 1 | ||||
| Criteria | Criteria | VarChar | Y) Accrual N) Cash | 1 | ||||
| Type | Withholding Tax Type | VarChar | V) VAT Withholding I) Incoming Tax Withholding | 1 | ||||
| RoundType | Rounding Type | VarChar | T) Truncated C) Commercial Values | 1 | ||||
| BaseType | Base Type | VarChar | G) Gross N) Net V) VAT | 1 | ||||
| Account | G/L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| 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 | ||||
| WTAmnt | WTax Amount | Num | 20 | |||||
| WTAmntSC | WTax Amount (SC) | Num | 20 | |||||
| WTAmntFC | WTax Amount (FC) | 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 |
Table relationship map
SELECT statement
SELECT
JST1.AbsId AS 'Internal Number',
JST1.LineNum AS 'Row Number',
JST1.WTCode AS 'WTax Code',
JST1.BaseNum AS 'Base Document Type',
JST1.BaseAbsId AS 'Base Document Internal ID',
JST1.BaseLine AS 'Base Row',
JST1.LogInstanc AS 'Log Instance',
JST1.Rate AS 'Rate',
JST1.TdsRate AS 'TDS Rate',
JST1.SurRate AS 'Surcharge Rate',
JST1.CessRate AS 'Cess Rate',
JST1.HscRate AS 'HSC Rate',
JST1.TaxbleAmnt AS 'Taxable Amount',
JST1.TxblAmntSC AS 'Taxable Amount (SC)',
JST1.TxblAmntFC AS 'Taxable Amount (FC)',
JST1.Category AS 'Category',
JST1.Criteria AS 'Criteria',
JST1.Type AS 'Withholding Tax Type',
JST1.RoundType AS 'Rounding Type',
JST1.BaseType AS 'Base Type',
JST1.Account AS 'G/L Account',
JST1.TdsAcc AS 'TDS Account',
JST1.SurAcc AS 'Surcharge Account',
JST1.CessAcc AS 'Cess Account',
JST1.HscAcc AS 'HSC Account',
JST1.WTAmnt AS 'WTax Amount',
JST1.WTAmntSC AS 'WTax Amount (SC)',
JST1.WTAmntFC AS 'WTax Amount (FC)',
JST1.TdsBAmt AS 'TDS Base Amount',
JST1.TdsBAmtSC AS 'TDS Base Amount (SC)',
JST1.TdsBAmtFC AS 'TDS Base Amount (FC)',
JST1.SurBAmt AS 'Surcharge Base Amount',
JST1.SurBAmtSC AS 'Surcharge Base Amount (SC)',
JST1.SurBAmtFC AS 'Surcharge Base Amount (FC)',
JST1.CessBAmt AS 'Cess Base Amount',
JST1.CessBAmtSC AS 'Cess Base Amount (SC)',
JST1.CessBAmtFC AS 'Cess Base Amount (FC)',
JST1.HscBAmt AS 'HSC Base Amount',
JST1.HscBAmtSC AS 'HSC Base Amount (SC)',
JST1.HscBAmtFC AS 'HSC Base Amount (FC)',
JST1.TdsAmnt AS 'TDS Tax Amount',
JST1.TdsAmntSC AS 'TDS Tax Amount (SC)',
JST1.TdsAmntFC AS 'TDS Tax Amount (FC)',
JST1.SurAmnt AS 'Surcharge Tax Amount',
JST1.SurAmntSC AS 'Surcharge Tax Amount (SC)',
JST1.SurAmntFC AS 'Surcharge Tax Amount (FC)',
JST1.CessAmnt AS 'Cess Tax Amount',
JST1.CessAmntSC AS 'Cess Tax Amount (SC)',
JST1.CessAmntFC AS 'Cess Tax Amount (FC)',
JST1.HscAmnt AS 'HSC Tax Amount',
JST1.HscAmntSC AS 'HSC Tax Amount (SC)',
JST1.HscAmntFC AS 'HSC Tax Amount (FC)'
FROM JST1 AS JST1
Related information
TDS Adjustment OJST SQL Table
G/L Accounts OACT 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