Contacts table

Column Type

Id

String

Url

URI

Active_Projects_Count

Integer

First_Name

String

Last_Name

String

Address1

String

Address2

String

Address3

String

Town

String

Region

String

Country

String

Postcode

String

Phone_Number

String

Organisation_Name

String

Email

String

Billing_Email

String

Default_Payment_Terms_In_Days

Integer

Sales_Tax_Registration_Number

String

Mobile

String

Contact_Name_On_Invoices

Boolean

Created_At

Timestamp

Status

String

Updated_At

Timestamp

Uses_Contact_Level_Email_Settings

Boolean

Charge_Sales_Tax

String

Locale

String

Account_Balance

Decimal

Uses_Contact_Invoice_Sequence

Boolean

Emails_Thank_You_Notes

Boolean

Emails_Invoices_Automatically

Boolean

Emails_Payment_Reminders

Boolean

Examples

SELECT
    Id
FROM
    Contacts
WHERE
    Email = 'ta@example.com'

INSERT INTO
    Contacts (
        First_Name,
        Last_Name,
        Email,
        Billing_Email,
        Phone_Number,
        Mobile,
        Address1,
        Address2,
        Address3,
        Town,
        Region,
        Postcode,
        Country,
        Uses_Contact_Invoice_Sequence,
        Contact_Name_On_Invoices,
        Charge_Sales_Tax,
        Sales_Tax_Registration_Number,
        [Status],
        Default_Payment_Terms_In_Days,
        Locale
    )
VALUES
    (
        'Thomas, ' Axen ', ' ta@example.com ', ' bills@example.com ', ' (123) 555 -0101 ', ' (321) 555 -0101 ', ' 123 Third Street ', '', '', ' Los Angeles ', ' CA ', ' 99999 ', USA',
        'false',
        'true',
        'Always',
        'US123456789',
        'Active',
        '30',
        'en'
    )

UPDATE Contacts
SET
    Mobile = '(321)555-0101'
WHERE
    Email = 'ta@example.com'
DELETE FROM Contacts
WHERE
    Id = '18482080'