Skip to main content
Skip table of contents

wsiJCJobEstimates

Table: JC00401

Element NameData TypeLengthRequiredDefaultDescription

@I_vCostCodeEstimatedUnits

numeric

19,5




@I_vCostElement

smallint

 




@I_vCostElementDescription

char

15




@I_vCustomerNumber

char

15




@I_vEstimatedAmtUnits

numeric

19,5




@I_vOnlyValidate

tinyint

 




@I_vReturnErrorText

tinyint

 




@I_vScheduleDate

datetime

 




@I_vShortDescription

char

31




@I_vSVLanguageID

smallint

 




@I_vTimeZone

char

3




@I_vTransactionAmount

numeric

19,5




@I_vTransactionDate

datetime

 




@I_vTransactionDocNumber

numeric

19,5




@I_vUpdateIfExists

tinyint

 




@I_vUserDefine1

char

31




@I_vUserDefine2

char

31




@I_vUserDefined1

char

21




@I_vUserDefined2

char

21




@I_vUserDefinedCB1

tinyint

 




@I_vUserDefinedCB2

tinyint

 




@I_vUserDefinedCB3

tinyint

 




@I_vUserDefinedCB4

tinyint

 




@I_vUserDefinedDate1

datetime

 




@I_vUserDefinedDate2

datetime

 




@I_vUserDefinedDollar1

numeric

19,5




@I_vUserDefinedDollar2

numeric

19,5




@I_vUserDefinedDollar3

numeric

19,5




@I_vUserDefinedDollar4

numeric

19,5




@I_vUserDefinedInteger1

int

 




@I_vUserDefinedInteger2

int

 




@I_vUserDefinedInteger3

int

 




@I_vUserDefinedInteger4

int

 




@I_vUserID

char

15




@I_vUSRDEFND1

char

50




@I_vUSRDEFND2

char

50




@I_vUSRDEFND3

char

50




@I_vUSRDEFND4

varchar

8000




@I_vUSRDEFND5

varchar

8000




@I_vWennsoftAffiliate

char

15




@I_vWennsoftBranch

char

15




@I_vWennsoftRegion

char

15




@I_vWennSoftTablesOnly

tinyint

 




@I_vWSCostCodeNumber1

char

7




@I_vWSCostCodeNumber2

char

7




@I_vWSCostCodeNumber3

char

7




@I_vWSCostCodeNumber4

char

7




@I_vWSJobNumber

char

17




@I_vWSManagerID

char

15




@I_vWSProjectNumber

char

17




@I_vWSReservedCB1

tinyint

 




@I_vWSReservedCB10

tinyint

 




@I_vWSReservedCB2

tinyint

 




@I_vWSReservedCB3

tinyint

 




@I_vWSReservedCB4

tinyint

 




@I_vWSReservedCB5

tinyint

 




@I_vWSReservedCB6

tinyint

 




@I_vWSReservedCB7

tinyint

 




@I_vWSReservedCB8

tinyint

 




@I_vWSReservedCB9

tinyint

 




@I_vWSReservedSTR1

char

11




@I_vWSReservedSTR2

char

11




@I_vWSUserDefinedDate3

datetime

 




@I_vWSUserDefinedDate4

datetime

 




@O_iErrorState

int

 




@oErrString

varchar

255




Error Codes

Error CodeDescription

10004

Transaction date is not within an open fiscal year.

51090

The Project Number does not exist.

51118

The project manager does not exist in the payroll master table.

51200

The cost code number is blank.

51202

The job is blank.

51203

The cost element is blank.

51204

The cost element does not exist in the cost element setup table.

51300

The Transaction Date field is blank.

51301

Cannot import estimates because the cost code number does not exist.

51302

Cannot import estimates because a password is setup for Revise Estimate Cost.

51412

Database error inserting records into table JC00401.

52100

The description field is blank.

52418

Error updating record in the JC00401 table.

52481

The Transaction Amount cannot be zero.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.