{"id":733,"date":"2023-06-19T23:18:22","date_gmt":"2023-06-19T15:18:22","guid":{"rendered":"https:\/\/www.furyblog.com\/?p=733"},"modified":"2023-07-12T10:36:24","modified_gmt":"2023-07-12T02:36:24","slug":"%e9%80%9a%e8%bf%87sql%e6%9f%a5%e8%af%a2%e6%b3%9b%e5%be%ae%e9%83%a8%e9%97%a8%e5%b9%b4%e5%ba%a6%e9%a2%84%e7%ae%97%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/www.furyblog.com\/?p=733","title":{"rendered":"\u901a\u8fc7SQL\u67e5\u8be2\u6cdb\u5fae\u90e8\u95e8\u5e74\u5ea6\u9884\u7b97\u4fe1\u606f"},"content":{"rendered":"\n

\u516c\u53f8\u4e0a\u8d39\u7528\u63a7\u5236\u7cfb\u7edf\u540e\uff0c\u6cdb\u5fae\u81ea\u5e26\u7684\u62a5\u8868\u6743\u9650\u63a7\u5236\u592a\u8db3\u4e86\uff0c\u4e0d\u65b9\u4fbf\u67e5\u8be2\uff0c\u4e8e\u662f\u6839\u636e\u73b0\u6709\u8868\u7ed3\u6784\u5199\u4e86\u8fd9\u4e2a\u67e5\u8be2\uff0c\u53ef\u4ee5\u67e5\u8be2\u90e8\u95e8\u5f53\u524d\u751f\u6548\u7684\u9884\u7b97\u4fe1\u606f\uff0c\u5305\u62ec\u79d1\u76ee\u3001\u603b\u9884\u7b97\u548c\u5df2\u7528\u9884\u7b97\uff0c\u5176\u4e2d\u5df2\u7528\u9884\u7b97\u5173\u8054\u62a5\u9500\u3001\u9884\u63d0\u7684\u76f8\u5173\u6d41\u7a0b\u3002<\/p>\n\n\n\n

SELECT\n\t\u5e74\u5ea6,\u5206\u90e8,\u90e8\u95e8,\u79d1\u76ee,\n\tSUM ( \u9884\u7b97\u91d1\u989d ) AS \u9884\u7b97 ,\n\tb1.[\u5df2\u7528\u91d1\u989d],\n\tSUM ( \u9884\u7b97\u91d1\u989d ) - b1.[\u5df2\u7528\u91d1\u989d] AS \u53ef\u7528\u91d1\u989d,\n\tb1.[\u5ba1\u6279\u4e2d\u91d1\u989d]\nFROM\n\t(\n\tSELECT\n\t\tt5.fnayear AS \u5e74\u5ea6,\n\t\tt4.subcompanyname AS \u5206\u90e8,\n\t\tt2.departmentname AS \u90e8\u95e8,\n\t\tt3.name AS \u79d1\u76ee,\n\t\tFnaBudgetInfoDetail.budgetaccount AS \u9884\u7b97\u91d1\u989d ,\n\t\tSUM ( t6.amount ) AS \u5df2\u7528\u91d1\u989d,\n\t\tSUM(CASE WHEN t6.status = 0 THEN t6.amount ELSE 0 END) AS \u5ba1\u6279\u4e2d\u91d1\u989d\n\tFROM\n\t\tFnaBudgetInfoDetail\n\t\tLEFT JOIN FnaBudgetInfo t1 ON t1.id= FnaBudgetInfoDetail.budgetinfoid\n\t\tLEFT JOIN hrmdepartment t2 ON t2.id = t1.budgetorganizationid\n\t\tLEFT JOIN FnaBudgetfeeType t3 ON t3.id = FnaBudgetInfoDetail.budgettypeid\n\t\tLEFT JOIN HrmSubCompany t4 ON t4.id = t2.subcompanyid1\n\t\tLEFT JOIN FnaYearsPeriods t5 ON t5.id = FnaBudgetInfoDetail.budgetperiods\n\t\tLEFT JOIN FnaExpenseInfo t6 ON t6.organizationid = t1.budgetorganizationid \n\t\tAND t6.subject = FnaBudgetInfoDetail.budgettypeid \n\tWHERE\n\t\tt1.status = 1 --\u9884\u7b97\u751f\u6548\u6807\u5fd7\n\t\t\n\t\tAND t5.id = 3 --\u8d26\u5957\u5e74\u5ea6\u4ee3\u7801\u6807\u5fd7l\n\t\t\n\t\tAND t4.id IN ( 15, 850, 396, 397 ) -- \u5206\u90e8\u6807\u5fd7\n\t\t\n\t\tAND t1.budgetorganizationid = 1574 --\u90e8\u95e8\u6807\u5fd7\n\t\t\n\t\tAND t6.budgetperiods = 3 --\u8d26\u5957\u5e74\u5ea6\u4ee3\u7801\u6807\u5fd7\n\t\t\n\tGROUP BY\n\t\tt5.fnayear,\n\t\tt4.subcompanyname,\n\t\tt2.departmentname,\n\t\tt3.name,\n\t\tFnaBudgetInfoDetail.budgetperiodslist,\n\t\tFnaBudgetInfoDetail.budgetaccount \n\t) b1 \nGROUP BY\n\tb1.[\u5e74\u5ea6],\n\tb1.[\u5206\u90e8],\n\tb1.[\u90e8\u95e8],\n\tb1.[\u79d1\u76ee],\n\tb1.[\u5df2\u7528\u91d1\u989d],\n\tb1.[\u5ba1\u6279\u4e2d\u91d1\u989d]\nORDER BY\n\tb1.[\u5206\u90e8],\n\tb1.[\u90e8\u95e8],\n\tb1.[\u79d1\u76ee]\n<\/code><\/pre>\n\n\n\n
\u8be5\u67e5\u8be2\u4e2d\u5173\u8054\u7684\u8868\u7ed3\u6784\u5982\u4e0b\uff1a<\/p>\n\n\n\n
fnabudgetinfodetail\/\u90e8\u95e8\u9884\u7b97\u4fe1\u606f\u660e\u7ec6\u8868<\/p>\n\n\n\n
\u5e8f\u53f7<\/td>\u4e2d\u6587\u540d\u79f0<\/td>\u82f1\u6587\u540d\u79f0<\/td>\u6570\u636e\u7c7b\u578b<\/td>\u957f\u5ea6<\/td>\u5141\u8bb8\u7a7a\u503c<\/td>\u4e3b\u952e<\/td>\u9ed8\u8ba4\u503c<\/td>\u81ea\u589e<\/td>\u8bf4\u660e<\/td><\/tr><\/thead>
1<\/td>\u4e3b\u952e<\/td>id<\/td>int<\/td><\/td>N<\/td>Y<\/td><\/td>Y<\/td><\/td><\/tr>
2<\/td>\u90e8\u95e8\u9884\u7b97\u4fe1\u606fid<\/td>budgetinfoid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
3<\/td>\u5e74\u5ea6\u671f\u95f4ID<\/td>budgetperiods<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u9884\u7b97\u5e74\u5ea6\u8868\u4e3b\u952e<\/td><\/tr>
4<\/td>\u79d1\u76eeid<\/td>budgettypeid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
5<\/td>\u4eba\u5458id<\/td>budgetresourceid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u9884\u7b97\u76f8\u5173\u4eba\u529b\u8d44\u6e90<\/td><\/tr>
6<\/td>\u5ba2\u6237id<\/td>budgetcrmid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u9884\u7b97\u76f8\u5173\u5ba2\u6237<\/td><\/tr>
7<\/td>\u9879\u76eeid<\/td>budgetprojectid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u9884\u7b97\u76f8\u5173\u9879\u76ee<\/td><\/tr>
8<\/td>\u91d1\u989d<\/td>budgetaccount<\/td>decimal<\/td>18,2<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
9<\/td>\u5907\u6ce8<\/td>budgetremark<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
10<\/td>\u671f\u95f4id<\/td>budgetperiodslist<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u9884\u7b97\u671f\u95f4\u8868\u4e3b\u952e<\/td><\/tr>
11<\/td>\u504f\u5dee\u91d1\u989d<\/td>fnaIncrement<\/td>decimal<\/td>18,2<\/td><\/td><\/td><\/td><\/td>\u5f53\u524d\u7248\u672c\u4e0e\u4e0a\u4e00\u7248\u672c\u7684\u5dee\u989d\uff0c\u8bb0\u5f55\u53ef\u80fd\u5b58\u5728\u7a7a\u6570\u636e\uff0c\u7a7a\u8bf7\u8f6c\u6362\u62100\uff1b
\u6ce8\uff1a\u76ee\u524d\u53ea\u6709\u7ed3\u8f6c\u7c7b\u578b\u7684\u64cd\u4f5c\u4f1a\u8bb0\u5f55\u8be5\u6570\u503c\uff0c\u6b63\u5e38\u7f16\u5236\u751f\u6210\u7684\u7248\u672c\u8be5\u6570\u503c\u7b49\u4e8e0\uff1b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
fnabudgetinfo\/\u90e8\u95e8\u9884\u7b97\u4fe1\u606f\u8868<\/p>\n\n\n\n
\u5e8f\u53f7<\/td>\u4e2d\u6587\u540d\u79f0<\/td>\u82f1\u6587\u540d\u79f0<\/td>\u6570\u636e\u7c7b\u578b<\/td>\u957f\u5ea6<\/td>\u5141\u8bb8\u7a7a\u503c<\/td>\u4e3b\u952e<\/td>\u9ed8\u8ba4\u503c<\/td>\u81ea\u589e<\/td>\u8bf4\u660e<\/td><\/tr><\/thead>
1<\/td>\u4e3b\u952e<\/td>id<\/td>int<\/td><\/td>N<\/td>Y<\/td><\/td>Y<\/td><\/td><\/tr>
2<\/td>\u9884\u7b97\u72b6\u6001<\/td>budgetstatus<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>0\uff1a\u672a\u5ba1\u6279\uff1b 1\uff1a\u5df2\u5ba1\u6279\uff1b<\/td><\/tr>
3<\/td>\u521b\u5efa\u4ebaid<\/td>createrid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
4<\/td>\u5ba1\u6279\u4ebaid<\/td>approverid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u901a\u8fc7\u5ba1\u6279\u6d41\u7a0b\u751f\u6548\u7684\u9884\u7b97\u624d\u6709\u6570\u636e<\/td><\/tr>
5<\/td>\u5ba1\u6279\u65e5\u671f<\/td>approverdate<\/td>char<\/td>10<\/td><\/td><\/td><\/td><\/td>\u901a\u8fc7\u5ba1\u6279\u6d41\u7a0b\u751f\u6548\u7684\u9884\u7b97\u624d\u6709\u6570\u636e<\/td><\/tr>
6<\/td>\u7ec4\u7ec7ID<\/td>budgetorganizationid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u5206\u90e8\uff1a\u5206\u90e8id\uff1b \u90e8\u95e8\uff1a\u90e8\u95e8id\uff1b \u4eba\u5458\uff1a\u4eba\u5458id\uff1b \u6210\u672c\u4e2d\u5fc3\uff1a\u6210\u672c\u4e2d\u5fc3id\uff1b<\/td><\/tr>
7<\/td>\u7ec4\u7ec7ID\u7c7b\u578b<\/td>organizationtype<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>0\uff1a\u603b\u90e8\uff1b 1\uff1a\u5206\u90e8\uff1b 2\uff1a\u90e8\u95e8\uff1b 18004\uff1a\u6210\u672c\u4e2d\u5fc3\uff1b<\/td><\/tr>
8<\/td>\u5e74\u5ea6\u671f\u95f4ID<\/td>budgetperiods<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u9884\u7b97\u5e74\u5ea6\u8868\u4e3b\u952e<\/td><\/tr>
9<\/td>\u7248\u672c<\/td>revision<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
10<\/td>\u72b6\u6001<\/td>status<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>0 \uff1a\u8349\u7a3f\uff1b1 \uff1a\u751f\u6548\uff1b2 \uff1a\u5386\u53f2\uff1b3 \uff1a\u5f85\u5ba1\u6279\uff1b<\/td><\/tr>
11<\/td>\u5907\u6ce8<\/td>remark<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
12<\/td>\u521b\u5efa\u65e5\u671f<\/td>createdate<\/td>char<\/td>20<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
14<\/td>\u751f\u6210\u65b9\u5f0f<\/td>opType<\/td>char<\/td>1<\/td><\/td><\/td><\/td><\/td>j\uff1a\u7ed3\u8f6c\uff1b\u7a7a\uff1a\u7f16\u5236\uff1b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
hrmdepartment\/\u4eba\u529b\u8d44\u6e90\u90e8\u95e8\u8868<\/p>\n\n\n\n
\u5e8f\u53f7<\/td>\u4e2d\u6587\u540d\u79f0<\/td>\u82f1\u6587\u540d\u79f0<\/td>\u6570\u636e\u7c7b\u578b<\/td>\u957f\u5ea6<\/td>\u5141\u8bb8\u7a7a\u503c<\/td>\u4e3b\u952e<\/td>\u9ed8\u8ba4\u503c<\/td>\u81ea\u589e<\/td>\u8bf4\u660e<\/td><\/tr><\/thead>
1<\/td>ID<\/td>id<\/td>int<\/td><\/td>N<\/td>Y<\/td><\/td>Y<\/td>\u3000<\/td><\/tr>
2<\/td>\u90e8\u95e8\u6807\u8bc6<\/td>departmentmark<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
3<\/td>\u90e8\u95e8\u540d\u79f0<\/td>departmentname<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
4<\/td>\u6240\u5c5e\u5206\u90e81<\/td>subcompanyid1<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
5<\/td>\u4e0a\u7ea7\u90e8\u95e8id<\/td>supdepid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
6<\/td>\u6240\u6709\u4e0a\u7ea7\u90e8\u95e8id<\/td>allsupdepid<\/td>varchar<\/td>2000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
7<\/td>\u663e\u793a\u987a\u5e8f<\/td>showorder<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
8<\/td>\u5c01\u5b58\u6807\u8bc6<\/td>canceled<\/td>char<\/td>1<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
9<\/td>\u90e8\u95e8\u7f16\u7801<\/td>departmentcode<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
10<\/td>\u534f\u529e\u4eba<\/td>coadjutant<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
11<\/td>\u7ec4\u7ec7\u67b6\u6784\u90e8\u95e8\u8d1f\u8d23\u4eba<\/td>zzjgbmfzr<\/td>varchar<\/td>4000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
12<\/td>\u7ec4\u7ec7\u67b6\u6784\u90e8\u95e8\u5206\u7ba1\u9886\u5bfc<\/td>zzjgbmfgld<\/td>varchar<\/td>4000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
13<\/td>\u77e9\u9635\u7ba1\u7406\u90e8\u95e8\u8d1f\u8d23\u4eba<\/td>jzglbmfzr<\/td>varchar<\/td>4000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
14<\/td>\u77e9\u9635\u7ba1\u7406\u90e8\u95e8\u5206\u7ba1\u9886\u5bfc<\/td>jzglbmfgld<\/td>varchar<\/td>4000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
15<\/td>\u77e9\u9635\u90e8\u95e8\u8d1f\u8d23\u4eba\u5458<\/td>bmfzr<\/td>text<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
16<\/td>\u77e9\u9635\u90e8\u95e8\u5206\u7ba1\u9886\u5bfc<\/td>bmfgld<\/td>text<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
17<\/td><\/td>outkey<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
18<\/td><\/td>budgetAtuoMoveOrder<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
19<\/td><\/td>ecology_pinyin_search<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
20<\/td><\/td>tlevel<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
fnabudgetfeetype\/\u9884\u7b97\u79d1\u76ee\u5b9a\u4e49\u8868<\/p>\n\n\n\n
\u5e8f\u53f7<\/td>\u4e2d\u6587\u540d\u79f0<\/td>\u82f1\u6587\u540d\u79f0<\/td>\u6570\u636e\u7c7b\u578b<\/td>\u957f\u5ea6<\/td>\u5141\u8bb8\u7a7a\u503c<\/td>\u4e3b\u952e<\/td>\u9ed8\u8ba4\u503c<\/td>\u81ea\u589e<\/td>\u8bf4\u660e<\/td><\/tr><\/thead>
1<\/td>\u4e3b\u952e<\/td>id<\/td>int<\/td><\/td>N<\/td>Y<\/td><\/td>Y<\/td><\/td><\/tr>
2<\/td>\u540d\u79f0<\/td>name<\/td>varchar<\/td>400<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
3<\/td>\u63cf\u8ff0<\/td>description<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
4<\/td>\u9884\u7b97\u5468\u671f<\/td>feeperiod<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>1\uff1a\u6708\u5ea6\uff1b2\uff1a\u5b63\u5ea6\uff1b3\uff1a\u534a\u5e74\u5ea6\uff1b4\uff1a\u5e74\u5ea6\uff1b<\/td><\/tr>
5<\/td>\u79d1\u76ee\u79cd\u7c7b<\/td>feetype<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>1\uff1a\u6536\u5165\uff1b 2\uff1a\u652f\u51fa<\/td><\/tr>
6<\/td>\u5141\u8bb8\u504f\u5dee<\/td>agreegap<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u767e\u5206\u6bd4<\/td><\/tr>
7<\/td>\u79d1\u76ee\u7ea7\u522b<\/td>feelevel<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>1\uff1a \u4e00\u7ea7\u79d1\u76ee\uff1b2\uff1a \u4e8c\u7ea7\uff1b3\uff1a \u4e09\u7ea7\uff1b<\/td><\/tr>
8<\/td>\u7236\u7ea7\u79d1\u76eeid<\/td>supsubject<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
9<\/td>\u9884\u8b66\u503c<\/td>alertvalue<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u767e\u5206\u6bd4<\/td><\/tr>
10<\/td>\u5c01\u5b58<\/td>Archive<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>0\u3001NULL\uff1a\u672a\u5c01\u5b58\uff1b1\uff1a\u5c01\u5b58\uff1b<\/td><\/tr>
15<\/td>\u7edf\u4e00\u8d39\u63a7<\/td>groupCtrl<\/td>char<\/td>1<\/td><\/td><\/td><\/td><\/td>\u9884\u7b97\u63a7\u5236\u65f6\u6c47\u603b\u4e0b\u7ea7\u79d1\u76ee\u8d39\u7528\u8fdb\u884c\u7edf\u4e00\u63a7\u5236<\/td><\/tr>
17<\/td>\u79d1\u76ee\u7f16\u7801<\/td>codeName<\/td>char<\/td>100<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
18<\/td>\u662f\u5426\u7ed3\u8f6c<\/td>budgetAutoMove<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u5f53\u524d\u79d1\u76ee\u662f\u5426\u8fdb\u884c\u7ed3\u8f6c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
hrmsubcompany\/\u5206\u90e8\u4fe1\u606f\u8868<\/p>\n\n\n\n
\u5e8f\u53f7<\/td>\u4e2d\u6587\u540d\u79f0<\/td>\u82f1\u6587\u540d\u79f0<\/td>\u6570\u636e\u7c7b\u578b<\/td>\u957f\u5ea6<\/td>\u5141\u8bb8\u7a7a\u503c<\/td>\u4e3b\u952e<\/td>\u9ed8\u8ba4\u503c<\/td>\u81ea\u589e<\/td>\u8bf4\u660e<\/td><\/tr><\/thead>
1<\/td>ID<\/td>id<\/td>int<\/td><\/td>N<\/td>Y<\/td><\/td>Y<\/td>\u3000<\/td><\/tr>
2<\/td>\u5206\u90e8\u7b80\u79f0<\/td>subcompanyname<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
3<\/td>\u5206\u90e8\u63cf\u8ff0<\/td>subcompanydesc<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
4<\/td>\u6240\u5c5e\u603b\u90e8id<\/td>companyid<\/td>tinyint<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
5<\/td>\u4e0a\u7ea7\u5206\u90e8ID<\/td>supsubcomid<\/td>int<\/td><\/td><\/td><\/td>0<\/td><\/td>\u3000<\/td><\/tr>
6<\/td>\u3000<\/td>url<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
7<\/td>\u5e8f\u5217\u53f7<\/td>showorder<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
8<\/td>\u5c01\u5b58\u6807\u8bc6<\/td>canceled<\/td>char<\/td>1<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
9<\/td>\u5206\u90e8\u7f16\u7801<\/td>subcompanycode<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
10<\/td>\u3000<\/td>outkey<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
11<\/td><\/td>budgetAtuoMoveOrder<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
12<\/td>\u62fc\u97f3<\/td>ecology_pinyin_search<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr>
13<\/td>\u9650\u5236\u7528\u6237\u6570<\/td>limitUsers<\/td>int<\/td><\/td><\/td><\/td>0<\/td><\/td>\u3000<\/td><\/tr>
14<\/td>\u7b49\u7ea7<\/td>tlevel<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u3000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
fnayearsperiods\/\u9884\u7b97\u5e74\u5ea6\u8868<\/p>\n\n\n\n
\u5e8f\u53f7<\/td>\u4e2d\u6587\u540d\u79f0<\/td>\u82f1\u6587\u540d\u79f0<\/td>\u6570\u636e\u7c7b\u578b<\/td>\u957f\u5ea6<\/td>\u5141\u8bb8\u7a7a\u503c<\/td>\u4e3b\u952e<\/td>\u9ed8\u8ba4\u503c<\/td>\u81ea\u589e<\/td>\u8bf4\u660e<\/td><\/tr><\/thead>
1<\/td>\u4e3b\u952e<\/td>id<\/td>int<\/td><\/td>N<\/td>Y<\/td><\/td>Y<\/td><\/td><\/tr>
2<\/td>\u5e74\u5ea6<\/td>fnayear<\/td>char<\/td>4<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
3<\/td>\u5f00\u59cb\u65e5\u671f<\/td>startdate<\/td>char<\/td>10<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
4<\/td>\u7ed3\u675f\u65e5\u671f<\/td>enddate<\/td>char<\/td>10<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
6<\/td>\u72b6\u6001<\/td>status<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>0\uff1a \u672a\u751f\u6548\uff1b1 \uff1a\u751f\u6548\uff1b-1\uff1a \u5173\u95ed\uff1b\u9ed8\u8ba4\u4e3a0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
fnaexpenseinfo\/\u8d39\u7528\u8868<\/p>\n\n\n\n
\u5e8f\u53f7<\/td>\u4e2d\u6587\u540d\u79f0<\/td>\u82f1\u6587\u540d\u79f0<\/td>\u6570\u636e\u7c7b\u578b<\/td>\u957f\u5ea6<\/td>\u5141\u8bb8\u7a7a\u503c<\/td>\u4e3b\u952e<\/td>\u9ed8\u8ba4\u503c<\/td>\u81ea\u589e<\/td>\u8bf4\u660e<\/td><\/tr><\/thead>
1<\/td>\u4e3b\u952e<\/td>id<\/td>int<\/td><\/td>N<\/td><\/td><\/td>Y<\/td><\/td><\/tr>
2<\/td>\u627f\u62c5\u4e3b\u4f53id<\/td>organizationid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u5206\u90e8id\uff1b\u90e8\u95e8id\uff1b\u4e2a\u4ebaid\uff1b\u6210\u672c\u4e2d\u5fc3id\uff1b<\/td><\/tr>
3<\/td>\u627f\u62c5\u4e3b\u4f53\u7c7b\u578b<\/td>organizationtype<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>1\uff1a\u5206\u90e8\uff1b2\uff1a\u90e8\u95e8\uff1b3\uff1a\u4e2a\u4eba\uff1b18004\uff1a\u6210\u672c\u4e2d\u5fc3\uff1b<\/td><\/tr>
4<\/td>\u8d39\u7528\u53d1\u751f\u65e5\u671f<\/td>occurdate<\/td>char<\/td>10<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
5<\/td>\u91d1\u989d<\/td>amount<\/td>decimal<\/td>15,3<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
6<\/td>\u79d1\u76eeid<\/td>subject<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
7<\/td>\u72b6\u6001<\/td>status<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>0\uff1a\u5ba1\u6279\u4e2d\uff1b1\uff1a\u751f\u6548\uff1b<\/td><\/tr>
8<\/td>\u6765\u6e90\u7c7b\u578b<\/td>type<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>1\uff1a\u4ed8\u6b3e\uff1b2\uff1a\u62a5\u9500\uff1b3\uff1a\u51b2\u9500\uff1b<\/td><\/tr>
9<\/td>\u9879\u76eeid<\/td>relatedprj<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u76f8\u5173\u9879\u76ee<\/td><\/tr>
10<\/td>\u5ba2\u6237id<\/td>relatedcrm<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u76f8\u5173\u5ba2\u6237<\/td><\/tr>
11<\/td>\u51ed\u8bc1\u53f7<\/td>debitremark<\/td>varchar<\/td>400<\/td><\/td><\/td><\/td><\/td>\u624b\u5de5\u505a\u8d26\u65f6\u624d\u4f1a\u5f55\u5165<\/td><\/tr>
12<\/td>\u63cf\u8ff0<\/td>description<\/td>varchar<\/td>1000<\/td><\/td><\/td><\/td><\/td><\/td><\/tr>
13<\/td>\u6d41\u7a0brequestid<\/td>requestid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u7edf\u8ba1\u7528\u6d41\u7a0brequestid<\/td><\/tr>
15<\/td>\u6d41\u7a0b\u660e\u7ec6\u8868id<\/td>requestidDtlId<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u7edf\u8ba1\u7528\u6d41\u7a0b\u660e\u7ec6\u8868id<\/td><\/tr>
16<\/td>\u6d41\u7a0b\u660e\u7ec6\u8868\u5e8f\u53f7<\/td>sourceDtlNumber<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u8bb0\u5f55\u6765\u6e90\u660e\u7ec6\u8868\u5e8f\u53f7<\/td><\/tr>
17<\/td>\u6d41\u7a0brequestid<\/td>sourceRequestid<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u6765\u6e90\u6d41\u7a0brequestid<\/td><\/tr>
18<\/td>\u6d41\u7a0b\u660e\u7ec6\u8868id<\/td>sourceRequestidDtlId<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u8bb0\u5f55\u6765\u6e90\u6d41\u7a0b\u660e\u7ec6\u8868id<\/td><\/tr>
19<\/td>\u5e74\u5ea6\u671f\u95f4ID<\/td>budgetperiods<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u8d39\u7528\u53d1\u751f\u65e5\u671f\u6240\u5c5e\uff1a\u9884\u7b97\u5e74\u5ea6\u8868\u4e3b\u952e<\/td><\/tr>
20<\/td>\u671f\u95f4id<\/td>budgetperiodslist<\/td>int<\/td><\/td><\/td><\/td><\/td><\/td>\u8d39\u7528\u53d1\u751f\u65e5\u671f\u6240\u5c5e\uff1a\u9884\u7b97\u671f\u95f4\u8868\u4e3b\u952e<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"
\u516c\u53f8\u4e0a\u8d39\u7528\u63a7\u5236\u7cfb\u7edf\u540e\uff0c\u6cdb\u5fae\u81ea\u5e26\u7684\u62a5\u8868\u6743\u9650\u63a7\u5236\u592a\u8db3\u4e86\uff0c\u4e0d\u65b9\u4fbf\u67e5\u8be2\uff0c\u4e8e\u662f\u6839\u636e\u73b0\u6709\u8868\u7ed3\u6784\u5199\u4e86\u8fd9\u4e2a\u67e5\u8be2\uff0c\u53ef\u4ee5\u67e5\u8be2\u90e8\u95e8\u5f53\u524d\u751f\u6548\u7684\u9884\u7b97\u4fe1\u606f\uff0c\u5305\u62ec\u79d1\u76ee\u3001\u603b\u9884\u7b97\u548c\u5df2\u7528\u9884\u7b97\uff0c\u5176\u4e2d\u5df2\u7528\u9884\u7b97\u5173\u8054\u62a5\u9500\u3001\u9884\u63d0\u7684\u76f8\u5173\u6d41\u7a0b\u3002 \u8be5\u67e5\u8be2\u4e2d\u5173\u8054\u7684\u8868\u7ed3\u6784\u5982\u4e0b\uff1a fnabudge…<\/p>\n","protected":false},"author":1,"featured_media":592,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"topic":[],"class_list":["post-733","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oa"],"_links":{"self":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts\/733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=733"}],"version-history":[{"count":8,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts\/733\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/posts\/733\/revisions\/807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=\/wp\/v2\/media\/592"}],"wp:attachment":[{"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=733"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.furyblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftopic&post=733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}