|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Rate Differences - Rows
Table Name: RTM1
Table Description: Rate Differences - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| LineNum | Reconciliation Key | Int | 11 | - | Â | Â | Â |
| TransId | Journal Key | Int | 11 | OJDT | Â | Â | Â |
| JdtLine | Journal Row | Int | 11 | - | 0 | Â | Â |
| IsSysCurr | Is System Currency | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AcctCode | G/L Account/BP Code | nVarChar | 15 | - | Â | Â | Â |
| Balance | Balance | Num | 19.6 | - | Â | Â | Â |
| FrnBlnc | Balance (FC) | Num | 19.6 | - | Â | Â | Â |
| Valid | Confirmed | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RevalRate | Revaluation Rate | Num | 19.6 | - | Â | Â | Â |
| Delta | Difference in LC | Num | 19.6 | - | Â | Â | Â |
| FCCurrency | Foreign Currency | nVarChar | 3 | - | Â | Â | Â |
| JdtAcctCod | Journal Account Code | nVarChar | 15 | - | Â | Â | Â |
| BaseRef | Base Reference | nVarChar | 11 | - | Â | Â | Â |
| JdtType | Journal Entry Type | VarChar | 1 | - | U | P | Primary |
| Â | Â | Â | Â | Â | Â | G | Generated |
| Â | Â | Â | Â | Â | Â | W | Without Primary |
| Â | Â | Â | Â | Â | Â | U | Undefined Type |
| RefDate | Posting Date | Date | 8 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| TaxDate | Document Date | Date | 8 | - | Â | Â | Â |
| BPLId | Branch | Int | 11 | OBPL | Â | Â | Â |
| CntBlnc | Converted Balance | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | LineNum |
| Â | Â | TransId |
| Â | Â | JdtLine |
| Â | Â | IsSysCurr |
| SYS_CURR | No | IsSysCurr |