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

taPMSchedPmnts

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
ORIG_VOUCHER_NUMchar(21)Yes Original Voucher Number IN
ORIG_DOC_TYPEsmallintYes Original Document Type 1=Invoice or 3=Misc Charge IN
PAY_OFFSET_ACCT_IDXintYes Payables Offset Account Index Either Index or String required IN
PayOffsetAccountvarchar(75)Yes Payables 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_EXP_ACCT_IDXintYes Interest Expense Account Index required if interest rate enteredIN
IntExpenseAccountvarchar(75)Yes Interest Expense Account String required if interest rate enteredIN
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
PAY_ACCT_IDXintNo Accounts Payable Account Index IN
PayAccountvarchar(75)No Accounts Payable 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
USERIDchar(15)No User ID used to update the PM Keys 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