CHECKING purchase_details TABLE STRUCTURE
Columns in purchase_details table:
| Column Name | Type | Null | Key | Default |
|---|
| detail_id | int(11) | NO | PRI |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| purchase_id | int(11) | NO | MUL |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| item_code | varchar(10) | NO | MUL |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| quantity | int(11) | NO | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| weight | decimal(10,3) | YES | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| unit_type | enum('grams','numbers') | YES | | grams |
| rate_per_gram | decimal(10,2) | NO | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| making_charges | decimal(10,2) | YES | | 0.00 |
| wastage_percentage | decimal(5,2) | YES | | 0.00 |
| wastage_amount | decimal(10,2) | YES | | 0.00 |
| total_amount | decimal(12,2) | NO | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| barcode | varchar(50) | YES | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 21
|
| created_at | timestamp | YES | | current_timestamp() |
| is_fixed_rate | tinyint(1) | YES | | 0 |
| fixed_price | decimal(10,2) | YES | | 0.00 |
| purchase_price | decimal(10,2) | YES | | 0.00 |
CHECKING purchase_header TABLE STRUCTURE
Columns in purchase_header table:
| Column Name | Type | Null | Key | Default |
|---|
| purchase_id | int(11) | NO | PRI |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| invoice_number | varchar(50) | NO | UNI |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| supplier_code | varchar(3) | YES | MUL |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| purchase_date | date | NO | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| purchase_time | time | NO | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| total_amount | decimal(12,2) | NO | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| total_weight | decimal(10,3) | NO | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| total_quantity | int(11) | YES | | 0 |
| cgst_amount | decimal(10,2) | YES | | 0.00 |
| sgst_amount | decimal(10,2) | YES | | 0.00 |
| igst_amount | decimal(10,2) | YES | | 0.00 |
| other_charges | decimal(10,2) | YES | | 0.00 |
| created_by | int(11) | YES | MUL |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
| created_at | timestamp | YES | | current_timestamp() |
| item_name | varchar(200) | YES | |
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/kalpavrukshaits/test.kalpavrukshaits.com/silver-jewelry/check_table.php on line 48
|
← Back to Purchase