VJC Vendor Warehouse

VJC Vendor WareHouse Login

Username

Password

{{ Quotes }}

{{ "-" + QuotesAuthor +"-" }}

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

{{ "WELCOME "+ UserData.FirstName + " " + UserData.LastName }}

Work Order			With EAM Issuance
Description			Location
Sector			Department
Status			No. of Rows

{{TC1D1_Prev==0?"1 → "+TC1D1_Next+" of "+ TC1D1_FindResult.length:TC1D1_Prev+" → "+TC1D1_Next+" of "+ TC1D1_FindResult.length}}

No	Work Order	Description	Location	Sector	Department	Date Rcv'd	Date Enrgz'd	Date Cmplt'd	Status	Action
{{ i.RowNo }}	{{ i.WorkOrder }}	{{ i.CustomerName.toUpperCase()}}	{{ i.Location.toUpperCase() }}	{{ i.Sector.toUpperCase() }}	{{ i.Department.toUpperCase() }}	{{ DateStyle(i.DateReceived,'C') }}	{{ DateStyle(i.DateEnergized,'C') }}	{{ DateStyle(i.DateCompleted,'C') }}	{{ i.WO_Status}}

{{ TC1D2_WODetails.substring(0,60) }} {{ TC1D22_TabTitle }} {{ TC1D22_SubTitle }}

	Transaction No.	{{ TC1D221_HeadR1[i][x] }}
	Type	{{ TC1D221_HeadR2[i][x] }}
	Date	{{ TC1D221_HeadR3[i][x] }}
	Crew	{{ TC1D221_HeadR4[i][x] }}
Code	Description	{{ TC1D221_HeadR5[i][x] }}
{{ x>1?NumberStyle(TC1D221_Body[i][x],"WCB"):TC1D221_Body[i][x] }}

Code	Description	WFMS	IFVW	RTVW	RTMS	Balance	BFOW	BBOW	BalanceIA	RTVW-Sal	RTMS-Sal	Balance-Sal
		SURPLUS								SALVAGE
{{ i.Code }}	{{ i.Description }}	{{ NumberStyle(i.WFMS,"WCB") }}	{{ NumberStyle(i.IFVW,"WCB") }}	{{ NumberStyle(i.RTVW,"WCB") }}	{{ NumberStyle(i.RTMS,"WCB") }}	{{ NumberStyle(i.Balance,"WCB") }}	{{ NumberStyle(i.BFOW,"WCB") }}	{{ NumberStyle(i.BBOW,"WCB") }}	{{ NumberStyle(i.BalanceIA,"WCB") }}	{{ NumberStyle(i.RTVW_Sal,"WCB") }}	{{ NumberStyle(i.RTMS_Sal,"WCB") }}	{{ NumberStyle(i.Balance_Sal,"WCB") }}

{{ TC1D2223_Title }}

WorkOrder	Customer Name	Date	Crew	Qnty
{{ i.WorkOrder }}	{{ i.CustomerName }}	{{ DateStyle(i.Date,"DT") }}	{{ i.Crew }}	{{ i.Qnty }}

Issuance Order

Trans. No	Generated By	Last Downloaded By	Action
{{ j.Transaction_No}}	{{ j.Input_By}}	{{ j. Downloaded_By}}

{{ TC1D2225_Title }}

Transaction No.	Date	Crew	Type	Quantity	Running Balance
{{ x.TransactionNo }}	{{ DateStyle(x.Date,"DT") }}	{{ x.Crew }}	{{ x.TransactionType }}	{{x.MO}}{{ NumberStyle(x.Qnty,"WCB") }}	{{ NumberStyle(x.RunningBalance,"WCB") }}

Trans. No	Trans. Type	Date	Crew	Received By	Remarks	RC		Action

						{{ TC1D2231_FindResult[i].RowCount }}

Allowed input by Code

WFMS ID
Page
Row No.
Reservation No.
Code
Class
Description
Quantity
Serial No.

Input By
Deleted
Deleted By

WFMS ID	Page	RowNo	ReserveNo	Code	Description	Balance	Serial	Dltd

{{ x.WFMSID }}	{{x.Page }}	{{x.RowNo }}	{{x.ReserveNo }}	{{x.Code }}	{{x.Description }}	{{ x.Qnty }}	{{ x.SerialNo }}

Transaction No	Date	Crew	Received By	Page	Row No.	Code	Description	Quantity	DT Serial	Input By	Dltd

