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

taAnalyticsDistribution

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
DOCNMBRvarchar(50)Yes Document Number IN
DOCTYPEsmallintYes Document Type IN
AMOUNTnumeric(19,5)No Amount IN
aaAssignedPercentnumeric(19,5)No Assign % IN
DistSequenceintNo Distribution Sequence Number IN
ACTNUMSTvarchar(75)No Account Number String - include seperator character IN
ACTINDXintNo Account Index IN
DistRefchar(31)No Distribution Reference IN
NOTETEXTvarchar(8000)No Notes field IN
aaTrxDimchar(31)Yes Transaction Dimension IN
aaTrxDimCodechar(31)No Transaction Dimension Alphanumeric IN
aaTrxDimCodeNumnumeric(19,5)No Transaction Dimension Numeric IN
aaTrxDimCodeBoolsmallintNo Transaction Dimension Yes/No IN
aaTrxDimCodeDatedatetimeNo Transaction Dimension Date IN
aaTrxDimIDintYes Transaction Dimension ID IN
aaTrxCodeIDintNo Transaction Dimension Code ID IN
aaSubLedgerHdrIDintNo SubLedger Header Lookup IN
aaSubLedgerDistIDintNo SubLedger Dist Lookup IN
aaSubLedgerAssignIDintNo SubLedger Assign Lookup IN
UpdateIfExistssmallintNo 0 = do not update, 1 = update if exists IN
RequesterTrxsmallintNo Requester Transaction - 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
SeriessmallintNoAdded the Parameter @I_vSeries to identify the series of the transaction, @I_vSeries=2 for a GL Trx. Fix for Bug ID#72286IN
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