Lawson Insight Technical Documentation |
|
RETURNLINE
RETURNLINE FILE
Return Line
The Return Line file contains the lines entered on a return.
REFERENCED BY
IC11.1 OE230 OE85.1 OE86.1 OE86.3 OE86.4
SA100
UPDATED BY
OE130 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE330 OE530 OE830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTL-COMPANY Numeric 4 OE30.2 OE30.3
Element: Company This field contains the company number. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
RTL-AUTH-NO Numeric 10 OE30.2 OE30.3
Element: Auth No 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
RTL-LINE-NBR Numeric 6 OE30.2 OE30.3
Element: Line Number This field contains the line number. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
RTL-CUSTOMER Alpha 9 (Right Justified) OE30.2 OE30.3
Element: Customer NumbeThis field contains the number that OE30.4 OE30.5
represents a customer. OE30.6 OE30.7
OE30.9 OE830
RTL-ORDER-NBR Numeric 8 OE30.2 OE30.3
Element: Order Number This field contains the order number. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
RTL-LOCATION Alpha 5 OE30.2 OE30.3
Element: Location Code This field contains a valid stock OE30.4 OE30.5
location within the company inventory. OE30.6 OE30.7
OE30.9 OE830
RTL-DATE Numeric 8 (yyyymmdd) OE30.2 OE30.3
Element: Date This field contains the system date OE30.4 OE30.5
when the return was created. OE30.6 OE30.7
OE30.9 OE830
RTL-ITEM Alpha 32 OE30.2 OE30.3
Element: Item Number This field contains the item OE30.4 OE30.5
identifier. OE30.6 OE30.7
OE30.9 OE830
RTL-DESCRIPTION Alpha 30 (Lower Case) OE30.2 OE30.3
Element: Description This field contains the item OE30.4 OE30.5
description. OE30.6 OE30.7
OE30.9 OE830
RTL-LINE-TYPE Alpha 1 OE30.2 OE30.3
Element: Line Type This field contains the type of OE30.4 OE30.5
inventory on this line. OE30.6 OE30.7
I = Inventoried OE30.9 OE830
N = Non-Stock
X = Special
RTL-REASON-CODE Alpha 4 OE30.2 OE30.3
Element: 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 OE830
RTL-SHIP-TO Numeric 4 OE30.2 OE30.3
Element: Ship-to Code This field contains the number OE30.4 OE30.5
representing the ship to customer. OE30.6 OE30.7
OE30.9 OE830
RTL-QUANTITY Signed 13.4 OE30.2 OE30.3
Element: Quantity This field contains the return quantity OE30.4 OE30.5
in sell unit of measure. OE30.6 OE30.7
OE30.9 OE530
OE830
RTL-SELL-UOM Alpha 4 OE30.2 OE30.3
Element: Unit of MeasurThis 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 OE830
for this item. If not entered, the
default stock unit of measure for this
item is assigned.
RTL-INVC-CW-QTY Signed 13.4 OE30.2 OE30.3
Element: Quantity This field contains the invoice catch OE30.4 OE30.5
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
quantity is used for pricing.
RTL-INVEN-CW-QTY Signed 13.4 OE30.2 OE30.3
Element: Quantity This field contains the inventory catch OE30.4 OE30.5
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
This is defaulted from invoice catch
weight quantity.
RTL-ENTERED-PRICE Signed 18.5 OE30.2 OE30.3
Element: Intl Cost This field contains the price of the OE30.4 OE30.5
line in original billing currency. OE30.6 OE30.7
OE30.9 OE830
RTL-STD-COST Signed 18.5 OE30.1 OE30.2
Element: Intl 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 standard costing. OE30.7 OE30.9
OE530 OE830
RTL-SELL-TO-STOCK Signed 13.7 OE30.2 OE30.3
Element: 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 OE830
RTL-UNIT-PRICE Signed 18.5 OE30.2 OE30.3
Element: Intl Cost This field contains the unit price in OE30.4 OE30.5
company base currency. OE30.6 OE30.7
OE30.9 OE830
RTL-BASE-PRICE Signed 18.5 OE30.2 OE30.3
Element: Intl Cost This field contains the base price from OE30.4 OE30.5
the order. OE30.6 OE30.7
OE30.9 OE830
RTL-SPR-UOM Alpha 4 OE30.2 OE30.3
Element: Unit of MeasurThis field contains the sell pricing OE30.4 OE30.5
unit of measure. OE30.6 OE30.7
OE30.9 OE830
RTL-SPR-TO-STOCK Signed 13.7 OE30.1 OE30.2
Element: Sell 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
OE530 OE830
RTL-ENT-UNIT-COST Signed 18.5 OE30.2 OE30.3
Element: Intl Cost This field contains the entered unit OE30.4 OE30.5
cost for the return line. OE30.6 OE30.7
OE30.9 OE830
RTL-UNIT-COST Signed 18.5 OE30.2 OE30.3
Element: Intl 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 OE830
RTL-ACTIVITY Alpha 15 OE30.2 OE30.3
Element: 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
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
Element: Account CategoThis 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
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-ACTIVITY-C Alpha 15 OE30.2 OE30.3
Element: Activity This field contains the activity for OE30.4 OE30.5
the Cost (COGS) account. OE30.6 OE30.7
OE30.9 OE830
Activities are the processes or
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
Element: Account CategoThis field contains the account OE30.4 OE30.5
category for the Cost (COGS) account. OE30.6 OE30.7
OE30.9 OE830
Account categories are groupings of
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
Object This field contains the system-defined OE30.3 OE30.4
Identification object ID representing the Activity OE30.5 OE30.6
Management commitment for Cost (COGS). OE30.7 OE30.9
OE530 OE830
RTL-CUST-REQ-ACT Alpha 1 OE30.2 OE30.3
Element: Cust Req Act 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
R = Replacement
RTL-RESTK-CHG-CODE Alpha 16 OE30.2 OE30.3
Element: Restk Chg CodeThis 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 OE830
RTL-INV-DISP-CD Alpha 1 OE30.2 OE30.3
Element: Inv Disp Cd This field indicates where to place OE30.4 OE30.5
returned items. OE30.6 OE30.7
R = Return To Stock OE30.9 OE830
S = Scrap
I = Ignore
RTL-CREATE-CM-CD Alpha 1 OE30.2 OE30.3
Element: All Flag This field indicates whether or not to OE30.4 OE30.5
create a credit memo. OE30.6 OE30.7
Y = Yes OE30.9 OE830
N = No
RTL-DETAIL-QTY Signed 13.4 OE30.2 OE30.3
Element: 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
RTL-SLS-ACCT-UNIT Alpha 15 OE30.2 OE30.3
Element: Accounting UniThis field contains the sales OE30.4 OE30.5
accounting unit to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-SLS-ACCOUNT Numeric 6 OE30.2 OE30.3
Element: Account This field contains the sales account OE30.4 OE30.5
to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-SLS-SUB-ACCT Numeric 4 OE30.2 OE30.3
Element: Subaccount This field contains the sales OE30.4 OE30.5
subaccount to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-OFF-ACCT-UNIT Alpha 15 OE30.2 OE30.3
Element: Accounting UniThis field contains the COGS offset OE30.4 OE30.5
account unit to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-OFF-ACCOUNT Numeric 6 OE30.2 OE30.3
Element: Account This field contains the COGS offset OE30.4 OE30.5
account to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-OFF-SUB-ACCT Numeric 4 OE30.2 OE30.3
Element: Subaccount This field contains the COGS offset OE30.4 OE30.5
subaccount to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-CGS-ACCT-UNIT Alpha 15 OE30.2 OE30.3
Element: Accounting UniThis field contains the COGS account OE30.4 OE30.5
unit to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-CGS-ACCOUNT Numeric 6 OE30.2 OE30.3
Element: Account This field contains the COGS account to OE30.4 OE30.5
post to. OE30.6 OE30.7
OE30.9 OE830
RTL-CGS-SUB-ACCT Numeric 4 OE30.2 OE30.3
Element: Subaccount This field contains the COGS subaccount OE30.4 OE30.5
to post to. OE30.6 OE30.7
OE30.9 OE830
RTL-CV-ACCT-UNIT Alpha 15 OE30.2 OE30.3
Element: Accounting UniThis field contains the cost variance OE30.4 OE30.5
accounting unit. OE30.6 OE30.7
OE30.9 OE830
RTL-CV-ACCOUNT Numeric 6 OE30.2 OE30.3
Element: Account This field contains the cost variance OE30.4 OE30.5
account. OE30.6 OE30.7
OE30.9 OE830
RTL-CV-SUB-ACCT Numeric 4 OE30.2 OE30.3
Element: Subaccount This field contains the cost variance OE30.4 OE30.5
subaccount. OE30.6 OE30.7
OE30.9 OE830
RTL-PO-NUMBER Alpha 14 (Right Justified) OE30.2 OE30.3
Element: PO Number This field contains the number OE30.4 OE30.5
representing the purchase order. OE30.6 OE30.7
OE30.9 OE830
RTL-PO-CODE Alpha 4 OE30.2 OE30.3
Element: Po Code This is the purchase order code. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
RTL-STATUS Numeric 1 OE130 OE30.1
Element: Status This field contains the return status. OE30.2 OE30.3
0 = Entered OE30.4 OE30.5
1 = Released OE30.6 OE30.7
9 = Closed OE30.9 OE530
OE830
RTL-AVERAGE-COST Signed 18.5 OE30.1 OE30.2
Element: Intl 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
RTL-SOH-QTY Signed 13.4 OE30.1 OE30.2
Element: Quantity This field contains the quantity that OE30.3 OE30.4
is currently on hand in inventory. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RETURNLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTLSET1 COMPANY IC11.1 OE130
AUTH-NO OE230 OE30.1
LINE-NBR OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE330
OE530 OE830
OE85.1 OE86.1
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
RTLSET4 COMPANY KeyChange OE86.3
ITEM
STATUS
AUTH-NO
LINE-NBR
RTLSET5 COMPANY KeyChange OE86.4
REASON-CODE
STATUS
AUTH-NO
LINE-NBR
RTLSET6 COMPANY This index was created as a solution to OE130
LINE-NBR the Find Next/Prev Flag error. It is
AUTH-NO only used where a modify must be done
within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
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-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 RTN-ORIG-INVC-PRE != Spaces
Or RTN-ORIG-INVC-NBR != Zeroes
RTL-COMPANY -> OIL-COMPANY
RTN-ORIG-INVC-PRE -> OIL-INVC-PREFIX
RTN-ORIG-INVC-NBR -> OIL-INVC-NUMBER
RTL-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 ITE-LOT-TRACK-FL = "N"
And ITL-BIN-TRACK-FL = "Y"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Lots WHSHLDTL
Valid When ITE-LOT-TRACK-FL = "Y"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-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-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 ITE-SER-TRACK-FL = "R"
Or ITE-SER-TRACK-FL = "I"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-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 ITE-MULT-UOMS > Zeroes
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
|