| ITEMNMBR | char(30) | Yes | Item Number | IN |
| ITEMDESC | char(100) | Yes | Description: Required for a new record | IN |
| ITMSHNAM | char(15) | No | Short Description | IN |
| ITMGEDSC | char(10) | No | Generic Description | IN |
| ITMCLSCD | char(10) | No | Class ID | IN |
| ITEMTYPE | smallint | No | Item Type: 1=Sales Inventory; 2=Discontinued; 3=Kit; 4=Misc Charges; 5=Services; 6=Flat Fee | IN |
| VCTNMTHD | smallint | No | Valuation Method: 0=Any ITEMTYPE other then 1 or 2; 1=FIFO Perpetual; 2=LIFO Perpetual; | IN |
| TAXOPTNS | smallint | No | Sales Tax Option; 1=Taxable; 2=Nontaxable; 3=Base on Customers; Default=1 on new record | IN |
| ITMTSHID | char(15) | No | Tax Schedule ID | IN |
| UOMSCHDL | char(10) | Yes | U of M Schedule ID: Required for a new record, but can roll down from class | IN |
| ITEMSHWT | numeric(19,5) | No | Shipping Weight; Only used with ITEMTYPE 1,2,3 | IN |
| TCC | char(30) | No | Tax Commodity Code: Only used if the 'Enable Intrastat Tracking' opion is enabled in Company Setup | IN |
| CNTRYORGN | char(6) | No | Country Origin: Only used if the 'Enable Intrastat Tracking' opion is enabled in Company Setup | IN |
| DECPLQTY | smallint | No | Quantity Decimals: Valid values=0-5; Default=0 on new record; ITEMTYPE=3 must be 0 | IN |
| DECPLCUR | smallint | No | Currency Decimals: Used for item if not registered for MC or used for functional currency | IN |
| Purchase_Tax_Options | smallint | No | Purchase Tax option: 1=Taxable; 2=NonTaxable; 3=Base on Vendors; Default=1 | IN |
| Purchase_Item_Tax_Schedu | char(15) | No | Purchases Tax Schedule ID | IN |
| STNDCOST | numeric(19,5) | No | Standard Cost | IN |
| CURRCOST | numeric(19,5) | No | Current Cost | IN |
| LISTPRCE | numeric(19,5) | No | List Price: Used if MC is not registered or for functional currency if MC registered | IN |
| NOTETEXT | varchar(8000) | No | Note Text | IN |
| ALTITEM1 | char(30) | No | Substitute Item 1 | IN |
| ALTITEM2 | char(30) | No | Substitute item 2 | IN |
| ITMTRKOP | smallint | No | Track: 1=None; 2=Serial Numbers; 3=Lot Numbers; Default=1 on new record; Used for ITEMTYPE 1,2 | IN |
| LOTTYPE | char(10) | No | Lot Category | IN |
| LOTEXPWARN | tinyint | No | Lot Expiration Warn: 0 = no warning; 1 = warnings enabled | IN |
| LOTEXPWARNDAYS | smallint | No | Days Before Lot Expires: 0 - 999 | IN |
| INCLUDEINDP | tinyint | No | Include in Demand Planning; 0=Do Not Include; 1=Include; Default=0 on new record | IN |
| MINSHELF1 | smallint | No | Minimum Shelf Life 1: Valid values=0-9999; Default=0 on new record; Valid with ITMTRKOP=3 | IN |
| MINSHELF2 | smallint | No | Minimum Shelf Life 2: Valid values=0-9999; Default=0 on new record; Valid with ITMTRKOP=3 | IN |
| ALWBKORD | tinyint | No | Allow Back Orders: 0=Do Not Allow Back Orders; 1=Allow Back Orders; Default=0 on new record | IN |
| WRNTYDYS | smallint | No | Warranty Days: Valid values=0-9999; Default=0 on new record | IN |
| ABCCODE | smallint | No | ABC Code: 1=None; 2=A; 3=B; 4=C; Default=1 on new record | IN |
| USCATVLS_1 | char(10) | No | Category 1 | IN |
| USCATVLS_2 | char(10) | No | Category 2 | IN |
| USCATVLS_3 | char(10) | No | Category 3 | IN |
| USCATVLS_4 | char(10) | No | Category 4 | IN |
| USCATVLS_5 | char(10) | No | Category 5 | IN |
| USCATVLS_6 | char(10) | No | Category 6 | IN |
| KPCALHST | tinyint | No | Maintain History - Calendar Year: 0=Do Not Keep History; 1=Keep History; Default=0 on new record | IN |
| KPERHIST | tinyint | No | Maintain History - Fiscal Year: 0=Do Not Keep History; 1=Keep History; Default=0 on new record | IN |
| KPTRXHST | tinyint | No | Maintain History - Transaction: 0=Do Not Keep History; 1=Keep History; Default=0 on new record | IN |
| KPDSTHST | tinyint | No | Maintain History - Distribution: 0=Do Not Keep History; 1=Keep History; Default=0 on new record | IN |
| IVIVACTNUMST | varchar(75) | No | Inventory Account | IN |
| IVIVOFACTNUMST | varchar(75) | No | Inventory Offset Account | IN |
| IVCOGSACTNUMST | varchar(75) | No | Cost of Goods Sold Account | IN |
| IVSLSACTNUMST | varchar(75) | No | Sales Account | IN |
| IVSLDSACTNUMST | varchar(75) | No | Markdowns Account | IN |
| IVSLRNACTNUMST | varchar(75) | No | Sales Returns Account | IN |
| IVINUSACTNUMST | varchar(75) | No | In Use Account | IN |
| IVINSVACTNUMST | varchar(75) | No | In Service Account | IN |
| IVDMGACTNUMST | varchar(75) | No | Damaged Account | IN |
| IVVARACTNUMST | varchar(75) | No | Variance Account | IN |
| DPSHPACTNUMST | varchar(75) | No | Drop Ship Items Account | IN |
| PURPVACTNUMST | varchar(75) | No | Purchase Price Variance Account | IN |
| UPPVACTNUMST | varchar(75) | No | Unrealized Purchase Price Variance Account | IN |
| IVRETACTNUMST | varchar(75) | No | Inventory Returns Account | IN |
| ASMVRACTNUMST | varchar(75) | No | Assembly Variance Account | IN |
| KTACCTSR | smallint | No | Cost of Good Sold Account: 0=From Component Item; 1=From Kit Item; Default=0 on new record | IN |
| PRCHSUOM | char(8) | No | Default Purchasing Unit of Measure | IN |
| Revalue_Inventory | tinyint | No | Revalue Inventory for Cost Variance: 0=Do Not Revalue; 1=Revalue; Default=0 on new record | IN |
| Tolerance_Percentage | numeric(19,5) | No | Tolerance Percentage: Valid values=.001 to 9999.999 | IN |
| LOCNCODE | char(10) | No | Default Site ID: Assigns site to item if it is not already assigned | IN |
| PRICMTHD | smallint | No | Price Method: 1=Currency Amount; 2=% of List Price; 3=%Markup-Current Cost; | IN |
| PriceGroup | char(10) | No | Price Group | IN |
| UseQtyOverageTolerance | tinyint | No | Use Qty Overage Tolerance | IN |
| UseQtyShortageTolerance | tinyint | No | Use Qty Shortage Tolerance | IN |
| QtyOverTolerancePercent | int | No | Qty Over Tolerance Percent | IN |
| QtyShortTolerancePercent | int | No | Qty Short Tolerance Percent | IN |
| UseItemClass | tinyint | No | Flag to have class roll down to parameters that are not passed in. Uses the @I_vITMCLSCD class | IN |
| UpdateIfExists | tinyint | No | Flag to allow updates: 0=Create only; 1=Update if exists; 2=Create, do NOT update(no error) | IN |
| RequesterTrx | smallint | No | Requester Transaction: 0=False; 1=True - if true than populates Requester shadow table | IN |
| USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
| USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
| ErrorState | int | No | Create Custom Business Logic | INOUT |
| oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |