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 | |
LINITMTYP | Line Item Type |
String | 4 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
ITEMUSETYPE | Item Use Type |
String | 4 | View | |
ITEMDESC | Item Description |
String | 102 | View | |
STATIONID | Depot Station ID |
String | 12 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
UOFM | U Of M |
String | 10 | View | |
TECHID | Tech ID |
String | 12 | 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 | |
STRTDATE | Start Date |
Date | 4 | View | |
STRTTIME | Start Time |
Time | 4 | View | |
ENDDATE | End Date |
Date | 4 | View | |
ENDTIME | End Time |
Time | 4 | View | |
TRANSTME | Transaction Time |
String | 8 | View | |
BILLABLTIM | Billable Time |
String | 8 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
SEQUENCE1 | Sequence |
Currency | 10 | View | |
ORDDOCID | Order Document ID |
String | 16 | View | |
TRANSLINESEQ | Transfer Line Item Sequence |
Long Integer | 4 | View | |
PONMBRSTR | Purchase_Order_Number_STR |
String | 18 | View | |
POLNSEQ | Purchase_Order_Line_Sequence_DOL |
Currency | 10 | View | |
FUFILDAT | Fulfillment Date |
Date | 4 | View | |
CMPNTSEQ | Component Sequence |
Long Integer | 4 | View | |
CMPITQTY | Component Item QTY |
Currency | 10 | View |