RETURNHDR FILE
Return Header
The Return Header file contains the return header record.
REFERENCED BY
BL199 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
OE962 OE990 WH991
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTN-COMPANY Numeric 4 OE30.1 OE30.2
Company This field contains the company number. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OE962
RTN-AUTH-NO Numeric 10 OE30.1 OE30.2
Authorization Number This field contains the authorization OE30.3 OE30.4
number of the user who is entering the OE30.5 OE30.6
return. OE30.7 OE30.9
OE830 OE950
OE962
RTN-DATE Numeric 8 (yyyymmdd) OE30.1 OE30.2
Date This field contains the system date OE30.3 OE30.4
when the return was created. OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OE962
RTN-USER-ID Alpha 10 (Lower Case) OE530 OE962
User ID This field contains the name of the
user who entered the return.
RTN-CUSTOMER Alpha 9 (Right Justified) OE30.1 OE30.2
Customer This field contains the number that OE30.3 OE30.4
represents a customer. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-BILL-TO Numeric 4 OE530 OE962
Bill-to This field contains the bill-to
customer number from the original order.
RTN-SHIP-TO Numeric 4 OE30.1 OE30.2
Ship-to This field contains the number OE30.3 OE30.4
representing the ship-to customer. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-DROPSHIP-FL Alpha 1 OE530 OE962
Dropship Flag 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 Alpha 5 OE30.1 OE30.2
Location This field contains a valid stock OE30.3 OE30.4
location within the company inventory. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-POSTING-DATE Numeric 8 (yyyymmdd) OE130 OE30.1
Posting Date This field contains the date assigned OE30.2 OE30.3
to the journal entry for posting. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830 OE950
OE962
RTN-CUST-REQ-ACT Alpha 1 OE530 OE962
Credit or This field indicates whether a customer
Replacement of Goods wants a credit or replacement of goods
on a return.
C = Credit
R = Replacement
RTN-REASON-CODE Alpha 4 OE530 OE990
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
RTN-ORIG-INVC-PRE Alpha 2 OE30.1 OE30.2
Original Invoice This field contains the prefix of the OE30.3 OE30.4
Pretax original invoice against which the OE30.5 OE30.6
return is being made. OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-ORIG-INVC-NBR Numeric 8 OE30.1 OE30.2
Original Invoice This field contains the number of the OE30.3 OE30.4
Number original invoice against which the OE30.5 OE30.6
return is being made. OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-INVC-PREFIX Alpha 2 OE30.1 OE30.2
Invoice Prefix This field contains the invoice prefix OE30.3 OE30.4
that is assigned from either the company OE30.5 OE30.6
or process level, depending on the OE30.7 OE30.9
invoice-level option chosen. OE830 OE950
OE962
RTN-INVC-NUMBER Numeric 8 OE30.1 OE30.2
Invoice Number This field contains the invoice number OE30.3 OE30.4
assigned by the system. Invoice numbers OE30.5 OE30.6
are assigned at the company or process OE30.7 OE30.9
level, depending on an invoice-level OE830 OE950
option on the company file. OE962
RTN-ORDER-NBR Numeric 8 OE30.1 OE30.2
Order Number Each order is assigned a unique number. OE30.3 OE30.4
Order numbers are either manually or OE30.5 OE30.6
system assigned based on a company-level OE30.7 OE30.9
option. OE530 OE830
OE950 OE962
RTN-SHIPMENT-NBR Numeric 10 OE30.1 OE30.2
Shipment Number This field contains the shipment OE30.3 OE30.4
number. One order can have several OE30.5 OE30.6
shipment numbers if the items of the OE30.7 OE30.9
order were not shipped at the same time. OE530 OE830
OE950 OE962
WH991
RTN-PROCESS-LEVEL Alpha 5 OE30.1 OE30.2
Process Level This field contains the process level. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-INVC-TYPE Alpha 4 OE30.1 OE30.2
Invoice Type This field contains the invoice type OE30.3 OE30.4
assigned to the return. The type must OE30.5 OE30.6
be a credit memo. OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-CURRENCY-CODE Alpha 5 OE30.1 OE30.2
Currency Code This field contains the company's base OE30.3 OE30.4
currency code established in the Lawson OE30.5 OE30.6
General Ledger system. OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-CONTACT Alpha 20 OE30.1 OE30.2
Contact This field contains the name of the OE30.3 OE30.4
main contact. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-INT-PREFIX Alpha 6 OE30.1 OE30.2
International Prefix This field contains the international OE30.3 OE30.4
telephone prefix of the contact at the OE30.5 OE30.6
customer site for which the return is OE30.7 OE30.9
being entered. OE530 OE830
OE950 OE962
RTN-PHONE-NMBR Alpha 15 OE30.1 OE30.2
Phone Number This field contains the telephone OE30.3 OE30.4
number of the contact at the customer OE30.5 OE30.6
site from which the inventory is being OE30.7 OE30.9
returned. OE530 OE830
OE950 OE962
RTN-PHONE-EXT Alpha 5 OE30.1 OE30.2
Phone Extension This field contains the contact's OE30.3 OE30.4
telephone extension number. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-RESTK-CHG-CODE Alpha 16 OE530 OE962
Restock Charge Code This field contains the add-on charge
code indicating whether you want to
charge customers for restocking.
RTN-STATUS Numeric 1 OE130 OE30.1
Status This field contains the status of the OE30.2 OE30.3
transaction. OE30.4 OE30.5
0 = Entered OE30.6 OE30.7
1 = Released OE30.9 OE530
2 = Authorized OE830 OE950
9 = Closed OE962
RTN-LAST-SEQ Numeric 3 OE30.1 OE30.2
Last Sequence This field contains the number used to OE30.3 OE30.4
increment the line number. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-LAST-COMM-SEQ Numeric 3 OE530 OE962
Record Sequence This is the sequence number of the last
Number comment line entered for this
requisition line.
RTN-LAST-LINE-NBR Numeric 6 OE530 OE962
Last Line Number This field contains the number of the
last line item added to the requisition.
It is used to determine the number when
the next line is added to the
requisition.
RTN-UND-ITEM-CNT Numeric 3 OE30.1 OE30.2
Item Count This field contains a count of items OE30.3 OE30.4
that have not been selected for return. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-UND-CM-CNT Numeric 4 OE30.1 OE30.2
Credit Memo Count This field contains a count of returns OE30.3 OE30.4
that have not selected whether or not to OE30.5 OE30.6
create a credit memo. OE30.7 OE30.9
OE530 OE830
OE950 OE962
RTN-CM-CNT Numeric 3 OE30.1 OE30.2
Comment Count This field contains a count of comments. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OE950 OE962
RETURNHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTNSET1 COMPANY BL199 OE130
AUTH-NO OE230 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE330
OE530 OE830
OE85.1 OE950
OE962 OE990
WH991
RTNSET2 COMPANY Subset SA100
INVC-PREFIX Where INVC-PREFIX != Spaces
INVC-NUMBER Or INVC-NUMBER != Zeroes
RETURNHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
RTN-COMPANY -> ACO-COMPANY
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
Oemisc OEMISC Required
When RTN-RESTK-CHG-CODE != Spaces
RTN-COMPANY -> OEM-COMPANY
RTN-RESTK-CHG-CODE -> OEM-MISC
RTN-CURRENCY-CODE -> OEM-CURRENCY-CODE
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 RTN-ORIG-INVC-NBR != Zeroes
RTN-COMPANY -> OEI-COMPANY
RTN-ORIG-INVC-PRE -> OEI-INVC-PREFIX
RTN-ORIG-INVC-NBR -> OEI-INVC-NUMBER
Returnsgbk RETURNSGBK Not Required
RTN-COMPANY -> RSB-COMPANY
RTN-AUTH-NO -> RSB-AUTH-NO
Zeroes -> RSB-LINE-NBR
Shipto SHIPTO Required
When RTN-SHIP-TO != Zeroes
RTN-COMPANY -> SHP-COMPANY
RTN-CUSTOMER -> SHP-CUSTOMER
RTN-SHIP-TO -> SHP-SHIP-TO
RETURNHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Returncomm RETURNCOMM
RTN-COMPANY -> RTC-COMPANY
RTN-AUTH-NO -> RTC-AUTH-NO
Zeroes -> RTC-LINE-NBR
RTC-SEQ
Returnline RETURNLINE
RTN-COMPANY -> RTL-COMPANY
RTN-AUTH-NO -> RTL-AUTH-NO
RTL-LINE-NBR
|