CHECKING purchase_details TABLE STRUCTURE

Columns in purchase_details table:


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

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

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

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

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

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

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

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
Column NameTypeNullKeyDefault
detail_idint(11)NOPRI
purchase_idint(11)NOMUL
item_codevarchar(10)NOMUL
quantityint(11)NO
weightdecimal(10,3)YES
unit_typeenum('grams','numbers')YESgrams
rate_per_gramdecimal(10,2)NO
making_chargesdecimal(10,2)YES0.00
wastage_percentagedecimal(5,2)YES0.00
wastage_amountdecimal(10,2)YES0.00
total_amountdecimal(12,2)NO
barcodevarchar(50)YES
created_attimestampYEScurrent_timestamp()
is_fixed_ratetinyint(1)YES0
fixed_pricedecimal(10,2)YES0.00
purchase_pricedecimal(10,2)YES0.00

CHECKING purchase_header TABLE STRUCTURE

Columns in purchase_header table:


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

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

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

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

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

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

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

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

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
Column NameTypeNullKeyDefault
purchase_idint(11)NOPRI
invoice_numbervarchar(50)NOUNI
supplier_codevarchar(3)YESMUL
purchase_datedateNO
purchase_timetimeNO
total_amountdecimal(12,2)NO
total_weightdecimal(10,3)NO
total_quantityint(11)YES0
cgst_amountdecimal(10,2)YES0.00
sgst_amountdecimal(10,2)YES0.00
igst_amountdecimal(10,2)YES0.00
other_chargesdecimal(10,2)YES0.00
created_byint(11)YESMUL
created_attimestampYEScurrent_timestamp()
item_namevarchar(200)YES


← Back to Purchase