* acholderid acholdername acholderdegid acholderdegabbr acholderactivate

* bankid bankname branchname bankaddress bankphone bankfax bankemail countid status

* anbuyid buyer_name buyer_address byer_contact_person buyer_contact_no buyer_email countid userid entry_date

* apitid apiresult apiwo apitranstime

* aprovlvid aprovlvname aprovlvsts

* bill_sts

* buyid buyer babbr baddress countid bphone bfax bemail buyertype buyerstatus

* bugaid cus_type buganame

* chid chamical_name chamical_type chamical_category

* costid costdate buyid fabid gdprocessid fabfinish dlvryterm payterm ordqty pricevalidity wpyarnid wp wfyarnid wf ends pik gsm wtg1 warpwtg wprt wfrt psrt wv wtg2 exrt mfmr com gw fw cum ctp qtkg fgt qoutemtr remarks stid mmid mmdate srmmid srmmdate gmid gmdate bfabid cpmid ypfor wfybrand

* cvid drate wvper proper

* pkrid cprid sdprate ydprate spdprate rst cpmid cril_3 cril_2

* cprid cprange cminrange cmaxrange crst rfor

* cpmid cpmdate cpuid cpudate cpckuid cpckdate cpappuid cpappdate status

* cprcid gdprocessid cprid rigidcost spdcost euserid edate appuserid appdate costst cpmid

* fabid artcode composition weave construction totalends reedcount reedspech pick warpcount weftcount wtofwarp wtofweft linearweight gsm oz width salvedge

* countid country

* cuspoid piid cuspo style color cusqty unitprice

* delvid piid poid colorname delivqty delivdate delivcomments picid delvchallan

* dltmid delterm

* dlv_month dlv_buyer dlv_construction dlv_qty dlv_ac_holder

* deptid deptname

* degid designation degabb

* dsbid dsid rcid prid pocid plmid dbacherno dbacherqty dbtranqty outdate outtime nprid rcsubid outnote rpstatus inbid mcid userid outwidth outshift outentrydate

* devdid dept_name

* dinid plmid userid insdate insokqty mcid dinuserid instime entrydate shiftid rollno trolyno rollwidth tfault_points point_sqyd result dinrid dshid plid dinstid rproqty inspection_notes gradding gradding_notes

* fltid faltname fault_category

* pfdid fltid nfault fremarks userid edate dinid

* pfdid fltid nfault fremarks userid edate dinid

* dinrid tnote plmid entrydate receive_date receive_time input_qty userid dsbid rnote input_backup prid dinstid rproqty dyeuid dinrmid grisid trollyno plid

* dinrmid plmid dyeuid transfernote transfer_date spnote userid receive_date receive_time mcid

* dinrmid plmid dyeuid transfernote transfer_date spnote userid receive_date receive_time

* dinrid dinrmid dinstid grisid trollyno input_qty

* dshid shade

* shiftid shift

* dinstid plmid stockqty grisid

* dinuserid dusername duseridno dusermobno

* dinid plmid userid insdate insokqty mcid dinuserid instime entrydate shiftid rollno trolyno rollwidth tfault_points point_sqyd result dinrid dshid plid dinstid rproqty inspection_notes gradding gradding_notes

* jobid

* docstid docstdesc

* docustid invomid docstid documentstdate docsysdate userid remarks

* dodid doid picid dqty

* doid dodate piid dgarid tranid drid mmid mmdate ppid

* inbid outbqty

* rcid gsid pocid rrcid rcno rcdate rcqty status

* rcno rootno

* rcsubid rcid subrcno subrcdate subrqty

* drid drname drphone dradd

* auid dsbid inbid tdate tqty userid

* emarid emarname emarfinishtype emarfinishstatus

* enduseid endusename

* fbfid fabfinish fabfinishtype fabfinishstatus

* fbpid fabprocess gdprocessid fbsname

* fabid artcode composition weave construction totalends reedcount reedspech pick warpcount weftcount wtofwarp wtofweft linearweight gsm oz width salvedge fabstatus

* fbstid rackid iopdid rollqty sqty fgsm fwidth userid rcvdate fremarks stock_status upduserid upd_date

