|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Special Prices - Data Areas
Table Name: SPP1
Table Description: Special Prices - Data Areas
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ItemCode | Item No. | nVarChar | 50 | OSPP | Â | Â | Â |
| CardCode | BP Code | nVarChar | 15 | OSPP | Â | Â | Â |
| LINENUM | Row Number | Int | 6 | - | Â | Â | Â |
| Price | Special Price | Num | 19.6 | - | Â | Â | Â |
| Currency | Price Currency | nVarChar | 3 | - | Â | Â | Â |
| Discount | Discount % | Num | 19.6 | - | Â | Â | Â |
| ListNum | Price List No. | Int | 6 | OPLN | 0 | Â | Â |
| FromDate | Date From | Date | 8 | - | Â | Â | Â |
| ToDate | Date To | Date | 8 | - | Â | Â | Â |
| AutoUpdt | Auto Update | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Expand | Item Details | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CardCode |
| Â | Â | ItemCode |
| Â | Â | LINENUM |
| CARD | No | CardCode |
| ITEM | No | ItemCode |
| CURRENCY | No | Currency |