| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | WtmCode | Code | int | 11 | 0 | OWTM | | | Allow NULL? |
| 2 | CondId | Condition No. | int | 11 | 0 | | 0 | 0=Undefined Type, 10=Counted Quantity, 11=Variance, 12=Variance %, 1=Deviation from Credit Limit, 2=Deviation from Commitment, 3=Gross Profit %, 4=Discount %, 5=Deviation from Budget, 6=Total Document, 7=Quantity, 8=Item Code, 9=Total | Allow NULL? |
| 3 | opCode | Ratio | int | 6 | 0 | | 0 | 0=Undefined Type, 1=Greater Than, 2=Greater or Equal, 3=Less Than, 4=Less or Equal, 5=Equal, 6=Does not Equal, 7=In Range, 8=Not in Range | Allow NULL? |
| 4 | opValue | Value | nvarchar | 90 | 0 | | | | Allow NULL? |
