add new table of fulfillment v2

1 files changed, 16 insertions, 0 deletions

diff --git a/indoteknik_custom/models/sales_order_fullfillment.py b/indoteknik_custom/models/sales_order_fullfillment.py
index ab416e8d..9e9457f1 100644
--- a/indoteknik_custom/models/sales_order_fullfillment.py
+++ b/indoteknik_custom/models/sales_order_fullfillment.py
@@ -6,6 +6,22 @@ import logging
 _logger = logging.getLogger(__name__)
 
 
+class SalesOrderFullfillmentV2(models.Model):
+    _name = 'sales.order.fulfillment.v2'
+
+    sale_order_id = fields.Many2one('sale.order', string='Sale Order')
+    sale_order_line_id = fields.Many2one('sale.order.line', string='Sale Order Line')
+    picking_id = fields.Many2one('stock.picking', string='Picking')
+    move_id = fields.Many2one('stock.move', string='Move')
+    move_line_id = fields.Many2one('stock.move.line', string='Move Line')
+    product_id = fields.Many2one('product.product', string='Product')
+    so_qty = fields.Float(string='SO Qty')
+    reserved_stock_qty = fields.Float(string='Reserved Stock Qty')
+    po_ids = fields.Many2many('purchase.order', string='Purchase Order')
+    po_qty = fields.Float(string='PO Qty', help='Totalan dari semua PO Outstanding')
+    received_qty = fields.Float(string='Received Qty', help='Totalan dari barang yang diterima dari PO tsb')
+
+
 class SalesOrderFullfillment(models.Model):
     _name = 'sales.order.fullfillment'