All tables
tables · table

surfacefinish

The surfacefinish table serves as a master reference for surface treatments, coatings, and finishing specifications applied to products and components. It provides a standardized list of finish types (e.g., Zinc plating, powder coating, polishing) and their corresponding detailed descriptions. This table is primarily used to qualify item variants in production (job, product2) and sales specifications (saleitemmas).

Row count
1
Last entry
—
Source
tables

Columns

5
ColumnTypeNullableMeaning
indexintegerNOPrimary Key. Unique identifier for the finish record.
compcodestringNOCompany Code. Links record to a specific legal entity.
surfacefinishstringNOThe unique identifier or name of the finish. Often used as a 'variant' in production.
sfdetailstringYESFull descriptive text of the surface finish process or requirements.
shortcodestringYESAbbreviated version of the surface finish name for compact reporting.

Full documentation

### 1. Overview
 The `surfacefinish` table serves as a master reference for surface treatments, coatings, and finishing specifications applied to products and components. It provides a standardized list of finish types (e.g., Zinc plating, powder coating, polishing) and their corresponding detailed descriptions. This table is primarily used to qualify item variants in production (`job`, `product2`) and sales specifications (`saleitemmas`).
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **index** | integer | NO | Primary Key. Unique identifier for the finish record. | | Internal ID |
 | **compcode** | string | NO | Company Code. Links record to a specific legal entity. | | `JOIN` |
 | **surfacefinish** | string | NO | The unique identifier or name of the finish. Often used as a 'variant' in production. | e.g., "ZINC", "CHROME" | `JOIN`, `FILTER` |
 | **sfdetail** | string | YES | Full descriptive text of the surface finish process or requirements. | | `DISPLAY` |
 | **shortcode** | string | YES | Abbreviated version of the surface finish name for compact reporting. | | `DISPLAY` |
 
 ### 3. Relationships & Join Map
 
 #### Authoritative Joins (Based on SCHEMA_MAP & REFERENCE_JSON)
 * **dbo.job**: Joined via `job.variant` = `surfacefinish.surfacefinish` and `job.compcode` = `surfacefinish.compcode`. This determines the finish required for a specific manufacturing job.
 * **dbo.saleitemmas**: Joined via `saleitemmas.surfacefinish` = `surfacefinish.surfacefinish` and `saleitemmas.compcode` = `surfacefinish.compcode`. Defines the finish for sales catalog items.
 * **dbo.itemmas**: Joined via `itemmas.sfcode` = `surfacefinish.surfacefinish` and `itemmas.compcode` = `surfacefinish.compcode` (Likely).
 
 #### Likely Inferred Joins (Based on naming patterns)
 * **dbo.product2 / dbo.RMproduct1**: Joins on `variant` = `surfacefinish.surfacefinish` to track finished goods/raw material states.
 * **dbo.itemcustrate**: Joins on `surf_finish` = `surfacefinish.surfacefinish` to handle customer-specific pricing for different finishes.
 * **dbo.rmincoming**: Joins on `variant` = `surfacefinish.surfacefinish` for incoming material inspections.
 
 ---