SaaSOptics

SaaSOptics is a subscription management platform that automates financial operations for growing B2B SaaS businesses.

SaaSOptics integration replicates data using the SaaSOptics REST API.

See the Schema section for a list of objects available for replication.

Общий обзор этого коннектора, включая полезные ссылки и поддерживаемые функции.

Функция/возможность	Сведения о поддержке
Поддерживаемые проекты Qlik Talend Data Integration	Только проекты репликации. Проекты конвейера данных не поддерживаются.
Методы обновления целей	Задачи репликации: Применить изменения Сохранить изменения Промежуточное хранение данных в озере данных: Захват изменений данных (CDC)
Управление метаданными	Создание метаданных вручную не требуется.
Эволюция схемы	Поддерживается только операция Изменить тип данных столбца.
Репликация столбцов LOB (NCLOB, CLOB и BLOB)	Не поддерживается.
Запланированный CDC	Требуется. Так целевой объект обновляется в соответствии с изменениями в источнике. Для получения информации о задачах репликации см. раздел Планирование задач Для получения информации о задачах промежуточного хранения в озере см. раздел Планирование CDC для задач промежуточного хранения в озере
Уведомления	Частично поддерживается Настройка уведомлений об изменениях в работе
Мониторинг	Только CDC, так как полная загрузка для этого коннектора не актуальна. Мониторинг индивидуальной задачи данных
Автоматическое извлечение вложенной полезной нагрузки столбцов JSON	Не поддерживается. Вложенная полезная нагрузка столбцов JSON в исходных наборах данных не извлекается автоматически в цели.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Убедитесь, что используемая учетная запись имеет доступ для чтения к таблицам, которые требуется получить.

Creating the connection

Для получения дополнительной информации см. раздел Подключение к приложениям SaaS.

Заполните необходимые свойства подключения.
Заполните поле Имя подключения.
Установите флажок Открыть метаданные подключения, чтобы определить метаданные для подключения, когда оно будет создано.
Щелкните Создать.

Connection settings
Setting	Description
Data gateway	Выберите шлюз Шлюз движения данных, если этого требует текущий сценарий использования. Примечание к информации Это поле недоступно при использовании подписки Qlik Talend Cloud Starter, так как она не поддерживает Шлюз движения данных. Если используется другой уровень подписки или не требуется использовать Шлюз движения данных, выберите Нет. Для получения информации о преимуществах Шлюз движения данных и о сценариях, требующих его использования, см. раздел Шлюз данных Qlik — движение данных.
Start Date	Введите дату в формате `MM/DD/YYYY`, начиная с которой данные должны реплицироваться из источника в цель.
Account Name	Account Name.
Server Subdomain	Server subdomain. You can find it in the URL of your account homepage. If the URL is https://mycompany.saasoptics.com/, the subdomain is mycompany.
Token	API token.
Date Window Size	The size of the date window for retrieving data.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

accounts

The accounts table contains info about accounts, or records in your Chart of Accounts, in SaaSOptics.

Replication Method

Full Table

Primary Key

Useful links

SaaSOptics API method

account_type

STRING

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

Full Table

Primary Key

Useful links

SaaSOptics API method

days

INTEGER

generate_revenue

BOOLEAN

INTEGER

months

INTEGER

name

STRING

recognize

BOOLEAN

billing_descriptions

The billing_descriptions table contains info about billing line item descriptions.

Replication Method

Full Table

Primary Key

Useful links

SaaSOptics API method

contents

STRING

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

Full Table

Primary Key

Useful links

SaaSOptics API method

INTEGER

name

STRING

contracts

The contracts table contains info about the contracts in your SaaSOptics account.

Replication Method	CDC
Primary Key	id
Replication Key	modified
Useful links	SaaSOptics API method

billing_profile

OBJECT

This is a nested data structure:

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

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

Full Table

Primary Key

Useful links

SaaSOptics API method

code

STRING

INTEGER

name

STRING

currency_codes

The currency_codes table contains info about currency codes.

Replication Method

Full Table

Primary Key

code

Useful links

SaaSOptics API method

code

STRING

name

STRING

customers

The customers table contains info about customers.

Replication Method	CDC
Primary Key	id
Replication Key	modified
Useful links	SaaSOptics API method

autopay_enrollment

STRING

billing_profile

OBJECT

This is a nested data structure:

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
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

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	CDC
Primary Key	id
Replication Key	deleted
Useful links

deleted

DATE-TIME

deleted_by

STRING

INTEGER

deleted_invoices

The deleted_invoices table contains a list of deleted SaaSOptics invoices.

Replication Method	CDC
Primary Key	id
Replication Key	deleted
Useful links

deleted

DATE-TIME

deleted_by

STRING

INTEGER

deleted_revenue_entries

The deleted_revenue_entries table contains a list of deleted SaaSOptics revenue entries.

Replication Method	CDC
Primary Key	id
Replication Key	deleted
Useful links

deleted

DATE-TIME

deleted_by

STRING

INTEGER

deleted_transactions

The deleted_transactions table contains a list of deleted SaaSOptics transactions.

Replication Method	CDC
Primary Key	id
Replication Key	deleted
Useful links

deleted

DATE-TIME

deleted_by

STRING

INTEGER

invoices

The invoices table contains info about invoices in your SaaSOptics account.

Replication Method	CDC
Primary Key	id
Replication Key	auditentry_modified
Useful links	SaaSOptics API method

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

INTEGER

ignore_date_when_syncing

BOOLEAN

is_paid

BOOLEAN

line_items

ARRAY

This is a nested data structure:

deleted_in_qb: BOOLEAN
exported_date: DATE-TIME
external_id: STRING
home_amount: NUMBER
id: 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	CDC
Primary Key	id
Replication Key	modified
Useful links	SaaSOptics API method

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

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

Full Table

Primary Key

Useful links

SaaSOptics API method

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.

Replication Method	CDC
Primary Key	id
Replication Key	modified
Useful links	SaaSOptics API method

currency_code

STRING

default_qb_ar_account

STRING

generated_invoice_number_prefix

STRING

INTEGER

modified

DATE-TIME

name

STRING

revenue_entries

The revenue_entries table contains info about revenue entries.

Replication Method	CDC
Primary Key	id
Replication Key	modified
Useful links	SaaSOptics API method

end_date

DATE-TIME

home_amount

NUMBER

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

Full Table

Primary Key

Useful links

SaaSOptics API method

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	CDC
Primary Key	id
Replication Key	created
Useful links	SaaSOptics API method

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

INTEGER

line_items

ARRAY

This is a nested data structure:

affected_transaction: STRING
created: DATE-TIME
created_by_username: STRING
id: 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: STRING
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	CDC
Primary Key	id
Replication Key	modified
Useful links	SaaSOptics API method

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

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

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

Помогла ли вам эта страница?

Если вы обнаружили какую-либо проблему на этой странице или с ее содержанием — будь то опечатка, пропущенный шаг или техническая ошибка, сообщите нам об этом!

Оставьте свой отзыв здесь