Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
SRVRECTYPE | Service Record Type |
Integer | 2 | View | |
CALLNBR | Service Call Number |
String | 12 | View | |
EQPLINE | Equipment Line Item Sequence |
Long Integer | 4 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
LINITMTYP | Line Item Type |
String | 4 | View | |
SRVSTAT | Service Call Status |
String | 4 | View | |
TECHID | Tech ID |
String | 12 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
ITEMUSETYPE | Item Use Type |
String | 4 | View | |
ITEMDESC | Item Description |
String | 102 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
UOFM | U Of M |
String | 10 | View | |
QTYORDER | QTY Ordered |
Currency | 10 | View | |
ATYALLOC | QTY Allocated |
Currency | 10 | View | |
QTYBACKO | QTY Backordered |
Currency | 10 | View | |
QTYSOLD | QTY Sold |
Currency | 10 | View | |
UNITCOST | Unit Cost |
Currency | 10 | View | |
UNITPRCE | Unit Price |
Currency | 10 | View | |
EXTDCOST | Extended Cost |
Currency | 10 | View | |
XTNDPRCE | Extended Price |
Currency | 10 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
STRTDATE | Start Date |
Date | 4 | View | |
STRTTIME | Start Time |
Time | 4 | View | |
ENDDATE | End Date |
Date | 4 | View | |
ENDTME | SVC_End Time |
Time | 4 | View | |
TRANSTME | Transaction Time |
String | 8 | View | |
BILLABLTIM | Billable Time |
String | 8 | View | |
TRNSFLOC | Transfer From Location |
String | 12 | View | |
TRNSFQTY | Transfer From QTY |
Currency | 10 | View | |
TRNFLAG | Transfer Flag |
Boolean | 2 | View | |
ORDDOCID | Order Document ID |
String | 16 | View | |
TRANSLINESEQ | Transfer Line Item Sequence |
Long Integer | 4 | View | |
LABPCT | Labor Pct |
Currency | 10 | View | |
PARTPCT | Part Pct |
Currency | 10 | View | |
MISCPCT | Misc Pct |
Currency | 10 | View | |
FUFILDAT | Fulfillment Date |
Date | 4 | View | |
PONMBRSTR | Purchase_Order_Number_STR |
String | 18 | View | |
POLNSEQ | Purchase_Order_Line_Sequence_DOL |
Currency | 10 | View | |
On_Return | On Return |
Boolean | 2 | View | |
RETDOCID | Return Document ID |
String | 16 | View | |
LNSEQNBR | Line SEQ Number |
Currency | 10 | View | |
Miles_Start | Miles Start |
Long Integer | 4 | View | |
Miles_End | Miles End |
Long Integer | 4 | View | |
Miles_Used | Miles Used |
Long Integer | 4 | View | |
PRICELVL | Price Level |
String | 16 | View | |
SVC_Address_Option | SVC_Address_Option |
Integer | 2 | View | |
SVC_Misc_Address_Code | SVC_Misc_Address_Code |
String | 16 | View | |
SVC_Disable_XFR_Grouping | SVC_Disable_XFR_Grouping |
Boolean | 2 | View | |
Work_Type | Work Type |
String | 12 | View | |
ORUNTCST | Originating Unit Cost |
Currency | 10 | View | |
ORUNTPRC | Originating Unit Price |
Currency | 10 | View | |
OREXTCST | Originating Extended Cost |
Currency | 10 | View | |
OXTNDPRC | Originating Extended Price |
Currency | 10 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
ORTAXAMT | Originating Tax Amount |
Currency | 10 | View | |
SVC_FO_ID | SVC FO ID |
String | 52 | View | |
svcCreateVoucher | svcCreateVoucher |
Boolean | 2 | View | |
VCHRNMBR | Voucher Number |
String | 22 | View | |
CMPNTSEQ | Component Sequence |
Long Integer | 4 | View | |
CMPITQTY | Component Item QTY |
Currency | 10 | View |