RETURNLINE – Return Line
- System
- OE (OE)
- Prefix
RTL- Primary key
COMPANY,AUTH-NO,LINE-NBR- Fields
- 59
- Updated by
- 1 program
- Referenced by
- 2 programs
RETURNLINE is the Return Line table in Lawson OE (prefix RTL). It is indexed by COMPANY, AUTH-NO, LINE-NBR (RTLSET1); alternate indexes: RTLSET2, RTLSET3, RTLSET4, RTLSET5 and RTLSET6. It is related 1:1 to GLMASTER, COLINE, GLSYSTEM, ICCOMPANY, ICLOCATION, ITEMLOC, ITEMMAST, OECOMPANY and 4 more and 1:M to WHSHLDTL, RETURNMISC and SOHDETAIL. It is updated by IC11.1 and referenced by BLI2.1 and WH20.7. The table has 59 fields, 6 indexes and 22 documented relations.
About RETURNLINE
The Return Line file contains the lines entered on a return.
Fields (59)
Column = COBOL field name without the RTL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
RTL-COMPANY PKCOMPANY | Numeric 4 | This field contains the company number. | — |
RTL-AUTH-NO PKAUTH_NO | Numeric 10 | This field contains the authorization number of the user who is entering the return. | — |
RTL-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | — |
RTL-CUSTOMERCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
RTL-ORDER-NBRORDER_NBR | Numeric 8 | This field contains the order number. | — |
RTL-LOCATIONLOCATION | Alpha 5 | This field contains a valid stock location within the company inventory. | — |
RTL-DATEDATE | Numeric 8 (yyyymmdd) | This field contains the system date when the return was created. | — |
RTL-ITEMITEM | Alpha 32 | This field contains the item identifier. | — |
RTL-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the item description. | — |
RTL-LINE-TYPELINE_TYPE | Alpha 1 | This field contains the type of inventory on this line.
| — |
RTL-REASON-CODEREASON_CODE | Alpha 4 | This field contains the reason code, which indicates the cause for credit memos. | — |
RTL-SHIP-TOSHIP_TO | Numeric 4 | This field contains the number representing the ship to customer. | — |
RTL-QUANTITYQUANTITY | Signed 13.4 | This field contains the return quantity in sell unit of measure. | — |
RTL-SELL-UOMSELL_UOM | Alpha 4 | This field contains the stock unit of measure for the item. If entered, it must be a valid stock unit of measure for this item. If not entered, the default stock unit of measure for this item is assigned. | — |
RTL-INVC-CW-QTYINVC_CW_QTY | Signed 13.4 | This field contains the invoice catch weight quantity. This field is valid only for catch weight items. This is used in extended price calculation, but quantity is used for pricing. | — |
RTL-INVEN-CW-QTYINVEN_CW_QTY | Signed 13.4 | This field contains the inventory catch weight quantity. This field is used only for credit memo catch weight items, if the item is returned to inventory. This is defaulted from invoice catch weight quantity. | — |
RTL-ENTERED-PRICEENTERED_PRICE | Signed 18.5 | This field contains the price of the line in original billing currency. | — |
RTL-STD-COSTSTD_COST | Signed 18.5 | This field contains the cost of the item that is being returned if the company is using standard costing. | — |
RTL-SELL-TO-STOCKSELL_TO_STOCK | Signed 13.7 | This field contains a conversion factor for converting the line amount from sell to stock unit of measure. | — |
RTL-UNIT-PRICEUNIT_PRICE | Signed 18.5 | This field contains the unit price in company base currency. | — |
RTL-BASE-PRICEBASE_PRICE | Signed 18.5 | This field contains the base price from the order. | — |
RTL-SPR-UOMSPR_UOM | Alpha 4 | This field contains the sell pricing unit of measure. | — |
RTL-SPR-TO-STOCKSPR_TO_STOCK | Signed 13.7 | This field contains the conversion factor from price to stock unit of measure. | — |
RTL-ENT-UNIT-COSTENT_UNIT_COST | Signed 18.5 | This field contains the entered unit cost for the return line. | — |
RTL-UNIT-COSTUNIT_COST | Signed 18.5 | This field contains the approved unit cost for this invoice line item in company base currency. | — |
RTL-ACTIVITYACTIVITY | Alpha 15 | This field contains the activity for the sales account. 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 Project Accounting. 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-CATEGORYACCT_CATEGORY | Alpha 5 | This field contains the account category for the sales account. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. 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 Account Assignment (AC07.1). 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-CACTIVITY_C | Alpha 15 | This field contains the activity for the Cost (COGS) account. 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 Project Accounting. 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-CACCT_CATEG_C | Alpha 5 | This field contains the account category for the Cost (COGS) account. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. 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 Account Assignment (AC07.1). 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-CATN_OBJ_ID_C | Numeric 12 | This field contains the system-defined object ID representing the Activity Management commitment for Cost (COGS). | — |
RTL-CUST-REQ-ACTCUST_REQ_ACT | Alpha 1 | This field indicates whether the customer wants a credit memo issued or replacement of goods.
| — |
RTL-RESTK-CHG-CODERESTK_CHG_CODE | Alpha 16 | This field contains the add-on charge code indicating whether you want to charge the customer for restocking. | — |
RTL-INV-DISP-CDINV_DISP_CD | Alpha 1 | This field indicates where to place returned items.
| — |
RTL-CREATE-CM-CDCREATE_CM_CD | Alpha 1 | This field indicates whether or not to create a credit memo.
| — |
RTL-DETAIL-QTYDETAIL_QTY | Signed 13.4 | This field contains the summation of all detail line quantity in stock unit of measure. | — |
RTL-SLS-ACCT-UNITSLS_ACCT_UNIT | Alpha 15 | This field contains the sales accounting unit to post to. | — |
RTL-SLS-ACCOUNTSLS_ACCOUNT | Numeric 6 | This field contains the sales account to post to. | — |
RTL-SLS-SUB-ACCTSLS_SUB_ACCT | Numeric 4 | This field contains the sales subaccount to post to. | — |
RTL-OFF-ACCT-UNITOFF_ACCT_UNIT | Alpha 15 | This field contains the COGS offset account unit to post to. | — |
RTL-OFF-ACCOUNTOFF_ACCOUNT | Numeric 6 | This field contains the COGS offset account to post to. | — |
RTL-OFF-SUB-ACCTOFF_SUB_ACCT | Numeric 4 | This field contains the COGS offset subaccount to post to. | — |
RTL-CGS-ACCT-UNITCGS_ACCT_UNIT | Alpha 15 | This field contains the COGS account unit to post to. | — |
RTL-CGS-ACCOUNTCGS_ACCOUNT | Numeric 6 | This field contains the COGS account to post to. | — |
RTL-CGS-SUB-ACCTCGS_SUB_ACCT | Numeric 4 | This field contains the COGS subaccount to post to. | — |
RTL-CV-ACCT-UNITCV_ACCT_UNIT | Alpha 15 | This field contains the cost variance accounting unit. | — |
RTL-CV-ACCOUNTCV_ACCOUNT | Numeric 6 | This field contains the cost variance account. | — |
RTL-CV-SUB-ACCTCV_SUB_ACCT | Numeric 4 | This field contains the cost variance subaccount. | — |
RTL-PO-NUMBERPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | — |
RTL-PO-CODEPO_CODE | Alpha 4 | This is the purchase order code. | — |
RTL-STATUSSTATUS | Numeric 1 | This field contains the return status.
| — |
RTL-AVERAGE-COSTAVERAGE_COST | Signed 18.5 | This field contains the cost of the item that is being returned if the company is using average costing. | — |
RTL-SOH-QTYSOH_QTY | Signed 13.4 | This field contains the desired quantity. | — |
RTL-LAST-MISC-SEQLAST_MISC_SEQ | Numeric 3 | — | — |
RTL-LAST-COMM-SEQLAST_COMM_SEQ | Numeric 3 | — | — |
RTL-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | — |
RTL-FREIGHT-TOTFREIGHT_TOT | Signed 18.2 | — | — |
RTL-INSURANCE-TOTINSURANCE_TOT | Signed 18.2 | — | — |
RTL-CSTMS-TOTCSTMS_TOT | Signed 18.2 | — | — |
RTL-OTHER-AOC-TOTOTHER_AOC_TOT | Signed 18.2 | — | — |
Indexes (6)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RTLSET1 | COMPANY, AUTH-NO, LINE-NBR | Primary | BLI2.1, IC11.1, WH20.7 | |
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, ITEM, STATUS, AUTH-NO, LINE-NBR | KeyChange | — | |
RTLSET5 | COMPANY, REASON-CODE, STATUS, AUTH-NO, LINE-NBR | KeyChange | — | |
RTLSET6 | COMPANY, LINE-NBR, AUTH-NO | — |
Relations
One to one (15) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 | |
| 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 |
One to many (7) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 | ||
| Returnmisc | RETURNMISC | RTL-COMPANY → RMC-COMPANY, RTL-AUTH-NO → RMC-AUTH-NO, RTL-LINE-NBR → RMC-LINE-NBR, RMC-SEQ | ||
| 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 |
Programs
Updated by (1)
- IC11.1 Item Master