| Pole | Typ | Plugin | Model |
|---|---|---|---|
| SIMPLE | technology | ||
id qualitycontrolrequired boolean, | bigint NOT NULL | ||
| technology_id | bigint | ||
| operation_id | bigint | ||
| parent_id | bigint | ||
| entitytype | character varying(255) | ||
| priority | integer | ||
| nodenumber | character varying(255) | ||
| comment | character varying(2048) | ||
| attachment | character varying(255) | ||
| referencetechnology_id | bigint | ||
| areproductquantitiesdivisible | boolean DEFAULT false | ||
| istjdivisible | boolean DEFAULT false | ||
| operationProductInComponents | HM | ||
| operationProductOutComponents | HM | ||
| Normy kosztowe | costNormsForOperations | ||
| pieceworkcost | numeric(12,5) DEFAULT 0::numeric | ||
| laborhourlycost | numeric(12,5) DEFAULT 0::numeric | ||
| machinehourlycost | numeric(12,5) DEFAULT 0::numeric | ||
| numberofoperations | integer DEFAULT 1 | ||
| Genealogia | AdvGenForOrder | ||
| genealogyProductInComponents | HM | ||
| Zadania operacyjne | |||
| operationalTasks | HM | ||
| Zlecenia | orders | ||
| order_id | bigint | ||
| Linia produkcyjna | productionLines | ||
| quantityOfWorkstationTypes | integer | ||
| Przydział do zmian | productionPerShifts | ||
| progressForDays | HM | ||
| hasCorrections | boolean | ||
| Kontrola jakości | qualityControls | ||
| qualityControls | HM | ||
| Podwykonawstwo | techSubcontracting | ||
| isSubcontracting | boolean | ||
| Normy czasowe | timeNormsForOperations | ||
| tpz | integer DEFAULT 0 | ||
| tj | integer DEFAULT 0 | ||
| productioninonecycle | numeric(12,5) DEFAULT 1::numeric | ||
| nextoperationafterproducedtype | character varying(255) DEFAULT '01all'::character varying | ||
| nextoperationafterproducedquantity | numeric(12,5) DEFAULT 0::numeric | ||
| timenextoperation | integer DEFAULT 0 | ||
| machineutilization | numeric(8,5) DEFAULT 1.0 | ||
| laborutilization | numeric(8,5) DEFAULT 1.0 | ||
| effectivedateto | timestamp without time zone | ||
| effectivedatefrom | timestamp without time zone, | ||
| effectiveoperationrealizationtime | integer | ||
| operationoffset | integer | ||
| productioninonecycleunit | character varying(255) | ||
| nextoperationafterproducedquantityunit | character varying(255) | ||
| duration | integer DEFAULT 0 | ||
| machineworktime | integer DEFAULT 0 | ||
| laborworktime | integer DEFAULT 0, | ||
| Karty pracy | workplans | ||
| hidedescriptioninworkplans | boolean | ||
| hidedetailsinworkplans | boolean | ||
| hidetechnologyandorderinworkplans | boolean | ||
| imageurlinworkplan | character varying(255) | ||
| dontprintinputproductsinworkplans | boolean | ||
| dontprintoutputproductsinworkplans | boolean | ||
| orderOperationInputColumns | HM | ||
| orderOperationOutputColumns | HM | ||
General
Content
Integrations