Interface Restrictions

·     All quantity and price amounts sent to MAC-PAC from Future Three are in stockkeeping units of measure (per piece units).

·     Configured and lot assigned items are not handled by the Future Three/MAC-PAC interface.

·     All shipment and billing transactions for a shipper number must always have the same company and location associated with them if MAC-PAC's currency level processing flag on Reference File category 133 is equal to L (location).

·     Users are required to set up and maintain two customer files when processing at a location currency level.  Users will be responsible to ensure that the data on both files is in sync.

·     No value added tax processing is currently allowed in the Future Three interface.

·     All customer information related to interface transactions (except for the Ship-to address) defaults from the MAC-PAC customer files.  All shipments to the customer are made in the currency defined for that customer on the Customer Master File.

·     Inventory updates related to shipments are allowed to one MAC-PAC inventory balance type and are done using one MAC-PAC inventory adjustment code.  The default balance type and adjustment code are stored on Reference File category D26, Future Three Interface Defaults.  The adjustment code must be for an adjustment type of shipment and must have an inventory reduction flag equal to Y.

·     One MAC-PAC shop calendar can be used by MAC-PAC interface clients for formatting Future Three demand on the Projected Demand File (MS150M).  The shop calendar code associated with that shop calendar is stored on Reference File category D26, Future Three Interface Defaults.

·     One demand type code is allowed for each of the four different types of demand sent to MAC-PAC from Future Three.  These four demand types should not be used to store demand other than Future Three demand.

·     Non-standard, bundled, planning and non-stocked part types are not handled by the interface .

·     All parts handled by the Future Three interface can be forecasted in daily, weekly, and monthly buckets.

·     Invoices entered in invoice entry in MAC-PAC's Accounts Receivable module for billing transactions with validation errors will not update sales history amounts used by MAC-PAC's Sales Analysis module.

·     Inventory adjustments entered in MAC-PAC's Inventory Control module for forecast shipment transactions with validation errors will not update ship quantities on the Projected Demand File (MS150M) in MAC-PAC.

·     Several field size restrictions apply to the interface:

a.   MAC-PAC's Company Number field is three bytes alphanumeric and Future Three's is two bytes numeric.  In order to use the interface, users are restricted in MAC-PAC to two-byte, left-justified, numeric company numbers.

b.   MAC-PAC's warehouse code is three bytes alphanumeric and Future Three's is two bytes alphanumeric.  In order to use the interface, users are restricted in MAC-PAC to two-byte, alphanumeric, left-justified warehouse codes.

c.   MAC-PAC's Ship-to customer number is determined by one (eleven byte alphanumeric) field.  Future Three's Ship-to customer number is one field (nine bytes numeric).  In order to use the interface, customer numbers in MAC-PAC must be restricted to an exactly nine-byte, left-justified numeric field.  Future Three's Ship-to customer number is formatted with the nine-byte customer number from MAC-PAC.

d.   MAC-PAC's Bill-to Customer field is one (eleven byte alphanumeric) field.  Future Three's Sold-to/Bill-to Customer Number field is nine bytes numeric.  This field is restricted to include the nine right-most bytes in the MAC-PAC Bill-to customer number, right-justified.

e.   MAC-PAC's address lines are 30 bytes alphanumeric and Future Three's are 24 bytes alphanumeric.  In order to use the interface, address line fields in MAC-PAC must be restricted to 24-byte alphanumeric  fields.

f.    MAC-PAC's Unit Price field is 14,3 numeric and Future Three's is 9,5 numeric.  In order to use the interface, users are restricted in MAC-PAC and in Future Three to 9,3 numeric unit price fields.

g.   MAC-PAC's Lot Number field is twelve bytes alphanumeric and Future Three's is ten bytes alphanumeric.  In order to use the interface, address lot number fields in MAC-PAC must be restricted to ten-byte alphanumeric fields.

h.   MAC-PAC's Customer Part Number field is 25 bytes alphanumeric and Future Three's is 30 bytes alphanumeric.  In order to use the interface, users are restricted in Future Three to 25-byte alphanumeric customer part number fields if and only if users wish to ensure that the customer part number in MAC-PAC is exactly in sync with the customer part number in Future Three.

i.    MAC-PAC's Ship Quantity field is 11,3 numeric and Future Three's is 8,0 numeric.  In order to use the interface, users are restricted in MAC-PAC to 8,0 numeric ship quantities.

j.          If the Process Non-Release flag on Reference File category D26 has a value of N, then an account assignment record with a blank product class must be set up on Reference File category 302.  This sales account is used for billing the non-inventoried part.