|
|
SQL Administration / Interest Rates
DTW Inventory / Inventory Transactions / Inventory Transfer Request
API RIT1
RIT1 - Interest Rates Table
Dunning Interest Rate ORIT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Object Code | nVarChar | 20 | ORIT Dunning Interest Rate | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| Days | Number of Tolerance Days | Int | 6 | |||||
| IntrstPrct | Interest % | Num | 20 | |||||
| FixedSum | Fixed Interest Amount | Num | 20 | |||||
| FixSumCurr | Fixed Amount Currency | nVarChar | 3 |
SELECT statement
SELECT
RIT1.Code AS 'Object Code',
RIT1.LineNum AS 'Row Number',
RIT1.Days AS 'Number of Tolerance Days',
RIT1.IntrstPrct AS 'Interest %',
RIT1.FixedSum AS 'Fixed Interest Amount',
RIT1.FixSumCurr AS 'Fixed Amount Currency'
FROM RIT1 AS RIT1
Related information
Dunning Interest Rate ORIT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
