Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Skip Navigation LinkseConnect Module : Type : Node : Fields Easy Navigation

taUpdateCreateItemRcd

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
ITEMNMBRchar(30)Yes Item Number IN
ITEMDESCchar(100)Yes Description: Required for a new record IN
ITMSHNAMchar(15)No Short Description IN
ITMGEDSCchar(10)No Generic Description IN
ITMCLSCDchar(10)No Class ID IN
ITEMTYPEsmallintNo Item Type: 1=Sales Inventory; 2=Discontinued; 3=Kit; 4=Misc Charges; 5=Services; 6=Flat Fee IN
VCTNMTHDsmallintNo Valuation Method: 0=Any ITEMTYPE other then 1 or 2; 1=FIFO Perpetual; 2=LIFO Perpetual; IN
TAXOPTNSsmallintNo Sales Tax Option; 1=Taxable; 2=Nontaxable; 3=Base on Customers; Default=1 on new record IN
ITMTSHIDchar(15)No Tax Schedule ID IN
UOMSCHDLchar(10)Yes U of M Schedule ID: Required for a new record, but can roll down from class IN
ITEMSHWTnumeric(19,5)No Shipping Weight; Only used with ITEMTYPE 1,2,3 IN
TCCchar(30)No Tax Commodity Code: Only used if the 'Enable Intrastat Tracking' opion is enabled in Company SetupIN
CNTRYORGNchar(6)No Country Origin: Only used if the 'Enable Intrastat Tracking' opion is enabled in Company Setup IN
DECPLQTYsmallintNo Quantity Decimals: Valid values=0-5; Default=0 on new record; ITEMTYPE=3 must be 0 IN
DECPLCURsmallintNo Currency Decimals: Used for item if not registered for MC or used for functional currency IN
Purchase_Tax_OptionssmallintNo Purchase Tax option: 1=Taxable; 2=NonTaxable; 3=Base on Vendors; Default=1 IN
Purchase_Item_Tax_Scheduchar(15)No Purchases Tax Schedule ID IN
STNDCOSTnumeric(19,5)No Standard Cost IN
CURRCOSTnumeric(19,5)No Current Cost IN
LISTPRCEnumeric(19,5)No List Price: Used if MC is not registered or for functional currency if MC registered IN
NOTETEXTvarchar(8000)No Note Text IN
ALTITEM1char(30)No Substitute Item 1 IN
ALTITEM2char(30)No Substitute item 2 IN
ITMTRKOPsmallintNo Track: 1=None; 2=Serial Numbers; 3=Lot Numbers; Default=1 on new record; Used for ITEMTYPE 1,2 IN
LOTTYPEchar(10)No Lot Category IN
LOTEXPWARNtinyintNo Lot Expiration Warn: 0 = no warning; 1 = warnings enabled IN
LOTEXPWARNDAYSsmallintNo Days Before Lot Expires: 0 - 999 IN
INCLUDEINDPtinyintNo Include in Demand Planning; 0=Do Not Include; 1=Include; Default=0 on new record IN
MINSHELF1smallintNo Minimum Shelf Life 1: Valid values=0-9999; Default=0 on new record; Valid with ITMTRKOP=3 IN
MINSHELF2smallintNo Minimum Shelf Life 2: Valid values=0-9999; Default=0 on new record; Valid with ITMTRKOP=3 IN
ALWBKORDtinyintNo Allow Back Orders: 0=Do Not Allow Back Orders; 1=Allow Back Orders; Default=0 on new record IN
WRNTYDYSsmallintNo Warranty Days: Valid values=0-9999; Default=0 on new record IN
ABCCODEsmallintNo ABC Code: 1=None; 2=A; 3=B; 4=C; Default=1 on new record IN
USCATVLS_1char(10)No Category 1 IN
USCATVLS_2char(10)No Category 2 IN
USCATVLS_3char(10)No Category 3 IN
USCATVLS_4char(10)No Category 4 IN
USCATVLS_5char(10)No Category 5 IN
USCATVLS_6char(10)No Category 6 IN
KPCALHSTtinyintNo Maintain History - Calendar Year: 0=Do Not Keep History; 1=Keep History; Default=0 on new record IN
KPERHISTtinyintNo Maintain History - Fiscal Year: 0=Do Not Keep History; 1=Keep History; Default=0 on new record IN
KPTRXHSTtinyintNo Maintain History - Transaction: 0=Do Not Keep History; 1=Keep History; Default=0 on new record IN
KPDSTHSTtinyintNo Maintain History - Distribution: 0=Do Not Keep History; 1=Keep History; Default=0 on new record IN
IVIVACTNUMSTvarchar(75)No Inventory Account IN
IVIVOFACTNUMSTvarchar(75)No Inventory Offset Account IN
IVCOGSACTNUMSTvarchar(75)No Cost of Goods Sold Account IN
IVSLSACTNUMSTvarchar(75)No Sales Account IN
IVSLDSACTNUMSTvarchar(75)No Markdowns Account IN
IVSLRNACTNUMSTvarchar(75)No Sales Returns Account IN
IVINUSACTNUMSTvarchar(75)No In Use Account IN
IVINSVACTNUMSTvarchar(75)No In Service Account IN
IVDMGACTNUMSTvarchar(75)No Damaged Account IN
IVVARACTNUMSTvarchar(75)No Variance Account IN
DPSHPACTNUMSTvarchar(75)No Drop Ship Items Account IN
PURPVACTNUMSTvarchar(75)No Purchase Price Variance Account IN
UPPVACTNUMSTvarchar(75)No Unrealized Purchase Price Variance Account IN
IVRETACTNUMSTvarchar(75)No Inventory Returns Account IN
ASMVRACTNUMSTvarchar(75)No Assembly Variance Account IN
KTACCTSRsmallintNo Cost of Good Sold Account: 0=From Component Item; 1=From Kit Item; Default=0 on new record IN
PRCHSUOMchar(8)No Default Purchasing Unit of Measure IN
Revalue_InventorytinyintNo Revalue Inventory for Cost Variance: 0=Do Not Revalue; 1=Revalue; Default=0 on new record IN
Tolerance_Percentagenumeric(19,5)No Tolerance Percentage: Valid values=.001 to 9999.999 IN
LOCNCODEchar(10)No Default Site ID: Assigns site to item if it is not already assigned IN
PRICMTHDsmallintNo Price Method: 1=Currency Amount; 2=% of List Price; 3=%Markup-Current Cost; IN
PriceGroupchar(10)No Price Group IN
UseQtyOverageTolerancetinyintNo Use Qty Overage Tolerance IN
UseQtyShortageTolerancetinyintNo Use Qty Shortage Tolerance IN
QtyOverTolerancePercentintNo Qty Over Tolerance Percent IN
QtyShortTolerancePercentintNo Qty Short Tolerance Percent IN
UseItemClasstinyintNo Flag to have class roll down to parameters that are not passed in. Uses the @I_vITMCLSCD class IN
UpdateIfExiststinyintNo Flag to allow updates: 0=Create only; 1=Update if exists; 2=Create, do NOT update(no error) IN
RequesterTrxsmallintNo Requester Transaction: 0=False; 1=True - if true than populates Requester shadow table IN
USRDEFND1char(50)No User Defined field - developer use only IN
USRDEFND2char(50)No User Defined field - developer use only IN
USRDEFND3char(50)No User Defined field - developer use only IN
USRDEFND4varchar(8000)No User Defined field - developer use only IN
USRDEFND5varchar(8000)No User Defined field - developer use only IN
ErrorStateintNo Create Custom Business Logic INOUT
oErrStringvarchar(255)No Create Custom Business Logic INOUT






Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
site