<table border="1" cellpadding="8">
  <tr>
    <th>Custaccount</th>
    <th>Contactpersonid</th>
    <th>Email</th>
    <th>Salespoolid</th>
    <th>Salesresponsible</th>
    <th>Segment</th>
    <th>SubSegment</th>
    <th>Taxgroup</th>
    <th>VATNum</th>
    <th>IDLTaxNumberTypeId</th>
    <th>Delivery Street</th>
    <th>PwC_InvoiceAddrRecid</th>
    <th>Invoice Street</th>
    <th>Payment</th>
    <th>PurchOrderFormNum</th>
    <th>CustomerRef</th>
    <th>PwC_CustPONum</th>
    <th>PwC_CustPODate</th>
    <th>DimH1</th>
    <th>DimH2</th>
    <th>DimH3</th>
    <th>DimH4</th>
    <th>DimH5</th>
    <th>DimH6</th>
    <th>DimH7</th>
    <th>LineNum</th>
    <th>Itemid</th>
    <th>Itemname</th>
    <th>Name</th>
    <th>SalesQty</th>
    <th>SalesUnit</th>
    <th>SalesPrice</th>
    <th>LineDisc</th>
    <th>LineAmount</th>
    <th>ReceiptDateRequested</th>
    <th>ShippingDateRequested</th>
    <th>InventLocationId</th>
    <th>Dim1</th>
    <th>Dim2</th>
    <th>Dim3</th>
    <th>Dim4</th>
    <th>Dim5</th>
    <th>Dim6</th>
  </tr>
<?php 
$count = 0;
foreach($order_details as $detail) : ?>
    <?php
       $count++;
      //get customer data
      $customer = $this->db->select('*')->from('customers')->where('id_customers', $detail->customer_id)->get()->row();
    ?>
    <tr>
      <td><?= $customer->custaccount; ?></td>
      <td><?= $customer->contactpersonid; ?></td>
      <td><?= $customer->email; ?></td>
      <td><?= $customer->salespoolid; ?></td>
      <td><?= $detail->sales_id; ?></td>
      <td><?= $customer->segment; ?></td>
      <td><?= $customer->subsegment; ?></td>
      <td><?= $customer->taxgroup; ?></td>
      <td><?= $customer->npwp; ?></td>
      <td><?= $customer->IDLTaxNumberTypeId; ?></td>
      <td><?= $detail->address; ?> <?= $detail->district; ?></td>
      <td><?= $customer->PwC_InvoiceAddrRecid; ?></td>
      <td><?= $customer->address; ?></td>
      <td><?= $customer->payment; ?></td>
      <td><?= $customer->PurchOrderFormNum; ?></td>
      <td><?= $customer->CustomerRef; ?></td>
      <td><?= $detail->id_orders; ?></td>
      <td><?= $detail->order_date; ?></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
      <td><?= $count; ?></td>
      <td>
      <?php
        //get product code
        $product_code = $this->db->select('product_code')->from('products')->where('id_products', $detail->item_id)->get()->row()->product_code;
        echo $product_code;
      ?>
      </td>
      <td><?= $detail->item_name; ?></td>
      <td><?= $detail->item_name; ?></td>
      <td><?= $detail->quantity; ?></td>
      <td>Pcs</td>
      <td><?= $detail->item_price; ?></td>
      <td>0</td>
      <td><?= $detail->item_price; ?></td>
      <td><?= $detail->order_date; ?></td>
      <td><?= $detail->payment_date; ?></td>
      <td><?= $detail->warehouse_id; ?></td>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
      <th></th>
    </tr>
<?php endforeach; ?>
</table>