* fabanid fab_an_code fab_rcv_date fab_dlv_date anbuyid mkt_person mkt_date fbfid emarid weaveid gdprocessid fabcompid warp_yarn1 warp1_fabcompid warp_yarn2 warp2_fabcompid warp_yarn3 warp3_fabcompid warp_yarn4 warp4_fabcompid weft_yarn1 weft1_fabcompid weft_yarn2 weft2_fabcompid weft_yarn3 weft3_fabcompid weft_yarn4 weft4_fabcompid ppi epi color_shade wash_status fab_crimper fab_crimper_weft an_fab_wt lycra_growth lycra_recovery lycra_elongation lycra_tear lycra_tensil slub_warp_length slub_warp_pause_lenght slub_warp_dia slub_weft_length slub_weft_pause_lenght slub_weft_dia filament_no_yarn_warp filament_no_yarn_weft entry_userid entry_date entry_comments check_userid check_date check_comments app_userid app_date app_comments rnd_warp_yarn1 rnd_warp1_fabcompid rnd_warp_yarn2 rnd_warp2_fabcompid rnd_warp_yarn3 rnd_warp3_fabcompid rnd_warp_yarn4 rnd_warp4_fabcompid rnd_weft_yarn1 rnd_weft1_fabcompid rnd_weft_yarn2 rnd_weft2_fabcompid rnd_weft_yarn3 rnd_weft3_fabcompid rnd_weft_yarn4 rnd_weft4_fabcompid rnd_epi rnd_ppi rnd_fabcompid rnd_an_fab_wt greige_width finish_width reed_space prizes rnd_userid rnd_upd_date ana_type iopmid

* fabcompid composition com_type

* flchid chid fabflid req_qty

* fabflid iopmid prid mcid pr_date before_greige_width after_greige_width mch_speed gen_temp ph pr_settings pr_temp1 pr_temp2 pr_temp3 pr_temp4 pr_temp5 pr_temp6 pr_temp7 pr_temp8 pr_temp9 pr_temp10 userid entry_date

* weaveid weavs

* finsid finsname

* flrid floor

* fspid userid poid spdate bookqty wlmid

* adid garid garaddress countid garcontract garphone garfax garemail status garcity

* garid garname garaddress countid garcontract garphone garfax garemail status garcity bin_no

* gwid gwname

* garconid garid contact_name contact_phone contact_email

* gddate gd_no enduse

* gdprocessid gdprocess activestatus

* subid subname gdprocessid

* gdsid gdsdate gdsqty

* gydid gdid ydcolor ydqty subref subrefdate iopmid reference devtype approval appdate ydwtg

* gd_acsid gdid userid acs_date acs_userid acs_udate acs_upuserid ac_status

* gdid gdjob buyid buycontract fabid gdprocess totalqty gddate gdreqdate gwidth fwidth cutwidth ggsm fgsm wrapyquality weftyquality warpcountprice weftcountprice market gdinspsystem gdnumbcolor spinst stid mmid mmdate srmmid srmmdate gmid gmdate gdrevno enduseid addqty refno refdate pappid pappdate spappid spappdate ttenwarp ttenweft yarncolorno costappid costappdate iomref unitid pisellprice gdsid ownerid acholder weft_yarnid warp_yarnid epi gepi ppi gdproceed_by gd_proceed_date ctnper subid sub_buyid sub_brid fab_cost emarid elongation growth recovery tensile_warp tensile_weft

* rgdid gdid gdrevno gdjob buyid buycontract fabid gdprocess totalqty revgddate gddate gdreqdate gwidth fwidth cutwidth ggsm fgsm wrapyquality weftyquality warpcountprice weftcountprice market gdinspsystem gdnumbcolor spinst stid mmid mmdate srmmid srmmdate gmid gmdate enduseid ttenwarp ttenweft yarncolorno costappid costappdate

* grid gsid ppid pocid fabid userid plmid rcv_challan_no wmid ysupid entrydate greigelotno yarnlotno receive_date gr_prod_date receive_time grcvqty grecvnot

* gsid plmid pocid fabid gsqty ginqty

* grissueid plmid grcvid refno greige_issue_date gr_issue input_date userid

* grcvid gdid wmid greige_rcv_date greige_challan yarnlotno greige_qty input_date userid

