|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Approval Templates - Terms
Table Name: WTM4
Table Description: Approval Templates - Terms
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| WtmCode | Code | Int | 11 | OWTM | Â | Â | Â |
| CondId | Condition No. | Int | 11 | - | 0 | 1 | Deviation from Credit Limit |
| Â | Â | Â | Â | Â | Â | 2 | Deviation from Commitment |
| Â | Â | Â | Â | Â | Â | 3 | Gross Profit % |
| Â | Â | Â | Â | Â | Â | 4 | Discount % |
| Â | Â | Â | Â | Â | Â | 5 | Deviation from Budget |
| Â | Â | Â | Â | Â | Â | 7 | Quantity |
| Â | Â | Â | Â | Â | Â | 8 | Item Code |
| Â | Â | Â | Â | Â | Â | 9 | Total |
| Â | Â | Â | Â | Â | Â | 6 | Total Document |
| Â | Â | Â | Â | Â | Â | 10 | Counted Quantity |
| Â | Â | Â | Â | Â | Â | 11 | Variance |
| Â | Â | Â | Â | Â | Â | 12 | Variance % |
| Â | Â | Â | Â | Â | Â | 13 | Operating Profit % |
| Â | Â | Â | Â | Â | Â | 14 | Net Income % |
| Â | Â | Â | Â | Â | Â | 0 | Undefined Type |
| 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 |
| Â | Â | Â | Â | Â | Â | 7 | In Range |
| Â | Â | Â | Â | Â | Â | 8 | Not in Range |
| Â | Â | Â | Â | Â | Â | 0 | Undefined Type |
| opValue | Value | nVarChar | 90 | - | Â | Â | Â |
| DecSep | Decimal Separator | VarChar | 1 | - | Â | Â | Â |
| ThousSep | Thousandths Separator | VarChar | 1 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | WtmCode |
| Â | Â | CondId |