McWilliams
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. Interfaces | Product, Pricing, Marketing & Promotions
      3. McWilliams

      1 | McWilliams Import Specifications

      This article covers the custom import for McWilliams Product and Price Import Specification.

      This article covers the custom import for McWilliams Product and Price Import Specification.


      McWilliams Custom Report

      • There is a custom import written for McWilliams Wines
      • There are two files that get imported, these are called BEpozPrd.txt for Product Import and BEpozPrc.txt for Price Import 
        BEpozPrd.txt

       

       

      Field Name

      Format

      Description

      A

      		 Barcode Number Numeric  

      B

      		 TUN Numeric The Barcode of the Wine Carton

      C

      		 Product Code Numeric  

      D

      		 Product Name Alphanumeric  

      E

      		 Parent Name Alphanumeric  

      F

      		 Product Short Name Alphanumeric  

      G

      		 Product Group Alphanumeric  

      H

      		 Major Qty Unit Alphanumeric This is the Case Size Name e.g. Carton

      I

      		 Major to Basic Conv Numeric  

      J

      		 Basic Qty Unit Alphanumeric  

      K

      		 Basic to Litre Conv Numeric How many Litres in a Unit e.g. 0.75 is 750ml

      L

      		 GST Rate Numeric The GST percentage for the product

      M

      		 Del? Alphanumeric If the product needs to be deleted in BEpoz

      N

      		 Imported Alphanumeric Puts the word Y into Product Export Code 1, used to clean database

      BepozPrc.tct

       

       

      Field Name

      Format

      Description

      A

      		 Client Key Numeric This is the key set in the Venue record Site Code to distinguish what Venue the price belongs to

      B

      		 Product Numeric This is the McWilliams product Number

      C

      		 SINGLE BOTTLE Numeric This is the Single Bottle Price

      D

      		 FULL CARTON Numeric This is the Full Carton Price

      E

      		 MIXED CASE Numeric This is the Mixed Case Price

      F

      		 STAFF AND GROW Numeric This is the Staff and Grow Price

      G

      		 COST Numeric This is the Cost Price

      H

      		     Blank Field

      I

      		     Blank Field

      J

      		 GST RATE Numeric The GST percentage for the product