Filetype Excel XLSX | Posted on 27 Jun 2022 | 3 years ago
Authentication
digital resources
199x Filetype XLSX File size 0.04 MB Source: www.tn.gov
Sheet 1: Item Request Form
| Action (A=Add) (U=Update) | Edison Item ID (10 digits, required for item update) | Long Item Description (No more than 254 characters. For Inventory items, all pertinent information should be within the first 60 characters) | Standard UOM (see UOM Tab or follow Link) | Supplier ID | Supplier Item ID (If a supplier ID is noted in Column E, this field is required) | Active Edison Contract ID (if applicable, 25 digits) | Minimum Order Quantity | Ordering UOM (see UOM Tab or follow Link) | Ordering Price (Must be in text format, No $ signs, no more than 2 decimal places) | Ordering UOM Conversion (Almost always will be 1) | Manufacturer ID | Manufacturer Part # | UNSPSC Code | CheckSum |
| A | ***THIS IS A SAMPLE LINE. *** Item Description. Do Not Include Model Numbers, Brand Names or Specifications. (See Instructions tab for examples). | EA | 0000000499 | IN12345 | 0000000000000000000012345 | 1 | EA | 12.52 | 1 | (leave blank if you don't have) | (leave blank if you don't have) | 12345678 | 1 |
| Blue and Orange Lines indicate that the corresponding column is hidden. Orange indicates fields that should always be left blank. Blue indicates fields that may be left blank at users' discretion. Please do not delete any of the hidden the columns from the Item Request Form tab. | ||||
| *** Please note: All requests for "Green" or Energy Efficient item coding should be included in your email with this form attached. Please refer to the Energy Efficient Purchasing Guide at https://www.teamtn.gov/cpo/resources/energy-efficient-purchasing-guide.html for more information. | ||||
| PeopleSoft Field Name | Column | Field Label | Requirement | Explanation/Instructions |
| ACTION | A | Action | Required | Action: A = Add U = Update |
| INV_ITM_ID | B | Edison Item ID | Edison* | Edison Item ID, Sequentially Assigned by the Edison System. *Required for Update requests |
| DESCR254 | C | Long Item Description (254) | Required | This item description can be up to 254 characters. I should not include item numbers, brand names, or model names. The Inventory Module will only present the first 60 characters, so pertinent information that differentiates items (such as sizes, colors, etc) should be noted inside the first 60 characters. Descriptions should be clear, concise and as short as possible. General format examples: "Printer, Multi-Function Color Laser" "Shirt, Polo, XXL, Gray" "Chips, Potato, Sour Cream and Onion, 1.25 oz bag, 20 BG/PH, 10 PH/CA" |
| UNIT_MEASURE_STD | D | Standard UOM (Lowest) | Required | This will be the basic, lowest unit of measure that makes sense for the item. Please see the UOM tab for a complete list with descriptions. |
| VENDOR_ID | E | Supplier ID | Required* | This is the Edison Supplier ID. * Note: Required only if a Supplier item ID is being entered. If creating item(s) for sourcing event where Supplier is unknown, the field may be left blank. |
| Supplier Name | F | Supplier Name | Optional | This is the name of the supplier |
| ITM_ID_VNDR | G | Supplier Item ID | Required | Supplier Part identifier or SKU #. The values in this field must be unique within each Supplier. (Max 20 characters) |
| PART_EXT | H | Supplier Part # Extension | Leave Blank | Supplier Part # Extension. Part of the unique ID for an item, when combined with Supplier Part #. (Max 50 characters) |
| Contract_ID | I | Active Contract ID | Optional | The Edison contract number. Must be 25 digits; prefacing 0s should be used to ensure correct entry length. |
| QTY_MIN | J | Minimum Order Quantity | Optional | Minimum Order QTY for this item, for the specificed Supplier. Should you need "Decimal Precision" for your item (to order by part of a whole, eg. 1.4 or 0.2), please note this in your request email by requesting "Decimal Precision." |
| ORD_UOM | K | Ordering UOM | Required | Unit of Measure. ANSI standard UOMs are required (eg. EA, BX, etc.). Please see the UOM tab for a complete list with descriptions. This may be equal to STD UOM (standard unit of measure, which is generally the lowest shipping UOM), otherwise it is the CASE or PACK UOM based on the negotiated contract as a derivative or function of the STD UOM. This is the UOM the appears on the PO and is recieved by the supplier |
| ORD_PRICE | L | Ordering Price | Required | Current Effective price of item. The price the supplier charges. Enter numeric values only. DO NOT include currency symbol or decimals beyond the hundredths place (.00, must be set at the nearest whole cent). |
| ORD_CONV_RATE | M | Ordering UOM Conversion | Required | Definition provided by Supplier to describe the Contract Case Pack UOM. Example: (Contract UOM = CA=Case , and CASE is defined as a QTY of 12 of the Standard UOM, or 24, or 36, etc…) This could refer to random weight items. EX: A case could refer to a QTY of 3, 8 to 10 LB hams ( the number of packages in the case, or Case Packs). Actual weight cannot be guarenteed, and thus it is random, but will be between 8 and 10 LB, and must be ordered by a case. |
| ORD_UOM | N | Other UOM-1 | Leave Blank | Unit of Measure. ANSI standard UOMs are required (eg. EA, BX, etc.) (Max. 3 characters) This CAN be equal to STD UOM (standard unit of measure, which is generally the lowest shipping UOM), otherwise it is the CASE or PACK UOM based on the negotiated contract as a derivative or function of the STD UOM. This is the UOM the appears on the PO and is recieved by the supplier |
| ORD_PRICE | O | Other Price-1 | Leave Blank | Current Effective price of item. The price the supplier charges. Enter numeric values only. DO NOT include currency symbol. (Max. 10.5 Nbr) |
| ORD_CONV_RATE | P | Other UOM Conversion-1 | Leave Blank | Definition provided by Supplier to describe the Contract Case Pack UOM. Example: (Contract UOM = CA=Case , and CASE is defined as a QTY of 12 of the Standard UOM, or 24, or 36, etc…) This could refer to random weight items. EX: A case could refer to a QTY of 3, 8 to 10 LB hams ( the number of packages in the case, or Case Packs). Actual weight cannot be guarenteed, and thus it is random, but will be between 8 and 10 LB, and must be ordered by a case. (Max: 7.8 Sign) |
| PRICE_EFFDT | Q | Price Date | Leave Blank | Effective Date of the price for an item not on contract for the calendar period during which it is avaiable. Format (MM/DD/YY) (Max: Date 10) |
| PO_AVAIL_DT | R | Contract/Catalog Begin Date | Leave Blank | Open For purchase Effective date |
| PO_UNAVAIL_DT | S | Contract/Catalog End Date | Leave Blank | Effective date item is unavailable for puchase |
| MFG ID | T | Manufacturer Name | Optional | Name of the product's manufacturer. (Max. 30 characters) |
| MFR_NAME | U | Manufacturer Name | Optional | |
| MFG_ITM_ID | V | Manufacturer Part # | Optional | Part identifier used by manufacturer. (Max. 20 characters) |
| CATEGORY_CD | W | UNSPSC Code | Required | The combined numeric value that identifies the logical aggregation of the UNSPSC Commodity for analytical purposes. Enter numeric values only. (Max: 8 Nbr) |
| CAT_LEVEL1 | X | UNSPSC Class Description | Leave Blank | The description that identifies the logical aggregation of Class (Max. 30 characters) |
| CAT_LEVEL2 | Y | UNSPSC Item Description | Leave Blank | The description that identifies the commonly recognized Item of inter-related commodity categories (Max. 30 characters) |
| Z | Other Category Code (EX: UNSPSC) | Leave Blank | Used when Supplier does not support UNSPSC | |
| CAT_LEVEL4 | AA | Other Cat Code Description | Leave Blank | |
| LEAD_TIME | AB | Ordering Lead Time | Leave Blank | This represents the number of business days from order placement to delivery of goods. Enter numeric values only. (Max. 3 Nbr) |
| RECYCLE_FLAG | AC | Recycled Content | Leave Blank | Valid values are Y or N. If the product contains recycled content. (Max. 1 Characters) |
| RECY_PRC | AD | Percentage 0 to 100 | Leave Blank | A value from 0 to 100. 0 = No recycled content. 1 through 100 is the percentage that is recycled. |
| HAZ_CLASS_CD | AE | Hazard Code | Leave Blank | A value of Y or Null. Since the Supplier will not know the State's codes, they can indicate that there is a hazard code for this item. It will be up to the content manager to associate the item with an existing code, or nullify the field. |
| FILENAME | AF | Image FileName or URL | Leave Blank | External link to a suppliers product page that might include pictures, detailed descriptions, etc.. (Max 80 characters) Picture size should not exceed 144x144 |
| FILE_EXTENSION | AG | Type of Image | Leave Blank | Identifies the type of image. (Example: JPG, BMP) (Max. 3 characters) |
| NULL not used | AH | NULL not used | Leave Blank | NULL not used |
| Account | AI | Account | Leave Blank | |
| Other Item ID | AJ | Leave Blank | Legacy or other item item for reference | |
| User-1 | AK | Leave Blank | User defined | |
| User-2 | AL | Leave Blank | User defined | |
| User-3 | AM | Leave Blank | User defined | |
| User-4 | AN | Leave Blank | User defined | |
| User-5 | AO | Leave Blank | User defined | |
| Check Sum | AP | Check Sum | Required | Needed for file and record length verification. Always enter "1." |
no reviews yet
Please Login to review.
