# SaaSOptics (v1) Information note **SaaSOptics is supported by the Singer community** This integration is powered by [Singer's](https://www.singer.io/) SaaSOptics tap. For support, [visit the GitHub repo](https://github.com/singer-io/tap-saasoptics) or [join the Singer Slack](https://singer-slackin.herokuapp.com/). ## SaaSOptics integration summary Stitch’s SaaSOptics integration replicates data using the [SaaSOptics REST API](https://saasoptics.zendesk.com/hc/en-us/articles/115003595913-URLs-and-REST-Info). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/saasoptics#schema) section for a list of objects available for replication. ## SaaSOptics feature snapshot A high-level look at Stitch's SaaSOptics (v1) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on March 4, 2020 | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Singer Community](https://www.singer.io/) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Success icon

This version of the integration is available via the API.

Available | | **Singer GitHub repository** | [singer-io/tap-saasoptics](https://github.com/singer-io/tap-saasoptics) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.

Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.

Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported

Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | ## Connecting SaaSOptics ### SaaSOptics setup requirements To set up SaaSOptics in Stitch, you need: * **Access to your API token**. Only account admins can generate the first API token for users. Once it has been generated by the admin, users can regenerate their tokens. You will either need an admin account to generate your own API token, or you will need an admin to generate one for you. ### Step 1: Identify your account name and server subdomain The server subdomain and account name are in the URL you use to access your SaaSOptics account. If you are unsure of what your link is, locate it within your welcome email from SaaSOptics. Your server subdomain is the first portion of the URL, and the account name is between the first and second forward slashes. ![SaaSOptics URL format.](https://help.qlik.com/en-US/stitch/images/integrations/saasoptics-url.png)SaaSOptics URL format.SaaSOptics URL format. ### Step 2: Obtain your token 1. Login to the SaaSOptics account you want to replicate data from. 2. In the upper right hand side of the page, click on the user account button that shows your username. 3. Click on **API**. ![SaaSOptics API hyperlink.](https://help.qlik.com/en-US/stitch/images/integrations/saasoptics-api-button.png)SaaSOptics API hyperlink.SaaSOptics API hyperlink. 4. If you are an admin, generate an API token. If you are a user without admin privileges, you can either use the API token that already exists or regenerate the token. Keep note of it - you’ll need it to complete the next step. ![Your SaaSOptics API token.](https://help.qlik.com/en-US/stitch/images/integrations/saasoptics-api-token.png)Your SaaSOptics API token.Your SaaSOptics API token. ### Step 3: Add SaaSOptics as a Stitch data source 1. [Sign into your Stitch account](https://app.stitchdata.com/). 2. On the Stitch Dashboard page, click the **Add Integration** button. 3. Click the **SaaSOptics** icon. 4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination. For example, the name “Stitch SaaSOptics” would create a schema called `stitch_saasoptics` in the destination. **Note**: Schema names cannot be changed after you save the integration. 5. In the **Account Name** field, enter the account name you identified in [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/saasoptics#account-subdomian). 6. In the **Server Subdomain** field, enter the subdomain you identified in [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/saasoptics#account-subdomain). 7. In the **Token** field, enter the API token you obtained in [step 2](https://help.qlik.com/en-US/stitch/integrations/saas/saasoptics#obtain-token). Information note **Note**: The **Date Window Field** is an internal field for Stitch use. The default value is `60`; it is optional to change it. ### Step 4: Define the historical replication start date The Sync Historical Data setting defines the starting date for your SaaSOptics integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse. Change this setting if you want to replicate data beyond SaaSOptics’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 5: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins. SaaSOptics integrations support the following replication scheduling methods: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 6: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/saasoptics#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For SaaSOptics integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate. 4. Repeat this process for all the tables and columns you want to replicate. 5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### Initial and historical replication jobs After you finish setting up SaaSOptics, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page. For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### Free historical data loads The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## SaaSOptics table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 1** of this integration. This is the latest version of the SaaSOptics integration. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### accounts The `accounts` table contains info about accounts, or records in your Chart of Accounts, in SaaSOptics. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [accounts schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/accounts.json "Opens in new tab: accounts schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013751507-Accounts-R- "Opens in new tab: SaaSOptics API method") | accounts table schema | **account\_type**

STRING | | --- | | **id**

INTEGER | | **intacct\_id**

STRING | | **intacct\_modified**

DATE-TIME | | **intacct\_recordno**

INTEGER | | **name**

STRING | | **netsuite\_id**

STRING | | **source\_system**

STRING | ### auto\_renewal\_profiles The `auto_renewal_profiles` table contains info about auto-renwal profiles, or transaction renewal rules in your SaaSOptics account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [auto_renewal_profiles schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/auto_renewal_profiles.json "Opens in new tab: auto_renewal_profiles schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013918268-Auto-Renewal-Profiles-R- "Opens in new tab: SaaSOptics API method") | auto\_renewal\_profiles table schema | **days**

INTEGER | | --- | | **generate\_revenue**

BOOLEAN | | **id**

INTEGER | | **months**

INTEGER | | **name**

STRING | | **recognize**

BOOLEAN | ### billing\_descriptions The `billing_descriptions` table contains info about billing line item descriptions. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [billing_descriptions schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/billing_descriptions.json "Opens in new tab: billing_descriptions schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013751807-Billing-Line-Item-Descriptions-R- "Opens in new tab: SaaSOptics API method") | billing\_descriptions table schema | **contents**

STRING | | --- | | **id**

INTEGER | | **name**

STRING | | **notes**

STRING | ### billing\_methods The `billing_methods` table contains info about billing methods, which are used to specify billing/invoice frequencies for transactions in your SaaSOptics account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [billing_methods schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/billing_methods.json "Opens in new tab: billing_methods schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115003604433-Billing-Methods-R- "Opens in new tab: SaaSOptics API method") | billing\_methods table schema | **id**

INTEGER | | --- | | **name**

STRING | ### contracts The `contracts` table contains info about the contracts in your SaaSOptics account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | modified | | **Useful links** | [contracts schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/contracts.json "Opens in new tab: contracts schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013751607-Contracts-CRUD- "Opens in new tab: SaaSOptics API method") | contracts table schema | **billing\_profile**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand billing\_profile

account_number

STRING

addr1

STRING

addr2

STRING

addr3

STRING

alt_contact

STRING

alt_phone

STRING

city

STRING

company_name

STRING

contact

STRING

country

STRING

currency

INTEGER

customer_type_ref_fullname

STRING

default_credit_memo_template

INTEGER

default_invoice_template

INTEGER

edit_sequence

STRING

email

STRING

entity_use_code

INTEGER

fax

STRING

first_name

STRING

full_name

STRING

invoice_email_preference

BOOLEAN

invoice_print_preference

BOOLEAN

is_active

BOOLEAN

job_description

STRING

job_end_date

DATE-TIME

job_projected_end_date

DATE-TIME

job_start_date

DATE-TIME

job_status

STRING

job_type

INTEGER

last_name

STRING

name

STRING

parent_id

STRING

payment_terms

INTEGER

phone

STRING

resale_number

STRING

sales_rep

INTEGER

salutation

STRING

shipping_addr1

STRING

shipping_addr2

STRING

shipping_addr3

STRING

shipping_city

STRING

shipping_country

STRING

shipping_state

STRING

shipping_zip_code

STRING

state

STRING

zip_code

STRING

| | --- | | **channel**

STRING | | **customer**

INTEGER | | **email**

STRING | | **entry\_date**

DATE-TIME | | **id**

INTEGER | | **is\_job**

BOOLEAN | | **lead\_date**

DATE-TIME | | **lead\_source**

STRING | | **modified**

DATE-TIME | | **notes**

STRING | | **number**

STRING | | **number\_field1**

NUMBER | | **number\_field2**

NUMBER | | **qb\_job\_id**

STRING | | **register**

INTEGER | | **sf\_id**

STRING | | **text\_field1**

STRING | | **text\_field2**

STRING | | **unbalanced\_revenue\_exception**

BOOLEAN | ### country\_codes The `country_codes` table contains info about country codes. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [country_codes schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/country_codes.json "Opens in new tab: country_codes schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115003604453-Country-Codes-R- "Opens in new tab: SaaSOptics API method") | country\_codes table schema | **code**

STRING | | --- | | **id**

INTEGER | | **name**

STRING | ### currency\_codes The `currency_codes` table contains info about currency codes. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | code | | **Useful links** | [currency_codes schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/currency_codes.json "Opens in new tab: currency_codes schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115003604453-Country-Codes-R- "Opens in new tab: SaaSOptics API method") | currency\_codes table schema | **code**

STRING | | --- | | **name**

STRING | ### customers The `customers` table contains info about customers. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | modified | | **Useful links** | [customers schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/customers.json "Opens in new tab: customers schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013751587-Customers-CRUD- "Opens in new tab: SaaSOptics API method") | customers table schema | **autopay\_enrollment**

STRING | | --- | | **billing\_profile**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand billing\_profile

account_number

STRING

addr1

STRING

addr2

STRING

addr3

STRING

alt_contact

STRING

alt_phone

STRING

avatax_address_validation_timestamp

DATE-TIME

city

STRING

company_name

STRING

contact

STRING

country

STRING

currency

INTEGER

customer_type

INTEGER

default_class

INTEGER

default_credit_memo_template

INTEGER

default_invoice_template

INTEGER

edit_sequence

STRING

email

STRING

entity_use_code

INTEGER

fax

STRING

first_name

STRING

full_name

STRING

invoice_email_preference

BOOLEAN

invoice_print_preference

BOOLEAN

is_active

BOOLEAN

item_sales_tax

INTEGER

last_name

STRING

last_updated_by_qb

BOOLEAN

name

STRING

payment_method

INTEGER

payment_terms

INTEGER

phone

STRING

resale_number

STRING

sales_rep

INTEGER

sales_rep_fullname

STRING

sales_tax_code

INTEGER

salutation

STRING

shipping_addr1

STRING

shipping_addr2

STRING

shipping_addr3

STRING

shipping_city

STRING

shipping_country

STRING

shipping_state

STRING

shipping_zip_code

STRING

state

STRING

zip_code

STRING

| | **cc\_email**

STRING | | **code**

STRING | | **crm\_id**

STRING | | **default\_autorenewal\_profile**

STRING | | **default\_email\_from\_so**

BOOLEAN | | **default\_enable\_ach\_payment**

BOOLEAN | | **default\_enable\_cc\_payment**

BOOLEAN | | **default\_theme**

INTEGER | | **do\_not\_sync**

BOOLEAN | | **einvoicing\_id**

STRING | | **email**

STRING | | **enable\_autopay**

BOOLEAN | | **escalation\_email**

STRING | | **id**

INTEGER | | **industry**

STRING | | **is\_active**

BOOLEAN | | **market**

STRING | | **modified**

DATE-TIME | | **name**

STRING | | **notes**

STRING | | **number**

STRING | | **number\_field1**

NUMBER | | **number\_field2**

NUMBER | | **number\_field3**

NUMBER | | **parent**

INTEGER | | **qb\_id**

STRING | | **recurly\_id**

STRING | | **segment**

STRING | | **sf\_default\_renewal\_opportunity\_rule**

INTEGER | | **sf\_id**

STRING | | **sf\_opportunity\_price\_book\_id**

STRING | | **sf\_owner\_id**

STRING | | **stripe\_id**

STRING | | **subsegment**

STRING | | **text\_field1**

STRING | | **text\_field2**

STRING | | **text\_field3**

STRING | | **unbalanced\_revenue\_exception**

BOOLEAN | ### deleted\_contracts The `deleted_contracts` table contains a list of deleted SaaSOptics contracts. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | deleted | | **Useful links** | [deleted_contracts schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/deleted_contracts.json "Opens in new tab: deleted_contracts schema on GitHub") | deleted\_contracts table schema | **deleted**

DATE-TIME | | --- | | **deleted\_by**

STRING | | **id**

INTEGER | ### deleted\_invoices The `deleted_invoices` table contains a list of deleted SaaSOptics invoices. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | deleted | | **Useful links** | [deleted_invoices schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/deleted_invoices.json "Opens in new tab: deleted_invoices schema on GitHub") | deleted\_invoices table schema | **deleted**

DATE-TIME | | --- | | **deleted\_by**

STRING | | **id**

INTEGER | ### deleted\_revenue\_entries The `deleted_revenue_entries` table contains a list of deleted SaaSOptics revenue entries. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | deleted | | **Useful links** | [deleted_revenue_entries schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/deleted_revenue_entries.json "Opens in new tab: deleted_revenue_entries schema on GitHub") | deleted\_revenue\_entries table schema | **deleted**

DATE-TIME | | --- | | **deleted\_by**

STRING | | **id**

INTEGER | ### deleted\_transactions The `deleted_transactions` table contains a list of deleted SaaSOptics transactions. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | deleted | | **Useful links** | [deleted_transactions schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/deleted_transactions.json "Opens in new tab: deleted_transactions schema on GitHub") | deleted\_transactions table schema | **deleted**

DATE-TIME | | --- | | **deleted\_by**

STRING | | **id**

INTEGER | ### invoices The `invoices` table contains info about invoices in your SaaSOptics account. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | auditentry\_modified | | **Useful links** | [invoices schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/invoices.json "Opens in new tab: invoices schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013918148-Invoices-CRUD- "Opens in new tab: SaaSOptics API method") | invoices table schema | **applied\_amount**

NUMBER | | --- | | **auditentry\_created**

DATE-TIME | | **auditentry\_created\_by\_name**

STRING | | **auditentry\_modified**

DATE-TIME | | **auditentry\_modified\_by\_name**

STRING | | **auditentry\_qb\_created**

DATE-TIME | | **auditentry\_qb\_modified**

DATE-TIME | | **avatax\_commit\_timestamp**

DATE-TIME | | **avatax\_id**

STRING | | **avatax\_modify\_timestamp**

DATE-TIME | | **avatax\_reconciliation\_status**

STRING | | **avatax\_status**

STRING | | **balance**

NUMBER | | **billing\_addr1**

STRING | | **billing\_addr2**

STRING | | **billing\_addr3**

STRING | | **billing\_city**

STRING | | **billing\_country**

STRING | | **billing\_state**

STRING | | **billing\_zip\_code**

STRING | | **contract**

INTEGER | | **date**

DATE-TIME | | **deleted\_in\_qb**

BOOLEAN | | **do\_not\_sync**

BOOLEAN | | **due\_date**

DATE-TIME | | **ei\_theme**

INTEGER | | **email\_from\_so**

BOOLEAN | | **enable\_ach\_payment**

BOOLEAN | | **enable\_cc\_payment**

BOOLEAN | | **exported\_date**

DATE-TIME | | **external\_id**

STRING | | **foreign\_exchange\_rate**

NUMBER | | **id**

INTEGER | | **ignore\_date\_when\_syncing**

BOOLEAN | | **is\_paid**

BOOLEAN | | **line\_items**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand line\_items

deleted_in_qb

BOOLEAN

exported_date

DATE-TIME

external_id

STRING

home_amount

NUMBER

INTEGER

invoice

INTEGER

item

INTEGER

local_amount

NUMBER

modified

DATE-TIME

no_transaction_permitted

BOOLEAN

notes

STRING

number

STRING

qb_class

INTEGER

qb_time_modified

DATE-TIME

qb_txn_line_id

STRING

quantity

NUMBER

recurly_id

STRING

refund_of

INTEGER

refund_of_stripe_id

STRING

sf_id

STRING

stripe_id

STRING

sync_date

DATE-TIME

transaction

INTEGER

| | **memo**

STRING | | **number**

STRING | | **other**

STRING | | **po\_number**

STRING | | **qb\_ar\_account**

INTEGER | | **qb\_class**

INTEGER | | **qb\_currency**

INTEGER | | **qb\_customer\_message**

INTEGER | | **qb\_number**

STRING | | **qb\_payment\_terms**

INTEGER | | **qb\_sales\_rep**

INTEGER | | **qb\_template**

INTEGER | | **qb\_txn\_id**

STRING | | **recurly\_id**

STRING | | **refund\_of**

INTEGER | | **sales\_tax**

NUMBER | | **sales\_tax\_percentage**

NUMBER | | **sf\_id**

STRING | | **ship\_date**

DATE-TIME | | **shipping\_addr1**

STRING | | **shipping\_addr2**

STRING | | **shipping\_addr3**

STRING | | **shipping\_city**

STRING | | **shipping\_country**

STRING | | **shipping\_state**

STRING | | **shipping\_zip\_code**

STRING | | **stripe\_id**

STRING | | **stripe\_refund\_id**

STRING | | **subtotal**

NUMBER | | **sync\_date**

DATE-TIME | | **to\_be\_emailed**

BOOLEAN | | **to\_be\_printed**

BOOLEAN | | **type**

STRING | ### items The `items` table contains info about items, which are products and services you sell. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | modified | | **Useful links** | [items schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/items.json "Opens in new tab: items schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013751567-Items-R- "Opens in new tab: SaaSOptics API method") | items table schema | **asset\_account**

INTEGER | | --- | | **avatax\_id**

STRING | | **avatax\_sales\_tax\_code**

STRING | | **billing\_description**

STRING | | **billing\_method**

INTEGER | | **code**

STRING | | **create\_revenue**

BOOLEAN | | **default\_duration**

STRING | | **description**

STRING | | **enable\_create\_transactions**

BOOLEAN | | **enforce\_start\_date\_after\_end\_date**

BOOLEAN | | **gl\_created**

DATE-TIME | | **gl\_description**

STRING | | **gl\_is\_active**

BOOLEAN | | **gl\_modified**

DATE-TIME | | **gl\_name**

STRING | | **id**

INTEGER | | **income\_account**

INTEGER | | **intacct\_id**

STRING | | **intacct\_modified**

DATE-TIME | | **intacct\_recordno**

STRING | | **is\_active**

BOOLEAN | | **is\_discount**

BOOLEAN | | **is\_sales\_tax**

BOOLEAN | | **is\_taxable**

BOOLEAN | | **liability\_account**

INTEGER | | **modified**

DATE-TIME | | **name**

STRING | | **needs\_so\_profile**

BOOLEAN | | **netsuite\_id**

STRING | | **netsuite\_modified**

DATE-TIME | | **normalized\_term**

STRING | | **product\_family**

STRING | | **qb\_account**

INTEGER | | **qb\_id**

STRING | | **qb\_only**

BOOLEAN | | **qb\_sales\_tax\_code**

STRING | | **recurly\_id**

STRING | | **recurring**

BOOLEAN | | **renew\_all\_open\_transactions**

BOOLEAN | | **renew\_using\_same\_item**

BOOLEAN | | **revenue\_recognition\_method**

INTEGER | | **sf\_do\_not\_sync**

BOOLEAN | | **source\_system**

STRING | | **stripe\_id**

STRING | | **sync\_invoices**

BOOLEAN | | **transaction\_end\_date**

DATE-TIME | | **transaction\_start\_date**

DATE-TIME | | **wizard\_enabled**

BOOLEAN | ### payment\_terms The `payment_terms` table contains info about invoice payment terms. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [payment_terms schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/payment_terms.json "Opens in new tab: payment_terms schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115003642673-Payment-Terms-R- "Opens in new tab: SaaSOptics API method") | payment\_terms table schema | **id**

INTEGER | | --- | | **intacct\_id**

STRING | | **intacct\_modified**

DATE-TIME | | **intacct\_recordno**

INTEGER | | **is\_active**

BOOLEAN | | **name**

STRING | | **netsuite\_id**

STRING | | **num\_days**

NUMBER | ### registers The `registers` table contains info about registers, which can contain one or more [contracts](https://help.qlik.com/en-US/stitch/integrations/saas/saasoptics#contracts). | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | modified | | **Useful links** | [registers schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/registers.json "Opens in new tab: registers schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115013751707-Registers-R- "Opens in new tab: SaaSOptics API method") | registers table schema | **currency\_code**

STRING | | --- | | **default\_qb\_ar\_account**

STRING | | **generated\_invoice\_number\_prefix**

STRING | | **id**

INTEGER | | **modified**

DATE-TIME | | **name**

STRING | ### revenue\_entries The `revenue_entries` table contains info about revenue entries. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | modified | | **Useful links** | [revenue_entries schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/revenue_entries.json "Opens in new tab: revenue_entries schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115003674273-Revenue-Entries-R- "Opens in new tab: SaaSOptics API method") | revenue\_entries table schema | **end\_date**

DATE-TIME | | --- | | **home\_amount**

NUMBER | | **id**

INTEGER | | **local\_amount**

NUMBER | | **modified**

DATE-TIME | | **start\_date**

DATE-TIME | | **transaction**

INTEGER | ### revenue\_recognition\_methods The `revenue_recognition_methods` table contains info about revenue recognition methods, which are the methods for calculating and generating revenue records for a transaction. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [revenue_recognition_methods schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/revenue_recognition_methods.json "Opens in new tab: revenue_recognition_methods schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/115003617774-Revenue-Recognition-Methods-R- "Opens in new tab: SaaSOptics API method") | revenue\_recognition\_methods table schema | **id**

INTEGER | | --- | | **name**

STRING | ### sales\_orders The `sales_orders` table contains info about sales orders, which have historically been synced in through the Salesforce integration and processed into financial records within SaaSOptics. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created | | **Useful links** | [sales_orders schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/sales_orders.json "Opens in new tab: sales_orders schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/360000738813-Sales-Orders-CR- "Opens in new tab: SaaSOptics API method") | sales\_orders table schema | **close\_date**

DATE-TIME | | --- | | **contract\_channel**

STRING | | **contract\_email**

STRING | | **contract\_entry\_date**

DATE-TIME | | **contract\_is\_job**

BOOLEAN | | **contract\_lead\_date**

DATE-TIME | | **contract\_lead\_source**

STRING | | **contract\_notes**

STRING | | **contract\_number**

STRING | | **contract\_number\_field1**

NUMBER | | **contract\_number\_field2**

NUMBER | | **contract\_register\_name**

STRING | | **contract\_sf\_id**

STRING | | **contract\_text\_field1**

STRING | | **contract\_text\_field2**

STRING | | **contract\_unbalanced\_revenue\_exception**

BOOLEAN | | **created**

DATE-TIME | | **created\_by\_username**

STRING | | **customer\_account\_number**

STRING | | **customer\_alt\_contact**

STRING | | **customer\_alt\_phone**

STRING | | **customer\_autopay\_enrollment**

STRING | | **customer\_billing\_addr3**

STRING | | **customer\_billing\_city**

STRING | | **customer\_billing\_country**

STRING | | **customer\_billing\_state**

STRING | | **customer\_billing\_street**

STRING | | **customer\_billing\_zip\_code**

STRING | | **customer\_code**

STRING | | **customer\_contact**

STRING | | **customer\_crm\_id**

STRING | | **customer\_currency**

STRING | | **customer\_default\_autorenewal\_profile**

STRING | | **customer\_default\_cadence\_template**

STRING | | **customer\_default\_email\_from\_so**

STRING | | **customer\_default\_enable\_ach\_payment**

BOOLEAN | | **customer\_default\_enable\_cc\_payment**

BOOLEAN | | **customer\_default\_invoice\_template**

STRING | | **customer\_default\_theme**

STRING | | **customer\_do\_not\_sync**

BOOLEAN | | **customer\_email**

STRING | | **customer\_enable\_autopay**

BOOLEAN | | **customer\_entity\_use\_code**

STRING | | **customer\_fax**

STRING | | **customer\_first\_name**

STRING | | **customer\_industry**

STRING | | **customer\_invoice\_email\_preference**

BOOLEAN | | **customer\_invoice\_print\_preference**

BOOLEAN | | **customer\_item\_sales\_tax**

STRING | | **customer\_last\_name**

STRING | | **customer\_market**

STRING | | **customer\_name**

STRING | | **customer\_notes**

STRING | | **customer\_number**

STRING | | **customer\_number\_field1**

NUMBER | | **customer\_number\_field2**

NUMBER | | **customer\_number\_field3**

NUMBER | | **customer\_parent**

STRING | | **customer\_payment\_terms**

STRING | | **customer\_phone**

STRING | | **customer\_resale\_number**

STRING | | **customer\_sales\_rep**

STRING | | **customer\_sales\_tax\_code**

STRING | | **customer\_salutation**

STRING | | **customer\_segment**

STRING | | **customer\_sf\_default\_renewal\_opportunity\_rule**

STRING | | **customer\_sf\_opportunity\_price\_book\_id**

STRING | | **customer\_sf\_owner\_id**

STRING | | **customer\_sfdc\_object\_id**

STRING | | **customer\_shipping\_addr3**

STRING | | **customer\_shipping\_city**

STRING | | **customer\_shipping\_country**

STRING | | **customer\_shipping\_state**

STRING | | **customer\_shipping\_street**

STRING | | **customer\_shipping\_zip\_code**

STRING | | **customer\_subsegment**

STRING | | **customer\_text\_field1**

STRING | | **customer\_text\_field2**

STRING | | **customer\_text\_field3**

STRING | | **customer\_type**

STRING | | **customer\_unbalanced\_revenue\_exception**

BOOLEAN | | **id**

INTEGER | | **line\_items**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand line\_items

affected_transaction

STRING

created

DATE-TIME

created_by_username

STRING

INTEGER

invoice_billing_addr1

STRING

invoice_billing_addr2

STRING

invoice_billing_addr3

STRING

invoice_billing_city

STRING

invoice_billing_country

STRING

invoice_billing_state

STRING

invoice_billing_zip_code

STRING

invoice_cadence_template

STRING

invoice_date

DATE-TIME

invoice_do_not_sync

BOOLEAN

invoice_ei_combine_all_description

STRING

invoice_ei_combine_lines

STRING

invoice_ei_theme

STRING

invoice_email_from_so

BOOLEAN

invoice_enable_ach_payment

BOOLEAN

invoice_enable_cc_payment

BOOLEAN

invoice_ignore_date_when_syncing

BOOLEAN

invoice_memo

STRING

invoice_other

STRING

invoice_payment_terms

STRING

invoice_po_number

STRING

invoice_qb_class

STRING

invoice_qb_customer_message

STRING

invoice_qb_payment_terms

STRING

invoice_qb_sales_rep

STRING

invoice_qb_template

STRING

invoice_ship_date

DATE-TIME

invoice_shipping_addr1

STRING

invoice_shipping_addr2

STRING

invoice_shipping_addr3

STRING

invoice_shipping_city

STRING

invoice_shipping_country

STRING

invoice_shipping_state

STRING

invoice_shipping_zip_code

STRING

invoice_suppress_zero_value_line_items

BOOLEAN

invoice_to_be_emailed

BOOLEAN

invoice_to_be_printed

BOOLEAN

line_item_id

STRING

processed

BOOLEAN

project_template

STRING

renewed_transaction

STRING

sfdc_object_type

STRING

transaction_action

STRING

transaction_amount

NUMBER

transaction_amount_after_discount

NUMBER

transaction_arr_amount

NUMBER

transaction_billing_method

STRING

transaction_conversion

STRING

transaction_crm_opportunity_id

STRING

transaction_crm_opportunity_line_item_id

STRING

transaction_discount_amount

NUMBER

transaction_duration

STRING

transaction_effective_change_date

DATE-TIME

transaction_effective_end_date

DATE-TIME

transaction_end_date

DATE-TIME

transaction_flagged

STRING

transaction_foreign_exchange_rate

NUMBER

transaction_generate_invoices

BOOLEAN

transaction_generate_revenue

BOOLEAN

transaction_ili_description

STRING

transaction_ili_qb_class

STRING

transaction_invoice_end_date

DATE-TIME

transaction_invoice_quantity

NUMBER

transaction_invoice_start_date

DATE-TIME

transaction_item_class_name

STRING

transaction_item_code

STRING

transaction_item_name

STRING

transaction_monthly_rate

NUMBER

transaction_normalized_amount

NUMBER

transaction_normalized_term

STRING

transaction_notes

STRING

transaction_number_field1

NUMBER

transaction_number_field2

NUMBER

transaction_order_date

DATE-TIME

transaction_order_number

STRING

transaction_quantity

NUMBER

transaction_recognize

BOOLEAN

transaction_renew_using_item

STRING

transaction_renewal_amount

NUMBER

transaction_renewal_amount_percentage

NUMBER

transaction_renewal_duration

STRING

transaction_renewal_factor

STRING

transaction_renewal_probability

NUMBER

transaction_renewal_quantity

NUMBER

transaction_revenue_amount

NUMBER

transaction_revenue_end_date

DATE-TIME

transaction_revenue_recognition_method

STRING

transaction_revenue_start_date

DATE-TIME

transaction_sales_manager

STRING

transaction_sales_rep

STRING

transaction_sf_group_id

STRING

transaction_sf_id

STRING

transaction_sf_renewal_opportunitiy_rule

STRING

transaction_start_date

DATE-TIME

transaction_term_number

INTEGER

transaction_text_field1

STRING

transaction_text_field2

STRING

transaction_unbalanced_revenue_exception

BOOLEAN

| | **name**

STRING | | **order\_notes**

STRING | | **order\_total**

STRING | | **project\_name**

STRING | | **project\_template**

STRING | | **quickbooks\_job\_account\_number**

STRING | | **quickbooks\_job\_addr1**

STRING | | **quickbooks\_job\_addr2**

STRING | | **quickbooks\_job\_addr3**

STRING | | **quickbooks\_job\_alt\_contact**

STRING | | **quickbooks\_job\_alt\_phone**

STRING | | **quickbooks\_job\_city**

STRING | | **quickbooks\_job\_company\_name**

STRING | | **quickbooks\_job\_contact**

STRING | | **quickbooks\_job\_country**

STRING | | **quickbooks\_job\_default\_credit\_memo\_template**

STRING | | **quickbooks\_job\_default\_invoice\_template**

STRING | | **quickbooks\_job\_description**

STRING | | **quickbooks\_job\_email**

STRING | | **quickbooks\_job\_end\_date**

DATE-TIME | | **quickbooks\_job\_fax**

STRING | | **quickbooks\_job\_first\_name**

STRING | | **quickbooks\_job\_invoice\_email\_preference**

BOOLEAN | | **quickbooks\_job\_invoice\_print\_preference**

BOOLEAN | | **quickbooks\_job\_is\_active**

BOOLEAN | | **quickbooks\_job\_last\_name**

STRING | | **quickbooks\_job\_name**

STRING | | **quickbooks\_job\_payment\_terms**

STRING | | **quickbooks\_job\_phone**

STRING | | **quickbooks\_job\_projected\_end\_date**

DATE-TIME | | **quickbooks\_job\_resale\_number**

STRING | | **quickbooks\_job\_sales\_rep**

STRING | | **quickbooks\_job\_salutation**

STRING | | **quickbooks\_job\_shipping\_addr1**

STRING | | **quickbooks\_job\_shipping\_addr2**

STRING | | **quickbooks\_job\_shipping\_addr3**

STRING | | **quickbooks\_job\_shipping\_city**

STRING | | **quickbooks\_job\_shipping\_country**

STRING | | **quickbooks\_job\_shipping\_state**

STRING | | **quickbooks\_job\_shipping\_zip\_code**

STRING | | **quickbooks\_job\_start\_date**

DATE-TIME | | **quickbooks\_job\_state**

STRING | | **quickbooks\_job\_status**

STRING | | **quickbooks\_job\_type**

STRING | | **quickbooks\_job\_zip\_code**

STRING | | **sales\_order\_id**

STRING | | **stage\_name**

STRING | | **type**

STRING | ### transactions The `transactions` table contains info about transactions. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | modified | | **Useful links** | [transactions schema on GitHub](https://github.com/singer-io/tap-saasoptics/blob/master/tap_saasoptics/schemas/transactions.json "Opens in new tab: transactions schema on GitHub")

[SaaSOptics API method](https://saasoptics.zendesk.com/hc/en-us/articles/360000066333-Transactions-CRUD- "Opens in new tab: SaaSOptics API method") | transactions table schema | **always\_use\_amount\_as\_normalized\_amount**

BOOLEAN | | --- | | **auditentry\_created**

DATE-TIME | | **auditentry\_created\_by\_name**

STRING | | **auditentry\_modified**

DATE-TIME | | **auditentry\_modified\_by\_name**

STRING | | **automatically\_update\_revenue**

BOOLEAN | | **autorenewal\_profile**

INTEGER | | **billing\_method**

INTEGER | | **cancelled**

BOOLEAN | | **contract**

INTEGER | | **conversion**

STRING | | **crm\_opportunity\_id**

STRING | | **crm\_opportunity\_line\_item\_id**

STRING | | **different\_invoice\_item\_permitted**

BOOLEAN | | **do\_not\_sync\_invoices**

BOOLEAN | | **duration**

STRING | | **end\_date**

DATE-TIME | | **flagged**

STRING | | **foreign\_exchange\_rate**

NUMBER | | **home\_amount**

NUMBER | | **home\_arr\_amount**

NUMBER | | **home\_normalized\_amount**

NUMBER | | **home\_normalized\_rate**

NUMBER | | **home\_rate**

NUMBER | | **id**

INTEGER | | **ili\_qb\_class**

STRING | | **invoice\_description**

STRING | | **is\_autorenewal**

BOOLEAN | | **item**

INTEGER | | **item\_class**

INTEGER | | **local\_amount**

NUMBER | | **local\_arr\_amount**

NUMBER | | **local\_normalized\_amount**

NUMBER | | **local\_normalized\_rate**

NUMBER | | **local\_rate**

NUMBER | | **modified**

DATE-TIME | | **monthyear**

STRING | | **notes**

STRING | | **number**

STRING | | **number\_field1**

NUMBER | | **number\_field2**

NUMBER | | **order\_date**

DATE-TIME | | **order\_number**

STRING | | **project**

INTEGER | | **quantity**

NUMBER | | **recognize**

BOOLEAN | | **reconcile\_required**

BOOLEAN | | **renew\_using\_item**

INTEGER | | **renewal\_amount**

NUMBER | | **renewal\_amount\_percentage**

NUMBER | | **renewal\_amount\_value**

NUMBER | | **renewal\_duration**

STRING | | **renewal\_factor**

INTEGER | | **renewal\_of\_set**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **renewal\_probability**

NUMBER | | **renewal\_quantity**

NUMBER | | **revenue\_amount**

NUMBER | | **revenue\_notes**

STRING | | **sales\_manager**

STRING | | **sales\_rep**

STRING | | **sf\_group\_id**

STRING | | **sf\_id**

STRING | | **sf\_opportunity\_id**

STRING | | **sf\_opportunity\_line\_item\_id**

STRING | | **sf\_renewal\_opportunity\_id**

STRING | | **sf\_renewal\_opportunity\_line\_item\_id**

STRING | | **sf\_renewal\_opportunity\_rule**

STRING | | **start\_date**

DATE-TIME | | **term\_number**

INTEGER | | **text\_field1**

STRING | | **text\_field2**

STRING | | **unbalanced\_revenue\_exception**

BOOLEAN |