MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Distribution > Electronic Data Interchange > Key Concepts and Procedures > EDI Data Setup > Reference File Categories

Reference File Categories

 

Certain Reference File categories should be considered before you begin Electronic Data Interchange processing.  Below is a list which highlights the important processing parameters on specific category records.  For more detailed information on each Reference File category, see the Common Features Reference File Categories Manual.  You can also check the EDI Transactions key concept of this manual for a more detailed discussion of each category's processing impact.

 

Category Number


Category Description and Important Fields

005

Unit of Measure Codes - This category contains information for unit of measure codes processed by the system.  The Translated Unit of Measure field is used to translate the unit of measure code for EDI transmitted documents.

007

Country Codes - This category contains information for all countries to be processed by the system.  Information entered in this category determines the processing policy regarding shipping information generated for customs officials.

012

Applications Installed - This category identifies which MAC-PAC modules have been installed on your system.

029

Customer Defaults - This category allows you to define default values that will be used when you create a new customer in the Customer Master Maintenance conversation.  This category maintains the default release code for several documents.  In order to process EDI transactions asynchronously, these values should be "I" (immediate).

402

Sales Order Hold Codes - This category defines various reasons that an order can be placed on hold.  If you want to review incoming EDI transactions, you can use code "I" (EDI Order hold).  If you want to place EDI orders on hold when the customer price does not match the MAC-PAC price, you can use code "P" (EDI Price hold).

410

Order Processing Comment and Message Print Codes - This category identifies where sales order comments can be printed and which comments will "transfer" to other related computer integrated distribution documents.  In order for comments to be carried over, the Requisition Print Code must be "1" (print on requisition).

412, 413

Order Processing System Defaults - These categories establish policy guidelines for Order Processing transactions.  Especially important is the overreservation flag on category 412.  This flag needs to be set to N (no), otherwise the item will not be backordered and you will be unable to source orders from a remote site automatically.

450

Shipment Type - This category defines valid codes that identify the kind of shipment being processed.  Valid values are: W (warehouse ship), D (direct ship) and C (used for quote order lines to defer the decision until the quote is converted into a sales order).

491, 492

Purchasing System Defaults - These categories establish policy guidelines for Purchasing transactions.  Direct distribution processes require that the requisition and receipt number assignment options must be set to auto or both.

G60

EDI Defaults - This category contains default information used for electronic data interchange.  This category is required if any computer integrated distribution transactions use EDI functionality.  It also maintains tolerance percentages used for Purchase Order Acknowledgment and Receipt variance calculations.

G61

Document Formats - This category establishes valid print default preferences for computer integrated distribution documents.  Valid options are paper, electronic, both, or neither.

G62

Sales Order Acknowledgment Release Codes - This category defines the printing options for sales order acknowledgments (which determines when the transactions will be processed).  To process these EDI transactions asynchronously, this value should be "I" (immediate).

G63

Bill of Lading Release Codes - This category determines the printing options for BOLs (which determines when the transactions will be processed).  To process these EDI transactions asynchronously, this value should be "I" (immediate).

G89

Part Validation Sequence - This category defines the part validation sequence code based on the internal part, customer part, UPC code, and alternate part.  The part is validated according to the sequence defined for these four fields.