ezyCollect Custom Integration

	A	B	C	D	E	F
1	Api Entity	Field	Type	Format	Max Size	Example

2	Customer	id	string	-	255	b90r3v28y5n0283
3	Customer	parentId	string	-	255	c79eq79cbebece
4	Customer	groupId	number	int32		5
5	Customer	chaseHeadOffice	boolean	TRUE		TRUE
6	Customer	accountNumber	string	-	500	EC0023
7	Customer	name	string	-	500	ezyCollect
8	Customer	creditTerms	string	-	45	30 days after EOM
9	Customer	creditLimit	number	double		50000
10	Customer	active	boolean	-		TRUE
11	Customer	onHold	boolean			FALSE
12	Customer	businessNumber	string	-	255	[53 156 330 371] will become [53156330371]
13	Customer	street	string	-	500	Level 1/80 Bay Street
14	Customer	street2	string	-	256	Apartment
15	Customer	city	string	-	256	Ultimo
16	Customer	state	string	-	256	NSW
17	Customer	postcode	string	-	100	2007
18	Customer	country	string	-	256	AU
19	Customer	balance	number	double		20154.76
20	Customer	consolidatedBalance	number	double		202154.76
21	Customer	earlyDiscountDays	number	int32		5
22	Customer	earlyDiscountRate	number	double		35.3
23	Customer	latePaymentChargeRate	number	double		18.5
24	Customer	notes	string	-	2000	Doesn't like to pay before the 15th of the month
25	Customer	salesRepresentative	string	-	255	Jack
26	Customer	customField	string	-	1024	BSB 082902
27	Customer	customField2	string	-	1024	Account 1054-4852
28	Customer	customField3	string	-	1024	Account name Julius Caesar
29	Example Query:
30	Select c.UniqueID As id, c.ParentAccount As 'parentId', c.CustomerGroup As 'groupId', CASE WHEN c.ParentAccount <> '' THEN 'true' ELSE 'false' END As 'chaseHeadOffice', c.CustomerCode As 'accountNumber', c.CustomerTitle As 'name', tt.TermsTitle As 'creditTerms', c.CreditLimit As 'creditLimit', 'true' As 'active', CASE WHEN c.HoldInvoices = 1 THEN 'true' ELSE 'false' END As 'onHold', c.Status As 'status', c.TaxNumber As 'businessNumber' , c.MailingStreet1 As 'street', c.MailingStreet1 As 'street2', c.MailingSuburb As 'city', c.MailingState As 'state', c.Postcode as 'postcode', c.MailingCountry As 'country', c.TotalDue as 'balance', c.TotalDue As 'consolidatedBalance', 0 As 'earlyDiscountDays', c.Discount As 'earlyDiscountRate', c.Interest As 'latePaymentChargeRate', c.Remarks As 'notes', '' As 'salesRepresentative', c.Notes As 'customField', c.Category as 'customField2', c.TaxStatus As 'customField3' FROM CUSTOMERS c INNER JOIN TRADINGTERMS tt ON tt.TermsCode = c.Terms WHERE c.TotalDue <> 0 AND c.Status like 'A%' ORDER BY ParentAccount ASC
31	Observations	Only customers with a balance <> 0 and active are required
32		When a Customer has parentId, Parent customer should exist in the sync
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100