| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ItemCode |
Item No. |
nVarChar |
50 |
OITM |
|
|
|
| PriceList |
Price List No. |
Int |
6 |
OPLN |
|
|
|
| Price |
List Price |
Num |
19.6 |
- |
|
|
|
| Currency |
Currency for List Price |
nVarChar |
3 |
OCRN |
|
|
|
| Ovrwritten |
Manual Price Entry |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Factor |
Factor |
Num |
19.6 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object |
nVarChar |
20 |
ADP1 |
4 |
|
|
| AddPrice1 |
Additional Price (1) |
Num |
19.6 |
- |
|
|
|
| Currency1 |
Currency for Add. Price 1 |
nVarChar |
3 |
OCRN |
|
|
|
| AddPrice2 |
Additional Price (2) |
Num |
19.6 |
- |
|
|
|
| Currency2 |
Currency for Add. Price 2 |
nVarChar |
3 |
OCRN |
|
|
|
| Ovrwrite1 |
Manual Price Entry (1) |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Ovrwrite2 |
Manual Price Entry (2) |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BasePLNum |
Base Price List No. |
Int |
6 |
OPLN |
|
|
|
| UomEntry |
UoM Entry |
Int |
11 |
OUOM |
|
|
|
| PriceType |
Price Type |
VarChar |
1 |
- |
M |
I |
Inventory UoM Price |
| |
|
|
|
|
|
P |
Pricing Unit Price |
| |
|
|
|
|
|
M |
Both I and P |
| |
|
|
|
|
|
O |
Other UoM Price |