Versions Compared

Version Old Version 3 New Version Current
Changes made by

Matthew Garrett

Matthew Garrett

Saved on

Key

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

Insert excerpt
FWINT HEAD
FWINT HEAD
nopaneltrue

Return to Databuild Land Integration

Article Index

Table of Contents

Integrated Fields

The integration of Databuild Land to Framework ECM is of Databuild Land to Framework ECM is fully customisable via the integration mapping database.

 Dbo.Jobs

Databuild Database Field Name

Databuild Field Label

Create

Update

Framework Database Field Name

Framework Field Label

AnyQuantities


Yes


Fixed Value: 0


GST


Yes


Fixed Value: 0


Job_No


Yes


Special #6: Framework Land (prefixed with an 'L')


JobPostCode


Yes

Yes

Special #15: fwork s_job_postcode


LiveOrders


Yes


Fixed Value: 0


LockBudgets


Yes


Fixed Value: 0


PreventBill


Yes


Fixed Value: 0


PreventPosting


Yes


Fixed Value: 0


Site_Address


Yes

Yes

Special #5: lot num, street num, street name suburbName, stateName


Database Models

The following database model(s) displays the manner in which data is integrated between the third party application and Framework and Framework Integration.Image Removed

...


Integration Process

The following information is a low level account of the integration process including criteria, decisions, and outcomes. This information is technical in nature and is provided "as-is" for a detailed analysis of the integration process for system administrators.

  1. Get eligible Framework jobs using v_FWINT_Land where

    1. land.s_link_accts <> ‘N/A’

    2. and apply Criteria Method criteria where CriteriaMethod is

    3. 1 – Single Region Division

    4. land.l_context_id = ‘CriteriaMethodID’

    5. 2 – Single Land

    6. land.l_land_id = ‘CriteriaMethodID’

    7. 3 – Single Team

    8. land.l_team_id = ‘CriteriaMethodID’

    9. 4 – All Land

    10. land.l_land_id <> 0

    11. 5 – Accounts Entity

    12. land.l_accounts_e_id = ‘CriteriaMethodID’

  2. For each Framework Job search for the job in Databuild table jobs where

    1. 'L' land.l_land_id = Jobs.job_no else

    2. Jobs.job_no = land.s_link_accts

  3. If the land is found in databuild then

    1. The matching land record is retrieved from land

    2. If the records above are retrieved successfully we update the databuild job.

  4. If the job is not found in databuild then

    1. If the land.s_link_accts field is empty we create the job in databuild.

    2. The framework land.l_land_id value is checked. It must be <= 6 characters for us to be able to create the record. This is because we add an L to the front of Land PKID.

    3. We retrieve a link to the jobs table so we can add the new job

    4. If the table is accessed successfully then we create the databuild job.