Field Descriptions

All field columns must be included in the file even if the data is not mandatory.
 -Optional field can be blank
Field Names must be exactly as referenced on this tab and must be on line 1 of the data file
Fields highlighted in GREEN are required data fields
Fields highlighted in Yellow are optional data fields
File type is comma delimited .txt
File naming convention is retailer #_ctr_invoice_mmddyyyy.txt
 - the mmddyyyy is always the current date
 - replace the word "retailer" with the number provided to you by BIW
 
FIELD NAME
COMMENTS
EXAMPLE
MEMBER_ID
Unique Contractor Reward's identifier (Pax ID) of the individual member. No spaces or special characters.
100123456
INVOICE_NUMBER
Invoice number. Used to determine duplicate invoices in conjunction with invoice date and distributor.
A-000578
 INVOICE_DATE
Invoice Date. Used to determine duplicate invoices. Required format: MM/DD/YYYY
8/9/2018
DISTRIBUTOR_NAME
Name of the distributor or retailer
Benjamin Moore Paints
DISTRIBUTOR_ADDR1
Address line 1 for the distributor/retailer location
101 Paragon Drive
DISTRIBUTOR_ADDR2
Address line 2 for the distributor/retailer location
 
DISTRIBUTOR_CITY
City for the distributor/retailer location
Montvale
DISTRIBUTOR_STATE
State for the distributor/retailer location. 2 digit abbreviation
NJ
DISTRIBUTOR_ZIP_CODE
Zip Code for the distributor/retailer location using US or Canadian zip code format.
12345
DISTRIBUTOR_PRODUCT_ID
The identifier the distributor (retailer) uses for the product. The SKU used at POS.
01473X004
BRAND_NAME
Brand name for the product
 
PRODUCT_DESCRIPTION
Product description as appears on a receipt or invoice
QT 01473X GRAND ENTRANCE SAT
PRODUCT_SKU
The Manufacturer Product SKU or a unique identifier of the product --- The Benjamin Moore product code
01473X004
PACK
Number of units with a packaged product. Lowest quantity in which a customer can purchase.
1
SIZE
Size of the product
 
UNIT_OF_MEASURE
Unit of measure. A standard unit of measure is EACH. Other measurements include GAL, PT, QT, FT, IN, etc.
Quart
QUANTITY
Positive whole number. Negative numbers, fractions, or decimals are not accepted.
2
UNIT_PRICE
Unit Price for one individual product. Not summarized by quantity.
46.99
UPC
UPC for the individual product. 12 digit numeric only code with no spaces or special characters.
023906062095
RETAILER_ID
Retailer ID (MOR Number) as specified by Benjamin Moore
10002345
RETAILER_NAME
Name of the distributor or retailer
BM Headquarters
 LOCATION_ID
Outlet ID as specified by Benjamin Moore
10006789