* grisid gsid plmid issue_qty issue_lot entry_date userid dyeuid

* grisdid grisid gsid plmid issue_qty entry_date userid

* gd_prodid gdid wmid prod_date prod_qty input_date userid

* gwmid gdid wmid wgdqty wgd_allownce greige_req_date input_date userid

* gwid gwidth

* gydid gdid warp_weft yarnid ysupid yqty refno refdate

* inbid dsrid dsbid pocid plmid prid rcid inbacherqty intranqty rcsubid indate intime userid tnote rpnum inshift inputnote inentrydate dinrid dinid

* invodid invomid picid dqty nroll

* invomid invono invdate lcdid drid tranid userid remarks

* ihdid ihid hdqty hdmid hdbid hprice

* ihid fbstid custcode hdate huser weight hwidth wtime wtemp hqty hqtym remarks gwid dg_ref gmt_ref fab_com_new orddid hncom_date hncom_user remarks_ncom gwid_com bfwelongation afwelongation bfwgrowth afwgrowth

* hdbid mbname mbaddress mbphone mbemail mdldate mdnote countid userid

* hdmid ideldate mnote mmid userid

* IOM COLOR iopmid

* iopdid iopmid styleref colorway labdipref labdiprefdate appshade ordqty iomtype

* iopmid buyid garid fabid fbpid lsid gwid enduseid iopno issuedate deliverydate ggsm fgsm testsid finsid devtype contactperson contactnumber mmid mmdate srmmid srmmdate dgmid gmdate rndmid rndappdate stid fbfid iomremarks gwidth fwidth warpyq weftyq iomtype achuid emarid yqcode edituser costingref costingref_date ownerid fabanid rep_iomno process_gwidth process_fwidth backp_userid backp_date backp_approval submission_ref submission_comments devdid contact_email development_purpose projection_required projection_qty negotiation_price oreder_placement_month development_reason greige_price payment_mood bfwelongation afwelongation bfwgrowth afwgrowth

* IOM No Rack No Color way Composition Weave Construction Fabric process Buyer Fabric finish Emarizing GSM Roll qty CURRENT STOCK QTY

* IOMNo iopmid RackNo Colorway iopdidupd Composition Weave Construction Fabricprocess Buyer Fabricfinish Emarizing GSM Rollqty CURRENT STOCK QTY

* jdlvid jdlvdate jdlvwmid jdlvchln jdlvpocid jdlvgarid jdlvqty jdlvexsqty jdlvwsrtqty jdlvrtqty jdlvdrid jdlvcomments jdlvuserid jdlventrydate

* lcamid lcamdate lcid lcno lcdate piid lcopenbid lcnegobid shipdate lcexpdate lcvalue lcpivalidity lcdelivery desc1 lcamuid

* lcdid lcid piid spl_piid pi_input_date piid_iom

* lcdaid lcaid piid

* lcid lcno lcdate piid lcopenbid lcnegobid shipdate lcexpdate lcvalue lcpivalidity tnrid desc1 explcno lcimage lcamimage lamentno lamentdate lcincvalue lcdecvalue euserid entrydate auserid aentrydate stid stnote lcptid

* lcaid lcid lcno lcdate lamentno lamentdate lcopenbid lcnegobid shipdate lcexpdate lcincvalue lcvalue lcdecvalue lcpivalidity lcdelivery desc1 lcimage lcamimage

* lcnegobid lcnegobank lcnegobranch

* lcopenbid lcopenbank lcopenbranch

* lc_catgid category_name

* lcptid pay_type ac_statys

* lsid lsname

* mcid machinename machineno prid flrid countid deptid mdcapacity

* mepuid mepuname

* mcid mcname mcnotes msl

* mcpid userid mcid mpid

* mpid mcid mpname mplink mpnotes mppops

* Prefix Category Description

* i

* orddid ordmid fbstid ordqty smpid sample_ordqty hanger_qty sewing_uid sewing_date

* ordmid ordno orderdate garid buyid contactperson contactno mmid mmdate srmmid srmmdate gmid gmdate remarks stuid studate otype srtype achuid contact_email prcnt ordertype ownerid greige_price payment_mood buyer_fab_ref

