|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Schedule Row Detail
Table Name: OSLD
Table Description: Schedule Row Detail
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 13 | A/R Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 18 | A/P Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 22 | Purchase Order |
| Â | Â | Â | Â | Â | Â | 163 | A/P Correction Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 165 | A/R Correction Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 202 | Production Order |
| Â | Â | Â | Â | Â | Â | 1250000001 | Warehouse Transfer Request |
| DocEntry | Associated Doc Entry | Int | 11 | - | Â | Â | Â |
| DocLineNum | Associated Doc Row No. | Int | 11 | - | Â | Â | Â |
| SchdLine | Schedule Row No. | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS | Â | Â | Â |
| CfmDate | Confirmation Date | Date | 8 | - | Â | Â | Â |
| CfmQty | Confirmation Quantity | Num | 19.6 | - | Â | Â | Â |
| FixedCfm | Fixed Confirmation Data | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ReqQty | Required Quantity | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| SCHD_LINE | Yes | ObjType |
| Â | Â | DocEntry |
| Â | Â | DocLineNum |
| Â | Â | SchdLine |
| DOCLINESLD | No | ObjType |
| Â | Â | DocEntry |
| Â | Â | DocLineNum |