Signature 2022 (18.5)
Signature 2022 (18.5)
Breadcrumbs

wsiWSTransactionalHeaderAndLine

/*<![CDATA[*/ div.rbtoc1765575865609 {padding: 0px;} div.rbtoc1765575865609 ul {list-style: disc;margin-left: 0px;} div.rbtoc1765575865609 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Name: wsiWSTransactionHeader Name: wsiWSTransactionLine

Name: wsiWSTransactionHeader

Parameter

Notes

@I_vBatchNumber

Validate, must exist

@I_vBatchSource

Default to GL_Normal, v2: allow override and validate.

@I_vJournalEntry

Default to GJ, allow override and validate

@I_vRecurringTRXSequence

Default to empty

@I_vSourceDocument

Validate, must exist

@I_vReference

 

@I_vTRXDate

Validate that it is in an open period

@I_vReversingDate

D14Not supported. V2

@I_vRecurringTRX

Not supported. v2

@I_vBalanceForCalculation

Research, not sure what it is.

@I_vPostingStatus

Remove, set to Work.

@I_vLastUser

Default to SQL user, allow override

@I_vLastDateEdited

Default to SQL date, allow override.

@I_vUserWhoPosted

Remove.

@I_vTransactionType

Research.

@I_vSequenceLine

Default to zero.

@I_vGLHDRMessages

Research.

@I_vGLHDRMessages2

Research.

@I_vTRXSource

Pass through

@I_vSeries

default to General Journal, allow override, validate

@I_vOriginatingTRXType

Default to empty, MC not supported

@I_vOriginatingControlNumber

Default to empty, MC not supported

@I_vOriginatingMasterID

Default to empty, MC not supported

@I_vOriginatingMasterName

Default to empty, MC not supported

@I_vOriginatingDocumentNumber

Default to empty, MC not supported

@I_vOriginatingPostedDate

Default to empty, MC not supported

@I_vOriginatingTRXSource

Default to empty, MC not supported

@I_vCurrencyID

Default to functional currency, MC not supported.

@I_vNoteIndex

Default to empty

@I_vGLHeaderValid

Research.

@I_vPeriodID

Remove and calc from transaction date.

@I_vOpenYear

Remove and calc from transaction date.

@I_vClosedYear

Default to empty.

@I_vHistoryTRX

Default to empty.

@I_vReversingPeriodID

Default to empty. Not supported

@I_vReversingYear

Default to empty. Not supported

@I_vReversingClosedYear

Default to empty. Not supported

@I_vReversingHistoryTRX

Default to empty. Not supported

@I_vICTRX

Default to empty. Not supported

@I_vErrorState

Remove.

@I_vUserDefine1

Default to empty.

@I_vUserDefine2

 

@I_vUserDefined1

 

@I_vUserDefined2

 

@I_vUserDefinedInteger1

 

@I_vUserDefinedInteger2

 

@I_vUserDefinedInteger3

 

@I_vUserDefinedInteger4

 

@I_vUserDefinedDollar1

 

@I_vUserDefinedDollar2

 

@I_vUserDefinedDollar3

 

@I_vUserDefinedDollar4

 

@I_vUserDefinedDate1

Valid dex date

@I_vUserDefinedDate2

Valid dex date

@I_vUserDefinedDate3

Valid dex date

@I_vUserDefinedDate4

Valid dex date

@I_vUserDefinedCB1

valid bool

@I_vUserDefinedCB2

valid bool

@I_vUserDefinedCB3

valid bool

@I_vUserDefinedCB4

valid bool

@I_vWSReservedCB1

valid bool

@I_vWSReservedCB2

valid bool

@I_vWSReservedCB3

valid bool

@I_vWSReservedCB4

valid bool

@I_vWSReservedCB5

valid bool

@I_vUpdateIfExists

 

@I_vWennSoftTablesOnly

 

@I_vOnlyValidate

 

