Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Skip Navigation LinkseConnect Module : Type : Node : Fields Easy Navigation

taSopHdrIvcInsert

eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
SOPTYPEsmallintYes1=QUOTE,2=ORDER,3=INVOICE,4=RETURN,5=BKORDER,6=FULFILLMENT ORDER IN
DOCIDchar(15)YesDocument ID, key field in SOP40200 IN
SOPNUMBEchar(21)YesInvoice Number IN
ORIGNUMBchar(21)NoOrder Number IN
ORIGTYPEsmallintNoDocument Type of the Originating SOP Document - 0 if this is original document IN
TAXSCHIDchar(15)YesTax Schedule if you have taxes IN
FRTSCHIDchar(15)NoFreight Schedule - optional IN
MSCSCHIDchar(15)NoMisc Tax Schedule - optional IN
SHIPMTHDchar(15)NoShipping Method IN
TAXAMNTnumeric(19,5)YesTax Amount if line items have tax IN
LOCNCODEchar(10)NoWill use default from IV if empty IN
DOCDATEdatetimeYesDocument Date IN
FREIGHTnumeric(19,5)NoFreight amount IN
MISCAMNTnumeric(19,5)NoMisc amount IN
TRDISAMTnumeric(19,5)NoTrade Discount Amount IN
TRADEPCTnumeric(19,5)NoTrade Discount Percentage IN
DISTKNAMnumeric(19,5)NoDiscount Taken Amount IN
MRKDNAMTnumeric(19,5)NoMarkdown Amount IN
CUSTNMBRchar(15)YesCustomer Number IN
CUSTNAMEchar(64)NoCustomer Name IN
CSTPONBRchar(20)NoCustomer Purchase Order Number IN
ShipToNamechar(64)NoShip to Name IN
ADDRESS1char(60)NoCustomer Address One IN
ADDRESS2char(60)NoCustomer Address Two IN
ADDRESS3char(60)NoCustomer Address Three IN
CNTCPRSNchar(60)NoContact Person IN
FAXNUMBRchar(21)NoFax Number IN
CITYchar(35)NoCustomer City IN
STATEchar(29)NoCustomer State IN
ZIPCODEchar(10)NoCustomer Zip IN
COUNTRYchar(60)NoCustomer Country IN
PHNUMBR1char(21)NoPhone one IN
PHNUMBR2char(21)NoPhone two IN
PHNUMBR3char(21)NoPhone three - Added for Release 6.0 IN
Print_Phone_NumberGBsmallintNo IN
SUBTOTALnumeric(19,5)YesSubtotal = Total before taxes IN
DOCAMNTnumeric(19,5)YesDocument Amount/Total IN
PYMTRCVDnumeric(19,5)YesTotal of all Deposits and Payments IN
SALSTERRchar(15)NoSales Territory IN
SLPRSNIDchar(15)NoSales Person ID IN
UPSZONEchar(3)NoUPS Zone IN
USER2ENTchar(15)NoUser Who Entered IN
BACHNUMBchar(15)NoBatch Number IN
PRBTADCDchar(15)NoPrimary Bill to Address Code IN
PRSTADCDchar(15)NoPrimary Ship to Address Code IN
FRTTXAMTnumeric(19,5)NoFreight Tax Amount IN
MSCTXAMTnumeric(19,5)NoMisc Tax Amount IN
ORDRDATEdatetimeNoOrder Date IN
MSTRNUMBintNoMaster Number, defaults to next number if 0 IN
PYMTRMIDchar(20)NoPayment term id, defaults from customer if not passed in IN
DUEDATEdatetimeNoDue Date IN
DISCDATEdatetimeNoDiscount Date IN
REFRENCEchar(30)NoGL Reference IN
USINGHEADERLEVELTAXESintNoHeader Level Taxes IN
BatchCHEKBKIDchar(15)NoCheckbook ID for the batch IN
CREATECOMMsmallintNoFlag to auto create commissions: 0=Manual; 1=Automatic - use if not callind taSopCommissions node IN
COMMAMNTnumeric(19,5)NoTotal Amount of commissions for this document - Used with Manual Commissions IN
COMPRCNTnumeric(19,5)NoUsed for ALL salespeople if passed in and @I_vCREATECOMM = 1; leave blank to use default percentages IN
CREATEDISTsmallintNoFlag to auto create distributions: 0=Manual; 1=Automatic - use if not calling taSopDistribution node IN
CREATETAXESsmallintNoFlag to auto create taxes with tax engine, leave at 0 if integrating your own IN
DEFTAXSCHDSsmallintNoFlag to default tax schedules based on setup, only used for Freight and Misc. - see help file for Line Item IN
CURNCYIDchar(15)NoCurrency ID - 02/10/02 - Added for Multi-Currency IN
XCHGRATEnumeric(19,5)NoExchange Rate - 02/10/02 - Added for Multi-Currency - MC020103 IN
RATETPIDchar(15)NoRate Type ID - 02/10/02 - Added for Multi-Currency - MC020103 IN
EXPNDATEdatetimeNoExpiration Date - 02/10/02 - Added for Multi-Currency - MC00100 IN
EXCHDATEdatetimeNoExchange Date - 02/10/02 - Added for Multi-Currency - MC00100 IN
EXGTBDSCchar(30)NoExchange ID Desc. - 02/10/02 - Added for Multi-Currency - MC40300 IN
EXTBLSRCchar(50)NoExchange Rate Source - 02/10/02 - Added for Multi-Currency - MC40300 IN
RATEEXPRsmallintNoRate Expiration - 02/10/02 - Added for Multi-Currency - MC40300 IN
DYSTINCRsmallintNoDays to Increment - 02/10/02 - Added for Multi-Currency - MC40300 - only used when RATEEXPR = 8IN
RATEVARCnumeric(19,5)NoRate Variance - 02/10/02 - Added for Multi-Currency - MC40300 IN
TRXDTDEFsmallintNoTrx Date Default - 02/10/02 - Added for Multi-Currency - MC40300 IN
RTCLCMTDsmallintNoRate Calc. Method - 02/10/02 - Added for Multi-Currency - MC40300 IN
PRVDSLMTsmallintNoPrevious Days Limits - 02/10/02 - Added for Multi-Currency - MC40300 IN
DATELMTSsmallintNoDate Limits - 02/10/02 - Added for Multi-Currency - MC40300 IN
TIME1datetimeNoTime 1 - 08/20/01 - 03/11/02 - Added for Multi-Currency - MC40300 IN
DISAVAMTnumeric(19,5)NoDISAVAMT IN
DSCDLRAMnumeric(19,5)NoDiscount Dollar Amount IN
DSCPCTAMnumeric(19,5)NoDiscount Percent Amount IN
FREIGTBLEintNoFreight Taxable 0=default from Sop Setup 1=Taxable 2=Non-taxable 3=Base on Customers IN
MISCTBLEintNoMisc Amount Taxable 0=default from Sop Setup 1=Taxable 2=Non-taxable 3=Base on Customers IN
COMMNTIDchar(15)NoComment ID IN
COMMENT_1char(50)Nonot required IN
COMMENT_2char(50)Nonot required IN
COMMENT_3char(50)Nonot required IN
COMMENT_4char(50)Nonot required IN
GPSFOINTEGRATIONIDchar(30)NoFront Office Integration ID IN
INTEGRATIONSOURCEsmallintNoIntegration Source IN
INTEGRATIONIDchar(30)NoIntegration ID IN
ReqShipDatedatetimeNoRequested Ship Date IN
RequesterTrxsmallintNoRequester Transaction - 0=false,1=true - if true than populates Requester shadow table IN
CKCreditLimittinyintNo0 - Do Not check credit limit; 1 - check credit limit IN
CKHOLDtinyintNo0 - Do Not check Hold status; 1 - check Hold status IN
UpdateExistingtinyintNoUsed to modify header - 0=New Transaction; 1=Update Header - used to update after transaction exists IN
QUOEXPDAdatetimeNoQuote Expiration Date - Defaults baed on setup if not filled in IN
QUOTEDATdatetimeNoQuote Date - Used for SOPTYPE <> 1, if SOPTYPE = 1 then DOCDATE is used IN
INVODATEdatetimeNoInvoice Date - Used for SOPTYPE <> 3, if SOPTYPE = 3 then DOCDATE is used IN
BACKDATEdatetimeNoBackorder Date - Used for SOPTYPE <> 4, if SOPTYPE = 4 then DOCDATE is used IN
RETUDATEdatetimeNoReturn Date - Used for SOPTYPE <> 5, if SOPTYPE = 5 then DOCDATE is used IN
CMMTTEXTvarchar(500)NoComment Text; only use if not using @I_vCOMMENT_1 thu @I_vCOMMENT_4 IN
PRCLEVELchar(10)NoPrice Level IN
DEFPRICINGtinyintNo1 = subtotal will be calculated from Sop Lines IN
TAXEXMT1char(25)NoTax Exempt #1 - - will default from Customer if not supplied IN
TAXEXMT2char(25)NoTax Exempt #2 - - will default from Customer if not supplied IN
TXRGNNUMchar(25)NoTax Registration Number - - will default from Customer if not supplied IN
REPTINGtinyintNoRepeating - - 0=False & 1=True - only valid for Quotes IN
TRXFREQUsmallintNoFrequency - - 1=Weekly, 2=Biweekly, 3=Semimonthly, 4=Monthly, 5=Bi-Monthly, 6=Quarterly, & 7=Misc. only valid for Quotes IN
TIMETREPsmallintNoTimes Repeating - - only valid for Quotes IN
QUOTEDYSTINCRsmallintNoDays to Increment - - only valid for Quotes IN
NOTETEXTvarchar(8000)NoNotes field IN
USRDEFND1char(50)NoUser Defined field - developer use only IN
USRDEFND2char(50)NoUser Defined field - developer use only IN
USRDEFND3char(50)NoUser Defined field - developer use only IN
USRDEFND4varchar(8000)NoUser Defined field - developer use only IN
USRDEFND5varchar(8000)NoUser Defined field - developer use only IN
ErrorStateintNoError Code INOUT
oErrStringvarchar(255)NoComma separated list of errors encountered 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
site