wsiJCChangeOrdersMSTR

@I_vWSJobNumber

char

17

Yes

'

I_vWSJobNumber is an existing job and is an active job

@I_vWSProjectNumber

char

17

No

'

I_vWSProjectNumber is an existing project and is an active project and is assigned to the job

@I_vChangeOrderNum

char

15

Yes

'

I_vChangeOrderNum must contain a value, I_vChangeOrderNum must not exist on a job if I_vUpdateIfExists is 0

@I_vChangeOrderStatus

smallint

5

No

0

I_vChangeOrderStatus must be in the range 1 thru 5

@I_vChangeOrderDescription

char

31

No

'

I_vChangeOrderDescription must contain a value

@I_vChangeOrderType

smallint

5

No

0

I_vChangeOrderType must be a value of 1 (Fixed Amount), 2 (Cost Plus), or 3 (Cost Plus NTE), I_vChangeOrderType must be a value of 1 (Fixed Amount) for jobs with billing type 6 (SOP Billing), If I_vChangeOrderType is 3 (Cost Plus NTE), then the job must have a contract type of 3 (Cost Plus NTE)

@I_vChangeOrderEstimatedCost

numeric

19,5

No

0

I_vChangeOrderEstimatedCost must be zero for I_vChangeOrderType values 2 (Cost Plus) and 3 (Cost Plus NTE)

@I_vConfirmedModifiedDate

datetime

No

01/01/1900'

@I_vOriginatingChangeOrderAmount

numeric

19,5

No

0

@I_vExchangeRate

numeric

19,7

No

0

@I_vExchangeDate

datetime

No

01/01/1900'

@I_vRateTypeID

char

15

No

'

@I_vExchangeTableID

char

15

No

'

@I_vTime

datetime

No

01/01/1900'

@I_vConfirmedModifiedTime

datetime

No

01/01/1900'

@I_vConfirmedModifiedUserID

char

15

No

'

@I_vInProcessModifiedDate

datetime

No

01/01/1900'

@I_vInProcessModifiedTime

datetime

No

01/01/1900'

@I_vInProcessModifiedUserID

char

15

No

'

@I_vCOUD1ModifiedDate

datetime

No

01/01/1900'

@I_vCOUD1ModifiedTime

datetime

No

01/01/1900'

@I_vCOUD1ModifiedUserID

char

15

No

'

@I_vCOUD2ModifiedDate

datetime

No

01/01/1900'

@I_vCOUD2ModifiedTime

datetime

No

01/01/1900'

@I_vCOUD2ModifiedUserID

char

15

No

'

@I_vCOUD3ModifiedDate

datetime

No

01/01/1900'

@I_vCOUD3ModifiedTime

datetime

No

01/01/1900'

@I_vCOUD3ModifiedUserID

char

15

No

'

@I_vUserDefinedCO1

char

15

No

'

@I_vUserDefinedCO2

char

15

No

'

@I_vUserDefinedCO3

char

15

No

'

@I_vUserDefinedCO4

char

15

No

'

@I_vUserDefinedDate1

datetime

No

01/01/1900'

@I_vUserDefinedDate2

datetime

No

01/01/1900'

@I_vWSUserDefinedDate3

datetime

No

01/01/1900'

@I_vWSUserDefinedDate4

datetime

No

01/01/1900'

@I_vEstEquipmentCost

numeric

19,5

No

0

@I_vEstLaborCost

numeric

19,5

No

0

@I_vEstLaborUnitsTTD

numeric

19,5

No

0

@I_vPayRate

numeric

19,5

No

0

@I_vEstMaterialCost

numeric

19,5

No

0

@I_vEstMiscOtherCost

numeric

19,5

No

0

@I_vEstSubsCost

numeric

19,5

No

0

@I_vEstCostUserDefined1

numeric

19,5

No

0

@I_vEstCostUserDefined2

numeric

19,5

No

0

@I_vEstCostUserDefined3

numeric

19,5

No

0

@I_vEstCostUserDefined4

