Skip Navigation LinkseConnect Module : Type : Node : Fields Easy Navigation


eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
SRVRECTYPEsmallintNo Service Record Type -- 1=Quote, 2=Open IN
CALLNBRchar(11)No Service Call Number IN
EQPLINEintNo Equipment Line Number IN
LNITMSEQbigintNo Line Item Sequence IN
LINITMTYPchar(3)No Line Item Type P=Parts, L=Labor, A=Addl Charges, E=Expenses IN
SRVSTATchar(3)No Service Call Status Code IN
TECHIDchar(11)No Tech ID IN
CUSTNMBRchar(15)No Customer Number IN
ADRSCODEchar(15)No Address Code IN
ITEMNMBRchar(31)No Item Number IN
CKNORETURNSsmallintNo Flag to indicate NOT to create Returnable line. IN
ITEMDESCchar(101)No Item Description IN
LOCNCODEchar(11)No Item Location Code IN
UOFMchar(9)No Item Unit of Measure IN
QTYORDERnumeric(19,5)No Ordered Qty IN
ATYALLOCnumeric(19,5)No Allocated Qty IN
QTYBACKOnumeric(19,5)No Backordered Qty IN
QTYSOLDnumeric(19,5)No Sold Qty IN
UNITCOSTnumeric(19,5)No Item Unit Cost IN
UNITPRCEnumeric(19,5)No Item Unit Price IN
XTNDPRCEnumeric(19,5)No Extended Price for Qty Sold IN
NOTETXTvarchar(8000)No Note Text for the line IN
STRTDATEdatetimeNo Start Date for Labor Hours IN
STRTTIMEdatetimeNo Start Time for Labor Hours IN
ENDDATEdatetimeNo End Date for Labor Hours IN
ENDTMEdatetimeNo End Time for Labor Hours IN
TRANSTMEnumeric(19,5)No Transaction Time for Labor Hours IN
BILLABLTIMnumeric(19,5)No Billable Time for Labor Hours IN
ENTDTEdatetimeNo Entry Date for the service call IN
ENTTMEdatetimeNo Entry Time for the service call IN
LABPCTnumeric(19,5)No Labor Percentage to be used from Contract IN
PARTPCTnumeric(19,5)No Parts Percentage to be used from Contract IN
MISCPCTnumeric(19,5)No Miscellaneous Percentage to be used from Contract IN
CKCREATEPOsmallintNo Flag to indicate whether to create a PO for the line IN
VENDORIDchar(15)No Vendor ID to be used for creating a PO for the item IN
PRMDATEdatetimeNo IN
Miles_StartintNo Starting Miles for Labor Lines IN
Miles_EndintNo Ending Miles for Labor Lines IN
Miles_UsedintNo Total Miles Used IN
PRICELVLchar(15)No Item Price Level IN
SVC_Address_OptionsmallintNo Address Based On. 1=Customer Address, 2=Tech Site, 3=Misc Address, 4=Transfer Header IN
SVC_Misc_Address_Codechar(15)No Misc Address. If SVC_Address_Option = 3 IN
SVC_Disable_XFR_GroupingtinyintNo Disable XFR Grouping. 0=False, 1=True IN
Work_Typechar(11)No Type of Work IN
SVC_FO_IDchar(51)No Service Front Office ID IN
CURNCYIDchar(15)No Currency ID IN
NonInventorysmallintNo Added on 10/26/09 to allow for NON-IV items. 0 = Inventory item, 1 = Non IV item IN
Create_Overtime_LaborsmallintNo Added on 11/16/09 to allow Overtime labor rates to be used for labor outside of Technician schedule IN
Overtime_Labor_Item_Numberchar(31)No Item Number for Overtime labor if automatic overtime is enabled, OvertimeLabor = 1 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 Error Code 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