PostgreSQL + Xero

OrganizationRequired

OrganizationRequired

OrganizationRequired

Transaction TypeRequired

ContactRequired

Bank AccountRequired

Date

OrganizationRequired

Contact NameRequired

Account Number

Contact Requirements

Primary Person - First Name

Primary Person - Last Name

Primary Person - Email

Secondary Person - First Name

Secondary Person - Last Name

Secondary Person - Email

Include secondary person in emails sent to contact?

Phone - Country Code

Phone - Area Code

Phone Number

Fax - Country Code

Fax - Area Code

Fax - Number

Mobile - Country Code

Mobile - Area Code

Mobile - Number

Direct Dial - Country Code

Direct Dial - Area Code

Direct Dial - Number

Address Type Of

Address - Attention

Address - Line 1

Address - Line 2

Address - City/Town

Address - State/Region

Address - Postal/Zip Code

Address - Country

Tax Number

Bank Account Number

Groups

Contact Number

Company Number

Payment Terms - Invoice Due (days)

Payment Terms - Type for Sales Invoices

Payment Terms - Bill Due (days)

Payment Terms - Type for Purchase Invoices

OrganizationRequired

TypeRequired

ContactRequired

Date

OrganizationRequired

Mark Item as a Sales Item?

Mark Item as a Purchase Item?

Item Name

Item CodeRequired

OrganizationRequired

Contact NameRequired

Email Address

Contact Account Number

Primary Person - First Name

Primary Person - Last Name

Phone - Country Code

Phone - Area Code

Phone Number

Fax - Country Code

Fax - Area Code

Fax - Number

Mobile - Country Code

Mobile - Area Code

Mobile - Number

Direct Dial - Country Code

Direct Dial - Area Code

Direct Dial - Number

Contact Address Type

Address - Attention

Address - Line 1

Address - Line 2

Address - City/Town

Address - State/Region

Address - Postal/Zip Code

Address - Country

Contact Tax Number

Bank Account Number

Contact Number

Status

Date

Due Date

Currency

Url

Attachment

Branding Theme

Number

Reference

Sent To Contact

Line Items Type

Item Code

Description

QuantityRequired

Unit Price

Discount %

Discount Amount

Account

Tax Rate

Tracking

OrganizationRequired

ContactRequired

Project NameRequired

Deadline for the project

Project Estimate

OrganizationRequired

ContactRequired

Repeated Invoice Schedule

Invoice Creation: Frequency TypeRequired

Invoice Creation: Frequency (Period)Required

Due Date Type: Payment TermsRequired

Set Due Dates (Days)Required

Start Date: Required

End Date

StatusRequired

Currency

Branding Theme

Reference

Mark as approved for sending?

Email a copy to Sender?

Include PDF

Line Amount Types

Info

OrganizationRequired

Invoice IdRequired

Contact

Status

Date

Due Date

Expected Payment Date

Reference

Branding Theme

Url

Currency

Sent To Contact

Attachments

Invoice Number

Line Amount Types

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

OrganizationRequired

OrganizationRequired

Invoice IDRequired

OrganizationRequired

Search ByRequired

Contact NameRequired

Account Number

Contact Requirements

Primary Person - First Name

Primary Person - Last Name

Primary Person - Email

Secondary Person - First Name

Secondary Person - Last Name

Secondary Person - Email

Include secondary person in emails sent to contact?

Phone - Country Code

Phone - Area Code

Phone Number

Fax - Country Code

Fax - Area Code

Fax - Number

Mobile - Country Code

Mobile - Area Code

Mobile - Number

Direct Dial - Country Code

Direct Dial - Area Code

Direct Dial - Number

Address Type Of

Address - Attention

Address - Line 1

Address - Line 2

Address - City/Town

Address - State/Region

Address - Postal/Zip Code

Address - Country

Tax Number

Bank Account Number

Groups

Contact Number

Company Number

Payment Terms - Invoice Due (days)

Payment Terms - Type for Sales Invoices

Payment Terms - Bill Due (days)

Payment Terms - Type for Purchase Invoices

Table/ViewRequired

QueryRequired

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

TableRequired

ID ColumnRequired

QueryRequired

OrganizationRequired

Status

Change

Contact

Trigger Preference

Copy

OrganizationRequired

InvoiceRequired

OrganizationRequired

From AccountRequired

To AccountRequired

AmountRequired

Date

OrganizationRequired

ContactRequired

Date

Expiry

Quote Number

Reference

Theme

Title

Summary

Currency

Amounts Are

Terms

OrganizationRequired

Invoice IDRequired

OrganizationRequired

Contact NameRequired

Email Address

Status

Date

Due Date

Currency

Url

Attachment

Branding Theme

Reference

Line Items Type

Item Code

Description

QuantityRequired

Unit Price

Account

Tax Rate

Tracking

OrganizationRequired

Document Type

Document ID or NumberRequired

Paid ToRequired

Date

Currency Rate

AmountRequired

Reference

OrganizationRequired

Contact (supplier)Required

Date

Delivery Date

Order Number

Reference

Theme

Currency

Tax Type

Delivery Address

Attention

Telephone

Delivery Instructions

Attachments

Purchase Order Status

OrganizationRequired

Purchase OrderRequired

Contact

Update Method for Line Items

Date

Delivery Date

Line Amount Types

Purchase Order Number

Reference

Branding Theme

Currency

Status

Sent to Contact

Delivery Address

Attention To

Telephone

Delivery Instructions

Expected Arrival Date

OrganizationRequired

Resource typeRequired

FileRequired

OrganizationRequired

Search ByRequired

OrganizationRequired

Search ByRequired

OrganizationRequired

Search ByRequired

OrganizationRequired

Search ByRequired

Mark Item as a Sales Item?

Mark Item as a Purchase Item?

Item Name

Item CodeRequired

Table/ViewRequired

Order By

Dedupe Key

TableRequired

TableRequired

Lookup ColumnRequired

Lookup ValueRequired

QueryRequired