Search only in titles

---

Draws Initiated Report Mapping

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

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, February 6, 2026