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 UpThe real number of days scaffold is erectInspection History Pivot, Inspections Due Pivot, Scaffold Pivot, Scaffold Activity PivotLocation: 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