@I_vUSRDEFND1

 

@I_vUSRDEFND2

 

@I_vUSRDEFND3

 

@I_vUSRDEFND4

 

@I_vUSRDEFND5

 

@I_vReturnErrorText

 

@O_iErrorState

 

@oErrString

 

Other notes:

  • Needs to be updated to the newest template.

  • Error codes need to be changed from TC error codes to Dev error codes.

  • Should handle updates and creates.

  • All datetimes are valid dex date/time.

  • All tiny ints are valid bools.

Name: wsiWSTransactionLine

Parameter

Notes

@I_vWSJobNumber

Not required. Validate if supplied

@I_vBatchNumber

Not required. Validate if supplied

@I_vBatchSource

Not required. Validate if supplied

@I_vJournalEntry

Not required. Validate if supplied

@I_vSequenceLine

Auto generate, increment by 500

@I_vProductIndicator

Validate: 1= Unbilled, 2=JC, or 3=SMS

@I_vAccountNumber

Optional. Validate lookup valid posting Account Index (GL00105)

@I_vAccountIndex

Validate, overrides Account Number. If PI = 1 then user must provide valid posting account (no unit accounts), if PI=2 or PI=3 then lookup account and this parameter and Account Number must be empty.

@I_vServiceCallID

Must be empty unless PI=3 then validate

@I_vWSProjectNumber

Remove. Lookup from job number if PI=JC

@I_vWSCostCodeNumber1

Validate if PI=2 otherwise must be empty

@I_vWSCostCodeNumber2

Validate if PI=2 otherwise must be empty

@I_vWSCostCodeNumber3

Validate if PI=2 otherwise must be empty

@I_vWSCostCodeNumber4

Validate if PI=2 otherwise must be empty

@I_vCostCodeDescription

Remove. Lookup

@I_vCostElement

Validate if PI=2 otherwise must be empty

@I_vWSCostCode

If PI=3 then 1-10, else must be empty

@I_vWSOtherCostSubCode

Research.

@I_vEquipmentID

If PI=3 validate, otherwise must be empty.

@I_vCreditAmount

 

@I_vDebitAmount

 

@I_vOriginatingCreditAmount

Force to match CR amount MC not supported

@I_vOriginatingDebitAmount

Force to match DR amount MC not supported

@I_vDescription

If PI= 1 allow any description, otherwise default to normal GUI JC and GUI SMS, allow override.

@I_vProfitTypeNumber

Remove, lookup JC00701

@I_vProfitAmount

Remove, lookup

@I_vTRXQTY

Default to empty

@I_vPostingStatus

Remove

@I_vGLLINEMessages

Research

@I_vGLLINEMessages2

Research

@I_vGLLineValid

Research

@I_vAccountType

Remove, lookup

@I_vFixedOrVariable

Remove, lookup

@I_vBalanceForCalculation

Remove research?

@I_vPostingType

Remove, lookup

@I_vDecimalPlaces

Default to 2. MC not supported. Research may be tied to currency and could lookup based on the currency.

@I_vPurchaseOrderNumber

Default to empty

@I_vRatePerUnit

Default to empty

@I_vBillingAmount

Default to empty or if time allows: Use the SMS_GetOHAndBillingAmounts.sql to retrieve this value.

@I_vVendorID

Default to empty, validate

@I_vEmployeeID

Default to empty, validate

@I_vItemNumber

Default to empty, validate

@I_vItemDescription

Default to empty, allow to override for non-IV parts

@I_vUserID

Default to header, allow to override.

@I_vWSTransactionDate

Lookup from header

@I_vOHAmount

Default to empty or if time allows: Use the SMS_GetOHAndBillingAmounts.sql to retrieve this value.

@I_vOHAccountNumberCR

Optional. Validate, lookup valid posting Account Index (GL00105)

@I_vOHAccountIndexCR

Default to empty. not supported

@I_vOHAccountNumberDR

