Disbursable Report Mapping

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

Suggested Prompt to use in Textura Reports

Get all information about disbursables including pay from, project identifiers (number, name), pay to details, contract details, prime subcontract organization name, draw information, invoice details, authorization details, owner funding details, and payment/financial details.

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 {
  disbursable(organizationID:0000, offset:0, next:1,){
    payFromOrganization{
      name
    }
    fundingBankAccount
    segmentID,
    project{
      projectNumber
      name
    }
    payToOrganization{
      name
    }
    contract{
      vendorID
      description
      comment
      contractNumber
    }
    primeSubcontract{
      organization{
        name
      }
    }
    draw {
      number
      name
      periodToDate
    }
    invoice {
      invoiceNumber
      submitDate
      selfBilledAmountThisPeriod
      selfRetentionAmountThisPeriod
      selfRetentionReleasedThisPeriod
      netInvoiceAmount
    }
    dateAuthorized,
    authorizer{
      firstName
      lastName
    }
    ownerFundingDate
    ownerFundingAmount
    ownerFundingComment
    taxAmount
    discountAmount
    netInvoiceAmount
    paidAmount
    paymentAmount
    paymentAmountRemaining
    paymentMethod
    paymentDueDate
  }
}

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	Selected for Disbursement	Not Applicable
2	Funding Organization	disbursable.payFromOrganization.name
3	Funding Account	disbursable.payFromOrganization.fundingBankAccount
4	Segment ID	disbursable.payFromOrganization.segmentID
5	Project Number	disbursable.project.projectNumber
6	Project Name	disbursable.project.name
7	Organization Name	payToOrganization.name
8	vendorID	contract.vendorID
9	Contract Number	contract.contractNumber
10	Contract Description	contract.description
11	Sub-tier of	disbursable.primeSubcontract.organization.name
12	Draw Number	draw.number
13	Draw Name	draw.name
14	Draw Comment	Not Applicable
15	Period to Date of Draw	draw.periodToDate
16	Invoice Number	invoice.invoiceNumber
17	Date Invoice Submitted	invoice.submitDate
18	Time Invoice Submitted	Not Applicable
19	Holds Released Count	Not Applicable
20	Last Hold Release Date	Not Applicable
21	Last Hold Release By	Not Applicable
22	Date Authorized	disbursable.dateAuthorized
23	Time Authorized	Not Applicable
24	Authorizer’s Name	disbursable.authorizer.firstName & lastName
25	Owner Funding Date	disbursable.ownerFundingDate
26	Owner Funding Amount	disbursable.ownerFundingAmount
27	Owner Funding Comment	disbursable.ownerFundingComment
28	Billed Amount This Period	invoice.selfBilledAmountThisPeriod
29	Retained Amount This Period	invoice.selfRetentionAmountThisPeriod
30	Retention Released This Period	invoice.selfRetentionReleasedThisPeriod
31	Tax Payment	disbursable.taxAmount
32	Discount	disbursable.discountAmount
33	Net Invoice Amount	disbursable.netInvoiceAmount
34	Paid Amount	disbursable.paidAmount
35	Payment Amount	disbursable.paymentAmount
36	Remaining Amount	disbursable.paymentAmountRemaining
37	Payment Method	disbursable.paymentMethod
38	Payment Due Date	disbursable.paymentDueDate
39	Contract Comment	contract.contractComment
40	Last Hold Overridden	Not Applicable
41	Hold Created On	Not Applicable
42	Hold Overridden On	Not Applicable
43	Overridden By	Not Applicable