π Overview: 69 Fields 19 Indexes 4 Many-to-One Relations 2 One-to-Many Relations
π¨οΈ Transaction table for customer purchase orders. Stores order details, delivery schedules, pricing, and status. Links to Customers, Products, and generates WorksOrders for production.
Table ID: 3UUID: BEB2206FADBF794D8690FF16FF7721B1Primary Key: π Petes_NoGenerated: π 2025-12-04T14:33:31Z Field Type Constraints Description Product_ID Long Integerπ« Not Null - Issue_Date Dateβ οΈ Required, π« Not Null - Date_Received Dateβ οΈ Required, π« Not Null - Customer_Code String (3)β οΈ Required, π« Not Null - Customer_Order_No String (18)β οΈ Required, π« Not Null - Customer_Order_Date Dateβ οΈ Required, π« Not Null - Part_No String (30)β οΈ Required, π« Not Null - Issue_No String (5)β οΈ Required, π« Not Null - Quantity_Ordered Long Integerβ οΈ Required, π« Not Null - Batch_No Stringπ« Not Null - Customer_Delivery_Date Dateβ οΈ Required, π« Not Null - Our_Delivery_Date Dateβ οΈ Required, π« Not Null - Price_Quantity Integerπ« Not Null - Order_Price Realβ οΈ Required, π« Not Null - Is_Replacement Booleanπ« Not Null - Tool_No String (5)π« Not Null - Nominal_Sale Realπ« Not Null - Material_ID Long Integerπ« Not Null - Material_CName String (80)π« Not Null - Tool_ID Integerπ« Not Null - MaterialOurName String (80)π« Not Null - Cust Part No String (30)π« Not Null, οΏ½οΏ½οΏ½οΈ Hidden - Quantity_Delivered Long Integerπ« Not Null - Cumulative Long Integerπ« Not Null - Suggested Long Integerπ« Not Null - Is_On_hold Booleanπ« Not Null - Completed Booleanβ οΈ Required, π« Not Null - Quantity_Required Long Integerπ« Not Null - π Petes_No Long Integerπ PK, β¨ Unique, β‘ Auto, π« Not Null, οΏ½οΏ½οΏ½ Not Modifiable - CalculatedDespatchDate Dateπ« Not Null - Status String (3)π« Not Null - Acknowledged Booleanβ οΈ Required, π« Not Null - Part_Delivery Booleanβ οΈ Required, π« Not Null - Invoiced Booleanβ οΈ Required, π« Not Null - Ready_To_Delete Booleanπ« Not Null - Is_a_Trial Booleanπ« Not Null - Delivered_Value Realπ« Not Null - Ammeded_Date Dateπ« Not Null - Is_New_Order Booleanπ« Not Null - QtyMonthAfter Long Integerπ« Not Null - BoxesMonthAfter Integerπ« Not Null - OTIF Booleanπ« Not Null - OTIF_Shortfall Long Integerπ« Not Null - OTIF_Comments String (255)π« Not Null - ConsignmentOTIFCheck Booleanπ« Not Null - ProductionReadyDate Dateπ« Not Null - ReadyOnDate Long Integerπ« Not Null - DaysLate Integerπ« Not Null - OrderNotes Stringπ« Not Null - MCPlanned Integerπ« Not Null - NSKDelivered Integerπ« Not Null - NSKUndelivered Integerπ« Not Null - NSKCurrentSYNStock Integerπ« Not Null - ConsignmentDummy Booleanπ« Not Null - FinWheelID Long Integerπ« Not Null - FinWheelMC Integerπ« Not Null - ConOrderDummy Booleanπ« Not Null - Reviewed Booleanπ« Not Null - DateReviewed Dateπ« Not Null - ReviewedReadyDate Dateπ« Not Null - Confirmed Booleanπ« Not Null - ConfirmedDate Dateπ« Not Null - ConfirmedDue Dateπ« Not Null - MakeOrder Long Integerπ« Not Null - SIMUsageOrder Booleanπ« Not Null - Product_OptionID Long Integer- - ProcurementProgramOrder Booleanπ« Not Null - Forecast Booleanπ« Not Null - FutureYearForecast Boolean- -
Field Type Kind Unique Petes_NoKeywords regular β¨ Yes ReviewedKeywords regular - ForecastKeywords regular - Product_IDKeywords regular - CompletedKeywords regular - Our_Delivery_DateKeywords regular - ConfirmedKeywords regular - Part_NoKeywords regular - ProcurementProgramOrderKeywords regular - Customer_Delivery_DateKeywords regular - Material_IDKeywords regular - FinWheelIDKeywords regular - Product_OptionIDKeywords regular - Customer_Order_NoKeywords regular - FutureYearForecastKeywords regular - Ready_To_DeleteKeywords regular - MakeOrderKeywords regular - Customer_CodeKeywords regular - Ammeded_DateKeywords regular -
Relation Name Destination Table Source β Destination State Description ProductEntityProduct Product_ID β Product_IDActive - MaterialEntityMaterial Material_ID β Unique_IDActive - CustomerEntityCustomer Customer_Code β Customer_CodeActive - Product_OptionEntityProduct_Option Product_OptionID β IDActive -
Relation Name Source Table Source β Destination State Description CofCSelectionCofC Petes No β Petes_NoActive - OrderPickRequestSelectionOrderPickRequest CustomerOrderID β Petes_NoActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:31Z