05 2011 档案

FA_SQL(抓固定資產相關信息)
摘要：SELECT dept.DEPARTMENT_CNAME, gcc.segment2 dept, fdh.ASSIGNED_TO_NAME full_name, fl.segment1 || '.' || fl.segment2, fa.ASSET_NUMBER, fa.description, fdh.UNITS_ASSIGNED, fb.date_placed_in_service, fdh.BOOK_TYPE_CODE, fai.invoice_number, fa.ATTRIBUTE_CATEGORY_CODE, fa.SERIAL_NUMBER, fa.TAG_NUM 阅读全文
posted @ 2011-05-19 17:26 aimin_zhong 阅读(322) 评论(0) 推荐(0) 编辑
QA/Setup/Collection Plans(Collection Plans中連接Collection Elements對應後臺qa_results.character欄位)
摘要：1.在Collection Plans中連接Collection Elements對應後臺qa_results.character欄位，是添加的先後順序排序的2.COPY elements注意後續添加的elements會插入到前面，導致copy后對應的qa_results.Character值變化。 阅读全文
posted @ 2011-05-18 10:33 aimin_zhong 阅读(132) 评论(0) 推荐(0) 编辑