MACRECLINE FILE UPDATED BY PO53.1 PO530 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY MRL-COMPANY Numeric 4 PO53.1 Company The company number represents an established company and is entered on all function codes. MRL-REFERENCE-NO Alpha 10 (Right Justified) PO53.1 Reference No MRL-LINE-NBR Numeric 6 PO53.1 Line Number This field contains the line number. MRL-REC-NUMBER Alpha 10 (Right Justified) Receiver Number The receiver number. Assigned when this receiving information was added. MRL-ITEM Alpha 32 Item Number This field contains the item identifier. MRL-DESCRIPTION Alpha 30 (Lower Case) PO53.1 Description This field contains the description. MRL-ITEM-TYPE Alpha 1 PO53.1 Item Type This field identifies the line item type. MRL-VEN-ITEM Alpha 32 PO53.1 Vendor Item The vendor's item identifer. MRL-LOCATION Alpha 5 PO53.1 Location Code This field contains a valid stocking location within the company inventory. MRL-ENT-REC-QTY Signed 13.4 PO53.1 Entered Received Entered receipt quantity. Quantity MRL-ENT-REC-UOM Alpha 4 PO53.1 Entered Received UOM Entered valid receipt unit of measure. MRL-ENT-RUOM-MULT Signed 13.7 Entered Recvd UOM This multiplier is used to convert Multiplier entered unit of measure quantity down to stocking unit of measure. MRL-CATCH-WT-QTY Signed 13.4 PO53.1 Catch Weight This field contains the quantity Quantity received for catch weight shipments. MRL-ORIG-UNIT-COST Signed 13.5 Orig Unit Cost MRL-BIN Alpha 7 Bin This field contains a storage area for an item or any number of items. MRL-CANCEL-BO-FL Alpha 1 Cancel Back Order This flag indicates whether the Flag backordered quantity is to be cancelled and the line is to be considered closed. MRL-STATUS Numeric 1 PO53.1 Status This field contains the status of the transaction. MRL-UPDATE-DATE Numeric 8 (yyyymmdd) PO53.1 Update Date This field contains the date the record was updated. MRL-UPDATE-TIME Numeric 6 PO53.1 Update Time This field contains the system time when the record was updated. MRL-MSDS-FLAG Alpha 1 Material Safety This flag indicates if this item DataSheet Flag requires a Material Safety Data Sheet. MRL-MSDS-DOCUMENT Alpha 30 Msds Document The document number from the most recent MSDS that was received. MRL-MSDS-VERSION Alpha 4 Msds Version The version number of the most recent MSDS that was received. MRL-REJECT-QTY Signed 13.4 Inspection Reject Quantity MACRECLINE FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN MRLSET1 COMPANY PO53.1 PO53.3 REFERENCE-NO PO530 LINE-NBR MACRECLINE FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Macrechdr MACRECHDR Required MRL-COMPANY -> MRH-COMPANY MRL-REFERENCE-NO -> MRH-REFERENCE-NO MACRECLINE FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Macrecpot MACRECPOT MRL-COMPANY -> MRP-COMPANY MRL-REFERENCE-NO -> MRP-REFERENCE-NO MRL-LINE-NBR -> MRP-LINE-NBR MRP-SEQ |