RQLINEDTL

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


RQLINEDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQDSET1 COMPANY
REQ-NUMBER
LINE-NBR
BIN
LOT-SERIAL
UOM
RQ35.1 RQ39.1
RQ39.2 RQ39.3
RQD0.1


RQLINEDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Rqaudit RQAUDIT
"LD"->RHA-AUDIT-TYPE
RQD-COMPANY->RHA-COMPANY
RQD-REQ-NUMBER->RHA-REQ-NUMBER
RQD-LINE-NBR->RHA-LINE-NBR
Zeroes->RHA-LINE-SEQ
RQD-BIN->RHA-BIN
RQD-LOT-SERIAL->RHA-LOT-SERIAL
RQD-UOM->RHA-UOM
  RHA-DATE
  RHA-TIME
  RHA-FLD-NBR


File created: Thu Jun 09 02:32:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.