[purchase] label = "存倉進貨報告" session_id[] = "prtPurchaseDetail" tbl_config[] = "40,100,20,20,20;存倉貨號,內容,數量,單價,金額;stock_no,content1,qty,cost,amt" session_id[] = "prtSumPurchaseDetail" tbl_config[] = "140,20,20,20;貨品總項,總數量,總成本,總額;sumOfStockNo,sumOfQty,sumOfCost,sumOfAmt" [returnedpurchase] label = "退貨報告" session_id[] = "prtReturnedPurchaseDetail" tbl_config[] = "40,60,20,20,20,20,20;存倉貨號,內容一,供應商,數量,單價,金額,存倉數;stock_no,content1,supplier_no,qty,cost,subtotal,stockqty" session_id[] = "prtSum_ReturnedPurchase" tbl_config[] = "120,40,20;貨品總項,總數量,總額;sumOfStockNo,sumOfQty,sumOfTotal" [transhistory] label = "交易記錄" session_id[] = "prtTranHistory" tbl_config[] = "20,22,20,28,15,20,20,15,15,15,17;存倉貨號,建立日期,分類,參考編號,數量,總成本,總單價,折扣,單價,成本,用戶;stock_no, confirmed_date, sub_cat, ref_no, qty, total_cost, amt, discount, retail_price, cost, username" [salesreport] label = "存倉訂貨報告" session_id[] = "prtSalesReport" tbl_config[] = "30,30,75,75,25,12,12,15,14,13;供應商,存倉貨號,內容1,內容2,類別,銷售數,存倉數,銷售總成本,單價,訂貨數;supplier_no,stock_no,content1,content2,cat,noofinvoice,stock_keep_qty,total_cost,retail_price,stock_order_qty" session_id[] = "prtDefaultIndentProduct" tbl_config[] = "30,30,75,75,25,12,12,15,14,13;預設訂貨表;supplier_no,stock_no,content1,content2,cat,noofinvoice,stock_keep_qty,amt,retail_price,stock_order_qty" session_id[] = "prtSumOfSalesReport" tbl_config[] = "32,32,22,22,27;共有存倉貨號,總銷售數,總存倉數,總訂貨數,總銷售成本;sumofstock_no,sumofnoofinvoice,sumofstock_keep_qty,sumofstock_order_qty,sumoftotal_cost;DISABLE_HIDDEN_FIELD" [dailyreport] label = "每日分析報告" session_id[] = "prtDailyReport" tbl_config[] = "32,28,20,20,20,30,20,20,20;時間,發票編號,用戶名稱,方式1,方式2,狀況,總金額,總成本,總利潤;datetime, invoice_no, username, PayMethod1, PayMethod2, state, actualprice, total_cost, profit" session_id[] = "prtSum_DailyReport" tbl_config[] = "148,20,20,20;總發票,總金額,總成本,總利潤;noofinvoice, total_amt, total_cost, total_profit"  [transreport] label = "時段交易分析" session_id[] = "prtTran_GByTime" tbl_config[] = "50,40,40,40,40;時間,發票數目,發票實收總金額,發票總成本,發票總利潤;datetime,noofinvoice,total_amount,total_cost,profit" session_id[] = "prtSum_Tran_GByTime" tbl_config[] = "50,40,40,40,40;總項,總發票,總金額,總成本,總利潤;nooftimelog,noofinvoice,total_amount,total_cost,profit" session_id[] = "prtTran_GByMethod" tbl_config[] = "40,40,40;付款方式,次數,金額;paymentmethod, noofinvoice, total_amount" session_id[] = "prtSum_Tran_GByMethod" tbl_config[] = "40,40,40;總項,總發票,總金額;noofpaymethod, noofinvoice, total_amount" session_id[] = "prtTran_GByCat" tbl_config[] = "40,40,40,40;類別,數量,總金額,總成本;cat, noofinvoice, total_amount, total_cost" session_id[] = "prtSum_Tran_GByCat" tbl_config[] = "40,40,40,40;總項,總數量,總金額,總成本;noofcat, noofinvoice, total_amount, total_cost" [monthlyreport] label = "每月分析" session_id[] = "prtMonthly_report" tbl_config[] = "40,20,20,20,25,25,25,25;日期,星期,發票數目,總金額,總成本,總利潤,進貨單數目,進貨總金額;datetime, weekday, noofinvoice, total_amt, total_cost, total_profit, noofpurchase, total_purchase_amt" session_id[] = "prtSum_Monthly_report" tbl_config[] = "60,20,20,25,25,25,25;總截數日,發票總數量,總金額,總成本,總利潤,進貨單總數目,進貨總金額;noofcutoffday, noofinvoice, total_amt, total_cost, total_profit, noofpurchase, total_purchase_amt" [monthlypaymentreport] label = "每月付款分析" session_id[] = "prtMonthly_payment_report" tbl_config[] = "26,8,18,23,23,23,23,23,23,23,23,23,23,12;日期,星期,AE,CASH,EPS,MASTER,VISA,GiftCard,Union Pay,OCTOPUS,WeChatPay,OTHER,總金額,會員卡;datetime, weekday, ae, cash, eps, master, visa, gift_card, union_pay, octopus, WeChatPay, other, total_amt, mem_card" session_id[] = "prtSum_Monthly_payment_report" tbl_config[] = "20,20,24,24,24,24,24,24,24,24,24,24,16;總截數日,AE,CASH,EPS,MASTER,VISA,GiftCard,UnionPay,OCTOPUS,WeChatPay,OTHER,總金額,會員卡;noofcutoffday, ae, cash, eps, master, visa, gift_card, union_pay, octopus, WeChatPay, other, total_amt, mem_card" [monthlycatreport] label = "每月貨品類別分析" session_id[] = "prtMonthly_cat_report" tbl_config[] = "40,40,40,40,40;類別,數量,總金額,總成本,總利潤;cat, noofinvoice, total_amount, total_cost, profit" session_id[] = "prtSum_Monthly_cat_report" tbl_config[] = "40,40,40,40,40;共有類別,總數量,總金額,總成本,總利潤;noofcat, noofinvoice, total_amount, total_cost, profit" [hotproduct] label = "流行貨品分析" session_id[] = "prtHotProduct" tbl_config[] = "40,100,30,20;存倉貨號,內容1,類別,銷售數量;stock_no,content1,cat,noofinvoice" [purchasereport] label = "進貨報表" session_id[] = "prtPurchaseReport" tbl_config[] = "40,90,25,20,20;存倉貨號,內容1,類別,進貨數量,總金額;stock_no,content1,cat,noofpurchase,total_amount" [stagnantreport] label = "呆貨報表" session_id[] = "prtStagnantReport" tbl_config[] = "40,90,25,20,20;存倉貨號,內容1,供應商,類別,數量;stock_no,content1,supplier_no,cat,stock_keep_qty" [specialofferstock] label = "特價類別" session_id[] = "prtSpecialOfferStock" tbl_config[] = "30,70,25,20,17,20,14,14;存倉貨號,內容1,供應商,類別,數量,特價類別,買滿,特價;stock_no,content1,supplier_no,cat,stock_keep_qty,special_offer_id,sp_or_qty,sp_or_price" [categoryreport] label = "貨品類別報表" session_id[] = "exCategoryReport" tbl_config[] = "60,50,80;類別,總數量,總成本;cat,qtysum,amtsum" [specialofferhistory] label = "特價貨品銷售記錄" session_id[] = "prtSpecialOfferHistory" tbl_config[] = "30,70,25,20,17,20,14,14;存倉貨號,內容1,供應商,類別,銷售數,特價類別,買滿,特價;stock_no,content1,supplier_no,cat,qty,special_offer_id,sp_or_qty,sp_or_price" [prtstocktake] label = "盤點紀錄" session_id[] = "prtstocktake" tbl_config[] = "50,30,60,20,17,20,14;盤點時間,存倉貨號,內容,類別,數量,成本,總成本;stock_take_date,stock_no,content1,cat,qty,cost,total_cost"