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
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 |
Last Published Friday, May 15, 2026