|
|
SAP Business One SDK 10.0 - Database Tables Reference |
TDS Adjustment - Rows
Table Name: JST1
Table Description: TDS Adjustment - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsId | Internal Number | Int | 11 | OJST | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | 0 | Â | Â |
| WTCode | WTax Code | nVarChar | 4 | OWHT | Â | Â | Â |
| BaseNum | Base Document Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment |
| BaseAbsId | Base Document Internal ID | Int | 11 | - | Â | Â | Â |
| BaseLine | Base Row | Int | 11 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Rate | Rate | Num | 19.6 | - | Â | Â | Â |
| TdsRate | TDS Rate | Num | 19.6 | - | Â | Â | Â |
| SurRate | Surcharge Rate | Num | 19.6 | - | Â | Â | Â |
| CessRate | Cess Rate | Num | 19.6 | - | Â | Â | Â |
| HscRate | HSC Rate | Num | 19.6 | - | Â | Â | Â |
| TaxbleAmnt | Taxable Amount | Num | 19.6 | - | Â | Â | Â |
| TxblAmntSC | Taxable Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| TxblAmntFC | Taxable Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| Category | Category | VarChar | 1 | - | Â | P | Payment |
| Â | Â | Â | Â | Â | Â | I | Invoice |
| Criteria | Criteria | VarChar | 1 | - | Â | Y | Accrual |
| Â | Â | Â | Â | Â | Â | N | Cash |
| Type | Withholding Tax Type | VarChar | 1 | - | Â | V | VAT Withholding |
| Â | Â | Â | Â | Â | Â | I | Incoming Tax Withholding |
| RoundType | Rounding Type | VarChar | 1 | - | Â | T | Truncated |
| Â | Â | Â | Â | Â | Â | C | Commercial Values |
| BaseType | Base Type | VarChar | 1 | - | Â | G | Gross |
| Â | Â | Â | Â | Â | Â | N | Net |
| Â | Â | Â | Â | Â | Â | V | VAT |
| Account | G/L Account | nVarChar | 15 | OACT | Â | Â | Â |
| TdsAcc | TDS Account | nVarChar | 15 | OACT | Â | Â | Â |
| SurAcc | Surcharge Account | nVarChar | 15 | OACT | Â | Â | Â |
| CessAcc | Cess Account | nVarChar | 15 | OACT | Â | Â | Â |
| HscAcc | HSC Account | nVarChar | 15 | OACT | Â | Â | Â |
| WTAmnt | WTax Amount | Num | 19.6 | - | Â | Â | Â |
| WTAmntSC | WTax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| WTAmntFC | WTax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| TdsBAmt | TDS Base Amount | Num | 19.6 | - | Â | Â | Â |
| TdsBAmtSC | TDS Base Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| TdsBAmtFC | TDS Base Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| SurBAmt | Surcharge Base Amount | Num | 19.6 | - | Â | Â | Â |
| SurBAmtSC | Surcharge Base Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| SurBAmtFC | Surcharge Base Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| CessBAmt | Cess Base Amount | Num | 19.6 | - | Â | Â | Â |
| CessBAmtSC | Cess Base Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| CessBAmtFC | Cess Base Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| HscBAmt | HSC Base Amount | Num | 19.6 | - | Â | Â | Â |
| HscBAmtSC | HSC Base Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| HscBAmtFC | HSC Base Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| TdsAmnt | TDS Tax Amount | Num | 19.6 | - | Â | Â | Â |
| TdsAmntSC | TDS Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| TdsAmntFC | TDS Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| SurAmnt | Surcharge Tax Amount | Num | 19.6 | - | Â | Â | Â |
| SurAmntSC | Surcharge Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| SurAmntFC | Surcharge Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| CessAmnt | Cess Tax Amount | Num | 19.6 | - | Â | Â | Â |
| CessAmntSC | Cess Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| CessAmntFC | Cess Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| HscAmnt | HSC Tax Amount | Num | 19.6 | - | Â | Â | Â |
| HscAmntSC | HSC Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| HscAmntFC | HSC Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsId |
| Â | Â | LineNum |
| BASE_ENTRY | No | AbsId |
| Â | Â | BaseNum |
| Â | Â | BaseAbsId |
| Â | Â | BaseLine |
| WT_CODE | No | AbsId |
| Â | Â | WTCode |