| COLUMN IN A STANDARD REPORT | DESCRIPTION |
|---|
| Location ID | Identification number of the location for which the invoiced work order was created |
| Location Name | Name of the location for which the invoiced work order was created |
| Address | Main address of the work order location |
| Provider | Company name of the provider who performed the requested work and submitted the invoice |
| Trade | Trade of the invoiced work order |
| W.O # | Number of the invoiced work order |
| Tr. # | Tracking number of the invoiced work order |
| Category | Category the invoiced work order belongs to |
| Priority | Priority of the invoiced work order |
| ProblemCode | Problem code of the invoiced work order |
| ProblemDescription | Issue description provided upon creating a work order |
| TagID | Tag ID of the asset associated with the work order the invoice was created for |
| InvoiceNumber | Number of the invoice |
| Inv.Date | Invoice date selected upon creating the invoice |
| Posted Date | Date when the invoice was actually submitted — can be different from the invoice date |
| Posted By | User ID of a person who created the invoice |
| Inv.Text | Problem resolution entered by the provider upon creating the invoice |
| Inv.Status | Invoice status at the moment of exporting the invoice report |
| Approved By | Username of a person who approved the invoice |
| Approved By UserID | User ID of a person who approved the invoice |
| Approve Date | Date and time when the invoice was approved |
| Batch ID | Identification number of the payment batch the invoice is added to |
| ApprCodeMajor | Invoice approval code, also known as GL code |
| ApprCodeMinor | When ApprCodeMajor is empty, this column will contain an automatically generated invoice approval code |
| Currency | Currency of the invoice total amount |
| Inv.Total | Total amount to be paid to the provider for the performed service |
| Vendor ID | Identification number given to the provider by their subscriber |
| Last Payment Date | Date when the invoice was paid |
| Last Payment Number | Payment number that is generated after the invoice is paid |
| Payment Amount | Invoice amount that was paid | Note |
|---|
Should you need to change the decimal point (.) to decimal comma (,) on monetary amounts, contact your ServiceChannel representative. |
|
| Comments | Comment the subscriber left upon taking action on the invoice. The comment is required upon rejecting an invoice but can be skipped upon approving or putting the invoice on hold. |
| Marked for Audit | Shows whether or not the invoice was marked for an audit via dashboard |
| Completed Date | Date when the related work order was moved to a “Completed” status |
| Region | Region of the location for which the invoiced work order was created |
| District | District of the location for which the invoiced work order was created |
| Travel Amount | Amount of travel charges |
| Labor | Amount of labor charges |
| Material | Amount of material charges |
| Freight | Amount of freight charges |
| Other | Amount of other charges |
| Sales Tax | Sales tax amount |
| Sales Tax 2 | Invoice second tax amount (typically PST, QST, or HST for Canada). Multiple taxes are required for some Canadian locations. |
| Total IVR/Check-in Hrs | Total time in hours a provider spent on site based on check-in/out records. |
| Invoice billed Hrs | Total labor time in hours a provider specified in the invoice. |
| W.O. Transf. Date | Transfer date of the work order for which the invoice was created |
| Inv. Transf. Date | Date when the approved invoice was transferred to the client’s accounting department for payment. Learn more about transferred invoices. |
| PO # | Purchase order number of the invoiced work order |
| Rejected Date | The date when the invoice was rejected. If the invoice was not rejected, the field under the column is empty. |
