# sale\_receipt\_validation\_queue

## Model

<table><thead><tr><th width="295">Field</th><th>Type</th><th data-type="checkbox">Nullable</th><th>Default value</th></tr></thead><tbody><tr><td>id</td><td>int4</td><td>false</td><td></td></tr><tr><td>current_validation_queue</td><td>varchar</td><td>false</td><td></td></tr><tr><td>sale_receipt_id</td><td>json</td><td>false</td><td></td></tr><tr><td>user_A_validation_status</td><td>int4</td><td>false</td><td>not done</td></tr><tr><td>user_B_validation_status</td><td>bool</td><td>false</td><td>not done</td></tr><tr><td>created_at</td><td>timestamp</td><td>false</td><td></td></tr><tr><td>updated_at</td><td>timestamp</td><td>false</td><td></td></tr><tr><td>team_member_validation_status</td><td>varchar(50)</td><td>false</td><td>not all</td></tr><tr><td>team_member_validation</td><td>json</td><td>true</td><td></td></tr></tbody></table>

## Description of fields

### id

Unique identifier for each entry in the queue.

### current\_validation\_queue

Name of the current queue the sales receipt is in. This likely reflects different validation stages.

1. user
2. team member

### sale\_receipt\_id

Foreign key referencing the ID of the associated sales receipt in a separate table.

### user\_A\_validation\_status

This column represents the validation status of the allocated user A. These 4 values are coming in this column.

1. not done
2. pending
3. done
4. not allocated

### user\_B\_validation\_status

This column same as the \`user\_A\_validation\_status\` column. But this status represents the validation status of the allocated user B. These are 4 values coming in this column.

1. not done
2. pending
3. done
4. not allocated&#x20;

### team\_member\_validation\_status

This column represents the validation status of a team member. These are below-mentioned values are coming in this column.

1. not allocated
2. done

### team\_member\_validation

The column represents what response the team member gave if there was a mismatch between the reactions of two validators for that sale receipt. So, this column stores the team member's responses. \
For reference:

```json
{
    "team_member_response": 
    {
        "1": "A", 
        "2": "A", 
        "3": "A", 
        "4": "A", 
        "5": "A", 
        "6": "A", 
        "7": "A", 
        "8": "A", 
        "9": "A"
    }, 
    "rejection_reason_ids": []
}
```