|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Special Ledger - Analytical Accounting Configuration Rule Conditions: Revenues & Expenses
Table Name: SCR1
Table Description: Special Ledger - Analytical Accounting Configuration Rule Conditions: Revenues & Expenses
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RuleID | Rule Identification Number | Int | 6 | OSCR | Â | Â | Â |
| CondNum | Condition Number | Int | 6 | - | Â | Â | Â |
| Value1 | Static Value | nVarChar | 200 | - | Â | Â | Â |
| Table1 | Table Name | nVarChar | 20 | - | Â | Â | Â |
| Field1 | Table Field Name | nVarChar | 200 | - | Â | Â | Â |
| Cond1 | Value Selection Condition | nVarChar | 200 | - | Â | Â | Â |
| Group1 | Group by Clause | nVarChar | 100 | - | Â | Â | Â |
| Relation | Comparison Operator | nVarChar | 50 | - | Â | Â | Â |
| Value2 | Static Value | nVarChar | 200 | - | Â | Â | Â |
| Table2 | Table Name | nVarChar | 20 | - | Â | Â | Â |
| Field2 | Table Field Name | nVarChar | 200 | - | Â | Â | Â |
| Cond2 | Comparison Operator | nVarChar | 200 | - | Â | Â | Â |
| Group2 | Group by Clause | nVarChar | 100 | - | Â | Â | Â |
| ExtCond1 | Extended Special Data | nVarChar | 200 | - | Â | Â | Â |
| ExtCond2 | Extended Special Data | nVarChar | 200 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | RuleID |
| Â | Â | CondNum |