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

taRMTransaction

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
RMDTYPALsmallintYes RM Type 1=Sales/Invoice 2=Debit Memo 3=Finance Charge 4=Service/Repair 5=Warranty IN
DOCNUMBRchar(20)Yes Document Number IN
DOCDATEdatetimeYes Document Date IN
BACHNUMBchar(15)Yes Batch Number IN
CUSTNMBRchar(15)Yes Customer Number IN
DOCAMNTnumeric(19,5)Yes Document Amount IN
SLSAMNTnumeric(19,5)Yes Sales Amount IN
DOCDESCRchar(30)No Document Description IN
ADRSCODEchar(15)No Address Code IN
SLPRSNIDchar(15)No Salesperson ID IN
SALSTERRchar(15)No Sales Territory IN
SHIPMTHDchar(15)No Shipping Method IN
TAXSCHIDchar(15)No Tax Schedule ID IN
CSTPONBRchar(20)No Customer PO Number IN
COSTAMNTnumeric(19,5)No Cost Amount IN
TRDISAMTnumeric(19,5)No Trade Discount Amount IN
TRDDISCTsmallintNo Trade Discount IN
FRTAMNTnumeric(19,5)No Freight Amount IN
MISCAMNTnumeric(19,5)No Miscellenous Amount IN
TAXAMNTnumeric(19,5)No Tax Amount IN
BKTSLSAMnumeric(19,5)No Backout Sales Amount IN
BKTFRTAMnumeric(19,5)No Backout Freight Amount IN
BKTMSCAMnumeric(19,5)No Backout Misc. Amount IN
CASHAMNTnumeric(19,5)No Cash Amount IN
CBKIDCSHchar(15)No Checkbook ID Cash IN
CASHDATEdatetimeNo Cash Date IN
DCNUMCSHchar(20)No Document Number Cash IN
CHEKAMNTnumeric(19,5)No Check Amount IN
CBKIDCHKchar(15)No Checkbook ID Check IN
CBKIDCRDchar(15)No Checkbook ID Credit Card IN
CHEKNMBRchar(20)No Check Number IN
CHEKDATEdatetimeNo Check Date IN
DCNUMCHKchar(20)No Document Number of the Check IN
CRCRDAMTnumeric(19,5)No Credit Card Amount IN
CRCRDNAMchar(15)No Credit Card Name IN
RCTNCCRDchar(20)No Receipt Numb. for C.Card IN
CRCARDDTdatetimeNo Credit Card Date IN
DCNUMCRDchar(20)No Document Number for C.Card IN
DISCRTNDnumeric(19,5)No Discount Returned IN
DISTKNAMnumeric(19,5)No Discount Taken Amount IN
WROFAMNTnumeric(19,5)No Write Off Amt for Credit Docs IN
PPSAMDEDnumeric(19,5)No PPS Amt Deducted for Credits IN
GSTDSAMTnumeric(19,5)No GST Discount Amount IN
PYMTRMIDchar(20)No Payment Term ID IN
DISAVAMTnumeric(19,5)No Discount Avail. Amount IN
DSCDLRAMnumeric(19,5)No Discount Dollar Amount IN
DSCPCTAMnumeric(19,5)No Discount Percent Amount IN
LSTUSREDchar(15)No Last User to Edit IN
PTDUSRIDchar(15)No Posted User ID IN
DistRefchar(30)No Distribution Reference IN
BatchCHEKBKIDchar(15)No Checkbook ID for the batch IN
DUEDATEdatetimeNo Due Date IN
DISCDATEdatetimeNo Discount Date IN
CURNCYIDchar(15)No Currency ID - 08/20/01 - Added for Multi-Currency IN
XCHGRATEnumeric(19,5)No Exchange Rate - 08/20/01 - Added for Multi-Currency - MC020103 IN
RATETPIDchar(15)No Rate Type ID - 08/20/01 - Added for Multi-Currency - MC020103 IN
EXPNDATEdatetimeNo Expiration Date - 08/20/01 - Added for Multi-Currency - MC00100 IN
EXCHDATEdatetimeNo Exchange Date - 08/20/01 - Added for Multi-Currency - MC00100 IN
EXGTBDSCchar(30)No Exchange ID Desc. - 08/20/01 - Added for Multi-Currency - MC40300 IN
EXTBLSRCchar(50)No Exchange Rate Source - 08/20/01 - Added for Multi-Currency - MC40300 IN
RATEEXPRsmallintNo Rate Expiration - 08/20/01 - Added for Multi-Currency - MC40300 IN
DYSTINCRsmallintNo Days to Increment - 08/20/01 - Added for Multi-Currency - MC40300 only used when RATEEXPR = 8 IN
RATEVARCnumeric(19,5)No Rate Variance - 08/20/01 - Added for Multi-Currency - MC40300 IN
TRXDTDEFsmallintNo Trx Date Default - 08/20/01 - Added for Multi-Currency - MC40300 IN
RTCLCMTDsmallintNo Rate Calc. Method - 08/20/01 - Added for Multi-Currency - MC40300 IN
PRVDSLMTsmallintNo Previous Days Limits - 08/20/01 - Added for Multi-Currency - MC40300 IN
DATELMTSsmallintNo Date Limits - 08/20/01 - Added for Multi-Currency - MC40300 IN
TIME1datetimeNo Time 1 - 08/20/01 - 03/11/02 - Added for Multi-Currency - MC40300 IN
COMDLRAMnumeric(19,5)No Commission Amount IN
COMAPPTOsmallintNo Commission Apply To IN
RequesterTrxsmallintNo Requester Transaction - 0=false,1=true - if true than populates Requester shadow table IN
CREATEDISTsmallintNo Flag to auto create distributions: 0=Manual; 1=Automatic 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 Return value: 0=No Errors, 1=Error Occurred INOUT
oErrStringvarchar(255)No Return Error Code List 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
3