RETURNLINE FILE
Return Line
The Return Line file contains the lines entered on a return.
REFERENCED BY
OE230 OE530 OE85.1 SA100
UPDATED BY
OE130 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE330 OE830 OE950
OE963 OE990
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTL-COMPANY Numeric 4 OE30.2 OE30.3
Company This field contains the company number. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-AUTH-NO Numeric 10 OE30.2 OE30.3
Authorization Number This field contains the authorization OE30.4 OE30.5
number of the user who is entering the OE30.6 OE30.7
return. OE30.9 OE830
OE950 OE963
RTL-LINE-NBR Numeric 6 OE30.2 OE30.3
Line Number This field contains the line number. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-CUSTOMER Alpha 9 (Right Justified) OE30.2 OE30.3
Customer This field contains the number that OE30.4 OE30.5
represents a customer. OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-ORDER-NBR Numeric 8 OE30.2 OE30.3
Order Number This field contains the order number. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-ORIG-LINE-NBR Numeric 6 OE530 OE963
Original Line Number This field contains the original line
number.
RTL-LOCATION Alpha 5 OE30.2 OE30.3
Location This field contains a valid stock OE30.4 OE30.5
location within the company inventory. OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-DATE Numeric 8 (yyyymmdd) OE30.2 OE30.3
Date This field contains the system date OE30.4 OE30.5
when the return was created. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-ITEM Alpha 32 OE30.2 OE30.3
Item This field contains the item OE30.4 OE30.5
identifier. OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-DESCRIPTION Alpha 30 (Lower Case) OE30.2 OE30.3
Description This field contains the item OE30.4 OE30.5
description. OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-LINE-TYPE Alpha 1 OE30.2 OE30.3
Line Type This field contains the type of OE30.4 OE30.5
inventory on this line. OE30.6 OE30.7
I = Inventoried OE30.9 OE530
N = Non-Stock OE830 OE950
X = Special OE963
RTL-REASON-CODE Alpha 4 OE30.2 OE30.3
Reason Code This field contains the reason code, OE30.4 OE30.5
which indicates the cause for credit OE30.6 OE30.7
memos. OE30.9 OE530
OE830 OE950
OE963
RTL-SHIP-TO Numeric 4 OE30.2 OE30.3
Ship-to This field contains the number OE30.4 OE30.5
representing the ship-to customer. OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-QUANTITY Signed 13.4 OE30.1 OE30.2
Quantity This field contains the return quantity OE30.3 OE30.4
in sell unit of measure. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE963
RTL-SELL-UOM Alpha 4 OE30.2 OE30.3
Sell Unit of Measure This field contains the stock unit of OE30.4 OE30.5
measure for the item. If entered, it OE30.6 OE30.7
must be a valid stock unit of measure OE30.9 OE530
for this item. If not entered, the OE830 OE950
default stock unit of measure for this OE963
item is assigned.
RTL-INVC-CW-QTY Signed 13.4 OE30.2 OE30.3
Invoice Catch This field contains the invoice catch OE30.4 OE30.5
Weight Quantity weight quantity. This field is valid OE30.6 OE30.7
only for catch weight items. This is OE30.9 OE530
used in extended price calculation, but OE830 OE950
quantity is used for pricing. OE963
RTL-INVEN-CW-QTY Signed 13.4 OE30.2 OE30.3
Inventory Catch This field contains the inventory catch OE30.4 OE30.5
Weight Qty weight quantity. This field is used OE30.6 OE30.7
only for credit memo catch weight items, OE30.9 OE530
if the item is returned to inventory. OE830 OE950
This is defaulted from invoice catch OE963
weight quantity.
RTL-ENTERED-PRICE Signed 13.5 OE30.2 OE30.3
Entered Price This field contains the price of the OE30.4 OE30.5
line in original billing currency. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-STD-COST Signed 13.5 OE30.2 OE30.3
Standard Cost This field contains the cost of the OE30.4 OE30.5
item that is being returned if the OE30.6 OE30.7
company is using standard costing. OE30.9 OE530
OE830 OE950
OE963
RTL-SELL-TO-STOCK Signed 13.7 OE30.2 OE30.3
Sell-to Stock This field contains a conversion factor OE30.4 OE30.5
for converting the line amount from sell OE30.6 OE30.7
to stock unit of measure. OE30.9 OE530
OE830 OE950
OE963
RTL-UNIT-PRICE Signed 13.5 OE30.2 OE30.3
Unit Price This field contains the unit price in OE30.4 OE30.5
company base currency. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-BASE-PRICE Signed 13.5 OE30.2 OE30.3
Base Price This field contains the base price from OE30.4 OE30.5
the order. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-SPR-UOM Alpha 4 OE30.2 OE30.3
Sell Price Unit of This field contains the sell pricing OE30.4 OE30.5
Measure unit of measure. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-SPR-TO-STOCK Signed 13.7 OE30.1 OE30.2
Sell Price to Stock This field contains the conversion OE30.3 OE30.4
factor from price to stock unit of OE30.5 OE30.6
measure. OE30.7 OE30.9
OE830 OE950
OE963
RTL-ORIG-UNIT-COST Signed 13.5 OE530 OE963
Original Unit Cost This field contains the original unit
cost for the return line.
RTL-ENT-UNIT-COST Signed 13.5 OE30.2 OE30.3
Entry Unit Cost This field contains the entered unit OE30.4 OE30.5
cost for the return line. OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-UNIT-COST Signed 13.5 OE30.2 OE30.3
Unit Cost This field contains the approved unit OE30.4 OE30.5
cost for this invoice line item in OE30.6 OE30.7
company base currency. OE30.9 OE530
OE830 OE950
OE963
RTL-ACTIVITY Alpha 15 OE30.2 OE30.3
Activity This field contains the activity for OE30.4 OE30.5
the sales account. OE30.6 OE30.7
OE30.9 OE830
Activities are the processes or OE950 OE963
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Lawson Activity
Management system. Direct costs are
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
RTL-ACCT-CATEGORY Alpha 5 OE30.2 OE30.3
Account Category This field contains the account OE30.4 OE30.5
category for the sales account. OE30.6 OE30.7
OE30.9 OE830
Account categories are groupings of OE950 OE963
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
RTL-CUST-REQ-ACT Alpha 1 OE30.2 OE30.3
Customer This field indicates whether the OE30.4 OE30.5
customer wants a credit memo issued or OE30.6 OE30.7
replacement of goods. OE30.9 OE830
C = Credit Memo OE950 OE963
R = Replacement
RTL-RESTK-CHG-CODE Alpha 16 OE30.2 OE30.3
Restock Charge Code This field contains the add-on charge OE30.4 OE30.5
code indicating whether you want to OE30.6 OE30.7
charge the customer for restocking. OE30.9 OE530
OE830 OE950
OE963
RTL-INV-DISP-CD Alpha 1 OE30.2 OE30.3
Inventory Display This field indicates where to place OE30.4 OE30.5
Code returned items. OE30.6 OE30.7
R = Return To Stock OE30.9 OE530
S = Scrap OE830 OE950
I = Ignore OE963
RTL-CREATE-CM-CD Alpha 1 OE30.2 OE30.3
Create Credit Memo This field indicates whether or not to OE30.4 OE30.5
create a credit memo. OE30.6 OE30.7
Y = Yes OE30.9 OE530
N = No OE830 OE950
OE963
RTL-DETAIL-QTY Signed 13.4 OE30.2 OE30.3
Detail Quantity This field contains the summation of OE30.4 OE30.5
all detail line quantity in stock unit OE30.6 OE30.7
of measure. OE30.9 OE530
OE830 OE950
OE963
RTL-DTL-CW-QTY Signed 13.4 OE30.2 OE30.3
Detail Catch Weight This field contains the total of all OE30.4 OE30.5
Quantity catch weights for all lots, bins, and OE30.6 OE30.7
serial numbers. OE30.9 OE530
OE830 OE950
OE963
RTL-SLS-ACCT-UNIT Alpha 15 OE30.2 OE30.3
Sales Account Unit This field contains the sales OE30.4 OE30.5
accounting unit to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-SLS-ACCOUNT Numeric 6 OE30.2 OE30.3
Sales Account This field contains the sales account OE30.4 OE30.5
to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-SLS-SUB-ACCT Numeric 4 OE30.2 OE30.3
Sales Sub-account This field contains the sales OE30.4 OE30.5
subaccount to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-OFF-ACCT-UNIT Alpha 15 OE30.2 OE30.3
COGS Offset Account This field contains the COGS offset OE30.4 OE30.5
Unit account unit to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-OFF-ACCOUNT Numeric 6 OE30.2 OE30.3
COGS Offset Account This field contains the COGS offset OE30.4 OE30.5
account to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-OFF-SUB-ACCT Numeric 4 OE30.2 OE30.3
COGS Offset This field contains the COGS offset OE30.4 OE30.5
Sub-account subaccount to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-CGS-ACCT-UNIT Alpha 15 OE30.2 OE30.3
COGS Account Unit This field contains the COGS account OE30.4 OE30.5
unit to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-CGS-ACCOUNT Numeric 6 OE30.2 OE30.3
COGS Account This field contains the COGS account to OE30.4 OE30.5
post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-CGS-SUB-ACCT Numeric 4 OE30.2 OE30.3
COGS Sub-account This field contains the COGS subaccount OE30.4 OE30.5
to post to. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-CV-ACCT-UNIT Alpha 15 OE30.2 OE30.3
Cost Variance This field contains the cost variance OE30.4 OE30.5
Accounting Unit accounting unit. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-CV-ACCOUNT Numeric 6 OE30.2 OE30.3
Cost Variance This field contains the cost variance OE30.4 OE30.5
Account account. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-CV-SUB-ACCT Numeric 4 OE30.2 OE30.3
Cost Variance This field contains the cost variance OE30.4 OE30.5
Subaccount subaccount. OE30.6 OE30.7
OE30.9 OE830
OE950 OE963
RTL-PO-NUMBER Alpha 7 (Right Justified) OE30.2 OE30.3
Purchase Order This field contains the number OE30.4 OE30.5
Number representing the purchase order. OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE963
RTL-LAST-COMM-SEQ Numeric 3 OE530 OE963
Last Comment Line This is the sequence number of the last
Sequence comment line entered for this return
line.
RTL-STATUS Numeric 1 OE530 OE990
Status This field contains the return status.
0 = Edit
1 = Fully Received
3 = Shipd To Vend
9 = Closed
RTL-AVERAGE-COST Signed 13.5 OE30.1 OE30.2
Average Cost This field contains the cost of the OE30.3 OE30.4
item that is being returned if the OE30.5 OE30.6
company is using average costing. OE30.7 OE30.9
OE530 OE830
OE950 OE963
RTL-SOH-QTY Signed 13.4 OE30.1 OE30.2
Stock On-hand This field contains the quantity that OE30.3 OE30.4
Quantity is currently on hand in inventory. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE963
RTL-ACTIVITY-C Alpha 15 OE30.2 OE30.3
Activity C This field contains the activity for OE30.4 OE30.5
the Cost (COGS) account. OE30.6 OE30.7
OE30.9 OE530
Activities are the processes or OE830 OE950
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Lawson Activity
Management system. Direct costs are
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
RTL-ACCT-CATEG-C Alpha 5 OE30.2 OE30.3
Account Category C This field contains the account OE30.4 OE30.5
category for the Cost (COGS) account. OE30.6 OE30.7
OE30.9 OE530
Account categories are groupings of OE830 OE950
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
RTL-ATN-OBJ-ID-C Numeric 12 OE30.1 OE30.2
Activity Management This field contains the system-defined OE30.3 OE30.4
Object ID object ID representing the Activity OE30.5 OE30.6
Management commitment for Cost (COGS). OE30.7 OE30.9
OE530 OE830
OE950
RETURNLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTLSET1 COMPANY OE130 OE230
AUTH-NO OE30.1 OE30.2
LINE-NBR OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE330 OE530
OE830 OE85.1
OE950 OE963
OE990 SA100
RTLSET2 COMPANY
CUSTOMER
ITEM
SHIP-TO
DATE
AUTH-NO
LINE-NBR
RTLSET3 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
RETURNLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cogs Account GLMASTER Not Required
Valid When RTL-CGS-ACCT-UNIT != Spaces
Or RTL-CGS-ACCOUNT != Zeroes
Or RTL-CGS-SUB-ACCT != Zeroes
RTL-COMPANY -> GLM-COMPANY
RTL-CGS-ACCT-UNIT -> GLM-ACCT-UNIT
RTL-CGS-ACCOUNT -> GLM-ACCOUNT
RTL-CGS-SUB-ACCT -> GLM-SUB-ACCOUNT
Cogs Offset GLMASTER Not Required
Valid When RTL-OFF-ACCT-UNIT != Spaces
Or RTL-OFF-ACCOUNT != Zeroes
Or RTL-OFF-SUB-ACCT != Zeroes
RTL-COMPANY -> GLM-COMPANY
RTL-OFF-ACCT-UNIT -> GLM-ACCT-UNIT
RTL-OFF-ACCOUNT -> GLM-ACCOUNT
RTL-OFF-SUB-ACCT -> GLM-SUB-ACCOUNT
Coline COLINE Not Required
Valid When RTL-ORDER-NBR != Zeroes
RTL-COMPANY -> COL-COMPANY
RTL-ORDER-NBR -> COL-ORDER-NBR
RTL-ORIG-LINE-NBR -> COL-LINE-NBR
Glsystem GLSYSTEM Required
RTL-COMPANY -> GLS-COMPANY
Iccompany ICCOMPANY Required
RTL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
RTL-COMPANY -> ICL-COMPANY
RTL-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Not Required
Valid When RTL-LINE-TYPE = "I"
RTL-COMPANY -> ITL-COMPANY
RTL-LOCATION -> ITL-LOCATION
RTL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When RTL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
RTL-ITEM -> ITE-ITEM
Oecompany OECOMPANY Required
RTL-COMPANY -> OEC-COMPANY
Oeinvcline OEINVCLINE Required
When RTL-ORIG-INVC-PRE != Spaces
Or RTL-ORIG-INVC-NBR != Zeroes
RTL-COMPANY -> OIL-COMPANY
RTN-ORIG-INVC-PRE -> OIL-INVC-PREFIX
RTN-ORIG-INVC-NBR -> OIL-INVC-NUMBER
RTL-ORIG-LINE-NBR -> OIL-LINE-NBR
Oemisc OEMISC Not Required
Valid When RTL-RESTK-CHG-CODE != Spaces
RTL-COMPANY -> OEM-COMPANY
RTL-RESTK-CHG-CODE -> OEM-MISC
RTN-CURRENCY-CODE -> OEM-CURRENCY-CODE
Oereason OEREASON Required
When RTL-REASON-CODE != Spaces
RTL-COMPANY -> OER-COMPANY
RTL-REASON-CODE -> OER-REASON-CODE
Reason OEREASON Required
When RTL-REASON-CODE != Spaces
RTL-COMPANY -> OER-COMPANY
RTL-REASON-CODE -> OER-REASON-CODE
Returnhdr RETURNHDR Required
RTL-COMPANY -> RTN-COMPANY
RTL-AUTH-NO -> RTN-AUTH-NO
Returnsgbk RETURNSGBK Not Required
RTL-COMPANY -> RSB-COMPANY
RTL-AUTH-NO -> RSB-AUTH-NO
RTL-LINE-NBR -> RSB-LINE-NBR
Sales Account GLMASTER Required
RTL-COMPANY -> GLM-COMPANY
RTL-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
RTL-SLS-ACCOUNT -> GLM-ACCOUNT
RTL-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
RETURNLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bins WHSHLDTL
Valid When RTL-LOT-TRACK-FL = "N"
And RTL-BIN-TRACK-FL = "Y"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-ORIG-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Lots WHSHLDTL
Valid When RTL-LOT-TRACK-FL = "Y"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-ORIG-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Oeshipdtl WHSHLDTL
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-ORIG-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Returndtl RETURNDTL
RTL-COMPANY -> RLD-COMPANY
RTL-AUTH-NO -> RLD-AUTH-NO
RTL-LINE-NBR -> RLD-LINE-NBR
RLD-UOM
RLD-LOT
RLD-SUBLOT
RLD-BIN
RLD-SERIAL
Serials WHSHLDTL
Valid When RTL-SER-TRACK-FL = "R"
Or RTL-SER-TRACK-FL = "I"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-ORIG-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Sohdetail SOHDETAIL
RTL-COMPANY -> SDT-COMPANY
RTL-LOCATION -> SDT-LOCATION
RTL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Uoms WHSHLDTL
Valid When RTL-MULT-UOMS > Zeroes
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-ORIG-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
|