Get data from table with where dynamic
{object}
0.700,SALES_ORDER_HEAD.SOLUTION_NAME,combo,60%,100,Solution Name,,
{onfocusUpdateCombo}
{getJson}
tableReadCombo?table=SETTINGS&limit=999999&fields=CODE,DESCRIPTION&order=CODE&where=where(CODE_PARENT:`'+_lookup('SALES_ORDER_HEAD.SOLUTION_TYPE')+'`) &format=S,S&callback=?{/getJson}
{endOfLoad}
if(OPERATION.indexOf(",H5,")>-1 | OPERATION.indexOf("|H5|")>-1 ){
$(".SALES_ORDER_HEAD_SYSTEM_TYPE").multiselect("enable");
}
{/endOfLoad}
{enableWhenPartial}
{/object}
Get data from table with where constant
{object}
0.28,PRDTMSTR.CATEGORY,combo,10,40,Type,,
{spaceline}{draftMust}
{getJson}tableRead?table=SETTINGS&limit=999999&fields=RECORDID,description&where=where status:`D` AND DATA_GROUP:`itype`&format=S,S&callback=?{/getJson}
{/object}
{object}
0.60,VENDPROD.PM,combo,100%,20,Product Manager ,,
{spaceLine}
{getJson}
tableReadCombo?table=ADDRESS_BOOK&limit=999999&fields=RECORDID,NAME&order=NAME&where=where status:`A` and (true) &format=S,S&callback=?{/getJson}
{comboConstrain}PARENT_RECORDID=reference{/comboConstrain}
{reference}VENDPROD.VENDOR_NO{/reference}
{onfocusUpdateCombo}
{/object}
Get combo data from Memory
{object}
0.14,SALES_ORDER_HEAD.EXTERNAL_SALES,combo,58%:50%:98%,10,Sales Person,,
{combo},ALL,[EXTSALES]{/combo}
{draftMust}
{/object}
EXTSALES,CURS,UOMS,MANUS,STATUSS,PROPTS,CATS,PAYTS,MTYPES,STYPES,PAYMS
{object}
0.40,CODE.NATURE,combo,100%:200px:400px,50,NATURE,,{required}
{combo}
Accounts Payable,Accounts Payable
,Bank,Bank
,Cash Account,Cash Account
,Cost of Goods Sold,Cost of Goods Sold
,Current Liability,Current Liability
,Equity,Equity
,Expense,Expense
,Income,Income
,Long-term Liability,Long-term Liability
,Other Asset,Other Asset
,Other Income,Other Income
,Other Expense,Other Expense
,Payroll Liability,Payroll Liability
{/combo}
{spaceline}
{/object}
{object}
0.26,SALES_ORDER_HEAD.CUSTOMER_NO,combo,98%:50%:98%,15,Customer,,
{getJson} tableReadCombo?table=CUSTOMER&limit=999999&fields=RECORDID,NAME&order=NAME&where=where status:`A` and (true) &format=S,S&callback=?{/getJson}
{onfocusUpdateCombo}
{reference}SALES_ORDER_HEAD.CUSTOMER_NO{/reference}
{comboConstrain}1=1{/comboConstrain}
{draftMust}
{onChangeAjax}
TABLE=CUSTOMER
,FIELDS=ADDRESS1&ADDRESS1&ADDRESS1
&ADDRESS2&ADDRESS2&ADDRESS2
&ADDRESS3&ADDRESS3&ADDRESS3
&ADDRESS4&ADDRESS4&ADDRESS4
&NAME&NAME&NAME
&CONTACT&PHONE_NO
&CONTACT&PHONE_NO
&CONTACT&PHONE_NO
&PAYMENT_TERMS_CODE&PAYMENT_METHOD_CODE
&CONTACT&CONTACT&EMAIL&EMAIL
&EXTERNAL_SALES
&INTERNAL_SALES
&INTERNAL_SALES2
,UPDATES=
this..SELL_TO_ADDRESS1&this..BILL_TO_ADDRESS1&this..DELIVERY_TO_ADDRESS1
&this..SELL_TO_ADDRESS2&this..BILL_TO_ADDRESS2&this..DELIVERY_TO_ADDRESS2
&this..SELL_TO_ADDRESS3&this..BILL_TO_ADDRESS3&this..DELIVERY_TO_ADDRESS3
&this..SELL_TO_ADDRESS4&this..BILL_TO_ADDRESS4&this..DELIVERY_TO_ADDRESS4
&this..SALES_TO_COMPANY&this..BILL_TO_COMPANY&this..SHIP_TO_COMPANY
&this..SALES_TO_NAME&this..SALES_TO_TEL
&this..CUSTOMER_CONTACT1&this..BILL_TO_TEL
&this..CUSTOMER_CONTACT1_NAME&this..CUSTOMER_CONTACT1_TELEPHONE
&this..PAYMENT_TERMS&this..PAYMENT_METHOD
&this..SALES_TO_NAME&this..CUSTOMER_CONTACT1&this..SELL_TO_EMAIL&this..BILL_TO_EMAIL
&this..EXTERNAL_SALES-
&this..INTERNAL_SALES-
&this..INTERNAL_SALES2-
{/onChangeAjax}
{onChange}
setTimeout(function() {
var s0724=_lookup('SALES_ORDER_HEAD.PAYMENT_TERMS');
if(!s0724){_refreshv2('SALES_ORDER_HEAD.PAYMENT_TERMS','30 Days');}
},100);
{/onChange}
{refresh}currentEntity=_lookup('this.id');{/refresh}
{/object}