numeric

19,5

No

0

@I_vTotalEstimatedCost

numeric

19,5

No

0

@I_vProductionEstimateQty

numeric

19,5

No

0

@I_vEstimatedMarkup

numeric

19,5

No

0

@I_vWSMarkupPercent

int

10

No

0

@I_vPostingStatus

smallint

5

No

0

@I_vPostingDate

datetime

No

01/01/1900'

@I_vChangeOrderMaximumAmount

numeric

19,5

No

I_vChangeOrderMaximumAmount must be zero for I_vChangeOrderType values of 1 (Fixed Amount) and 2 (Cost Plus)

@I_vUserID

char

15

No

'

@I_vUserDefine1

char

31

No

'

@I_vUserDefine2

char

31

No

'

@I_vUserDefined1

char

21

No

'

@I_vUserDefined2

char

21

No

'

@I_vUserDefinedInteger1

int

10

No

0

@I_vUserDefinedInteger2

int

10

No

0

@I_vUserDefinedInteger3

int

10

No

0

@I_vUserDefinedInteger4

int

10

No

0

@I_vUserDefinedDollar1

numeric

19,5

No

0

@I_vUserDefinedDollar2

numeric

19,5

No

0

@I_vUserDefinedDollar3

numeric

19,5

No

0

@I_vUserDefinedDollar4

numeric

19,5

No

0

@I_vUserDefinedCB1

tinyint

3

No

0

@I_vUserDefinedCB2

tinyint

3

No

0

@I_vUserDefinedCB3

tinyint

3

No

0

@I_vUserDefinedCB4

tinyint

3

No

0

@I_vWennsoftAffiliate

char

15

No

'

@I_vWennsoftBranch

char

15

No

'

@I_vWennsoftRegion

char

15

No

'

@I_vSVLanguageID

smallint

5

No

0

@I_vTimeZone

char

3

No

'

@I_vWSReservedCB1

tinyint

3

No

0

@I_vWSReservedCB2

tinyint

3

No

0

@I_vWSReservedCB3

tinyint

3

No

0

@I_vWSReservedCB4

tinyint

3

No

0

@I_vWSReservedCB5

tinyint

3

No

0

@I_vWSReservedSTR1

char

11

No

'

@I_vWSReservedSTR2

char

11

No

'

@I_vDEXROWID

int

10

No

0

@I_vUpdateIfExists

tinyint

3

Yes

0

@I_vWennSoftTablesOnly

tinyint

3

Yes

0

@I_vOnlyValidate

tinyint

3

Yes

0

@I_vUSRDEFND1

char

50

No

'

@I_vUSRDEFND2

char

50

No

'

@I_vUSRDEFND3

char

50

No

'

@I_vUSRDEFND4

varchar

8000

No

'

@I_vUSRDEFND5

varchar

8000

No

'

@I_vReturnErrorText

tinyint

3

No

1

@O_iErrorState

int

10

No

0

@oErrString

varchar

255

No

'

51017

The Job does not exist in Signature.

51094

Job is inactive.

51090

The Project Number does not exist.

51234

Project Number must be for an Active project.

52265

The change order number must contain a value.

52266

The change order number already exists for the job.

52267

The change order status must be a value in the range 1 thru 5.

52268

The change order type must be a value of 1 (Fixed Amount), 2 (Cost Plus), or 3 (Cost Plus NTE).

52269

The change order type must be a value of 1 (Fixed Amount) for jobs with billing type 6 (SOP Billing).

52270

Cost Plus NTE change orders, change order type 3, are only valid for jobs with a contract type of Cost Plus NTE.

52271

Change order posting status must be the value 0 (Unposted) or 2 (Posted).

52272

The change order description must contain a value.

52273

The change order estimated cost must be zero for change order types of 2 (Cost Plus) and 3 (Cost Plus NTE).

51234

The project number is not assigned to the job.

52274

The maximum change order amount must be zero for change order types 1 (Fixed Amount) and 2 (Cost Plus).