Aluminum Manufacturing ERP
Everything on this page is data — adding a system, material or rule needs no code change (spec §10, §15, §91).
Aluminum systems
| Code | Name | Version |
|---|
| SYS-X | System X | active |
Material master
| Code | Name | Category | Unit | Cost |
|---|
| ACC-ROLLER | Sliding Roller | accessory | pcs | 12.00 ILS |
| ACC-HANDLE | Window Handle | accessory | pcs | 25.00 ILS |
| ACC-LOCK | Sliding Lock | accessory | pcs | 35.00 ILS |
| ACC-MESH | Insect Mesh | accessory | m2 | 45.00 ILS |
| PRF-X-FRAME | System X Outer Frame | aluminum_profile | m | 55.00 ILS |
| PRF-X-SASH | System X Sash Profile | aluminum_profile | m | 48.00 ILS |
| GLS-DBL-6 | Double Glazed 6mm | glass | m2 | 380.00 ILS |
| ACC-RUBBER | Glazing Gasket | rubber | m | 3.50 ILS |
| ACC-SCREW | Assembly Screw | screw | pcs | 0.40 ILS |
Manufacturing rules & formulas
| Code | Name | Produces | Version | Applies when | Formula |
|---|
| SASH_W |
Sash width (derived) |
deduction |
1.0 |
always |
roundto((Width + (Sashes - 1) * 35) / Sashes, 1) |
| SASH_H |
Sash height (derived) |
deduction |
1.0 |
always |
Height - 45 |
| GLASS_W |
Glass width (derived) |
deduction |
1.0 |
always |
SASH_W - 40 |
| GLASS_H |
Glass height (derived) |
deduction |
1.0 |
always |
SASH_H - 40 |
| FRAME_H |
Outer frame horizontals |
profile |
1.0 |
always |
Width |
| FRAME_V |
Outer frame verticals |
profile |
1.0 |
always |
Height |
| SASH_TOPBOT |
Sash top/bottom rails |
profile |
1.0 |
always |
SASH_W |
| SASH_SIDES |
Sash side stiles |
profile |
1.0 |
always |
SASH_H |
| GLASS |
Glass panels |
glass |
1.0 |
always |
(GLASS_W / 1000) * (GLASS_H / 1000) * Sashes |
| ROLLER |
Sliding rollers |
accessory |
1.0 |
always |
Sashes * 2 |
| ROLLER |
Sliding rollers |
accessory |
2.0 |
always |
Sashes * 3 |
| HANDLE |
Handles |
accessory |
1.0 |
always |
Sashes |
| LOCK |
Locks |
accessory |
1.0 |
always |
if(Sashes > 1, Sashes - 1, 1) |
| RUBBER |
Glazing gasket |
rubber |
1.0 |
always |
(2 * (GLASS_W + GLASS_H) / 1000) * Sashes |
| SCREW |
Assembly screws |
screw |
1.0 |
always |
Sashes * 8 + 12 |
| MESH |
Insect mesh |
accessory |
1.0 |
Mesh == 1 |
(Width / 1000) * (Height / 1000) |