The Item Maintenance template has the following fields, the table also includes any restrictions regarding the field inputs:
| Field | Restrictions |
|---|---|
| Item Number* | Max Characters:30 |
| Item Description | Max Characters:100 |
| Short Description | Max Characters:15 |
| Generic Description | Max Characters:10 |
| Class Id | Max Characters:10 |
| Inactive | Active / Inactive |
| Item Type | Item type 1=Sales inventory; 2=Discontinued; 3=Kit; 4=Miscellaneous charges; 5=Services; 6=Flat fee Default is one on new record |
| Valuation Method | Valuation method: 0=Any ITEMTYPE other than 1 or 2; 1=FIFO perpetual; 2=LIFO perpetual; 3=Average perpetual; 4=FIFO periodic; 5=LIFO periodic Default is one on new record |
| Sales Tax Options | Sales tax options: 1=Taxable; 2=Nontaxable; 3=Base on customers Default is one on new record |
| Tax Schedule Id | Max Characters:15 |
| Unit Of Measure Schedule Id | Max Characters:10 |
| Shipping Weight | Shipping weight; only used when ITEMTYPE=1, 2, or 3 |
| Quantity Decimals | Quantity Decimals; DECPLQTY can equal 0, 1, 2, 3, 4, or 5; if ITEMTYPE=3, then DECPLQTY must be set to zero Default is zero on new record |
| Tax Community Code | Tax community code; only used if the Enable Intrastat Tracking option is enabled in Company Setup Max Characters:30 |
| Country Origin | Country origin; only used if the Enable Intrastat Tracking option is enabled in Company Setup Max Characters:6 |
| Currency Decimals | Currency Decimals; used for item if not registered for multi-currency or used for functional currency |
| Purchasing Tax Option | Purchasing tax option: 1=Taxable; 2=Nontaxable; 3=Base on vendors Default is one on new record |
| Purchase Tax Schedule Id | Max Characters:15 |
| Standard Cost | |
| Current Cost | |
| Note Text | Max Characters:8000 |
| Alternate Item 1 | Max Characters:30 |
| Alternate Item 2 | Max Characters:30 |
| Item Tracking | Item tracking: 1=None; 2=Serial Numbers; 3=Lot Numbers Used when ITEMTYPE= 1 or 2 Default is one on new record |
| Lot Category | Max Characters:10 |
| Lot Expiration Warn | Lot Expiration Warn: 0 = no warning 1 = warnings enabled If this item is not lot tracked, the value of this element is not used. |
| Days Before Lot Expires | Days Before Lot Expires: Valid entries equal 0 - 999. If LOTEXPWARN is 0 then LOTEXPWARNDAYS always defaults to 0. |
| Include In Demand Planning | Include in Demand Planning; 0=Do Not Include; 1=Include Default is zero on new record |
| Minimum Shelf Life 1 | Minimum shelf life 1: Valid entries equal 0-9999 Use when ITMTRKOP=3 Default is zero on new record |
| Minimum Shelf Life 2 | Minimum shelf life 2: Valid entries equal 0-9999 Use when ITMTRKOP=3 Default is zero on new record |
| Allow Back Orders | Allow back orders: 0=Do not allow back orders; 1=Allow back orders Default is zero on new record |
| Warranty Days | Warranty days; valid entries equal 0-9999 Default is zero on new record |
| Abc Code | ABC code: 1=None; 2=A; 3=B; 4=C Default is one on new record |
| User Category 1 | Max Characters:10 |
| User Category 2 | Max Characters:10 |
| User Category 3 | Max Characters:10 |
| User Category 4 | Max Characters:10 |
| User Category 5 | Max Characters:10 |
| User Category 6 | Max Characters:10 |
| Maintain History—Calendar Year | Maintain history—calendar year: 0=Do not keep history; 1=Keep history Default is 0 on new record |
| Maintain History—Fiscal Year | Maintain history—fiscal year: 0=Do not keep history; 1=Keep history Default is 0 on new record |
| Maintain History—Transaction | Maintain history—transaction: 0=Do not keep history; 1=Keep history Default is 0 on new record |
| Maintain History—Distribution | Maintain history—distribution: 0=Do not keep history; 1=Keep history Default is 0 on new record |
| Inventory Account | Max Characters:75 |
| Inventory Offset Account | Max Characters:75 |
| Cost Of Goods Sold Account | Max Characters:75 |
| Sales Account | Max Characters:75 |
| Markdown Account | Max Characters:75 |
| Sales Return Account | Max Characters:75 |
| In Use Account | Max Characters:75 |
| In Service Account | Max Characters:75 |
| Damaged Account | Max Characters:75 |
| Variance Account | Max Characters:75 |
| Drop-Ship Items Account | Max Characters:75 |
| Purchase Price Variance Account | Max Characters:75 |
| Unrealized Purchase Price Variance Account | Max Characters:75 |
| Inventory Returns Account | Max Characters:75 |
| Assembly Variance Account | Max Characters:75 |
| Cost Of Goods Sold Account Source | Cost of goods sold account source: 0=From component item; 1=From kit item Default is zero on new record |
| Standard Cost Revaluation | Manuf. System Max Characters:75 |
| Applied - Material Fixed OH | Manuf. System Max Characters:75 |
| Applied - Material Var. OH | Manuf. System Max Characters:75 |
| Variance - Labor | Manuf. System Max Characters:75 |
| Variance - Labor Var. OH | Manuf. System Max Characters:75 |
| Variance - Machine | Manuf. System Max Characters:75 |
| Variance - Mach. Fixed OH | Manuf. System Max Characters:75 |
| Variance - Mach. Var. OH | Manuf. System Max Characters:75 |
| Variance - Material | Manuf. System Max Characters:75 |
| Variance - Mat. Fixed OH | Manuf. System Max Characters:75 |
| Variance - Mat. Var. OH | Manuf. System Max Characters:75 |
| WIP - Material | Manuf. System Max Characters:75 |
| WIP - Material Fixed OH | Manuf. System Max Characters:75 |
| WIP - Material Var. OH | Manuf. System Max Characters:75 |
| WIP - Labor | Manuf. System Max Characters:75 |
| WIP - Labor Fixed OH | Manuf. System Max Characters:75 |
| WIP - Labor Var. OH | Manuf. System Max Characters:75 |
| WIP - Machine | Manuf. System Max Characters:75 |
| WIP - Machine Fixed OH | Manuf. System Max Characters:75 |
| WIP - Machine Var. OH | Manuf. System Max Characters:75 |
| CoGS - Material | Manuf. System Max Characters:75 |
| CoGS - Material Fixed OH | Manuf. System Max Characters:75 |
| CoGS - Material Var. OH | Manuf. System Max Characters:75 |
| CoGS - Labor | Manuf. System Max Characters:75 |
| CoGS - Labor Fixed OH | Manuf. System Max Characters:75 |
| CoGS - Labor Var. OH | Manuf. System Max Characters:75 |
| CoGS - Machine | Manuf. System Max Characters:75 |
| CoGS - Machine Fixed OH | Manuf. System Max Characters:75 |
| CoGS - Machine Var. OH | Manuf. System Max Characters:75 |
| Inventory - Mat. Fixed OH | Manuf. System Max Characters:75 |
| Inventory - Mat. Var. OH | Manuf. System Max Characters:75 |
| Inventory - Labor | Manuf. System Max Characters:75 |
| Inventory - Labor Fixed OH | Manuf. System Max Characters:75 |
| Inventory - Labor Var. OH | Manuf. System Max Characters:75 |
| Inventory - Machine | Manuf. System Max Characters:75 |
| Inventory - Mach. Fixed OH | Manuf. System Max Characters:75 |
| Inventory - Mach. Var OH | Manuf. System Max Characters:75 |
| Selling Unit Of Measure | Manuf. System Max Characters:75 |
| Purchasing Unit Of Measure | Max Characters:8 |
| Revalue Inventory For Cost Variance | Max Characters:8 |
| Tolerance Percentage | Revalue inventory for cost variance: 0=Do not revalue; 1=Revalue Default is zero on new record |
| Location Code | |
| Price Method | Location code; assigns site to item if it is not already assigned Max Characters:10 |
| Price Group | Price method: 1=Currency amount; 2=Percent of List price; 3=Percent of markup of current cost; 4=Percent markup of standard cost; 5=Percent margin of current cost; 6=Percent margin of standard cost Default is one |
| Use Item Class | Flag to have class setting roll down to elements that are not passed in; uses the ITMCLSCD class (Yes/Empty=No |
Keep an eye on our social media for updates on changes coming to TitaniumGP. We hope to see you! Privacy Policy
