wsiWSTransactionLineCreate

@I_vWSJobNumber

char

17

No

'

Required and validated for Job Cost

@I_vJournalEntry

int

10

Yes

Validated - WS10801

@I_vProductIndicator

smallint

5

Yes

Must be 1 Unbilled, 2 Job Cost, or 3 Service

.@I_vAccountNumber

char

200

No

'

Auto set for Service, Auto set for JC if using divisional posting accounts, else must provide acct number or acct index

@I_vAccountIndex

int

10

No

0

Auto set for Service, Auto set for JC if using divisional posting accts, else must provide acct number or acct index

@I_vServiceCallID

char

17

No

'

Required and validated for Service

@I_vWSCostCodeNumber1

char

7

No

'

Validated - Job Cost JC00701

@I_vWSCostCodeNumber2

char

7

No

'

Validated - Job Cost JC00701

@I_vWSCostCodeNumber3

char

7

No

'

Validated - Job Cost JC00701

@I_vWSCostCodeNumber4

char

7

No

'

Validated - Job Cost JC00701

@I_vCostElement

smallint

5

No

0

Validated - Job Cost

@I_vWSCostCode

int

10

No

0

Validated - Service

@I_vWSOtherCostSubCode

int

10

No

0

Validated - Service SV00145

@I_vEquipmentID

char

31

No

'

Validated - Service SV00400, SV00300

@I_vCreditAmount

numeric

19,5

No

0

Validated against both credit and debit being non zero

@I_vDebitAmount

numeric

19,5

No

0

Validated against both credit and debit being non zero

@I_vOriginatingCreditAmount

numeric

19,5

No

set to Credit Amount

set to Credit Amount

@I_vOriginatingDebitAmount

numeric

19,5

No

set to Debit Amount

set to Debit Amount

@I_vDescription

char

31

No

JC - 'Job ' + job number + cost element

Service - set to 'Service ' + service call Id + cost code

@I_vTRXQTY

numeric

19,5

No

0

@I_vGLLINEMessages

binary

4

No

@I_vGLLINEMessages2

binary

4

No

@I_vGLLineValid

binary

4

No

@I_vFixedOrVariable

smallint

5

No

Set to 0

Set to 0

@I_vBalanceForCalculation

smallint

5

No

Set to 0

Set to 0

@I_vPostingType

smallint

5

No

0 or 1 for Service

@I_vDecimalPlaces

smallint

5

No

2

Set to 2

@I_vPurchaseOrderNumber

char

21

No

'

@I_vRatePerUnit

numeric

19,5

No

0

@I_vBillingAmount

numeric

19,5

No

0

@I_vVendorID

char

15

No

'

Validated - PM00200

@I_vEmployeeID

char

15

No

'

Validated - UPR00100

@I_vItemNumber

char

31

No

'

@I_vItemDescription

char

101

No

'

@I_vUserID

char

15

No

'

@I_vOHAmount

numeric

19,5

No

0

@I_vOHAccountIndexCR

int

10

No

0

@I_vOHAccountIndexDR

int

10

No

0

@I_vTRXHoursUnits

int

10

No

0

@I_vPayrollPayType

smallint

5

No

0

@I_vPayRecord

char

7

No

'

@I_vPayRate

numeric

19,5

No

0

@I_vDepartment

char

7

No

'

@I_vJobTitle

char

7

No

'

@I_vPayRateAmount

numeric

19,5

No

0

@I_vUPRTRXCode

char

7

No

'

@I_vUOfM

char

9

No

'

@I_vCurrencyID

char

15

No

FUNLCURR from MC40000

@I_vCurrencyIndex

smallint

5

No

Set to 1007

Set to 1007

@I_vRateCalculationMethod

smallint

5

No

0

@I_vExchangeRate

numeric

19,7

No

0

@I_vDenominationExchangeRate

numeric

19,7

No

0

@I_vIntercompanyID

char

5

No

'

SELECT DB_NAME()

@I_vRateTypeID

char

15

No

'

@I_vExchangeTableID

char

15

No

'

@I_vExchangeDate

datetime

No

1/1/1900'

@I_vPONumber

char

17

No

'

@I_vTime

datetime

No

1/1/1900'

@I_vLaborGroupName

char

15

No

'

@I_vPricingMatrixName

char

15

No

'

set for service from SV00200

@I_vWennsoftAffiliate

char

15

No

'

Validated - sv00015

@I_vWennsoftRegion

char

15

No

'

Validated - sv00015

@I_vWennsoftBranch

char

15

No

'

Validated - sv00015

@I_vSVLanguageID

smallint

5

No

0

@I_vTimeZone

char

3

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_vUserDefinedDate1

datetime

No

1/1/1900'

@I_vUserDefinedDate2

datetime

No

1/1/1900'

@I_vUserDefinedDate3

datetime

No

1/1/1900'

@I_vUserDefinedDate4

datetime

No

1/1/1900'

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

1

No

1

@O_iErrorState

int

10

No

0

@oErrString

varchar

255

No