|
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
RQ35.1 RQ39.1 RQ39.2 RQ39.3 RQD0.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQD-COMPANY Numeric 4 RQ35.1 RQ39.1
Element: Company Identifies the AP company if the RQ39.2 RQ39.3
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
RQD-REQ-NUMBER Numeric 7 RQ35.1 RQ39.1
Element: Req Number This is the assigned number to identify RQ39.2 RQ39.3
this requisition.
RQD-LINE-NBR Numeric 6 RQ35.1 RQ39.1
Element: Line Nbr This is the requisition line number. RQ39.2 RQ39.3
RQD-BIN Alpha 7 RQ35.1 RQ39.1
Element: Bin This field contains a storage area for RQ39.2 RQ39.3
an item or any number of items.
RQD-LOT-SERIAL Alpha 16 RQ35.1 RQ39.1
Element: Serial RQ39.2 RQ39.3
RQD-UOM Alpha 4 RQ35.1 RQ39.1
Element: Uom This field contains the valid stock RQ39.2 RQ39.3
unit of measure for this item.
RQD-UOM-MULT Signed 13.7 RQ35.1 RQ39.1
Element: Uom Mult This field contains the multiplier for RQ39.2 RQ39.3
converting this unit of measure to the
stock unit of measure.
RQD-QUANTITY Signed 13.4 RQ35.1 RQ39.1
Element: Quantity This is the detail transaction quantity. RQ39.2 RQ39.3
RQLINEDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQDSET1 COMPANY RQ35.1 RQ39.1
REQ-NUMBER RQ39.2 RQ39.3
LINE-NBR RQD0.1
BIN
LOT-SERIAL
UOM
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
|