Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
MANUFACTUREORDER_I | Manufacture Order |
String | 32 | View | |
SEQ_I | Seq |
Long Integer | 4 | View | |
MANUFACTUREORDERST_I | Manufacture Order Status |
Integer | 2 | View | |
PPN_I | PPN |
String | 32 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
POSITION_NUMBER | Position Number |
Integer | 2 | View | |
ROUTINGNAME_I | RoutingName |
String | 32 | View | |
RTSEQNUM_I | rtseqnum |
String | 12 | View | |
MRPAMOUNT_I | MRP_Amount |
Currency | 10 | View | |
MRPAMOUNT2_I | MRP_Amount2 |
Currency | 10 | View | |
SUGGESTEDQTY_I | Suggested QTY |
Currency | 10 | View | |
MRPISSUEDATE_I | MRP_Issue Date |
Date | 4 | View | |
MRPISSUETIME_I | MRP_Issue Time |
Time | 4 | View | |
ALLOCATEDATEI | Allocate_Date |
Date | 4 | View | |
ALLOCATETIMEI | Allocate_Time |
Time | 4 | View | |
WCID_I | WC ID |
String | 12 | View | |
BACKFLUSHITEM_I | Backflush Item |
Boolean | 2 | View | |
ICBACKORDER_I | IC Backorder |
Boolean | 2 | View | |
ALTERNATE_I | Alternate |
Boolean | 2 | View | |
ALTERNATEPARTFOR_I | Alternate Part For |
String | 32 | View | |
ALT_FOR_SEQ_I | Alternate For Sequence |
Long Integer | 4 | View | |
SUBASSEMBLY_I | Subassembly |
Boolean | 2 | View | |
SUBASSEMBLYOF_I | Subassembly Of |
String | 32 | View | |
SUBASSEMBLY_OF_SEQ | Subassembly Of Seq |
Long Integer | 4 | View | |
BOMENGAPPROVAL_I | BOM_Eng_Approval |
Boolean | 2 | View | |
BOMSINGLELOT_I | BOM_Single_Lot |
Boolean | 2 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
ALLOCATED_I | Allocated |
Boolean | 2 | View | |
ISSUED_I | Issued |
Boolean | 2 | View | |
FLOORSTOCK_I | Floor Stock |
Boolean | 2 | View | |
CALCMRP_I | Calc MRP |
Boolean | 2 | View | |
PHANTOM_I | Phantom |
Boolean | 2 | View | |
CHANGEDATE_I | Change Date |
Date | 4 | View | |
USERID | User ID |
String | 16 | View | |
ALLOCATEUID_I | Allocate UID |
String | 16 | View | |
ISSUEDUID_I | Issued UID |
String | 16 | View | |
RELIEFCOST_I | Relief Cost |
Currency | 10 | View | |
RETURNTOSTOCK_I | Return To Stock |
Currency | 10 | View | |
NUMBERSCRAPPED_I | Number Scrapped |
Currency | 10 | View | |
ACTUAL_CONSUMED_I | Actual Consumed |
Currency | 10 | View | |
PORDNMBR | Purchase Order Number |
String | 22 | View | |
POLINE_I | PO Line Item |
Integer | 2 | View | |
QTY_ALLOWED_I | QTY Allowed |
Currency | 10 | View | |
CURRENT_CONSUMED_I | Current Consumed |
Currency | 10 | View | |
CURRENT_RTS_I | Current RTS |
Currency | 10 | View | |
CURRENT_SCRAPPED_I | Current Scrapped |
Currency | 10 | View | |
OPTIONED_ITEM_I | Optioned Item |
Boolean | 2 | View | |
MRKDNAMT | Markdown Amount |
Currency | 10 | View | |
BOMCAT_I | BOM Cat |
Integer | 2 | View | |
BOMNAME_I | BOM Name |
String | 16 | View | |
PROMOTION_ID_I | Promotion ID |
String | 32 | View | |
ACTUAL_CONSUMED_CHECK_I | Actual Consumed Check |
Boolean | 2 | View | |
REQDATE | Required Date |
Date | 4 | View | |
UOFM | U Of M |
String | 10 | View | |
ATYALLOC | QTY Allocated |
Currency | 10 | View | |
UNITCOST | Unit Cost |
Currency | 10 | View | |
NON_INV_CRED_ACCT_IDX_I | Non Inventory Credit Account Index |
Long Integer | 4 | View | |
QTYBSUOM | QTY In Base U Of M |
Currency | 10 | View | |
QTY_ISSUED_I | QTY Issued |
Currency | 10 | View | |
QTY_BACKFLUSHED_I | QTY Backflushed |
Currency | 10 | View | |
NON_INV_ITEM_DESC_I | Non Inventory Item Description |
String | 52 | View | |
LINK_TO_SEQUENCE_I | Link To Sequence |
Long Integer | 4 | View | |
FIXED_QTY_I | Fixed Quantity |
Currency | 10 | View | |
LEADTIMEOFFSET_I | Lead Time Offset |
Currency | 10 | View | |
OFFSET_FROM_I | Offset From |
Integer | 2 | View | |
BOMUSERDEF1_I | BOM User Def1 |
String | 32 | View | |
BOMUSERDEF2_I | BOM User Def2 |
String | 32 | View | |
EXPLODE_QTY_I | Explode Quantity |
Currency | 10 | View | |
MFGNOTEINDEX_I | MFG Note Index |
Currency | 10 | View | |
BOMSEQ_I | BOM Seq |
Long Integer | 4 | View | |
POSITION_NUMBER2 | Position Number2 |
Integer | 2 | View |