Optional. Validate lookup posting Account Index (GL00105)

@I_vOHAccountIndexDR

Default to empty. not supported

@I_vDivisions

Remove, lookup

@I_vTRXHoursUnits

Default to empty.

@I_vPayrollPayType

Default to empty. not supported

@I_vPayRecord

Default to empty or if time allows: Validate this is valid for the employeeID.

@I_vPayRate

Default to empty. not supported

@I_vDepartment

Default to empty or if time allows: Validate this is valid for the employeeID.

@I_vJobTitle

Default to empty or if time allows: Validate this is valid for the employeeID.

@I_vPayRateAmount

Default to empty. not supported

@I_vUPRTRXCode

Default to empty. not supported

@I_vUOfM

Default to empty. not supported

@I_vCurrencyID

Default to functional. not supported

@I_vCurrencyIndex

Default to functional. not supported

@I_vRateCalculationMethod

Default to empty. MC not supported

@I_vExchangeRate

Default to empty. MC not supported.

@I_vDenominationExchangeRate

Default to empty. MC not supported

@I_vIntercompanyID

Default to empty. Not supported for IC trx.

@I_vRateTypeID

Default to empty. MC not supported.

@I_vExchangeTableID Default to empty. MC not supported.

 

@I_vExchangeDate

Default to empty. MC not supported.

@I_vPONumber

Default to empty. not supported

@I_vTime

Default to empty. not supported

@I_vLaborGroupName

Default to empty or if time allows: Check if company is using Overhead Amounts from Job Cost and look at the SV000123 and SV00122. See the guts of the SMS_GetOHAndBillngAmounts.sql for how this might be done.

@I_vPricingMatrixName

default to empty. not supported – ck with LZ

@I_vWennsoftAffiliate

Validate combination of Affiliate, Region, and Branch.

@I_vWennsoftRegion

Validate combination of Affiliate, Region, and Branch.

@I_vWennsoftBranch

Validate combination of Affiliate, Region, and Branch.

@I_vSVLanguageID

Default to empty

@I_vTimeZone

Default to empty

@I_vUserDefine1

 

@I_vUserDefine2

 

@I_vUserDefined1

 

@I_vUserDefined2

 

@I_vUserDefinedInteger1

 

@I_vUserDefinedInteger2

 

@I_vUserDefinedInteger3

 

@I_vUserDefinedInteger4

 

@I_vUserDefinedDollar1

 

@I_vUserDefinedDollar2

 

@I_vUserDefinedDollar3

 

@I_vUserDefinedDollar4

 

@I_vUserDefinedDate1

Valid dex date

@I_vUserDefinedDate2

Valid dex date.

@I_vUserDefinedDate3

Valid dex date

@I_vUserDefinedDate4

Valid dex date

@I_vUserDefinedCB1

Valid bool

@I_vUserDefinedCB2

Valid bool

@I_vUserDefinedCB3

Valid bool

@I_vUserDefinedCB4

Valid bool

@I_vWSReservedCB1

Valid bool

@I_vWSReservedCB2

Valid bool

@I_vWSReservedCB3

Valid bool

@I_vWSReservedCB4

Valid bool

@I_vWSReservedCB5

Valid bool

@I_vWSReservedSTR1

 

@I_vWSReservedSTR2

 

@I_vUpdateIfExists

 

@I_vWennSoftTablesOnly

 

@I_vOnlyValidate

 

@I_vUSRDEFND1

 

@I_vUSRDEFND2

 

@I_vUSRDEFND3

 

@I_vUSRDEFND4

 

@I_vUSRDEFND5

 

@I_vReturnErrorText

 

@O_iErrorState

 

@oErrString

 

Other notes:

  • Needs to be updated to the newest template.

  • Error codes need to be changed from TC error codes to Dev error codes.

  • Should handle updates and creates.

  • All datetimes are valid dex date/time.

  • All tiny ints are valid bools.