tables · table
vitemopr
The vitemopr table serves as a configuration mapping between Vendors, Items, and Operations. It defines the production/process capacity and grace time allowed for a specific vendor performing a specific operation on a specific item. This is typically used in subcontracting or multi-vendor procurement modules to track vendor-specific constraints.
Row count
1
Last entry
—
Source
tables
Columns
8| Column | Type | Nullable | Meaning |
|---|---|---|---|
index | integer | No | Primary key/Sequential record ID |
compcode | string | Yes | Company identifier |
vendcode | string | Yes | Unique code for the vendor |
itemcode | string | Yes | Unique code for the item/part |
oprcode | string | Yes | Operation code performed by the vendor |
capacity | integer | Yes | Process capacity for the specific mapping |
gracetime | integer | Yes | Allowed delay or buffer time (usually in days) |
username | string | Yes | User who created or updated the record |
Full documentation
### 1) Overview The `vitemopr` table serves as a configuration mapping between **Vendors**, **Items**, and **Operations**. It defines the production/process capacity and grace time allowed for a specific vendor performing a specific operation on a specific item. This is typically used in subcontracting or multi-vendor procurement modules to track vendor-specific constraints. ### 2) Column Dictionary | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage | | :--- | :--- | :--- | :--- | :--- | :--- | | **index** | integer | No | Primary key/Sequential record ID | | Unique identifier | | **compcode** | string | Yes | Company identifier | e.g., "DAS" | `WHERE compcode = 'DAS'` | | **vendcode** | string | Yes | Unique code for the vendor | Links to `dbo.vendmas` | `JOIN dbo.vendmas ON ...` | | **itemcode** | string | Yes | Unique code for the item/part | Links to `dbo.itemmas` | `JOIN dbo.itemmas ON ...` | | **oprcode** | string | Yes | Operation code performed by the vendor | Links to `dbo.oprmas` | `JOIN dbo.oprmas ON ...` | | **capacity** | integer | Yes | Process capacity for the specific mapping | e.g., 500 units | Production planning | | **gracetime** | integer | Yes | Allowed delay or buffer time (usually in days) | | Scheduling/Lead time | | **username** | string | Yes | User who created or updated the record | e.g., "system" | Audit tracking | ### 3) Relationships & Join Map Based on the `SCHEMA_MAP`, `vitemopr` acts as a lookup table for vendor-operation specificities. #### Mandatory Joins (Shared Keys) * **Vendor Master**: `dbo.vendmas` on `vendcode` and `compcode`. * **Item Master**: `dbo.itemmas` (or `dbo.saleitemmas`) on `itemcode` and `compcode`. * **Operation Master**: `dbo.oprmas` on `oprcode` and `compcode`. #### Likely Functional Joins * **Vendor Item Mapping**: `dbo.vendmasitem` on `vendcode` and `itemcode`. * **Vendor Item Operation Details**: `dbo.itemvendopr` on `vendcode`, `itemcode`, and `oprcode`. * **Job Work Tracking**: `dbo.job` on `vendcode`, `itemcode`, and `oprcode` to compare actual performance against the configured `capacity` or `gracetime`.