{"id":484,"date":"2015-05-19T09:38:17","date_gmt":"2015-05-19T01:38:17","guid":{"rendered":"http:\/\/www.llku.com\/?p=484"},"modified":"2015-05-19T09:38:17","modified_gmt":"2015-05-19T01:38:17","slug":"%e8%b5%84%e4%ba%a7%e7%b1%bb%e5%88%ab%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=484","title":{"rendered":"\u8d44\u4ea7\u7c7b\u522b\u4fe1\u606f"},"content":{"rendered":"<p>\n\tSELECT FCV.SEGMENT1 || &#39;.&#39; || FCV.SEGMENT2 || &#39;.&#39; || FCV.SEGMENT3 \u8d44\u4ea7\u7c7b\u522b,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FCV.DESCRIPTION \u7c7b\u522b\u63cf\u8ff0,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FCB.BOOK_TYPE_CODE \u8d44\u4ea7\u8d26\u7c3f,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC.SEGMENT1 || &#39;.&#39; || GCC.SEGMENT2 || &#39;.&#39; || GCC.SEGMENT3 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC.SEGMENT4 || &#39;.&#39; || GCC.SEGMENT5 || &#39;.&#39; || GCC.SEGMENT6 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC.SEGMENT7 || &#39;.&#39; || 0 \u6210\u672c\u79d1\u76ee,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC1.SEGMENT1 || &#39;.&#39; || GCC1.SEGMENT2 || &#39;.&#39; || GCC1.SEGMENT3 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC1.SEGMENT4 || &#39;.&#39; || GCC1.SEGMENT5 || &#39;.&#39; || GCC1.SEGMENT6 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC1.SEGMENT7 || &#39;.&#39; || 0 \u8d44\u4ea7\u7ed3\u7b97\u79d1\u76ee,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC2.SEGMENT1 || &#39;.&#39; || GCC2.SEGMENT2 || &#39;.&#39; || GCC2.SEGMENT3 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC2.SEGMENT4 || &#39;.&#39; || GCC2.SEGMENT5 || &#39;.&#39; || GCC2.SEGMENT6 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC2.SEGMENT7 || &#39;.&#39; || 0 \u6298\u65e7\u8d39\u7528\u79d1\u76ee,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC3.SEGMENT1 || &#39;.&#39; || GCC3.SEGMENT2 || &#39;.&#39; || GCC3.SEGMENT3 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC3.SEGMENT4 || &#39;.&#39; || GCC3.SEGMENT5 || &#39;.&#39; || GCC3.SEGMENT6 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC3.SEGMENT7 || &#39;.&#39; || 0 \u7d2f\u8ba1\u6298\u65e7\u79d1\u76ee,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC4.SEGMENT1 || &#39;.&#39; || GCC4.SEGMENT2 || &#39;.&#39; || GCC4.SEGMENT3 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC4.SEGMENT4 || &#39;.&#39; || GCC4.SEGMENT5 || &#39;.&#39; || GCC4.SEGMENT6 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC4.SEGMENT7 || &#39;.&#39; || 0 \u9644\u52a0\u8d39\u7528\u79d1\u76ee,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC5.SEGMENT1 || &#39;.&#39; || GCC5.SEGMENT2 || &#39;.&#39; || GCC5.SEGMENT3 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC5.SEGMENT4 || &#39;.&#39; || GCC5.SEGMENT5 || &#39;.&#39; || GCC5.SEGMENT6 || &#39;.&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCC5.SEGMENT7 || &#39;.&#39; || 0 \u9644\u52a0\u51c6\u5907\u91d1\u79d1\u76ee\n<\/p>\n<p>\n\t&nbsp; FROM FA_CATEGORIES_VL&nbsp;&nbsp;&nbsp;&nbsp; FCV,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FA_CATEGORY_BOOKS&nbsp;&nbsp;&nbsp; FCB,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_CODE_COMBINATIONS GCC,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_CODE_COMBINATIONS GCC1,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_CODE_COMBINATIONS GCC2,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_CODE_COMBINATIONS GCC3,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_CODE_COMBINATIONS GCC4,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_CODE_COMBINATIONS GCC5\n<\/p>\n<p>\n\t&nbsp;WHERE 1 = 1<br \/>\n\t&nbsp;&nbsp; AND FCV.CATEGORY_ID = FCB.CATEGORY_ID<br \/>\n\t&nbsp;&nbsp; AND FCV.ENABLED_FLAG = &#39;Y&#39;<br \/>\n\t&nbsp;&nbsp; AND FCB.ASSET_COST_ACCOUNT_CCID = GCC.CODE_COMBINATION_ID<br \/>\n\t&nbsp;&nbsp; AND FCB.ASSET_CLEARING_ACCOUNT_CCID = GCC1.CODE_COMBINATION_ID<br \/>\n\t&nbsp;&nbsp; AND FCB.DEPRN_EXPENSE_ACCOUNT_CCID = GCC2.CODE_COMBINATION_ID<br \/>\n\t&nbsp;&nbsp; AND FCB.BONUS_RESERVE_ACCT_CCID = GCC3.CODE_COMBINATION_ID<br \/>\n\t&nbsp;&nbsp; AND FCB.BONUS_EXPENSE_ACCOUNT_CCID = GCC4.CODE_COMBINATION_ID<br \/>\n\t&nbsp;&nbsp; AND FCB.BONUS_RESERVE_ACCT_CCID = GCC5.CODE_COMBINATION_ID;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT FCV.SEGMENT1 || &#39;.&#39; || FCV.SEGMENT2 || &#038; &hellip; <a href=\"https:\/\/www.llku.com\/?p=484\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u8d44\u4ea7\u7c7b\u522b\u4fe1\u606f<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[88,89],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/484"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=484"}],"version-history":[{"count":1,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/484\/revisions"}],"predecessor-version":[{"id":485,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/484\/revisions\/485"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}