|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Special Ledger - Analytical Accounting Report Lines: Material
Table Name: SLM1
Table Description: Special Ledger - Analytical Accounting Report Lines: Material
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocID | Document Identification Number | Int | 11 | OSLM | Â | Â | Â |
| LineID | Line Identification | Int | 11 | - | Â | Â | Â |
| RuleID | Rule Identification Number | Int | 6 | OSCM | Â | Â | Â |
| GoalNum | Rule Goal Number | Int | 6 | - | Â | Â | Â |
| TransType | Transaction Type Number | Int | 6 | - | Â | Â | Â |
| PrfCntVal | Distribution Rule Code | nVarChar | 8 | OOCR | Â | Â | Â |
| PrfCntOrig | Orig. Distribution Rule Code | nVarChar | 8 | OOCR | Â | Â | Â |
| Checked | Selected for Processing | VarChar | 1 | - | Y | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Status | Status | VarChar | 1 | - | Â | Â | Â |
| Enabled | Enabled for Processing | VarChar | 1 | - | Y | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| DebitAct | Debit Account | nVarChar | 15 | OACT | Â | Â | Â |
| CreditAct | Credit Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevSides | Revert Debit/Credit Sides | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Src | Source Amount | Num | 19.6 | - | Â | Â | Â |
| SrcFC | Source Amount, Foreign Currency | Num | 19.6 | - | Â | Â | Â |
| SrcSC | Source Amount, System Currency | Num | 19.6 | - | Â | Â | Â |
| SrcCalc | Calculated Amount | Num | 19.6 | - | Â | Â | Â |
| SrcCalcFC | Calculated Amount - Foreign | Num | 19.6 | - | Â | Â | Â |
| SrcCalcSC | Calculated Amount - System | Num | 19.6 | - | Â | Â | Â |
| FinalSum | Final Amount | Num | 19.6 | - | Â | Â | Â |
| FinalSumFC | Final Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| FinalSumSC | Final Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| Currency | Foreign Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| MainTable | Main Source Table | nVarChar | 20 | - | Â | Â | Â |
| PKField0 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField1 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField2 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField3 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField4 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField5 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField6 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField7 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField8 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| PKField9 | Primary Key Field | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocID |
| Â | Â | LineID |