{{ x.TransactionNo }}	{{ DateStyle(x.Date,"DT") }}	{{ x.Crew }}	{{ x.InCharge }}	{{ x.Page }}	{{ x.RowNo }}	{{ x.Code }}	{{ x.Description }}	{{ x.Qnty }}	{{ x.DTSerialNo }}	{{ x.InputBy }}
Total								{{ NumberStyle(SumColIf(TC1D2233_FindResult,"Code",TC1D2233_Code,"Qnty"),"WCB") }}

Trans. No	Trans. Type	Date	Crew	Issued By	Remarks	RC		Action
						{{ TC1D2241_FindResult[i].RowCount }}

IFVW ID
Page			Row No.
Code			Class
Description
Balance
Quantity			TBQFIOS

Sector	WorkOrder	Customer Name	Balance	BQFIOS

{{ x.FrSector }}	{{ x.FrWorkOrder}}	{{ x.FrCustomerName}}	{{ NumberStyle(x.Balance,"WCB")}}
Total				{{ NumberStyle(SumCol(TC1D2242_NFromWorkOrders,"BQFIOS"),"WCB") }}

Input By	:
Deleted	:
Deleted By	:

IFVW ID	Page	Item	Code	Description	Balance	Quantity	TBQFIOS	Dltd

{{x.IFVWID }}	{{x.Page }}	{{x.RowNo }}	{{x.Code }}	{{x.Description }}	{{ NumberStyle(x.Balance,"WCB") }}	{{ NumberStyle(x.Quantity,"WCB") }}	{{ NumberStyle(x.TBQFIOS,"WCB") }}

Transaction No	Date	Crew	Issued By	Page	Row No.	Code	Description	Total Qnty	Borrowed Qnty	Input By	Dltd

{{ x.TransactionNo }}	{{ DateStyle(x.Date,"DT") }}	{{ x.Crew }}	{{ x.InCharge }}	{{ x.Page }}	{{ x.RowNo }}	{{ x.Code }}	{{ x.Description }}	{{ NumberStyle(x.TotalQnty,"WCB") }}	{{ NumberStyle(x.BorrowedQnty,"WCB") }}	{{ x.InputBy }}
Total							{{ NumberStyle(SumColIf(TC1D2243_FindResult,"Code",TC1D2243_Code1,"TotalQnty"),"WCB") }}	{{ NumberStyle(SumColIf(TC1D2243_FindResult,"Code",TC1D2243_Code1,"BorrowedQnty"),"WCB") }}

Trans. No.	Date	Code	Description	Fr WorkOrder	Fr Customer Name	Purpose	Borrowed Qnty	Returned Qnty	Balance	Input By	Dltd

{{ x.TransactionNo }}	{{ DateStyle(x.Date,"DT") }}	{{ x.Code }}	{{ x.Description }}	{{ x.FrWorkOrder }}	{{ x.FrCustomerName }}	{{ x.Purpose }}	{{ NumberStyle(x.BorrowedQnty,"WCB") }}	{{ NumberStyle(x.ReturnedQnty,"WCB") }}	{{ NumberStyle(x.Balance,"WCB") }}	{{ x.InputBy }}

Trans. No	Trans. Type	Entry Type	Date	Crew	Received By	Remarks	RC		Action

							{{ TC1D2261_FindResult[i].RowCount }}

RTVW ID
Page
Row No.
Code
Entry Type
Description
Quantity

Input By
Deleted
Deleted By

RTVW ID	Page	Row No.	Code	Description	Qnty	Dlt

{{ x.RTVWID }}	{{ x.Page }}	{{ x.RowNo }}	{{ x.Code }}	{{ x.Description }}	{{ NumberStyle(x.Qnty,"WCB") }}

Transaction No	Date	Crew	Received By	Page	Row No.	Code	Description	Qnty	Type	Input By	Dltd

{{ x.TransactionNo }}	{{ DateStyle(x.Date,"DT") }}	{{ x.Crew }}	{{ x.InCharge }}	{{ x.Page }}	{{ x.RowNo }}	{{ x.Code }}	{{ x.Description }}	{{ NumberStyle(x.Qnty,"WCB") }}	{{ x.EntryType }}	{{ x.InputBy }}
Total							{{ NumberStyle(SumColIf(TC1D2263_FindResult,"Code",TC1D2263_Code1,"Qnty"),"WCB") }}

Trans. No	Trans. Type	Return Type	Date	Crew	Prepared By	Remarks	RC		Action

Return Type			RTMS ID
Page			Row No.
Code			Class
Description
Balance
Quantity			TBQFVC

