 | ||||
|---|---|---|---|---|
ECM Usage | ECM FAQ | ECM Best Practice | ECM Technical Resources | ECM Release Information |
Return to Framework Resource Centre | ||||
Article Index
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 | |
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  |
