Younium

Prerequisites

This Younium source uses the Younium API.

Tables in the Younium connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	product	14		Full Refresh
2	subscription	45		Full Refresh
3	invoice	37		Full Refresh

Table: product

No	Column Name	Type	Notes
1	externalCRMId	VARCHAR
2	chargePlans	VARCHAR
3	customFields	VARCHAR
4	productNumber	VARCHAR
5	endOfLifeDate	VARCHAR
6	endOfNewSalesDate	VARCHAR
7	endOfRenewalDate	VARCHAR
8	isFrameworkProduct	BOOLEAN
9	externalERPId	VARCHAR
10	name	VARCHAR
11	id	VARCHAR
12	category	VARCHAR
13	activationDate	VARCHAR
14	productType	VARCHAR

Table: subscription

No	Column Name	Type	Notes
1	effectiveEndDate	VARCHAR
2	orderType	VARCHAR
3	orderNumber	VARCHAR
4	cmrr	VARCHAR
5	customFields	VARCHAR
6	emrr	VARCHAR
7	termType	VARCHAR
8	description	VARCHAR
9	invoiceAccount	VARCHAR
10	orderPaymentMethod	VARCHAR
11	invoiceAddress	VARCHAR
12	invoiceSeparatly	BOOLEAN
13	products	VARCHAR
14	ourReference	VARCHAR
15	externalERPId	VARCHAR
16	deliveryAddress	VARCHAR
17	acv	VARCHAR
18	useAccountInvoiceBatchGroup	BOOLEAN
19	effectiveStartDate	VARCHAR
20	oneTimeFees	VARCHAR
21	term	DOUBLE
22	currency	VARCHAR
23	id	VARCHAR
24	isAutoRenewed	BOOLEAN
25	lastRenewalDate	VARCHAR
26	cancellationDate	VARCHAR
27	yourReference	VARCHAR
28	invoiceBatchGroup	VARCHAR
29	externalCRMId	VARCHAR
30	tcv	VARCHAR
31	currencyCodeToUseWhenInvoice	VARCHAR
32	noticePeriodDate	VARCHAR
33	orderDiscounts	VARCHAR
34	version	DOUBLE
35	isLastVersion	BOOLEAN
36	noticePeriod	DOUBLE
37	renewalTerm	DOUBLE
38	effectiveChangeDate	VARCHAR
39	milestones	VARCHAR
40	orderDate	VARCHAR
41	paymentTerm	VARCHAR
42	remarks	VARCHAR
43	account	VARCHAR
44	status	VARCHAR
45	yourOrderNumber	VARCHAR

Table: invoice

No	Column Name	Type	Notes
1	settledNotes	VARCHAR
2	notes	VARCHAR
3	taxIncluded	BOOLEAN
4	customFields	VARCHAR
5	dueDate	VARCHAR
6	daysPastDue	DOUBLE
7	invoiceAddress	VARCHAR
8	balancedAmount	DOUBLE
9	ourReference	VARCHAR
10	sendMethod	VARCHAR
11	accountsReceivable	VARCHAR
12	invoiceLines	VARCHAR
13	externalERPId	VARCHAR
14	deliveryAddress	VARCHAR
15	exchangeRate	DOUBLE
16	invoiceNumber	VARCHAR
17	onlinePaymentLink	VARCHAR
18	invoiceType	VARCHAR
19	currency	VARCHAR
20	id	VARCHAR
21	invoiceTemplateId	VARCHAR
22	yourReference	VARCHAR
23	buyerReference	VARCHAR
24	externalCRMId	VARCHAR
25	totalRoundingAmount	DOUBLE
26	invoiceBatchId	VARCHAR
27	tax	DOUBLE
28	invoiceDate	VARCHAR
29	settledAmount	DOUBLE
30	totalAmount	DOUBLE
31	disableAutomaticInvoiceReminder	BOOLEAN
32	nrOfReminders	DOUBLE
33	subtotal	DOUBLE
34	paymentTerm	VARCHAR
35	account	VARCHAR
36	status	VARCHAR
37	yourOrderNumber	VARCHAR

External Resources

• Younium Api
• Younium Web Platform
• Subscriptions
• Products
• Invoices

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.