Sector	WorkOrder	Customer Name	Balance	BQFVC

{{ x.FrSector }}	{{ x.FrWorkOrder}}	{{ x.FrCustomerName}}	{{ NumberStyle(x.Balance,"WCB")}}
Total				{{ NumberStyle(SumCol(TC1D2272_NFromWorkOrders,"BQFVC"),"WCB") }}

Input By	:
Deleted	:
Deleted By	:

RTMS ID	Page	Row No	Code	Description	Balance	Quantity	TBQFVC	Dltd

{{x.RTMSID }}	{{x.Page }}	{{x.RowNo }}	{{x.Code }}	{{x.Description }}	{{ NumberStyle(x.Balance,"WCB") }}	{{ NumberStyle(x.Quantity,"WCB") }}	{{ NumberStyle(x.TBQFVC,"WCB") }}

Transaction No	Date	Crew	Prepared By	Page	Row No.	Code	Description	Qnty	B-Qnty	Type	Input By	Dltd

{{ x.TransactionNo }}	{{ DateStyle(x.Date,"DT") }}	{{ x.Crew }}	{{ x.InCharge }}	{{ x.Page }}	{{ x.RowNo }}	{{ x.Code }}	{{ x.Description }}	{{ NumberStyle(x.Qnty,"WCB") }}	{{ NumberStyle(x.BorrowedQnty,'WC') }}	{{ x.EntryType }}	{{ x.InputBy }}
Total								{{ NumberStyle(SumColIf(TC1D2273_FindResult,"Code",TC1D2273_Code1,"Qnty"),"WCB") }}	{{ NumberStyle(SumColIf(TC1D2273_FindResult,"Code",TC1D2273_Code1,"BorrowedQnty"),"WCB") }}

{{ 'Date Uploaded: '+TC1D228_DateUploaded }}

Task	Reserve No	Code	Description	Rsrv Qnty	ERP Iss Qnty	Exclude

{{ x.Task }}	{{ x.ReserveNo }}	{{ x.Code }}	{{ x.Description }}	{{ NumberStyle(x.Reserved_Qnty,"WCB") }}	{{ NumberStyle(x.ERP_Issued_Qnty,"WCB") }}

Code	Description	WFMS	EAM Issuance	Difference
{{ i.Code }}	{{ i.Description }}	{{ NumberStyle(i.WFMS,"WC") }}	{{ NumberStyle(i.EAMIssuance,"WC") }}	{{ NumberStyle(i.Difference,"WC") }}

No.	Crew	Enabled	Action

{{x.Code}} {{x.Alias}} {{x.Class}} {{x.Description}} Show Work Order Download Item Transaction

{{TC2D13_Prev==0?"1 → "+TC2D13_Next+" of "+ TC2D1_FindResult.length:TC2D13_Prev+" → "+TC2D13_Next+" of "+ TC2D1_FindResult.length}}

Work Order	Customer Name	Status	Sector	Code	WFMS	IFVW	RTVW	RTMS	Balance	BFOW	BBOW	Balance

{{ x.WorkOrder }}	{{ x.CustomerName }}	{{ x.WOStatus }}	{{ x.Sector }}	{{ x.Code }}	{{ NumberStyle(x.WFMS,"WCB") }}	{{ NumberStyle(x.IFVW,"WCB") }}	{{ NumberStyle(x.RTVW,"WCB") }}	{{ NumberStyle(x.RTMS,"WCB") }}	{{ NumberStyle(x.Balance,"WCB") }}	{{ NumberStyle(x.BFOW,"WCB") }}	{{ NumberStyle(x.BBOW,"WCB") }}	{{ NumberStyle(x.NewBalance,"WCB") }}

Sector	Code	Description	UoM	Beg. Inv	WFMS	IFVW	RTVW-Sur	RTVW-Sal	RTMS-Sur	RTMS-Sal	Clo. Inv

{{x.Sector}}	{{x.Code}}	{{x.Description }}	{{x.UoM}}	{{ NumberStyle(x.BI,"WCB") }}	{{ NumberStyle(x.WFMS,"WCB") }}		{{ NumberStyle(x.RTVW_Sur,"WCB")}}	{{ NumberStyle(x.RTVW_Sal,"WCB")}}		{{ NumberStyle(x.RTMS_Sal,"WCB")}}	{{ NumberStyle(x.CI,"WCB")}}

Month	Year	Action
{{ x.Month}}	{{ x.Year}}

Record No.

Date

Work Order No.

