|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses
Table Name: OSCR
Table Description: Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RuleID | Rule Identification Number | Int | 6 | - | Â | Â | Â |
| RuleType | Rule Type Number | Int | 6 | - | 1 | Â | Â |
| ParentID | Parent Rule ID | Int | 6 | OSCR | Â | Â | Â |
| Status | Rule Status | VarChar | 1 | - | Â | Â | Â |
| Priority | Rule Priority | Int | 6 | - | 100 | Â | Â |
| Name | Rule Name | nVarChar | 100 | - | Â | Â | Â |
| CreateDate | Date of Rule Generation | Date | 8 | - | Â | Â | Â |
| UpdateDate | Date of Rule Change | Date | 8 | - | Â | Â | Â |
| UserSign | Rule Created By | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Rule Changed By | Int | 6 | OUSR | Â | Â | Â |
| ExtCond | Extended Special Data | nVarChar | 200 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | RuleID |