Railz

Prerequisites

• A Railz account with permission to access data from accounts you want to sync.
• Railz Client ID and Secret key

Tables in the Railz connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	inventory	14	id	Full Refresh		API Reference
2	refunds	17	id	Full Refresh, Incremental	date	API Reference
3	commerce_transactions	12	id	Full Refresh, Incremental	createdDate
4	bank_transfers	13	id	Full Refresh, Incremental	date
5	invoices	21	id	Full Refresh, Incremental	postedDate	API Reference
6	bills	22	id	Full Refresh, Incremental	postedDate	API Reference
7	customers	16	id	Full Refresh		API Reference
8	commerce_products	11	id	Full Refresh, Incremental	createdDate
9	vendors	16	id	Full Refresh		API Reference
10	businesses	6	businessName	Full Refresh		API Reference
11	connections	8	connectionId	Full Refresh		API Reference
12	bills_payments	13	id	Full Refresh, Incremental	date
13	estimates	20	id	Full Refresh, Incremental	postedDate	API Reference
14	bills_credit_notes	20	id	Full Refresh, Incremental	postedDate
15	journal_entries	13	id	Full Refresh, Incremental	postedDate
16	purchase_orders	21	id	Full Refresh, Incremental	postedDate
17	tracking_categories	8	id	Full Refresh
18	deposits	13	id	Full Refresh, Incremental	postedDate	API Reference
19	tax_rates	9	id	Full Refresh
20	invoices_credit_notes	20	id	Full Refresh, Incremental	postedDate
21	accounting_transactions	17	id	Full Refresh, Incremental	postedDate
22	commerce_orders	22	id	Full Refresh, Incremental	createdDate
23	invoices_payments	13	id	Full Refresh, Incremental	date
24	commerce_disputes	11	id	Full Refresh, Incremental	createdDate
25	bank_accounts	14	accountId	Full Refresh
26	accounts	23	id	Full Refresh		API Reference

Table: inventory

No	Column Name	Type	Notes
1	subsidiaryRefs	VARCHAR
2	code	VARCHAR
3	businessName	VARCHAR
4	serviceName	VARCHAR
5	taxRateRef	VARCHAR
6	sourceModifiedDate	VARCHAR
7	itemStatus	VARCHAR
8	quantityOnHand	VARCHAR
9	name	VARCHAR
10	isInvoiceItem	BOOLEAN
11	quantityOnHandPerLocation	VARCHAR
12	id	VARCHAR	Primary Key
13	billItem	VARCHAR
14	isBillItem	BOOLEAN

Table: refunds

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	businessName	VARCHAR
3	memo	VARCHAR
4	subTotal	DOUBLE
5	serviceName	VARCHAR
6	discountPercentage	DOUBLE
7	totalAmount	DOUBLE
8	sourceModifiedDate	VARCHAR
9	customerRef	VARCHAR
10	currencyRef	VARCHAR
11	totalDiscount	DOUBLE
12	shippingAddress	VARCHAR
13	id	VARCHAR	Primary Key
14	accountRef	VARCHAR
15	currencyRate	DOUBLE
16	lines	VARCHAR
17	taxAmount	DOUBLE

Table: commerce_transactions

No	Column Name	Type	Notes
1	transactionType	VARCHAR
2	totalAmount	DOUBLE
3	createdDate	VARCHAR	Incremental sync key
4	sourceModifiedDate	VARCHAR
5	orderId	VARCHAR
6	currencyRef	VARCHAR
7	businessName	VARCHAR
8	id	VARCHAR	Primary Key
9	serviceName	VARCHAR
10	paymentMethodType	VARCHAR
11	transactionSourceRefs	VARCHAR
12	status	VARCHAR

Table: bank_transfers

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	businessName	VARCHAR
3	memo	VARCHAR
4	serviceName	VARCHAR
5	totalAmount	DOUBLE
6	fromBankTransactionId	VARCHAR
7	sourceModifiedDate	VARCHAR
8	currencyRef	VARCHAR
9	toBankTransactionId	VARCHAR
10	toAccountRef	VARCHAR
11	id	VARCHAR	Primary Key
12	currencyRate	DOUBLE
13	fromAccountRef	VARCHAR

Table: invoices

