| Reservation ID | Sample ID | Policy Number | Patient Name | Test | Payment Method | Paid by Patient | Insurance Credit | Subtotal | {{$global_symbol['tax'] ?? 'TAX'}} (Patient) | Insurance {{$global_symbol['tax'] ?? 'TAX'}} | Net Total (Insurance) | Paid | Remaining | Status | Result Date | Paid By | Open/Closed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{$order->END_USER_LAB_ORDER_ID}} | {{$order->ID}} | {{$order->POLICY_NUMBER}} | {{$order->PATIENT_NAME}} | {{$order->TEST_NAME}} | {{$order->PAYMENT_METHOD_NAME}} | {{$order->SUB_TOTAL}} | {{$order->SUB_TOTAL_INSURANCE}} | {{$order->SUB_TOTAL_INSURANCE + $order->SUB_TOTAL}} | {{$order->TOTAL_TAX}} | {{$order->TOTAL_TAX_INSURANCE}} | {{$order->TOTAL_INSURANCE}} | {{--{{empty($order->TOTAL_INVOICE) ? "0" : $order->TOTAL_INVOICE}} | --}}{{($order->TOTAL_AMOUNT/100 - $order->TOTAL_PRICE)}} | {{(empty($order->TOTAL_INSURANCE) ? 0 : $order->TOTAL_INSURANCE) - (($order->TOTAL_AMOUNT / 100 - $order->TOTAL_PRICE))}} | {{$order->SAMPLE_STATUS}} | {{$order->APPROVE_TIME}} | {{$order->USERNAME}} | @if(($order->TOTAL_AMOUNT/100 - $order->TOTAL_PRICE) < $order->TOTAL_INSURANCE) Open @else Closed @endif | Totals | {{$sub_total}} | {{$sub_total_insurance}} | {{$sub_total_insurance + $sub_total}} | {{$tax_total}} | {{$tax_total_insurance}} | {{$total_net}} | {{$total_invoice}} | {{$total_net - $total}} |