Skip to main content
Skip table of contents

wsiJCInventoryWork

Table: JC10201

Description: Used to create Job Cost Inventory Transactions

Element NameData TypeLengthRequiredDefaultDescription

@I_vAccountIndexArray21

int

 




@I_vAccountIndexArray22

int

 




@I_vAccountIndexArray23

int

 




@I_vAccountIndexArray24

int

 




@I_vAccountIndexArray25

int

 




@I_vBatchNumber

char

15




@I_vBatchSource

char

15




@I_vCostCodeActualCostTTD

numeric

19,5




@I_vCostCodeDescription

char

31




@I_vCostElement

smallint

 




@I_vDocumentAmount

numeric

19,5




@I_vDocumentDate

datetime

 




@I_vDocumentSource

char

3




@I_vGLPostingDate

datetime

 




@I_vItemDescription

char

101




@I_vItemNumber

char

31




@I_vIVDocumentType

smallint

 




@I_vJobTRXNumber

char

21




@I_vJobType

char

7




@I_vLineSEQNumber

numeric

19,5




@I_vOnlyValidate

tinyint

 




@I_vPostingStatus

smallint

 




@I_vProfitAmount

numeric

19,5




@I_vProfitTypeNumber

smallint

 




@I_vReturnErrorText

tinyint

 




@I_vSVLanguageID

smallint

 




@I_vTaxDate

datetime

 




@I_vTimeZone

char

3




@I_vTransactionDescription

char

31




@I_vTRXLocation

char

11




@I_vTRXQTY

numeric

19,5




@I_vUnitCost

numeric

19,5




@I_vUOfM

char

9




@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_vVendorID

char

15




@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_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.

51017

The Job does not exist in Signature.

51018

Cost Code does not exist for this Job.

51050

An error occurred during an update or insert into a Signature table.

51050

An error occurred during an update or insert into a Signature table.

51089

The Cost Element must be in the range of 1 to 9.

51091

The Inventory Item does not exist.

51094

Job is inactive.

52234

Transaction Quantity is invalid.

52236

Unit of Measure is invalid.

JavaScript errors detected

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

If this problem persists, please contact our support.