No	Column Name	Type	Notes
1	subsidiaryRefs	VARCHAR
2	dueDate	VARCHAR
3	payments	VARCHAR
4	businessName	VARCHAR
5	memo	VARCHAR
6	subTotal	DOUBLE
7	serviceName	VARCHAR
8	postedDate	VARCHAR	Incremental sync key
9	amountDue	DOUBLE
10	discountPercentage	DOUBLE
11	totalAmount	DOUBLE
12	sourceModifiedDate	VARCHAR
13	customerRef	VARCHAR
14	currencyRef	VARCHAR
15	invoiceNumber	VARCHAR
16	totalDiscount	DOUBLE
17	id	VARCHAR	Primary Key
18	currencyRate	DOUBLE
19	lines	VARCHAR
20	taxAmount	DOUBLE
21	status	VARCHAR

Table: bills

No	Column Name	Type	Notes
1	subsidiaryRefs	VARCHAR
2	purchaseOrderRef	VARCHAR
3	dueDate	VARCHAR
4	payments	VARCHAR
5	businessName	VARCHAR
6	memo	VARCHAR
7	subTotal	DOUBLE
8	serviceName	VARCHAR
9	vendorInvoiceNumber	VARCHAR
10	vendorRef	VARCHAR
11	postedDate	VARCHAR	Incremental sync key
12	amountDue	DOUBLE
13	totalAmount	DOUBLE
14	sourceModifiedDate	VARCHAR
15	currencyRef	VARCHAR
16	locationRef	VARCHAR
17	id	VARCHAR	Primary Key
18	currencyRate	DOUBLE
19	lines	VARCHAR
20	taxAmount	DOUBLE
21	purchaseOrderRefs	VARCHAR
22	status	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	subsidiaryRefs	VARCHAR
2	website	VARCHAR
3	addresses	VARCHAR
4	contactName	VARCHAR
5	businessName	VARCHAR
6	taxNumber	VARCHAR
7	serviceName	VARCHAR
8	customerName	VARCHAR
9	emailAddress	VARCHAR
10	sourceModifiedDate	VARCHAR
11	balance	DOUBLE
12	phone	VARCHAR
13	defaultCurrency	VARCHAR
14	id	VARCHAR	Primary Key
15	contacts	VARCHAR
16	status	VARCHAR

Table: commerce_products

No	Column Name	Type	Notes
1	createdDate	VARCHAR	Incremental sync key
2	sourceModifiedDate	VARCHAR
3	isGiftCard	BOOLEAN
4	businessName	VARCHAR
5	name	VARCHAR
6	description	VARCHAR
7	productVariants	VARCHAR
8	id	VARCHAR	Primary Key
9	serviceName	VARCHAR
10	type	VARCHAR
11	status	VARCHAR

Table: vendors

No	Column Name	Type	Notes
1	subsidiaryRefs	VARCHAR
2	website	VARCHAR
3	addresses	VARCHAR
4	contactName	VARCHAR
5	businessName	VARCHAR
6	taxNumber	VARCHAR
7	serviceName	VARCHAR
8	vendorName	VARCHAR
9	emailAddress	VARCHAR
10	sourceModifiedDate	VARCHAR
11	balance	DOUBLE
12	phone	VARCHAR
13	defaultCurrency	VARCHAR
14	id	VARCHAR	Primary Key
15	contacts	VARCHAR
16	status	VARCHAR

Table: businesses

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	metadata	VARCHAR
3	businessName	VARCHAR	Primary Key
4	connections	VARCHAR
5	status	VARCHAR
6	updatedAt	VARCHAR

Table: connections

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	businessName	VARCHAR
3	connectionId	VARCHAR	Primary Key
4	description	VARCHAR
5	serviceName	VARCHAR
6	firstRecordDate	VARCHAR
7	status	VARCHAR
8	updatedAt	VARCHAR

Table: bills_payments

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	subsidiaryRefs	VARCHAR
3	businessName	VARCHAR
4	memo	VARCHAR
5	serviceName	VARCHAR
6	vendorRef	VARCHAR
7	totalAmount	DOUBLE
8	sourceModifiedDate	VARCHAR
9	currencyRef	VARCHAR
10	id	VARCHAR	Primary Key
11	accountRef	VARCHAR
12	currencyRate	DOUBLE
13	lines	VARCHAR

Table: estimates

No	Column Name	Type	Notes
1	dueDate	VARCHAR
2	businessName	VARCHAR
3	memo	VARCHAR
4	subTotal	DOUBLE
5	serviceName	VARCHAR
6	acceptedDate	VARCHAR
7	postedDate	VARCHAR	Incremental sync key
8	expiryDate	VARCHAR
9	discountPercentage	DOUBLE
10	totalAmount	DOUBLE
11	sourceModifiedDate	VARCHAR
12	customerRef	VARCHAR
13	currencyRef	VARCHAR
14	totalDiscount	DOUBLE
15	shippingAddress	VARCHAR
16	id	VARCHAR	Primary Key
17	currencyRate	DOUBLE
18	lines	VARCHAR
19	taxAmount	DOUBLE
20	status	VARCHAR

