|
|
RETURNDTL FILE
Return Detail
The Return Detail file contains detail information about the lines on a
return. For example, if the return was entered and goods belonging to a lot
or serial number were returned to inventory, they would have records created
in this file. Their records indicate the serial number and where they belong
in inventory.
REFERENCED BY
OE530 OE86.1 OE86.2
UPDATED BY
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE330
OE830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RLD-COMPANY Numeric 4 OE30.4 OE30.5
Element: Company This field contains the company number. OE30.6 OE30.7
OE30.9 OE830
RLD-AUTH-NO Numeric 10 OE30.4 OE30.5
Element: Auth No This field contains the authorization OE30.6 OE30.7
number for the return line. OE30.9 OE830
RLD-LINE-NBR Numeric 6 OE30.4 OE30.5
Element: Line Number This field contains the line number. OE30.6 OE30.7
OE30.9 OE830
RLD-UOM Alpha 4 OE30.4 OE30.5
Element: Unit of MeasurThis field contains the valid stock OE30.6 OE30.7
unit of measure for this item. OE30.9 OE830
RLD-UOM-MULT Signed 13.7 OE30.4 OE30.5
Unit of Measure This field contains the multiplier for OE30.6 OE30.7
Multiplier converting this unit of measure to stock OE30.9 OE830
unit of measure.
RLD-LOT Alpha 10 OE30.5 OE30.9
Element: Lot Number This field contains the identifier for OE830
the homogeneous quantity of material.
RLD-SUBLOT Alpha 6 OE30.5 OE30.9
Element: Sublot Number This field contains the identifier for OE830
a detail breakdown of a lot number.
RLD-BIN Alpha 7 OE30.4 OE30.5
Element: Bin This field contains a storage area for OE30.6 OE30.9
an item or any number of items. OE830
RLD-SERIAL Alpha 16 OE30.6 OE30.9
Element: Serial Number This field contains the serial number OE830
assigned to the item being returned.
RLD-QUANTITY Signed 13.4 OE30.4 OE30.5
Element: Quantity This field contains the desired OE30.6 OE30.7
quantity. OE30.9 OE830
RLD-CATCH-WT-QTY Signed 13.4 OE30.4 OE30.5
Element: Quantity This field contains the quantity OE30.9 OE830
received for catch weight shipments.
RLD-SUOM Derived
Element: Suom This field contains the selling unit of
measure of the item.
RLD-LOT-STRING Derived
Element: Lot String This field contains the lot number
assigned to the returned item.
RLD-BIN-STRING Derived
Element: Bin String This field contains the bin number
assigned to the returned item.
RLD-SERIAL-STRING Derived
Element: Serial String This field contains the serial number
assigned to the returned item.
RLD-UOM-STRING Derived
Element: Uom String This field contains the unit of measure
of the returned item, if multiple unit
of measures are available.
RETURNDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RLDSET1 COMPANY OE30.1 OE30.2
AUTH-NO OE30.3 OE30.4
LINE-NBR OE30.5 OE30.6
UOM OE30.7 OE30.9
LOT OE330 OE530
SUBLOT OE830 OE86.1
BIN OE86.2
SERIAL
RETURNDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
RLD-COMPANY -> ICC-COMPANY
Itemloc ITEMLOC Required
RLD-COMPANY -> ITL-COMPANY
RTL-LOCATION -> ITL-LOCATION
RTL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
RTL-ITEM -> ITE-ITEM
Itserial ITSERIAL Required
When ITE-SER-TRACK-FL != "N"
RLD-COMPANY -> SER-COMPANY
RTL-ITEM -> SER-ITEM
RLD-SERIAL -> SER-SERIAL
Oeinvcdtl OEINVCDTL Not Required
RLD-COMPANY -> OID-COMPANY
RTN-ORIG-INVC-PRE -> OID-INVC-PREFIX
RTN-ORIG-INVC-NBR -> OID-INVC-NUMBER
RLD-LINE-NBR -> OID-LINE-NBR
RLD-UOM -> OID-UOM
RLD-LOT -> OID-LOT
RLD-SUBLOT -> OID-SUBLOT
RLD-BIN -> OID-BIN
RLD-SERIAL -> OID-SERIAL
Returnhdr RETURNHDR Required
RLD-COMPANY -> RTN-COMPANY
RLD-AUTH-NO -> RTN-AUTH-NO
Returnline RETURNLINE Required
RLD-COMPANY -> RTL-COMPANY
RLD-AUTH-NO -> RTL-AUTH-NO
RLD-LINE-NBR -> RTL-LINE-NBR
Sohdetail SOHDETAIL Not Required
RLD-COMPANY -> SDT-COMPANY
RTL-LOCATION -> SDT-LOCATION
ICC-ITEM-GROUP -> SDT-ITEM
RLD-UOM -> SDT-UOM
RLD-LOT -> SDT-LOT
RLD-SUBLOT -> SDT-SUBLOT
RLD-BIN -> SDT-BIN
|
