The Pivot Table Glossary is an alphabetical list of all the terms used in Quantify's pivot tables. Use it to quickly understand the meaning of pivot table fields and how they were put together. You can use the glossary to learn:
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
The item in the pivot table being described | The meaning of the term as used Quantify | A list of pivot tables where the term can be found | The record from which the information used in the term is taken |
Note: When searching for a term, press CRTL + F to initiate a search field into which you can enter the desired term.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
A
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Access Point Count | The number of access points associated with a scaffold | Inspection History Pivot, Inspections Due Pivot, Scaffold Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Access Points |
Access Point Description | A description of the access point of a scaffold | Inspections Due Pivot | Scaffold Register: Tag: Access Points |
Access Point Name | The name of the access point of a scaffold | Inspections Due Pivot | Scaffold Register: Tag: Access Points |
Active | Indicates whether job site is active | Billable Job site Summary | Job site: General: Active |
Activity Actual Cost | The actual cost of specified scaffold activity | Scaffold Activity Pivot | Scaffold Register: Activity: Units Hours and Costs: Actual Cost |
Activity Count | The number of activities associated with a scaffold | Inspection History Pivot, Inspections Due Pivot, Scaffold Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Activities |
Activity Detail | The details associated with a scaffold activity | Scaffold Activity Pivot | Scaffold Register: Activity: General: Detail |
Activity Planned Cost | the planned cost of a scaffold activity | Scaffold Activity Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Activities: Activity: Unit Hours and Costs: Planned Costs |
Activity Shift | The shift associated with a scaffold activity | Scaffold Activity Pivot | Scaffold Register: Activity: General: Shift |
Activity Summary | The summary of an activity type | Scaffold Activity Pivot | Scaffold Register: Activity: General: Summary |
Activity Type | The type of activity associated with a scaffold | Scaffold Activity Pivot | Scaffold Register: Activity: General: Activity Type |
Actual Build | The date a scaffold was actually built | Inspection History Pivot, Inspections Due Pivot, Scaffold Activity Pivot, Scaffold Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates and Inspections: Actual Dates: Build |
Actual Date | The date of actual shipment | Shipment Pivot For Scaffold, Shipment Additional Charges Pivot, Shipment Consumables Pivot, Shipment Pivot | Shipment: Shipment: Summary: Actual Ship |
Actual Days Up | The real number of days scaffold is erect | Inspection History Pivot, Inspections Due Pivot, Scaffold Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates and Inspections: Actual Days Up |
Actual Dismantle | The real date scaffold is dismantled | Inspection History Pivot, Inspections Due Pivot, Scaffold Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates and Inspections: Actual Dates: Dismantle |
Actual Load | The real date scaffold materials are loaded | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates and Inspections: Actual Dates: Load |
Actual Units | The number of unit-hours associated with a specified scaffold activity | Scaffold Activity Pivot | Scaffold Register: Activity: Units Hours and Costs: Unit-Rate Charge: Actual |
Additional Charge | The additional charges associated with an invoice | Invoice Additional Charges Pivot | Shipment: Additional Charges |
Additional Charge Description | A description of additional charges associated with an estimate | Estimate Detail Pivot | Estimate: Additional Charges |
Additional Charge Name | The name of additional charges associated with an estimate | Estimate Detail Pivot | Estimate: Additional Charges |
Additional Charge Units | The unit type of additional charges associated with an estimate | Estimate Detail Pivot | Estimate: Additional Charges |
Additional Charge Weight | The weight of additional charges associated with an estimate | Estimate Detail Pivot | Estimate: Additional Charges |
Additional Charges | The additional charges associated with a job site | Estimate Detail Pivot, Estimate Detail Pivot, Invoice Pivot | New Direct Shipment: Additional Charges |
Adjustments | The number of rated adjustments applied to a scaffold | Scaffold Pivot, Job Sites and Groups Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Rate Adjustments |
Advance Min Days | The minimum day's rent for a job site | Billable Jobsite Summary | Job Site: Billing |
Arrears Cycle | The period associated with an arrears cycle | Billable Jobsite Summary | Job Site: Billing |
Arrears Cycle Type | Indicates whether an arrears cycle is daily, weekly or monthly | Billable Jobsite Summary | Job Site: Billing |
Arrears Min Days | The minimum days rent for a job site | Billable Jobsite Summary | Job Site: Billing |
Assigned To | The name of employee to which a request is assigned | Request Products, Requests | Requests: Summary |
Available | Indicates that a transaction is for available items | Service Ticket Pivot | Transaction: Available |
Available-Backordered | Indicates that transaction is for available items on backorder | Estimate Summary Pivot, Transaction Pivot, Transaction Products Pivot, Invoice Additional Charges Pivot, Invoice Pivot | Available Items Ordered Minus Available Items Received |
Available-Cancelled | Indicates that a transaction is for available items where the backorder has been cancelled | Service Ticket Pivot | Available Cancelled Backorder |
Available-Ordered | Indicates that a transaction is for available items that have been ordered | Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Available Items Ordered |
Available-Received | Indicates that a transaction is for available items that have been received | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Available Items Received |
Avg Cost (Ea) | The average cost to purchase one unit of a product | Pivot For All Order Transactions | Product Catalog: Avg. Cost |
Avg Cost at Time of Transaction | The average cost of an item when the transaction was created | Job Sites and Groups Pivot | Product Catalog: Avg. Cost |
Avg. Cost Available | The average cost of the available units for a specific part | Pivot For All Order Transactions | Transaction: Avg Cost |
Avg. Cost Each | The average cost for a quantity of a specific part | Pivot For All Order Transactions | Transaction: Avg Cost |
Avg. Cost On Rent | The average cost of catalog | Shipment Pivot For Scaffold | Transaction: Avg Cost |
Avg Daily Rent | The average rental price for re-rent items | Pivot For All Order Transactions | Re-Rent: Products: Total |
B
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Backordered | The quantity of a product on backorder | Pivot For All Order Transactions, Transaction Products Pivot | Branch: Products: Backordered |
Backordered New | The quantity of a product that has been ordered as new but not fulfilled | Rent Extension Pivot | Branch: Products: Backordered New |
Base Elev. | The base elevation of a scaffold | Product Pricing Pivot | Location: Scaffold Register: General: Base Elev. |
Billable | Indicates whether a shipment is billable | Product Pricing Pivot | Shipment: Shipment: Summary: Billing for Delivery |
Billing Cycle Begin | The start date of the most current billing cycle | Product Pricing Pivot | Job Site: Billing: Billing Method |
Billing Cycle End | The end date of the most current billing cycle | Pivot For All Order Transactions, Product Quantity Pivot | Job Site: Billing: Billing Method |
Billing Method | Indicates whether a billing method is arrears, FATA or advance | Product Quantity Pivot | Job Site: Billing: Billing Method |
Branch Office | The branch office associated with a service ticket | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Service Ticket: + |
Builder | The builder name associated with a scaffold | Transaction Pivot, Transaction Products Pivot, Shipment Pivot | Location: Scaffold Register: General: Builder |
C
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Canceled | The amount of backorded product that has been canceled | Pivot For All Order Transactions | Back Order: Quantity |
Catalog | The group type or category to which a product belongs | Billable Jobsite Summary, Job Sites and Groups Pivot | Product Catalog: Category |
Category | The product category to which a part is assigned | Service Ticket Pivot | Product Catalog: Category |
Completed | Indicates whether a request has been completed | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Request: Summary: Completed |
Cost | The cost of an additional charge | Product Pricing Pivot | Shipment: Additional Charges |
Cost | The cost of a part | Pivot For All Order Transactions | Product Catalog: Cost |
Cost Available | A product of the average cost available times product available | Product Quantity Pivot, Product Pricing Pivot | Product Catalog: Avg. Cost/Location: Quantity Available |
Cost Each | The cost of a unit of a product | Request Products, Requests | Product Catalog: Cost |
Cost New | The cost of a new unit of product | Shipment Pivot For Scaffold | Transactions: Purchase New: Cost Each |
Cost On Rent | The product of the cost each times the quantity on rent | Invoice Additional Charges Pivot | Product Catalog: Cost/Location: On Rent |
Cost Per Unit | The cost of unit of additional charges | Product Pricing Pivot | Shipment: Additional Charges: Price/Unit |
Cost/Unit | The cost of unit of additional charges | Invoice Additional Charges Pivot | Shipment: Additional Charges: Price/Unit |
County/Parish | The county/parish or jobsite/group | Product Pricing Pivot | Jobsite: Shipment: County/Parish |
Create Date | The date an estimate was created | Estimate Detail Pivot | Estimate: + |
Create Date | The date a request was created | Scaffold Pivot, Shipment Pivot | Requests: + |
Create Date | The date a scaffold was created in the system | Requests, Request Products | Location: Scaffold Register: + Sign |
Create Date | The date a service ticket was created | Estimate Summary Pivot | Service Ticket: + |
Create Date | The date a scaffold was created in the system | Estimate Detail Pivot | Location: Scaffold Register: + Sign |
Create Date | The date an inspection entry was created | Service Ticket Pivot | Inspections: + |
Create Date | The date a transaction was created | Transaction Products Pivot, Transaction Pivot, Pivot For Selected Order Transaction, Pivot For All Order Transactions, Re-Rent Swap History For Selected Location, Service Ticket Pivot | Transaction: + |
Created By | The name of the user who created a scaffold | Transaction Pivot | Scaffold Register: + |
Created By | The name of the Quantify user who entered the scaffold | Transaction Products Pivot, Pivot For All Order Transactions | Location: Scaffold Register: + Sign |
Created By | The name of the user who created the shipment | Pivot For Selected Order Transaction | Shipment: + |
Current Cycle End | The end date of current billing cycle | Inspection History Pivot | Job Site: Billing: Billing Method |
Current Cycle Start | The start date of current billing cycle | Scaffold Activity Pivot | Job Site: Billing: Billing Method |
Customer | The name of customer associated with job site/group | Scaffold Pivot | Job Site: Customer |
Customer Contact 1 | The name of the first customer contact | Inspections Due Pivot | Job Site: Job Site Properties: Customer Contact 1 |
Customer Name | The name of job site customer | Billable Jobsite Summary | Job Site: General |
Customer Number | The number associated with a customer | Shipment Pivot | Customers: Customer: Number |
Customer Rep. | The name of the customer representative for a scaffold | Billable Jobsite Summary | Location: Scaffold Register: General: Customer/Representative |
Customer Requestor | The name of the customer requestor for a scaffold | Rent Extension Pivot, Invoice Additional Charges Pivot, Billable Jobsite Summary, Pivot For Selected Order Transaction, Pivot For All Order Transactions, Transaction Products Pivot, Transaction Pivot, Consolidated Pivot For Selected Estimates, Estimate Detail Pivot, Estimate Summary Pivot, Product Quantity Pivot, Product Pricing Pivot, Invoice Pivot | Location: Scaffold Register: General: Customer/Requestor |
D
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Daily Rent | The rental price for re-rent items | Shipment Additional Charges Pivot | Re-Rent: Products: Total |
Daily Rent (Ea) | The rental price for re-rent items | Estimate Detail Pivot | Re-Rent: Products: Total |
Damaged | The number of units of a product that have been assigned the condition of damaged | Job Sites And Groups Pivot | Out Of Service: Condition: Damaged |
Date | Date of invoice create | Invoice Pivot | Create Rental Invoices: Create Invoices |
Date | The up-to date of an invoice | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Create Rental Invoices: Date On Invoice |
Date | The last date of an invoice period | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Job Site: Billing: Billing Cycle |
Date | The date a swap transaction was created | Product Quantity Pivot | Ship: Summary: Dates |
Date | The service date | Invoice Pivot | Service Ticket: General: Service Date |
Date Needed | The date a request fulfillment is needed | Transaction Pivot | Request: Summary: Date Needed |
Days | The difference between the rent start date and the end date | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Estimate Summary Pivot | Summary: Billing For Delivery: Rent Start/Summary: Billing For Return: Rent Stop |
Days Inspection Overdue | The number of days an inspection is overdue | Pivot For All Order Transactions | Location: Scaffold Register: Dates And Inspections: Inspections: Next Inspections |
Days To Load | The difference between the planned load date and the actual load date | Pivot For Selected Order Transaction | Location: Scaffold Register: Tag: Dates And Inspections: Actual Dates: Load/Location: Scaffold Register: Tag: Dates And Inspections: Planned Dates: Load |
Deck Area | The product of scaffold length, width and the number of decks | Invoice Additional Charges Pivot | Location: Scaffold Register: Tag: General: Dimensions |
Delivery Activity Summary | The summary of the scaffold activity type associated with a delivery | Product Pricing Pivot | New Direct Shipment: Activity/Scaffold Register: Activities |
Delivery Activity Type | The scaffold activity type associated with a delivery | Shipment Pivot | New Direct Shipment: Activity |
Description | The product description | Scaffold Pivot, Scaffold Activity Pivot | Product Catalog: Description |
Description | The description of product | Inspections Due Pivot, Scaffold Pivot, Scaffold Activity Pivot, Product Pricing Pivot, Product Quantity Pivot, Request Products, Estimate Detail Pivot, Shipment Consumables Pivot, Invoice Additional Charges Pivot, Rent Extension Pivot, Transaction Pivot | Product Catalog: Description |
Description | The description of additional charges | Inspections Due Pivot, Scaffold Pivot, Scaffold Activity Pivot, Consolidated Pivot For Selected Estimates | Shipment: Additional Charges |
Discount Or Markup (%) | Indicates the percentage of discount or markup | Service Ticket Pivot | Job Site: Billing: Rent |
Discount Or Markup Type | Indicates whether the percent is discount or markup | Transaction Products Pivot | Job Site: Billing: Rent |
Dismantler | The name of the employee who will dismantle a scaffold | Pivot For All Order Transactions | Location: Scaffold Register: General: Employees: Dismantler |
Driver | The name of the driver associated with a shipment | Pivot For Selected Order Transaction | Shipment: Shipment: Summary: Driver |
Due Date | The due date of estimates | Invoice Additional Charges Pivot, Billable Jobsite Summary | Estimates: Summary: Due Date |
Due In (Days) As Of (Today’s Date) | The number of days from the current date that an inspection is due | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot, Shipment Pivot | Dates And Inspections: Inspections |
E
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Elevation | The elevation of the site where a scaffold is located | Estimate Summary Pivot | Location: Scaffold Register: Tag: Details: Location: Elevation |
End | The job end date | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Estimate Summary Pivot, Inspections Due Pivot | Job Site: General: Dates |
Equipment Type | Indicates whether equipment is new, available, or re-rent | Estimate Detail Pivot | Transaction: Order: Available, New, Re-Rent |
Estimate Number | The number that identifies an estimate | Request Products, Requests | Created At Time Of Estimate Creation |
F
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Factor | The value of the factor affecting product pricing | Rent Extension Pivot | Estimate: Products: Factor Value |
First Invoice Date | Indicates the date of first invoice | Job Sites And Groups Pivot | Job Site: Billing: Billing Method |
Forecast | Indicates whether an estimate is forecast | Rent Extension Pivot | Forecasting: Include This Estimate In Forecasting |
Foreman | The name of scaffold foreman | Pivot For All Order Transactions | Location: Scaffold Register: General: Employees: Foreman |
From | The site from which re-rent materials are being sent | Shipment Pivot For Scaffold | New Direct Ship: Summary: From |
From Location | Indicates the location from which a consumable is being shipped | Shipment Additional Charges Pivot | Location: Summary: Name |
From Location # | The number associated with the location from which a shipment came | Billable Jobsite Summary, Service Ticket Pivot | Shipment: Shipment: Summary: From (Job Site: Number) |
From Location Type | The type of location at which a shipment was created | Rent Extension Pivot | Indicated At Location's Creation |
G
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
GST (Tax 1) | State taxes | Re-Rent Swap History For Selected Location | Job Site: Billing: Taxes |
H
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Height | Height of a scaffold | Shipment Additional Charges Pivot, Shipment Consumables Pivot | Location: Scaffold Register: Tag: General: Dimensions |
HST (Tax 2) | Local taxes | Shipment Pivot | Job Site: Billing: Taxes |
I
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Inspection Count | The number of inspections a scaffold has had | Shipment Additional Charges Pivot, Job Sites And Groups Pivot, Invoice Pivot | Location: Scaffold Register: Tag: Inspections |
Inspection Create Date | The date an inspection entry was created | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Estimate Summary Pivot | Inspection: + |
Inspection Date | The date of inspection | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Inspection: Date |
Inspection Frequency | The number of days between inspections | Request Products | Location: Scaffold Register: Tag: Inspections: Inspection Frequency (Days) |
Inspection Notes | The notes related to inspection | Shipment Additional Charges Pivot | Inspection: Notes |
Inspection Result | Indicates whether was inspection was passed or failed | Scaffold Pivot, Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Inspection: Result |
Inspection Shift | Indicates the shift on which an inspection occurred | Job Sites And Groups Pivot, Invoice Pivot | Inspection: Shift |
Inspector On Tag | The inspector associated with a tag/scaffold | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Tag: General: Employees |
Inspector | The name of the scaffold inspector | Inspection History Pivot | Location: Scaffold Register: General: Employees: Inspector |
Inspector On Inspection | The name of the scaffold inspector | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Location: Scaffold Register: General: Employees: Inspector |
Invoice | Indicates the invoice with which a transaction is associated | Shipment Pivot For Scaffold | Invoice Run After Transaction |
Invoice/Credit | Indicates whether an item is invoice or credit | Inspection History Pivot | |
Invoice No. | The invoice ID number | Pivot For All Order Transactions | Invoice Created After Date Of Service Ticket Created |
Invoice Number | The number associated with an invoice | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Invoice: Number |
Invoice Option | The options associated with an invoice | Inspection History Pivot | Job Site: Billing: Options |
Is Active | Indicates whether the job site or group is active | Inspection History Pivot | Job Site Or Group: Is Active |
Is Billable | Indicates whether the job site or group is billable | Transaction Pivot | Job Site: Billing: This Job Site Is Billable |
Item Description | A description of item | Service Ticket Pivot | Product Catalog: Description |
Item Part Number/Name | A description of product | Shipment Pivot For Scaffold | Description Of Consumable, Or Additional Charge |
Item Price | The price of a consumable or additional charge | Shipment Pivot For Scaffold | Service Ticket: Service Details |
Item Qty | The quantity of a consumable or additional charge | Transaction Pivot | Service Ticket: Service Details |
Item Total | The total cost of each item used in a service ticket | Shipment Pivot For Scaffold | Service Ticket: Service Details |
Item Type | Indicates whether an item is a consumable or an additional charge | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Service Ticket: Service Details |
Item Unit | The type of unit that is being measured (hour, foot, etc.) | Shipment Pivot For Scaffold, Shipment Consumables Pivot | Consumable Catalog Or Additional Charges |
J
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Job Site | The name of a job site | Service Ticket Pivot | Job Site: General: Job Site Name |
Job Site Location | The name of the job site associated with an estimate | Invoice Additional Charges Pivot, Service Ticket Pivot | Summary: Job Site |
Job Site Number | The number associated with a job site | Service Ticket Pivot | Job Site: General: Job Site Number |
Job Site/Group | The name of a job site/group | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Estimate Summary Pivot | Job Site: Name |
Job Site/Group Number | The number of a job site/group | Pivot For All Order Transactions, Pivot For Selected Order Transaction, Transaction Products Pivot | Job: Site: Number |
K
L
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Last Inspection | The date of most the recent inspection | Invoice Additional Charges Pivot, Invoice Pivot | Location: Scaffold Register: Tag: Inspections: Inspection: Date |
Last Inspection Passed | Indicates whether the last inspection was passed | Rent Extension Pivot | Location: Scaffold Register: Inspection: Pass |
Latitude | The latitude of the site where a scaffold is located | Rent Extension Pivot | Location: Scaffold Register: Tag: Details: Location: Latitude |
Leg Length | The product of leg height and number of legs | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Scaffold Register: General: Dimensions |
Length | The length of a scaffold leg | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Scaffold Register: General: Dimensions |
List Available | The product of the number available times the list price | Scaffold Pivot, Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Branch: Product: Available/Product Catalog: List |
List Each | The list price from the product catalog | Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Product Catalog: List |
List New | The product of the list price and the quantity new | Estimate Summary Pivot | Product Catalog: List/Branch: Product: New |
List On Rent | The product of the list price and the quantity on rent | Product Pricing Pivot | Product Catalog: List/Location: Product: On Rent |
Location # | The job site number | Rent Extension Pivot, Invoice Pivot | Job Site: General: Job Site Number |
Location Name | The name of the job site or group | Service Ticket Pivot | Job Site: Name |
Location Notes | The notes regarding the scaffold location | Billable Jobsite Summary | Location: Scaffold Register: General: Notes |
Location Number | The number associated with a location | Invoice Additional Charges Pivot, Invoice Pivot | Job Site: Location Number |
Location Type | Based on type of location created (jobsite, group etc.) | Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Selected At Creation Of Location |
Longitude | The longitude of the site where a scaffold is located | Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Location: Scaffold Register: Tag: Details: Location: Longitude |
Lost/Missing | The number of units of a product that have been assigned the condition of lost/missing | Inspections Due Pivot, Scaffold Activity Pivot | Out Of Service: Condition: Lost/Missing |
M
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Markup Name | The name of markup of additional charge | Product Quantity Pivot | Additional Charges: Name |
Model No. | The model number for a product | Shipment Additional Charges Pivot | Product Catalog: Model No. |
N
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Name | The name of a job site | Billable Jobsite Summary | Job Site: General |
Name | The name of additional charges associated with an invoice | Invoice Additional Charges Pivot | Shipment: Additional Charges |
Name | The name of a location (jobsite, group, etc.) | Pivot For All Order Transactions, Re-Rent Swap History For Selected Location | Location: General: Location Name |
Name | The name of additional charges associated with an invoice | Pivot For All Order Transactions | Shipment: Additional Charges |
New | Indicates that a transaction is for new items | Product Pricing Pivot | Transaction: New |
New-Backordered | Indicates that a transaction is for new items on backorder | Product Pricing Pivot | New Items Ordered Minus New Items Received |
New-Cancelled | Indicates that a transaction is for new items where the backorder has been cancelled | Service Ticket Pivot | New Cancelled Backorder |
New-Ordered | Indicates that a transaction is for new items that have been ordered | Product Pricing Pivot | New Items Ordered |
New-Received | Indicates that a transaction is for new items that have been received | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Transaction Pivot, Transaction Products Pivot, Pivot For All Order Transactions, Pivot For Selected Order Transaction, Estimate Summary Pivot | New Items Received |
New Value | The quantity of re-rent items after a swap | Scaffold Pivot, Scaffold Activity Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Shipping: Swap Re-Rent With Owned |
Next Inspection | The date that the next inspection is scheduled | Scaffold Activity Pivot, Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot | Location: Scaffold Register: Tag: Dates And Inspections: Next Inspection |
No. Of Decks | The number of decks of a scaffold | Scaffold Activity Pivot, Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, | Location: Scaffold Register: Tag: General: Dimensions |
No. Of Legs | The number of legs of a scaffold | Scaffold Activity Pivot, Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot | Location: Scaffold Register: Tag: General: Dimensions |
No. Periods | The number of periods associated with estimates | Estimate Summary Pivot, Estimate Detail Pivot, Consolidated Pivot For Selected Estimates | Estimate: Summary: No. Of Periods |
No. Units | The number of units for an additional charge | Estimate Detail Pivot | Estimate: Additional Charges |
No. Units | The number of units for an additional charge | Shipment Additional Charges Pivot, Invoice Additional Charges Pivot | Shipment: Additional Charges |
Notes | The notes associated with an estimate | Scaffold Activity Pivot, Scaffold Pivot, | Estimate: Summary: Notes |
Notes | The notes associated with an inspection | Shipment Pivot, Requests | Scaffold Register: Inspection: Notes |
Notes | The notes associated with a request | Consolidated Pivot For Selected Estimates, Inspections Due Pivot, Inspection History Pivot, Shipment Pivot For Scaffold | Requests: Notes |
Notes | The notes associated with a service ticket | Service Ticket Pivot | Service Ticket: Notes |
Notes | The notes associated with a shipment | Transaction Pivot, Transaction Products Pivot | Shipment: Attachments And Notes |
Notes | The notes associated with a transaction | Pivot For All Order Transactions, Pivot For Selected Order Transaction, Product Quantity Pivot, Request Products | Transactions: Notes |
Number | The number of a job site | Product Pricing Pivot | Job Site: General |
Number | The location number | Service Ticket Pivot, Transaction Pivot | Location: General: Location Number |
Number | The request number | Transaction Products Pivot | Request: +: Summary: Number |
Number | The service ticket number | Pivot For All Order Transactions | Service Ticket: +: Summary: Number |
Number | The transaction number | Pivot For Selected Order Transaction, Transaction Products Pivot, Product Quantity Pivot, Product Quantity Pivot | Transaction: +: Summary: Number |
O
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Old Value | The quantity of re-rent items before a swap | Request Products, Rent Extension Pivot, Requests | New Direct Ship: Product: Quantity |
On Order | The quantity of a product that has been ordered | Product Quantity Pivot | Branch: Product: On Order |
On Order New | An order placed for new products | Product Quantity Pivot | Transaction: Order New: Quantity |
Order | The order number associated with an order | Pivot For Selected Order Transaction, Billable Jobsite Summary | Order: Summary: Order |
Order | The work order number associated with additional charges | Job Sites And Groups Pivot | Customers: Orders |
Order | The work order number associated with additional charges | Requests | Customers: Orders |
Order | The order number associated with a transaction | Request Products, Shipment Additional Charges Pivot | Transaction: Summary: Order |
Order | The order number associated with a job site | Shipment Pivot For Scaffold | Job Site: Billing: Invoice Order Options |
Order | The order number associated with requests | Service Ticket Pivot, Transaction Pivot | Request: Summary: Order |
Order | The order number associated with service tickets | Transaction Products Pivot | Customers: Orders |
Order | The purchase order number associated with additional charges | Pivot For All Order Transactions | Customers: Orders |
Order | The work order associated with a scaffold | Pivot For Selected Order Transaction | Customer: Order: Purchase Order |
Ordered | Indicates that the item has been ordered | Job Sites And Groups Pivot | Transaction: Order |
Order Number | The order number associated with a jobsite/location | Shipment Pivot | Location: Billing: Options: Invoice Order Options: Orders - Purchase Orders |
Owner | The re-rent owner | Product Quantity Pivot, Re-Rent Swap History For Selected Location, Shipment Pivot For Scaffold, Product Pricing Pivot | Transaction: Vendor Or Customer |
P
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Parent Job Site | The name of the scaffold tracking site to which a scaffold belongs | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Jobsite: Jobsite Name |
Parent Job Site Number | The number of the scaffold tracking site to which a scaffold belongs | Scaffold Pivot, Inspection History Pivot, Scaffold Activity Pivot | Jobsite: Jobsite Number |
Part Number | The part number as entered in the product catalog | Re-Rent Swap History For Selected Location, Request Products, Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Shipment Consumables Pivot, Service Ticket Pivot, Transaction Products Pivot, Pivot For All Order Transactions, Pivot For Selected Order Transaction, Product Pricing Pivot | Product Catalog: Part Number |
Period | The name of a period | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Estimate: Period: Label |
Pieces | The number of pieces that have been shipped to a scaffold | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Shipment: Deliver To Selected Scaffold: Products: To Ship |
Pieces | The number of pieces involved in a transaction | Scaffold Activity Pivot | Transaction: Products: Quantity |
Pieces/Hour | The number of pieces divided by the number of actual hours | Inspections Due Pivot, Scaffold Activity Pivot | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Actual |
Plan Area | The product of scaffold length and width | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: General: Dimensions |
Planned Build | The date a build is planned | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates And Inspections: Planned Dates: Build |
Planned Date | The date of a planned shipment | Shipment Pivot, Shipment Pivot For Scaffold, Scaffold Activity Pivot | Shipment: New: Summary: Planned Ship |
Planned Days Up | The number of planned days a scaffold is erect | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates And Inspections: Planned Dates: Build/Location: Scaffold Register: Tag: Dates And Inspections: Planned Dates: Dismantle |
Planned Delivery | The planned date of delivery | Rent Extension Pivot | Estimate: Estimate Dates And Periods |
Planned Dismantle | The date of planned dismantle | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates And Inspections: Planned Dates: Dismantle |
Planned Load | The date of planned load | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Location: Scaffold Register: Tag: Dates And Inspections: Planned Dates: Load |
Planned Return | The planned date of return | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Estimate Summary Pivot | Estimate: Estimate Dates And Periods |
Planned Return Date | The date of planned return | Scaffold Activity Pivot | Transaction: Summary: Dates: Date |
Planned Units | The number of planned units associated with a scaffold activity | Scaffold Activity Pivot | Scaffold Register: Activity: General: Unit-Rate Charge: Planned |
Po | The purchase order associated with a scaffold | Scaffold Activity Pivot, Scaffold Pivot, Estimate Summary Pivot, Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Inspections Due Pivot, Inspection History Pivot, Invoice Pivot | Customers: Customer: Orders: Numbers |
Po Approved Amt. | Indicates the amount approved for a purchase order | Invoice Pivot | Customer: Orders: Purchase Order: Purchase Order Number |
Po Approver | The user selected to approve the PO | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Customers: Customer: Orders: Approver |
Po Reviewer | The user selected to review the PO | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Customers: Customer: Orders: Reviewer |
Price/Unit, Price Per Unit | The price per unit of an additional charge | Invoice Additional Charges Pivot, Estimate Detail Pivot, Rent Extension Pivot | New Direct Shipment: Additional Charges: Price/Unit |
Priority | The priority assigned to a scaffold | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Scaffold Register: General: Priority |
Product Charges | The sum of all the product charges for a job | Invoice Pivot | |
Product Type | Indicates whether an item is a product or a consumable | Product Quantity Pivot | Product Catalog/Consumable Catalog |
Project | The name of the project associated with scaffold | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Scaffold Register: Tag: General: Project |
Purchase Price | The total purchase price of a transaction | Shipment Pivot For Scaffold | Purchase: Products Quantity, Cost Each |
Purchase Price (Ea) | The purchase price for each product unit | Estimate Detail Pivot | Product Catalog: Cost |
Q
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Quantity | The quantity of a product requested | Shipment Consumables Pivot | Request: Product: Quantity |
Quantity | The quantity of consumables in a shipment | Shipment Pivot For Scaffold | Shipment: Consumables: Quantity |
Quantity | The quantity of a product delivered to a scaffold | Transaction Products Pivot | Shipment: Product: Quantity |
Quantity | The quantity of a product for an estimate | Request Products | Estimate: Products: Quantity |
Quantity | The quantity of a product for an estimate | Estimate Detail Pivot | Estimate: Products: Quantity |
Quantity | The quantity a product in a transaction | Transaction Products Pivot | Transaction: Quantity Received |
Quantity | The quantity received | Scaffold Activity Pivot | Transaction: Quantity Received |
Quantity Available | The number of available units for a specific part | Product Quantity Pivot, Product Pricing Pivot | Location: Product: Available |
Quantity Discrepancy | The number of unit difference between the receiving count and shipment count | Product Quantity Pivot, Product Pricing Pivot | Product: Discrepancy/Shipment: To Ship/Shipment Quantity; Return Quantity |
Quantity In Transit | The quantity in a shipment that has not yet been received | Product Quantity Pivot, Product Pricing Pivot | Shipment: Received =: Blank |
Quantity New | The quantity of a new product for a location | Product Quantity Pivot, Product Pricing Pivot | Branch: Product: New |
Quantity On Rent | The quantity of a product on rent | Product Quantity Pivot, Product Pricing Pivot | Location: Product: On Rent |
Quantity Reserved | The quantity of a product reserved | Product Quantity Pivot, Product Pricing Pivot | Branch: Product: Reserved |
Quantity Total | The total quantity of a product for a request | Shipment Pivot For Scaffold | Request: Product: Quantity |
R
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Rate Profile | The rate profile associated with a shipment | Billable Jobsite Summary, Shipment Pivot | Jobsite: Billing: Rent: Rate Profile |
Receive Date | The date a shipment was received | Shipment Pivot, Requests | Shipment: Shipment: Summary: Received |
Reference No. | The reference number of a transaction | Scaffold Activity Pivot | Transaction: Summary: Reference No. |
Rent | The total rents charges for a job | Transaction Products Pivot, Pivot For All Order Transactions, Pivot For Selected Order Transaction, Transaction Pivot | Invoice: Rent |
Rent (Ea) | The rental price for a product | Shipment Additional Charges Pivot | Shipment: Products: 28 Day Rate |
Rent Discount | The % of discount applied to rent | Shipment Pivot For Scaffold | Estimate: Summary |
Rent Discount | The $ of discount applied to rent | Estimate Summary Pivot, Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Invoice Pivot | Estimate: Summary |
Rent Start Date | The start date of rent for a shipment | Shipment Pivot For Scaffold, Rent Extension Pivot, Shipment Pivot | Shipment: Shipment: Summary: Billing For Delivery: Rent Start |
Rent Stop On Delivery | THe stop date of rent for a shipment | Shipment Pivot | Shipment: Shipment: Summary: Billing For Delivery: Rent Stop |
Rent Stop On Return | The rental stop date on returns | Shipment Pivot | Shipment: Shipment: Summary: Billing For Return: Rent Stop |
Rent Stopped | Indicates whether rent has been stopped for a scaffold | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | Scaffold Register: Tag: General: Status |
Rent Without Discount | The % of discount applied to rent | Estimate Detail Pivot, Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Estimate: Product: Quantity :/Estimate: Product: Rent |
Replacement Cost (Ea) | The replacement cost of a product based on rate profile | Estimate Summary Pivot | Rate Profile: Replacement |
Request | Indicates whether a request is managed at location | Billable Jobsite Summary | Job Site: Request: Manage Requests For This Location |
Requested Date | The date of a request | Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Request: Summary: Request Date |
Requested By | Indicates whether the requestor is from a customer or internal | Job Sites And Groups Pivot | Scaffold Register: Tag: General: Requested By |
Re-Rent | Indicates that a transaction is for re-rent items | Requests | Transaction: Re-Rent |
Re-Rent-Backordered | Indicates that a transaction is for re-rent items on backorder | Requests, Request Products, Service Ticket Pivot, Job Sites And Groups Pivot | Re-Rent Items Ordered Minus Re-Rent Items Received |
Re-Rent-Cancelled | Indicates that a transaction is for re-rent items where the backorder has been cancelled | Service Ticket Pivot | Re-Rent Cancelled Backorder |
Re-Rent-Ordered | Indicates that a transaction is for re-rent items that have been ordered | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Re-Rent Items Ordered |
Re-Rent-Received | Indicates that a transaction is for re-rent items that have been received | Service Ticket Pivot, Job Sites And Groups Pivot | Re-Rent Items Received |
Received | Indicates the product quantity received | Product Quantity Pivot, Job Sites And Groups Pivot, Rent Extension Pivot, Product Pricing Pivot | Transaction: Received |
Result | Indicates to which inventory queue a product has been returned | Transaction Products Pivot, Transaction Pivot | Service Ticket: Service Details: Service Result |
Return Activity Summary | The summary of scaffold activity type associated with return | Shipment Pivot For Scaffold | New Direct Shipment: Activity |
Return Activity Type | The scaffold activity type associated with a return | Requests | New Direct Shipment: Activity |
Return Date | Teh date of planned return | Product Quantity Pivot, Product Pricing Pivot | Transaction: Summary: Dates: Date |
Return Rent Stop Date | The rent stop date associated with a return | Shipment Consumables Pivot | New Direct Shipment: Rent Stop |
ROP | The re-order point from pc for notifications | Invoice Additional Charges Pivot | Product Catalog: Rop |
ROQ | The re-order quantity from Product Catalog | Product Quantity Pivot, Product Pricing Pivot | Product Catalog: Roq |
S
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Scrap | The number of units of a product that have been assigned the condition of damaged | Product Quantity Pivot, Product Pricing Pivot | Out Of Service: Condition: Damaged |
Sell | The product of product quantity and sale price | Product Quantity Pivot | Estimate: Product: Quantity :/Estimate: Products: Sell |
Sell (Ea) | The sell price of a consumable | Scaffold Pivot, Inspections Due Pivot, Scaffold Activity Pivot | New Direct Shipment: Consumables: Sell |
Sell Price | The product of price (ea.) and quantity | Consolidated Pivot For Selected Estimates | Transaction: Quantity, Price (Ea) |
Sell Price (Ea) | Indicates the sell price for each product unit | Shipment Additional Charges Pivot | TBD |
Serial Number | A number specific to one product unit | Pivot For Selected Order Transaction, Pivot For All Order Transactions | Product Catalog: Serial Number |
Serial Number Last Inspection Date | The number of units of a product that have been assigned the condition of lost/missing | Shipment Pivot For Scaffold, Service Ticket Pivot, Product Quantity Pivot, Product Quantity Pivot, Product Pricing Pivot | Out Of Service: Condition: Lost/Missing |
Serial Number Next Inspection Date | The next scheduled inspection for a serialized product | Product Quantity Pivot | Product Catalog: Serial Number: Next Inspection |
Serial Number Notes | The notes associated with a serialized item | Product Quantity Pivot | Product Catalog: Serial Number: Notes |
Serial Number Purchase Date | The purchase date of a serial number | Product Quantity Pivot | Product Catalog: Serial Number: Purchase Date |
Serial Number Purchase Price | The purchase price of a serial number | Product Pricing Pivot | Product Catalog: Serial Number: Purchase Price |
Serial Number Warranty Expiration Date | The warranty expiration date of a serialized item | Product Pricing Pivot | Product Catalog: Serial Number: Warranty |
Serviced By | Indicates the name of the person who serviced equipment | Product Quantity Pivot | Service Ticket: General: Serviced By |
Shipment | The number of the shipment to which a service ticket is associated | Service Ticket Pivot | New Direct Ship: Summary: Number |
Shipment No. | The number associated with a shipment | Job Sites And Groups Pivot | New Direct: Summary: Number |
Shipment Notes | The notes associated with a shipment | Shipment Consumables Pivot, Request Products | Shipment: Notes |
Shipment Type | Indicates whether th eshipment is a return, delivery or transfer | Rent Extension Pivot | Indicated At Shipment’s Creation |
Shipment Number | The number associated with a shipment | Rent Extension Pivot | Shipment: General: Summary: Number |
Shipment Status | Indicates whether a shipment has been received or is to be received | Rent Extension Pivot, Shipment Pivot For Scaffold, Shipment Additional Charges Pivot, Shipment Consumables Pivot, Shipment Pivot | Shipment: Prereturn Shipment/Shipment: Prereturn Shipment: Received Date |
Start | The job start date | Pivot For All Order Transactions | Jobs Site: Start |
Start Date | The start date of a job site | Job Sites And Groups Pivot | Job Site: General: Dates |
State/Province | The County/parish or jobsite/group | Rent Extension Pivot | Jobsite: Shipment: State Province |
State/Province | The County/parish or jobsite/group | Job Sites And Groups Pivot | Jobsite: Shipment: State Province |
Status | Indicates the status of a scaffold | Scaffold Activity Pivot, Scaffold Pivot, Request Products, Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Scaffold Register: Tag: General: Status |
Status | Indicates the status of a request | Requests Product | Request: Summary: Status |
Step | Indicates the step of a scaffold | Inspections Due Pivot | Scaffold Register: Tag: General: Step |
Stop Rent Date | Indicates the stop rent date of a scaffold | Inspection History Pivot | Scaffold Register: Tag: General: Status: Stop Rent Date |
T
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Tag | The tag associated with a scaffold | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Scaffold Register: Tag: General: Tag |
To | The site to which re-rent materials are being sent | Pivot For All Order Transactions | New Direct Ship: Summary: To |
To Be Serviced | The number of units assigned to the To Be Serviced queue | Invoice Additional Charges Pivot, Estimate Detail Pivot | Ship: Product: To Be Serviced |
To Location | Indicates the location to which a consumable is being shipped | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Location: Summary: Name |
To Location # | The number associated with a location shipment | Product Quantity Pivot | Shipment: Prereturn Shipment: Received Date |
To Location Number | The number to job site location | Invoice Additional Charges Pivot, Re-Rent Swap History For Selected Location | Job Site: Number |
Total | The total value of an estimate | Shipment Pivot, Shipment Additional Charges Pivot | Estimate: Product + Consumables + Additional Charges + Recurring Charges |
Total Additional Charges | The total additional charges associated with a shipment | Invoice Pivot | Shipment: Additional Charges |
Total Average Calculated Cost | The quantity on rent or quantity available times the calculated avg. cost | Estimate Summary Pivot | Location: Product: On Rent/Location: Product: Available :/Calculated Avg. Cost :/ |
Total Avg. Cost | The product of average cost and quantity | Re-Rent Swap History For Selected Location | Consumable Catalog: Average Cost/New Direct Shipment: Consumables: Quantity |
Total Average Cost | The product of the average cost times quantiles available or on rent | Estimate Summary Pivot, Shipment Pivot | Jobsite: Products: On Rent/Branch: Product: Available/Transaction: Avg Cost/Average Cost X (Quantity On Rent + Quantity Available) |
Total Cost | The total quantity of materials times the cost as listed in the product catalog | Shipment Pivot For Scaffold, Product Pricing Pivot | Jobsite: Location: On Rent Branch: Product: Quantity Available/Product Catalog: Cost/Branch: Product: Quantity New/Transactions: Purchase New: Cost Each |
Total Cost | The total additional charges associated with a shipment | Shipment Consumables Pivot | Shipment: Additional Charges |
Total Cost | The total cost of consumables in a shipment | Product Pricing Pivot | Shipment: Consumables: Quantity/Product Catalog: Cost |
Total Pieces | The total pieces in a request | Shipment Consumables Pivot | Request: Product: Quantity |
Total Pieces | The total number of pieces included in a shipment | Shipment Additional Charges Pivot | Shipment: To Ship … Pieces (Sum At Bottom Of Window)/Product Catalog: Cost |
Total Price | The product of the price of an additional charge and its quantity | Shipment Additional Charges Pivot, Shipment Pivot | Shipment: Additional Charges: Price/Unit, Quantity |
Total Purchase | The product of purchase price and quantity | Estimate Summary Pivot | Transaction: Product: Quantity/Transaction: Products: Cost Each |
Total Recurring Charges | The sum of an estimate's recurring charges | Consolidated Pivot For Selected Estimates, Estimate Detail Pivot | Estimate: Recurring Charges |
Total Rent | The product of an estimate's product, rate profile and quantities | Transaction Products Pivot | Jobsite: Billing: Rate Profile :/Shipment: Products: Part Number, Shipment, 28 Day Rate |
Total Rent | The product of a shipment's product, rate profile and quantities | Estimate Summary Pivot | Jobsite: Billing: Rate Profile :/Shipment: Products: Part Number, Shipment, 28 Day Rate |
Total Rent | The product of a shipment's product, rate profile and quantities | Shipment Pivot For Scaffold | Jobsite: Billing: Rate Profile :/Shipment: Products: Part Number, Shipment, 28 Day Rate |
Total Replacement Cost | A product's cost each times the quantity shipped | Estimate Detail Pivot | Rate Profile: Replacement :/New Direct Shipment: Product: Quantity |
Total Sell | The product of quantity and sell price | Transaction Products Pivot | Estimates: Products |
Total Sell | The product of product quantity and sale price | Pivot For Selected Order Transaction | Transaction: Products |
Total Sell | A product's sell price times the quantity shipped | Scaffold Activity Pivot | Rate Profile: Sell/New Direct Shipment: Product: Quantity |
Total Weight | The product of weight and product quantity | Shipment Pivot For Scaffold | Request: Product: Quantity/Product Catalog: Weight |
Total Weight | The product of weight and product quantity | Transaction Products Pivot | Request: Product: Quantity/Product Catalog: Weight |
Total Weight | The total weight of an additional charge | Shipment Pivot | Shipment: Additional Charges |
Total Weight | The product of the number of pieces and the weight of each piece | Request Products | Shipment: Product: Weight/Shipment: Products: To Ship |
Total Weight | The product of product weight and product quantity | Shipment Pivot | Transaction: Product: Quantity/Product Catalog: Weight |
Type | Indicates type of order :(backorder (available), backorder completed (available), etc.) | Product Quantity Pivot, Pivot For All Order Transactions, Pivot For All Order Transactions, Shipment Pivot For Scaffold | Determined By Type Of Order Selected And Whether It Has Been Completed |
Type | Indicates whether an item is a product, consumable or additional charge | Shipment Additional Charges Pivot, Transaction Products Pivot | Product Catalog/Consumable Catalog/Shipment: Product/Consumable/Additional Charge |
Type Of Estimate | Indicates whether an estimate is for rent, sell available or sell new | Pivot For All Order Transactions, Pivot For Selected Order Transaction, Estimate Summary Pivot | Estimate: Summary |
Type Of Transaction | Indicates the type of transaction | Request Products | Is Chosen At Time Of Transaction's Creation |
U
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Unit | The type of unit applied to the unit hour | Consolidated Pivot For Selected Estimates | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Unit-Hour Rate |
Unit Actual Total | The total actual charges applied to a specified activity | Transaction Pivot | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Actual Total |
Unit Factor | The build cost as calculated by company | Pivot For All Order Transactions | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Unit Factor |
Unit-Hour-Rate | The type of unit-hour rate applied to an activity | Scaffold Activity Pivot | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Unit Hour Rate |
Unit Of Measure | The type of unit to be counted against additional charge | Inspection History Pivot | Additional Charges: Units |
Unit Planned Total | The total planned charges applied to an activity | Scaffold Activity Pivot | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Planned Total |
Unit Planned Total Hours | The number of total hours applied to a scaffold activity | Invoice Additional Charges Pivot | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Price/Hour |
Unit Price/Hour | The unit | Scaffold Activity Pivot | Scaffold Register: Activity: Units Hours And Costs: Unit-Rate Charge: Price/Hour |
Units | The number of units of an additional charge | #VALUE! | Shipment: Additional Charges: Quantity |
User | The name of the user creating a re-rent | Pivot For All Order Transactions | Auto-Entry From Creation Of Shipment |
V
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Vendor | Indicates the vendor who is selling the product | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Transaction (Order, Purchase): Product: Vendor |
Volume | The product of length, width, height of a scaffold | Re-Rent Swap History For Selected Location | Location: Scaffold Register: General: Dimensions |
W
Term | Definition | Associated Pivot Tables | Record-Field Data Retrieved From |
Weight | Indicates the weight of a product unit | Transaction Products Pivot, Pivot For All Order Transactions, Pivot For Selected Order Transaction, Transaction Pivot, Inspection History Pivot, Inspections Due Pivot, Scaffold Pivot, Scaffold Activity Pivot | Part Catalog: Weight |
Weight | The sum of product weight and estimate quantities | Scaffold Pivot, Scaffold Activity Pivot | Part Catalog: Weight/Estimate: Product: Quantities |
Weight | The sum of the weight of all shipments made to a scaffold | Estimate Summary Pivot | Part Catalog: Weight/Shipment: Product: Quantities |
Weight | The product of number of pieces and the weight of the pieces | Consolidated Pivot For Selected Estimates | Location: Scaffold Register: Bill Of Materials: Pieces/Product Catalog: Weight |
Weight | The weight of additional charges for a scaffold | Shipment Additional Charges Pivot | Shipment: Additional Charges |
Weight | The product of weight and product quantity | Inspections Due Pivot | Shipment: Product: Quantity/Product Catalog: Weight |
Weight | The total weight of products in a transaction | Inspection History Pivot | Transaction: Product: Quantity/Product Catalog: Weight |
Weight Available | A product of the weight and quantity available | Request Products | Product Catalog: Weight/Branch: Product: Available |
Weight Discrepancy | The product of part weight and quantity missing | Pivot For All Order Transactions | Receiving: Sent -Received |
Weight (Ea), Weight Each | The weight of a product unit as listed in the product catalog | Transaction Pivot, Product Quantity Pivot, Product Pricing Pivot, Pivot For All Order Transactions | Product Catalog: Weight |
Weight In Transit | The product of weight and product quantity shipped and not received | Re-Rent Swap History For Selected Location | Shipment: Quantity |
Weight New | The weight of a product unit as listed in the product catalog new | Product Quantity Pivot, Product Pricing Pivot | Product Catalog: Weight/Branch: Product: New |
Weight On Rent | The product of the weight of a product unit and the number of units on rent | Shipment Pivot For Scaffold | Product Catalog: Weight/Jobsite: Products: On Rent |
Weight Reserved | The product weight and quantity reserved | Pivot For All Order Transactions | Reserve: Product: Quantity |
Weight/Unit | The weight or unit of additional charge | Inspection History Pivot | Additional Charges: Weight/Unit |
Width | The width of a scaffold | Product Quantity Pivot | Location: Scaffold Register: General: Dimensions |
WO Approver | The name of work order approver | Inspections Due Pivot | General: Add/Edit Order: Purchase Order: Work Order: Approver |
WO Reviewer | The name of work order reviewer | Invoice Additional Charges Pivot | General: Add/Edit Order: Purchase Order: Work Order: Reviewer |
Work Order | The work order number associated with a scaffold | Inspection History Pivot, Inspections Due Pivot, Consolidated Pivot For Selected Estimates, Estimate Detail Pivot, Scaffold Pivot, Scaffold Activity Pivot | General: Add/Edit Order: Purchase Order: Work Order |
Work Order Approved Amount | Indicates the amount approved for a work order | Scaffold Pivot, Inspections Due Pivot, Inspection History Pivot, Scaffold Activity Pivot | Customer: Orders: Purchase Order: Purchase Order Number: Work Order |
X
Y
Z
Re-Rent Swap History For Selected Location