营业员编号：
db_data2('select a.sale_man from view_pos_sale_detail a where a.sheet_no=?',sheet_no)

批发销售单中显示支付金额（不含免付、预付）：
db_data2('select paid_amt from t_cust_accout_flow where sheet_no=?',sheet_no)

在收支费用表-收支明细里面添加一个计算列显示其它支出表里面的备注信息：
明细备注：db_data3('select mx_memo from t_visa_detail where sheet_no=? and fees_NO=? ',sheet_No,fees_No) 
单据备注：db_data2('select memo from t_visa_master where sheet_no=?',sheet_No)

批发销售单中添加件跟包的单位数量（只限两个单位）：
1、大包装的计算列：if(dec(db_data2(~"SELECT count(*) FROM t_item_unit WHERE item_no=?~",item_no))>1   , int(『数量小计』/dec(db_data2(~"SELECT isnull(item_pack,0) FROM t_item_unit WHERE item_no=? AND unit_type=1~",item_no))),0)
2、小单位的计算列：if(dec(db_data2(~"SELECT count(*) FROM t_item_unit WHERE item_no=?~",item_no))>1   , mod (sub_qty,dec(db_data2(~"SELECT isnull(item_pack,0) FROM t_item_unit WHERE item_no=? AND unit_type=1~",item_no))),sub_qty)
a、大包装数量后加单位：if(dec(db_data2(~"SELECT count(*) FROM t_item_unit WHERE item_no=?~",item_no))>1   , string(int(『数量小计』/dec(db_data2(~"SELECT isnull(item_pack,0) FROM t_item_unit WHERE item_no=? AND unit_type=1~",item_no))))+db_data2(~"SELECT item_unit_No FROM t_item_unit WHERE item_no=? AND unit_type=1~",item_no),~"~")