| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | ListNum | Price List No. | int | 6 | 0 | | | | Allow NULL? |
| 2 | ListName | Price List Name | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | BASE_NUM | Base Price List | int | 6 | 0 | OPLN | | | Allow NULL? |
| 4 | Factor | Factor | num | 19 | 6 | | | | Allow NULL? |
| 5 | RoundSys | Rounding Method | int | 6 | 0 | | 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 | Allow NULL? |
| 6 | GroupCode | Group No. | int | 6 | 0 | | 1 | 1=Group 1, 2=Group 2, 3=Group 3, 4=Group 4 | Allow NULL? |
| 7 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 8 | SPPCounter | SPP Counter | int | 11 | 0 | | | | Allow NULL? |
| 9 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 10 | IsGrossPrc | Gross Price? | char | 1 | 0 | | N | N=Net, Y=Gross | Allow NULL? |
| 11 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 12 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 13 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 14 | ValidFor | Active | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 15 | ValidFrom | Active From | date | 8 | 0 | | | | |
| 16 | ValidTo | Active To | date | 8 | 0 | | | | |
| 17 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 18 | PrimCurr | Primary Default Curreny | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | AddCurr1 | Additional Default Currency 1 | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | AddCurr2 | Additional Default Currency 2 | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | RoundRule | Rounding Rule | char | 1 | 0 | | R | C=Round Up, F=Round Down, R=Round to Closest | Allow NULL? |
| 22 | ExtAmount | Fixed Amount (Ending/Interval) | num | 19 | 6 | | | | Allow NULL? |
| 23 | RndFrmtInt | Ending/Interval - Integer Part | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | RndFrmtDec | Ending/Interval - Decimal Part | nvarchar | 10 | 0 | | | | Allow NULL? |
