P0 catalog walker
IRIS’s own memory of the version-3 Eloquent catalog. A PHP artisan job walks llm/nav.json in small batches, then persists nodes, edges, and identifier hints. No GPU. No fetch_erp. No intent registry writes. Ask stays on /eloquent-llm.
Generation
1
Status
idle
Nodes learned
283 / 283
Cursor
283
Edges
845
Identifiers
22
Last tick
2026-08-26T20:05:03+00:00
GPU
0
Catalog generated 2026-08-19T18:07:17+00:00. Snapshot storage/app/iris-context/latest.json. Command: php artisan iris:context-walk --once --limit=15.
283
| node_key | class | table | rels | lookup |
|---|---|---|---|---|
| accountpayabletracking | AccountPayableTracking | account_payable_tracking | 5 | — |
| accountreceivabletracking | AccountReceivableTracking | account_receivables_tracking | 3 | — |
| address | Address | empty | 1 | — |
| bin | Bin | Bins | 0 | — |
| bom | Bom | boms | 30 | part_number |
| bomauditlog | BomAuditLog | bom_audit_logs | 1 | — |
| bombehaviour | BomBehaviour | bom_behaviours | 0 | — |
| bomcategory | BomCategory | bom_categories | 1 | — |
| bomchild | BomChild | bom_childs | 4 | — |
| bominventory | BomInventory | bom_inventories | 6 | — |
| bomoperationworkguide | BomOperationWorkGuide | bom_operation_work_guides | 1 | — |
| bomprice | BomPrice | bom_prices | 4 | — |
| bomprocess | BomProcess | bom_processes | 8 | — |
| bomprocessdynamicvariablecontent | BomProcessDynamicVariableContent | bom_process_dynamic_variable_contents | 2 | — |
| bomprocessio | BomProcessIO | bom_process_io | 3 | — |
| bomprocessioitem | BomProcessIOItem | bom_process_io_items | 2 | — |
| bomprocessop | BomProcessOP | bom_process_op | 3 | — |
| bomresource | BomResource | bom_resources | 9 | — |
| bomtoquotationbombinding | BomToQuotationBomBinding | bom_to_quotation_bom_bindings | 0 | — |
| bomtype | BomType | bom_types | 0 | — |
| bracketno | BracketNo | bracket_no | 1 | — |
| calendarcachehierarchical | CalendarCacheHierarchical | empty | 2 | — |
| calendardetailbybomtypecache | CalendarDetailByBomTypeCache | calendar_detail_by_bom_type_caches | 0 | — |
| calendardetailbycustomercache | CalendarDetailByCustomerCache | calendar_detail_by_customer_caches | 1 | — |
| calendardetailbyfaicache | CalendarDetailByFAICache | calendar_detail_by_fai_caches | 0 | — |
| calendardetailbyfaicustomercache | CalendarDetailByFAICustomerCache | calendar_detail_by_fai_by_customer_caches | 1 | — |
| calendardetailcache | CalendarDetailCache | empty | 0 | — |
| calendardetailcachedependency | CalendarDetailCacheDependency | empty | 1 | — |
| calendardetaildivisioncustomercache | CalendarDetailDivisionCustomerCache | empty | 2 | — |
| calendardetaildivisionfaicache | CalendarDetailDivisionFaiCache | empty | 1 | — |
| calendardetaildivisionprocesscache | CalendarDetailDivisionProcessCache | empty | 1 | — |
| calendardetailprocesscache | CalendarDetailProcessCache | empty | 3 | — |
| calendarnondeliveredvaluationcache | CalendarNonDeliveredValuationCache | calendar_non_delivered_valuation_caches | 0 | — |
| calendarsetting | CalendarSetting | empty | 1 | — |
| chatbotquerylog | ChatbotQueryLog | chatbot_query_logs | 0 | — |
| commercialinvoice | CommercialInvoice | commercial_invoices | 4 | — |
| commercialinvoiceimport | CommercialInvoiceImport | commercial_invoice_imports | 4 | — |
| commercialinvoiceimportitem | CommercialInvoiceImportItem | commercial_invoices_import_items | 1 | — |
| commercialinvoiceitem | CommercialInvoiceItem | commercial_invoices_items | 1 | — |
| commercialinvoicelocal | CommercialInvoiceLocal | commercial_invoice_locals | 3 | — |
| commercialinvoicelocalitem | CommercialInvoiceLocalItem | commercial_invoice_local_items | 1 | — |
| companyprofile | CompanyProfile | company_profiles | 2 | — |
| companysetting | CompanySetting | company_settings | 0 | — |
| consolidatedeinvoicebatch | ConsolidatedEinvoiceBatch | consolidated_einvoice_batches | 5 | — |
| consolidatedeinvoicebatchitem | ConsolidatedEinvoiceBatchItem | consolidated_einvoice_batch_items | 3 | — |
| creditdebitnote | CreditDebitNote | credit_debit_notes | 5 | — |
| creditdebitnotecancellationrequest | CreditDebitNoteCancellationRequest | empty | 4 | — |
| creditdebitnoteitem | CreditDebitNoteItem | credit_debit_note_items | 3 | — |
| currency | Currency | currencies | 2 | — |
| customer | Customer | customers | 7 | — |
| customerrequestdatechangelog | CustomerRequestDateChangeLog | customer_request_date_changelogs | 0 | — |
| custominvoiceitem | CustomInvoiceItem | custom_invoice_items | 3 | — |
| delayedproductionschedule | DelayedProductionSchedule | delayed_production_schedules | 5 | — |
| delayedshipmentschedule | DelayedShipmentSchedule | delayed_shipment_schedules | 5 | — |
| deliveryevidence | DeliveryEvidence | delivery_evidences | 1 | — |
| deliveryschedulecategory | DeliveryScheduleCategory | delivery_schedule_categories | 0 | — |
| deliveryscheduledetail | DeliveryScheduleDetail | delivery_schedule_details | 3 | — |
| deliveryschedulelist | DeliveryScheduleList | delivery_schedule_lists | 2 | — |
| developmenttask | DevelopmentTask | development_tasks | 0 | — |
| division | Division | empty | 5 | — |
| divisionemployee | DivisionEmployee | empty | 0 | — |
| divisionprocess | DivisionProcess | division_process | 2 | — |
| documentprefix | DocumentPrefix | document_prefixes | 0 | — |
| dynamiccalendarcache | DynamicCalendarCache | empty | 0 | — |
| einvoiceauditlogentry | EinvoiceAuditLogEntry | einvoice_audit_log | 1 | — |
| einvoiceclassificationcode | EinvoiceClassificationCode | einvoice_classification_codes | 0 | — |
| einvoicecountry | EinvoiceCountry | einvoice_countries | 0 | — |
| einvoicedocumenttype | EinvoiceDocumentType | einvoice_document_types | 0 | — |
| einvoicemsiccode | EinvoiceMsicCode | einvoice_msic_codes | 0 | — |
| einvoicenotification | EinvoiceNotification | einvoice_notifications | 0 | — |
| einvoicepaymentmode | EinvoicePaymentMode | einvoice_payment_modes | 0 | — |
| einvoicesavedsearch | EinvoiceSavedSearch | einvoice_saved_searches | 0 | — |
| einvoicesetting | EinvoiceSetting | einvoice_settings | 0 | — |
| einvoicestatecode | EinvoiceStateCode | einvoice_state_codes | 0 | — |
| einvoicesubmissionjob | EinvoiceSubmissionJob | einvoice_submission_jobs | 0 | — |
| einvoicetaxtype | EinvoiceTaxType | einvoice_tax_types | 0 | — |
| einvoiceuom | EinvoiceUom | einvoice_uoms | 0 | — |
| einvoicewebhooklog | EinvoiceWebhookLog | einvoice_webhook_log | 0 | — |
| empty | 2 | — | ||
| employee | Employee | employees | 6 | staff_id |
| exchangerate | ExchangeRate | exchangerates | 2 | — |
| faigallery | FaiGallery | fai_galleries | 1 | — |
| fgactualimportbatch | FgActualImportBatch | fg_actual_import_batches | 2 | — |
| fgreclaimentry | FgReclaimEntry | fg_reclaim_entries | 4 | — |
| finishgoodsstock | FinishGoodsStock | finish_goods_stocks | 8 | — |
| finishgoodstocklocation | FinishGoodStockLocation | finish_good_stock_locations | 5 | — |
| finishgoodstockstransaction | FinishGoodStocksTransaction | finish_good_stocks_transactions | 10 | — |
| globalsetting | GlobalSetting | empty | 0 | — |
| goodrecieptsnoteitem | GoodRecieptsNoteItem | goodrecieptsnoteitems | 6 | — |
| goodsreceiptsnote | GoodsReceiptsNote | goodsreceiptsnotes | 7 | grn_number |
| gpb | Gpb | gpb_documents | 2 | — |
| gpb_report | Gpb_report | gpb_reports | 0 | — |
| grncancellationrequest | GrnCancellationRequest | empty | 4 | — |
| hardware | Hardware | hardwares | 0 | — |
| imte | Imte | imtes | 0 | — |
| inventory | Inventory | inventories | 21 | part_number |
| inventorycategory | InventoryCategory | inventory_categories | 1 | — |
| inventorylocation | InventoryLocation | inventory_locations | 1 | — |
| inventoryprice | InventoryPrice | inventory_prices | 6 | — |
| inventorystock | InventoryStock | inventory_stocks | 0 | — |
| inventorytracker | InventoryTracker | inventory_trackers | 0 | — |
| inventoryusagelayout | InventoryUsageLayout | inventory_usage_layouts | 0 | — |
| inventoryusagelayoutitem | InventoryUsageLayoutItem | inventory_Usage_Layout_Items | 0 | — |
| invoice | Invoice | invoices | 21 | invoice_number |
| invoiceablequantity | InvoiceableQuantity | invoiceable_quantities | 1 | — |
| invoicecancellationrequest | InvoiceCancellationRequest | invoice_cancellation_requests | 6 | — |
| invoicecategory | InvoiceCategory | invoice_categories | 0 | — |
| invoiceitem | InvoiceItem | invoice_items | 5 | — |
| itemtransfer | ItemTransfer | item_transfers | 8 | — |
| itemtransfergallery | ItemTransferGallery | item_transfer_galleries | 3 | — |
| joborder | JobOrder | job_orders | 7 | job_order_number |
| joborderitem | JobOrderItem | job_order_items | 3 | — |
| k1 | K1 | k1_documents | 2 | — |
| k2 | K2 | k2_documents | 2 | — |
| k9 | K9 | k9_documents | 1 | — |
| kuk | Kuk | kuk_documents | 2 | — |
| labelsize | LabelSize | labels | 0 | — |
| lmw | Lmw | lmws | 2 | — |
| lmwdetail | LmwDetail | lmwdetails | 1 | — |
| location | Location | locations | 5 | — |
| locationcategory | LocationCategory | location_categories | 1 | — |
| locationnetwork | LocationNetwork | location_networks | 1 | — |
| logistic | Logistic | logistics | 4 | — |
| logisticitem | LogisticItem | logistic_items | 1 | — |
| logisticsubmissionaccount | LogisticSubmissionAccount | logisticsubmissionaccounts | 1 | — |
| logisticsubmissionaccountitem | LogisticSubmissionAccountItem | logisticsubmissionaccountitems | 1 | — |
| machine | Machine | machines | 6 | — |
| machinelist | MachineList | machine_lists | 0 | — |
| machinemaintenanceschedule | MachineMaintenanceSchedule | machine_maintenance_schedules | 3 | — |
| machinemaintenancescheduledetail | MachineMaintenanceScheduleDetail | machine_maintenance_schedule_details | 2 | — |
| machiningschedulecategory | MachiningScheduleCategory | machining_schedule_categories | 0 | — |
| machiningscheduledetail | MachiningScheduleDetail | machining_schedule_details | 1 | — |
| machiningschedulelist | MachiningScheduleList | machining_schedule_lists | 2 | — |
| machiningscheduleprocess | MachiningScheduleProcess | machining_schedule_processes | 3 | — |
| maintenancechecklist | MaintenanceChecklist | maintenance_checklists | 1 | — |
| maintenancefrequency | MaintenanceFrequency | maintenance_frequency | 1 | — |
| materialinvoicevoucher | MaterialInvoiceVoucher | material_invoice_vouchers | 5 | — |
| materialprice | MaterialPrice | material_prices | 1 | — |
| moq | Moq | moqs | 1 | — |
| mpsarchivedata | MpsArchiveData | mps_archive_datas | 0 | — |
| mrpactivity | MrpActivity | mrp_activities | 4 | — |
| mrpanalysiscontrol | MrpAnalysisControl | mrp_analysis_controls | 2 | — |
| mrpanalysisprojection | MrpAnalysisProjection | mrp_analysis_projections | 2 | — |
| mrpanalysisrun | MrpAnalysisRun | mrp_analysis_runs | 4 | — |
| mrpanalysissocrd | MrpAnalysisSocrd | mrp_analysis_socrds | 6 | — |
| mrpforecastline | MrpForecastLine | mrp_forecast_lines | 4 | — |
| mrpforecastlinevalue | MrpForecastLineValue | mrp_forecast_line_values | 1 | — |
| mrpforecastupload | MrpForecastUpload | mrp_forecast_uploads | 2 | — |
| mrpplan | MrpPlan | mrp_plans | 11 | — |
| mrpplanapproval | MrpPlanApproval | mrp_plan_approvals | 2 | — |
| mrpplanitem | MrpPlanItem | mrp_plan_items | 11 | — |
| mrpprofile | MrpProfile | mrp_profiles | 2 | — |
| notification | Notification | notifications | 1 | — |
| packinglist | PackingList | packing_lists | 4 | — |
| packinglistitem | PackingListItem | packing_list_items | 5 | — |
| pdo | Pdo | pdos | 3 | — |
| pdoitem | PdoItem | pdo_items | 3 | — |
| pdosupplier | PdoSupplier | pdo_suppliers | 3 | — |
| pdosupplieritem | PdoSupplierItem | pdo_supplier_items | 3 | — |
| permissions | Permissions | permissions | 0 | — |
| plantschedulecategory | PlantScheduleCategory | plant_schedule_categories | 0 | — |
| plantscheduledetail | PlantScheduleDetail | plant_schedule_details | 2 | — |
| plantschedulelist | PlantScheduleList | plant_schedule_lists | 3 | — |
| popricerevision | PoPriceRevision | po_price_revisions | 3 | — |
| popricerevisionitem | PoPriceRevisionItem | po_price_revision_items | 4 | — |
| porevisionauditlog | PoRevisionAuditLog | po_revision_audit_logs | 2 | — |
| powder | Powder | powders | 1 | — |
| printformat | PrintFormat | print_formats | 0 | — |
| printformattype | PrintFormatType | print_format_types | 0 | — |
| process | Process | processes | 11 | — |
| processdynamicvariable | ProcessDynamicVariable | process_dynamic_variables | 1 | — |
| processgallery | ProcessGallery | process_galleries | 2 | — |
| processschedule | ProcessSchedule | process_schedules | 0 | — |
| processtravellerformnumber | ProcessTravellerFormNumber | process_traveller_form_numbers | 0 | — |
| productcost | ProductCost | product_costs | 1 | — |
| productionreceivaltransaction | ProductionReceivalTransaction | production_receival_transactions | 3 | — |
| productpertime | ProductPerTime | product_per_times | 1 | — |
| producttime | ProductTime | product_times | 1 | — |
| project | Project | projects | 1 | — |
| purchaseorder | PurchaseOrder | purchase_orders | 8 | po_number |
| purchaseorderitem | PurchaseOrderItem | purchase_order_items | 12 | — |
| purchaseorderitemdeliveryschedule | PurchaseOrderItemDeliverySchedule | purchase_order_item_delivery_schedules | 7 | — |
| purchaseorderitemdeliveryschedulehistory | PurchaseOrderItemDeliveryScheduleHistory | purchase_order_item_delivery_schedule_history | 1 | — |
| purchasepricemonitoritem | PurchasePriceMonitorItem | purchase_price_monitor_items | 6 | — |
| purchasepricemonitorrun | PurchasePriceMonitorRun | purchase_price_monitor_runs | 2 | — |
| purchasepricemonitorsetting | PurchasePriceMonitorSetting | purchase_price_monitor_settings | 0 | — |
| purchasereport | PurchaseReport | purchase_report | 1 | — |
| purchaserequest | PurchaseRequest | purchase_requests | 18 | pr_number |
| purchaserequesttype | PurchaseRequestType | purchase_request_types | 0 | — |
| qcgallery | QcGallery | qc_galleries | 1 | — |
| quotation | Quotation | quotations | 4 | — |
| quotationbom | QuotationBom | quotation_boms | 12 | — |
| quotationbomchild | QuotationBomChild | quotation_bom_childs | 1 | — |
| quotationbominventory | QuotationBomInventory | quotation_bom_inventories | 2 | — |
| quotationbomprice | QuotationBomPrice | quotation_bom_prices | 4 | — |
| quotationbomprocess | QuotationBomProcess | quotation_bom_processes | 5 | — |
| quotationinventory | QuotationInventory | quotation_inventories | 7 | — |
| quotationinventorycategory | QuotationInventoryCategory | quotation_inventory_categories | 1 | — |
| quotationinventorydynamicvariable | QuotationInventoryDynamicVariable | quotation_inventory_dynamic_variables | 1 | — |
| quotationinventorydynamicvariablecontent | QuotationInventoryDynamicVariableContent | quotation_inventory_dynamic_variable_contents | 2 | — |
| quotationinventoryprice | QuotationInventoryPrice | quotation_inventory_prices | 4 | — |
| quotationitem | QuotationItem | quotation_items | 5 | — |
| quotationsupplier | QuotationSupplier | quotation_suppliers | 0 | — |
| receivedeinvoice | ReceivedEinvoice | received_einvoices | 5 | — |
| receivedeinvoiceitem | ReceivedEinvoiceItem | received_einvoice_items | 2 | — |
| rejectgallery | RejectGallery | reject_galleries | 2 | — |
| resource | Resource | resources | 0 | — |
| role | Role | roles | 1 | — |
| runningnumber | RunningNumber | running_numbers | 0 | — |
| salesorder | SalesOrder | sales_orders | 11 | so_number |
| salesordercustomerrequestdate | SalesOrderCustomerRequestDate | sales_order_customer_request_dates | 8 | — |
| salesordercustomerrequestdatehistory | SalesOrderCustomerRequestDateHistory | sales_order_customer_request_date_histories | 1 | — |
| salesorderitem | SalesOrderItem | sales_order_items | 18 | — |
| scrapdisposal | ScrapDisposal | scrap_disposals | 0 | — |
| scrapdisposalitem | ScrapDisposalItem | scrap_disposal_items | 0 | — |
| shipmentframe | ShipmentFrame | shipment_frames | 5 | — |
| shipmentframecategory | ShipmentFrameCategory | shipment_frame_categories | 0 | — |
| shipmentframeitem | ShipmentFrameItem | shipment_frame_items | 1 | — |
| shipmentpiecepart | ShipmentPiecePart | shipment_pieceparts | 4 | — |
| shipmentpiecepartitem | ShipmentPiecePartItem | shipment_piecepart_items | 1 | — |
| skiplog | SkipLog | terminal_skip_logs | 3 | — |
| sku | Sku | sku | 1 | — |
| smpstock | SMPStock | smp_stocks | 3 | — |
| smpstocklocation | SMPStockLocation | smp_stock_locations | 3 | — |
| smpstocktransaction | SMPStockTransaction | smp_stock_transactions | 4 | — |
| station | Station | stations | 5 | — |
| stationip | StationIp | station_ip | 1 | — |
| stationoperator | StationOperator | station_operators | 2 | — |
| stockframe | StockFrame | stock_frames | 0 | — |
| stockframetransaction | StockFrameTransaction | stock_frames_transactions | 0 | — |
| stockhistory | StockHistory | stock_histories | 2 | — |
| stockinventories | StockInventories | stock_inventories | 9 | — |
| stockinventorydynamicvariablecontent | StockInventoryDynamicVariableContent | stock_inventory_dynamic_variable_contents | 2 | — |
| stockinventorylocation | StockInventoryLocation | stock_inventory_locations | 3 | — |
| stockinventorytransaction | StockInventoryTransaction | stock_inventory_transactions | 9 | — |
| stockitemcategory | StockItemCategory | stock_item_categories | 1 | — |
| stockitemdynamicvariable | StockItemDynamicVariable | stock_item_dynamic_variables | 1 | — |
| subcon | Subcon | subcon | 2 | — |
| substorestockinventories | SubstoreStockInventories | substore_stock_inventories | 3 | — |
| substorestockinventorytransaction | SubstoreStockInventoryTransaction | substore_stock_inventory_transactions | 7 | — |
| supplier | Supplier | suppliers | 14 | — |
| suppliercategory | SupplierCategory | supplier_categories | 0 | — |
| systemactivitylog | SystemActivityLog | empty | 0 | — |
| systemdatainformation | SystemDataInformation | system_data_Informations | 0 | — |
| systemstatus | SystemStatus | system_statuses | 0 | — |
| targetschedulecategory | TargetScheduleCategory | target_schedule_categories | 0 | — |
| targetscheduledetail | TargetScheduleDetail | target_schedule_details | 1 | — |
| targetschedulelist | TargetScheduleList | target_schedule_lists | 2 | — |
| targetscheduleprocess | TargetScheduleProcess | target_schedule_processes | 3 | — |
| tarifcode | TarifCode | tarif_code | 0 | — |
| tax | Tax | empty | 2 | — |
| term | Term | terms | 2 | — |
| transaction | Transaction | transactions | 0 | — |
| travgallery | TravGallery | trav_galleries | 1 | — |
| treatment | Treatment | treatments | 0 | — |
| trip | Trip | trips | 5 | — |
| tripitem | TripItem | trip_items | 7 | — |
| unpackfinishgood | UnpackFinishGood | unpack_finish_goods | 2 | — |
| uom | Uom | uoms | 0 | — |
| uomconverter | UomConverter | uom_converters | 2 | — |
| user | User | users | 3 | staff_id |
| useridcard | UserIdCard | user_id_cards | 1 | — |
| userrole | UserRole | role_users | 1 | — |
| vehicle | Vehicle | vehicles | 1 | — |
| vehicletype | VehicleType | vehicle_types | 0 | — |
| vendoritemmapping | VendorItemMapping | vendor_item_mappings | 2 | — |
| wipinventory | WipInventory | wip_inventories | 3 | — |
| wipinventorytransaction | WipInventoryTransaction | wip_inventory_transactions | 3 | — |
| wipinventoryusage | WipInventoryUsage | wip_inventory_usages | 4 | — |
| wipinventoryusageitem | WipInventoryUsageItem | wip_inventory_usage_items | 7 | — |
| wipstorage | WipStorage | wip_storages | 1 | — |
| wipunfinishedgood | WipUnfinishedGood | wip_unfinished_goods | 4 | — |
| wipunfinishedgoodtransaction | WipUnfinishedGoodTransaction | wip_unfinished_good_transactions | 6 | — |
| workinprogressrecord | WorkInProgressRecord | work_in_progress_records | 4 | — |
| workorder | WorkOrder | work_orders | 30 | wo_number |
| workorderdetailreport | WorkOrderDetailReport | work_order_detail_reports | 0 | — |
| workorderfgitem | WorkOrderFgItem | work_order_fg_items | 5 | — |
| workorderforecast | WorkOrderForecast | work_order_forecasts | 2 | — |
| workorderitem | WorkOrderItem | work_order_items | 8 | — |
| workorderitemipo | WorkOrderItemIPO | work_order_item_ipos | 7 | — |
| workorderos | WorkOrderOS | work_order_operation_schedules | 2 | — |
| workorderprocessprogressrecord | WorkOrderProcessProgressRecord | workorder_process_progress_records | 5 | — |
| workorderprocesstraveller | WorkOrderProcessTraveller | workorder_process_travellers | 11 | — |
845
| from | method | type | fk | related | |
|---|---|---|---|---|---|
| accountpayabletracking | purchaseOrder | belongsTo | po_id | purchaseorder | |
| accountpayabletracking | goodsReceiptsNote | belongsTo | grn_id | goodsreceiptsnote | |
| accountpayabletracking | purchaseRequest | belongsTo | pr_id | purchaserequest | |
| accountpayabletracking | inventory | belongsTo | item_id | inventory | |
| accountpayabletracking | purchaseOrderItem | belongsTo | po_item_id | purchaseorderitem | |
| accountreceivabletracking | salesOrder | belongsTo | sales_order_id | salesorder | |
| accountreceivabletracking | invoiceItem | belongsTo | invoice_item_id | invoiceitem | |
| accountreceivabletracking | workOrder | belongsTo | work_order_id | workorder | |
| address | addressable | morphTo | addressable_id | — | |
| bom | bom_inventory | hasMany | — | bominventory | |
| bom | bom_price | hasMany | — | bomprice | |
| bom | default_bom_price | belongsTo | cost_price | bomresource | |
| bom | default_sell_price | belongsTo | sell_price | bomprice | |
| bom | bom_process | hasMany | — | bomprocess | |
| bom | bom_resource | hasMany | — | bomresource | |
| bom | systemStatus | belongsTo | status | systemstatus | |
| bom | inventory | hasMany | id | inventory | code_may_be_wrong |
| bom | bom_category | belongsTo | engineering_bom | bomcategory | |
| bom | bom_type | belongsTo | bom_type_id | bomtype | |
| bom | customer | belongsTo | customer_id | customer | |
| bom | uom | belongsTo | uom_id | uom | |
| bom | supplier | belongsTo | supplier_id | supplier | |
| bom | project | belongsTo | project_id | project | |
| bom | currency | belongsTo | currency_id | currency | |
| bom | finish_good_stock | hasOne | bom_id | finishgoodsstock | |
| bom | finish_good_transaction | hasMany | bom_id | finishgoodstockstransaction | |
| bom | dualnaturewithinventory | hasOne | part_number | inventory | |
| bom | salesOrderItem | hasMany | id | salesorderitem | code_may_be_wrong |
| bom | bombehaviour | belongsTo | bom_behaviour_id | bombehaviour | |
| bom | surfacetreatmentbehaviour | belongsTo | surface_treatment_behaviour_id | bombehaviour | |
| bom | bomchild | hasMany | main_bom_id | bomchild | |
| bom | bomchild_all | hasMany | main_bom_id | bomchild | |
| bom | childbom | hasOne | bom_id | bomchild | |
| bom | process_bom | hasMany | bom_id | bomprocess | |
| bom | bracket | belongsTo | bracket_code | bracketno | |
| bom | bomClassType | hasMany | bom_id | — | |
| bom | childs | hasMany | main_bom_id | bomchild | |
| bom | taxes | hasMany | taxable_id | tax | |
| bom | workOrders | hasMany | bom_id | workorder | |
| bomauditlog | bom | belongsTo | bom_id | bom | |
| bomcategory | bom | hasMany | id | bom | code_may_be_wrong |
| bomchild | bom | belongsTo | bom_id | bom | |
| bomchild | mainbom | belongsTo | main_bom_id | bom | |
| bomchild | children | hasMany | parent_bom_id | bomchild | |
| bomchild | parent | belongsTo | parent_bom_id | bomchild | |
| bominventory | bom | belongsTo | bom_id | bom | |
| bominventory | inventory | belongsTo | inventory_id | inventory | |
| bominventory | stockinventories | belongsTo | inventory_id | stockinventories | |
| bominventory | inventory_price | hasMany | inventory_id | inventoryprice | |
| bominventory | purchase_request | hasMany | inventory_id | purchaserequest | |
| bominventory | supplier | belongsTo | supplier_id | supplier | |
| bomoperationworkguide | bom_process | belongsTo | bom_process_id | bomprocess | |
| bomprice | bom | belongsTo | bom_id | bom | |
| bomprice | currency | belongsTo | currency_id | currency | |
| bomprice | customer | belongsTo | customer_id | customer | |
| bomprice | moq | belongsTo | price_condition_name | moq | |
| bomprocess | bom | belongsTo | bom_id | bom | |
| bomprocess | process | belongsTo | name | process | |
| bomprocess | bom_behaviour | belongsTo | bom_behaviour_id | bombehaviour | |
| bomprocess | processinput | hasOne | bom_process_id | bomprocessio | |
| bomprocess | processoutput | hasOne | bom_process_id | bomprocessio | |
| bomprocess | operationprocedure | hasMany | bom_process_id | bomprocessop | |
| bomprocess | workguide | hasMany | bom_process_id | bomoperationworkguide | |
| bomprocess | wo_process_traveller | hasMany | bom_process_id | workorderprocesstraveller | |
| bomprocessdynamicvariablecontent | process | belongsTo | process_id | process | |
| bomprocessdynamicvariablecontent | operationprocedure | belongsTo | bom_process_operation_procedure_id | bomprocessop | |
| bomprocessio | bomprocess | belongsTo | bom_process_id | bomprocess | |
| bomprocessio | transaction | belongsTo | transaction_id | transaction | |
| bomprocessio | bomprocessioitem | hasMany | bom_process_io_id | bomprocessioitem | |
| bomprocessioitem | bom | belongsTo | item_id | bom | |
| bomprocessioitem | inventory | belongsTo | item_id | inventory | |
| bomprocessop | bomprocess | belongsTo | bom_process_id | bomprocess | |
| bomprocessop | bombehaviour | belongsTo | bom_behaviour_id | bombehaviour | |
| bomprocessop | dynamicvariablecontent | belongsTo | id | bomprocessdynamicvariablecontent | |
| bomresource | currency | belongsTo | currency_id | currency | |
| bomresource | bom | belongsTo | bom_id | bom | |
| bomresource | uom | belongsTo | uom_id | uom | |
| bomresource | supplier | belongsTo | supplier_id | supplier | |
| bomresource | companyProfile | belongsTo | supplier_id | companyprofile | |
| bomresource | moq | belongsTo | moq_id | moq | |
| bomresource | systemStatus | belongsTo | status | systemstatus | |
| bomresource | resource | belongsTo | sourcing_type | resource | |
| bomresource | salesOrderItem | hasMany | bom_resource_id | salesorderitem | |
| bracketno | tarifCode | hasMany | bracket_no_id | tarifcode | |
| calendarcachehierarchical | parentView | belongsTo | parent_view_identifier | calendarcachehierarchical | |
| calendarcachehierarchical | childViews | hasMany | parent_view_identifier | calendarcachehierarchical | |
| calendardetailbycustomercache | customer | belongsTo | — | customer | |
| calendardetailbyfaicustomercache | customer | belongsTo | customer_id | customer | |
| calendardetailcachedependency | calendarDetailCache | belongsTo | cache_date | calendardetailcache | |
| calendardetaildivisioncustomercache | division | belongsTo | — | division | |
| calendardetaildivisioncustomercache | customer | belongsTo | — | customer | |
| calendardetaildivisionfaicache | division | belongsTo | — | division | |
| calendardetaildivisionprocesscache | division | belongsTo | — | division | |
| calendardetailprocesscache | process | belongsTo | — | process | |
| calendardetailprocesscache | divisions | belongsToMany | process_id | division | |
| calendardetailprocesscache | divisionProcesses | hasMany | process_id | divisionprocess | |
| calendarsetting | hierarchicalView | belongsTo | view_identifier | calendarcachehierarchical | |
| commercialinvoice | commercialInvoiceItem | hasMany | — | commercialinvoiceitem | |
| commercialinvoice | customer | belongsTo | customer_id | customer | |
| commercialinvoice | currency | belongsTo | currency_id | currency | |
| commercialinvoice | systemStatus | belongsTo | status | systemstatus | |
| commercialinvoiceimport | commercialInvoiceImportItem | hasMany | — | commercialinvoiceimportitem | |
| commercialinvoiceimport | customer | belongsTo | customer_id | customer | |
| commercialinvoiceimport | currency | belongsTo | currency_id | currency | |
| commercialinvoiceimport | systemStatus | belongsTo | status | systemstatus | |
| commercialinvoiceimportitem | commercialInvoiceImport | belongsTo | commercial_invoice_import_id | commercialinvoiceimport | |
| commercialinvoiceitem | commercialInvoice | belongsTo | commercial_invoice_id | commercialinvoice | |
| commercialinvoicelocal | items | hasMany | commercial_invoice_local_id | commercialinvoicelocalitem | |
| commercialinvoicelocal | currency | belongsTo | currency_id | currency | |
| commercialinvoicelocal | systemStatus | belongsTo | status | systemstatus | |
| commercialinvoicelocalitem | commercialInvoiceLocal | belongsTo | commercial_invoice_local_id | commercialinvoicelocal | |
| companyprofile | company_currency | belongsTo | currency | currency | |
| companyprofile | country | belongsTo | — | — | |
| consolidatedeinvoicebatch | items | hasMany | batch_id | consolidatedeinvoicebatchitem | |
| consolidatedeinvoicebatch | invoices | belongsToMany | batch_id | invoice | |
| consolidatedeinvoicebatch | referencesBatch | belongsTo | references_batch_id | consolidatedeinvoicebatch | |
| consolidatedeinvoicebatch | referencingBatches | hasMany | references_batch_id | consolidatedeinvoicebatch | |
| consolidatedeinvoicebatch | creator | belongsTo | created_by | user | |
| consolidatedeinvoicebatchitem | batch | belongsTo | batch_id | consolidatedeinvoicebatch | |
| consolidatedeinvoicebatchitem | invoice | belongsTo | invoice_id | invoice | |
| consolidatedeinvoicebatchitem | creditDebitNote | belongsTo | invoice_id | creditdebitnote | |
| creditdebitnote | customer | belongsTo | customer_id | customer | |
| creditdebitnote | invoice | belongsTo | invoice_id | invoice | |
| creditdebitnote | cn_item | hasMany | creditnote_id | creditdebitnoteitem | |
| creditdebitnote | systemStatus | belongsTo | status | systemstatus | |
| creditdebitnote | grnReference | belongsTo | grn_reference | goodsreceiptsnote | |
| creditdebitnotecancellationrequest | creditDebitNote | belongsTo | credit_debit_note_id | creditdebitnote | |
| creditdebitnotecancellationrequest | requester | belongsTo | requested_by | user | |
| creditdebitnotecancellationrequest | approver | belongsTo | approved_by | user | |
| creditdebitnotecancellationrequest | reversalNote | belongsTo | reversal_note_id | creditdebitnote | |
| creditdebitnoteitem | project | belongsTo | project_id | project | |
| creditdebitnoteitem | uom | belongsTo | uom_id | uom | |
| creditdebitnoteitem | credit_note | belongsTo | creditnote_id | creditdebitnote | |
| currency | inventory | belongsToMany | — | inventory | |
| currency | inventory_price | hasOne | id | inventoryprice | |
| customer | systemStatus | belongsTo | status | systemstatus | |
| customer | term | belongsTo | default_term | term | |
| customer | currency | belongsTo | default_currency | currency | |
| customer | tax | belongsTo | default_tax | tax | |
| customer | invoice | hasMany | customer_id | invoice | |
| customer | subcon | hasMany | customer_id | subcon | |
| customer | addresses | hasMany | addressable_id | address | |
| custominvoiceitem | invoice | belongsTo | invoice_id | invoice | |
| custominvoiceitem | uoms | belongsTo | uom_id | uom | |
| custominvoiceitem | taxes | hasMany | taxable_id | tax | |
| delayedproductionschedule | bom | belongsTo | bom_id | bom | |
| delayedproductionschedule | work_order | belongsTo | wo_id | workorder | |
| delayedproductionschedule | processTraveller | belongsTo | workorder_process_traveller_id | workorderprocesstraveller | |
| delayedproductionschedule | process | belongsTo | process_id | process | |
| delayedproductionschedule | location | belongsTo | location_id | location | |
| delayedshipmentschedule | bom | belongsTo | bom_id | bom | |
| delayedshipmentschedule | work_order | belongsTo | wo_id | workorder | |
| delayedshipmentschedule | processTraveller | belongsTo | workorder_process_traveller_id | workorderprocesstraveller | |
| delayedshipmentschedule | process | belongsTo | process_id | process | |
| delayedshipmentschedule | location | belongsTo | location_id | location | |
| deliveryevidence | invoice | belongsTo | invoice_id | invoice | |
| deliveryscheduledetail | scheduleCategory | belongsTo | delivery_schedule_category_id | deliveryschedulecategory | |
| deliveryscheduledetail | bom | belongsTo | bom_id | bom | |
| deliveryscheduledetail | user | belongsTo | prepared_by | — | |
| deliveryschedulelist | user | belongsTo | prepared_by | — | |
| deliveryschedulelist | scheduleCategory | belongsTo | delivery_schedule_category_id | deliveryschedulecategory | |
| division | parent | belongsTo | parent_id | division | |
| division | children | hasMany | parent_id | division | |
| division | processes | belongsToMany | — | process | |
| division | divisionProcesses | hasMany | — | divisionprocess | |
| division | calendarSettings | hasOne | — | calendarsetting | |
| divisionprocess | division | belongsTo | — | division | |
| divisionprocess | process | belongsTo | — | process | |
| einvoiceauditlogentry | actor | belongsTo | actor_user_id | user | |
| senderName | belongsTo | user_id | user | ||
| receiverName | belongsTo | email_id | user | ||
| employee | employeeidcard | belongsTo | user_id | useridcard | |
| employee | department | hasMany | user_id | userrole | |
| employee | user | hasOne | staff_id | user | |
| employee | station | hasMany | leader_id | station | |
| employee | station_operator | hasMany | employee_id | stationoperator | |
| employee | station_operator_pic | hasMany | employee_id | stationoperator | |
| exchangerate | currencyFrom | belongsTo | from_currency_id | currency | |
| exchangerate | currencyTo | belongsTo | to_currency_id | currency | |
| faigallery | workorder | belongsTo | wo_id | workorder | |
| fgactualimportbatch | uploader | belongsTo | uploaded_by | user | |
| fgactualimportbatch | reclaimEntries | hasMany | import_batch_id | fgreclaimentry | |
| fgreclaimentry | batch | belongsTo | import_batch_id | fgactualimportbatch | |
| fgreclaimentry | workOrder | belongsTo | source_wo_id | workorder | |
| fgreclaimentry | bom | belongsTo | bom_id | bom | |
| fgreclaimentry | markedBy | belongsTo | marked_by | user | |
| finishgoodsstock | bom | belongsTo | bom_id | bom | |
| finishgoodsstock | transaction | hasMany | bom_id | finishgoodstockstransaction | |
| finishgoodsstock | location_details | belongsTo | location_id | location | |
| finishgoodsstock | finishgoodstocklocation | hasMany | finish_good_stock_id | finishgoodstocklocation | |
| finishgoodsstock | relatedInvoices | hasManyThrough | bom_id | invoice | |
| finishgoodsstock | stockOutTransactionsWithInvoices | hasMany | bom_id | finishgoodstockstransaction | |
| finishgoodsstock | issueWorkOrderForecasts | hasManyThrough | bom_id | workorderforecast | |
| finishgoodsstock | bindWorkOrderForecasts | hasManyThrough | bom_id | workorderforecast | |
| finishgoodstocklocation | bom | belongsTo | bom_id | bom | |
| finishgoodstocklocation | location | belongsTo | location_id | location | |
| finishgoodstocklocation | finishgoodstock | belongsTo | finish_good_stock_id | finishgoodsstock | |
| finishgoodstocklocation | transactions | hasMany | finish_good_stock_location_id | finishgoodstockstransaction | |
| finishgoodstocklocation | stockOutTransactionsWithInvoices | hasMany | finish_good_stock_location_id | finishgoodstockstransaction | |
| finishgoodstockstransaction | station | belongsTo | station_id | station | |
| finishgoodstockstransaction | workOrder | belongsTo | wo_number | workorder | |
| finishgoodstockstransaction | jobOrder | belongsTo | jo_number | joborder | |
| finishgoodstockstransaction | trans_by | belongsTo | trasaction_by | — | |
| finishgoodstockstransaction | transaction | belongsTo | transaction_id | transaction | |
| finishgoodstockstransaction | bom | belongsTo | bom_id | bom | |
| finishgoodstockstransaction | finishGoodsStock | belongsTo | bom_id | finishgoodsstock | |
| finishgoodstockstransaction | invoices | hasManyThrough | id | invoice | |
| finishgoodstockstransaction | finishGoodStockLocation | belongsTo | finish_good_stock_location_id | finishgoodstocklocation | |
| finishgoodstockstransaction | packingList | belongsTo | packing_list_id | packinglist | |
| goodrecieptsnoteitem | grn | belongsTo | grn_id | goodsreceiptsnote | |
| goodrecieptsnoteitem | po_item | belongsTo | po_item_id | purchaseorderitem | |
| goodrecieptsnoteitem | inventory | belongsTo | item_id | inventory | |
| goodrecieptsnoteitem | bom | belongsTo | item_id | bom | |
| goodrecieptsnoteitem | work_order | belongsTo | wo_number | workorder | |
| goodrecieptsnoteitem | sku | hasMany | grn_item_id | sku | |
| goodsreceiptsnote | supplier | belongsTo | supplier_id | supplier | |
| goodsreceiptsnote | po_reference | belongsTo | po_number | purchaseorder | |
| goodsreceiptsnote | grn_item | hasMany | grn_id | goodrecieptsnoteitem | |
| goodsreceiptsnote | systemStatus | belongsTo | status | systemstatus | |
| goodsreceiptsnote | substore | belongsTo | substore_id | locationcategory | |
| goodsreceiptsnote | receivedEinvoices | hasMany | grn_id | receivedeinvoice | |
| goodsreceiptsnote | receivedEinvoice | hasOne | grn_id | receivedeinvoice | |
| gpb | invoice | hasMany | gpb_id | invoice | |
| gpb | lmwdettails | belongsTo | lmw_details_id | lmwdetail | |
| grncancellationrequest | grn | belongsTo | grn_id | goodsreceiptsnote | |
| grncancellationrequest | requester | belongsTo | requested_by | user | |
| grncancellationrequest | approver | belongsTo | approved_by | user | |
| grncancellationrequest | creditNote | belongsTo | credit_note_id | creditdebitnote | |
| inventory | currency | belongsTo | — | currency | |
| inventory | supplier | belongsTo | supplier_id | supplier | |
| inventory | uom | belongsTo | uom_id | uom | |
| inventory | inventory_price | hasMany | inventory_id | inventoryprice | |
| inventory | inventory_price_moq | hasMany | — | moq | |
| inventory | bom_inventory | hasMany | — | moq | |
| inventory | stock_inv_transaction | hasMany | inventory_id | stockinventorytransaction | |
| inventory | substore_stock_inv_transaction | hasMany | inventory_id | substorestockinventorytransaction | |
| inventory | stock_inv | hasOne | inventory_id | stockinventories | |
| inventory | dualNatureWithBom | hasOne | part_number | bom | |
| inventory | systemStatus | belongsTo | status | systemstatus | |
| inventory | inventoryCategory | belongsTo | category | inventorycategory | |
| inventory | purchaseOrderItem | hasMany | item_id | purchaseorderitem | |
| inventory | bom | hasMany | inventory_id | bominventory | |
| inventory | defaultsupplier | hasOne | id | supplier | |
| inventory | defaultprice | belongsTo | default_inventory_price_id | inventoryprice | |
| inventory | workOrderItem | hasMany | inventory_id | workorderitem | |
| inventory | bracket | belongsTo | bracket_no_id | bracketno | |
| inventory | tarif | belongsTo | tarif_code_id | tarifcode | |
| inventory | wipInventory | hasOne | inventory_id | wipinventory | |
| inventory | taxes | hasMany | taxable_id | tax | |
| inventorycategory | parent | belongsTo | parent | inventorycategory | |
| inventorylocation | inventory | belongsTo | inventory_id | inventory | |
| inventoryprice | supplier | belongsTo | supplier_id | supplier | |
| inventoryprice | inventory | belongsTo | inventory_id | inventory | |
| inventoryprice | stock_inventory | belongsTo | inventory_id | stockinventories | |
| inventoryprice | moq | belongsTo | price_condition_name | moq | |
| inventoryprice | purchaseRequest | belongsTo | inventory_id | purchaserequest | |
| inventoryprice | currency | belongsTo | currency_id | currency | |
| invoice | invoice_items | hasMany | invoice_id | invoiceitem | |
| invoice | deleted_invoice_items | hasMany | invoice_id | invoiceitem | |
| invoice | exchange_rates | belongsTo | exchange_rate | exchangerate | |
| invoice | sales_order | hasOne | id | salesorder | |
| invoice | job_order | belongsTo | jo_number | joborder | |
| invoice | systemstatus | belongsTo | status | systemstatus | |
| invoice | customer | belongsTo | customer_id | customer | |
| invoice | k2 | belongsTo | k2_id | k2 | |
| invoice | gpb | belongsTo | gpb_id | gpb | |
| invoice | customInvoiceItem | hasMany | invoice_id | custominvoiceitem | |
| invoice | deletedCustomInvoiceItem | hasMany | invoice_id | custominvoiceitem | |
| invoice | approver | belongsTo | approved_by | — | |
| invoice | doEvidence | hasMany | invoice_id | deliveryevidence | |
| invoice | invoiceItems | hasMany | invoice_id | invoiceitem | |
| invoice | invoiceItemsWithTrashed | hasMany | invoice_id | invoiceitem | |
| invoice | customInvoiceItemWithTrashed | hasMany | invoice_id | custominvoiceitem | |
| invoice | supplier | belongsTo | supplier_id | supplier | |
| invoice | subcon | belongsTo | subcon_id | subcon | |
| invoice | credit_debit_notes | hasMany | invoice_id | creditdebitnote | |
| invoice | cancellationRequests | hasMany | — | invoicecancellationrequest | |
| invoice | latestCancellationRequest | hasOne | — | invoicecancellationrequest | |
| invoiceablequantity | salesOrderItem | belongsTo | soi_id | salesorderitem | |
| invoicecancellationrequest | invoice | belongsTo | — | invoice | |
| invoicecancellationrequest | requester | belongsTo | requested_by | user | |
| invoicecancellationrequest | approver | belongsTo | approved_by | user | |
| invoicecancellationrequest | verifier | belongsTo | verified_by | user | |
| invoicecancellationrequest | locker | belongsTo | locked_by | user | |
| invoicecancellationrequest | creditNote | belongsTo | credit_note_id | creditdebitnote | |
| invoiceitem | invoice | belongsTo | invoice_id | invoice | |
| invoiceitem | bom | belongsTo | bom_id | bom | |
| invoiceitem | sales_order | belongsTo | customer_po_number | salesorder | |
| invoiceitem | sales_order_items | belongsTo | so_item_id | salesorderitem | |
| invoiceitem | project | belongsTo | project | project | |
| itemtransfer | current_process_traveller | belongsTo | current_process_traveller_id | workorderprocesstraveller | |
| itemtransfer | next_process_traveller | belongsTo | next_process_traveller_id | workorderprocesstraveller | |
| itemtransfer | location | belongsTo | location_id | location | |
| itemtransfer | work_order | belongsTo | wo_id | workorder | |
| itemtransfer | current_process | belongsTo | current_process_id | process | |
| itemtransfer | next_process | belongsTo | next_process_id | process | |
| itemtransfer | galleries | hasMany | item_transfer_id | itemtransfergallery | |
| itemtransfer | trip | belongsTo | trip_id | trip | |
| itemtransfergallery | itemTransfer | belongsTo | item_transfer_id | itemtransfer | |
| itemtransfergallery | trip | belongsTo | trip_id | trip | |
| itemtransfergallery | workOrder | belongsTo | wo_id | workorder | |
| joborder | bom | belongsTo | bom_id | bom | |
| joborder | customer | belongsTo | customer_id | customer | |
| joborder | sales_order | hasOne | so_number | salesorder | |
| joborder | job_order_items | hasMany | job_order_id | joborderitem | |
| joborder | preparedBy | belongsTo | prepared_by | — | |
| joborder | systemStatus | belongsTo | status | systemstatus | |
| joborder | work_order | hasMany | jo_id | workorder | |
| joborderitem | job_order | belongsTo | job_order_id | joborder | |
| joborderitem | bom | belongsTo | bom_id | bom | |
| joborderitem | work_orders | belongsTo | job_order_id | workorder | |
| k1 | purchase_order | hasMany | k1_id | purchaseorder | |
| k1 | supplier | belongsTo | supplier_id | supplier | |
| k2 | invoice | hasMany | k2_id | invoice | |
| k2 | customer | belongsTo | customer_id | customer | |
| k9 | invoice | hasMany | k9_id | invoice | |
| kuk | invoice | hasMany | kuk_id | invoice | |
| kuk | lmwdettails | belongsTo | lmw_details_id | lmwdetail | |
| lmw | companies | belongsTo | company | customer | |
| lmw | lmwdetails | hasMany | id | lmwdetail | code_may_be_wrong |
| lmwdetail | lmw | belongsTo | lmw_id | lmw | |
| location | sub_locations | hasMany | sub_location | location | |
| location | locations | hasOne | id | location | |
| location | stations | hasMany | location_id | station | |
| location | location_category | belongsTo | location_category_id | locationcategory | |
| location | networks | hasMany | location_id | locationnetwork | |
| locationcategory | location | hasMany | location_category_id | location | |
| locationnetwork | location | belongsTo | location_id | location | |
| logistic | logisticItem | hasMany | logistic_id | logisticitem | |
| logistic | vehicle | belongsTo | vehicle_id | vehicle | |
| logistic | driver | belongsTo | employee_id | employee | |
| logistic | supplier | belongsTo | supplier_id | supplier | |
| logisticitem | packingList | belongsTo | packing_list_id | packinglist | |
| logisticsubmissionaccount | lsa_items | hasMany | lsa_id | logisticsubmissionaccountitem | |
| logisticsubmissionaccountitem | lsa | belongsTo | lsa_id | logisticsubmissionaccount | |
| machine | systemstatus | belongsTo | status | systemstatus | |
| machine | statuscolour | belongsTo | color | systemstatus | |
| machine | workorder | belongsTo | wo_id | workorder | |
| machine | machinelocation | belongsTo | location | location | |
| machine | incharge_person | belongsTo | employee_id | employee | |
| machine | machine_location | belongsTo | location | location | |
| machinemaintenanceschedule | machine | belongsTo | machine_id | machine | |
| machinemaintenanceschedule | maintenanceFrequency | belongsTo | maintenance_frequency_id | maintenancefrequency | |
| machinemaintenanceschedule | machineMaintenanceScheduleDetail | hasMany | machine_maintenance_schedule_id | machinemaintenancescheduledetail | |
| machinemaintenancescheduledetail | machineMaintenanceSchedule | belongsTo | machine_maintenance_schedule_id | machinemaintenanceschedule | |
| machinemaintenancescheduledetail | maintenanceChecklist | belongsTo | maintenance_checklist_id | maintenancechecklist | |
| machiningscheduledetail | bom | belongsTo | bom_id | bom | |
| machiningschedulelist | user | belongsTo | prepared_by | — | |
| machiningschedulelist | scheduleCategory | belongsTo | machining_schedule_category_id | machiningschedulecategory | |
| machiningscheduleprocess | scheduleDetail | belongsTo | machining_schedule_detail_id | machiningscheduledetail | |
| machiningscheduleprocess | process | belongsTo | process_id | process | |
| machiningscheduleprocess | user | belongsTo | prepared_by | — | |
| maintenancechecklist | maintenanceFrequency | belongsTo | maintenance_frequency_id | maintenancefrequency | |
| maintenancefrequency | maintenanceChecklists | hasMany | maintenance_frequency_id | maintenancechecklist | |
| materialinvoicevoucher | inventory | hasOne | id | inventory | |
| materialinvoicevoucher | bom | hasOne | id | bom | |
| materialinvoicevoucher | workorder | hasMany | id | workorder | code_may_be_wrong |
| materialinvoicevoucher | workorderitem | hasOne | id | workorderitem | |
| materialinvoicevoucher | workorderfgitem | hasOne | id | workorderfgitem | |
| materialprice | uom | belongsTo | uom_id | uom | |
| moq | quotationBomPrice | hasMany | name | quotationbomprice | |
| mrpactivity | plan | belongsTo | mrp_plan_id | mrpplan | |
| mrpactivity | analysisRun | belongsTo | analysis_run_id | mrpanalysisrun | |
| mrpactivity | inventory | belongsTo | inventory_id | inventory | |
| mrpactivity | performedByUser | belongsTo | performed_by | — | |
| mrpanalysiscontrol | triggeredByUser | belongsTo | triggered_by | — | |
| mrpanalysiscontrol | profile | belongsTo | profile_id | mrpprofile | |
| mrpanalysisprojection | analysisRun | belongsTo | analysis_run_id | mrpanalysisrun | |
| mrpanalysisprojection | inventory | belongsTo | inventory_id | inventory | |
| mrpanalysisrun | triggeredBy | belongsTo | triggered_by | — | |
| mrpanalysisrun | socrds | hasMany | analysis_run_id | mrpanalysissocrd | |
| mrpanalysisrun | projections | hasMany | analysis_run_id | mrpanalysisprojection | |
| mrpanalysisrun | plans | hasMany | analysis_run_id | mrpplan | |
| mrpanalysissocrd | analysisRun | belongsTo | analysis_run_id | mrpanalysisrun | |
| mrpanalysissocrd | socrd | belongsTo | socrd_id | salesordercustomerrequestdate | |
| mrpanalysissocrd | salesOrder | belongsTo | sales_order_id | salesorder | |
| mrpanalysissocrd | workOrder | belongsTo | work_order_id | workorder | |
| mrpanalysissocrd | bom | belongsTo | bom_id | bom | |
| mrpanalysissocrd | customer | belongsTo | customer_id | customer | |
| mrpforecastline | upload | belongsTo | upload_id | mrpforecastupload | |
| mrpforecastline | values | hasMany | forecast_line_id | mrpforecastlinevalue | |
| mrpforecastline | bom | belongsTo | bom_id | bom | |
| mrpforecastline | customer | belongsTo | customer_id | customer | |
| mrpforecastlinevalue | line | belongsTo | forecast_line_id | mrpforecastline | |
| mrpforecastupload | lines | hasMany | upload_id | mrpforecastline | |
| mrpforecastupload | uploadedByUser | belongsTo | uploaded_by | — | |
| mrpplan | items | hasMany | mrp_plan_id | mrpplanitem | |
| mrpplan | approvals | hasMany | mrp_plan_id | mrpplanapproval | |
| mrpplan | activities | hasMany | mrp_plan_id | mrpactivity | |
| mrpplan | parentPlan | belongsTo | parent_plan_id | mrpplan | |
| mrpplan | revisions | hasMany | parent_plan_id | mrpplan | |
| mrpplan | analysisRun | belongsTo | analysis_run_id | mrpanalysisrun | |
| mrpplan | createdByUser | belongsTo | created_by | — | |
| mrpplan | submittedByUser | belongsTo | submitted_by | — | |
| mrpplan | approvedByUser | belongsTo | approved_by | — | |
| mrpplan | rejectedByUser | belongsTo | rejected_by | — | |
| mrpplan | currency | belongsTo | currency_id | currency | |
| mrpplanapproval | plan | belongsTo | mrp_plan_id | mrpplan | |
| mrpplanapproval | performedByUser | belongsTo | performed_by | — | |
| mrpplanitem | plan | belongsTo | mrp_plan_id | mrpplan | |
| mrpplanitem | bom | belongsTo | bom_id | bom | |
| mrpplanitem | workOrder | belongsTo | work_order_id | workorder | |
| mrpplanitem | socrd | belongsTo | socrd_id | salesordercustomerrequestdate | |
| mrpplanitem | inventory | belongsTo | inventory_id | inventory | |
| mrpplanitem | suggestedSupplier | belongsTo | suggested_supplier_id | supplier | |
| mrpplanitem | selectedSupplier | belongsTo | selected_supplier_id | supplier | |
| mrpplanitem | inventoryPrice | belongsTo | inventory_price_id | inventoryprice | |
| mrpplanitem | currency | belongsTo | currency_id | currency | |
| mrpplanitem | purchaseRequest | belongsTo | pr_id | purchaserequest | |
| mrpplanitem | uom | belongsTo | uom_id | uom | |
| mrpprofile | categories | belongsToMany | mrp_profile_id | inventorycategory | |
| mrpprofile | createdByUser | belongsTo | created_by | — | |
| notification | purchase_report | belongsTo | purchase_report_id | purchasereport | |
| packinglist | packingListItem | hasMany | packing_list_id | packinglistitem | |
| packinglist | systemStatus | belongsTo | status | systemstatus | |
| packinglist | invoice | belongsTo | invoice_id | invoice | |
| packinglist | employee | belongsTo | prepared_by | employee | |
| packinglistitem | workorder | belongsTo | wo_id | workorder | |
| packinglistitem | bom | belongsTo | item_id | bom | |
| packinglistitem | inventory | belongsTo | item_id | inventory | |
| packinglistitem | packinglist | belongsTo | packing_list_id | packinglist | |
| packinglistitem | unpackFG | belongsTo | wo_id | unpackfinishgood | |
| pdo | customer | belongsTo | customer_id | customer | |
| pdo | systemStatus | belongsTo | status | systemstatus | |
| pdo | pdo_item | hasMany | pdo_id | pdoitem | |
| pdoitem | pdo | belongsTo | pdo_id | pdo | |
| pdoitem | projectname | belongsTo | project | project | |
| pdoitem | uom | belongsTo | uom_id | uom | |
| pdosupplier | supplier | belongsTo | supplier_id | supplier | |
| pdosupplier | systemStatus | belongsTo | status | systemstatus | |
| pdosupplier | pdo_supplier_item | hasMany | pdo_supplier_id | pdosupplieritem | |
| pdosupplieritem | pdo_supplier | belongsTo | pdo_supplier_id | pdosupplier | |
| pdosupplieritem | projectname | belongsTo | project | project | |
| pdosupplieritem | uom | belongsTo | uom_id | uom | |
| plantscheduledetail | location | belongsTo | location_id | location | |
| plantscheduledetail | workOrder | belongsTo | wo_id | workorder | |
| plantschedulelist | user | belongsTo | prepared_by | — | |
| plantschedulelist | location | belongsTo | location_id | location | |
| plantschedulelist | scheduleCategory | belongsTo | plant_schedule_category_id | plantschedulecategory | |
| popricerevision | salesOrder | belongsTo | sales_order_id | salesorder | |
| popricerevision | items | hasMany | po_price_revision_id | popricerevisionitem | |
| popricerevision | creator | belongsTo | created_by | user | |
| popricerevisionitem | revision | belongsTo | po_price_revision_id | popricerevision | |
| popricerevisionitem | salesOrderItem | belongsTo | sales_order_item_id | salesorderitem | |
| popricerevisionitem | bom | belongsTo | bom_id | bom | |
| popricerevisionitem | newBom | belongsTo | new_bom_id | bom | |
| porevisionauditlog | revision | belongsTo | po_price_revision_id | popricerevision | |
| porevisionauditlog | salesOrder | belongsTo | sales_order_id | salesorder | |
| powder | supplier | belongsTo | supplier_id | supplier | |
| process | divisions | belongsToMany | — | division | |
| process | department | belongsTo | department_id | role | |
| process | station | hasMany | process_id | station | |
| process | bom_process | hasMany | name | bomprocess | |
| process | wo_process_traveller_uninitialize | hasMany | process_id | workorderprocesstraveller | |
| process | wo_process_traveller_onprogress | hasMany | process_id | workorderprocesstraveller | |
| process | wo_process_traveller_finish | hasMany | process_id | workorderprocesstraveller | |
| process | process_child | hasMany | master_process_id | process | |
| process | master_process | belongsTo | id | process | |
| process | dynamicvariable | hasMany | process_id | processdynamicvariable | |
| process | divisionProcesses | hasMany | — | divisionprocess | |
| processdynamicvariable | process | belongsTo | process_id | process | |
| processgallery | workorder | hasOne | id | workorder | |
| processgallery | process | belongsTo | process_id | process | |
| productcost | bom | belongsTo | part_number_id | bom | |
| productionreceivaltransaction | trans_by | belongsTo | transaction_by | — | |
| productionreceivaltransaction | work_order_item | belongsTo | wo_item_id | workorderitem | |
| productionreceivaltransaction | user | belongsTo | received_by | — | |
| productpertime | bom | belongsTo | part_number_id | bom | |
| producttime | bom | belongsTo | part_number_id | bom | |
| project | pdo_item | hasMany | project | pdoitem | |
| purchaseorder | supplier | belongsTo | supplier_id | supplier | |
| purchaseorder | purchase_order_items | hasMany | po_id | purchaseorderitem | |
| purchaseorder | k1 | belongsTo | k1_id | k1 | |
| purchaseorder | good_reciepts_note | hasMany | po_number | goodsreceiptsnote | |
| purchaseorder | systemStatus | belongsTo | status | systemstatus | |
| purchaseorder | approver | belongsTo | approved_by | — | |
| purchaseorder | delivery_schedules | hasMany | purchase_order_id | purchaseorderitemdeliveryschedule | |
| purchaseorder | receivedEinvoices | hasMany | po_id | receivedeinvoice | |
| purchaseorderitem | bom | belongsTo | item_id | bom | |
| purchaseorderitem | inventory | belongsTo | item_id | inventory | |
| purchaseorderitem | inventory_category | belongsTo | item_category | inventorycategory | |
| purchaseorderitem | uom | belongsTo | uom_id | uom | |
| purchaseorderitem | Job_order | belongsTo | jo_number | joborder | |
| purchaseorderitem | purchase_order | belongsTo | po_id | purchaseorder | |
| purchaseorderitem | purchase_request | belongsTo | pr_id | purchaserequest | |
| purchaseorderitem | purchase_request_revised | belongsTo | revised_pr_id | purchaserequest | |
| purchaseorderitem | grn_items | hasMany | po_item_id | goodrecieptsnoteitem | |
| purchaseorderitem | stock_inventory | belongsTo | item_id | stockinventories | |
| purchaseorderitem | finish_good_stock | belongsTo | item_id | finishgoodsstock | |
| purchaseorderitem | delivery_schedules | hasMany | purchase_order_item_id | purchaseorderitemdeliveryschedule | |
| purchaseorderitemdeliveryschedule | purchase_order_item | belongsTo | purchase_order_item_id | purchaseorderitem | |
| purchaseorderitemdeliveryschedule | purchase_order | belongsTo | purchase_order_id | purchaseorder | |
| purchaseorderitemdeliveryschedule | supplier | belongsTo | supplier_id | supplier | |
| purchaseorderitemdeliveryschedule | location | belongsTo | location_id | location | |
| purchaseorderitemdeliveryschedule | grn | belongsTo | grn_id | — | |
| purchaseorderitemdeliveryschedule | created_by_user | belongsTo | created_by | — | |
| purchaseorderitemdeliveryschedule | histories | hasMany | delivery_schedule_id | purchaseorderitemdeliveryschedulehistory | |
| purchaseorderitemdeliveryschedulehistory | deliverySchedule | belongsTo | delivery_schedule_id | purchaseorderitemdeliveryschedule | |
| purchasepricemonitoritem | run | belongsTo | run_id | purchasepricemonitorrun | |
| purchasepricemonitoritem | inventory | belongsTo | inventory_id | inventory | |
| purchasepricemonitoritem | category | belongsTo | category_id | inventorycategory | |
| purchasepricemonitoritem | uom | belongsTo | uom_id | uom | |
| purchasepricemonitoritem | supplier | belongsTo | latest_supplier_id | supplier | |
| purchasepricemonitoritem | currency | belongsTo | latest_currency_id | currency | |
| purchasepricemonitorrun | items | hasMany | run_id | purchasepricemonitoritem | |
| purchasepricemonitorrun | triggeredByUser | belongsTo | triggered_by | user | |
| purchasereport | notification | hasMany | id | notification | code_may_be_wrong |
| purchaserequest | moq_price_inventory | belongsTo | price_condition | inventoryprice | |
| purchaserequest | moq_price_bom | belongsTo | price_condition | bomresource | |
| purchaserequest | customer | belongsTo | customer_id | customer | |
| purchaserequest | supplier | belongsTo | supplier_id | supplier | |
| purchaserequest | so_detail | hasOne | so_number | salesorder | |
| purchaserequest | jo_detail | hasOne | jo_number | joborder | |
| purchaserequest | purchase_order_items | belongsTo | id | purchaseorderitem | |
| purchaserequest | bom | belongsTo | item_id | bom | |
| purchaserequest | purchaserequesttype | belongsTo | pr_type | purchaserequesttype | |
| purchaserequest | inventory | belongsTo | item_id | inventory | |
| purchaserequest | inventory_price | belongsTo | item_id | inventoryprice | |
| purchaserequest | many_inventory_price | hasMany | inventory_id | inventoryprice | |
| purchaserequest | currency | belongsTo | currency_id | currency | |
| purchaserequest | exchangeRate | hasOne | from_currency_id | exchangerate | |
| purchaserequest | approvalStatus | belongsTo | approval_status | systemstatus | |
| purchaserequest | systemStatus | belongsTo | status | systemstatus | |
| purchaserequest | workorder | belongsTo | wo_number | workorder | |
| purchaserequest | mrpPlan | belongsTo | mrp_number | mrpplan | |
| qcgallery | workorder | belongsTo | wo_id | workorder | |
| quotation | customer | belongsTo | customer_id | customer | |
| quotation | currency | belongsTo | currency_id | currency | |
| quotation | quotation_item | hasMany | — | quotationitem | |
| quotation | systemStatus | belongsTo | status | systemstatus | |
| quotationbom | bom_inventory | hasMany | — | quotationbominventory | |
| quotationbom | bom_price | hasMany | — | quotationbomprice | |
| quotationbom | bom_process | hasMany | — | quotationbomprocess | |
| quotationbom | systemStatus | belongsTo | status | systemstatus | |
| quotationbom | bom_category | belongsTo | engineering_bom | bomcategory | |
| quotationbom | bom_type | belongsTo | bom_type_id | bomtype | |
| quotationbom | customer | belongsTo | customer_id | customer | |
| quotationbom | uom | belongsTo | uom_id | uom | |
| quotationbom | project | belongsTo | project_id | project | |
| quotationbom | currency | belongsTo | currency_id | currency | |
| quotationbom | bom_childs | hasMany | — | quotationbomchild | |
| quotationbom | bom_quotation_child | hasMany | — | quotationbomchild | |
| quotationbomchild | bom | belongsTo | quotation_bom_id | quotationbom | |
| quotationbominventory | inventory | belongsTo | quotation_inventory_id | quotationinventory | |
| quotationbominventory | bom | belongsTo | quotation_bom_id | quotationbom | |
| quotationbomprice | bom | belongsTo | quotation_bom_id | quotationbom | |
| quotationbomprice | customer | belongsTo | customer_id | customer | |
| quotationbomprice | currency | belongsTo | currency_id | currency | |
| quotationbomprice | moq | belongsTo | price_condition_name | moq | |
| quotationbomprocess | process | belongsTo | process_id | process | |
| quotationbomprocess | uom | belongsTo | variable_uom | uom | |
| quotationbomprocess | supplier | belongsTo | supplier_id | quotationsupplier | |
| quotationbomprocess | currency | belongsTo | currency_id | currency | |
| quotationbomprocess | quotation_bom | belongsTo | quotation_bom_id | quotationbom | |
| quotationinventory | systemstatus | belongsTo | status | systemstatus | |
| quotationinventory | uom | belongsTo | uom_id | uom | |
| quotationinventory | inventorycategory | belongsTo | category | quotationinventorycategory | |
| quotationinventory | dynamicVariableContent | belongsTo | id | quotationinventorydynamicvariablecontent | |
| quotationinventory | inventory_price | hasMany | quotation_inventory_id | quotationinventoryprice | |
| quotationinventory | default_inventory_price | belongsTo | default_inventory_price_id | quotationinventoryprice | |
| quotationinventory | quotation_bom_inventory | hasMany | quotation_inventory_id | quotationbominventory | |
| quotationinventorycategory | inventoryDynamicVariable | hasMany | quotation_inventory_category_id | quotationinventorydynamicvariable | |
| quotationinventorydynamicvariable | inventoryCategory | belongsTo | quotation_inventory_category_id | quotationinventorycategory | |
| quotationinventorydynamicvariablecontent | inventory | belongsTo | quotation_inventory_id | quotationinventory | |
| quotationinventorydynamicvariablecontent | inventoryCategory | belongsTo | quotation_inventory_category_id | quotationinventorycategory | |
| quotationinventoryprice | supplier | belongsTo | quotation_supplier_id | quotationsupplier | |
| quotationinventoryprice | moq | belongsTo | moq_id | moq | |
| quotationinventoryprice | currency | belongsTo | currency_id | currency | |
| quotationinventoryprice | inventory | belongsTo | quotation_inventory_id | quotationinventory | |
| quotationitem | quotation | belongsTo | quotation_id | quotation | |
| quotationitem | bom | belongsTo | part_number | bom | |
| quotationitem | uom | belongsTo | uom_id | uom | |
| quotationitem | currency | belongsTo | currency_id | currency | |
| quotationitem | moq | belongsTo | moq_id | moq | |
| receivedeinvoice | items | hasMany | received_einvoice_id | receivedeinvoiceitem | |
| receivedeinvoice | supplier | belongsTo | supplier_id | supplier | |
| receivedeinvoice | purchaseOrder | belongsTo | po_id | purchaseorder | |
| receivedeinvoice | grn | belongsTo | grn_id | goodsreceiptsnote | |
| receivedeinvoice | rejectedByUser | belongsTo | rejected_by | user | |
| receivedeinvoiceitem | receivedEinvoice | belongsTo | received_einvoice_id | receivedeinvoice | |
| receivedeinvoiceitem | poItem | belongsTo | po_item_id | purchaseorderitem | |
| rejectgallery | workorder | belongsTo | wo_id | workorder | |
| rejectgallery | process | belongsTo | process_id | process | |
| role | process | belongsTo | department_id | role | |
| salesorder | bom | belongsTo | bom_id | bom | |
| salesorder | customer | belongsTo | customer_id | customer | |
| salesorder | user | belongsTo | prepared_by | — | |
| salesorder | currency | belongsTo | currency_id | currency | |
| salesorder | job_order | hasOne | job_order_number | joborder | |
| salesorder | sales_order_items | hasMany | sales_order_id | salesorderitem | |
| salesorder | invoice | hasMany | so_number | invoice | |
| salesorder | systemStatus | belongsTo | status | systemstatus | |
| salesorder | lmw | belongsTo | customer_id | lmw | |
| salesorder | invoices | hasOne | so_id | invoice | |
| salesorder | sales_order_customer_request_dates | hasMany | sales_order_id | salesordercustomerrequestdate | |
| salesordercustomerrequestdate | salesOrder | belongsTo | sales_order_id | salesorder | |
| salesordercustomerrequestdate | salesOrderItem | belongsTo | sales_order_item_id | salesorderitem | |
| salesordercustomerrequestdate | histories | hasMany | sales_order_customer_request_date_id | salesordercustomerrequestdatehistory | |
| salesordercustomerrequestdate | invoiceItem | belongsTo | document_reference_id | invoiceitem | |
| salesordercustomerrequestdate | invoiceItemWithTrashed | belongsTo | document_reference_id | invoiceitem | |
| salesordercustomerrequestdate | latestHistory | hasOne | — | salesordercustomerrequestdatehistory | |
| salesordercustomerrequestdate | workOrders | hasMany | so_item_id | workorder | |
| salesordercustomerrequestdate | workOrdersWithFrame | hasMany | so_item_id | workorder | |
| salesordercustomerrequestdatehistory | salesOrderCustomerRequestDate | belongsTo | sales_order_customer_request_date_id | salesordercustomerrequestdate | |
| salesorderitem | bom | belongsTo | bom_id | bom | |
| salesorderitem | finishGood | belongsTo | bom_id | finishgoodsstock | |
| salesorderitem | salesOrder | belongsTo | sales_order_id | salesorder | |
| salesorderitem | salesOrderChangeRequestDate | belongsTo | sales_order_id | salesorder | |
| salesorderitem | workOrder | belongsTo | id | workorder | |
| salesorderitem | bomPrice | hasMany | bom_id | bomprice | |
| salesorderitem | bomResourceSelected | hasMany | id | bomresource | code_may_be_wrong |
| salesorderitem | bomResource | belongsTo | bom_resource_id | bomresource | |
| salesorderitem | invoice_items | hasMany | so_item_id | invoiceitem | |
| salesorderitem | systemStatus | belongsTo | status | systemstatus | |
| salesorderitem | workOrders | belongsTo | id | workorder | |
| salesorderitem | workOrderswithframe | hasMany | so_item_id | workorder | |
| salesorderitem | mainWorkOrders | hasMany | so_item_id | workorder | |
| salesorderitem | tripItems | hasMany | so_item_id | tripitem | |
| salesorderitem | sales_order_customer_request_dates | hasMany | sales_order_item_id | salesordercustomerrequestdate | |
| salesorderitem | invoiceableQuantities | hasMany | soi_id | invoiceablequantity | |
| salesorderitem | priceRevisionItems | hasMany | sales_order_item_id | popricerevisionitem | |
| salesorderitem | latestRevisionPointer | belongsTo | revision_history_pointer | popricerevisionitem | |
| shipmentframe | frameCategories | belongsTo | frame_category_id | shipmentframecategory | |
| shipmentframe | workOrder | belongsTo | work_order_id | workorder | |
| shipmentframe | customer | belongsTo | customer_id | customer | |
| shipmentframe | salesOrder | belongsTo | so_id | salesorder | |
| shipmentframe | shipment_frame_item | hasMany | shipment_frame_id | shipmentframeitem | |
| shipmentframeitem | inventory | belongsTo | item_id | inventory | |
| shipmentpiecepart | workOrder | belongsTo | wo_id | workorder | |
| shipmentpiecepart | customer | belongsTo | customer_id | customer | |
| shipmentpiecepart | salesOrder | belongsTo | so_id | salesorder | |
| shipmentpiecepart | shipment_pp_item | hasMany | shipment_piecepart_id | shipmentpiecepartitem | |
| shipmentpiecepartitem | shipmentPiecePart | belongsTo | shipment_piecepart_id | shipmentpiecepart | |
| skiplog | process | belongsTo | process_id | process | |
| skiplog | station | belongsTo | station_skip_origin_id | station | |
| skiplog | workorder | belongsTo | wo_id | workorder | |
| sku | grn_item | belongsTo | grn_item_id | goodrecieptsnoteitem | |
| smpstock | bom | belongsTo | bom_id | bom | |
| smpstock | transaction | hasMany | bom_id | smpstocktransaction | |
| smpstock | smpstocklocation | hasMany | smp_stock_id | smpstocklocation | |
| smpstocklocation | bom | belongsTo | bom_id | bom | |
| smpstocklocation | location | belongsTo | location_id | location | |
| smpstocklocation | smpstock | belongsTo | smp_stock_id | smpstock | |
| smpstocktransaction | location | belongsTo | location_id | station | |
| smpstocktransaction | trans_by | belongsTo | transaction_by | — | |
| smpstocktransaction | transaction | belongsTo | transaction_id | transaction | |
| smpstocktransaction | bom | belongsTo | bom_id | bom | |
| station | process | belongsTo | process_id | process | |
| station | leader | belongsTo | leader_id | employee | |
| station | location | belongsTo | location_id | location | |
| station | operator | hasMany | station_id | stationoperator | |
| station | ipaddress | belongsTo | station_ip_id | stationip | |
| stationip | location | belongsTo | location_id | location | |
| stationoperator | station | belongsTo | station_id | station | |
| stationoperator | employee | belongsTo | employee_id | employee | |
| stockhistory | transaction | hasOne | id | — | |
| stockhistory | nexthistory | hasOne | id | stockhistory | |
| stockinventories | inventory | belongsTo | inventory_id | inventory | |
| stockinventories | transaction | hasMany | inventory_id | — | |
| stockinventories | location_details | belongsTo | location_id | location | |
| stockinventories | stockItemCategory | belongsTo | stock_item_category_id | stockitemcategory | |
| stockinventories | dynamicVariableContent | belongsTo | id | stockinventorydynamicvariablecontent | |
| stockinventories | uom_converter | hasOne | id | uomconverter | |
| stockinventories | stockInventoryLocation | hasMany | stock_inventory_id | stockinventorylocation | |
| stockinventories | stockHistory | hasMany | stock_inventory_id | stockhistory | |
| stockinventories | hardwarePlanning | hasOne | inventory_id | hardware | |
| stockinventorydynamicvariablecontent | stockinventory | belongsTo | stock_inventory_id | stockinventories | |
| stockinventorydynamicvariablecontent | category | belongsTo | stock_item_category_id | stockitemcategory | |
| stockinventorylocation | inventory | belongsTo | inventory_id | inventory | |
| stockinventorylocation | location | belongsTo | location_id | location | |
| stockinventorylocation | stockinventory | belongsTo | stock_inventory_id | stockinventories | |
| stockinventorytransaction | transaction | belongsTo | transaction_id | transaction | |
| stockinventorytransaction | trans_by | belongsTo | transaction_by | — | |
| stockinventorytransaction | inventory | belongsTo | inventory_id | inventory | |
| stockinventorytransaction | station | belongsTo | station_id | station | |
| stockinventorytransaction | transactionBy | belongsTo | transaction_by | — | |
| stockinventorytransaction | purchaseOrder | belongsTo | po_number | purchaseorder | |
| stockinventorytransaction | workOrder | belongsTo | reference_transaction_id | workorder | |
| stockinventorytransaction | stockInventory | hasOne | inventory_id | stockinventories | |
| stockinventorytransaction | subStore | belongsTo | substore_id | locationcategory | |
| stockitemcategory | stockItemDynamicVariable | hasMany | stock_item_category_id | stockitemdynamicvariable | |
| stockitemdynamicvariable | stockItemCategory | belongsTo | stock_item_category_id | stockitemcategory | |
| subcon | invoice | hasMany | subcon_id | invoice | |
| subcon | customer | belongsTo | customer_id | customer | |
| substorestockinventories | inventory | belongsTo | inventory_id | inventory | |
| substorestockinventories | location_category | belongsTo | location_categories_id | locationcategory | |
| substorestockinventories | transaction | belongsTo | transaction_id | transaction | |
| substorestockinventorytransaction | substore_stock_inventories | belongsTo | substore_stock_inventory_id | substorestockinventories | |
| substorestockinventorytransaction | inventory | belongsTo | inventory_id | inventory | |
| substorestockinventorytransaction | transaction | belongsTo | transaction_id | transaction | |
| substorestockinventorytransaction | user | belongsTo | transaction_by | — | |
| substorestockinventorytransaction | workOrder | belongsTo | reference_transaction_id | workorder | |
| substorestockinventorytransaction | transactionBy | belongsTo | transaction_by | — | |
| substorestockinventorytransaction | subStore | hasOneThrough | id | locationcategory | |
| supplier | systemStatus | belongsTo | status | systemstatus | |
| supplier | currency | belongsTo | default_currency | currency | |
| supplier | taxes | belongsTo | default_tax | tax | |
| supplier | term | belongsTo | default_term | term | |
| supplier | country | belongsTo | — | — | |
| supplier | approver | belongsTo | approved_by | — | |
| supplier | purchaseOrder | hasMany | supplier_id | purchaseorder | |
| supplier | supplier_category | hasOne | id | suppliercategory | |
| supplier | bom_resource | hasMany | supplier_id | bomresource | |
| supplier | inventory_price | hasMany | supplier_id | inventoryprice | |
| supplier | powder | hasMany | supplier_id | powder | |
| supplier | addresses | hasMany | addressable_id | address | |
| supplier | msic | belongsTo | msic_id | einvoicemsiccode | |
| supplier | receivedEinvoices | hasMany | supplier_id | receivedeinvoice | |
| targetscheduledetail | bom | belongsTo | bom_id | bom | |
| targetschedulelist | user | belongsTo | prepared_by | — | |
| targetschedulelist | scheduleCategory | belongsTo | target_schedule_category_id | targetschedulecategory | |
| targetscheduleprocess | scheduleDetail | belongsTo | target_schedule_detail_id | targetscheduledetail | |
| targetscheduleprocess | process | belongsTo | process_id | process | |
| targetscheduleprocess | user | belongsTo | prepared_by | — | |
| tax | taxTypeBom | belongsTo | tax_type | einvoicetaxtype | |
| tax | taxTypeInventory | belongsTo | tax_type | einvoicetaxtype | |
| term | companies | belongsTo | company | customer | |
| term | documents | belongsTo | document | documentprefix | |
| travgallery | workorder | belongsTo | wo_id | workorder | |
| trip | tripItems | hasMany | — | tripitem | |
| trip | systemStatus | belongsTo | status | systemstatus | |
| trip | origin_plant | belongsTo | origin_plant_id | location | |
| trip | item_transfers | hasMany | trip_id | itemtransfer | |
| trip | galleries | hasMany | trip_id | itemtransfergallery | |
| tripitem | trip | belongsTo | trip_id | trip | |
| tripitem | bom | belongsTo | bom_id | bom | |
| tripitem | salesOrderItem | belongsTo | so_item_id | salesorderitem | |
| tripitem | workOrder | belongsTo | wo_id | workorder | |
| tripitem | systemStatus | belongsTo | status | systemstatus | |
| tripitem | destination_plant | belongsTo | destination_plant_id | location | |
| tripitem | item_transfer | belongsTo | item_transfer_id | itemtransfer | |
| unpackfinishgood | workorder | belongsTo | wo_id | workorder | |
| unpackfinishgood | bom | belongsTo | bom_id | bom | |
| uomconverter | convert_from_uom | belongsTo | from_uom | uom | |
| uomconverter | convert_to_uom | belongsTo | to_uom | uom | |
| user | country | belongsTo | — | — | |
| user | userrole | belongsTo | id | userrole | |
| user | employee | hasOne | staff_id | employee | |
| useridcard | employee | belongsTo | employee_id | employee | |
| userrole | role | belongsTo | role_id | role | |
| vehicle | vehicletype | hasOne | id | vehicletype | |
| vendoritemmapping | supplier | belongsTo | supplier_id | supplier | |
| vendoritemmapping | inventory | belongsTo | item_id | inventory | |
| wipinventory | inventory | belongsTo | inventory_id | inventory | |
| wipinventory | uom | belongsTo | uom_id | uom | |
| wipinventory | transactions | hasMany | wip_inventory_id | wipinventorytransaction | |
| wipinventorytransaction | wipInventory | belongsTo | wip_inventory_id | wipinventory | |
| wipinventorytransaction | workOrder | belongsTo | referance_document_id | workorder | |
| wipinventorytransaction | uom | belongsTo | uom_id | uom | |
| wipinventoryusage | process | belongsTo | process_id | process | |
| wipinventoryusage | wipInventoryUsageItems | hasMany | wip_inventory_usage_id | wipinventoryusageitem | |
| wipinventoryusage | inventory | belongsTo | inventory_id | inventory | |
| wipinventoryusage | status | belongsTo | status_id | — | |
| wipinventoryusageitem | workOrderItem | belongsTo | woi_id | workorderitem | |
| wipinventoryusageitem | wipInventoryUsage | belongsTo | wip_inventory_usage_id | wipinventoryusage | |
| wipinventoryusageitem | uom | belongsTo | uom_id | uom | |
| wipinventoryusageitem | workOrder | belongsTo | document_referance_id | workorder | |
| wipinventoryusageitem | status | belongsTo | status_id | — | |
| wipinventoryusageitem | bom | belongsTo | item_id | bom | |
| wipinventoryusageitem | inventory | belongsTo | item_id | inventory | |
| wipstorage | unfinishedGoods | hasMany | wip_storage_id | wipunfinishedgood | |
| wipunfinishedgood | transactions | hasMany | wip_unfinished_goods_id | wipunfinishedgoodtransaction | |
| wipunfinishedgood | storage | belongsTo | wip_storage_id | wipstorage | |
| wipunfinishedgood | bom | belongsTo | bom_id | — | |
| wipunfinishedgood | uom | belongsTo | uom_id | — | |
| wipunfinishedgoodtransaction | unfinishedGood | belongsTo | wip_unfinished_goods_id | wipunfinishedgood | |
| wipunfinishedgoodtransaction | uom | belongsTo | uom_id | uom | |
| wipunfinishedgoodtransaction | process | belongsTo | last_process_id | process | |
| wipunfinishedgoodtransaction | employee | belongsTo | transaction_by | employee | |
| wipunfinishedgoodtransaction | wipInventoryUsageItem | belongsTo | referance_document_id | wipinventoryusageitem | |
| wipunfinishedgoodtransaction | workOrderItem | belongsTo | referance_document_id | workorderitem | |
| workinprogressrecord | bom | belongsTo | bom_id | bom | |
| workinprogressrecord | transaction | belongsTo | transaction_type | transaction | |
| workinprogressrecord | workOrder | belongsTo | wo_id | workorder | |
| workinprogressrecord | station | belongsTo | station_id | station | |
| workorder | bom | belongsTo | bom_id | bom | |
| workorder | work_order_items | hasMany | wo_id | workorderitem | |
| workorder | work_order_item_ipos | hasMany | wo_id | workorderitemipo | |
| workorder | work_order_os | hasMany | wo_id | workorderos | |
| workorder | bom_process | hasMany | bom_id | bomprocess | |
| workorder | job_order | belongsTo | jo_id | joborder | |
| workorder | job_order_items | hasOne | job_order_number | joborder | |
| workorder | system_statuses | belongsTo | status | systemstatus | |
| workorder | frame_statuses | belongsTo | frame_wo_status | systemstatus | |
| workorder | bomResource | belongsTo | bom_resource_id | bomresource | |
| workorder | salesOrderItem | belongsTo | so_item_id | salesorderitem | |
| workorder | purchaseRequest | hasMany | wo_number | purchaserequest | |
| workorder | processtraveller | hasMany | wo_id | workorderprocesstraveller | |
| workorder | lastUpdatedProcessTraveller | hasOne | wo_id | workorderprocesstraveller | |
| workorder | FinishGoodStocksTransaction | belongsTo | wo_number | finishgoodstockstransaction | |
| workorder | unpackFinishGood | hasOne | wo_id | unpackfinishgood | |
| workorder | forecast_workorder | hasMany | wo_forecast_id | workorder | |
| workorder | customer_po_workorder | belongsTo | wo_forecast_id | workorder | |
| workorder | item_transfers | hasMany | wo_id | itemtransfer | |
| workorder | stockFrame | hasOne | wo_id | stockframe | |
| workorder | customer | hasOne | id | customer | |
| workorder | faiGallery | hasMany | wo_id | faigallery | |
| workorder | qcGallery | hasMany | wo_id | qcgallery | |
| workorder | workorderfg_items | hasMany | wo_id | workorderfgitem | |
| workorder | shipmentPiecePart | hasOne | wo_id | shipmentpiecepart | |
| workorder | issueWo | hasMany | issue_wo | workorderforecast | |
| workorder | bindWo | hasMany | bind_wo | workorderforecast | |
| workorder | wipStockin | belongsTo | id | workinprogressrecord | |
| workorder | wipStockout | belongsTo | id | workinprogressrecord | |
| workorder | workOrderProcessProgress | hasMany | wo_id | workorderprocesstraveller | |
| workorderfgitem | bom | belongsTo | bom_id | bom | |
| workorderfgitem | work_order | belongsTo | wo_id | workorder | |
| workorderfgitem | stockfg | belongsTo | bom_id | finishgoodsstock | |
| workorderfgitem | system_statuses | belongsTo | status | systemstatus | |
| workorderfgitem | miv | hasOne | woi_id | materialinvoicevoucher | |
| workorderforecast | issueWorkOrder | belongsTo | issue_wo | workorder | |
| workorderforecast | bindWorkOrder | belongsTo | bind_wo | workorder | |
| workorderitem | jo_item_id | belongsTo | jo_item_id | joborderitem | |
| workorderitem | inventory | belongsTo | inventory_id | inventory | |
| workorderitem | inventoryWithTrashed | belongsTo | inventory_id | inventory | |
| workorderitem | work_order | belongsTo | wo_id | workorder | |
| workorderitem | stock_inventory | belongsTo | inventory_id | stockinventories | |
| workorderitem | system_statuses | belongsTo | status | systemstatus | |
| workorderitem | receive_production | hasMany | wo_item_id | productionreceivaltransaction | |
| workorderitem | miv | hasOne | woi_id | materialinvoicevoucher | |
| workorderitemipo | jo_item_id | belongsTo | jo_item_id | joborderitem | |
| workorderitemipo | inventory | belongsTo | inventory_id | inventory | |
| workorderitemipo | work_order | belongsTo | wo_id | workorder | |
| workorderitemipo | stock_inventory | belongsTo | inventory_id | stockinventories | |
| workorderitemipo | system_statuses | belongsTo | status | systemstatus | |
| workorderitemipo | receive_production | hasMany | wo_item_id | productionreceivaltransaction | |
| workorderitemipo | miv | hasOne | woi_id | materialinvoicevoucher | |
| workorderos | bomprocess | belongsTo | bom_process_id | bomprocess | |
| workorderos | location | belongsTo | location_id | location | |
| workorderprocessprogressrecord | employee | belongsTo | employee_id_for_relation | employee | |
| workorderprocessprogressrecord | processtraveller | belongsTo | wo_process_traveller_id | workorderprocesstraveller | |
| workorderprocessprogressrecord | stations | belongsTo | station_id | station | |
| workorderprocessprogressrecord | progressRecordwot | belongsTo | wo_process_traveller_id | workorderprocesstraveller | |
| workorderprocessprogressrecord | progressRecordstation | belongsTo | station_id | station | |
| workorderprocesstraveller | work_order | belongsTo | wo_id | workorder | |
| workorderprocesstraveller | bomprocess | belongsTo | bom_process_id | bomprocess | |
| workorderprocesstraveller | process | belongsTo | process_id | process | |
| workorderprocesstraveller | rejected_process | belongsTo | rejected_process_id | process | |
| workorderprocesstraveller | parentProcessTraveller | belongsTo | parent_process_traveller_id | workorderprocesstraveller | |
| workorderprocesstraveller | reworkChildren | hasMany | parent_process_traveller_id | workorderprocesstraveller | |
| workorderprocesstraveller | item_transfer_statuses | belongsTo | item_transfer_status | systemstatus | |
| workorderprocesstraveller | item_receival_statuses | belongsTo | item_receival_status | systemstatus | |
| workorderprocesstraveller | unpackFG | belongsTo | wo_id | unpackfinishgood | |
| workorderprocesstraveller | delayed_production_schedule | hasOne | workorder_process_traveller_id | delayedproductionschedule | |
| workorderprocesstraveller | delayed_shipment_schedule | hasOne | workorder_process_traveller_id | delayedshipmentschedule |
22
| node | column | source | verified |
|---|---|---|---|
| bom | part_number | lookup_map | yes |
| creditdebitnote | grn_number | catalog_guess | guess |
| employee | staff_id | lookup_map | yes |
| finishgoodstockstransaction | wo_number | catalog_guess | guess |
| goodrecieptsnoteitem | wo_number | catalog_guess | guess |
| goodsreceiptsnote | grn_number | lookup_map | yes |
| inventory | part_number | lookup_map | yes |
| invoice | invoice_number | lookup_map | yes |
| invoice | job_order_number | catalog_guess | guess |
| invoiceitem | customer_po_number | catalog_guess | guess |
| joborder | job_order_number | lookup_map | yes |
| purchaseorder | po_number | lookup_map | yes |
| purchaseorderitem | job_order_number | catalog_guess | guess |
| purchaserequest | pr_number | lookup_map | yes |
| purchaserequest | so_number | catalog_guess | guess |
| purchaserequest | job_order_number | catalog_guess | guess |
| purchaserequest | wo_number | catalog_guess | guess |
| purchaserequest | plan_number | catalog_guess | guess |
| quotationitem | part_number | catalog_guess | guess |
| salesorder | so_number | lookup_map | yes |
| user | staff_id | lookup_map | yes |
| workorder | wo_number | lookup_map | yes |