|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Special Prices - Quantity Areas
Table Name: ASP2
Table Description: Special Prices - Quantity Areas
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ItemCode | Item No. | nVarChar | 50 | OSPP | Â | Â | Â |
| CardCode | BP Code | nVarChar | 15 | OSPP | Â | Â | Â |
| SPP1LNum | Dates Row Number | Int | 6 | - | Â | Â | Â |
| SPP2LNum | Row Number | Int | 6 | - | Â | Â | Â |
| Amount | Quantity | Num | 19.6 | - | Â | Â | Â |
| Price | Special Price | Num | 19.6 | - | Â | Â | Â |
| Currency | Price Currency | nVarChar | 3 | - | Â | Â | Â |
| Discount | Discount in % | Num | 19.6 | - | Â | Â | Â |
| UomEntry | UoM Entry | Int | 11 | OUOM | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CardCode |
| Â | Â | ItemCode |
| Â | Â | SPP1LNum |
| Â | Â | SPP2LNum |
| Â | Â | LogInstanc |