What data columns are available in a schedule of values on an owner invoice ? (Beta - Draft)

Owner Invoices: Schedule of Values Data Columns

When you set the accounting method to use on a prime contract's Schedule of Values, that method is automatically applied to the contract's owner invoices. 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 invoice uses the amount-based accounting method, you'll see these columns. 

Default Columns

This table details the default columns for owner invoices 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 invoice's Schedule of Values.
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: SOV or Change Order.
Value	Prime Contract Value*		Shows the value of the line item from any 'Approved' change orders for the contract.
	Change Value*		Shows the value of the line item from any 'Approved' change orders.
	Scheduled Value		Shows the line item's scheduled value from the prime contract or change order.  Where the group total shows, the value is the total sum of all the values on its prime contract plus all of its change orders.
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.
Retainage Note: To fully expand this column group, you may need to collapse other column groups first.	Previous Work Retainage *		Shows the currency amount for any work retainage held for work completed from previous billing periods.
	Previous Materials Retainage *		Shows a currency amount for any materials retainage held from previous billing periods.
	Previous Total Retainage *		Shows the currency amount that is the sum of 'Previous Work Retainage' and 'Previous Total Retainage.'
	Work Retainage This Period ($) *		Enter a currency amount for the work retainage held for this billing period.
	Work Retainage This Period (%)		Enter a percentage value for the work retainage held for this billing period.
	Total Work Retainage *		Shows a currency amount for the total work retainage held for previous billing periods plus this billing period.
	Materials Retainage ($) *		Enter a currency amount for materials retainage held for this billing period.
	Materials Retainage (%)		Enter a percentage value of materials retainage held for this billing period.
	Work Retainage Released This Period *		Enter a currency amount of work retainage released for this billing period.
	Total		Shows the total retainage. Procore calculates this value as: ('Total Work Retainage' + 'Materials Retainage ($)') - 'Total Retainage Released This Period'. This 'Total' is analogous to the definition of 'Retainage' on common industry-standard forms.

Unit/Quantity-Based Accounting Method

When owner invoices use the unit/quantity-based accounting method, you'll see these columns. 

Default Columns

This table details the default columns for owner invoices 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 invoice's Schedule of Values.
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: SOV or Change Order.
Value	Scheduled Quantity		Shows the scheduled quantity for the line item.
	Unit Price		Shows the unit price for the line item.
	Prime Contract Value *		Shows the value of the line item from the prime contract.
	Change Value *		Shows the value of the line item from any 'Approved' change orders for the contract.
	Scheduled Value		Shows the line item's scheduled value from the prime contract or change order.  Where the group total shows, the value is the total sum of all the values on its prime contract plus all of its change orders.
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
Retainage Note: To fully expand this column group, you may need to collapse other column groups first.	Previous Work Retainage *		Shows a currency amount for any materials retainage held from previous billing periods.
	Work Retainage This Period ($) *		Enter a currency amount for the work retainage held for this billing period.
	Work Retainage This Period (%) *		Enter a percentage value for the work retainage held for this billing period.
	Work Retainage Release This Period *		Enter a currency amount for the work retainage released for this billing period.
	Total		Shows the total retainage. Procore calculates this value as: ('Total Work Retainage' + 'Materials Retainage ($)') - 'Total Retainage Released This Period'. This 'Total' is analogous to the definition of 'Retainage' on common industry-standard forms.