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

taFSRMALine

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
Return_Record_TypesmallintNo Return Record Type, 1=Open, 2=Closed IN
RETDOCIDchar(15)No Return Document ID IN
LNSEQNBRnumeric(19,5)No Line Sequence Number IN
RETTYPEchar(11)No Return Type IN
RETSTATchar(3)No Line Return Status IN
CUSTNMBRchar(15)No Customer Number IN
ADRSCODEchar(15)No Address Code of customer IN
ITEMNMBRchar(31)No Item Number IN
ITEMDESCchar(101)No Item Description IN
LOCNCODEchar(11)No Location Code of the item IN
SVC_Ready_To_ClosetinyintNo Flag to indicate line is ready for closing. 0=No, 1=Ready IN
SVC_RMA_Reason_Codechar(3)No RMA Reason Code IN
NOTETXTnvarchar(2000)No Notes for the line IN
RETORIGsmallintNo Flag to indicate Return Origin. 1=None, 2=Service Call, 3=SOP IN
RETREFchar(31)No Return Reference IN
EQPLINEintNo Equipment Line Sequence of Service Call Part line IN
LNITMSEQintNo Line Item Sequence of Service Call Part line IN
SVC_RMA_From_ServicetinyintNo Flag to indicate whether RMA created from Service Call. 0=No, 1=Yes IN
CMPNTSEQintNo Component Sequence number of SOP Document Line IN
SOP_Line_Item_SequenceintNo SOP Document Line Sequence Number IN
ENTDTEdatetimeNo Entry Date for the return line IN
ENTTMEdatetimeNo Entry Time for the return line IN
ETADTEdatetimeNo ETA Date for the return line IN
ETATMEdatetimeNo ETA Time for the return line IN
Commit_DatedatetimeNo Commit Date for the return line IN
Commit_TimedatetimeNo Commit Time for the return line IN
RETUDATEdatetimeNo Actual Date of returning the item IN
Return_TimedatetimeNo Actual Time of returning the item IN
COMPDTEdatetimeNo Completed date of return line IN
COMPTMEdatetimeNo Completed time of return line IN
PRMDATEdatetimeNo Promised date of return IN
USERIDchar(15)No Create or last modified User ID IN
OFFIDchar(11)No Office ID IN
RTRNNAMEchar(45)No Name of the person to return to IN
RETADDR1char(61)No Address line 1 of return address IN
RETADDR2char(61)No Address line 2 of return address IN
RETADDR3char(61)No Address line 3 of return address IN
RTRNCITYchar(21)No City of return address IN
SVC_Return_Statechar(29)No State of return address IN
RTRNZIPchar(11)No Zip Code of return address IN
Return_Countrychar(61)No Country of return address IN
CUSTNAMEchar(65)No Customer Name IN
CONTACTchar(61)No Name of Contact Person IN
ADDRESS1char(61)No Address line 1 of customer IN
ADDRESS2char(61)No Address line 2 of customer IN
ADDRESS3char(61)No Address line 3 of customer IN
CITYchar(35)No City of customer's address IN
STATEchar(29)No State of customer's address IN
ZIPCODEchar(11)No Zip Code of customer's address IN
COUNTRYchar(61)No Country of customer's address IN
CSTPONBRchar(21)No Customer PO Number, if any IN
QUANTITYnumeric(19,5)No Quantity being returned IN
UOFMchar(9)No Unit of Measure of the returned item IN
UNITCOSTnumeric(19,5)No Unit Cost of the item IN
UNITPRCEnumeric(19,5)No Unit Price of the Item IN
XTNDPRCEnumeric(19,5)No Extended Price of the Item IN
CUSTOWNtinyintNo Flag to indicate customer owned item. 0=No, 1=Yes IN
FACTSEALtinyintNo Flag to indicate whether item was factory seales. 0=No, 1=Yes IN
Flat_Rate_Repair_Pricenumeric(19,5)No Flat Rate Repair Price IN
Repair_Pricenumeric(19,5)No Actual Repair Price, if not Flat Rate IN
NTE_Pricenumeric(19,5)No NTE Price, if any IN
Repair_Costnumeric(19,5)No Repair Cost IN
Bill_of_Ladingchar(31)No Bill of Lading number, if any IN
SHIPMTHDchar(15)No Shipping Method IN
Location_Code_Replacemenchar(11)No Location Code for Replacement IN
Replace_Item_Numberchar(31)No Replacing Item Number if being replaced by another item IN
Replace_U_Of_Mchar(9)No Unit of Measure of Replacing Item Number IN
Replace_Price_Levelchar(11)No Price Level of Replacing Item Number IN
Replace_QTYnumeric(19,5)No Quantity of item being replaced IN
Replace_Costnumeric(19,5)No Cost of item being replaced IN
Replace_Pricenumeric(19,5)No Price Level of Replacing Item Number IN
Item_Number_Invoicechar(31)No Item Number used in SOP Invoice for return IN
USERDEF1char(21)No User Comments for return line IN
USERDEF2char(21)No User Comments for return line IN
USRDEF03char(21)No User Comments for return line IN
USRDEF04char(21)No User Comments for return line IN
USRDEF05char(21)No User Comments for return line IN
CURNCYIDchar(15)No Currency ID used in return IN
Return_Item_Numberchar(31)No Item Number being returned to Customer IN
Return_Item_Descriptionchar(51)No Description of Item Number being returned IN
Return_Location_Codechar(11)No Location Code being returned to IN
Return_QTYnumeric(19,5)No Quantity of item being returned IN
Return_U_Of_Mchar(9)No Unit of Measure of item being returned IN
RETCOSTnumeric(19,5)No Unit Cost of returning item IN
SVC_Return_Price_Levelchar(11)No Price Level of item being returned IN
SVC_Return_Pricenumeric(19,5)No Price Level of item being returned IN
SVC_Extended_Return_Pricnumeric(19,5)No Extended Price for returning item IN
SVC_FO_IDchar(51)No FO ID IN
SVC_SCM_CompletesmallintNo Flag to indicate whether SCM was completed 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