{"meta":{"parserVersion":1,"key":"29e9f00b-cdeb-471f-988d-d73d15345378","base":{"name":"대표 가수금 관리","desc":"- 대표이사의 가수금 입금, 반환(출금) 내역을 관리하는 앱\n- “접근 제어-데이터 목록 조회 권한 설정”을 통해 목록에 나타날 자료의 관리년도 범위를 5년(2019-2023)으로 설정함\n","icon":"ic_app10.png"},"exporter":{"name":"웍스 매니저","companyName":"Works 데모"},"exportedAt":1582517675671},"components":{"view":{"id":null,"charts":[{"id":null,"title":"년도별 가수금 잔액 현황","chartType":"COLUMN","groupByCid":"_20so4izcf","subGroupByCid":"","rangeOption":null,"subRangeOption":null,"goal":null,"aggMethod":"SUM","subAggMethod":"COUNT","aggCid":"_6xlsukdl0","subAggCid":null,"combination":false,"stack":false,"subStack":false,"showValue":true,"theme":2},{"id":null,"title":"년도별 가수금 입금 현황","chartType":"COLUMN","groupByCid":"_20so4izcf","subGroupByCid":"","rangeOption":null,"subRangeOption":null,"goal":null,"aggMethod":"SUM","subAggMethod":"COUNT","aggCid":"_8zbrlbno9","subAggCid":null,"combination":false,"stack":false,"subStack":false,"showValue":false,"theme":0}],"columns":[{"id":null,"fieldCid":"_20so4izcf","columnName":"","width":null},{"id":null,"fieldCid":"_skpa7lkm8","columnName":"","width":null},{"id":null,"fieldCid":"_jchlmhmvu","columnName":"","width":null},{"id":null,"fieldCid":"_8zbrlbno9","columnName":"","width":null},{"id":null,"fieldCid":"_a7e7ke887","columnName":"","width":null},{"id":null,"fieldCid":"_6xlsukdl0","columnName":"","width":null}],"titleColumnIndex":1,"sortColumnIndex":0,"sortDirection":"DESC","docNoConfig":{"id":null,"useDocNo":false,"docNoType":"simple","customPrefix":null,"customDigit":2}},"form":{"id":null,"appletId":null,"data":{"type":"canvas","valueType":null,"multiple":false,"cid":"cxx1","parentCid":null,"properties":null,"components":[{"type":"columns","valueType":null,"multiple":false,"cid":"_pzfnl4ioq","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_p8bfidnzj","parentCid":"_pzfnl4ioq","properties":{},"components":[{"type":"number","valueType":"NUMBER","multiple":false,"cid":"_20so4izcf","parentCid":"_p8bfidnzj","properties":{"label":"관리년도","hideLabel":false,"guide":"YYYY 형식으로 입력합니다.","guideAsTooltip":false,"required":true,"minLength":"2016","maxLength":"2050","width":"50","widthUnit":"px","unitText":"년","fixType":"postfix","decimalPoints":"0","thousandComma":false,"useTableAutoAggr":false,"tableAggrType":"","code":"number_13854"},"components":[]}]},{"type":"column","valueType":null,"multiple":false,"cid":"_xa2b83kzb","parentCid":"_pzfnl4ioq","properties":{},"components":[{"type":"number","valueType":"NUMBER","multiple":false,"cid":"_jchlmhmvu","parentCid":"_xa2b83kzb","properties":{"label":"전년도 이월금","hideLabel":false,"guide":"","guideAsTooltip":true,"required":true,"defaultValue":"0","minLength":"0","maxLength":"1000000000","width":"120","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"useTableAutoAggr":false,"tableAggrType":"","code":"number_0"},"components":[]}]}]},{"type":"text","valueType":"STEXT","multiple":false,"cid":"_skpa7lkm8","parentCid":"cxx1","properties":{"label":"회계 명목","hideLabel":false,"guide":"목록에서 제목으로 표시하는 용도이므로 \"가수금\"이라고 입력합니다.","guideAsTooltip":false,"required":true,"duplicate":false,"similar":false,"defaultValue":"가수금","minLength":0,"maxLength":100,"width":"150","widthUnit":"px","format":"all"},"components":[]},{"type":"hr","valueType":null,"multiple":false,"cid":"_tb3xwcn29","parentCid":"cxx1","properties":{},"components":[]},{"type":"label","valueType":null,"multiple":false,"cid":"_x37fqm28f","parentCid":"cxx1","properties":{"label":"◆ 당해년도 가수금 입출 내역","color":"4"},"components":[]},{"type":"table","valueType":null,"multiple":false,"cid":"_uukcx7f86","parentCid":"cxx1","properties":{"label":"테이블 이름","hideLabel":true,"guide":"","guideAsTooltip":true},"components":[{"type":"date","valueType":"DATE","multiple":true,"cid":"_z0ukav87g","parentCid":"_uukcx7f86","properties":{"label":"일자","hideLabel":false,"guide":"","guideAsTooltip":true,"required":false,"defaultAsNow":false,"defaultDate":"","code":"date_55744"},"components":[]},{"type":"text","valueType":"STEXT","multiple":true,"cid":"_uxnjnkms8","parentCid":"_uukcx7f86","properties":{"label":"적요 (용도/반환)","hideLabel":false,"guide":"","guideAsTooltip":true,"required":false,"duplicate":false,"similar":false,"defaultValue":"","minLength":0,"maxLength":100,"width":100,"widthUnit":"percent","format":"all"},"components":[]},{"type":"number","valueType":"NUMBER","multiple":true,"cid":"_v9drf2st8","parentCid":"_uukcx7f86","properties":{"label":"입금","hideLabel":false,"guide":"","guideAsTooltip":true,"required":true,"defaultValue":"0","minLength":"0","maxLength":"1000000000","width":"120","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"useTableAutoAggr":true,"tableAggrType":"SUM","code":"sum_1"},"components":[]},{"type":"number","valueType":"NUMBER","multiple":true,"cid":"_xp1rs251s","parentCid":"_uukcx7f86","properties":{"label":"출금","hideLabel":false,"guide":"","guideAsTooltip":true,"required":true,"defaultValue":"0","minLength":"0","maxLength":"1000000000","width":"120","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"useTableAutoAggr":true,"tableAggrType":"SUM","code":"sum_2"},"components":[]}]},{"type":"hr","valueType":null,"multiple":false,"cid":"_zyyb03zwz","parentCid":"cxx1","properties":{},"components":[]},{"type":"label","valueType":null,"multiple":false,"cid":"_g9s4o8goi","parentCid":"cxx1","properties":{"label":"◆ 당해년도 가수금 결산 내역","color":"4"},"components":[]},{"type":"columns","valueType":null,"multiple":false,"cid":"_lk6ls3bav","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_0l5dzu9h5","parentCid":"_lk6ls3bav","properties":{},"components":[{"type":"formula","valueType":"NUMBER","multiple":false,"cid":"_8zbrlbno9","parentCid":"_0l5dzu9h5","properties":{"label":"가수금 입금 총액","hideLabel":false,"guide":"","guideAsTooltip":true,"expressionType":"number","expression":"sum_1","width":"120","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"code":"formula_1"},"components":[]}]},{"type":"column","valueType":null,"multiple":false,"cid":"_upd7egjhn","parentCid":"_lk6ls3bav","properties":{},"components":[{"type":"formula","valueType":"NUMBER","multiple":false,"cid":"_a7e7ke887","parentCid":"_upd7egjhn","properties":{"label":"가수금 반환 총액","hideLabel":false,"guide":"","guideAsTooltip":true,"expressionType":"number","expression":"sum_2","width":"120","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"code":"formula_2"},"components":[]}]}]},{"type":"formula","valueType":"NUMBER","multiple":false,"cid":"_6xlsukdl0","parentCid":"cxx1","properties":{"label":"가수금 잔액","hideLabel":false,"guide":"","guideAsTooltip":true,"expressionType":"number","expression":"number_0 + formula_1 - formula_2","width":"120","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"code":"formula_57256"},"components":[]}]}},"process":{"id":null,"appletId":null,"useProcess":false,"statuses":[{"id":null,"name":"승인대기","start":true,"doing":false,"end":false,"count":null,"color":"0"},{"id":null,"name":"반려","start":false,"doing":true,"end":false,"count":null,"color":"4"},{"id":null,"name":"승인완료","start":false,"doing":false,"end":true,"count":null,"color":"8"}],"transitions":[{"id":null,"beforeStatus":"승인대기","nextStatus":"반려","actionName":"반려하기","actionRoles":["ADMIN"],"pushRoles":["REGISTRANT"]},{"id":null,"beforeStatus":"승인대기","nextStatus":"승인완료","actionName":"승인완료","actionRoles":["ADMIN"],"pushRoles":["REGISTRANT"]},{"id":null,"beforeStatus":"반려","nextStatus":"승인완료","actionName":"승인완료","actionRoles":["ADMIN"],"pushRoles":["REGISTRANT"]}],"addPushes":[]}},"messageKeys":null}