generator-lookupValue , generator-lookupTable

var s=lookupTable('QTY,REASON_DESCRIPTION','PURCHASE_APPLY_LINE.RECORDID',RECORDID);
_refreshv2('query.QTY',s.split(',')[0]);
_refreshv2('query.REASON_DESCRIPTION',uiDisplay(s.split(',')[1]));



/******************************************************************/


var s4='CUSTOMER_NO,PAYMENT_TERMS,TYPE,LEADTIME,REQUEST_SHIP_DATE,URGENT,TARGET_COMPLETION_DATE,QD_NO,CUSTOMER_PO_DATE,ENTRY_DATE,CUSTOMER_REQUIREMENT,EXTERNAL_SALES,INTERNAL_SALES,SIGNED_QD,SIGNED_CPO,SIGNED_SQD,END_USER,LQD_NO,PQD_NO,INTERNAL_SALES2,ISSUED_BY';

var s3=lookupTable(s4,'INBOX_HEADER.RECORDID',formResult);
var s4a=s4.split(',');
var s3a=s3.split(',');
for (i=0;i<=s4a.length;i++){
if (s3a[i]){_refreshv2('SALES_ORDER_HEAD.'+s4a[i],s3a[i].replace(/CoMmA/g,','));}

}



generator-lookup generator-findValue

{object}
0.26,SALES_ORDER_HEAD.CUSTOMER_NO,lookupValue,98%:50%:98%,15,Customer,,
{findValue}
SOURCE_TABLE=CUSTOMER,SOURCE_NAME=NAME,SOURCE_CODE=RECORDID
{/findValue}
{/object}




s1103x=_lookup('PURCHASE_HEADER.SALES_ORDER');

_refreshv2('view.uploadDocument',lookupTable('SIGNED_QD','SALES_ORDER_HEAD.SALES_ORDER',s1103x));




function lookupTable(_returnField,_tableField,_searchValue){
var _table=_tableField.split('.')[0];
var _field1103=_tableField.split('.')[1];
var r1103=''; 
var s1103='tableRead?table='+_table+'&fields='+_returnField
+'&where=where '+_field1103+': %60'+_searchValue +'%60&format=S&callback=?&db='+DATABASE;
$.getJSON(s1103,
function(data) {
if (data[0]){
r1103=data[0][0];
}
}
)
return r1103;
}