📊 Overview: 24 Fields 4 Indexes 2 Many-to-One Relations
🗨️ Transaction table tracking inventory movements of finished products. Records stock transfers between locations, deliveries, adjustments, and provides audit trail for stock changes.
Table ID: 5UUID: F1AE2CED84FC204E9E788B8FF9BE9359Primary Key: 🔑 IDGenerated: 🕐 2025-12-04T14:33:33Z Field Type Constraints Description Movement_Type_From_s String (2)🚫 Not Null - Date_Of_Movement_d Date🚫 Not Null - Works_Order_No_l Long Integer🚫 Not Null - Quantity_In_l Long Integer🚫 Not Null - Advice_Note_No_i Long Integer🚫 Not Null - Quantity_Out_l Long Integer🚫 Not Null - Stock_Movement_b Boolean🚫 Not Null - Cert_Of_Conformance_No_i Long Integer🚫 Not Null - From_Location_l Long Integer🚫 Not Null - UserName_txt String🚫 Not Null - ProductID_l Long Integer🚫 Not Null - To_Location_l Long Integer🚫 Not Null - Reason_For_Movement_txt String🚫 Not Null - Movement_Type_To_s String (2)🚫 Not Null - StockMovementID_l Long Integer🚫 Not Null - DeliveryMethod_txt String🚫 Not Null - Order_No_s String (30)🚫 Not Null - FullPallet_l Long Integer🚫 Not Null - is_consigment_stock_b Boolean🚫 Not Null - NSKFromBox Long Integer🚫 Not Null - NSKToBox Long Integer🚫 Not Null - TransactionID Long Integer🚫 Not Null - MoveListNum Long Integer🚫 Not Null - 🔑 ID Long Integer🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null -
Field Type Kind Unique ProductID_lKeywords regular - IDKeywords regular ✨ Yes Works_Order_No_lKeywords regular - Date_Of_Movement_dKeywords regular -
Relation Name Destination Table Source → Destination State Description WorksOrderEntityWorksOrder Works_Order_No_l → Works_Order_NoActive - Stock_LocationEntityStock_Location To_Location_l → StockLocationID_lActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:33Z