wsiSMSJobCostsWork

Table: SV000810

Element Name	Data Type	Length
@I_vAccountIndexCredit	int
@I_vAccountIndexDebit	int
@I_vAddedRate	tinyint
@I_vAddNewEquipmentRecord	tinyint
@I_vAddressCode	char	15
@I_vBaseCurrConversionFactor	numeric	19,7
@I_vBaseCurrencyID	char	15
@I_vBatchNumber	char	15
@I_vBatchSource	char	15
@I_vBillableCheckBox	tinyint
@I_vBilledToJob	numeric	19,5
@I_vBillingAmount	numeric	19,5
@I_vBillingCurrConversionFactor	numeric	19,7
@I_vBillingCurrencyID	char	15
@I_vBillingRate	numeric	19,5
@I_vCallInvoiceNumber	char	17
@I_vCostCodeDescription	char	31
@I_vCustomerNumber	char	15
@I_vDivisions	char	15
@I_vDocumentAmount	numeric	19,5
@I_vDocumentDate	datetime
@I_vDocumentType	smallint
@I_vDynamicsStatus	char	5
@I_vEmployeeID	char	15
@I_vEmployeeName	char	41
@I_vEquipmentID	char	31
@I_vEquipmentType	char	31
@I_vExtendedCost	numeric	19,5
@I_vGLPostingDate	datetime
@I_vInvoiceAccountIndexCredit	int
@I_vInvoiceAccountIndexDebit	int
@I_vItemDescription	char	101
@I_vItemNumber	char	31
@I_vJobTitle	char	7
@I_vJobType	char	7
@I_vJournalEntry	int
@I_vLaborGroupName	char	15
@I_vLocalCurrencyID	char	15
@I_vManufacturerID	char	15
@I_vNewEquipmentID	char	11
@I_vNonBillable	tinyint
@I_vNoteCheckbox	tinyint
@I_vOHAccountIndexCR	int
@I_vOHAccountIndexDR	int
@I_vOHAmount	numeric	19,5
@I_vOnlyValidate	tinyint
@I_vOverheadWIPAccountIndexCredit	int
@I_vPayRate	numeric	19,5
@I_vPayRecord	char	7
@I_vPricingMatrixName	char	15
@I_vPYADNMBR	int
@I_vReferenceTRXNumber	char	17
@I_vReturnErrorText	tinyint
@I_vREVSETRX	tinyint
@I_vSequenceNumber	int
@I_vServiceCallID	char	17
@I_vServiceUserDefine1	char	21
@I_vServiceUserDefine10	datetime
@I_vServiceUserDefine11	datetime
@I_vServiceUserDefine12	datetime
@I_vServiceUserDefine18	tinyint
@I_vServiceUserDefine19	tinyint
@I_vServiceUserDefine2	char	21
@I_vServiceUserDefine20	tinyint
@I_vServiceUserDefine21	tinyint
@I_vServiceUserDefine22	numeric	19,5
@I_vServiceUserDefine23	numeric	19,5
@I_vServiceUserDefine24	numeric	19,5
@I_vServiceUserDefine25	numeric	19,5
@I_vServiceUserDefine5	int
@I_vServiceUserDefine6	int
@I_vServiceUserDefine7	int
@I_vServiceUserDefine8	int
@I_vServiceUserDefine9	datetime
@I_vShiftCode	char	7
@I_vShiftPremium	numeric	19,5
@I_vSVLanguageID	smallint
@I_vTask_Account	int
@I_vTaskCode	char	11
@I_vTaxable	tinyint
@I_vTechnicianID	char	15
@I_vTechnicianTeam	char	15
@I_vTimeZone	char	3
@I_vTransactionDescription	char	31
@I_vTransactionSource	char	25
@I_vTravelRateName	char	15
@I_vTravelTransaction	tinyint
@I_vTRXHoursUnits	int
@I_vTRXHoursUnitsBill	int
@I_vTRXQTY	numeric	19,5
@I_vTRXQTYBILL	numeric	19,5
@I_vUnitCost	numeric	19,5
@I_vUnitPrice	numeric	19,5
@I_vUOfM	char	9
@I_vUpdateIfExists	tinyint
@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_vVendorName	char	65
@I_vVOIDPYADNMBR	int
@I_vVoucherNumberWORK	char	17
@I_vWennsoftAffiliate	char	15
@I_vWennsoftBranch	char	15
@I_vWennsoftModelNumber	char	21
@I_vWennsoftRegion	char	15
@I_vWennsoftSerialNumber	char	41
@I_vWennsoftStatus	char	5
@I_vWennSoftTablesOnly	tinyint
@I_vWIPAccountIndexCredit	int
@I_vWS_Grouped	tinyint
@I_vWSCommittedCost	numeric	19,5
@I_vWSCostCode	int
@I_vWSCreatedDate	datetime
@I_vWSCreatedTime	datetime
@I_vWSExtendedCost	numeric	19,5
@I_vWSJobName	char	31
@I_vWSOtherCostSubCode	int
@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_vWSTransactionNote	varchar	8000
@O_iErrorState	int
@oErrString	varchar	255

Error Codes

Error Code	Description
51000	Customer Number does not exist in Service.
51001	Customer Number does not exist in Microsoft Business Solutions.
51016	The Service Call does not exist in Signature.
51050	An error occurred during an update or insert into a Signature table.
52026	The Location does not exist in Signature.
52027	The Location does not exist in Microsoft Business Solutions.
52028	The Primary Bill To Location is not set for this Customer in Microsoft Business Solutions.
52029	The Reference Transaction Number is missing or blank.
52030	The Service Cost Code does not exist.
52031	The Document Date is missing or blank.
52032	Employee doesn't exist
52033	The Equipment ID does not exist.
52034	Employee is inactive
52035	The Position or Job Title does not exist.
52036	The Pay Code is empty or missing.
52037	Pay code can't be all.
52038	The Pay Code is inactive.
52039	This is not a valid pay code for this labor group and position.
52040	The Pay Code does not exist for this employee.
52041	The Labor Group does not exist.
52042	The Pricing Matrix does not exist.
52643	Invalid Transaction Source.
52644	Pay codes are only valid for payroll transactions.