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.

Field / column	Type	Description & values	Updated by
`RTN-COMPANY` PK COMPANY	Numeric 4	This field contains the company number.	—
`RTN-AUTH-NO` PK AUTH_NO	Numeric 10	This field contains the authorization number of the user who is entering the return.	—
`RTN-DATE` DATE	Numeric 8 (yyyymmdd)	This field contains the system date when the return was created.	—
`RTN-USER-ID` USER_ID	Alpha 10 (Lower Case)	This field contains the name of the user who entered the return.	—
`RTN-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	—
`RTN-BILL-TO` BILL_TO	Numeric 4	This field contains the bill-to customer number from the original order.	—
`RTN-SHIP-TO` SHIP_TO	Numeric 4	This field contains the number representing the ship to customer.	—
`RTN-DROPSHIP-FL` DROPSHIP_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. `Y` Yes `N` No	—
`RTN-LOCATION` LOCATION	Alpha 5	This field contains a valid stock location within the company inventory.	—
`RTN-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	This field contains the date assigned to the journal entry for posting.	—
`RTN-CUST-RET-REF` CUST_RET_REF	Alpha 10	—	—
`RTN-CUST-REQ-ACT` CUST_REQ_ACT	Alpha 1	This field indicates whether a customer wants a credit or replacement of goods on a return. `C` Credit `R` Replacement	—
`RTN-REASON-CODE` REASON_CODE	Alpha 4	This field contains the reason code, which indicates the cause for credit memos.	—
`RTN-ORIG-INVC-PRE` ORIG_INVC_PRE	Alpha 2	This field contains the prefix of the original invoice against which the return is being made.	—
`RTN-ORIG-INVC-NBR` ORIG_INVC_NBR	Numeric 8	This field contains the number of the original invoice against which the return is being made.	—
`RTN-INVC-PREFIX` INVC_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` INVC_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-NBR` ORDER_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-NBR` SHIPMENT_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-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level.	—
`RTN-INVC-TYPE` INVC_TYPE	Alpha 4	This field contains the invoice type assigned to the return. The type must be a credit memo.	—
`RTN-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company's base currency code established in General Ledger.	—
`RTN-CONTACT` CONTACT	Alpha 20	This field contains the name of the main contact.	—
`RTN-INT-PREFIX` INT_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-NMBR` PHONE_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-EXT` PHONE_EXT	Alpha 5	This field contains the contact's telephone extension number.	—
`RTN-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `0` Entered `1` Released `9` Closed	—
`RTN-LAST-SEQ` LAST_SEQ	Numeric 3	This field contains the number used to increment the line number.	—
`RTN-LAST-COMM-SEQ` LAST_COMM_SEQ	Numeric 3	This field contains the record sequence number.	—
`RTN-LAST-LINE-NBR` LAST_LINE_NBR	Numeric 6	This field contains the line number.	—
`RTN-UND-ITEM-CNT` UND_ITEM_CNT	Numeric 3	This field contains a count of items that have not been selected for return.	—
`RTN-UND-CM-CNT` UND_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-CNT` CM_CNT	Numeric 3	This field contains the number of items to be included on a credit memo.	—
`RTN-AUTO-APP-FL` AUTO_APP_FL	Alpha 1	—	—
`RTN-CREATE-CM-CD` CREATE_CM_CD	Alpha 1	—	—
`RTN-EP-TYPE` EP_TYPE	Alpha 5	—	—
`RTN-EP-ACCOUNT` EP_ACCOUNT	Alpha 32	—	—
`RTN-EP-EXP-DATE` EP_EXP_DATE	Numeric 8 (yyyymmdd)	—	—
`RTN-FREIGHT-CDE` FREIGHT_CDE	Alpha 2	—	—
`RTN-FRT-CHARGE` FRT_CHARGE	Signed 18.2	—	—
`RTN-LAST-MISC-SEQ` LAST_MISC_SEQ	Numeric 3	—	—
`RTN-LINE-TOTAL` LINE_TOTAL	Signed 18.2	—	—
`RTN-GLBL-DOC-TYPE` GLBL_DOC_TYPE	Alpha 10	—	—
`RTN-TEMP-HOLD` TEMP_HOLD	Alpha 1	—	—