* plid pldate userid packing_list_no packing_list_note grisid plmid packinglist_comm

* packid dinid plmid userid grisid

* picid piid picdesc picustomer picstyle piccolor labdipref labdiprefdate labdipapp labdipappdate picqty picprice coating labdipappimg userid appdate iopdid gydid piiomordtypid iopmid

* picid_iom picid iopdid spl_qty picprice userid entrydate piid_iom picstyle coating

* pic_splid picid piid pldid spl_qty picprice userid entrydate spl_piid picstyle coating

* piid piissudate pirevno gdid garid bankid fbfid totalqty unitid pivalidity pidelivery pideliverydate fbpid cgsm commi picondition stid mmid mmdate srmmid srmmdate gmid gmdate buyfabref acholder piid_no iopmid adid garconid hscode ownerid cost_app cost_app_date net_wight gross_wight po_app po_app_date dimensional_stability warpshrinkage_pi weftshrinkage_pi

* piid_iom piissudate pirevno garid bankid fbfid totalqty unitid pivalidity pidelivery pideliverydate fbpid cgsm commi picondition stid mmid mmdate srmmid srmmdate gmid gmdate buyfabref acholder piid_no iopmid adid garconid hscode ownerid cost_app cost_app_date net_wight gross_wight po_app po_app_date dimensional_stability warpshrinkage_pi weftshrinkage_pi buyid sub_buyid sub_brid sale_types dollar_rate cutwidth

* picrivid picrivdate picid piid picdesc picustomer picstyle piccolor labdipref labdipapp picqty picprice coating labdipappimg pirivid

* pirivid pirivdate pirevno piid piissudate gdid garid bankid fbfid totalqty unitid pivalidity pidelivery pideliverydate fbpid cgsm commi picondition stid mmid mmdate srmmid srmmdate gmid gmdate acholder

* piiomordtypid piiomordtype piiomordtypsts

* pldid plmid prid mcid pdate pslno pocid plcqty

* plmid pocid pldate pentrydate plqty wtgper userid stid pst fabid piccolor labdipref labdipapp WONO wonotes dyeuserid directoruserid unitid tnaprid dyeuid greigercv labdipapproval qualityapproval ownerid

* pocid ppid picid djob ldsno ldsdate pocolorqty

* pocrid pocid picid pocolorqty pprivid

* ppid ppdate piid buyid emarid gwid lsid testsid enduseid finsid ppdelvdate wrapshrinkage weftshrinkage packing ppsample poqty stid mmid mmdate srmmid srmmdate gmid gmdate pprevno seclsid poinst porivdate ppid_no srkwid dyedlvdate dyecomment dyeuserid dyeappdate graydlvdate graycomment grayuserid grayappdate awgsm lcsts lcappid lcappdate unitid ownerid acholder rubbing_dry rubbing_wet

* pprivid pprivdate ppid ppdate piid buyid emarid gwid lsid testsid enduseid finsid ppdelvdate wrapshrinkage weftshrinkage packing ppsample stid mmid mmdate srmmid srmmdate gmid gmdate poqty poruid seclsid poinst porivdate pprevno srkwid dyedlvdate dyecomment dyeuserid dyeappdate graydlvdate graycomment grayuserid grayappdate

* prid pname pcataid pcatasubid process_types

* rackid deptid rackno

* smpid smpdate smpfabcode smpiomno smpcustomer smpconstruction smpcomposition smpfabrictype smpweave smpgsm smpoz smpcolor smpprocess smpfinish smprcvqty smpdlvqty smpbalqty smpsalfno smpday smpremarks smprebook smpactivity

* srkwid srkwname srkwnotes

* spblid spbldate spbglmgid spbluid spblgdprocessid spblqty

* spbgdid spbgddate spbgmgdid spbgduid spbgdprocessid spbgdqty

* spglid spgldate spglmgid spglgdprocessid spglqty

* spl_piid piid piissudate pirevno gdid garid bankid fbfid totalqty unitid pivalidity pidelivery pideliverydate fbpid cgsm commi picondition stid mmid mmdate srmmid srmmdate gmid gmdate buyfabref acholder piid_no iopmid adid garconid hscode ownerid cost_app cost_app_date net_wight gross_wight po_app po_app_date dimensional_stability warpshrinkage_pi weftshrinkage_pi

