| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | WddCode | Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | CondId | Condition No. | int | 11 | 0 | | | 1=Deviation from Credit Limit, 2=Deviation from Commitment, 3=Gross Profit %, 4=Discount %, 5=Deviation from Budget, 6=Total Document | Allow NULL? |
| 3 | opCode | Ratio | int | 6 | 0 | | | 1=Greater than, 2=Greater or Equal, 3=Less than, 4=Less or Equal, 5=Equal, 6=Does not Equal | Allow NULL? |
| 4 | opValue | Value | nvarchar | 40 | 0 | | | | Allow NULL? |