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

taPMTransactionInsert

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
BACHNUMBchar(15)Yes Batch Number* IN
VCHNUMWKchar(17)Yes Voucher Number* IN
VENDORIDchar(15)Yes Vendor ID* IN
DOCNUMBRchar(20)Yes Document Number* IN
DOCTYPEsmallintYes1=Invoice 2=Finance Charge 3=Miscellaneous Charge 4=Return 5=Credit MemoIN
DOCAMNTnumeric(19,5)Yes Document Amount* <@I_vDOCAMNT = @I_vMSCCHAMT + @I_vPRCHAMNT + @I_vTAXAMNT + @I_vFRTAMNT - @I_vTRDISAMT>IN
DOCDATEdatetimeYes Document Date* IN
PSTGDATEdatetimeNo Posting Date* IN
VADCDTROchar(15)No Remit To Address ID* IN
VADDCDPRchar(15)No Primary Address ID* IN
PYMTRMIDchar(20)No Payment Terms ID* IN
TAXSCHIDchar(15)No Tax Schedule ID* IN
DUEDATEdatetimeNo Due Date* IN
DSCDLRAMnumeric(19,5)No Discount Dollar Amt* IN
DISCDATEdatetimeNo Discount Date* IN
PRCHAMNTnumeric(19,5)Yes Document Date* IN
CHRGAMNTnumeric(19,5)Yes Charge Amount* (@I_vDOCAMNT-@I_vCASHAMNT-@I_vCHEKAMNT-@I_vCRCRDAMT-@I_vDISTKNAM>IN
CASHAMNTnumeric(19,5)No Cash Amount* IN
CAMCBKIDchar(15)No Cash Amount Checkbook ID* IN
CDOCNMBRchar(20)Yes Cash Document Number* IN
CAMTDATEdatetimeNo Cash Amount Date* IN
CAMPMTNMchar(20)Yes Cash Amount Payment Number* IN
CHEKAMNTnumeric(19,5)No Cash Amount* IN
CHAMCBIDchar(15)No Check Amount Checkbook ID* IN
CHEKDATEdatetimeNo Check Amount Date* IN
CAMPYNBRchar(20)Yes Check Payment Number* <> IN
CRCRDAMTnumeric(19,5)No Cash Amount* IN
CCAMPYNMchar(20)Yes Credit Card Pyment Number* <> IN
CHEKNMBRchar(20)Yes Check Document Number* IN
CARDNAMEchar(15)Yes Credit Card Name* 0 IN
CCRCTNUMchar(20)Yes Credit Card Receipt Number* 0 IN
CRCARDDTdatetimeNo Credit Card Amount Date* IN
CHEKBKIDchar(15)Yes CheckBook ID* IN
TRXDSCRNchar(30)No Transaction Description* IN
TRDISAMTnumeric(19,5)Yes Document Date* IN
TAXAMNTnumeric(19,5)Yes Document Date* IN
FRTAMNTnumeric(19,5)Yes Document Date* IN
TEN99AMNTnumeric(19,5)No 1099 Amount* IN
MSCCHAMTnumeric(19,5)Yes Document Date* IN
PORDNMBRchar(20)No Purchase Order Number* IN
SHIPMTHDchar(15)No Shipping Method* IN
DISAMTAVnumeric(19,5)No Discount Amount Available* IN
DISTKNAMnumeric(19,5)No Cash Amount* IN
APDSTKAMnumeric(19,5)No Applied Discount Taken Amount* IN
MDFUSRIDchar(15)No Modified User ID* IN
POSTEDDTdatetimeNo Posted Date* IN
PTDUSRIDchar(15)No Posted User ID* IN
PCHSCHIDchar(15)No Purchase Schedule ID* IN
FRTSCHIDchar(15)No Freight Schedule ID* IN
MSCSCHIDchar(15)No Misc Schedule ID* IN
PRCTDISCnumeric(19,5)No Percent Discount IN
Tax_DatedatetimeNo Tax 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
BatchCHEKBKIDchar(15)No Checkbook ID for the batch IN
CREATEDISTsmallintNo Flag to auto create distributions: 0=Manual; 1=Automatic - use if not calling taPMDistribution node 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
ErrorStateintNo INOUT
oErrStringvarchar(255)No 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