📊 CSV to Database Importer

Import CSV data into the alloutstanding table with two header rows

🛢️ Select Database

Current Database: test

Table Status: ❌ Table not found

✅ Ready to Import

The 'alloutstanding' table will be created automatically when you import data.

📋 Required Table Structure

Column Name Data Type Nullable
alloutstanding_idINT(11) AUTO_INCREMENTNO
del_pointINT(11)NO
dem_nameVARCHAR(45)YES
dem_noVARCHAR(12)YES
ord_noINT(11)NO
ord_dateDATETIMEYES
expected_deliv_dateDATETIMEYES
item_descriptionVARCHAR(145)YES
supplier_nameVARCHAR(145)YES
ord_qtyINT(11)YES
doqVARCHAR(5)YES
doq_priceDOUBLEYES
valueDECIMAL(15,4)YES
outs_qtyINT(11)YES
oust_valueDECIMAL(15,4)YES
icnINT(11)NO

📄 CSV File Requirements