SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: SPP2
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 |
6 |
OUOM |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
CardCode |
| |
|
ItemCode |
| |
|
SPP1LNum |
| |
|
SPP2LNum |
| CARD |
No |
CardCode |
| ITEM |
No |
ItemCode |
| CURRENCY |
No |
Currency |