|
|
Inc. No./Work Order | With SI | Inc Assigned | Inc Attachment | Inc Issuance | Inc Returned | Inc ABS | Inc ABF | Inc Spec Form | Inc SI Comp | |
| Sector | Department | Pole Tag | Crew | WO Assigned | WO Attachment | WO Issuance | WO Returned | WO ABS | WO ABF | WO Spec Form | WO SI Comp |
| Description | Inc Remarks | WO Remarks | Notes | Coordinator | Supervisor | Team | SR Printed | Payment Status |
| No | Date | Inc. No. | W.O. No. | Pole Tag | Description | Inc PO Amt | Inc Bill Amt | Inc GR Amount | Inc Balance | WO PO Amt | WO Bill Amt | WO GR Amount | WO Balance | Payment Status | Inc Remarks | WO Remarks | Notes | Inc SI Comp | WO SI Comp | With SI | SR Printed | Inc Assigned | Inc Attachment | Inc Issuance | Inc Returned | Inc ABS | Inc Specs Form | Inc ABF | Inc EAM Status | WO Assigned | WO Attachment | WO Issuance | WO Returned | WO ABS | WO Specs Form | WO ABF | WO EAM Status | Sector | Department | Coordinator | Crew | Supervisor | Shift | Team | Aging | # | # |
| {{ x.Date }} | {{ x.IncNo }} | {{ x.WorkOrder }} | {{ x.PoleTag }} | {{ x.Description }} | {{ x.IncPOAmt }} | {{ x.IncBillAmt }} | {{ x.IncGRAmt }} | {{ x.IncBalance }} | {{ x.WOPOAmt }} | {{ x.WOBillAmt }} | {{ x.WOGRAmt }} | {{ x.WOBalance }} | {{ x.PaymentStatus }} | {{ x.IncRemarks }} | {{ x.WORemarks }} | {{ x.Notes }} | {{ x.IncSICompleted }} | {{ x.WOSICompleted }} | {{ x.WithSI }} | {{ x.SRPrinted }} | {{ x.IncAssigned }} | {{ x.IncAttachment }} | {{ x.IncIssuance }} | {{ x.IncReturned }} | {{ x.IncABS }} | {{ x.IncSpecsForm }} | {{ x.IncABF }} | {{ x.IncEAMStatus }} | {{ x.WOAssigned }} | {{ x.WOAttachment }} | {{ x.WOIssuance }} | {{ x.WOReturned }} | {{ x.WOABS }} | {{ x.WOSpecsForm }} | {{ x.WOABF }} | {{ x.WOEAMStatus }} | {{ x.Sector }} | {{ x.Department }} | {{ x.Coordinator }} | {{ x.Crew }} | {{ x.Supervisor }} | {{ x.Shift }} | {{ x.Team }} | {{ x.Aging }} |
| Date | Inc. No. | Inc Assigned | Inc Attachment | Inc Issuance | Inc Returned | Inc ABS | Inc ABF | Inc Spec Form | Inc SI Completed |
| Sector | Work Order | WO Assigned | WO Attachment | WO Issuance | WO Returned | WO ABS | WO ABF | WO Spec Form | WO SI Completed |
| Department | Pole Tag | Crew | Coordinator | Supervisor | Shift | Team | Inc EAM Status | WO EAM Status | SR Printed |
| Description | Inc Remarks |
| Notes | WO Remarks |
| Inc PO Amt | Inc Bill Amt | Inc GR Amt | Inc Balance | WO PO Amt | WO Bill Amt | WO GR Amt | WO Balance | Payment Status | |
| For | IncNo/WO | Service Item | Description | Qnty | Unit Cost | Amount | Less PO | Less Related SI | Balance | Action | |||||
| Qnty | Amount | SI | Qnty | Amount | Qnty | Amount | |||||||||
| {{ x.For}} | {{ x.IncWO }} | {{ x.ServiceItem }} | {{ x.Description }} | {{ x.Qnty }} | {{ x.UnitCost }} | {{ x.Amount }} | {{ x.POQnty }} | {{ x.POAmount }} | {{ x.RelatedSI }} | {{ x.RelatedSIQnty }} | {{ x.RelatedSIAmount }} | {{ x.BalQnty }} | {{ x.BalAmount }} | ||
| Total Inc SI | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","Qnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","Amount"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","POQnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","POAmount"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","RelatedSIQnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","RelatedSIAmount"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","BalQnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","Inc","BalAmount"),"WC") }} | |||||||
| Total WO SI | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","Qnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","Amount"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","POQnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","POAmount"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","RelatedSIQnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","RelatedSIAmount"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","BalQnty"),"WC") }} | {{ NumberStyle(SumColIf(TC1D51212_FindResult,"For","WO","BalAmount"),"WC") }} | |||||||
| IncNo/WO | P.O. No. | G.R. No. | Inv. No. | P.O. Date | G.R. Date | SI Code | Description | Qnty | Amount | Cont. Sector | Cont. Office | Dltd | Ignore | Action |
| {{ x.IncWO }} | {{ x.PONo }} | {{ x.GRNo }} | {{ x.InvoiceNo }} | {{ DateStyle(x.PODate,"C") }} | {{ DateStyle(x.GRDate,"C") }} | {{ x.SICode }} | {{ x.Description }} | {{ NumberStyle(x.Qnty,"WC") }} | {{ NumberStyle(x.Amount,"WC") }} | {{ x.ContractingSector }} | {{ x.ContractingOffice }} | {{ x.Deleted }} | {{ x.IgnorePO }} |
| Date & Time | Affected Column | Previous Value | New Value | User | Work Station |
| {{ DateStyle(x.DateTime,"DT") }} | {{ x.AffectedColumn }} | {{ x.PreviousValue }} | {{ x.NewValue }} | {{ x.User }} | {{ x.WorkStation }} |
| IncNo | WorkOrder | Description | PoleTag | Crew | Shift | Date | IncBillAmt | WOBillAmt | Supervisor | Coordinator | Sector | Department | IncRemarks | WORemarks | Team | Notes | System Remarks |
| {{ x.IncNo }} | {{ x.WorkOrder }} | {{ x.Description }} | {{ x.PoleTag }} | {{ x.Crew }} | {{ x.Shift }} | {{ x.Date }} | {{ x.IncBillAmt }} | {{ x.WOBillAmt }} | {{ x.Supervisor }} | {{ x.Coordinator }} | {{ x.Sector }} | {{ x.Department }} | {{ x.IncRemarks }} | {{ x.WORemarks }} | {{ x.Team }} | {{ x.Notes }} | {{ x.SystemRemarks }} |
| No | Sector | Crew | Input By | Update By | Action | |
| No | Sector | Coordinator | Input By | Update By | Action | |
| No | Sector | Supervisor | Input By | Update By | Action | |
| SI Code | Description | Qnty | Unit Cost |
| {{ x.ServiceItem }} | {{ x.Description }} | {{ x.Qnty }} | {{ NumberStyle(x.UnitCost,"WC") }} |
| Inc/WO | Supervisor | OLD EAM Status | New EAM Status | Remarks |
| {{ x.IncWO }} | {{ x.Supervisor }} | {{ x.OldEAMStatus }} | {{ x.NewEAMStatus }} | {{ x.Remarks }} |