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 |