* stid stdesc

* sub_buyid buyid sub_buyer_name countid buyerid_sub

* sub_brid sub_buyid brand_name

* dinrmid dyeuid transfernote transfer_date spnote userid entrydate

* tnrid tenorname tenorval

* testsid testname

* dyeuid dyeuname

* tnaprid tnaprname tnaproctype tnabrush tnaleadday

* tnaprsid plmid dyeuid prid batchno inputqty input_date userid entry_date

* tnatempid tnaprid prid process_sequence req_days userid entry_date status

* commdid tnaid commid userid comm_date

* commid comments

* tnaid plmid tnatempid tna_date

* tranid tranname tranno trtyid

* trtyid typename

* unitid logo unitname exporttype headaddress factoryaddress unitabbr unit_bin fac_city ho_city fac_phone

* unitrngid unitid unitmonth unitminrange unitmaxrange unitlockrange unitstatus unituserid unitentrydate

* uapid apusername apassworkd

* usrmgtid umacholder umacmanager umuser umstartdate umenddate umstatus ownerid

* uspid wlmid userid spqty

* userid username fullname password degid phone email managerid deptid sign team joindate activate comments empuserid passupdate aprovlvid isacholder isaprovauthority user_ref usercode fab_ana_group iom_stock_upd

* empuserid empusername empfullname emppassword empdegid empphone empemail empmanagerid empdeptid empsign empteam empjoindate empactivate aprovlvid isacholder isaprovauthority

* id userid username email mobile ip_address created_at

* ownerid usercode uprivid owner_status userid

* uprivid uprivname

* vctid vctname

* id ent_date bugaid cus_type vctid address contract_person contract_number mepuid meeting_purpos_des meeting_recap action_plan follow_up acholder ent_user

* vcustid vevent_id vcust_name vcust_vcard visit_date userid

* vevent_id event_place events_fdate events_tdate

* vprodid vcustid ihid

* wmid wmillname wabbr waddress wcontactno wemail wmcapacity

* wkspblid wkspbldate wkspbglmgid wkspbluid wkspblgdprocessid wkspblqty

* wkspglid wkspgldate wkspglmgid wkspglgdprocessid wkspglqty

* wldid wlmid fbpid

* wlmid wtext wlqty wldqty

* woid

* yarnid yarncount yc ytp ycode

* ypid yarnid yprice pvalidity euid edate appuid appdate acstatus ypfor cpmid ybrand

* ysupid ysupname ysupabbr ysupadd ysupemail ysupphone ybagqty

选择表 acholderview advbank ana_buyer apitranshistory approval_level billpaysystem buyerinfo buyer_garments chamical_info costing costingvalue costpkratetab costprange costpricemaster costprocost cost_fabricdetail country customerpo deliverystatus deliveryterm delivery_new department designation desizebatcherdetail devlopment_dept dinspection dinspectionfaltmaster dinspectionfaultdet dinspectionfaultdet_t dinspectionrcv dinspectionrcv_master dinspectionrcv_master_t dinspectionrcv_t dinspectionshade dinspectionshift dinspectionstock dinspectionuser dinspection_t djobtab docstdate documentst dodetail domaster doutbview dprocessroot dprocessrootno dprocesssubroot driverdet dtranaudit emarizingdetail enduselist fabfinishdetail fabprocessdetail fabricdetail fabricstock fabric_analysis fabric_composition_details fabric_process_chemical fabric_process_flowchart fabric_weave_details finalinspectiondetail floordetail fspbooked garaddressinfo garments garmentswashdetail garments_contact_info gddate_enduse gdprocess gdprocess_sub gdsqtytable gdydcolordet gd_access greigedemand greigedemandrevise greigercv greigestock greige_fabric_issue_wo greige_fabric_received greige_issue greige_issue_det greige_production gweavmilldefine gwidthtab gyarndefine inputbatcherdetail invoicedetail invoicemaster iomhangerdelvery iomhangerinfo iomhdbuyerinfo iomhdmktinfo iom_new_color iopdetail iopmaster IOP_Stock_Final_Info iostckupd jhony_delivery lcamendmentdet lcdtail lcdtailbackup lcinfo lcinfobackup lcnegobank lcopenbank lc_category lc_paytype lightsourcedetail machineinfo meeting_purpose menucategory menupermission menuproduct Monthly_Stock_NG_Customized_Re_ num orderdetail ordermaster packinglist_info packing_list_t picolordetail picolordetail_iom picolordetail_split pidetail pidetail_iom pirivcolordetail pirivdetail pi_iom_ord_type plandetail planmaster pocolordetail pocolordetailrev podetail porivdetail processmaster rackdetail sample_arc shrink_wash spbookload spbookloadgd spgroupload split_pidetail status sub_buyerinfo sub_buyer_brand tdinspectionrcv_master tenordetail testsrandared tnadyeunit tnaprocess tnaprocess_input tnaprocess_templates tna_comments_details tna_comments_master tna_details transportdet transporttype unitdetail unitrange userapitab usermanagement userspqty usertable usertable_emp user_login_log user_order_owner user_priv visitor_cust_type visitor_report visit_customer_info visit_event_info visit_product_info weavmilldetail wkspbookload wkspgroupload workloadd workloadm wotab yarnmaster yarnprice yarnsupplierdetail . 选择字段
显示

