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

taRMSchedPmnts

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
ORIG_DOC_NUMBERchar(21)Yes Original Document Number IN
ORIG_DOC_TYPEsmallintYes Original Document Type 1=Sales/Invoice; 3=Debit Memos; 5=Service/Repairs IN
REC_OFFSET_ACCT_IDXintYes Receivables Offset Account Index Either Index or String required IN
RecOffsetAccountvarchar(75)Yes Receivables Offset Account String Either Index or String required IN
FIRST_INV_DOC_DATEdatetimeYes First Invoice Document Date reqrd if payment freq is 1 semimnthlyIN
FIRST_INV_DUE_DATEdatetimeYes First Invoice Due Date reqrd if payment freq is 1 semimnthlyIN
INT_INCOME_ACCT_IDXintYes Interest Income Account Index required if interest rate entered IN
IntIncomeAccountvarchar(75)Yes Interest Income Account Strng required if interest rate entered IN
PAYMENT_AMOUNTnumeric(19,5)Yes Payment Amount IN
NUM_PAYMENTSsmallintYes Number of Payments IN
SCHEDULE_NUMBERchar(21)No Schedule Number IN
PYMNT_FREQUENCYsmallintNo Payment Frequency 1=Semimonthly; 2=Monthly; 3=Quarterly; 4=Semiannual; 5=Annual IN
REC_ACCT_IDXintNo Receivables Account Index IN
RecAccountvarchar(75)No Receivables Account String IN
SCH_DOC_DATEdatetimeNo Schedule Document Date IN
SCHEDULE_AMOUNTnumeric(19,5)No Schedule Amount IN
SCHEDULE_DESCchar(31)No Schedule Description IN
SCHEDULE_INT_RATEnumeric(19,5)No Schedule Interest Rate front end allows negative interest but this will not IN
SCHEDULE_INT_TYPE1smallintNo Schedule Interest Type 0=Compound, 1=Simple IN
RequesterTrxsmallintNo Requester Transaction - 0=false,1=true -if true than populates Requester shadow tableIN
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
USRDEFND4char(8000)No User Defined field - developer use only IN
USRDEFND5char(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 - Multiple error conditions are returned 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