Accounts Payable Report Mapping

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

Suggested Prompt to use in Textura Reports

Get all AVAILABLE_TO_PAY invoices and their details including project, organization, draw.

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(organizationID:xxx, offset:0, next:1){
        contract{
      project{
        segmentID
        projectNumber
        name
      }
      organization{
        name
      }
      vendorID
      contractNumber
      description
      subcontractedBalanceDue
      comment
    }
    draw{
      number
      name
      periodToDate
    }
    invoiceNumber
    submitDate
    approvedDate
    selfBilledAmountThisPeriod
    selfRetentionAmountThisPeriod
    selfRetentionReleasedThisPeriod
    taxAmount
    netInvoiceAmount
    netPaymentDue
    authorizedDate
    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	Segment ID	Invoice.contract.project.segmentID
2	Project Number	Invoice.contract.project.projectNumber
3	Project Name	Invoice.contract.project.name
4	Organization Name	Invoice.contract.organization.name
5	Vendor Id	invoice.contract.vendorID
6	Contract Number	Invoice.contract.contractNumber
7	Contract Description	invoice.contract.desciption
8	Sub-tier of	Not Applicable
9	Draw Number	invoice.draw.number
10	Draw Name	invoice.draw.name
11	Draw Comment	Not Applicable
12	Period to Date of Draw	invoice.draw.periodToDate
13	Invoice Number	invoice.invoiceNumber
14	Date Invoice Submitted	invoice.submittedDate
15	Date Invoice Approved	invoice.approvedDate
16	Billed Amount This Period	invoice.selfBilledAmountThisPeriod
17	Retained Amount This Period	invoice.selfRetentionAmountThisPeriod
18	Retention Released This Period	invoice.selfRetentionReleasedThisPeriod
19	Tax Payment	invoice.taxAmount
20	Net Payment	invoice.netInvoiceAmount
21	Paid Amount	Not Applicable
22	Remaining Amount	netPaymentDue
23	Payment Type	Not Applicable
24	Previous Payment Type	Not Applicable
25	Reason for Payment Type Update	Not Applicable
26	Payment on Hold	Not Applicable
27	Hold Created On	Not Applicable
28	Last Hold Overridden	Not Applicable
29	Hold Overridden On	Not Applicable
30	Overridden By	Not Applicable
31	Date Authorized	invoice.authorizedDate
32	Authorizer’s Name	Not Applicable
33	Payment Due Date	invoice.paymentDueDate
34	Owner Funding Date	Not Applicable
35	Contract Comment	invoice.contract.comment
36	Reason For Hold	Not Applicable
37	Non-Compliant Legal Documents	Not Applicable