|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Rate Differences
Table Name: ORTM
Table Description: Rate Differences
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| LineNum | Reconciliation Key | Int | 11 | - | Â | Â | Â |
| Rtmdate | Posting Date | Date | 8 | - | Â | Â | Â |
| AcctCode | G/L Account/BP Code | nVarChar | 15 | - | Â | Â | Â |
| IsCard | Card | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ActCurrncy | Document Valuation Currency | nVarChar | 3 | - | Â | Â | Â |
| ActRate | Document Revaluation Rate | Num | 19.6 | - | Â | Â | Â |
| Balance | Balance | Num | 19.6 | - | Â | Â | Â |
| FrnBlnc | FC Balance | Num | 19.6 | - | Â | Â | Â |
| TransNum | Transaction Number | Int | 11 | - | 0 | Â | Â |
| Valid | Confirmed | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Delta | Difference in LC | Num | 19.6 | - | Â | Â | Â |
| IsSysCurr | In System Currency | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| StornoDate | Reversal Date | Date | 8 | - | Â | Â | Â |
| RevalRate | Revaluation Rate | Num | 19.6 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| BPLId | Branch | Int | 11 | OBPL | Â | Â | Â |
| CntBlnc | Converted Balance | Num | 19.6 | - | Â | Â | Â |
| TransAmtSC | Transaction Amount Total | Num | 19.6 | - | Â | Â | Â |
| BalDueSC | Balance Due Total | Num | 19.6 | - | Â | Â | Â |
| SCAdjust | SC Adjustment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | LineNum |
| Â | Â | IsSysCurr |
| SYS_CURR | No | IsSysCurr |