Table: bills_credit_notes

No	Column Name	Type	Notes
1	remainingCredit	DOUBLE
2	payments	VARCHAR
3	businessName	VARCHAR
4	memo	VARCHAR
5	subTotal	DOUBLE
6	serviceName	VARCHAR
7	vendorRef	VARCHAR
8	postedDate	VARCHAR	Incremental sync key
9	discountPercentage	DOUBLE
10	totalAmount	DOUBLE
11	sourceModifiedDate	VARCHAR
12	currencyRef	VARCHAR
13	locationRef	VARCHAR
14	allocatedOnDate	VARCHAR
15	totalDiscount	DOUBLE
16	id	VARCHAR	Primary Key
17	currencyRate	DOUBLE
18	lines	VARCHAR
19	taxAmount	DOUBLE
20	status	VARCHAR

Table: journal_entries

No	Column Name	Type	Notes
1	subsidiaryRefs	VARCHAR
2	totalCredit	DOUBLE
3	businessName	VARCHAR
4	memo	VARCHAR
5	serviceName	VARCHAR
6	postedDate	VARCHAR	Incremental sync key
7	createdDate	VARCHAR
8	sourceModifiedDate	VARCHAR
9	currencyRef	VARCHAR
10	totalDebit	DOUBLE
11	id	VARCHAR	Primary Key
12	currencyRate	DOUBLE
13	lines	VARCHAR

Table: purchase_orders

No	Column Name	Type	Notes
1	dueDate	VARCHAR
2	businessName	VARCHAR
3	memo	VARCHAR
4	subTotal	DOUBLE
5	serviceName	VARCHAR
6	vendorRef	VARCHAR
7	postedDate	VARCHAR	Incremental sync key
8	discountPercentage	DOUBLE
9	totalAmount	DOUBLE
10	sourceModifiedDate	VARCHAR
11	expectedArrivalDate	VARCHAR
12	currencyRef	VARCHAR
13	totalDiscount	DOUBLE
14	shippingAddress	VARCHAR
15	id	VARCHAR	Primary Key
16	currencyRate	DOUBLE
17	deliveryDate	VARCHAR
18	lines	VARCHAR
19	taxAmount	DOUBLE
20	contacts	VARCHAR
21	status	VARCHAR

Table: tracking_categories

No	Column Name	Type	Notes
1	sourceModifiedDate	VARCHAR
2	isEditable	BOOLEAN
3	businessName	VARCHAR
4	name	VARCHAR
5	id	VARCHAR	Primary Key
6	serviceName	VARCHAR
7	parentRef	VARCHAR
8	status	VARCHAR

Table: deposits

No	Column Name	Type	Notes
1	businessName	VARCHAR
2	memo	VARCHAR
3	subTotal	DOUBLE
4	serviceName	VARCHAR
5	postedDate	VARCHAR	Incremental sync key
6	totalAmount	DOUBLE
7	sourceModifiedDate	VARCHAR
8	currencyRef	VARCHAR
9	id	VARCHAR	Primary Key
10	currencyRate	DOUBLE
11	lines	VARCHAR
12	taxAmount	DOUBLE
13	status	VARCHAR

Table: tax_rates

No	Column Name	Type	Notes
1	components	VARCHAR
2	code	VARCHAR
3	sourceModifiedDate	VARCHAR
4	effectiveTaxRate	DOUBLE
5	businessName	VARCHAR
6	name	VARCHAR
7	totalTaxRate	DOUBLE
8	id	VARCHAR	Primary Key
9	serviceName	VARCHAR

Table: invoices_credit_notes

No	Column Name	Type	Notes
1	remainingCredit	DOUBLE
2	payments	VARCHAR
3	businessName	VARCHAR
4	memo	VARCHAR
5	subTotal	DOUBLE
6	serviceName	VARCHAR
7	postedDate	VARCHAR	Incremental sync key
8	discountPercentage	DOUBLE
9	totalAmount	DOUBLE
10	sourceModifiedDate	VARCHAR
11	currencyRef	VARCHAR
12	locationRef	VARCHAR
13	customerRef	VARCHAR
14	allocatedOnDate	VARCHAR
15	totalDiscount	DOUBLE
16	id	VARCHAR	Primary Key
17	currencyRate	DOUBLE
18	lines	VARCHAR
19	taxAmount	DOUBLE
20	status	VARCHAR

