Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
WORECTYPE | Work Order Record Type |
Integer | 2 | View | |
WORKORDNUM | Work Order Number |
String | 12 | View | |
WOSTAT | Work Order Status |
String | 4 | View | |
WOTYPE | Work Order Type |
String | 12 | View | |
SVC_Depot_Priority | SVC_Depot_Priority |
Currency | 10 | View | |
PARWORECTYPE | Parent Work Order Record Type |
Integer | 2 | View | |
PARWONUM | Parent Work Order Number |
String | 16 | View | |
ORIGIN | Origin |
Integer | 2 | View | |
REFRENCE | Reference |
String | 32 | View | |
TIMEZONE | TimeZone |
String | 4 | View | |
ENTDTE | Entry Date |
Date | 4 | View | |
ENTTME | Entry Time |
Time | 4 | View | |
ETADTE | ETA Date |
Date | 4 | View | |
ETATME | ETA Time |
Time | 4 | View | |
ECOMPDT | EComp Date |
Date | 4 | View | |
EComp_Time | EComp Time |
Time | 4 | View | |
RETUDATE | Return Date |
Date | 4 | View | |
Return_Time | Return Time |
Time | 4 | View | |
COMPDTE | Complete Date |
Date | 4 | View | |
COMPTME | Complete Time |
Time | 4 | View | |
BIN | Bin |
String | 16 | View | |
USERID | User ID |
String | 16 | View | |
OFFID | Office ID |
String | 12 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
ADDRESS1 | Address 1 |
String | 62 | View | |
ADDRESS2 | Address 2 |
String | 62 | View | |
CITY | City |
String | 36 | View | |
STATE | State |
String | 30 | View | |
ZIPCODE | Zip Code |
String | 12 | View | |
RETDOCID | Return Document ID |
String | 16 | View | |
LNSEQNBR | Line SEQ Number |
Currency | 10 | View | |
SRVRECTYPE | Service Record Type |
Integer | 2 | View | |
CALLNBR | Service Call Number |
String | 12 | View | |
SERVLITEMSEQ | Service Line Item Sequence |
Long Integer | 4 | View | |
IBITEMNUM | Inbound Item Number |
String | 32 | View | |
IBSERIAL | Inbound Serial Number |
String | 22 | View | |
IBEQUIPID | Inbound Equipment ID |
Long Integer | 4 | View | |
OBITEMNUM | Outbound Item Number |
String | 32 | View | |
OBSERIAL | Outbound Serial Number |
String | 22 | View | |
OBEQUIPID | Outbound Equipment ID |
Long Integer | 4 | View | |
QUANTITY | QTY |
Currency | 10 | View | |
STATIONID | Depot Station ID |
String | 12 | View | |
ROUTEID | Route ID |
String | 12 | View | |
SEQUENCE1 | Sequence |
Currency | 10 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
IBANALCODE | Inbound Analysis Code |
String | 12 | View | |
OBANALCODE | Outbound Analysis Code |
String | 12 | View | |
CUSTOWN | Customer Owned |
Boolean | 2 | View | |
ORDDOCID | Order Document ID |
String | 16 | View | |
TRANSLINESEQ | Transfer Line Item Sequence |
Long Integer | 4 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
FACTSEAL | Factory Sealed |
Boolean | 2 | View | |
LABSTOTCST | Labor Sub Total Cost |
Currency | 10 | View | |
PARSTOTCST | Part Sub Total Cost |
Currency | 10 | View | |
TOTLABHRS | Total Labor Hours |
Currency | 10 | View | |
PRICELVL | Price Level |
String | 16 | View | |
NUMRESCHED | Number of Reschedules |
Integer | 2 | View | |
Commit_Date | Commit Date |
Date | 4 | View | |
Commit_Time | Commit Time |
Time | 4 | View | |
DSCRIPTN | Description |
String | 32 | View |