Disbursed Report Mapping

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

Suggested Prompt to use in Textura Reports

Show me up my organization

• Project number: “GC-exp-2-drw”
• Only invoices with a status of PAID
• For each invoice, include the following:

Invoice details

• Invoice ID
• Invoice number
• System-generated invoice number
• Submit date
• Approved date
• Authorized date
• Payment due date
• Self billed amount for this period
• Self retention amount this period
• Self retention released this period
• Tax amount
• Net invoice amount
• Net payment due
• Discount

Draw details

• Draw ID
• Draw number
• Draw name
• Period-to-date amount

Payment details

For each payment associated to the invoice, include:

• Payment ID
• Payment amount
• Payment method
• Payment status
• Check number
• Paid date
• Tax amount
• Remaining amount
• Invoice paid to date
• Disbursement date and time
• Bank upload date and time
• Settlement date
• Discount
• Pay-from organization name
• Pay-to organization name

Project details (from the payment)

• Project ID
• Project name
• Project number
• Segment ID

Split check payment details (if applicable)

• Split payment ID
• Payment amount
• Payment method
• Payment status
• Check number
• Paid date
• Tax
• Date modified

Disburser details

• Disburser first name
• Disburser last name

Contract details

• Contract ID
• Contract number
• Description
• Vendor ID

Invoice approval details

For each approval, include:

• Approver action
• Approver first name
• Approver last name
• Approver role
• Approver job title

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: 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

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.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