~ Tiez Notes ~

CREATE VIEW dbo.v_col998_khusus
AS
SELECT b.regionalid, b.regional, b.zoneid, b.zonename, a.branchid, dbo.f_getBranch(a.branchid) AS branchname, a.norek, a.nopin, a.cicildate, a.angsuran,
0 AS indoor, 0 AS outdoor, 0 AS inod, 0 AS reversal, 0 AS bank, 0 AS unknown, 0 AS vtlancar, 0 AS Vt90_in, 0 AS Vt90up_in, 0 AS Vt90_od,
0 AS Vt90UP_od, 0 AS tagih, 0 AS denda
FROM dbo.tmpPJT_Khusus a INNER JOIN
dbo.genRegional b ON b.branchid = a.branchid