SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
//Input and update
//TAX Database
ODBC CONNECT32 TO tax (XUserId is SAWHaZFPTDcEXXdMSLZGXZFM, XPassword is EQRaZYAD);
Collectible:
LOAD pin,
"prop-type",
"user_id",
remarks,
todate,
"prev-assess",
"curr-assess",
year,
qtr,
"basic_sef",
tin,
"penalty-bal",
qtr2,
"disc-bal",
compro,
"mode",
"time_stamp",
PCINum,
MDINum,
BINum,
SINum,
Parcel,
PType,
RPUNum,
OwnerNum,
Basic,
SEF,
AssmtCount,
"Rev-Yr",
IdleTax;
SQL SELECT *
FROM PUB.collectible;
Store Collectible into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Collectible.qvd;
OrFile:
LOAD ornum,
ordate,
payee,
"c-code",
BasicTax,
SEFTax,
IdleTax,
BasicPen,
SEFPen,
IdlePen,
BasicDis,
SEFDis,
IdleDis,
TotalDis,
TotalTax,
TotalPen,
TotalPay,
CancFlag,
"user_code",
"date_posted",
"time_posted",
BankName,
CheckNo,
CheckDate,
CheckAmt,
CashAmt,
remarks,
"abs-date",
"abs-no";
SQL SELECT *
FROM PUB.orfile;
Store OrFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\OrFile.qvd;
Payment:
LOAD pin,
"prop-type",
ornum,
ordate,
"user_id",
remarks,
checknum,
tin,
mcode,
bcode,
payee,
bankname,
checkdate,
todate,
discount,
penalty,
"prev-assess",
"curr-assess",
year1,
year2,
qtr1,
qtr2,
VOS,
"basic_sef",
tdno,
cancelled,
partial,
"abs-date",
compro,
"mode",
"time_stamp",
"c-code",
PCINum,
MDINum,
BINum,
SINum,
Parcel,
PType,
RPUNum,
OwnerNum,
"Discount_Basic",
"Discount_SEF",
"Penalty_Basic",
"Penalty_SEF",
Basic,
SEF,
AssmtCount,
"Rev-Yr",
"tc-amount",
ornumber,
taxcredit,
"Penalty_Idle",
"Discount_Idle",
TotalPay,
IdleTax,
"abs-no";
SQL SELECT *
FROM PUB.payment;
Store Payment into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Payment.qvd;
PenaltyRate:
LOAD yr,
rate,
qtr,
taxyear;
SQL SELECT *
FROM PUB."penalty-rate";
Store PenaltyRate into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\PenaltyRate.qvd;
//sysdb Database
ODBC CONNECT32 TO sysdb (XUserId is GfMFbZFPTDcEXXdMSLZGXZdD, XPassword is XOdYQYER);
AcctForm:
LOAD stubno,
"cust_recvdate",
"orfm_ornum",
"orto_ornum",
"cust_issuedate",
"c-code",
"or_count";
SQL SELECT *
FROM PUB.acctform;
Store AcctForm into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\AcctForm.qvd;
Aword:
LOAD val,
word;
SQL SELECT *
FROM PUB.aword;
Store Aword into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Aword.qvd;
Collect:
LOAD "c-code",
name,
designation;
SQL SELECT *
FROM PUB.collect;
Store Collect into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Collect.qvd;
MenuFile:
LOAD "menu_order",
"menu_level",
"menu_obj",
"menu_program",
"menu_cat",
"menu_label",
"init_access";
SQL SELECT *
FROM PUB.menufile;
Store MenuFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\MenuFile.qvd;
UserProg:
LOAD "user_code",
"module_code",
"view_flag",
"create_flag",
"edit_flag",
"cancel_flag",
"delete_flag",
"process_flag",
"generate_flag",
"seq_no";
SQL SELECT *
FROM PUB.userprog;
Store UserProg into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\UserProg.qvd;
//tempdb Database
ODBC CONNECT32 TO tempdb (XUserId is YZESaZFPTDcEXXdMSLZGXZBZ, XPassword is PFbNUYIC);
AbsClass:
LOAD "tax_type",
ccode,
crank,
"curr_tax",
"curr_dis",
"curr_net",
"curr_pen",
"prec_tax",
"prec_pen",
"prev_tax",
"prev_pen",
"prev_taxsub",
"prev_pensub",
"currmo_coll",
"brgy_share",
"prevmo_coll",
"total_coll",
"class_type",
Name;
SQL SELECT *
FROM PUB.AbsClass;
Store AbsClass into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\AbsClass.qvd;
Abstract:
LOAD pcinum,
mdinum,
binum,
sinum,
parcel,
pType,
ordate,
ornum,
pin,
owner,
brgy,
"curr_assval",
"lot_no",
"yr_from",
"yr_to",
"adv_tax",
"curr_taxwdis",
"curr_taxodis",
"prec_tax",
"prev_tax",
"gross_coll",
"curr_disc",
"adv_disc",
"net_coll",
"tax_code",
"curr_pen",
"prec_pen",
"prev_pen",
"abs-date";
SQL SELECT *
FROM PUB.Abstract;
Store Abstract into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Abstract.qvd;
BrgyShare:
LOAD BrgyCode,
BrgyName,
AdvPay,
CurrYrD,
CurrYrW,
PrecYr,
PrevYr,
CurrPen,
PrecPen,
PrevPen,
GrossC,
CurrDisc,
AdvDisc,
TotColl,
"gen_fund",
"brgy_share",
"brgy_50p",
"brgy_30p",
"brgy_total",
"brgy_50pA",
"brgy_50pO",
"brgy_30pA",
"brgy_30pO",
"brgy_totalA",
"brgy_totalO";
SQL SELECT *
FROM PUB.BrgyShare;
Store BrgyShare into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\BrgyShare.qvd;
DelinqFile:
LOAD pcinum,
mdinum,
binum,
sinum,
parcel,
pType,
owner,
"pin-short",
address1,
address2,
lotno,
assdval,
"yr_fm",
"yr_to",
taxdue,
pendue,
discdue,
totdue,
location,
arp,
propClass,
"area",
tctno,
Qtr1,
Qtr2;
SQL SELECT *
FROM PUB.delinqfile;
Store DelinqFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\DelinqFile.qvd;
Delsumm:
LOAD "brgy_code",
"brgy_name",
"rpu_cnt",
"rpu_taxable",
"rpu_exempt",
"rpu_delinq",
"rpu_per",
"tot_basic",
"tot_sef",
"tot_idle",
"tot_taxdue",
"tot_recv",
"tot_basicpen",
"tot_sefpen",
"tot_idlepen",
"tot_pendue",
"tot_amtdue",
"del_per",
"tot_del";
SQL SELECT *
FROM PUB.DelSumm;
Store Delsumm into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Delsumm.qvd;
OrptFile:
LOAD seqno,
"prt_detail",
owner,
location,
lotno,
PIN,
instlno,
"assval_land",
"assval_imp",
basictax,
basicpen,
seftax,
sefpen,
totaldue;
SQL SELECT *
FROM PUB.orptfile;
Store OrptFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\OrptFile.qvd;
Pastdue:
LOAD pin,
assmtcnt,
lotno,
totarea,
proptype,
propclass,
propdesc,
assval,
ownernum,
oname,
lastpaid,
lpaidyr,
lpaidqtr,
lpaydesc,
lcollyr,
lcollqtr,
lcollyr2,
lcollqtr2,
lcolldesc,
basicdue,
sefdue,
idledue,
taxdue,
basicpen,
sefpen,
idlepen,
pendue,
totdue,
yrsdel,
mval,
titleno;
SQL SELECT *
FROM PUB.pastdue;
Store Pastdue into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Pastdue.qvd;
RaaFile:
LOAD "tran_code",
"beg_fmor",
"beg_toor",
"beg_qty",
"rec_fmor",
"rec_toor",
"rec_qty",
"iss_fmor",
"iss_toor",
"iss_qty",
collname,
"end_fmor",
"end_toor",
"end_qty";
SQL SELECT *
FROM PUB.raafile;
Store RaaFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RaaFile.qvd;
Rptar:
LOAD refdate,
refnum,
"assess-count",
"year-from",
"qtr-from",
"year-to",
"qtr-to",
"basic_tax",
"basic_penalty",
"basic_discount",
"sef_tax",
"sef_penalty",
"sef_discount",
"total_tax",
"total_penalty",
"total_discount",
"assess-value",
"total_paid";
SQL SELECT *
FROM PUB.rptar;
Store Rptar into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Rptar.qvd;
TaxNotice:
LOAD YearType,
nyear,
nQtrFm,
nQtrTo,
nPeriod,
nArp,
nAssVal,
nBasTax,
nBasNet,
nSEFTax,
nSEFNet,
nIdleTax,
nIdleNet,
nTotal;
SQL SELECT *
FROM PUB.TaxNotice;
Store TaxNotice into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\TaxNotice.qvd;
TempSysparam:
LOAD "sys_lgutype",
"sys_provcode",
"sys_citycode",
"sys_muncode",
"sys_distcode",
"sys_provname",
"sys_cityname",
"sys_muniname",
"sys_provtreas",
"sys_currtrn",
"sys_ovrdate",
"sys_update",
"sys_reprint",
"sys_citytreas",
"sys_muntreas",
"sys_formcust",
"sys_custpos",
"sys_directory";
SQL SELECT *
FROM PUB."temp-sysparam";
Store TempSysparam into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\TempSysparam.qvd;
//Prop database
ODBC CONNECT32 TO prop (XUserId is UcMBYZFPTDcEXXdMSLZGXZNT, XPassword is GaEUSZFPTDcEXXdMSLZGXZdK);
AssLevel:
LOAD "prop-type",
classif,
description,
asslev,
Code,
yr;
SQL SELECT *
FROM PUB."ASS-LEVEL";
Store AssLevel into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\AssLevel.qvd;
BldgAssmt:
LOAD pin,
effectivity,
classif,
storey,
"area",
"area-comp",
"unit-val",
asslev,
"area-length",
"area-width",
"use-type-code",
depreciation,
"prop-type",
remarks,
cancelled,
yr,
"d-compltd",
"bldg-type",
"NPaint-Rate",
"SHM-Rate",
NR,
"eco-life",
mvalue,
"uval-yr",
"d-rate",
"e-count",
colum,
beams,
floorjt,
roof,
partition,
flooring,
ceiling,
windows,
doors,
elect,
numtb,
paint,
"paint-c",
"ex-walls",
"roof-frm",
founda,
"wall-fin",
dom,
pcount,
"entry_date",
"mode",
PCINum,
MDINum,
BINum,
SINum,
Parcel,
PType,
CCode,
AUCode,
Stairs,
TBath,
Plumbing;
SQL SELECT *
FROM PUB."Bldg-ASSMT";
Store BldgAssmt into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\BldgAssmt.qvd;
Brgy:
LOAD PCINum,
MDINum,
BINum,
BrgyName;
SQL SELECT *
FROM PUB.Brgy;
Store Brgy into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Brgy.qvd;
LandAssmt:
LOAD pin,
effectivity,
classif,
Kind,
"area",
classrnk,
"unit-val",
adjmt,
asslev,
width,
remarks,
"corner-inf",
"UNDEVELOP-LVA",
taxability,
"prop-type",
Mcode,
mvalue,
depth,
cancelled,
yr,
"strip_area",
ctr,
NR,
"uval-yr",
"dst-pobl",
"dst-weath",
pcount,
"lva-pobl",
"lva-rdfrt",
"lva-weat",
kind2,
"entry_date",
"mode",
CRClassif,
WRF,
WSA,
Testat,
PCINum,
MDINum,
BINum,
SINum,
Parcel,
PType,
CCode,
AUCode,
ClassifType,
"dst-rdfrt";
SQL SELECT *
FROM PUB."Land-ASSMT";
Store LandAssmt into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\LandAssmt.qvd;
LandMV:
LOAD Kind,
"mv-kind",
unit,
classif,
treecode,
Mcode,
yr,
ZoneNum;
SQL SELECT *
FROM PUB."Land-MV";
Store LandMV into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\LandMV.qvd;
MTSRep:
LOAD YrOf,
MOf,
PCINum,
MDINum,
BINum,
Taxable,
RCode,
RPUs
Classif,
Cancelled,
"Area",
LMVal,
BMVal175B,
BMVal175U,
MMVal,
IMVal,
LAVal,
BAVal175B,
BAVal175U,
MAVal,
IAVal,
CutOff;
SQL SELECT *
FROM PUB.MTSRep;
Store MTSRep into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\MTSRep.qvd;
Owner:
LOAD tin,
tctno,
owner,
address,
admin,
address2,
"telno-1",
"telno-2",
lotno,
"c-status",
spouse,
"et_al",
others,
"mode",
"entry_date",
BIRTin,
AdmTin,
OwnerNum,
AdmNum;
SQL SELECT *
FROM PUB.Owner;
Store Owner into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Owner.qvd;
Property:
LOAD pin,
tin,
assdate,
"prop-type",
arp,
cancelled,
"total-area",
"tot-assess",
lotno,
tctno,
tcode,
pcode,
Mcode,
bcode,
scode,
asslot,
"entry_date",
taxability,
classrnk,
demolished,
"new-assval",
yr,
Marketval,
NR,
remarks,
prevpin,
revnum,
pcount,
"mode",
Approved,
"Date_apprvd",
remote,
PCINum,
MDINum,
BINum,
SINum,
Parcel,
PType,
RPUNum,
"rev-yr",
BCCT,
TctDate,
AdmNum,
Qtr,
AssmtCount,
OwnerNum,
DateCancelled,
LBNum,
CBRpunum,
CBYr,
CBPCount,
Inactive,
Mortgage,
PTagNum,
PTagInfo,
Signatory,
SPos,
SDate;
SQL SELECT *
FROM PUB.Property;
Store Property into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Property.qvd;
Qrep:
LOAD Mcode,
bcode,
QYr,
Quarter,
Taxable,
RCode,
RPUs,
"Area",
LMVal,
BMVal175B,
BMVal175U,
MMVal,
IMVal,
LAVal,
BAVal175B,
BAVal175U,
MAVal,
IAVal,
Classif,
PCINum,
MDINum,
BINum,
PKRpus,
Carpav,
Uliqav,
Oprav;
SQL SELECT *
FROM PUB.QRep;
Store Qrep into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Qrep.qvd;
RevYear:
LOAD "rev-yr",
year1,
year2;
SQL SELECT *
FROM PUB.revyear;
Store RevYear into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RevYear.qvd;
RPClass:
LOAD Kind,
description,
SubCode;
SQL SELECT *
FROM PUB."RP-CLASS";
Store RPClass into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RPClass.qvd;
RPUnit:
LOAD RPUNum,
PCINum,
MDINum,
BINum,
SINum,
Parcel,
NumAndStreet,
PType,
LSurveyNum,
LLotNum,
LBlkNum,
LNBound,
LEBound,
LSBound,
LWBound,
LSketchFile,
BPermitNum,
BPIssued,
BCCT,
BCompletionIssued,
BOccupancyIssued,
BDateCompleted,
BDateOccupied,
MEAmenities,
Purok,
MPCINum,
MMDINum,
MSINum,
MParcel,
MPType,
MBINum,
LotBlkSurvey,
MTelecom;
SQL SELECT *
FROM PUB.RPUnit;
Store RPUnit into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RPUnit.qvd;
//Load
AbsClass:
LOAD tax_type,
ccode,
crank,
curr_tax,
curr_dis,
curr_net,
ACcurr_pen,
ACprec_tax,
ACprec_pen,
ACprev_tax,
ACprev_pren,
prev_taxsub,
prev_pensub,
currmo_coll,
brgy_share,
prevmo_coll,
total_coll,
class_type,
Name
FROM
(qvd);
Abstract:
LOAD pcinum,
mdinum,
binum,
sinum,
parcel,
pType,
ATordate,
ATornum,
ATpin,
owner,
brgy,
curr_assval,
lot_no,
yr_from,
yr_to,
adv_tax,
curr_taxwdis,
curr_taxodis,
prec_tax,
prev_tax,
gross_coll,
curr_disc,
adv_disc,
net_coll,
tax_code,
curr_pen,
prec_pen,
prev_pen,
[ATabs=date]
FROM
(qvd);
AcctForm:
LOAD stubno,
cust_recvdate,
orfm_ornum,
orto_ornum,
cust_issuedate,
[c-code],
or_count
FROM
(qvd);
AssLevel:
LOAD ASSLproptype,
ASSLclassif,
description,
ASSLasslev,
Code,
ASSLyr
FROM
(qvd);
Aword:
LOAD val,
word
FROM
(qvd);
BldgAssmt:
LOAD BApin,
BAeffectivity,
classif,
storey,
BAarea,
[area-comp],
[BAunit-val],
BAasslev,
[area-length],
[area-width],
[use-type-code],
depreciation,
[BAprop-type],
BAremarks,
BAcancelled,
BAyr,
[d-compltd],
[bldg-type],
[NPaint-Rate],
[SHM-Rate],
BANR,
[eco-life],
BAmvalue,
[BAuva;-yr],
[d-rate],
[e-count],
colum,
beams,
floorjt,
roof,
partition,
flooring,
ceiling,
windows,
doors,
elect,
numtb,
paint,
[paint-c],
[ex-walls],
[roof-frm],
founda,
[wall-fin],
dom,
BApcount,
BAentrydate,
BAmode,
BAPCINum,
BAMDINum,
BABINum,
BASINum,
BAParcel,
BAPtype,
[BA-CCode],
[BA-AUCode],
Stairs,
TBath,
Plumbing
FROM
(qvd);
Brgy:
LOAD BRPCINum,
BRMDINum,
BRBINum,
BrgyName
FROM
(qvd);
BrgyShare:
LOAD BrgyCode,
BrgyName,
AdvPay,
CurrYrD,
CurrYrW,
PrecYr,
PrevYr,
CurrPen,
PrecPen,
PrevPen,
GrossC,
CurrDisc,
AdvDisc,
TotColl,
gen_fund,
brgy_share,
brgy_50p,
brgy_30p,
brgy_total,
brgy_50pA,
brgy_50pO,
brgy_30pA,
brgy_30pO,
brgy_totalA,
brgy_totalO
FROM
(qvd);
Collect:
LOAD [c-code],
name,
designation
FROM
(qvd);
Collectible:
LOAD Colpin,
[Colprop-type],
Coluser_id,
Colremarks,
Coltodate,
[Colprev-assess],
[Colcurr-assess],
year,
qtr,
Colbasic_sef,
Coltin,
[penalty-bal],
Colqtr2,
[disc-bal],
Colcompro,
Colmode,
Coltime_stamp,
ColPCINum,
ColMDINum,
ColBINum,
ColSInum,
Parcel,
ColPType,
ColRPUNum,
ColOwnerNum,
ColBasic,
ColSEF,
ColAssmtCount,
[ColRev-Yr],
ColIdleTax
FROM
(qvd);
DelinqFile:
LOAD Delpcinum,
Delmdinum,
binum,
Delsinum,
Delparcel,
DelpType,
Delowner,
[pin-short],
address1,
Deladdress2,
[Del-lotno],
assdval,
yr_fm,
Delyr_to,
Deltaxdue,
Delpendue,
discdue,
Deltotdue,
[Del-location],
Delarp,
propClass,
area,
Deltctno,
Qtr1,
Qtr2
FROM
(qvd);
Delsumm:
LOAD brgy_code,
brgy_name,
rpu_cnt,
rpu_taxable,
rpu_exempt,
rpu_delinq,
rpu_per,
tot_basic,
tot_sef,
tot_idle,
tot_taxdue,
tot_recv,
tot_basicpen,
tot_sefpen,
tot_idlepen,
tot_pendue,
tot_amtdue,
del_per,
tot_del
FROM
(qvd);
LandAssmt:
LOAD LAPin,
effectivity,
LAClassif,
LAKind,
area,
LAClassrnk,
[unit-val],
adjmt,
asslev,
width,
LARemarks,
[corner-inf],
[UNDEVELOP-LVA],
LATaxability,
LAProptype,
LAMcode,
mvalue,
depth,
LACancelled,
LAyr,
strip_area,
ctr,
LANR,
[uval-yr],
[dst-pobl],
[dst-weath],
LAPcount,
[lva-pobl],
[lva-rdfrt],
[lva-weat],
kind2,
LAEntrydate,
LAMode,
CRClassif,
WRF,
WSA,
Testat,
LAPCINum,
LAMDINum,
LABINum,
LASINum,
LAParcel,
LAPtype,
CCode,
AUCode,
ClassifType,
[dst-rdfrt]
FROM
(qvd);
LandMV:
LOAD Kind,
[mv-kind],
unit,
classif,
treecode,
LMVMcode,
LMVyr,
ZoneNum
FROM
(qvd);
MenuFile:
LOAD menu_order,
menu_level,
menu_obj,
menu_program,
menu_cat,
menu_label,
init_access
FROM
(qvd);
MTSRep:
LOAD YrOf,
MOf,
MTSPCINum,
MTSMDINum,
MTSBINum,
MTSTaxable,
MTSRCode,
MTSRPUs,
MTSClassif,
Cancelled,
MTSArea,
MTSLMVal,
MTSBMVal175B,
MTSBMVal175U,
MTSMMVal,
MTSIMVal,
MTSLAVal,
MTSBAVal175B,
MTSBAVal175U,
MTSMAVal,
MTSIAVal,
CutOff
FROM
(qvd);
OrFile:
LOAD OrFornum,
OrFordate,
OrFpayee,
[OrFc-code],
BasicTax,
SEFTax,
OrFIdleTax,
BasicPen,
SEFPen,
IdlePen,
BasicDis,
SEFDis,
IdleDis,
TotalDis,
TotalTax,
TotalPen,
OrFTotalPay,
CancFlag,
user_code,
date_posted,
time_posted,
BankName,
CheckNo,
CheckDate,
CheckAmt,
CashAmt,
OrFremarks,
[OrFabs-date],
[OrFabs-no]
FROM
(qvd);
OrptFile:
LOAD seqno,
prt_detail,
OFowner,
OFlocation,
OFlotno,
PIN,
instlno,
assval_land,
assval_imp,
basictax,
OFbasicpen,
seftax,
OFsefpen,
totaldue
FROM
(qvd);
Owner:
LOAD OwnerTin,
OwnerTctno,
owner,
address,
admin,
address2,
[telno-1],
[telno-2],
OwnerLotno,
[c-status],
spouse,
et_al,
others,
OwnerMode,
OwnerEntrydate,
BIRTin,
AdmTin,
OwnerNum,
OwnerAdmNum
FROM
(qvd);
Pastdue:
LOAD PDpin,
assmtcnt,
PDlotno,
totarea,
proptype,
propclass,
propdesc,
assval,
ownernum,
oname,
lastpaid,
lpaidyr,
lpaidqtr,
lpaydesc,
lcollyr,
lcollqtr,
lcollyr2,
lcollqtr2,
lcolldesc,
basicdue,
sefdue,
idledue,
taxdue,
basicpen,
sefpen,
idlepen,
pendue,
totdue,
yrsdel,
mval,
titleno
FROM
(qvd);
Payment:
LOAD pin,
[prop-type],
ornum,
ordate,
user_id,
remarks,
checknum,
tin,
mcode,
bcode,
payee,
bankname,
checkdate,
todate,
discount,
penalty,
[prev-assess],
[curr-assess],
year1,
year2,
qtr1,
qtr2,
VOS,
basic_sef,
tdno,
cancelled,
partial,
[abs-date],
compro,
mode,
time_stamp,
[c-code],
PCINum,
MDINum,
BINum,
SINum,
Parcel,
PType,
RPUNum,
OwnerNum,
Discount_Basic,
Discount_SEF,
Penalty_Basic,
Penalty_SEF,
Basic,
SEF,
AssmtCount,
[Rev-Yr],
[tc-amount],
ornumber,
taxcredit,
Penalty_Idle,
Discount_Idle,
TotalPay,
IdleTax,
[abs-no]
FROM
(qvd);
PenaltyRate:
LOAD yr,
rate,
PRqtr,
taxyear
FROM
(qvd);
Property:
LOAD [Prop-pin],
[Prop-tin],
assdate,
[Prop_prop-type],
arp,
Propcancelled,
[total-area],
[tot-assess],
lotno,
tctno,
tcode,
pcode,
Mcode,
Propbcode,
scode,
asslot,
entry_date,
taxability,
classrnk,
demolished,
[new-assval],
yr,
Marketval,
NR,
Propremarks,
prevpin,
revnum,
pcount,
Propmode,
Approved,
Date_apprvd,
remote,
PropPCINum,
PropMDINum,
PropBINum,
PropSInum,
PropParcel,
PropPType,
RPUNum,
[rev-yr],
BCCT,
TctDate,
AdmNum,
Qtr,
PropAssmtCount,
PropOwnerNum,
DateCancelled,
LBNum,
CBRpunum,
CBYr,
CBPCount,
Inactive,
Mortgage,
PTagNum,
PTagInfo,
Signatory,
SPos,
SDate
FROM
(qvd);
QRep:
LOAD QrepMcode,
QrepBcode,
QYr,
Quarter,
Taxable,
RCode,
RPUs,
Area,
LMVal,
BMVal175B,
BMVal175U,
MMVal,
IMVal,
LAVal,
BAVal175B,
BAVal175U,
MAVal,
IAVal,
Classif,
QrepPCINum,
QrepMDINum,
QrepBINum,
PKRpus,
Carpav,
Uliqav,
Oprav
FROM
(qvd);
RaaFile:
LOAD tran_code,
beg_fmor,
beg_toor,
beg_qty,
rec_fmor,
rec_toor,
rec_qty,
iss_fmor,
iss_toor,
iss_qty,
collname,
end_fmor,
end_toor,
end_qty
FROM
(qvd);
RevYear:
LOAD [rev-yr],
RYyear1,
RYyear2
FROM
(qvd);
RPClass:
LOAD Kind,
description,
SubCode
FROM
(qvd);
Rptar:
LOAD refdate,
refnum,
[assess-count],
[year-from],
[qtr-from],
[year-to],
[qtr-to],
basic_tax,
basic_penalty,
basic_discount,
sef_tax,
sef_penalty,
sef_discount,
total_tax,
total_penalty,
total_discount,
[assess-value],
total_paid
FROM
(qvd);
RPUnit:
LOAD RPUnitRPUNum,
RPUnitPCINum,
RPUnitMDINum,
PRUnitBINum,
RPUnitSINum,
Parcel,
NumAndStreet,
RPUnitPtype,
LSurveyNum,
LLotNum,
LBlkNum,
LNBound,
LEBound,
LSBound,
LWBound,
LSketchFile,
BPermitNum,
BPIssued,
RPUnitBCCT,
BCompletionIssued,
BOccupancyIssued,
BDateCompleted,
BDateOccupied,
MEAmenities,
Purok,
MPCINum,
MMDINum,
MSINum,
MParcel,
MPType,
MBINum,
LotBlkSurvey,
MTelecom
FROM
(qvd);
TaxNotice:
LOAD YearType,
nyear,
nQtrFm,
nQtrTo,
nPeriod,
nArp,
nAssVal,
nBasTax,
nBasNet,
nSEFTax,
nSEFNet,
nIdleTax,
nIdleNet,
nTotal
FROM
(qvd);
TempSysparam:
LOAD sys_lgutype,
sys_provcode,
sys_citycode,
sys_muncode,
sys_distcode,
sys_provname,
sys_cityname,
sys_muniname,
sys_provtreas,
sys_currtrn,
sys_ovrdate,
sys_update,
sys_reprint,
sys_citytreas,
sys_muntreas,
sys_formcust,
sys_custpos,
sys_directory
FROM
(qvd);
UserProg:
LOAD user_code,
module_code,
view_flag,
create_flag,
edit_flag,
cancel_flag,
delete_flag,
process_flag,
generate_flag,
seq_no
FROM
(qvd);
