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

taFSEquipmentMaster

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
SERLNMBRchar(21)No Serial Number IN
ITEMNMBRchar(31)No Item Number IN
REFRENCEchar(31)No Equipment Reference IN
Versionchar(21)No Version Number IN
SRLSTATchar(11)No Equipment/Serial Status Code IN
CUSTNMBRchar(15)No Customer Number IN
ADRSCODEchar(15)No Customer Address Code to which Equipment belongs to IN
ADDRESS1char(61)No Address Line 1 of Customer's Address IN
ADDRESS2char(61)No Address Line 2 IN
ADDRESS3char(61)No Address Line 3 IN
CITYchar(35)No City Name IN
STATEchar(29)No State Name/Code IN
ZIPchar(11)No Zip Code IN
COUNTRYchar(61)No Country Name IN
CNTCPRSNchar(61)No Contact Person's Name of Customer IN
INSTDTEdatetimeNo Install Date IN
Shipped_DatedatetimeNo Date item was shipped IN
SVC_Register_DatedatetimeNo Registered Date IN
LSTPMDTEdatetimeNo Last PM Date IN
LSTSRVDTEdatetimeNo Last Serviced Date IN
TECHIDchar(11)No Technician ID IN
OFFIDchar(11)No Office ID IN
SVCAREAchar(11)No Service Area IN
TIMEZONEchar(3)No Time Zone IN
VENDORIDchar(15)No Vendor ID providing warranty for the Item IN
WARRCDEchar(11)No Vendor's Warranty Code, if any IN
WARRSTARTdatetimeNo Vendor Warranty Start Date IN
WARRENDdatetimeNo Vendor Warranty End Date IN
SLRWARRchar(11)No Seller's Warranty Code, if any IN
SLRWSTARTdatetimeNo Seller Warranty Start Date IN
SLRWENDdatetimeNo Seller Warranty End Date IN
NOTETXTnvarchar(2000)No Notes IN
SVC_PM_DatesmallintNo Month when Preventive Maintenance is done IN
SVC_PM_DaysmallintNo Day when Preventive Maintenance is done IN
USERDEF1char(21)No Addl. Information line 1 IN
USERDEF2char(21)No Addl. Information line 2 IN
USRDEF03char(21)No Addl. Information line 3 IN
USRDEF04char(21)No Addl. Information line 4 IN
USRDEF05char(21)No Addl. Information line 5 IN
SVC_Serial_IDchar(21)No Serial Number to be used in service calls IN
SVC_Asset_Tagchar(21)No Asset Tag linked to the equipment IN
UpdateIfExiststinyintNo Flag to allow customer data to be updated if it exists. 0=no, 1=yes IN
RequesterTrxsmallintNo Requester Trx - 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 List of errors encountered INOUT
oErrStringvarchar(255)No List of errors encountered 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