| id |
bigint(20)
|
|
|
|
| ticket_no |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| ticket_type |
enum('SALES', 'SERVICE')
|
utf8mb4_general_ci
|
|
|
| entry_type |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| entry_date |
date
|
|
|
|
| ledger_id |
tinyint(4)
|
|
|
|
| customer_name |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| contact_person |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| whatsapp |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| pincode |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| address |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| sales_person_id |
int(10)
|
|
|
|
| other_reference |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| reference_notes |
longtext
|
utf8mb4_general_ci
|
|
|
| is_exchange |
enum('Y', 'N')
|
utf8mb4_general_ci
|
|
|
| new_machine_price |
decimal(10,2)
|
|
|
|
| total_exchange |
decimal(10,2)
|
|
|
|
| net_payable |
decimal(10,2)
|
|
|
|
| exchange_status |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| inspection_by |
int(10)
|
|
|
|
| pickup_date |
date
|
|
|
|
| pickup_location |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| exchange_remark |
longtext
|
utf8mb4_general_ci
|
|
|
| status_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| finance_year_id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