Indexes (4)

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
`RTNSET1`	`COMPANY`, `AUTH-NO`	Primary		BLI2.1, WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3 +19 more
`RTNSET2`	`COMPANY`, `INVC-PREFIX`, `INVC-NUMBER`	KeyChange, Subset	Where INVC-PREFIX != Spaces Or INVC-NUMBER != Zeroes	WH20.7
`RTNSET3`	`COMPANY`, `LOCATION`, `STATUS`, `AUTH-NO`	KeyChange		—
`RTNSET4`	`COMPANY`, `CUSTOMER`, `STATUS`, `AUTH-NO`	KeyChange		—

Relations

One to one (14) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcomp	ARCOMP	Required		`RTN-COMPANY` → `ACO-COMPANY (ACOSET1)`
Arcustomer	ARCUSTOMER	Required		`RTN-COMPANY` → `ACM-COMPANY`, `RTN-CUSTOMER` → `ACM-CUSTOMER`
Billto	BILLTO	Required	When RTN-BILL-TO != Zeroes	`ACO-CUST-GROUP` → `ABS-CUST-GROUP`, `RTN-CUSTOMER` → `ABS-CUSTOMER`, `RTN-BILL-TO` → `ABS-BILL-TO`
Cucodes	CUCODES	Required	When RTN-CURRENCY-CODE != Spaces	`RTN-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Custdesc	CUSTDESC	Required		`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `RTN-CUSTOMER` → `CUD-CUSTOMER`
Custorder	CUSTORDER	Not Required		`RTN-COMPANY` → `COR-COMPANY`, `RTN-ORDER-NBR` → `COR-ORDER-NBR`
Iclocation	ICLOCATION	Required		`RTN-COMPANY` → `ICL-COMPANY`, `RTN-LOCATION` → `ICL-LOCATION`
Oecompany	OECOMPANY	Required		`RTN-COMPANY` → `OEC-COMPANY`
Oeinvctype	OEINVCTYPE	Required		`RTN-COMPANY` → `OIN-COMPANY`, `RTN-INVC-TYPE` → `OIN-INVC-TYPE`
Oeinvoice	OEINVOICE	Required	When RTN-INVC-PREFIX != Spaces Or RTN-INVC-NUMBER != Zeroes	`RTN-COMPANY` → `OEI-COMPANY`, `RTN-INVC-PREFIX` → `OEI-INVC-PREFIX`, `RTN-INVC-NUMBER` → `OEI-INVC-NUMBER`
Oeproclev	OEPROCLEV	Required		`RTN-COMPANY` → `OEP-COMPANY`, `RTN-PROCESS-LEVEL` → `OEP-PROCESS-LEVEL`
Oereason	OEREASON	Required	When RTN-REASON-CODE != Spaces	`RTN-COMPANY` → `OER-COMPANY`, `RTN-REASON-CODE` → `OER-REASON-CODE`
Orig Invoice	OEINVOICE	Required	When -ORIG-INVC-NBR != Spaces	`RTN-COMPANY` → `OEI-COMPANY`, `RTN-ORIG-INVC-PRE` → `OEI-INVC-PREFIX`, `RTN-ORIG-INVC-NBR` → `OEI-INVC-NUMBER`
Shipto	SHIPTO	Required	When -SHIP-TO != Spaces	`RTN-COMPANY` → `SHP-COMPANY`, `RTN-CUSTOMER` → `SHP-CUSTOMER`, `RTN-SHIP-TO` → `SHP-SHIP-TO`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Returnline	RETURNLINE			`RTN-COMPANY` → `RTL-COMPANY`, `RTN-AUTH-NO` → `RTL-AUTH-NO`, → `RTL-LINE-NBR`
Returnmisc	RETURNMISC			`RTN-COMPANY` → `RMC-COMPANY`, `RTN-AUTH-NO` → `RMC-AUTH-NO`, `Zeroes` → `RMC-LINE-NBR`, → `RMC-SEQ`

Programs

No Lawson programs are documented as updating or referencing this table.