Sector

Code

Class

Description

Remaining Balance

Quantity

Work Order	Customer Name	Sector	Department	Action

{{ x.WorkOrder }}	{{ x.CustomerName }}	{{ x.Sector }}	{{ x.Department }}

Code	Description	WFMS	IFVW	RTVW	RTMS	Balance
{{ x.Code }}	{{ x.Description }}	{{ NumberStyle(x.WFMS,"WC") }}	{{ NumberStyle(x.IFVW,"WC") }}	{{ NumberStyle(x.RTVW,"WC") }}	{{ NumberStyle(x.RTMS,"WC") }}	{{ NumberStyle(x.Balance,"WC") }}

{{ "Item Code:"+TC5D121_FindResult[TC5D122_RowNo].Code+"-"+TC5D121_FindResult[TC5D122_RowNo].Description}}

Sector	Department	Work Order	WO Description	Date Receieved	Date	Code	Type	Qnty	RT

{{ x.Sector }}	{{ x.Department }}	{{ x.WorkOrder }}	{{ x.CustomerName }}	{{ DateStyle(x.DateRecieved,"C") }}	{{ DateStyle(x.TransDate,"DO") }}	{{ x.Code }}	{{ x.Type }}	{{ x.Sign }}{{ NumberStyle(x.Qnty,"WC") }}	{{ NumberStyle(x.RunningTotal,"WC") }}

Sector			Crew
Work Order			Customer Name
Transaction No			Transaction Type

{{TC6D1_Prev==0?"1 → "+TC6D1_Next+" of "+ TC6D2_FindResult.length:TC6D1_Prev+" → "+TC6D1_Next+" of "+ TC6D2_FindResult.length}}

Sector	WorkOrder	Customer Name	Date Generated	Trans. No.	Trans. Type	Trans. Date	Crew	Issuer/Receiver	Input By
{{ x.Sector }}	{{ x.WorkOrder }}	{{ x.CustomerName }}	{{ DateStyle(x.DateGenerated,"DT") }}	{{ x.TransactionNo }}	{{ x.EntryType.length>0?x.TransactionType+"-"+x.EntryType:x.TransactionType }}	{{ DateStyle(x.Date,"DT") }}	{{ x.Crew }}	{{ x.InCharge }}	{{ x.InputBy }}

Transaction No			Transaction Date
Code			Sector
WorkOrder			Date Received

Sector	Department	Transaction No	Date	WorkOrder	WO Description	Date Rcv'd	Fr WorkOrder	Code	Description	Borrowed Qnty	Returned Qnty	Balance	Aging(Day)
{{ x.Sector }}	{{ x.Department }}	{{ x.TransactionNo}}	{{ DateStyle(x.Date,"DT")}}	{{ x.WorkOrder}}	{{ x.CustomerName}}	{{ x.DateReceived}}	{{ x.FrWorkOrder}}	{{ x.Code}}	{{ x.Description}}	{{ NumberStyle(x.BorrowedQnty,"WC")}}	{{ NumberStyle(x.ReturnedQnty,"WC")}}	{{ NumberStyle(x.Balance,"WC")}}	{{ x.Aging }}

{{TC7D2_Prev==0?"1 → "+TC7D2_Next+" of "+ TC7D3_FindResult.length:TC7D2_Prev+" → "+TC7D2_Next+" of "+ TC7D3_FindResult.length}}

Code			Sector
Date Range			Transaction Type
Crew			WorkOrder

Sector	Transaction Type	Work Order	WO Description	Date	Crew	Code	Description	Qnty
{{ x.Sector}}	{{ x.TransactionType}}	{{ x.WorkOrder }}	{{ x.CustomerName }}	{{ DateStyle(x.Date,"DT")}}	{{ x.Crew}}	{{ x.Code}}	{{ x.Description}}	{{ x.Quantity}}

{{TC8D4_Prev==0?"1 → "+TC8D4_Next+" of "+ TC8D3_FindResult.length:TC8D4_Prev+" → "+TC8D4_Next+" of "+ TC8D3_FindResult.length}}

Sector

No	Work Order	Sector	Department	Description	Date Received	WFMS Date	Iss Date Uploaded
{{ (i+1) }}	{{ x.WorkOrder }}	{{ x.Sector }}	{{ x.Department }}	{{ x.CustomerName }}	{{ DateStyle(x.DateReceived,"C") }}	{{ DateStyle(x.WFMSDate,"DT") }}	{{ DateStyle(x.DateUploaded,"DT") }}