Billing Code Stored Procedures
This topic shows the stored procedures used for material, labor, and
miscellaneous billing codes.
Material Stored Procedure
exec @Severity = SSSFSCustomMatlRateSp @InTransType, @InSroNum, @InSroLine, @InSroOper, @InItem, @InCustNum, @InTransDate, @InQty, @InCurrCode, @InPricecode, @InBillCode, @InCost, @OutUnitPrice, OUTPUT, @Infobar OUTPUT
Labor Stored Procedure
exec @Severity = SSSFSCustLaborRateSp @iTransType, @iSroNUm, @iSroLine, @iSroOper, @iBillCode, @iTransDate, @iPartnerId, @iWorkCode, @iUnitCost, @iHrsWorked, @iHrsBilled, @tUnitPrice OUTPUT, @Infobar OUTPUT
Miscellaneous Stored Procedure
exec @Severity = SSSFSCustMiscRateSp @iTransType, @iSroNum, @iSroLine, @iSroOper, @iBillCode, @iTransDate, @iPartner, @iMiscCode, @iUnitCost, @iQty, @tUnitPrice OUTPUT, @Infobar OUTPUT
Notes About the Stored Procedures
- A working knowledge of SQL is strongly recommended before you try to modify the stored procedures.
- If the Custom billing code option is selected and the stored procedure does not exist, errors will occur.
- To display an error message from the stored procedure, return a non-zero value as well as a error message in @Infobar.
- Return a 0 from the stored procedure if processing completed successfully.
Related topics