Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: addmrn
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query
x
 
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(11)
MRNNovarchar(40)
MRNVoucherDatedate ...
MRNDatedate ...
ReceivedAgainstvarchar(30)
MaterialReceiptOnBasisvarchar(20)
rmrs_novarchar(50)
StoreCodevarchar(10)
sitevarchar(50)
StoreNamevarchar(30)
PO_WO_MTOvarchar(30)
OrderDatedate ...
ReceivedFromvarchar(40)
req_noint(6)
DocumentTypevarchar(10)
BillNovarchar(10)
BillDatedate ...
GetPassNovarchar(10)
Inwardsdatedate ...
Transp_namevarchar(30)
VehicleNovarchar(20)
TimeInvarchar(10)
Timeoutvarchar(10)
LRnovarchar(10)
LRdatedate ...
TotalWeightvarchar(50)
form_typevarchar(50)
form_novarchar(100)
RemarksIfAnytext
Remarkstext
createdbyvarchar(20)
mrnstatusvarchar(20)
site_namevarchar(30)
totalqtydouble(10,2)
total_Item_Amountdouble(10,2)
pkg_percdouble(10,2)
pkg_chargesdouble(10,2)
vat_cstvarchar(20)
vat_cst_valdouble(10,2)
sur_oct_perdouble(10,2)
sur_oct_amtdouble(10,2)
tot_freightdouble(10,2)
add_chargesdouble(10,2)
grandtotaldouble(10,2)
round_offvarchar(5)
order_novarchar(20)
Typevarchar(30)
Cancel_Statusvarchar(10) N
OrderFromSitevarchar(30)
gatepassdatedate ...
MRVS_statusint(10) 0
companyIDint(10)
loadingdouble(10,2)
workordernoint(25)
workorderitemint(25)
userstypevarchar(255)
CustomDutyint(10)
custondutyvaldouble(16,2)
insurancechargesdouble(16,2)
insurancecharges_amtdouble(16,2)
overseasfrieghtdouble(16,2)
overseasfrieght_amtdouble(16,2)
localfreightdouble(16,2)
localfreight_amtdouble(16,2)
clearingforwardingdouble(16,2)
calclearingforwarding_amtdouble(16,2)
detetionchargesdouble(16,2)
detetioncharges_amtdouble(16,2)
otherchargesdouble(16,2)
Grn_Typevarchar(255)
Po_categoryvarchar(255)
Modified_byint(10)
Modified_datedate ...
duty_typevarchar(255) Consolidated
batch_novarchar(255)
Approval_statusvarchar(10) 0
totalRecQtydouble(10,2)
totalBillQtydouble(10,2)
purch_ord_categoryvarchar(200)
transaction_timedatetime ...
site_tranf_statusint(11)
totalamountdouble(10,2)
cash_paymentdouble(10,2)
credit_paymentdouble(10,2)


ColumnTypeFunctionNullValue
idint(11)
MRNNovarchar(40)
MRNVoucherDatedate ...
MRNDatedate ...
ReceivedAgainstvarchar(30)
MaterialReceiptOnBasisvarchar(20)
rmrs_novarchar(50)
StoreCodevarchar(10)
sitevarchar(50)
StoreNamevarchar(30)
PO_WO_MTOvarchar(30)
OrderDatedate ...
ReceivedFromvarchar(40)
req_noint(6)
DocumentTypevarchar(10)
BillNovarchar(10)
BillDatedate ...
GetPassNovarchar(10)
Inwardsdatedate ...
Transp_namevarchar(30)
VehicleNovarchar(20)
TimeInvarchar(10)
Timeoutvarchar(10)
LRnovarchar(10)
LRdatedate ...
TotalWeightvarchar(50)
form_typevarchar(50)
form_novarchar(100)
RemarksIfAnytext
Remarkstext
createdbyvarchar(20)
mrnstatusvarchar(20)
site_namevarchar(30)
totalqtydouble(10,2)
total_Item_Amountdouble(10,2)
pkg_percdouble(10,2)
pkg_chargesdouble(10,2)
vat_cstvarchar(20)
vat_cst_valdouble(10,2)
sur_oct_perdouble(10,2)
sur_oct_amtdouble(10,2)
tot_freightdouble(10,2)
add_chargesdouble(10,2)
grandtotaldouble(10,2)
round_offvarchar(5)
order_novarchar(20)
Typevarchar(30)
Cancel_Statusvarchar(10) N
OrderFromSitevarchar(30)
gatepassdatedate ...
MRVS_statusint(10) 0
companyIDint(10)
loadingdouble(10,2)
workordernoint(25)
workorderitemint(25)
userstypevarchar(255)
CustomDutyint(10)
custondutyvaldouble(16,2)
insurancechargesdouble(16,2)
insurancecharges_amtdouble(16,2)
overseasfrieghtdouble(16,2)
overseasfrieght_amtdouble(16,2)
localfreightdouble(16,2)
localfreight_amtdouble(16,2)
clearingforwardingdouble(16,2)
calclearingforwarding_amtdouble(16,2)
detetionchargesdouble(16,2)
detetioncharges_amtdouble(16,2)
otherchargesdouble(16,2)
Grn_Typevarchar(255)
Po_categoryvarchar(255)
Modified_byint(10)
Modified_datedate ...
duty_typevarchar(255) Consolidated
batch_novarchar(255)
Approval_statusvarchar(10) 0
totalRecQtydouble(10,2)
totalBillQtydouble(10,2)
purch_ord_categoryvarchar(200)
transaction_timedatetime ...
site_tranf_statusint(11)
totalamountdouble(10,2)
cash_paymentdouble(10,2)
credit_paymentdouble(10,2)

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

Continue insertion with rows