Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
USERID | User ID |
String | 16 | View | |
QUERYNAME | Query Name |
String | 52 | View | |
MRPQTYNUM_I | MRP_Quantity_Number |
Integer | 2 | View | |
STTITNUM | Start Item Number |
String | 32 | View | |
ENITMNBR | End Item Number |
String | 32 | View | |
ITEMDESC | Item Description |
String | 102 | View | |
STTITCLS | Start Item Class |
String | 12 | View | |
ENITMCLS | End Item Class |
String | 12 | View | |
STTLOCCD | Start Location Code |
String | 12 | View | |
ENLOCNCD | End Location Code |
String | 12 | View | |
STARTORDERNMBR | Start Order Number |
String | 32 | View | |
ENDORDERNMBR | End Order Number |
String | 32 | View | |
STARTBUYERID | Start Buyer ID |
String | 16 | View | |
ENDBUYERID | End Buyer ID |
String | 16 | View | |
STARTPLANNERID | Start Planner ID |
String | 16 | View | |
ENDPLANNERID | End Planner ID |
String | 16 | View | |
STARTRELEASEDATE | Start Release Date |
Date | 4 | View | |
ENDRELEASEDATE | End Release Date |
Date | 4 | View | |
STTDUEDT | Start Due Date |
Date | 4 | View | |
ENDDUEDT | End Due Date |
Date | 4 | View | |
MRPQUERYIV_1 | MRPQueryIV[1] |
Boolean | 2 | View | |
MRPQUERYIV_2 | MRPQueryIV[2] |
Boolean | 2 | View | |
MRPQUERYIV_3 | MRPQueryIV[3] |
Boolean | 2 | View | |
MRPQUERYIV_4 | MRPQueryIV[4] |
Boolean | 2 | View | |
MRPQUERYPO_1 | MRPQueryPO[1] |
Boolean | 2 | View | |
MRPQUERYPO_2 | MRPQueryPO[2] |
Boolean | 2 | View | |
MRPQUERYPO_3 | MRPQueryPO[3] |
Boolean | 2 | View | |
MRPQUERYPO_4 | MRPQueryPO[4] |
Boolean | 2 | View | |
MRPQUERYSO_1 | MRPQuerySO[1] |
Boolean | 2 | View | |
MRPQUERYSO_2 | MRPQuerySO[2] |
Boolean | 2 | View | |
MRPQUERYSO_3 | MRPQuerySO[3] |
Boolean | 2 | View | |
MRPQUERYSO_4 | MRPQuerySO[4] |
Boolean | 2 | View | |
MRPQUERYSO_5 | MRPQuerySO[5] |
Boolean | 2 | View | |
MRPQUERYSO_6 | MRPQuerySO[6] |
Boolean | 2 | View | |
MRPQUERYSO_7 | MRPQuerySO[7] |
Boolean | 2 | View | |
MRPQUERYMO_1 | MRPQueryMO[1] |
Boolean | 2 | View | |
MRPQUERYMO_2 | MRPQueryMO[2] |
Boolean | 2 | View | |
MRPQUERYMO_3 | MRPQueryMO[3] |
Boolean | 2 | View | |
MRPQUERYMO_4 | MRPQueryMO[4] |
Boolean | 2 | View | |
MRPQUERYMO_5 | MRPQueryMO[5] |
Boolean | 2 | View | |
MRPQUERYMO_6 | MRPQueryMO[6] |
Boolean | 2 | View | |
MRPQUERYPK_1 | MRPQueryPK[1] |
Boolean | 2 | View | |
MRPQUERYPK_2 | MRPQueryPK[2] |
Boolean | 2 | View | |
MRPQUERYPK_3 | MRPQueryPK[3] |
Boolean | 2 | View | |
MRPQUERYPK_4 | MRPQueryPK[4] |
Boolean | 2 | View | |
MRPQUERYPK_5 | MRPQueryPK[5] |
Boolean | 2 | View | |
MRPQUERYPK_6 | MRPQueryPK[6] |
Boolean | 2 | View | |
MRPQUERYSUGGESTIONS_1 | MRPQuerySuggestions[1] |
Boolean | 2 | View | |
MRPQUERYSUGGESTIONS_2 | MRPQuerySuggestions[2] |
Boolean | 2 | View | |
MRPQUERYSUGGESTIONS_3 | MRPQuerySuggestions[3] |
Boolean | 2 | View | |
MRPQUERYSUGGESTIONS_4 | MRPQuerySuggestions[4] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_1 | MRPQueryExceptions[1] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_2 | MRPQueryExceptions[2] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_3 | MRPQueryExceptions[3] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_4 | MRPQueryExceptions[4] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_5 | MRPQueryExceptions[5] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_6 | MRPQueryExceptions[6] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_7 | MRPQueryExceptions[7] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_8 | MRPQueryExceptions[8] |
Boolean | 2 | View | |
MRPQUERYEXCEPTIONS_9 | MRPQueryExceptions[9] |
Boolean | 2 | View | |
MRPQUERYDUEDATE | MRPQueryDueDate |
Integer | 2 | View | |
MRPQUERYRLSDATE | MRPQueryReleaseDate |
Integer | 2 | View |