Interface Design Assumptions

·     Future Three will not validate any data on MAC-PAC's database prior to formatting the Forecast Shipments Transaction File (IC140AP1) and the Billing File (IC110AP1) except for the Ship-to customer number.

·     The shipper number sent to MAC-PAC in IC110AP1 is always used as the invoice number in MAC-PAC unless the invoice number has already been used in MAC-PAC.  If the number has already been used, a new number is assigned.  The shipper number is always unique for each shipment.

·     Shipment transactions sent to MAC-PAC on IC140AP1 do not always have an associated billing transaction sent to MAC-PAC on IC110AP1 except when the Billing Update Program (IC110E) is not installed.

·     Billing transactions sent to MAC-PAC on IC110AP1 will not always have associated shipment transactions sent to MAC-PAC on IC140AP1.  This may be true for an entire invoice or for an invoice line item.

·     Shipment transactions sent to MAC-PAC are never formatted in IC140AP1 after their associated billing transactions are formatted in IC110AP1.

·     The sequence number on a billing transaction on IC110AP1 is always the same sequence number as the one formatted on the associated shipment transaction on IC140AP1.

·     The customer purchase order number and total invoice amount are not passed to MAC-PAC from Future Three.

·     The Customer Reference Number field on MAC-PAC's Projected Demand File and the Sold-to Customer Number field on Future Three's database must always be formatted in the same manner.

·     Future Three handles demand quantities on MAC-PAC's Projected Demand file in daily, weekly, and monthly buckets.  The start date for each of these amounts is the first workday in each week (an exception to this is when Future Three passes MAC-PAC JIT demand quantities for the current week when today is not the first workday of the week.  In this case, Future Three formats the start date of that period with today's date).

·     Demand from Future Three should be passed to MAC-PAC's Projected Demand File (MS150M) immediately prior to tentative schedule generations and Master Scheduling rollovers in MAC-PAC in order for the MAC-PAC programs to adequately plan production for the Future Three demand.

·     Week start dates in Future Three's calendar and MAC-PAC's shop calendar should be set up to be the same.