Databuild Client / Job Integration Mapping

Databuild Job Database

Job Table

Framework Integration updates the following fields in Databuild from the fields in Framework. If a field is not specified the Field is not updated by default Integration.

Databuild Field	Create	Update	Default Value	Framework Field - Screen and field
AnyQuantities	Yes	No	0	N/A
CCBank	Yes	Yes		Uses the Integration Profile Value for the key dbuild_CostCentreGroupCode.
ContractGST	Yes	Yes		Document / B. Contract Building Contract Amount (GST)
ContractPrice	Yes	Yes		Document / B. Contract Building Contract Amount (ex GST)
ContractType	No	No		(AUS = 4)
Debtor	Yes	No		This will be the client Link Accts value if it is not empty. If it is empty then the value will be determined by striping all non alpha numeric characters from the Client Report/Search Name, and then taking only the first 4 characters of what is left. Then a search is done in databuild to find all clients with similar beginning codes and it determines a 2 digit number to append to the end to make it unique. - i.e - 'BLOG01'
DebtorName	Yes	Yes		Client Overview Full Name
EndDate	Yes	Yes		Construction Overview Revised Completion Date
Estimator	Yes	Yes		Administration / Ordering Ordering Estimator
Forecast	Yes	Yes		Document / B. Contract Building Contract Amount (ex GST)
GST	Yes	No	Tick (Value = 1)	N/A
Job_No	Yes	No		Client / Job Overvierw Job Number shortened to 8 characters.
JobPostCode	Yes	Yes		Land Overview Postcode
LiveOrders	Yes	No	Value = 0
LockBudgets	Yes	No	Value = 0
Salesperson	Yes	Yes		Pre-Admin Overview Primary Salesperson
ScheduleProfile	Yes	Yes		Client Job Overview House Type
Site_Address	Yes	Yes		Land Overview If the job lot number is not empty then the value will be “Lot “ + lot number + “, “ + street number + “ “ + street name Else it will be street number + “ “ + street name.
SiteState	Yes	Yes		Land Overview State
SiteStreet	Yes	Yes		Land Overview If the job lot number is not empty then the value will be “Lot “ + lot number + “, “ + street number + “ “ + street name Else it will be street number + “ “ + street name.
SiteSuburb	Yes	Yes		Land Overview Suburb
StartDate	Yes	Yes		Construction Overview Site Start Actual
Supervisor	Yes	Yes		Construction Overview Supervisor

Databuild System Database

Contacts Table

Databuild Field	Create	Update	Default Value	Framework Field - Screen and field
Address	Yes	Yes		Client Overview Client street number + “ “ + Client street name.
City	Yes	Yes		Client Overview Suburb
Code	Yes	No		This will be the client Link Accts value if it is not empty. If it is empty then the value will be determined by striping all non alpha numeric characters from the Client Report/Search Name, and then taking only the first 4 characters of what is left. Then a search is done in databuild to find all clients with similar beginning codes and it determines a 2 digit number to append to the end to make it unique. - i.e - 'BLOG01'
Contact	Yes	Yes		Client Contacts - Primary Contact Name Full Name
Dear	Yes	Yes		Client Overview Salutation
Debtor	Yes	No	Value = 1
Email	Yes	Yes
Fax	Yes	Yes
Group	Yes	Yes		Uses the Integration Profile Value for the key dbuild_ContactGroupCode.
Mobile	Yes	Yes
Name	Yes	Yes		Client Overview Full Name
Phone	Yes	Yes
Postcode	Yes	Yes		Client Overview Postcode
Sort	Yes	Yes		Client Overview Report/Search Name
State	Yes	Yes		Client Overview State