Recurring_Invoices table

Column Type

Id

Integer

Url

URI

Net_Value

Decimal

Recurring_End_Date

String

Next_Recurs_On

String

Contact_Id

String

Contact

String

Send_New_Invoice_Emails

Boolean

Comments

String

Contact_Name

String

Dated_On

String

Recurring_Status

String

Frequency

String

Reference

String

Created_At

Timestamp

Due_Value

Decimal

Profile_Id

String

Currency

String

Exchange_Rate

Decimal

Second_Sales_Tax_Value

Decimal

Total_Value

Decimal

Payment_Terms_In_Days

Integer

Sales_Tax_Value

Decimal

Omit_Header

Boolean

Always_Show_Bic_And_Iban

Boolean

Send_Reminder_Emails

Boolean

Updated_At

Timestamp

Send_Thank_You_Emails

Boolean

Bank_Account_Id

String

Bank_Account

String

Invoice_Items

Array

Payment_Methods

Array

Examples

SELECT
    *
FROM
    Recurring_Invoice_Invoice_Items
WHERE
    Id = '41506170'