条件

排序	递增	递减
添加为	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	文字 另一个字段
	选择表 acholderview advbank ana_buyer apitranshistory approval_level billpaysystem buyerinfo buyer_garments chamical_info costing costingvalue costpkratetab costprange costpricemaster costprocost cost_fabricdetail country customerpo deliverystatus deliveryterm delivery_new department designation desizebatcherdetail devlopment_dept dinspection dinspectionfaltmaster dinspectionfaultdet dinspectionfaultdet_t dinspectionrcv dinspectionrcv_master dinspectionrcv_master_t dinspectionrcv_t dinspectionshade dinspectionshift dinspectionstock dinspectionuser dinspection_t djobtab docstdate documentst dodetail domaster doutbview dprocessroot dprocessrootno dprocesssubroot driverdet dtranaudit emarizingdetail enduselist fabfinishdetail fabprocessdetail fabricdetail fabricstock fabric_analysis fabric_composition_details fabric_process_chemical fabric_process_flowchart fabric_weave_details finalinspectiondetail floordetail fspbooked garaddressinfo garments garmentswashdetail garments_contact_info gddate_enduse gdprocess gdprocess_sub gdsqtytable gdydcolordet gd_access greigedemand greigedemandrevise greigercv greigestock greige_fabric_issue_wo greige_fabric_received greige_issue greige_issue_det greige_production gweavmilldefine gwidthtab gyarndefine inputbatcherdetail invoicedetail invoicemaster iomhangerdelvery iomhangerinfo iomhdbuyerinfo iomhdmktinfo iom_new_color iopdetail iopmaster IOP_Stock_Final_Info iostckupd jhony_delivery lcamendmentdet lcdtail lcdtailbackup lcinfo lcinfobackup lcnegobank lcopenbank lc_category lc_paytype lightsourcedetail machineinfo meeting_purpose menucategory menupermission menuproduct Monthly_Stock_NG_Customized_Re_ num orderdetail ordermaster packinglist_info packing_list_t picolordetail picolordetail_iom picolordetail_split pidetail pidetail_iom pirivcolordetail pirivdetail pi_iom_ord_type plandetail planmaster pocolordetail pocolordetailrev podetail porivdetail processmaster rackdetail sample_arc shrink_wash spbookload spbookloadgd spgroupload split_pidetail status sub_buyerinfo sub_buyer_brand tdinspectionrcv_master tenordetail testsrandared tnadyeunit tnaprocess tnaprocess_input tnaprocess_templates tna_comments_details tna_comments_master tna_details transportdet transporttype unitdetail unitrange userapitab usermanagement userspqty usertable usertable_emp user_login_log user_order_owner user_priv visitor_cust_type visitor_report visit_customer_info visit_event_info visit_product_info weavmilldetail wkspbookload wkspgroupload workloadd workloadm wotab yarnmaster yarnprice yarnsupplierdetail .	选择字段