Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: dbl_dealer_dispatch
Page-related settingsClick on the bar to scroll to top of page
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Edit mode

Customize edit mode.

Documentation Disallow BLOB and BINARY columns from editing.
Documentation Display the function fields in edit/insert mode.
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode.
Documentation How many rows can be inserted at one time.
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value.
Documentation A dropdown will be used if fewer items are present.
ColumnTypeFunctionNullValue
idint(25)
pick_list_typevarchar(255)
datedate ...
timevarchar(25)
pick_list_novarchar(255)
dispatch_datedate ...
delivery_datedate ...
consignee_codevarchar(255)
dealerint(25)
SOI_noint(25)
SOI_datedate ...
enquiry_noint(25)
zoneint(25)
subzoneint(25)
engineerint(25)
customerint(25)
sales_remarkstext
dispatch_remarkstext
order_typevarchar(255)
quotation_novarchar(255)
companyint(25)
created_byint(25)
created_datedate ...
basic_amtdouble(10,2)
discountdouble(10,2)
discount_Amtdouble(10,2)
EDBillRatedouble(10,2)
totalDiscountedPricedouble(10,2)
VatCstint(10)
VatCstValuedouble(10,2)
surchargeint(10)
surcharge_Amtdouble(10,2)
ecess_perint(10)
sah_perint(10)
ecess_valuedouble(10,2)
sah_valuedouble(10,2)
totalexcisedouble(10,2)
discountAmtdouble(10,2)
additional_chrgdouble(10,2)
grand_tataldouble(10,2)
term_and_conditionvarchar(255)
validitydate ...
payment_termint(10)
p_and_fdouble(10,2)
pnf_amtdouble(10,2)
Inc_chrgdouble(10,2)
incidental_Amtdouble(10,2)


ColumnTypeFunctionNullValue
idint(25)
pick_list_typevarchar(255)
datedate ...
timevarchar(25)
pick_list_novarchar(255)
dispatch_datedate ...
delivery_datedate ...
consignee_codevarchar(255)
dealerint(25)
SOI_noint(25)
SOI_datedate ...
enquiry_noint(25)
zoneint(25)
subzoneint(25)
engineerint(25)
customerint(25)
sales_remarkstext
dispatch_remarkstext
order_typevarchar(255)
quotation_novarchar(255)
companyint(25)
created_byint(25)
created_datedate ...
basic_amtdouble(10,2)
discountdouble(10,2)
discount_Amtdouble(10,2)
EDBillRatedouble(10,2)
totalDiscountedPricedouble(10,2)
VatCstint(10)
VatCstValuedouble(10,2)
surchargeint(10)
surcharge_Amtdouble(10,2)
ecess_perint(10)
sah_perint(10)
ecess_valuedouble(10,2)
sah_valuedouble(10,2)
totalexcisedouble(10,2)
discountAmtdouble(10,2)
additional_chrgdouble(10,2)
grand_tataldouble(10,2)
term_and_conditionvarchar(255)
validitydate ...
payment_termint(10)
p_and_fdouble(10,2)
pnf_amtdouble(10,2)
Inc_chrgdouble(10,2)
incidental_Amtdouble(10,2)

   and then   
Use TAB key to move from value to value, or CTRL+arrows to move anywhere

Continue insertion with rows