|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Checking Rule
Table Name: ODCR
Table Description: Checking Rule
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RuleCode | Checking Rule Code | nVarChar | 2 | - | Â | Â | Â |
| RuleDesc | Checking Rule Description | nVarChar | 100 | - | Â | Â | Â |
| PastRcp | Include Past Plan Receipts | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AutoATP | ATP Check Automatically | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SLDUncfm | Schedule for Unconfirmed Qty | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AllowUncfm | Allow Unconfirmed Quantity | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CmltStrtg | Cumulation Strategy | VarChar | 1 | - | R | R | Required Qty on Creation; Confirmed Qty on Change |
| Â | Â | Â | Â | Â | Â | C | Confirmed Qty on Creation and Change |
| DeliStrtg | Delivery Strategy | VarChar | 1 | - | D | D | Delivery Proposal |
| Â | Â | Â | Â | Â | Â | O | One-Time Delivery |
| Â | Â | Â | Â | Â | Â | C | Complete Delivery |
| MaxPrpsls | Max. No. of Proposals | Int | 11 | - | 9 | Â | Â |
| validFor | Active | VarChar | 1 | - | N | Â | Â |
| validFrom | Active From | nVarChar | 8 | - | Â | Â | Â |
| validTo | Active To | nVarChar | 8 | - | Â | Â | Â |
| frozenFor | Inactive | VarChar | 1 | - | N | Â | Â |
| frozenFrom | Inactive From | nVarChar | 8 | - | Â | Â | Â |
| frozenTo | Inactive To | nVarChar | 8 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | RuleCode |