SAP Business One SDK 10.0 - Database Tables Reference
-
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 |