VJC Metering Security Login

Username

Password

Web Apps Developed By:Gondren Apas|gondrenapas89@gmail.com

No.	Sector	Date	Work Order/s	Truck No./Crew	Description	Total Hrs	Billed Amount	Paid Amount	Balance	Status	Action

{{ x.RowNo }}	{{ x.Sector }}	{{ DateStyle(x.Date,'C') }}	{{ x.WorkOrders }}	{{ x.Crew }}	{{ x.Description }}	{{ x.TotalHrs }}	{{ NumberStyle(x.BilledAmount,"WCB") }}	{{ NumberStyle(x.PaidAmount,"WCB") }}	{{ NumberStyle(x.Balance,"WCB") }}	{{ x.PaymentStatus }}

{{NC1D2_Prev==0?"1 → "+NC1D2_Next+" of "+ NC1D1_FindResult.length:NC1D2_Prev+" → "+NC1D2_Next+" of "+ NC1D1_FindResult.length}}

Date			Sector
Truck No./Crew			Total Hrs
Description

WorkOrder	SI Code	Description	Qnty	SI Amount	Billed Amount	Paid Amount	Balance	Action
{{ x.WorkOrder }}	{{ x.SICode }}	{{ x.SIDescription }}	{{ x.SIQnty }}	{{ NumberStyle(x.SIAmount,"WC") }}	{{ NumberStyle(x.BilledAmount,"WC") }}	{{ NumberStyle(x.PaidAmount,"WC") }}	{{ NumberStyle(x.Balance,"WC") }}

Date	Sector	Crew	WorkOrder	Remarks
{{ x.Date }}	{{ x.Sector }}	{{ x.Crew }}	{{ x.WorkOrder }}	{{ x.Remarks }}

Date	W.O. No.	Crew	Sector	Act Count	Billed Amount	Paid Amount	Balance	Payment Status	SI Comp	Upl EAM Serv	With SIFM	Close	Action

{{x.Date}}	{{x.WorkOrder}}	{{x.Crew}}	{{x.Sector}}	{{x.ActCount}}	{{NumberStyle(x.BilledAmount,"WC")}}	{{NumberStyle(x.GRAmount,"WC")}}	{{NumberStyle(x.Balance,"WC")}}	{{x.PaymentStatus}}		{{x.UploadedEAMServices }}	{{x.WithSIForManual }}	{{x.Close}}

{{NC2T2_Prev==0?"1 → "+NC2T2_Next+" of "+ NC2T2_FindResult.length:NC2T2_Prev+" → "+NC2T2_Next+" of "+ NC2T2_FindResult.length}}

{{ NC2T2_PageContent[NC2T2_RowNo].RecordNo+":"+NC2T2_PageContent[NC2T2_RowNo].WorkOrder+":"+NC2T2_PageContent[NC2T2_RowNo].Crew+":"+NC2T2_PageContent[NC2T2_RowNo].Date}}

Upload PO From SAP

SI	Description	Qnty	Amount	P.O. No.	G.R. No.	Inv. No.	Inspected	Deleted	Contract	Con Sec	Con Off	Action
{{ x.Code }}	{{ x.Description }}	{{ NumberStyle(x.Qnty,"WC") }}	{{ NumberStyle(x.Amount,"WC") }}	{{ x.PO }}	{{ x.GR }}	{{ x.InvoiceNo }}	{{ x.Inspected }}	{{ x.Deleted }}	{{ x.ContractNo }}	{{ x.ContractingSector }}	{{ x.ContractingOffice }}
Total			{{ NumberStyle(SumCol(NC2T21_FindResult,'Amount'),"WC") }}

SI Code	Amount	PO	GR	Inspected	Deleted

{{x.Code}}	{{x.Amount}}	{{x.POTask}}	{{x.GR}}	{{ x.Inspected }}	{{ x.Deleted }}
	{{ NumberStyle(SumColIfs(NC2T22A_SAP,'Amount',item=>InStr(item.Amount,NC2T22A_Amount)>=0 && InStr(item.POTask,NC2T22A_PO)>=0 && InStr(item.Inspected,NC2T22A_Inspected)>=0 && InStr(item.Deleted,NC2T22A_Deleted)>=0),"WC") }}	{{ 'Count: '+CountColIfs(NC2T22A_SAP,'Amount',item=>InStr(item.Amount,NC2T22A_Amount)>=0 && InStr(item.POTask,NC2T22A_PO)>=0 && InStr(item.Inspected,NC2T22A_Inspected)>=0 && InStr(item.Deleted,NC2T22A_Deleted)>=0) }}

