RQLINEDTL FILE
Requisition Line Details
This file contains requisition line detail records. These are created if the
item is an inventory item and it was picked from or returned to multiple bins
and/or is lot or serial tracked.
UPDATED BY
RQ39.1 RQ39.2 RQ39.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQD-COMPANY Numeric 4 RQ39.1 RQ39.2
Company The company number represents an RQ39.3
established company and is entered on
all function codes.
RQD-REQ-NUMBER Numeric 7 RQ39.1 RQ39.2
Requisition Number This is the assigned number to identify RQ39.3
this requisition.
RQD-LINE-NBR Numeric 6 RQ39.1 RQ39.2
Line Number This is the requisition line number. RQ39.3
RQD-BIN Alpha 7 RQ39.1 RQ39.2
Bin This field contains a storage area for RQ39.3
an item or any number of items.
RQD-LOT-SERIAL Alpha 16 RQ39.1 RQ39.2
Lot/Serial Number This is the lot/sublot or serial number RQ39.3
for this detail record.
RQD-UOM Alpha 4 RQ39.1 RQ39.2
Unit of Measure This field contains the valid stock RQ39.3
unit of measure for this item.
RQD-UOM-MULT Signed 13.7 RQ39.1 RQ39.2
Unit of Measure This field contains the multiplier for RQ39.3
Multiplier converting this unit of measure to the
stock unit of measure.
RQD-QUANTITY Signed 13.4 RQ39.1 RQ39.2
Quantity This is the detail transaction quantity. RQ39.3
RQLINEDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQDSET1 COMPANY This index is used to access a RQ39.1 RQ39.2
REQ-NUMBER requisition line detail record by RQ39.3
LINE-NBR company; requisition number; line; bin,
BIN lot number, serial number, or a
LOT-SERIAL combination thereof; and unit of
UOM measure.
RQLINEDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Req Line REQLINE Required
RQD-COMPANY -> RLN-COMPANY
RQD-REQ-NUMBER -> RLN-REQ-NUMBER
RQD-LINE-NBR -> RLN-LINE-NBR
Serial ITSERIAL Not Required
RQD-COMPANY -> SER-COMPANY
RLN-ITEM -> SER-ITEM
RQD-LOT-SERIAL -> SER-SERIAL
RQLINEDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Return Detail RQLINEDTL Delete Restricted
RQD-COMPANY -> RQD-COMPANY
RQD-REQ-NUMBER -> RQD-REQ-NUMBER
RQD-LINE-NBR -> RQD-LINE-NBR
RQD-BIN
RQD-LOT-SERIAL
RQD-UOM
|
