Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
FWINT RHEAD
FWINT RHEAD
nopaneltrue

Article Index

Table of Contents

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

Image Removed
Image Added

Yes

Yes


Uses the Integration Profile Value for the key dbuild_CostCentreGroupCode.

ContractGST

Image Removed
Image Added

Yes

Yes


Document / B. Contract

Building Contract Amount (GST)

 

Image Removed

Image Added

ContractPrice

Image Removed
Image Added

Yes

Yes


Document / B. Contract

Building Contract Amount (ex GST)

Image Removed
Image Added

ContractType

No

No


(AUS  = 4)

Debtor

Image Removed
Image Added

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

Image Removed
Image Added


Yes

Yes


Client Overview

Full Name

Image Removed
Image Added

EndDate

Image Removed
Image Added

Yes

Yes


Construction Overview

Revised Completion Date

Image Removed
Image Added

Estimator

Image Removed
Image Added

Yes

Yes


Administration / Ordering

Ordering Estimator

Image Removed
Image Added

Forecast

Image Removed
Image Added

Yes

Yes


Document / B. Contract

Building Contract Amount (ex GST)

Image Removed
Image Added

GST

Yes

No

Tick (Value = 1)

N/A

Job_No

Image Removed
Image Added

Yes

No


Client / Job Overvierw

Job Number shortened to 8 characters.

Image Removed
Image Added

JobPostCode

Image Removed
Image Added

Yes

Yes


Land Overview

Postcode

Image Removed
Image Added

LiveOrders

Image Removed
Image Added

Yes

No

Value = 0


LockBudgets

Image Removed
Image Added

Yes

No

Value = 0


Salesperson

Image Removed
Image Added

Yes

Yes


Pre-Admin Overview

Primary Salesperson

Image Removed
Image Added

ScheduleProfile

Image Removed
Image Added

Yes

Yes


Client Job Overview

House Type

Image Removed
Image Added

Site_Address

Image Removed
Image Added

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.

Image Removed
Image Added

SiteState

Image Removed
Image Added

Yes

Yes


Land Overview

State

Image Removed
Image Added

SiteStreet

Image Removed
Image Added

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.

Image Removed
Image Added

SiteSuburb

Image Removed
Image Added

Yes

Yes


Land Overview

Suburb

Image Removed
Image Added

StartDate

Image Removed
Image Added

Yes

Yes


Construction Overview

Site Start Actual

Image Removed
Image Added

Supervisor

Image Removed
Image Added

Yes

Yes


Construction Overview

Supervisor

Image Removed
Image Added



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.

Image Removed
Image Added

City

Yes

Yes


Client Overview

Suburb

Image Removed
Image Added

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

Image Removed
Image Added

Dear

Yes

Yes


Client Overview

Salutation

Image Removed
Image Added

Debtor

Yes

No

Value = 1


Email

Yes

Yes

Image Removed


Image Added

Fax

Yes

Yes

Image Removed


Image Added

Group

Yes

Yes


Uses the Integration Profile Value for the key dbuild_ContactGroupCode.

Mobile

Yes

Yes

Image Removed


Image Added

Name

Yes

Yes


Client Overview

Full Name

Image Removed
Image Added

Phone

Yes

Yes

Image Removed


Image Added

Postcode

Yes

Yes


Client Overview

Postcode

Image Removed
Image Added

Sort

Yes

Yes


Client Overview

Report/Search Name

Image Removed
Image Added

State

Yes

Yes


Client Overview

State

Image Removed
Image Added

Image Removed

...