|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Special Ledger - Analytical Accounting Report: Material
Table Name: OSLM
Table Description: Special Ledger - Analytical Accounting Report: Material
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocID | Document Identification Number | Int | 11 | - | Â | Â | Â |
| DocDate | Date of Report Generation | Date | 8 | - | Â | Â | Â |
| Ref1 | Journal Entry Number | Int | 11 | OJDT | Â | Â | Â |
| Ref2 | Original JE Reference | Int | 11 | OJDT | Â | Â | Â |
| Status | Document Status | VarChar | 1 | - | Â | Â | Â |
| DateFrom | Document Start Date | Date | 8 | - | Â | Â | Â |
| DateTo | Document End Date | Date | 8 | - | Â | Â | Â |
| TotDebit | Total Debit Amount | Num | 19.6 | - | Â | Â | Â |
| TotCredit | Total Credit Amount | Num | 19.6 | - | Â | Â | Â |
| RateType | Type of Exchange Rate | VarChar | 1 | - | O | O | Original document |
| Â | Â | Â | Â | Â | Â | E | Execution date |
| Â | Â | Â | Â | Â | Â | V | Other value |
| Comment | Remarks | nVarChar | 250 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Canceled | Canceled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CancelDate | Cancelation Date | Date | 8 | - | Â | Â | Â |
| CancelUser | Document Cancelled by | Int | 6 | OUSR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocID |