SRVRECTYPE | smallint | No | Service Record Type -- 1=Quote, 2=Open | IN |
CALLNBR | char(11) | No | Service Call Number | IN |
EQPLINE | int | No | Equipment Line Number | IN |
LNITMSEQ | bigint | No | Line Item Sequence | IN |
LINITMTYP | char(3) | No | Line Item Type P=Parts, L=Labor, A=Addl Charges, E=Expenses | IN |
SRVSTAT | char(3) | No | Service Call Status Code | IN |
TECHID | char(11) | No | Tech ID | IN |
CUSTNMBR | char(15) | No | Customer Number | IN |
ADRSCODE | char(15) | No | Address Code | IN |
ITEMNMBR | char(31) | No | Item Number | IN |
CKNORETURNS | smallint | No | Flag to indicate NOT to create Returnable line. | IN |
ITEMDESC | char(101) | No | Item Description | IN |
LOCNCODE | char(11) | No | Item Location Code | IN |
UOFM | char(9) | No | Item Unit of Measure | IN |
QTYORDER | numeric(19,5) | No | Ordered Qty | IN |
ATYALLOC | numeric(19,5) | No | Allocated Qty | IN |
QTYBACKO | numeric(19,5) | No | Backordered Qty | IN |
QTYSOLD | numeric(19,5) | No | Sold Qty | IN |
UNITCOST | numeric(19,5) | No | Item Unit Cost | IN |
UNITPRCE | numeric(19,5) | No | Item Unit Price | IN |
XTNDPRCE | numeric(19,5) | No | Extended Price for Qty Sold | IN |
NOTETXT | varchar(8000) | No | Note Text for the line | IN |
STRTDATE | datetime | No | Start Date for Labor Hours | IN |
STRTTIME | datetime | No | Start Time for Labor Hours | IN |
ENDDATE | datetime | No | End Date for Labor Hours | IN |
ENDTME | datetime | No | End Time for Labor Hours | IN |
TRANSTME | numeric(19,5) | No | Transaction Time for Labor Hours | IN |
BILLABLTIM | numeric(19,5) | No | Billable Time for Labor Hours | IN |
ENTDTE | datetime | No | Entry Date for the service call | IN |
ENTTME | datetime | No | Entry Time for the service call | IN |
LABPCT | numeric(19,5) | No | Labor Percentage to be used from Contract | IN |
PARTPCT | numeric(19,5) | No | Parts Percentage to be used from Contract | IN |
MISCPCT | numeric(19,5) | No | Miscellaneous Percentage to be used from Contract | IN |
CKCREATEPO | smallint | No | Flag to indicate whether to create a PO for the line | IN |
VENDORID | char(15) | No | Vendor ID to be used for creating a PO for the item | IN |
PRMDATE | datetime | No | | IN |
Miles_Start | int | No | Starting Miles for Labor Lines | IN |
Miles_End | int | No | Ending Miles for Labor Lines | IN |
Miles_Used | int | No | Total Miles Used | IN |
PRICELVL | char(15) | No | Item Price Level | IN |
SVC_Address_Option | smallint | No | Address Based On. 1=Customer Address, 2=Tech Site, 3=Misc Address, 4=Transfer Header | IN |
SVC_Misc_Address_Code | char(15) | No | Misc Address. If SVC_Address_Option = 3 | IN |
SVC_Disable_XFR_Grouping | tinyint | No | Disable XFR Grouping. 0=False, 1=True | IN |
Work_Type | char(11) | No | Type of Work | IN |
SVC_FO_ID | char(51) | No | Service Front Office ID | IN |
CURNCYID | char(15) | No | Currency ID | IN |
NonInventory | smallint | No | Added on 10/26/09 to allow for NON-IV items. 0 = Inventory item, 1 = Non IV item | IN |
Create_Overtime_Labor | smallint | No | Added on 11/16/09 to allow Overtime labor rates to be used for labor outside of Technician schedule | IN |
Overtime_Labor_Item_Number | char(31) | No | Item Number for Overtime labor if automatic overtime is enabled, OvertimeLabor = 1 | IN |
UpdateIfExists | tinyint | No | Flag to allow customer data to be updated if it exists. 0=no, 1=yes | IN |
RequesterTrx | smallint | No | Requester Trx - 0=false,1=true - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | Error Code | INOUT |
oErrString | varchar(255) | No | List of errors encountered | INOUT |