| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ListNum |
Price List No. |
Int |
6 |
- |
|
|
|
| ListName |
Price List Name |
nVarChar |
32 |
- |
|
|
|
| BASE_NUM |
Base Price List |
Int |
6 |
OPLN |
|
|
|
| Factor |
Factor |
Num |
19.6 |
- |
|
|
|
| RoundSys |
Rounding Method |
Int |
6 |
- |
0 |
0 |
No Rounding |
| |
|
|
|
|
|
1 |
Round to Full Decimal Amount |
| |
|
|
|
|
|
2 |
Round to Full Amount |
| |
|
|
|
|
|
3 |
Round to Full Tens Amount |
| |
|
|
|
|
|
4 |
Fixed Ending |
| |
|
|
|
|
|
5 |
Fixed Interval |
| GroupCode |
Group No. |
Int |
6 |
- |
1 |
1 |
Price List - Group No. 1 |
| |
|
|
|
|
|
2 |
Price List - Group No. 2 |
| |
|
|
|
|
|
3 |
Price List - Group No. 3 |
| |
|
|
|
|
|
4 |
Price List - Group No. 4 |
| |
|
|
|
|
|
5 |
Price List - Group No. 5 |
| |
|
|
|
|
|
6 |
Price List - Group No. 6 |
| |
|
|
|
|
|
7 |
Price List - Group No. 7 |
| |
|
|
|
|
|
8 |
Price List - Group No. 8 |
| |
|
|
|
|
|
9 |
Price List - Group No. 9 |
| |
|
|
|
|
|
10 |
Price List - Group No. 10 |
| |
|
|
|
|
|
11 |
Price List - Group No. 11 |
| |
|
|
|
|
|
12 |
Price List - Group No. 12 |
| |
|
|
|
|
|
13 |
Price List - Group No. 13 |
| |
|
|
|
|
|
14 |
Price List - Group No. 14 |
| |
|
|
|
|
|
15 |
Price List - Group No. 15 |
| |
|
|
|
|
|
16 |
Price List - Group No. 16 |
| |
|
|
|
|
|
17 |
Price List - Group No. 17 |
| |
|
|
|
|
|
18 |
Price List - Group No. 18 |
| |
|
|
|
|
|
19 |
Price List - Group No. 19 |
| |
|
|
|
|
|
20 |
Price List - Group No. 20 |
| |
|
|
|
|
|
21 |
Price List - Group No. 21 |
| |
|
|
|
|
|
22 |
Price List - Group No. 22 |
| |
|
|
|
|
|
23 |
Price List - Group No. 23 |
| |
|
|
|
|
|
24 |
Price List - Group No. 24 |
| |
|
|
|
|
|
25 |
Price List - Group No. 25 |
| |
|
|
|
|
|
26 |
Price List - Group No. 26 |
| |
|
|
|
|
|
27 |
Price List - Group No. 27 |
| |
|
|
|
|
|
28 |
Price List - Group No. 28 |
| |
|
|
|
|
|
29 |
Price List - Group No. 29 |
| |
|
|
|
|
|
30 |
Price List - Group No. 30 |
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| SPPCounter |
SPP Counter |
Int |
11 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| IsGrossPrc |
Gross Price? |
VarChar |
1 |
- |
N |
Y |
Gross |
| |
|
|
|
|
|
N |
Net |
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| ValidFor |
Active |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ValidFrom |
Active From |
Date |
8 |
- |
|
|
|
| ValidTo |
Active To |
Date |
8 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| PrimCurr |
Primary Default Currency |
nVarChar |
3 |
- |
|
|
|
| AddCurr1 |
Additional Default Currency 1 |
nVarChar |
3 |
- |
|
|
|
| AddCurr2 |
Additional Default Currency 2 |
nVarChar |
3 |
- |
|
|
|
| RoundRule |
Rounding Rule |
VarChar |
1 |
- |
R |
R |
Round to Closest |
| |
|
|
|
|
|
C |
Round Up |
| |
|
|
|
|
|
F |
Round Down |
| ExtAmount |
Fixed Amount (Ending/Interval) |
Num |
19.6 |
- |
|
|
|
| RndFrmtInt |
Ending/Interval - Integer Part |
nVarChar |
10 |
- |
|
|
|
| RndFrmtDec |
Ending/Interval - Decimal Part |
nVarChar |
10 |
- |
|
|
|