DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
RachelW 6/14/2018 11:10:23 AM

taCreateCustomerItems complete text

* This article, and all our great eConnect documentation, Is available on the eConnect menu

The complete text of the taCreateCustomerItems stored procedure. First 50 lines or so shown below.

CREATE PROCEDURE dbo.taCreateCustomerItems
    @I_vITEMNMBR CHAR(30),
    @I_vCUSTNMBR CHAR(15),
    @I_vCUSTITEMNMBR CHAR(30) = '',
    @I_vCUSTITEMDESC CHAR(50) = '',
    @I_vCUSTITEMSHORNAME CHAR(15) = '',
    @I_vCUSTITEMGENERICDESC CHAR(10) = '',
    @I_vUSERDEF1 CHAR(20) = '',
    @I_vUSERDEF2 CHAR(20) = '',
    @I_vUSRDEF03 CHAR(20) = '',
    @I_vUSRDEF04 CHAR(20) = '',
    @I_vUSRDEF05 CHAR(20) = '',
    @I_vSUBITEMNMBR CHAR(30) = '',
    @I_vSTRTDATE DATETIME = '',
    @I_vENDDATE DATETIME = '',
    @I_vRequesterTrx SMALLINT = 0,
    @I_vUSRDEFND1 CHAR(50) = '',
    @I_vUSRDEFND2 CHAR(50) = '',
    @I_vUSRDEFND3 CHAR(50) = '',
    @I_vUSRDEFND4 VARCHAR(8000) = '',
    @I_vUSRDEFND5 VARCHAR(8000) = '',
    @O_iErrorState INT OUTPUT,
    @oErrString VARCHAR(255) OUTPUT
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET NOCOUNT ON;
DECLARE @SUBITEMDESC CHAR(50),
        @NOTEINDX DECIMAL(19, 5),
        @CMPANYID SMALLINT,
        @iGetNextNoteIdxErrState INT,
        @iAddCodeErrState INT,
        @iStatus INT,
        @iCustomState INT,
        @iCustomErrString VARCHAR(255),
        @O_oErrorState INT,
        @iError INT;
SELECT @SUBITEMDESC = '',
       @NOTEINDX = 0,
       @iStatus = 0,
       @O_iErrorState = 0;
IF (@oErrString IS NULL)
BEGIN
    SELECT @oErrString = '';
END;
EXEC @iStatus = taCreateCustomerItemsPre @I_vITEMNMBR OUTPUT,
                                         @I_vCUSTNMBR OUTPUT,
                                         @I_vCUSTITEMNMBR OUTPUT,
                                         @I_vCUSTITEMDESC OUTPUT,
                                         @I_vCUSTITEMSHORNAME OUTPUT,
                                         @I_vCUSTITEMGENERICDESC OUTPUT,
                                         @I_vUSERDEF1 OUTPUT,
                                         @I_vUSERDEF2 OUTPUT,
                                         @I_vUSRDEF03 OUTPUT,
                                         @I_vUSRDEF04 OUTPUT,
                                         @I_vUSRDEF05 OUTPUT,
                                         @I_vSUBITEMNMBR OUTPUT,
                                         @I_vSTRTDATE OUTPUT,
                                         @I_vENDDATE OUTPUT,
                                         @I_vRequesterTrx OUTPUT,
                                         @I_vUSRDEFND1 OUTPUT,
                                         @I_vUSRDEFND2 OUTPUT,
                                         @I_vUSRDEFND3 OUTPUT,
                                         @I_vUSRDEFND4 OUTPUT,
                                         @I_vUSRDEFND5 OUTPUT,
                                         @O_iErrorState = @iCustomState OUTPUT,
                                         @oErrString = @iCustomErrString OUTPUT;
SELECT @iError = @@error;
Version: All
Section: eConnect,SQL Scripts