|
|
API RTM1
RTM1 - Rate Differences - Rows Table
Business Place OBPL SQL Table
Journal Entry OJDT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | LineNum KEY UNIQUE | Reconciliation Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TransId | Journal Key | Int | 11 | OJDT Journal Entry | ||||
| JdtLine | Journal Row | Int | 11 | 0 | ||||
| IsSysCurr KEY | Is System Currency | VarChar | Y) Yes N) No | 1 | N | SYS_CURR | No | |
| AcctCode | G/L Account/BP Code | nVarChar | 15 | |||||
| Balance | Balance | Num | 20 | |||||
| FrnBlnc | Balance (FC) | Num | 20 | |||||
| Valid | Confirmed | VarChar | Y) Yes N) No | 1 | Y | |||
| RevalRate | Revaluation Rate | Num | 20 | |||||
| Delta | Difference in LC | Num | 20 | |||||
| FCCurrency | Foreign Currency | nVarChar | 3 | |||||
| JdtAcctCod | Journal Account Code | nVarChar | 15 | |||||
| BaseRef | Base Reference | nVarChar | 11 | |||||
| JdtType | Journal Entry Type | VarChar | P) Primary G) Generated W) Without Primary U) Undefined Type | 1 | U | |||
| RefDate | Posting Date | Date | 8 | |||||
| DueDate | Due Date | Date | 8 | |||||
| TaxDate | Document Date | Date | 8 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| CntBlnc | Converted Balance | Num | 20 |
Table relationship map
SELECT statement
SELECT
RTM1.LineNum AS 'Reconciliation Key',
RTM1.TransId AS 'Journal Key',
RTM1.JdtLine AS 'Journal Row',
RTM1.IsSysCurr AS 'Is System Currency',
RTM1.AcctCode AS 'G/L Account/BP Code',
RTM1.Balance AS 'Balance',
RTM1.FrnBlnc AS 'Balance (FC)',
RTM1.Valid AS 'Confirmed',
RTM1.RevalRate AS 'Revaluation Rate',
RTM1.Delta AS 'Difference in LC',
RTM1.FCCurrency AS 'Foreign Currency',
RTM1.JdtAcctCod AS 'Journal Account Code',
RTM1.BaseRef AS 'Base Reference',
RTM1.JdtType AS 'Journal Entry Type',
RTM1.RefDate AS 'Posting Date',
RTM1.DueDate AS 'Due Date',
RTM1.TaxDate AS 'Document Date',
RTM1.BPLId AS 'Branch',
RTM1.CntBlnc AS 'Converted Balance'
FROM RTM1 AS RTM1
Related information
Business Place OBPL SQL Table
Journal Entry OJDT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