Service	Line Cost	PO	Inspected	Deleted

{{x.Code}}	{{x.Amount}}	{{x.PO}}	{{x.Inspected}}	{{x.Deleted}}
	{{ NumberStyle(SumColIfs(NC2T22B_EAM,'Amount',item=>InStr(item.Amount,NC2T22B_Amount)>=0 && InStr(item.PO,NC2T22B_PO)>=0 && InStr(item.Inspected,NC2T22B_Inspected)>=0 && InStr(item.Deleted,NC2T22B_Deleted)>=0),"WC") }}	{{ 'Count: '+CountColIfs(NC2T22B_EAM,'Amount',item=>InStr(item.Amount,NC2T22B_Amount)>=0 && InStr(item.PO,NC2T22B_PO)>=0 && InStr(item.Inspected,NC2T22B_Inspected)>=0 && InStr(item.Deleted,NC2T22B_Deleted)>=0) }}

Date	Crew	SI Code	SI Description	SI Qnty	SI Amount	Billed Amount	Paid Amount	Balance	Action
{{ DateStyle(x.Date,"C") }}	{{ x.Crew }}	{{ x.SICode }}	{{ x.SIDescription }}	{{ x.SIQnty }}	{{ NumberStyle(x.SIAmount,"WCB") }}	{{ NumberStyle(x.BilledAmount,"WCB") }}	{{ NumberStyle(x.PaidAmount,"WCB") }}	{{ NumberStyle(x.Balance,"WCB") }}
Total						{{ NumberStyle(SumCol(NC2T23A_FindResult,"BilledAmount"),"WCB")}}	{{ NumberStyle(SumCol(NC2T23A_FindResult,"PaidAmount"),"WCB")}}	{{ NumberStyle(SumCol(NC2T23A_FindResult,"Balance"),"WCB")}}

Crew	Date	SI Code	SI Qnty	SI Amount	Billed Amount	Action
{{ x.Crew }}	{{ DateStyle(x.Date,"C") }}	{{ x.SICode }}	{{ x.SIQnty }}	{{ NumberStyle(x.SIAmount,"WCB") }}	{{ NumberStyle(x.BilledAmount,"WCB") }}

SI Code	SI Description	Billed Qnty	Billed Amount	PO SI Qnty	PO SI Amount	GR SI Qnty	GR SI Amount	Bal Qnty	Bal Amount
{{x.SICode}}	{{x.SIDescription}}	{{ NumberStyle(x.BilledQnty,"WCB") }}	{{ NumberStyle(x.BilledAmount,"WCB") }}	{{ NumberStyle(x.POQnty,"WCB") }}	{{ NumberStyle(x.POAmount,"WCB") }}	{{ NumberStyle(x.GRQnty,"WCB") }}	{{ NumberStyle(x.GRAmount,"WCB") }}	{{ NumberStyle(x.BalQnty,"WCB") }}	{{ NumberStyle(x.BalAmount,"WCB")}}
Total		{{ NumberStyle(SumCol(NC2T23C_FindResult,"BilledQnty"),"WCB") }}	{{ NumberStyle(SumCol(NC2T23C_FindResult,"BilledAmount"),"WCB") }}	{{ NumberStyle(SumCol(NC2T23C_FindResult,"POQnty"),"WCB") }}	{{ NumberStyle(SumCol(NC2T23C_FindResult,"POAmount"),"WCB") }}	{{ NumberStyle(SumCol(NC2T23C_FindResult,"GRQnty"),"WCB") }}	{{ NumberStyle(SumCol(NC2T23C_FindResult,"GRAmount"),"WCB") }}	{{ NumberStyle(SumCol(NC2T23C_FindResult,"BalQnty"),"WCB") }}	{{ NumberStyle(SumCol(NC2T23C_FindResult,"BalAmount"),"WCB") }}

Your session is about to expire due to inactivity.

You will be logged out in

{{(MaxInactivity - SecondInactiveCounter)+"s." }}

Just move the mouse here to continue.