Search only in titles

---

Disbursed Report Mapping

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

Query

query Invoice {
 invoice(
 offset: 0
 next: 1000
 organizationID: 294
 projectNumber: "GC-exp-2-drw"
 invoiceStatus: [PAID]
 ) {
 id
 invoiceNumber
 systemGeneratedInvoiceNumber
 selfBilledAmountThisPeriod
 selfRetentionAmountThisPeriod
 selfRetentionReleasedThisPeriod
 taxAmount
 submitDate
 approvedDate
 authorizedDate
 netPaymentDue
 paymentDueDate
 netInvoiceAmount
 discount
 draw {
 id
 number
 name
 periodToDate
 }
 payments {
 id
 paymentAmount
 paymentMethod
 paymentStatus
 checkNumber
 paidDate
 tax
 remainingAmount
 invoicePaidToDate
 disbursementDateTime
 bankUploadDateTime
 settlementDate
 discount
 payFromOrganization {
 name
 }
 payToOrganization {
 name
 }
 project {
 id
 name
 projectNumber
 segmentID
 }
 splitCheckPayments {
 id
 paymentAmount
 paymentMethod
 paymentStatus
 checkNumber
 paidDate
 tax
 dateModified
 }
 disburserName {
 firstName
 lastName
 }
 }
 contract {
 id
 contractNumber
 description
 vendorID
 }
 invoiceApprovals {
 approverAction
 approver {
 firstName
 lastName
 role
 jobTitle
 }
 }
 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.Payment.Project.segmentID
2	Funding Organization	Invoice.Payment.payFromOrganization.name
3	Funding Account	Not Applicable
4	Project Number	Invoice.Payment.Project.projectNumber
5	Project Name	Invoice.Payment.Project.name
6	Draw Number	Invoice.Draw.number
7	Draw Name	Invoice.Draw.name
8	Draw Comment	Not Applicable
9	Period to Date of Draw	invoice.draw.periodToDate
10	Owner Funding Date	Not Applicable
11	Time Owner Funding Entered	Not Applicable
12	Owner Funding Amount	Not Applicable
13	Owner Funding Comment	Not Applicable
14	Organization Name	Invoice.Payment.payToOrganization.name
15	Sub-tier of	Not Applicable
16	Vendor Id	Invoice.contract.vendorID
17	Contract Number	invoice.contract.contractNumber
18	Contract Description	invoice.contract.description
19	Invoice Number	invoice.systemGeneratedInvoiceNumber
20	Billed Amount This Period	Invoice.selfBilledAmountThisPeriod
21	Retained Amount This Period	invoice.selfRetentionAmountThisPeriod
22	Retention Released This Period	invoice.selfRetentionReleasedThisPeriod
23	Tax Amount	invoice.taxAmount
24	Discount Amount	invoice.discount
25	Total Payment	invoice.netInvoiceAmount
26	Current Payment	Invoice.Payment.paymentAmount
27	Invoice Paid to Date	invoice.Payment.invoicePaidToDate
28	Remaining Amount	invoice.Payment.remainingAmount
29	Payment Type	Invoice.Payment.paymentMethod
30	Check #	Invoice.Payment.checkNumber
31	Invoice Approved Date	Invoice.approvedDate
32	Time Invoice Approved	Not Applicable
33	Invoice Approvers	Invoice.InvoiceApprovals.Approver.firstName, lastName
34	Approvers Title	Invoice.InvoiceApprovals.Approver.jobTitle
35	Date Authorized	Invoice.authorizedDate
36	Time Authorized	Not Applicable
37	Authorizers Name	Not Applicable
38	Payment Due Date	invoice.paymentDueDate
39	Disbursement Date	invoice.payment.disbursementDateTime
40	Time Disbursed	invoice.payment.disbursementDateTime
41	Bank Upload Date	invoice.payment.bankUploadDateTime
42	Bank Upload Time	invoice.payment.bankUploadDateTime
43	Disburser Name	Invoice.payment.disburserName.firstname, lastName
44	Contract Comment	Invoice.contract.contractComment

---

Last Published Friday, February 6, 2026