 |
Catalog Standars
Despite the usual requirements to manage catalogs there are some specific standards for CEMEX´s Catalogs:
∙ Catalog´s Name
The Catalog´s file name should follow the next convention:
“BusinessName_BusinessType_SupplierName_AgreementNumber”
Where:
“BusinessType” would be the business type. The possible options are:
- PLAN Cement Plant
- READYMIX Ready mix Plant
“BusinessName” would be the name of the plant.
“SupplierName” would be the name of the supplier.
“AgreementNumber” would be the specific CEMEX´s agreement number for all the products included in the catalog.
If the company has several agreements with CEMEX every one should be loaded as a different catalog. The supplier may decide if one agreement will be loaded in just one catalog or in several catalogs, but he should never include different agreements in one catalog.
Some examples of complaining catalog file names are:
BALCONES_PLAN_GRAINGER_124589
COLORADO_READYMIX_GRAINGER_ 490193
∙ CIF FILES
-
CIF Catalogs must be version 3.0:
CIF_I_V3.0
- A CIF file header may be created using several header key names. Usually those key names are optional but CEMEX ask their suppliers to use some of them as required. The table below enlists all the keys recognized by the CIF parser in the header of a CIF 3.0 file and establish the CEMEX´s standards for each of them.
| HEADER KEY NAME |
STANDARD |
TYPE |
SYNTAX |
EXAMPLE |
| CURRENCY |
Optional |
String |
Default currency for interpreting prices in this file. Must match an ISO currency name.Every catalog should have just one currency associated to it. |
USD |
| CHARSET |
Required |
String |
Specifies the ISO Character set used in this file. The valid value for CEMEX Catalogs is 8859_1. |
8859_1 |
| CODEFORMAT |
Required |
String |
Specifies the default commodity code format, which is always SPSC. |
SPSC |
| COMMENTS |
Optional |
String |
Arbitrary text. |
CEMEX catalog |
| DUNS |
Required |
Boolean |
Indicates whether the supplier ID is a DUNS number. For CEMEX Catalogs must be TRUE. |
TRUE |
| FIELDNAMES |
Required |
String |
This attribute names the columns that will appear in the file. The default is the required 12 columns. If the file contains any optional column they can appear in any order but must be named here. |
Supplier ID,
Supplier Part ID,
Manufacturer Part ID,
Item Description,
SPSC Code,
Unit Price,
Unit of Measure,
Lead Time,
Manufacturer Name,
Supplier URL,
Manufacturer URL,
Market Price,
Parametric Data,
Parametric Name,
Territory Available. |
| ITEMCOUNT |
Required |
Integer |
Number of items in the file. |
38 |
| LOADMODE |
Optional |
Char |
F or I. F stands for Full. I stands for Incremental. CIF 3.0 is incremental by default but CEMEX´s standards will be full. |
F |
| SUPPLIERID_DOMAIN |
Required |
String |
Specifies the domain for supplier ID used in this file. For CEMEX Catalogs must be DUNS. |
DUNS |
| TIMESTAMP |
Optional |
Date |
YYYY-MM-DD, where the time is in 24 hour military time. |
1/26/1999 |
| UNUOM |
Required |
Boolean |
Indicates whether this file uses UNUOM. For CEMEX´s Catalogs must be TRUE. |
TRUE |
- The keys that can appear in the body of a CIF file are 22. The first twelve are required by the CIF3.0 format but some of them may appear empty, those columns are designated in the following table like “required column”. Other keys are required by CEMEX´s. All the possible keys and their standards are shown below:
| HEADER KEY NAME |
STANDARD |
TYPE |
SYNTAX |
EXAMPLE |
| Supplier ID |
Required |
String |
Supplier ID must be the Supplier´s Duns Number, in case of test catalogs the number must be follow by a -t . |
12345678,
12345678-t |
| Supplier Part ID |
Required |
String |
|
|
| Manufacturer Part ID |
Required Column |
String |
May appear empty |
|
| Item Description |
Required |
String |
Maximum length 2000 characters written in Lower and Upper case. |
White chalkboard |
| SPSC Code |
Required |
String |
This code is a combination of a Language Code plus the UNSPSC Code until the third pair. Language Code may be S for Spanish and E for English. |
S504599 |
| Unit Price |
Required |
Double |
Accepts just two decimals. |
8897.09 |
| Unit of Measure |
Required |
String |
Should complain with the ANSI codes and the accepted codes for CEMEX, see note below. |
EA |
| Lead Time |
Required |
Integer |
Represents a number of days. The specials value 999 means “unknown”, but it is highly recommended to use a specific number of days. |
3 |
| Manufacturer Name |
Required Column |
String |
May appear empty. |
|
| Supplier URL |
Required Column |
String |
May appear empty. |
|
| Manufacturer URL |
Required Column |
String |
May appear empty. |
|
| Market Price |
Required Column |
Double |
Accepts just two decimals. May appear empty. |
8900.56 |
| Currency |
Required by CEMEX |
String |
ISO Currency Codes. Codes should also complain with the accepted codes for CEMEX, see note below. |
MX |
| Expiration Date |
Optional |
Date |
YYYY-MM-DD |
9/25/2000 |
| Effective Date |
Optional |
Date |
This field is information only. |
8/13/2000 |
| Commodity Codes |
Optional |
String |
|
|
| Parametric Data |
|
String |
Three fields must be specified: JDEpartID, AgreementNumber, RepositionMethod |
{JDEpartID=57541;
Agreement=18;
Reposition=1} |
| Parametric Name |
|
String |
Standardaized name for the convination of fields in the parametric data. |
JDECodes |
| PunchOut Enabled |
Optional |
Boolean |
True, false |
FALSE |
| Territory Available |
|
String |
Comma-separated list of one or more ISO country codes. The codes must also match one of the accepted by CEMEX, see note below. |
MX,USA |
| Supplier Part Auxiliary ID |
|
String |
The Supplier Part ID will be the agreement number. |
30000018 |
| Delete |
Optional |
Boolean |
True, false |
FALSE |
Notes:
-
The fields:
- Unit of measure.
- Currency codes.
- Territory available.
Should complain with the universal standard codes specified for each and the list of codes used by CEMEX.
-
Parametric Data must contain the following fields for every content row:
- CEMEX´s Part ID if it is a stock item. Non-stock items don´t have a CEMEX´s Part ID.
- Agreement Number.
- Reposition Method. The reposition Method may be 1 or 3, one for those items that can only be bought by people from warehouse and three for those items that can be bought for every body.
- The supplier should not add information in the parametric data unless he has agreed to do so with the CEMEX Negotiator and CEMEX Catalog Manager.
|
|
|