ITEMMAST – Item Master
- System
- Inventory Control (IC)
- Prefix
ITE- Primary key
ITEM-GROUP,ITEM- Fields
- 107
- Updated by
- 23 programs
- Referenced by
- 532 programs
ITEMMAST is the Item Master table in Lawson Inventory Control (prefix ITE). It is indexed by ITEM-GROUP, ITEM (ITESET1); alternate indexes: ITESET10, ITESET11, ITESET12, ITESET13, ITESET2, ITESET3, ITESET4, ITESET5 and 4 more. It is related 1:1 to ICGENERIC, HAZARD, ICITEUF, ICMANFCODE, MINORCL, ITEBOD, ITEMGROUP, ICITEMCODE and 2 more and 1:M to ICAUDIT, ICITEMGTIN, ICMXVAL, ITCOMMENT, ITEMSUB, ITEMUPC, ITEMUPN1, ITEMUPN2 and 2 more. It is updated by IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 and 15 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 524 more. The table has 107 fields, 13 indexes and 23 documented relations.
About ITEMMAST
The Item Master file stores static information about each item. Every item has one Item Master record which contains data such as description, classes, units of measure, and weight. This data is shared by all Item Location records for this item.
Fields (107)
Column = COBOL field name without the ITE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ITE-ITEM-GROUP PKITEM_GROUP | Alpha 5 | This field contains the identifier for a group of items that can be shared by one or more companies. | IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-ITEM PKITEM | Alpha 32 | This field contains the item identifier. | IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the first line of the description. | IC10.2, IC11.1, IC270, IC330, IC811, PO150, PO25.6, PO25.7 +16 more |
ITE-DESCRIPTION2DESCRIPTION2 | Alpha 30 (Lower Case) | This field contains the second line of the description. | IC10.2, IC11.1, IC270, IC330, IC811, PO150, PO25.6, PO25.7 +9 more |
ITE-STOCK-UOMSTOCK_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | IC10.2, IC11.1, IC243, IC811, PO150, PO25.6, PO25.7, PO26.4 +8 more |
ITE-SEC-UOMSEC_UOM | Alpha 4 | This field contains the secondary quantity unit of measure. | IC11.1, IC330, IC811 |
ITE-SEC-UOM-MULTSEC_UOM_MULT | Signed 13.7 | This field contains the multiplier for the secondary quantity unit of measure. It is used to convert the stock-on-hand quantity to the secondary quantity or visa versa. This field is calculated using the secondary conversion factor. | IC11.1, IC811 |
ITE-SEC-UOM-CONVSEC_UOM_CONV | Signed 10.5 | This field contains the secondary unit of measure conversion factor. | IC11.1, IC811 |
ITE-CTW-CODECTW_CODE | Alpha 1 | This field indicates whether this item is a catch weight item. A catch weight item tracks two quantities with two different units of measure. The first quantity is the stock quantity (for catch weights this would be pounds). The second quantity is the secondary quantity (for example, case). This field controls when both quantities are entered.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +6 more |
ITE-CTW-VAR-PCTCTW_VAR_PCT | Signed 5.2 | This field contains the catch weight variance percent. It is used to give a warning message if the stock and secondary quantities on a catch weight transaction are outside this variance percent. | IC10.2, IC11.1, IC330, IC811 |
ITE-GENERICGENERIC | Alpha 10 | This field contains a user-defined general name for an item, used for searching for an item. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-FREIGHT-CLASSFREIGHT_CLASS | Alpha 4 | This field contains the user-defined freight classification code. The Warehouse system uses freight classes for bill of lading processing. | IC10.2, IC11.1, IC330, IC811 |
ITE-PURCH-MAJCLPURCH_MAJCL | Alpha 4 | This field contains the user-defined major purchasing class identifier. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-PURCH-MINCLPURCH_MINCL | Alpha 4 | This field contains the user-defined minor purchasing class identifier. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-INVEN-MAJCLINVEN_MAJCL | Alpha 4 | This field contains the user-defined major inventory class code. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-INVEN-MINCLINVEN_MINCL | Alpha 4 | The user-defined minor inventory class code within the major class. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-SALES-MAJCLSALES_MAJCL | Alpha 4 | This field contains the sales major class code. | IC10.2, IC11.1, IC330, IC811 |
ITE-SALES-MINCLSALES_MINCL | Alpha 4 | This field contains the sales minor class code within the major class. | IC10.2, IC11.1, IC330, IC811 |
ITE-MANUF-CODEMANUF_CODE | Alpha 4 | This field contains a user-defined code that indicates the manufacturer of an item. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-MANUF-DIVISIONMANUF_DIVISION | Alpha 4 | This is a user defined code that indicates which division of a manufacturer is tied to an item. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-MANUF-NBRMANUF_NBR | Alpha 35 | This is the identifier that the manufacturer has assigned to an item. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-HAZARD-CODEHAZARD_CODE | Alpha 8 | This field contains a short code describing why an item can be hazardous. | IC10.2, IC11.1, IC330, IC811 |
ITE-PURCH-TAX-FLPURCH_TAX_FL | Alpha 1 | This flag specifies if this item is taxable when it is purchased. It defaults to No (nontaxable). The value Yes indicates taxable. " " = Default to Next Level
| IC10.2, IC11.1, IC330, IC811 |
ITE-PURCH-TAX-CDPURCH_TAX_CD | Alpha 10 | This code is used to determine if this item is taxable when purchased and to extract tax data from the Tax file based on this tax code. | IC10.2, IC11.1, IC330, IC811 |
ITE-PROD-TAX-CATPROD_TAX_CAT | Alpha 15 | This field contains a classification of items for determining taxes using the VERTEX system in the Order Entry system. | IC10.2, IC11.1, IC330, IC811 |
ITE-HARMONIZE-CDHARMONIZE_CD | Alpha 11 | This field contains the harmonize class code. | — |
ITE-WEIGHTWEIGHT | Signed 9.3 | This field contains the net unit weight of the item based on the stock unit of measure. | IC10.2, IC11.1, IC330, IC811 |
ITE-CUBIC-FEETCUBIC_FEET | Signed 9.3 | This field contains the net unit cubic measure of the item based on the stock unit of measure. | IC10.2, IC11.1, IC330, IC811 |
ITE-NBR-DEC-QTYNBR_DEC_QTY | Numeric 1 | This field contains the number of decimal places that are entered and displayed for the cost field.
| IC10.2, IC11.1, IC330, IC811, PO229, PO32.3, PO63.1, PO67.1 +1 more |
ITE-NBR-DEC-COSTNBR_DEC_COST | Numeric 1 | This field contains the number of decimal places that are entered and displayed for the unit cost field.
| IC10.2, IC11.1, IC330, IC811, PO150, PO229, PO25.6, PO25.7 +5 more |
ITE-NBR-DEC-PRICENBR_DEC_PRICE | Numeric 1 | This field contains the number of decimal places that are entered and displayed for the unit cost field.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-LOT-TRACK-FLLOT_TRACK_FL | Alpha 1 | This field contains the lot tracking field which indicates whether the item is tracked by a lot/sublot number.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-SER-TRACK-FLSER_TRACK_FL | Alpha 1 | This field determines if the item is to be tracked by a serial number.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-CERT-REQ-FLCERT_REQ_FL | Alpha 1 | This field indicates whether a certification is required when this item is purchased.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-KIT-ITEM-FLKIT_ITEM_FL | Alpha 1 | This field indicates whether a kit has been set up for this item.
| IC10.2, IC11.1, IC330, IC60.1, IC62.1, IC62.4, IC811 |
ITE-BRKN-CS-CHRGBRKN_CS_CHRG | Alpha 1 | This flag determines if there is a charge to break up a case to satisfy an order in the Order Entry system.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-REPLACE-ITEMREPLACE_ITEM | Alpha 32 | This field contains a valid item number designated as a replacement for this item. | IC10.2, IC11.1, IC330, IC811 |
ITE-USER-FIELD1USER_FIELD1 | Alpha 30 | This is the first user-defined field. Set up the title of this field in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-USER-FIELD2USER_FIELD2 | Alpha 30 | This is the second user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-USER-FIELD3USER_FIELD3 | Alpha 30 | This is the third user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-USER-FIELD4USER_FIELD4 | Alpha 30 | This is the fourth user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-USER-FIELD5USER_FIELD5 | Alpha 30 | This is the fifth user-defined field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-USER-FIELD-N1USER_FIELD_N1 | Signed 18.5 | This is the first user-defined numeric field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-USER-FIELD-N2USER_FIELD_N2 | Signed 18.5 | This is the second user-defined numeric field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-USER-FIELD-N3USER_FIELD_N3 | Signed 18.5 | This is the third user-defined numeric field. It can contain any data the user wants. The title of this field is set up in Corporate Item Group (IC00.1). | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-SEQSEQ | Numeric 3 | This field contains the last sequence number used for the item comments added in IC18.1 (Item Comments) for this item. | IC10.2, IC11.1, IC18.1, IC811 |
ITE-ADDED-DATEADDED_DATE | Numeric 8 (yyyymmdd) | This field contains the date the Item Master record was originally added in IC11.1 (Item Master) or IC10.1 (Formats). The field defaults to the system date when the record is added. | IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-MSDS-FLAGMSDS_FLAG | Alpha 1 | This field indicates whether this item requires a Material Safety Data Sheet.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-ACTIVE-STATUSACTIVE_STATUS | Alpha 1 | This status flag indicates whether this item is active or inactive. If inactive, no transactions can be entered using this item, but transactions that are in process can be completed.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-ALT-UOMALT_UOM | Alpha 4 Occurs 10 Times ×10 | This field contains the alternate unit of measure for this item. | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-ALT-UOM-CONVALT_UOM_CONV | Signed 10.5 Occurs 10 Times ×10 | This field contains the conversion factor from the alternate unit of measure to the stock unit of measure. | IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-ALT-UOM-MULTALT_UOM_MULT | Signed 13.7 Occurs 10 Times ×10 | This field contains the multiplier for converting an alternate unit of measure to the stock unit of measure. It is calculated by IC11.1 (Item Master) based on the conversion factor and the relationship between the stock and alternate units of measure. | IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-TRACKING-FLTRACKING_FL | Alpha 1 Occurs 10 Times ×10 | This field indicates whether quantities are tracked by this alternate unit of measure.
| IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +4 more |
ITE-TRANS-FLTRANS_FL | Alpha 1 Occurs 10 Times ×10 | This flag indicates whether this alternate unit of measure is valid for inventory transactions. The flag settings consist of the following.
| IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-SELL-FLSELL_FL | Alpha 1 Occurs 10 Times ×10 | This field indicates whether this alternate unit of measure is valid for the sell quantity in the Order Entry system. The flag settings consist of the following.
| IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-SELL-PRICE-FLSELL_PRICE_FL | Alpha 1 Occurs 10 Times ×10 | This field indicates whether this alternate unit of measure is valid for the sell price in the Order Entry system. The flag settings consist of the following.
| IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-BUY-FLBUY_FL | Alpha 1 Occurs 10 Times ×10 | This field indicates whether this alternate unit of measure is valid for the buy quantity in the Purchase Order system. The flag settings consist of the following.
| IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-PACKING-WEIGHTPACKING_WEIGHT | Signed 9.3 Occurs 10 Times ×10 | This field contains the packed weight of an item in the alternate unit of measure. | IC10.2, IC11.1, IC330, IC811 |
ITE-PACKING-CUBICPACKING_CUBIC | Signed 9.3 Occurs 10 Times ×10 | This field contains the cubic measure of the packed alternate unit of measure. | IC10.2, IC11.1, IC330, IC811 |
ITE-USE-IDENTIFIERUSE_IDENTIFIER | Alpha 1 | —
| IC10.2, IC11.1, IC330, IC811 |
ITE-CONSIGNMENT-FLCONSIGNMENT_FL | Alpha 1 | The consignment flag set to Y indicates that this item is not to be counted as part of the owned inventory. It will default to N and will be defaulted to the ITEMLOC record with the same flag.
| IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-UPC-EXISTSUPC_EXISTS | Numeric 1 | This is a flag to indicate that UPC numbers exist for this item.
| ICI4.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more |
ITE-UPN1-EXISTSUPN1_EXISTS | Numeric 1 | This is a flag to indicate that UPN1 numbers exist for this item.
| ICI5.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more |
ITE-UPN2-EXISTSUPN2_EXISTS | Numeric 1 | This is a flag to indicate that UPN2 numbers exist for this item.
| ICI6.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more |
ITE-SKU-EXISTSSKU_EXISTS | Numeric 1 | This is a flag to indicate that SKU numbers exist for this item.
| ICI7.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more |
ITE-NDC-EXISTSNDC_EXISTS | Numeric 1 | This is a flag to indicate that NDC numbers exist for this item.
| ICIC.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 +2 more |
ITE-INSP-REQ-FLINSP_REQ_FL | Alpha 1 | —
| IC10.2, IC330, IC811 |
ITE-ICN-CODEICN_CODE | Alpha 8 | ICN stands for Intrastat Classification Nomenclature. ICN code is a combination of the 2-digit Harmonize System Chapter code, 2-digit Harmonize Heading, 2-digit Harmonize Subheading, and 2-digit combined nomenclature code. The Harmonize System of classification codes is designed to identify items for international trade. The ICN code entered on Item Master (IC11.1) will be validated against the code listing in ICN and Unit of Measure Codes (IN03.1). When a code is added there will also be a check to make sure there is an alternate UOM defined for the item that is associated with the code in Intrastat. | IC10.2, IC11.1, IC330, IC811 |
ITE-ICSEGMENTICSEGMENT | Alpha 2 | — | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-ICFAMILYICFAMILY | Alpha 2 | — | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-ICCLASSICCLASS | Alpha 2 | — | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-ICCOMMODITYICCOMMODITY | Alpha 2 | — | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-ISS-ACCOUNTISS_ACCOUNT | Numeric 6 | This is a default account number for issues to requisitions and purchase orders. This field will eliminate the need to create item location records pertaining to non-stock items for the purpose of defaulting an "issue account number". | IC10.2, IC11.1, IC330, IC811 |
ITE-ISS-SUB-ACCTISS_SUB_ACCT | Numeric 4 | This is the default sub account number for issues. Will be used as a default to issues, requisitions and purchase-orders. Will eliminate the need to create item-location records pertaining to non-stock items for the purpose of defaulting a "issue account number". | IC10.2, IC11.1, IC330, IC811 |
ITE-CAP-TECH-FLAGCAP_TECH_FLAG | Numeric 1 | —
| — |
ITE-IC-OBJ-IDIC_OBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-COMMODITY-CODECOMMODITY_CODE | Alpha 35 | — | IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +2 more |
ITE-ALLOC-UOMALLOC_UOM | Derived | This field is the allocation unit of measure based on whether the item is a catch weight or regular item. | — |
ITE-HAZARD-FLHAZARD_FL | Derived | This field is used to display an "X" if the item is hazardous. | — |
ITE-TRACK-1TRACK_1 | Derived | This field is used to determine if this item is tracked by more than one unit of measure. | — |
ITE-TRACK-2TRACK_2 | Derived | This field is used to determine if this item is tracked by more than one unit of measure. | — |
ITE-TRACK-3TRACK_3 | Derived | This field is used to determine if this item is tracked by more than one unit of measure. | — |
ITE-TRACK-4TRACK_4 | Derived | This field is used to determine if this item is tracked by more than one unit of measure. | — |
ITE-TRACK-5TRACK_5 | Derived | This field is used to determine if this item is tracked by more than one unit of measure. | — |
ITE-TRACK-6TRACK_6 | Derived | This field is used to determine if this item is tracked by more than one unit of measure. | — |
ITE-VALUE-1VALUE_1 | Derived | This field is used to determine if this item is tracked by this unit of measure.
| — |
ITE-VALUE-2VALUE_2 | Derived | This field is used to determine if this item is tracked by this unit of measure.
| — |
ITE-VALUE-3VALUE_3 | Derived | This field is used to determine if this item is tracked by this unit of measure.
| — |
ITE-VALUE-4VALUE_4 | Derived | This field is used to determine if this item is tracked by this unit of measure.
| — |
ITE-VALUE-5VALUE_5 | Derived | This field is used to determine if this item is tracked by this unit of measure.
| — |
ITE-VALUE-6VALUE_6 | Derived | This field is used to determine if this item is tracked by this unit of measure.
| — |
ITE-MULT-UOMSMULT_UOMS | Derived | This field contains the value of the number of units of measure this item is tracked by. | — |
ITE-ITEM-CODE-USEDITEM_CODE_USED | Derived | — | — |
ITE-OE-ALLOW-RTNOE_ALLOW_RTN | Alpha 1 | " "
| IC10.2, IC11.1, IC811 |
ITE-OE-RTN-DATEOE_RTN_DATE | Numeric 8 (yyyymmdd) | — | IC10.2, IC11.1, IC811 |
ITE-CREATED-BYCREATED_BY | Alpha 10 | — | IC10.2, IC11.1, IC811, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITE-LAST-UPDT-DATELAST_UPDT_DATE | Numeric 8 (yyyymmdd) | — | IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 +15 more |
ITE-LAST-UPDT-TIMELAST_UPDT_TIME | Numeric 8 | — | IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 +15 more |
ITE-LAST-UPDATE-BYLAST_UPDATE_BY | Alpha 10 | — | IC10.2, IC11.1, IC18.1, IC330, IC60.1, IC62.1, IC62.4, IC811 +15 more |
ITE-DESCRIPTION3DESCRIPTION3 | Alpha 350 (Lower Case) | — | IC10.2, IC11.1, IC330, IC811, PO150, PO25.6, PO25.7, PO26.4 +4 more |
ITE-EFFECT-DTEFFECT_DT | Numeric 8 (yyyymmdd) | This is the first date that this item can be used as a Replacement item. | IC10.2, IC11.1 |
ITE-EXPIRE-DTEXPIRE_DT | Numeric 8 (yyyymmdd) | This is the last date that this item can be used as a Replacement item. | IC10.2, IC11.1 |
ITE-CHARGE-NBRCHARGE_NBR | Alpha 80 | — | IC11.1, IC811 |
ITE-LATEX-INDLATEX_IND | Numeric 1 | —
| IC11.1, IC811 |
ITE-HAS-EXP-DTHAS_EXP_DT | Alpha 1 | —
| IC11.1, IC811 |
ITE-CHARGEABLE-FLCHARGEABLE_FL | Alpha 1 | —
| IC11.1, IC811 |
ITE-HCPCSHCPCS | Alpha 7 | — | IC11.1, IC811 |
Indexes (13)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ITESET1 | ITEM-GROUP, ITEM | Primary | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) | |
ITESET10 | ITEM-GROUP, ICSEGMENT, ICFAMILY, ICCLASS, ICCOMMODITY, ITEM | KeyChange, Subset | Where ICSEGMENT != Spaces And ACTIVE-STATUS = "A" | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) |
ITESET11 | ITEM-GROUP, MANUF-NBR, MANUF-CODE, MANUF-DIVISION, ITEM | KeyChange, Subset | Where MANUF-NBR != Spaces And ACTIVE-STATUS = "A" | — |
ITESET12 | ITEM-GROUP, REPLACE-ITEM, ITEM | KeyChange, Subset | Where REPLACE-ITEM != Spaces | IC11.1 |
ITESET13 | ITEM-GROUP, DESCRIPTION2, ITEM | KeyChange, Subset | Where DESCRIPTION2 != Spaces | IC30.1 |
ITESET2 | ITEM-GROUP, DESCRIPTION, ITEM | KeyChange | IC30.1 | |
ITESET3 | ITEM-GROUP, GENERIC, ITEM | KeyChange, Subset | Where GENERIC != Spaces And ACTIVE-STATUS = "A" | IC08.1, IC30.1 |
ITESET4 | ITEM-GROUP, PURCH-MAJCL, PURCH-MINCL, ITEM | KeyChange, Subset | Where PURCH-MAJCL != Spaces And ACTIVE-STATUS = "A" | IC07.1, IC30.1, IC46.1 |
ITESET5 | ITEM-GROUP, INVEN-MAJCL, INVEN-MINCL, ITEM | KeyChange, Subset | Where INVEN-MAJCL != Spaces And ACTIVE-STATUS = "A" | IC06.1, IC30.1, IC46.1, RQ250 |
ITESET6 | ITEM-GROUP, SALES-MAJCL, SALES-MINCL, ITEM | KeyChange, Subset | Where SALES-MAJCL != Spaces And ACTIVE-STATUS = "A" | IC05.1, IC30.1, IC46.1 |
ITESET7 | ITEM-GROUP, USER-FIELD1, ITEM | KeyChange, Subset | Where USER-FIELD1 != Spaces And ACTIVE-STATUS = "A" | IC30.1, IC46.1 |
ITESET8 | ITEM-GROUP, MANUF-CODE, MANUF-DIVISION, MANUF-NBR, ITEM | KeyChange, Subset | Where MANUF-CODE != Spaces And ACTIVE-STATUS = "A" | IC11.1, IC14.1, IC46.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5 +3 more |
ITESET9 | IC-OBJ-ID | KeyChange, Subset | Where IC-OBJ-ID != Zeroes | IC220, IC223, IC231, IC233, IC234, IC243, IC247, IC30.1 +11 more |
Relations
One to one (12) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Genericname | ICGENERIC | Required | When ITE-GENERIC != Spaces And ITE-ACTIVE-STATUS = "A" | ITE-ITEM-GROUP → ICG-ITEM-GROUP, ITE-GENERIC → ICG-GENERIC |
| Hazard | HAZARD | Required | When ITE-HAZARD-CODE != Spaces | ITE-ITEM-GROUP → HAZ-ITEM-GROUP, ITE-HAZARD-CODE → HAZ-HAZARD-CODE |
| Iciteuf | ICITEUF | Not Required, Delete Cascades | ITE-ITEM-GROUP → UFM-ITEM-GROUP, ITE-ITEM → UFM-ITEM | |
| Icmanfcode | ICMANFCODE | Required | When ITE-MANUF-CODE != Spaces And ITE-ACTIVE-STATUS = "A" | ITE-ITEM-GROUP → IMC-ITEM-GROUP, ITE-MANUF-CODE → IMC-MANUF-CODE, ITE-MANUF-DIVISION → IMC-MANUF-DIVISION |
| Inventoryclass | MINORCL | Required | When ITE-INVEN-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A" | ITE-ITEM-GROUP → MIN-ITEM-GROUP, "I" → MIN-CLASS-TYPE, ITE-INVEN-MAJCL → MIN-MAJOR-CLASS, ITE-INVEN-MINCL → MIN-MINOR-CLASS |
| Itebod | ITEBOD | Not Required | Valid When IBA- = ITE- | ITE-ITEM-GROUP → IBA-ITEM-GROUP, ITE-ITEM → IBA-ITEM |
| Itemgroup | ITEMGROUP | Required | ITE-ITEM-GROUP → ITG-ITEM-GROUP | |
| Itemtoitemcode | ICITEMCODE | Not Required | ITE-ITEM-GROUP → IIC-ITEM-GROUP, ITE-ICSEGMENT → IIC-ICSEGMENT, ITE-ICFAMILY → IIC-ICFAMILY, ITE-ICCLASS → IIC-ICCLASS, ITE-ICCOMMODITY → IIC-ICCOMMODITY | |
| Procuregrp | PROCUREGRP | Required | ITE-ITEM-GROUP → PCG-ITEM-GROUP | |
| Purchaseclass | MINORCL | Required | When ITE-PURCH-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A" | ITE-ITEM-GROUP → MIN-ITEM-GROUP, "P" → MIN-CLASS-TYPE, ITE-PURCH-MAJCL → MIN-MAJOR-CLASS, ITE-PURCH-MINCL → MIN-MINOR-CLASS |
| Replace Item | ITEMMAST | Required | When ITE-REPLACE-ITEM != Spaces | ITE-ITEM-GROUP → ITE-ITEM-GROUP, ITE-REPLACE-ITEM → ITE-ITEM |
| Salesclass | MINORCL | Required | When ITE-SALES-MAJCL != Spaces And ITE-ACTIVE-STATUS = "A" | ITE-ITEM-GROUP → MIN-ITEM-GROUP, "S" → MIN-CLASS-TYPE, ITE-SALES-MAJCL → MIN-MAJOR-CLASS, ITE-SALES-MINCL → MIN-MINOR-CLASS |
One to many (11) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Icaudit | ICAUDIT | ITE-ITEM-GROUP → IAU-ITEM-GROUP, Zeroes → IAU-COMPANY, Spaces → IAU-LOCATION, ITE-ITEM → IAU-ITEM, → IAU-GL-CATEGORY, → IAU-DATE, → IAU-TIME, → IAU-FLD-NBR | ||
| Icitemgtin | ICITEMGTIN | ITE-ITEM-GROUP → GTI-ITEM-GROUP, ITE-ITEM → GTI-ITEM, → GTI-GTIN | ||
| Icmxval | ICMXVAL | Delete Cascades | ITE-IC-OBJ-ID → IMV-IC-OBJ-ID, → IMV-MATRIX-CAT | |
| Itemcomments | ITCOMMENT | Delete Restricted | ITE-ITEM-GROUP → ICO-ITEM-GROUP, ITE-ITEM → ICO-ITEM, → ICO-LANGUAGE-CODE, → ICO-SEQ | |
| Itemcompanion | ITEMSUB | ITE-ITEM-GROUP → ITS-ITEM-GROUP, ITE-ITEM → ITS-ITEM, "C" → ITS-SUBTYPE, → ITS-SUB-ITEM | ||
| Itemsub | ITEMSUB | ITE-ITEM-GROUP → ITS-ITEM-GROUP, ITE-ITEM → ITS-ITEM, "S" → ITS-SUBTYPE, → ITS-SUB-ITEM | ||
| Itemtoupc | ITEMUPC | ITE-ITEM-GROUP → IPC-ITEM-GROUP, ITE-ITEM → IPC-ITEM, → IPC-UPC | ||
| Itemtoupn1 | ITEMUPN1 | ITE-ITEM-GROUP → IPN-ITEM-GROUP, ITE-ITEM → IPN-ITEM, → IPN-UPN-NBR | ||
| Itemtoupn2 | ITEMUPN2 | ITE-ITEM-GROUP → IP2-ITEM-GROUP, ITE-ITEM → IP2-ITEM, → IP2-UPN2-NBR | ||
| Poitemven | POITEMVEN | PCG-PROCURE-GROUP → PIV-PROCURE-GROUP, ITE-ITEM → PIV-ITEM, → PIV-VENDOR, → PIV-VEN-ITEM | ||
| Taxcode | TXTAXCODE | ITE-PURCH-TAX-CD → TAC-TAX-CODE, → TAC-COMPANY |
Programs
Updated by (23)
- IC10.2 Item Master and Location
- IC11.1 Item Master
- IC18.1 Item Comments
- IC330 Item Mass Change
- IC60.1 Kit Assembly
- IC62.1 Finished Goods
- IC62.4 Component Finished Goods
- IC811 Item Master Load
- ICI4.1 ITEMUPC Invoked Object
- ICI5.1 ITEMUPN1 Invoked Object
- ICI6.1 ITEMUPN2 Invoked Object
- ICI7.1 ITEMSKU Invoked Object
- ICIC.1 ITEMNDC Invoked Object
- PO150 Bid Load to Contract or Catalog
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO26.8 Update Vendor Agreement Line for Special Item
- PO28.2 Vendor Agreement Line Detail List
- PO36.2 Vendor Agreement Import Manual Input
- PO536 Vendor Price Agreement Load
- WHD3.1 WH-IC Detail Integrity Check
Referenced by (532)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- CX05.1 Preference Template
- CX05.2 Preference Template Diagnostics
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX205 Preference Template Items
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CX805 Template Card Conversion
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- DR25.1 Planned Orders
- DR40.1 Time Phased Order Point
- DR42.1 Time Phased Order Point by Buyer
- IC00.1 Corporate Item Group
- IC02.1 Location
- IC05.1 Sales Class
- IC06.1 Inventory Class
- IC07.1 Purchasing Class
- IC08.1 Generic Names
- IC110 Intransit Shipping
- IC12.1 Item Location
- IC12.2 Replenishment Setup
- IC120 Economic Order Quantity and Reorder Calculation
- IC125 Standard Cost Valuation
- IC13.1 Associated Items
- IC130 General Ledger Interface
- IC134 Inventory Turnover
- IC135 Inventory Turnover by Issues
- IC138 Bin Replenishment Report
- IC14.1 Manufacturer Code
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC143 Finished Good Replenishment
- IC145 Stock Status Report
- IC15.2 Bins
- IC150 Movement Analysis - Cost
- IC151 Movement Analysis - Sales
- IC152 Movement Analysis - GMROI
- IC16.1 UNSPSC Product Codes
- IC170 Freeze Selected Items
- IC175 Update Variances
- IC179 Delete Freeze Records
- IC182 Par Location Utilization
- IC183 Par Level Load
- IC19.1 Forecasts
- IC190 Closing
- IC191 Item Master Audit Trail
- IC192 Item Location Audit Trail
- IC195 IC Receipts Audit Report
- IC20.1 Receipts
- IC20.2 Detail Receipts
- IC21.1 Issues
- IC21.2 Detail Issues
- IC21.5 Issues Detail List
- IC210 Item Master Listing
- IC211 Item Location Listing
- IC212 Item Comments Listing
- IC213 Item Substitutes Listing
- IC216 Open Transaction Report
- IC218 GTIN Listing
- IC219 Forecast Listing
- IC22.1 Transfers
- IC22.2 Detail Transfer
- IC220 Transaction History Report
- IC221 Open Intransit Report
- IC222 Unreleased Documents
- IC223 Availability Report
- IC224 Gross Margin Return on Investment
- IC225 Inventory Reorder Advice
- IC226 Leadtime Review Report
- IC227 Potential Obsolete
- IC228 Potential Overstock
- IC229 Transactions by Reason Code
- IC23.1 Intransit Receiving
- IC23.2 Detail Intransit Receiving
- IC23.3 Intransit Receiving by Lot
- IC23.4 Intransit Receiving by Bin, UOM
- IC23.5 Intransit Receiving by Serial
- IC230 Lot Status Report
- IC231 Issue Summary Report
- IC232 Serial Status Report
- IC233 Inventory Valuation
- IC234 Period End Valuation
- IC235 Market Inventory Valuation
- IC237 Unapproved Bin Report
- IC238 Bin Stock on Hand Report
- IC239 Forecast Variance
- IC24.1 Adjustments
- IC24.2 Detail Adjustments
- IC240 General Ledger Audit Report
- IC241 Bin Reorder Policy Listing
- IC242 Transaction Audit Report
- IC243 Killed Item Report
- IC244 Inventory Issue Document
- IC247 IFRS FIFO Period End Valuation
- IC25.1 Document Release
- IC250 Released Document Report
- IC26.1 Detail Transfers
- IC26.2 Bin Transfer by Serial
- IC260 Kit, Assembly Listing
- IC262 Finished Good Listing
- IC266 Replenishment PO Worksheet Rpt
- IC27.1 Lot Hold Control
- IC270 Count Sheets
- IC28.1 Cost Adjustments
- IC280 Distribution History Report
- IC281 Par Inventory Worksheet
- IC282 Requesting Location Usage
- IC283 Par Location Valuation
- IC285 Detail Par Loc Utilization
- IC287 Transactions by Document Type
- IC29.1 Lots
- IC29.2 Serials
- IC29.3 Bins
- IC295 Count Control Status
- IC30.1 Item Search
- IC30.2 GTIN Inquiry
- IC31.1 Item Location Balances
- IC320 Mass Item Location Copy
- IC331 Par Cart Mass Changes
- IC36.1 User Defined Item Inquiry
- IC38.1 Bin Reorder Policy
- IC40.1 Availability by Location
- IC40.2 Secondary Quantity Availability
- IC41.1 Items Within a Bin
- IC42.1 Stock by Detail
- IC42.2 Stock by Lot
- IC42.3 Serial Numbers
- IC42.4 Secondary Detail
- IC43.1 Bin Type Inquiry
- IC44.1 Inventory Stock Status
- IC45.1 Stock Status
- IC46.1 Inventory Status
- IC47.1 Cost History
- IC48.1 Open Intransits
- IC49.1 Usage History
- IC50.1 Transaction History
- IC50.2 Detail Transaction History
- IC500 Transaction Interface
- IC503 IC Valid UOM CSV Create
- IC51.1 Available Bin Space
- IC511 Item Master-Item Location Extr
- IC512 Item Audit Extract
- IC516 Load UNSPSC Product Codes
- IC519 Forecast Interface
- IC52.1 Serial or Lot History
- IC520 Handheld Item Master Interface
- IC521 Bar Code Item Master Interface
- IC522 HL7 Item Master - Atwork
- IC523 HL7 Item Master - OmniCell
- IC524 CSV Item Master
- IC525 HL7 Item Master Interface
- IC526 HL7 Item Master - McKesson
- IC527 HL7 Item Master - DeRoyal
- IC53.1 Document Inquiry
- IC55.1 Transaction History Inquiry
- IC55.2 Transaction History Inquiry
- IC550 Overallocated Items
- IC56.1 Item Attributes
- IC56.2 Values by Item Attributes
- IC56.3 Query List Members
- IC56.4 Manual Item List
- IC574 Physical Inventory Interface
- IC58.1 Global Location Numbers
- IC589 Forecast Transfer
- IC59.1 Create Label Entry
- IC590 Out of Stock Extract
- IC598 Bin Label Export
- IC61.1 Kit Component Replacement
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC65.1 Component Where Used
- IC66.1 Replenishment PO Worksheet
- IC67.1 Kit Availability
- IC68.1 Finished Good Component Availability
- IC68.2 Finished Good Component Availability
- IC68.3 Finished Good Component Sub Location Availability
- IC70.1 Select IDs
- IC72.1 Counts by Page
- IC73.1 Count Detail
- IC74.1 Random Counts
- IC76.1 Variance Reasons
- IC800 Keyword Search Load
- IC81.1 Cart, Par Location
- IC81.2 Cart, Par Location Item Detail
- IC812 Item Location Load
- IC82.1 Par Location Item Mass Change
- IC820 Beginning Balance Load
- IC83.1 Par Location Counts
- IC84.1 Detail Par Location Utilization by Month
- IC84.2 Detail Par Location Utilization by Month
- IC840 Cart Par Location Conversion
- IC850 Transaction Load
- IC851 History Load
- IC90.1 Bin Transfers
- IC91.1 Item Audit Inquiry
- IC91.2 Item Location and Item Source Audit Inquiry
- IC95.1 Catch Weight
- IC95.2 Catch Weight
- IC95.3 Catch Weight
- IC95.4 IC Receipts Audit
- ICBL.1 Build Item Matrix List
- ICBL.2 Update Global Matrix List
- ICBL.4 Populate Sort File from Matrix List
- ICI1.1 Unit Of Measure Routines
- ICI8.1 ITEMUPC Invoked Object
- ICI9.1 Item GTIN Invoke Object
- ICIA.1 Keyword Search INVOKED Object
- ICIT.1 Item Master Edit
- MA180 Open Receipt Archive
- MA236 Invoiced, Not Received Report
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA53.5 Additional Receiving Entry
- MA53.7 Additional Receiving Adjustment Entry
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA540 Invoice Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA63.1 Invoice Line Match
- MA64.6 Message Detail by Invoice
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA66.3 Purchase Order Cost Review Message
- MA66.8 Chargeback Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA69.1 AOC Level Detail Match
- MA69.2 AOC Level Selections
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MA90.2 All Transactions for Invoice
- MA90.3 Match Analysis Details
- MA90.4 Ready to Archive Receipts
- MAI1.1 Invoke for MAMATCH Object
- MM280 Departmental Procurement Expense Report
- MM80.1 Departmental Procurement Expense Inquiry Selection
- MM80.2 Departmental Procurement Expense Inquiry Detail
- MX123 List Member Build
- MX223 List Member Listing
- MX500 Attribute Value Population
- PC10.1 Patient Charge Items
- PC120 Price Calculation
- PC190 Patient Charge Item Audit Rpt
- PC20.1 Patient Charges
- PC540 Patient Charge Upload
- PC810 Patient Charge Item Conversion
- PC90.1 Patient Charge Item Audit Inquiry
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO125 Print Agreement Item Description
- PO13.1 Vendor Item
- PO13.3 Vendor Items
- PO130 Receiving Document
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO133 Receiving Adjustment Log
- PO135 Received, Not Invoiced Report
- PO136 Matched, Not Received Report
- PO137 Agreement Cost Update
- PO139 Standard Cost Calculation
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO16.1 Bid
- PO16.2 Bid Response
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO192 PO Vendor Item Audit Report
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.7 Substitute Vendor Items Detail
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO213 Vendor Item Listing
- PO215 Procurement Template Listing
- PO216 Bid Analysis
- PO22.1 Authorization, Release
- PO22.2 Mass Cancel or Delete Purchase Orders
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO22.5 Purchase Order Line Inquiry
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO223 Buyer Expediting Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO227 Contract Agreement Compliance Report
- PO228 Consolidated Demand Report
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO23.6 Agreements For An Item
- PO23.7 Item Purchase History
- PO230 Unreleased Receivings Listing
- PO233 PO Received Quantity Exceptions
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO251 PO Buyer Message Listing
- PO253 Item Receipt Volume Report
- PO254 PO Inquiry Report
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO274 Returns Analysis
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO278 RNI Aging Report
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO295 Cash Requirements Forecast
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.1 GL distribution for returns
- PO32.2 Item Detail
- PO32.3 Catch Weight
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO45.1 Procurement Template Item Lookup
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO53.2 Purchase Order Line Interface
- PO53.8 Item AOC
- PO54.1 Purchase Order Inquiry
- PO54.2 Purchase Order Inquiry
- PO54.3 Purchase Order Inquiry
- PO54.4 Purchase Order Inquiry
- PO54.5 PO Line Detail List
- PO550 Bid Creation
- PO560 Bid Response Load
- PO63.1 PO Inquiry By Item
- PO64.1 PO Line Item History
- PO67.1 PO Inquiry By AOC
- PO69.1 PO Vendor Item Audit Inquiry
- PO813 Item Vendor Load
- PO94.1 Vendor Performance
- PO983 PO Line Item UNSPSC
- POAP.1 Olap Dimension Retrieval Format
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POI6.1 Assign Doc Number Oject
- POI7.1 POI7 Print Object
- POID.1 PO Delivery Ticket Select
- POIE.1 Delivery Ticket Report
- POIH.1 Invokeable Unit Cost Default
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- POIM.1 GL Budget Ck for PO and RQ
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ11.3 AOC Spread
- RQ11.4 Miscellaneous AOC
- RQ11.5 Item AOC
- RQ111 Print Requisitions
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ140 Requisition Status Report
- RQ230 Department Usage Report
- RQ235 Issues Audit List
- RQ250 Item Catalog
- RQ260 Requisitioned Items Report
- RQ270 RQ Fill Rate Analysis
- RQ35.1 Requisition Returns
- RQ39.1 Serial Feedback
- RQ39.2 Lot Feedback
- RQ39.3 Bin Feedback
- RQ40.1 Requisitions by Location
- RQ41.1 Requisition Status
- RQ42.1 Requisitions by Item
- RQ44.1 Requisition Inquiry
- RQ44.2 Requisition Detail Inquiry
- RQ50.1 Issues History
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQCP.1 Copy Attachment Comments
- RQD0.1 Invoke for RQ Orphan Check
- RQD1.1 Invoke for RQ Integrity Check
- RQIB.1 RQRQHUPD Invoke Object
- RQIC.1 Get Item List Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- RQIH.1 Invoke Determine Express Data
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH110 Batch Allocation
- WH120 Route Creation
- WH126 POD Print
- WH130 Pick List Print
- WH132 Batch Feedback
- WH140 Bill Of Lading Print
- WH190 Shipment Release
- WH20.1 Inventoried Allocation
- WH20.2 Nonstock and Special Allocation
- WH20.3 Bin Allocation
- WH20.4 Lot Allocation
- WH20.5 Serial Allocation
- WH20.6 UOM Allocation
- WH20.7 Substitute Location
- WH21.1 Routes
- WH21.2 Stops
- WH21.3 Stop Transfer
- WH21.4 Document Transfer
- WH210 Route File Listing
- WH22.1 Kit Options
- WH220 Ready to Allocate
- WH221 Allocated Not Printed
- WH222 Shipments In Process
- WH224 Packing List Print
- WH225 MSDS Listing
- WH226 Items on Backorder Report
- WH25.1 Cancellation By Item
- WH25.2 Cancellation By Document
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH34.5 Catch Weight
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
- WHD2.1 WH-IC Integrity Check