Table: accounting_transactions

No	Column Name	Type	Notes
1	isReconciled	BOOLEAN
2	transactionNumber	VARCHAR
3	businessName	VARCHAR
4	isSplitTransaction	BOOLEAN
5	entityRef	VARCHAR
6	subTotal	DOUBLE
7	serviceName	VARCHAR
8	type	VARCHAR
9	postedDate	VARCHAR	Incremental sync key
10	parentTransactionId	VARCHAR
11	totalAmount	DOUBLE
12	currencyRef	VARCHAR
13	isPosting	BOOLEAN
14	id	VARCHAR	Primary Key
15	accountRef	VARCHAR
16	currencyRate	DOUBLE
17	taxAmount	DOUBLE

Table: commerce_orders

No	Column Name	Type	Notes
1	orderNumber	VARCHAR
2	totalDiscountAmount	DOUBLE
3	businessName	VARCHAR
4	fulfillmentRefs	VARCHAR
5	serviceName	VARCHAR
6	totalShippingAmount	DOUBLE
7	fulfillmentStatus	VARCHAR
8	totalAmount	DOUBLE
9	createdDate	VARCHAR	Incremental sync key
10	sourceModifiedDate	VARCHAR
11	customerRef	VARCHAR
12	currencyRef	VARCHAR
13	shippingAddress	VARCHAR
14	refundRefs	VARCHAR
15	id	VARCHAR	Primary Key
16	billingAddress	VARCHAR
17	lines	VARCHAR
18	totalTaxAmount	DOUBLE
19	paymentStatus	VARCHAR
20	transactionSourceRefs	VARCHAR
21	totalGratuityAmount	DOUBLE
22	status	VARCHAR

Table: invoices_payments

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	subsidiaryRefs	VARCHAR
3	businessName	VARCHAR
4	memo	VARCHAR
5	serviceName	VARCHAR
6	totalAmount	DOUBLE
7	sourceModifiedDate	VARCHAR
8	customerRef	VARCHAR
9	currencyRef	VARCHAR
10	id	VARCHAR	Primary Key
11	accountRef	VARCHAR
12	currencyRate	DOUBLE
13	lines	VARCHAR

Table: commerce_disputes

No	Column Name	Type	Notes
1	totalAmount	DOUBLE
2	reason	VARCHAR
3	createdDate	VARCHAR	Incremental sync key
4	sourceModifiedDate	VARCHAR
5	orderRef	VARCHAR
6	currencyRef	VARCHAR
7	dueDate	VARCHAR
8	businessName	VARCHAR
9	id	VARCHAR	Primary Key
10	serviceName	VARCHAR
11	status	VARCHAR

Table: bank_accounts

No	Column Name	Type	Notes
1	accountName	VARCHAR
2	accountSubType	VARCHAR
3	currentBalance	DOUBLE
4	accountType	VARCHAR
5	businessName	VARCHAR
6	serviceName	VARCHAR
7	maskedAccountNumber	VARCHAR
8	availableBalance	DOUBLE
9	accountId	VARCHAR	Primary Key
10	sourceModifiedDate	VARCHAR
11	institutionName	VARCHAR
12	limit	DOUBLE
13	currency	VARCHAR
14	officialAccountName	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	isBankAccount	BOOLEAN
2	subsidiaryRefs	VARCHAR
3	subGroup	VARCHAR
4	currentBalance	DOUBLE
5	businessName	VARCHAR
6	nominalCode	VARCHAR
7	description	VARCHAR
8	section	VARCHAR
9	serviceName	VARCHAR
10	classification	VARCHAR
11	fullyQualifiedName	VARCHAR
12	type	VARCHAR
13	isActive	BOOLEAN
14	parentRef	VARCHAR
15	depth	INTEGER
16	sourceModifiedDate	VARCHAR
17	currencyRef	VARCHAR
18	name	VARCHAR
19	isSubAccount	BOOLEAN
20	subSection	VARCHAR
21	subType	VARCHAR
22	id	VARCHAR	Primary Key
23	group	VARCHAR

External Resources

• Railz Api
• On The Dashboard
• Tax Rates
• Tracking Categories
• Bank Accounts
• Accounting Transactions
• Bank Transfers
• Bills Credit Notes
• Bills Payments
• Invoices Credit Notes
• Invoices Payments
• Journal Entries
• Purchase Orders
• Commerce Disputes
• Commerce Orders
• Commerce Products
• Commerce Transactions

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.