ITMCLSCD | char(10) | Yes | Item Class ID - | IN |
ITMCLSDC | char(30) | Yes | Item Class Description - | IN |
DEFLTCLS | tinyint | No | Default Class - - 0=False & 1=True | IN |
ITEMTYPE | smallint | No | Item Type - - 1=Sales Inventory, 2=Discontinued, | IN |
ITMTRKOP | smallint | No | Item Tracking Option - - 1=None, 2=Serial Numbers, 3=Lots | 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 |
KPERHIST | tinyint | No | Keep Period History - - 0=False & 1=True | IN |
KPTRXHST | tinyint | No | Keep Trx History - - 0=False & 1=True | IN |
KPCALHST | tinyint | No | Keep Calendar History - - 0=False & 1=True | IN |
KPDSTHST | tinyint | No | Keep Distribution History - - 0=False & 1=True | IN |
ALWBKORD | tinyint | No | Allow Back Orders - - 0=False & 1=True | IN |
ITMGEDSC | char(10) | No | Item Generic Description - | IN |
TAXOPTNS | smallint | No | Sales Tax Option - - 1=Taxable, 2=Nontaxable, | IN |
ITMTSHID | char(15) | No | Sales Tax Schedule ID - | IN |
Purchase_Tax_Options | smallint | No | Sales Tax Option - - 1=Taxable, 2=Nontaxable, | IN |
Purchase_Item_Tax_Schedu | char(15) | No | Purchase Tax Schedule ID - | IN |
UOMSCHDL | char(11) | No | Unit of Measure Schedule ID - | IN |
VCTNMTHD | smallint | No | Valuation Method - - 1=FIFO Perpetual, 2=LIFO Perpetual | IN |
USCATVLS_1 | char(10) | No | User Defined 1 - | IN |
USCATVLS_2 | char(10) | No | User Defined 2 - | IN |
USCATVLS_3 | char(10) | No | User Defined 3 - | IN |
USCATVLS_4 | char(10) | No | User Defined 4 - | IN |
USCATVLS_5 | char(10) | No | User Defined 5 - | IN |
USCATVLS_6 | char(10) | No | User Defined 6 - | IN |
DECPLQTY | smallint | No | Decimal Places Quantity (1=0,2=1,3=2,4=3,5=4,6=5) | IN |
Inventory_Acct | char(75) | No | Inventory Account - | IN |
Inventory_Offset_Acct | char(75) | No | Inventory Offset Account - | IN |
Cost_of_Goods_Sold_Acct | char(75) | No | Cost of Good Sold Account - | IN |
Sales_Acct | char(75) | No | Sales Account - | IN |
Markdowns_Acct | char(75) | No | Markdowns Account - | IN |
Sales_Returns_Acct | char(75) | No | Sales Returns Account - | IN |
In_Use_Acct | char(75) | No | In Use Account - | IN |
In_Service_Acct | char(75) | No | In Service Account - | IN |
Damaged_Acct | char(75) | No | Damaged Account - | IN |
Variance_Acct | char(75) | No | Variance Account - | IN |
Drop_Ship_Items_Acct | char(75) | No | Drop Ship Items Account - | IN |
Purchase_Price_Variance_Acct | char(75) | No | Purchase Price Variance Account - | IN |
Unrealized_Purchase_Price_Variance_Acct | char(75) | No | Unrealized Purchase Price Variance Account - | IN |
Inventory_Returns_Acct | char(75) | No | Inventory Returns Account - | IN |
Assembly_Variance_Acct | char(75) | No | Assembly Variance Account - | IN |
PRCLEVEL | char(10) | No | Price Level - | IN |
PriceGroup | char(10) | No | Price Group - | IN |
PRICMTHD | smallint | No | Price Method - - 1=Currency Amount, 2=% of List Price | IN |
Revalue_Inventory | tinyint | No | Revalue Inventory - - 0=False & 1=True | IN |
Tolerance_Percentage | int | No | Tolerance Percentage - | 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 |
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 | Return value: 0=No Errors, 1=Error Occurred | INOUT |
oErrString | varchar(255) | No | Return Error Code List | INOUT |