Integrated Fields

The integration of Octal8 BizPrac Purchase Orders to Framework is fixed in the content that is exchanged between the systems. There are no user-configurable integrated fields available to this type of integration.

Database Models

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

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. Read profile keys to determine which actions to process.
2. Process Entities
   1. Read all eligible records from Framework table int_entity where
      1. Int_entity.l_link_sys_gl_id = -2272 (BizPrac)
      2. Int_entity.l_int_entity_id <> 0
   2. For each record get matching BizPrac record in table 'file17' where
      1. file17.supplier_code = int_entity.s_link_entity
   3. Update the int_entity.s_link_name with supplier.sub_name
   4. In the linked entity record we update (if different)
      1. Name
      2. ABN
      3. ACN
      4. Update the primary/postal address
      5. BH
      6. Fax
      7. Mobile
3. Process Orders
   1. Get eligible Framework jobs from v_sched_dbJobOrders where
      1. Job.s_link_boq <> ‘N/A’
      2. Job.l_context_id = ‘Context’ (profile key, if 0 all contexts)
      3. and apply order criteria where OrderCriteria is
      4. 2 – Construction Manager • Cst.l_mgr_e_id = ‘OrderCriteriaID’
      5. 3 – Supervsor • Cst.l_super_e_id = ‘OrderCriteriaID’
      6. 4 – Single Job • job.s_job_num = ‘OrderCriteriaID’
   2. For each job get orders and items from BizPrac where
      1. file30.job_no = job.s_job_num
   3. Once we have the BizPrac Order, see if it exists in po_order table where
      1. Po_order.s_jobNo = job.s_job_num
      2. Po_order.s_link_boq = file30.order_code
   4. And we check each BizPrac Order Item, by seeing if it exists in po_item table where
      1. Po_item.s_link_item = poDetail.poDetail_id
      2. Po_item.l_po_order_id = po_order.l_po_order_id