| | 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
|
