RETURNHDR – Return Header
- System
- OE (OE)
- Prefix
RTN- Primary key
COMPANY,AUTH-NO- Fields
- 44
- Updated by
- 0 programs
- Referenced by
- 0 programs
RETURNHDR is the Return Header table in Lawson OE (prefix RTN). It is indexed by COMPANY, AUTH-NO (RTNSET1); alternate indexes: RTNSET2, RTNSET3 and RTNSET4. It is related 1:1 to ARCOMP, ARCUSTOMER, BILLTO, CUCODES, CUSTDESC, CUSTORDER, ICLOCATION, OECOMPANY and 5 more and 1:M to RETURNLINE and RETURNMISC. The table has 44 fields, 4 indexes and 16 documented relations.
About RETURNHDR
The Return Header file contains the return header record.
Fields (44)
Column = COBOL field name without the RTN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RTN-COMPANY PKCOMPANY | Numeric 4 | This field contains the company number. | — |
#RTN-AUTH-NO PKAUTH_NO | Numeric 10 | This field contains the authorization number of the user who is entering the return. | — |
#RTN-DATEDATE | Numeric 8 (yyyymmdd) | This field contains the system date when the return was created. | — |
#RTN-USER-IDUSER_ID | Alpha 10 (Lower Case) | This field contains the name of the user who entered the return. | — |
#RTN-CUSTOMER SET4CUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
#RTN-BILL-TOBILL_TO | Numeric 4 | This field contains the bill-to customer number from the original order. | — |
#RTN-SHIP-TOSHIP_TO | Numeric 4 | This field contains the number representing the ship to customer. | — |
#RTN-DROPSHIP-FLDROPSHIP_FL | Alpha 1 | This flag indicates whether goods being shipped by the vendor directly to a nonstandard location need to have the receiving process performed.
| — |
#RTN-LOCATION SET3LOCATION | Alpha 5 | This field contains a valid stock location within the company inventory. | — |
#RTN-POSTING-DATEPOSTING_DATE | Numeric 8 (yyyymmdd) | This field contains the date assigned to the journal entry for posting. | — |
#RTN-CUST-RET-REFCUST_RET_REF | Alpha 10 | — | — |
#RTN-CUST-REQ-ACTCUST_REQ_ACT | Alpha 1 | This field indicates whether a customer wants a credit or replacement of goods on a return.
| — |
#RTN-REASON-CODEREASON_CODE | Alpha 4 | This field contains the reason code, which indicates the cause for credit memos. | — |
#RTN-ORIG-INVC-PREORIG_INVC_PRE | Alpha 2 | This field contains the prefix of the original invoice against which the return is being made. | — |
#RTN-ORIG-INVC-NBRORIG_INVC_NBR | Numeric 8 | This field contains the number of the original invoice against which the return is being made. | — |
#RTN-INVC-PREFIX SET2INVC_PREFIX | Alpha 2 | This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen. | — |
#RTN-INVC-NUMBER SET2INVC_NUMBER | Numeric 8 | This field contains the invoice number assigned by the system. Invoice numbers are assigned at the company or process level, depending on an invoice-level option on the company file. | — |
#RTN-ORDER-NBRORDER_NBR | Numeric 8 | Each order is assigned a unique number. Order numbers are either manually or system assigned based on a company-level option. | — |
#RTN-SHIPMENT-NBRSHIPMENT_NBR | Numeric 10 | This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time. | — |
#RTN-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | This field contains the process level. | — |
#RTN-INVC-TYPEINVC_TYPE | Alpha 4 | This field contains the invoice type assigned to the return. The type must be a credit memo. | — |
#RTN-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company's base currency code established in General Ledger. | — |
#RTN-CONTACTCONTACT | Alpha 20 | This field contains the name of the main contact. | — |
#RTN-INT-PREFIXINT_PREFIX | Alpha 6 | This field contains the international telephone prefix of the contact at the customer site for which the return is being entered. | — |
#RTN-PHONE-NMBRPHONE_NMBR | Alpha 15 | This field contains the telephone number of the contact at the customer site from which the inventory is being returned. | — |
#RTN-PHONE-EXTPHONE_EXT | Alpha 5 | This field contains the contact's telephone extension number. | — |
#RTN-STATUS SET3 SET4STATUS | Numeric 1 | This field displays the status of the transaction.
| — |
#RTN-LAST-SEQLAST_SEQ | Numeric 3 | This field contains the number used to increment the line number. | — |
#RTN-LAST-COMM-SEQLAST_COMM_SEQ | Numeric 3 | This field contains the record sequence number. | — |
#RTN-LAST-LINE-NBRLAST_LINE_NBR | Numeric 6 | This field contains the line number. | — |
#RTN-UND-ITEM-CNTUND_ITEM_CNT | Numeric 3 | This field contains a count of items that have not been selected for return. | — |
#RTN-UND-CM-CNTUND_CM_CNT | Numeric 4 | This field contains a count of returns that have not selected whether or not to create a credit memo. | — |
#RTN-CM-CNTCM_CNT | Numeric 3 | This field contains the number of items to be included on a credit memo. | — |
#RTN-AUTO-APP-FLAUTO_APP_FL | Alpha 1 | — | — |
#RTN-CREATE-CM-CDCREATE_CM_CD | Alpha 1 | — | — |
#RTN-EP-TYPEEP_TYPE | Alpha 5 | — | — |
#RTN-EP-ACCOUNTEP_ACCOUNT | Alpha 32 | — | — |
#RTN-EP-EXP-DATEEP_EXP_DATE | Numeric 8 (yyyymmdd) | — | — |
#RTN-FREIGHT-CDEFREIGHT_CDE | Alpha 2 | — | — |
#RTN-FRT-CHARGEFRT_CHARGE | Signed 18.2 | — | — |
#RTN-LAST-MISC-SEQLAST_MISC_SEQ | Numeric 3 | — | — |
#RTN-LINE-TOTALLINE_TOTAL | Signed 18.2 | — | — |
#RTN-GLBL-DOC-TYPEGLBL_DOC_TYPE | Alpha 10 | — | — |
#RTN-TEMP-HOLDTEMP_HOLD | Alpha 1 | — | — |
Indexes (4)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RTNSET1 |
| Primary | BLI2.1, WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3 +19 more | |
RTNSET2 |
| KeyChange, Subset | Where INVC-PREFIX != Spaces Or INVC-NUMBER != Zeroes | WH20.7 |
RTNSET3 |
| KeyChange | — | |
RTNSET4 |
| KeyChange | — |
Relations
One to one (14) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcomp | ARCOMP | Required |
| ||||||||||
| Arcustomer | ARCUSTOMER | Required |
| ||||||||||
| Billto | BILLTO | Required | When RTN-BILL-TO != Zeroes |
| |||||||||
| Cucodes | CUCODES | Required | When RTN-CURRENCY-CODE != Spaces |
| |||||||||
| Custdesc | CUSTDESC | Required |
| ||||||||||
| Custorder | CUSTORDER | Not Required |
| ||||||||||
| Iclocation | ICLOCATION | Required |
| ||||||||||
| Oecompany | OECOMPANY | Required |
| ||||||||||
| Oeinvctype | OEINVCTYPE | Required |
| ||||||||||
| Oeinvoice | OEINVOICE | Required | When RTN-INVC-PREFIX != Spaces Or RTN-INVC-NUMBER != Zeroes |
| |||||||||
| Oeproclev | OEPROCLEV | Required |
| ||||||||||
| Oereason | OEREASON | Required | When RTN-REASON-CODE != Spaces |
| |||||||||
| Orig Invoice | OEINVOICE | Required | When -ORIG-INVC-NBR != Spaces |
| |||||||||
| Shipto | SHIPTO | Required | When -SHIP-TO != Spaces |
|
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Returnline | RETURNLINE |
| ||||||||||||||
| Returnmisc | RETURNMISC |
|
Programs
No Lawson programs are documented as updating or referencing this table.