Draws Initiated Report Mapping

You can map DaaS data to the Textura Draws Initiated Report with the following prompt or query.

Suggested Prompt to use in Textura Reports

Show me invoices for my organization that:

• Are not deleted
• Belong to project number “XXXX”
• Start at the beginning of the list (offset 0)

For each invoice, include:

Invoice details

• Invoice ID
• Invoice number
• Invoice status
• Submit date
• Net invoice amount
• Tax amount
• Net payment due
• Self retention amount for this period
• Subcontracted retention amount for this period
• Self retention released this period
• Subcontracted retention released this period

Contract details

• Contract ID
• Contract number
• Contract description

Draw details

• Draw ID
• Draw number
• Draw name
• Period from date
• Period to date
• Due date
• Draw status
• Date created
• Date modified
• Closed date
• Whether the draw is deleted

Project details (from the draw)

• Project name
• Project number
• Segment ID

Also include pagination information showing:

• Number of results returned on this page
• Total number of matching results

Note:

• For more information on using prompts, see topic Creating a Report from a Prompt.
• The above prompt is a suggestion, your results may vary.

Query

query Invoice
{
 invoice(offset: 0 next: 100 organizationID: XXXXX
 isDeleted: false
 projectNumber: "XXXX"
 )
{
 id
 invoiceNumber
 invoiceStatus
 submitDate
 netInvoiceAmount
 selfRetentionAmountThisPeriod
 subcontractedRetentionAmountThisPeriod
 selfRetentionReleasedThisPeriod
 subcontractedRetentionReleasedThisPeriod
 taxAmount
 netPaymentDue
 contract {
 id
 description
 contractNumber
 }
 draw {
 id
 number
 name
 periodFromDate
 periodToDate
 dueDate
 status
 dateCreated
 closedDate
 dateModified
 isDeleted
 project {
 name
 projectNumber
 segmentID
 }
 }
 pageInfo {
 pageResults
 totalResults
 }
 }
}

Mapping Table

Note: If you copy text from a table cell for use in code, paste it as plain text to avoid copying typographic quotation marks or other formatting.

Use the table below to map report output column fields to DaaS fields. Note that cells with a DaaS Field of Not Applicable do not have a DaaS equivalent to an available report field.

Column Number	Report Column	DaaS Field
1	Segment ID	Invoice.draw.project.segmentID
2	Project Number	Invoice.draw.project.projectNumber
3	Project Name	Invoice.draw.project.name
4	Draw Number	Invoice.draw.number
5	Draw Name	Invoice.draw.name
6	Draw Period to Date	Invoice.draw.periodToDate
7	Draw Date	Invoice.draw.dueDate
8	Draw Status	Invoice.draw.status
9	Gross Billed This Period	SUM OF (Invoice.netInvoiceAmount + invoice.selfRetentionAmountThisPeriod) for a specific draw
10	Draw Initiated	Invoice.draw.dateCreated
11	GC Submitted Date	Not Applicable
12	Date Draw Closed	Invoice.draw.closedDate
13	Architect Approved Date	Not Applicable
14	Owner Approved Date	Not Applicable