|
|
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.
UPDATED BY
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE330
OE830 OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RLD-COMPANY Numeric 4 OE30.4 OE30.5
Company This field contains the company number. OE30.6 OE30.7
OE30.9 OE830
OE950
RLD-AUTH-NO Numeric 10 OE30.4 OE30.5
Authorization Number This field contains the authorization OE30.6 OE30.7
number for the return line. OE30.9 OE830
OE950
RLD-LINE-NBR Numeric 6 OE30.4 OE30.5
Line Numberq This field contains the line number. OE30.6 OE30.7
OE30.9 OE830
OE950
RLD-UOM Alpha 4 OE30.4 OE30.5
Unit of Measure This field contains the valid stock OE30.6 OE30.7
unit of measure for this item. OE30.9 OE830
OE950
RLD-UOM-MULT Signed 13.7 OE30.4 OE30.5
Unit of Measure This field contains the multiplier for OE30.6 OE30.7
Multiplierq converting this unit of measure to stock OE30.9 OE830
unit of measure. OE950
RLD-LOT Alpha 10 OE30.5 OE30.9
Lot This field contains the identifier for OE830 OE950
the homogeneous quantity of material.
RLD-SUBLOT Alpha 6 OE30.5 OE30.9
Sublot This field contains the identifier for OE830 OE950
a detail breakdown of a lot number.
RLD-BIN Alpha 7 OE30.4 OE30.5
Bin This field contains a storage area for OE30.6 OE30.9
an item or any number of items. OE830 OE950
RLD-SERIAL Alpha 16 OE30.6 OE30.9
Serial This field contains the serial number OE830 OE950
assigned to the item being returned.
RLD-QUANTITY Signed 13.4 OE30.4 OE30.5
Quantity This field contains the requested OE30.6 OE30.7
quantity. OE30.9 OE830
OE950
RLD-CATCH-WT-QTY Signed 13.4 OE30.4 OE30.5
Catch Weight This field contains the quantity OE30.9 OE830
Quantity received for catch weight shipments. OE950
RLD-SUOM Derived
Sell Unit of Measure This field contains the selling unit of
measure of the item.
RLD-LOT-STRING Derived
Lot String This field contains the lot number
assigned to the returned item.
RLD-BIN-STRING Derived
Bin String This field contains the bin number
assigned to the returned item.
RLD-SERIAL-STRING Derived
Serial String This field contains the serial number
assigned to the returned item.
RLD-UOM-STRING Derived
Unit of Measure This field contains the unit of measure
String 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 OE830
SUBLOT OE950
BIN
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 RLD-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
|