SCM-Sources_data

{"definitionMarkdown":"# {name}\n{description}\n\n---------------\n\n### Properties\n{properties}\n\n### Tests\n{sourceTests}\n\nHelp! I don't know [markdown](https://www.markdownguide.org/).\n","properties":[{"property":"TIME_SK","type":"Date","originSource":"TCLS_LOAN","sampleValue":"20181122","comments":""},{"property":"LOAN_ID","type":"String","originSource":"TCLS_LOAN","sampleValue":"BMRIID18L0014176I000","comments":""},{"property":"PROD_TYPE","type":"String","originSource":"TCLS_LOAN","sampleValue":"DDP","comments":""},{"property":"PROD_CODE","type":"String","originSource":"TCLS_LOAN","sampleValue":"BMRIID-DF","comments":""},{"property":"COMPANY_EIN2","type":"String","originSource":"TCDA_COMPANY","sampleValue":"23000539661","comments":""},{"property":"COMPANY_CODE","type":"String","originSource":"TCDA_COMPANY","sampleValue":"KTIRE01","comments":""},{"property":"CUST_CODE","type":"String","originSource":"TCLS_LOAN","sampleValue":"KTIRE01","comments":""},{"property":"OBLIGOR_CODE","type":"String","originSource":"TCLS_LOAN","sampleValue":"JJGGH01","comments":""},{"property":"COMPANY_NAME","type":"String","originSource":"TCDA_COMPANY","sampleValue":"PT KING TIRE INDONESIA","comments":""},{"property":"COLLECT_SCORE","type":"Numeric","originSource":"TCLS_LOAN","sampleValue":"4","comments":""},{"property":"PROC_COLLECTIBILITY_STATUS","type":"Numeric","originSource":"TCDA_COMPANY","sampleValue":"1","comments":""},{"property":"LOAN_CCY","type":"String","originSource":"TCLS_LOAN","sampleValue":"IDR","comments":""},{"property":"MATURITY_DATE","type":"Date","originSource":"TCLS_LOAN","sampleValue":"2018-07-19 12:00:00","comments":""},{"property":"INT_RATE_TOTAL","type":"Date","originSource":"TCLS_LOANINTEREST","sampleValue":"9.24","comments":""},{"property":"EFFECTIVE_DATE","type":"Date","originSource":"TCLS_LOAN","sampleValue":"2018-04-20 12:00:00","comments":""},{"property":"LOAN_AMT","type":"Numeric","originSource":"TCLS_LOAN","sampleValue":"223150211","comments":""},{"property":"PRINC_OUTSTD_AMT","type":"Numeric","originSource":"TCLS_LOANEXT","sampleValue":"223150211","comments":""},{"property":"FACE_LIMIT_AMT","type":"Numeric","originSource":"TRMS_LIMIT","sampleValue":"50000","comments":""},{"property":"LIMIT_NODE_VALUE","type":"String","originSource":"TRMS_LIMIT","sampleValue":"JJGGH01","comments":""},{"property":"LIMIT_NODE_NAME","type":"String","originSource":"TRMS_LIMIT","sampleValue":"RISK_OWNER","comments":""},{"property":"INT_EARNED_AMT","type":"Numeric","originSource":"TCLS_LOANEXT","sampleValue":"1418130.03","comments":""},{"property":"FACE_LIMIT_FXRATE","type":"Numeric","originSource":"TRMS_LIMIT","sampleValue":"1","comments":""},{"property":"LOAN_STATUS","type":"String","originSource":"TCLS_LOAN","sampleValue":"P","comments":""},{"property":"BU_CODE","type":"String","originSource":"TCLS_LOAN","sampleValue":"SM471","comments":""},{"property":"LIMIT_AMT","type":"Numeric","originSource":"TRMS_LIMIT","sampleValue":"3000000000","comments":""},{"property":"LIMIT_PENDING_AMT ","type":"Numeric","originSource":"TRMS_LIMIT","sampleValue":"0","comments":""},{"property":"LIMIT_USED_AMT","type":"Numeric","originSource":"TRMS_LIMIT","sampleValue":"limitused_cust","comments":""},{"property":"PROC_COLLECTABILITY_STATUS","type":"String","originSource":"TCDA_COMPANY","sampleValue":"4","comments":""},{"property":"FEE_PAID_AMT_B","type":"Numeric","originSource":"TCLS_LOANEXT","sampleValue":"0","comments":""},{"property":"PRINC_PAID_AMT","type":"Numeric","originSource":"TCLS_LOANEXT","sampleValue":"0","comments":""},{"property":"LAST_PAY_DATE","type":"Date","originSource":"TCLS_LOANEXT","sampleValue":"2018-12-19 00:00:00","comments":""},{"property":"BUNITD1_NM","type":"String","originSource":"zBUNITD1","sampleValue":"Small Commercial","comments":""},{"property":"CU_BMSUBSUBSEKTOREKONOMI","type":"String","originSource":"CUSTOMER","sampleValue":"","comments":""},{"property":"N_PD_PERCENT","type":"Numeric","originSource":"BASEL_INFO_IFRS","sampleValue":"","comments":""},{"property":"N_LGD_PERCENT_POST_CRM","type":"Numeric","originSource":"BASEL_INFO_IFRS","sampleValue":"","comments":""},{"property":"N_CCF_PERCENT","type":"Numeric","originSource":"BASEL_INFO_IFRS","sampleValue":"","comments":""},{"property":"DPD_LOGIC","type":"Numeric","originSource":"","sampleValue":"234","comments":""},{"property":"UNDRAWN_AMOUNT","type":"Numeric","originSource":"","sampleValue":"2718879438","comments":""},{"property":"COMPANYCODE_OBLIGOR","type":"String","originSource":"TCDA_COMPANY_OBLIGOR","sampleValue":"JJGGH01","comments":""},{"property":"COMPANYCODE_CUST","type":"String","originSource":"TCDA_COMPANY_OBLIGOR","sampleValue":"","comments":""},{"property":"COUNTERID_OBLIGOR","type":"String","originSource":"TCDA_COMPANY_OBLIGOR","sampleValue":"10000843791","comments":""},{"property":"COMPANYNAME_OBLIGOR","type":"String","originSource":"TCDA_COMPANY_OBLIGOR","sampleValue":"XX XXXXX XXXX XXXXX","comments":""},{"property":"COLLECTSTATUS_OBLIGOR","type":"Numeric","originSource":"TCDA_COMPANY_OBLIGOR","sampleValue":"5","comments":""},{"property":"FACELIMIT_OBLIGOR","type":"Numeric","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"3000000000","comments":""},{"property":"LIMITVALUE_OBLIGOR","type":"String","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"JJGGH01","comments":""},{"property":"LIMITNAME_OBLIGOR","type":"String","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"RISK_OWNER","comments":""},{"property":"CURRRATE_OBLIGOR","type":"Numeric","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"1","comments":""},{"property":"LIMITAOUNT_OBLIGOR","type":"Numeric","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"3000000000","comments":""},{"property":"LIMITPENDING_OBLIGOR","type":"String","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"0","comments":""},{"property":"LIMITUSED_OBLIGOR","type":"String","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"281120562","comments":""},{"property":"PREPAYMENTAMOUNT_OBLIGOR","type":"String","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"5","comments":""},{"property":"SECOM_OBLIGOR","type":"String","originSource":"TRMS_LIMIT_OBLIGOR","sampleValue":"","comments":""}]}