What data columns are available in a bill of quantities on an owner payment application ? (Beta - Draft)

Main Contract Payment Applications: Bill of Quantities Data Columns

When you set the accounting method to use on a main contract's Bill of Quantities, that method is automatically applied to the contract's main contract payment applications. See How do I set the accounting method for a contract? Each accounting method has a unique column layout that includes specific columns and column groups designed specifically to work for each accounting method. For both methods, you can expand and collapse each column group by clicking these icons:

•  Expand Column Group. Click to expand the columns in the group. 
•  Collapse Column Group. Click to collapse the columns in the group. 

Amount-Based Accounting Method

When an owner payment application uses the amount-based accounting method, you'll see these columns. 

Default Columns

This table details the default columns for main contract payment applications with the amount-based accounting method. An asterisk (*) by a 'Column Name' indicates the column is only visible when the 'Column Group' is expanded. 

Column Group	Column Name	Data Entry Field	Description
	Item Number		Show the line item number on the payment application's Bill of Quantities.
Line Item Details	Budget Code		Shows the budget code for the line item.
	Description of Work		Shows the description for the line item from the corresponding line item on the contract.
	Line Item Type *		Shows the line item type.
	Source *		Shows the link to the line item source. This includes: BOQ or Variation.
Value	Main Contract Value*		Shows the value of the line item from any 'Approved' variations for the contract.
	Change Value*		Shows the value of the line item from any 'Approved' variations.
	Bill of Quantities		Shows the line item's bill of quantities from the main contract or variation.  Where the group total shows, the value is the total sum of all the values on its main contract plus all of its variations.
Work Completed	From Previous Application (£)		Shows the currency amount for all work completed in previous payment applications.
	From Previous Application (%) *		Shows the percentage value for all work completed in previous payment applications.
	This Period		Enter a currency amount for all work completed this billing period.
	This Period (%) *		Enter a percentage value for all work completed in this billing period.
Materials	Previous Materials Stored*		Enter a currency amount that represents the total of all materials stored in previous billing periods.
	New Materials Stored*		Enter a currency amount for all materials stored in this billing period.
	Materials Presently Stored		Shows the currency amount that is the sum of 'Previous Materials Stored' plus 'New Materials Stored.'
Total Completed & Stored Materials	Total to Date (£)		Shows the currency amount for all completed and stored materials for previous billing periods plus this billing period.
	Total to Date (%)		Enter a percentage value for all completed and stored materials for previous billing periods plus this billing period.
	Balance to Finish		Shows the remaining currency amount that has yet to be completed and stored for the contract.
Retention Note: To fully expand this column group, you may need to collapse other column groups first.	Previous Work Retention *		Shows the currency amount for any work retention held for work completed from previous billing periods.
	Previous Materials Retention *		Shows a currency amount for any materials retention held from previous billing periods.
	Previous Total Retention *		Shows the currency amount that is the sum of 'Previous Work Retention' and 'Previous Total Retention.'
	Work Retention This Period (£) *		Enter a currency amount for the work retention held for this billing period.
	Work Retention This Period (%)		Enter a percentage value for the work retention held for this billing period.
	Total Work Retention *		Shows a currency amount for the total work retention held for previous billing periods plus this billing period.
	Materials Retention (£) *		Enter a currency amount for materials retention held for this billing period.
	Materials Retention (%)		Enter a percentage value of materials retention held for this billing period.
	Work Retention Released This Period *		Enter a currency amount of work retention released for this billing period.
	Total		Shows the total retention. Procore calculates this value as: ('Total Work Retention' + 'Materials Retention (£)') - 'Total Retention Released This Period'. This 'Total' is analogous to the definition of 'Retention' on common industry-standard forms.

Unit/Quantity-Based Accounting Method

When main contract payment applications use the unit/quantity-based accounting method, you'll see these columns. 

Default Columns

This table details the default columns for main contract payment applications with the unit/quantity-based accounting method. An asterisk (*) under 'Column Name' indicates the column is only visible when the 'Column Group' is expanded. 

Column Group	Column Name	Data Entry Field	Description
	Item Number		Shows the line item number on the payment application's Bill of Quantities.
Line Item Details	Budget Code		Shows the budget code for the line item.
	Description of Work		Shows the description for the line item from the corresponding line item on the contract.
	Line Item Type *		Shows the line item type.
	Source *		Shows the link to the line item source. This includes: BOQ or Variation.
Value	Programmed Quantity		Shows the programmed quantity for the line item.
	Unit Price		Shows the unit price for the line item.
	Main Contract Value *		Shows the value of the line item from the main contract.
	Change Value *		Shows the value of the line item from any 'Approved' variations for the contract.
	Bill of Quantities		Shows the line item's bill of quantities from the main contract or variation.  Where the group total shows, the value is the total sum of all the values on its main contract plus all of its variations.
Work Completed	From Previous Application (Qty)		Shows the unit quantity for all work completed in previous payment applications.
	From Previous Application (£)		Shows the currency amount for all work completed in previous payment applications.
	From Previous Application (%) *		Shows the percentage value for all work completed in previous payment applications.
	This Period (Qty.)		Shows the quantity for all work completed in this billing period.
	This Period (£)		Shows the currency amount for all work completed in this billing period.
	This Period (%) *		Shows the percentage value for all work completed in this billing period.
Total Completed & Stored Materials	Total to Date (Qty.) *		Shows the quantity for all completed and stored materials for previous billing periods plus this billing period.
	Total to Date (£) *		Shows the currency amount for all completed and stored materials for previous billing periods plus this billing period.
	Total to Date (%) *		Enter a percentage value for all completed and stored materials for previous billing periods plus this billing period.
	Balance to Finish *		Shows the remaining currency amount that has yet to be completed and stored for the contract
Retention Note: To fully expand this column group, you may need to collapse other column groups first.	Previous Work Retention *		Shows a currency amount for any materials retention held from previous billing periods.
	Work Retention This Period (£) *		Enter a currency amount for the work retention held for this billing period.
	Work Retention This Period (%) *		Enter a percentage value for the work retention held for this billing period.
	Work Retention Release This Period *		Enter a currency amount for the work retention released for this billing period.
	Total		Shows the total retention. Procore calculates this value as: ('Total Work Retention' + 'Materials Retention (£)') - 'Total Retention Released This Period'. This 'Total' is analogous to the definition of 'Retention' on common industry-standard forms.