|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Special Ledger - Analytical Accounting Configuration Rule Goals: Material
Table Name: SCM2
Table Description: Special Ledger - Analytical Accounting Configuration Rule Goals: Material
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RuleID | Rule Identification Number | Int | 6 | OSCM | Â | Â | Â |
| GoalNum | Rule Goal Number | nVarChar | 6 | - | Â | Â | Â |
| TransTpVal | Transaction Type Number | Int | 6 | - | Â | Â | Â |
| TransTpFld | Transaction Type Table Field | nVarChar | 20 | - | Â | Â | Â |
| PrfCntVal | Distribution Rule Code | nVarChar | 8 | OOCR | Â | Â | Â |
| PrfCntFld | Distribution Rule Table Field | nVarChar | 20 | - | Â | Â | Â |
| DebitAct | Debit Account | nVarChar | 15 | OACT | Â | Â | Â |
| CreditAct | Credit Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevSides | Revert Debit/Credit Sides | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| SrcTable | Main Source Table | nVarChar | 10 | - | Â | Â | Â |
| SrcField | Main Source Table Field | nVarChar | 20 | - | Â | Â | Â |
| SrcFieldFC | Source Field, Foreign Currency | nVarChar | 20 | - | Â | Â | Â |
| SrcFieldSC | Source Field, System Currency | nVarChar | 20 | - | Â | Â | Â |
| Calc | Calculation Expression | nVarChar | 200 | - | Â | Â | Â |
| CalcFC | Expression for Foreign Calculation | nVarChar | 200 | - | Â | Â | Â |
| CalcSC | Expression for System Calculation | nVarChar | 200 | - | Â | Â | Â |
| CalcCond | Calculation Condition | nVarChar | 200 | - | Â | Â | Â |
| CalcCondFC | Condition for Foreign Calculation | nVarChar | 200 | - | Â | Â | Â |
| CalcCondSC | Condition for System Calculation | nVarChar | 200 | - | Â | Â | Â |
| CurrFld | Table Field with Currency | nVarChar | 20 | - | Â | Â | Â |
| CallProc | Recalculation Stored Procedure Name | nVarChar | 50 | - | Â | Â | Â |
| ExtCond | Extended Special Data | nVarChar | 200 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | RuleID |
| Â | Â | GoalNum |